An Alembic test named "test_variant_no_issue" in AutogenerateVariantCompareTest
is failing when run against CockroachDB. It looks like the test is trying to confirm that if you give it an empty upgrade
uo = ops.UpgradeOps(ops=[])
and retrieve the net effect
autogenerate._produce_net_changes(self.autogen_context, uo)
that it should be empty
diffs = uo.as_diffs()
eq_(diffs, [])
However what I'm getting is
AssertionError: [[('modify_type', None, 'sometable', 'id', {'existing_nullable': False, 'existing_server_default': DefaultClause(<sqlalchemy.sql.elements.TextClause object at 0x7fd7749c6c10>, for_update=False), 'existing_comment': None}, INTEGER(), Variant())]] != []
[[('modify_type',
None,
'sometable',
'id',
{'existing_comment': None,
'existing_nullable': False,
'existing_server_default': DefaultClause(<sqlalchemy.sql.elements.TextClause object at 0x7fd7749c6c10>, for_update=False)},
INTEGER(),
Variant())]] != []
What's not clear is the significance of the `.with_variant(Integer, "sqlite")` in the column definition. The test itself is not restricted to sqlite, and it does pass for postgresql, so I'm not quite sure if this is something that I should be concerned with.