Bug#390173: Someone needs to try to reproduce this

[Ansgar Burchardt]

Hi,

Keith Lawson <keith at nowhere.ca> writes:
> MySQL won't even let me create the situation described. While it will
> allow for NULL or 0 in a primary key field it only allows for one of
> them:
[...]
> mysql> insert into test_table (pkey,text) values ('null','test no
> key');
> ERROR 1062 (23000): Duplicate entry '0' for key 'PRIMARY'

It's interesting that MySQL believes the string 'null' to be an integer,
but I suppose you should try without the quotes.

Regards,
Ansgar