# some mysql issues 2 rc6

**URL:** <https://forum.liquibase.org/t/some-mysql-issues-2-rc6/871>\
**Category:** General Discussion\
**Created:** [October 18, 2010, 10:59am UTC](https://forum.liquibase.org/t/some-mysql-issues-2-rc6/871 "2010-10-18T10:59:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![grdmitro](https://avatars.discourse-cdn.com/v4/letter/g/ce7236/32.png) [@grdmitro](https://forum.liquibase.org/u/grdmitro)\
**Post date:** [October 18, 2010, 10:59am UTC](https://forum.liquibase.org/t/some-mysql-issues-2-rc6/871/1 "2010-10-18T10:59:00Z")

</div>

1. enums  
generateChangeLog gives unquoted string in defaultValue:  
\<column defaultValue=“Off” name=“toggledOn” type=“enum(‘On’,‘Off’)”\>  
which causes syntax err during update, should be  

2. composite indexes  
generateChangeLog does not preserve column order is composite indexes  
columns go in alphabetical order

thanks

---

<div class="post-metadata">

**Author:** ![nvoxland](https://avatars.discourse-cdn.com/v4/letter/n/87869e/32.png) [@nvoxland](https://forum.liquibase.org/u/nvoxland)\
**Post date:** [October 18, 2010, 10:59am UTC](https://forum.liquibase.org/t/some-mysql-issues-2-rc6/871/2 "2010-10-18T10:59:00Z")

</div>

Thanks, I created [http://liquibase.jira.com/browse/CORE-755](http://liquibase.jira.com/browse/CORE-755) to track them.&nbsp; I don’t believe either were handled correctly in 1.9, and unfortunately I had to push the generateChangeLog improvements to 2.1 in order to get 2.0 out ever.

Nathan
