INSERT INTO `test` (`id`, `value`) VALUES (NULL, NULL);

1 row inserted.

INSERT INTO `test` (`id`, `value`) VALUES (NULL, '123')

#1062 - Duplicate entry '123' for key 'value'

Even in clear MySQL. Unique. No problem.