I have an issue where I run create_all, and then run alembic to detect changes (there should be none). Because the schema is ignored on the metadata-based FK, but preserved on the reflected FK, I get the following (i added a debug line in the sig check routine):
removed sig: ('tests', 'test', ('image_id',), 'test_schema', 'images', ('id',), None, None, 'not deferrable')
INFO:alembic.autogenerate.compare:Detected removed foreign key (image_id)(id) on table tests.test
added sig: ('tests', 'test', ('image_id',), None, 'images', ('id',), None, None, 'not deferrable')
INFO:alembic.autogenerate.compare:Detected added foreign key (logo_image_id)(id) on table whitelabels.whitelabel
Do I have something configured incorrectly? Is there something I can change to ensure the default schema is used when doing FK comparisons against tables in the default schema? The table in question does not have a hard-coded schema, so table.schema returns None.