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.
Create new ticket
Create your profile
Help contribute to this project by taking a few moments to create your personal profile. Create your profile »
Justin Bozonier