Failures on migration with change_column, remove_column on jdbcsqlite3
----------------------------------------------------------------------
Key: JRUBY-2685
URL: http://jira.codehaus.org/browse/JRUBY-2685
Project: JRuby
Issue Type: Bug
Components: ActiveRecord-JDBC
Affects Versions: JRuby 1.1.2
Environment: KUbuntu 8.04
java version "1.6.0"
OpenJDK Runtime Environment (build 1.6.0-b09)
OpenJDK 64-Bit Server VM (build 1.6.0-b09, mixed mode)
Reporter: Ben Hughes
Priority: Critical
When running a migration like:
change_column :flights, :flight_date, :string
I get the error:
ActiveRecord::StatementInvalid: ActiveRecord::ActiveRecordError: near
"ALTER": syntax error: ALTER TABLE flights ALTER COLUMN flight_date text(0)
When I try to hack around it by migrating like:
remove_column :flights, :flight_date
add_column :flights, :flight_date, :string
I get:
ActiveRecord::StatementInvalid: ActiveRecord::ActiveRecordError: duplicate
column name: flight_date: ALTER TABLE flights ADD flight_date text(10)
Queerer still, this behavior spans across migrations (if I drop a column in one
and try to add a new column with the same name I still get the duplicate), so
it kind of breaks the whole migrations mechanism.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe from this list, please visit:
http://xircles.codehaus.org/manage_email
