SQLite3::SQLException: cannot drop UNIQUE column: ...

[dentarg]

Am I doing something wrong or is this not supported in Sequel?

# migrations/01_pages.rb
Sequel.migration do
  change do
    create_table(:pages) do
      primary_key :id
      String :title
      Text :content
    end
  end
end

# migrations/02_alter_pages.rb
Sequel.migration do
  change do
    alter_table(:pages) do
      add_column :shorthand_title, String, unique: true
    end
  end
end

$ bundle exec sequel --migrate-directory migrations sqlite://test.db

$ bundle exec sequel --migrate-version 0 --migrate-directory migrations sqlite://test.db
Error: Sequel::DatabaseError: SQLite3::SQLException: cannot drop UNIQUE column: "shorthand_title"
/Users/dentarg/.arm64_rubies/3.2.4/lib/ruby/gems/3.2.0/gems/sqlite3-2.0.2-arm64-darwin/lib/sqlite3/statement.rb:36:in `prepare'

[dentarg]

From https://stackoverflow.com/a/9935824/525616 it sounds like Sequel could do the rename/add/drop column for me :)

[jeremyevans]

On SQLite 3.35.0+, Sequel issues DROP COLUMN directly, but looks like that doesn't work if the column is unique (on older versions, it does the whole temporary table hack). It may be possible to fix this if there is a way to detect the column being dropped is unique. I'll look into this.

[jeremyevans]

Should be fixed by 7b748b5

[dentarg]

Thanks, works perfectly 👌