#1485 new
Justin Bozonier

Manual MySQL Migration using change_column errors

Reported by Justin Bozonier | February 9th, 2011 @ 10:46 PM

Receive the following error while trying to change a table's column data type:
ALTER TABLE people ALTER COLUMN name TYPE String ~ You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE String' at line 1 (code: 1064, sql state: 42000, query: ALTER TABLE people ALTER COLUMN name TYPE String, uri: mysql://root:@127.0.0.1datamapper_test) rake aborted!
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE String' at line 1
/Users/Justin/Dropbox/Business/datamapper/playground/rakefile.rb:41:in block (2 levels) in <top (required)>' (See full trace by running task with --trace)

Per http://dev.mysql.com/doc/refman/5.5/en/alter-table.html there is alter, modify, and change and dm-do-adapter makes no differentiation.

dm-core 1.0.2, MySQL 5.5

Rake repro:
https://gist.github.com/819960

No comments found

Please Sign in or create a free account to add a new ticket.

With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.

New-ticket Create new ticket

Create your profile

Help contribute to this project by taking a few moments to create your personal profile. Create your profile »

People watching this ticket

Pages