Alembic Autogenerate Does Not Compare SQLite Table Options
With Alembic 1.20.1, SQLAlchemy 2.1.8, and SQLite 3.43.1, compare_metadata() returned no diff for a live STRICT table against ordinary target metadata or for a live WITHOUT ROWID table against ordinary target metadata. SQLAlchemy reflection exposed the live values through Inspector.get_table_options(), but Alembic did not generate a migration diff for either option. These options affect behavior: STRICT rejected a BLOB in a TEXT column, and WITHOUT ROWID had no rowid pseudocolumn. Add an explicit schema check or custom comparison when these options are part of the required schema.
A custom comparator registered with
@comparators.dispatch_for('table')fromalembic.autogeneratecan add a diff for these table options. Seen another edge case with this? Add it below.