rename_column sql syntax is incorrect

[cgunnels]

please see http://dev.mysql.com/doc/refman/5.1/en/alter-table.html

dm-migrations / lib / dm-migrations / sql / table_modifier.rb

you need to change the sql syntax to look like this:
"ALTER TABLE #{quoted_table_name} CHANGE #{quote_column_name(name)} #{quote_column_name(new_name)}"

According to the docs this is correct syntax, also try running the current syntax via a ui or command line and you will get an error.

[cgunnels]

This is using the mysql adapter.

[stephankaag]

+1

[postmodern]

+1

We need to add an MySQL adapter specific method for this, similar to change_column_type_statement. I might try to fix this.

[jgr]

Looks like this was fixed in b408d64 and 9eb1f5b.