I'm not sure this isn't a Rails 2.3 bug, though...
== 3 RenameBehaviorColumn: migrating ==========================================
-- rename_column(:pages, :behavior, :behavior_id)
rake aborted!
ActiveRecord::ActiveRecordError: near "ALTER": syntax error: ALTER TABLE pages ALTER COLUMN behavior RENAME TO behavior_id
Description
Ran into this trying to follow Radiant setup instructions on sqlite3 here: http://radiantcms.org/download/
I'm not sure this isn't a Rails 2.3 bug, though...
== 3 RenameBehaviorColumn: migrating ==========================================
-- rename_column(:pages, :behavior, :behavior_id)
rake aborted!
ActiveRecord::ActiveRecordError: near "ALTER": syntax error: ALTER TABLE pages ALTER COLUMN behavior RENAME TO behavior_id
bbrowning added a comment - 12/Aug/09 01:43 AM - edited
SQLite3 doesn't allow you to rename columns via the ALTER TABLE statement. Instead, you have to move the existing table to a temporary table, create a new table with the new column name, and copy the data into the new table.
Bug
Resolved
Major
sqlite3 alter table error while installing Radiant CMS
SQLite3 doesn't allow you to rename columns via the ALTER TABLE statement. Instead, you have to move the existing table to a temporary table, create a new table with the new column name, and copy the data into the new table.
Tracing activerecord's sqlite rename_column method provides the details:
http://github.com/rails/rails/blob/0a558b36eb3858ceeb926ada1388b0bd41da11f7/activerecord/lib/active_record/connection_adapters/sqlite_adapter.rb#L306-311
activerecord-jdbc's sqlite adapter needs to be updated to do this instead of executing an ALTER TABLE statement.