Thanks for the update. That is correct, NULLs in MySQL/Singlestore don’t trigger unique key errors. This is a source of some confusion as different databases have different behaviors - though I believe our behavior is ANSI standard.
-Adam
Thanks for the update. That is correct, NULLs in MySQL/Singlestore don’t trigger unique key errors. This is a source of some confusion as different databases have different behaviors - though I believe our behavior is ANSI standard.
-Adam