rowland/activerecord-fb-adapter

migration issue with default bool columns : change_column :test, :is_test, :boolean, default: true

Closed this issue · 1 comments

  • change_column(:test, :is_test, :boolean, {:default=>true})

Fb::Error: Invalid token
Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 80
DEFAULT
: ALTER TABLE "TEST" ALTER COLUMN "IS_TEST" TYPE BOOLEAN DEFAULT 1

I'm afraid that's a limitation of Firebird. It seems you'll need both change_column() and change_column_default() to complete your migration.