Am I misunderstanding how Unique Keys in a Sharded (columnstore) table should work?

[hanson]

Yes. If there are NULL values in a record that are part of the unique key, a duplicate key error will not be generated. This follows the SQL standard.

Behavior Change Due to Unique Key Null Handling Bug Fix in 7.0

In MemSQL 6.8 and earlier, the code incorrectly handles NULL values in unique key columns for the case of a composite unique key, only in the case that the first column’s data type is defined to be NOT NULL but another column’s type is defined to be NULL. In MemSQL 7.0 we found this bug and fixed it, changing the behavior to follow the SQL standard [SQL13]. Application software should not rely on the old behavior present in MemSQL 6.8 when upgrading to 7.0 or later. To avoid confusion, MemSQL …