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