不，根据 SQL-99 规范，MySQL 正在做正确的事情.

No, MySQL is doing the right thing, according to the SQL-99 specification.

https://mariadb.com/kb/en/sql-99/constraint_type-unique-constraint/

唯一约束使得不可能提交任何操作将导致唯一键包含任何非空重复值.(允许多个空值，因为空值永远不相等任何东西，甚至是另一个空值.)

A UNIQUE Constraint makes it impossible to COMMIT any operation that would cause the unique key to contain any non-null duplicate values. (Multiple null values are allowed, since the null value is never equal to anything, even another null value.)

如果您使用 UNIQUE 约束但不希望多行具有 NULL，请将列声明为 NOT NULL 并禁止 任何 行具有 NULL.

If you use a UNIQUE constraint but don't want multiple rows with NULL, declare the columns as NOT NULL and prohibit any row from having NULL.