While rebuilding TPC-DS on Snowflake from Schemity's own SQL, the copy accepted a row the original refuses, and gave it key 1.
Snowflake records primary keys but does not enforce them. It enforces NOT NULL. TPC-DS's surrogate keys come with the data being loaded, so the original refuses a CALL_CENTER row without one, error 100072.
Schemity had guessed AUTOINCREMENT for every single-column whole-number key. On the copy, the missing key quietly became 1, and the next load's real key 1 would duplicate it. Snowflake would not refuse that either.
Schemity now records that a column has no identity, and writes none.
commit ef904f8
