Re: UNIQUE with NULL columns

2001-03-07 Thread Rimantas Liubertas
Hello john, Thursday, March 08, 2001, 12:19:22 AM, you wrote: jrd> with MySQL 3.23.33 on Linux, shouldn't UNIQUE columns that contain NULL jrd> values still reject rows that are the same? this isn't working (it allows jrd> duplicate rows to be included if one of the columns is NULL). this seem

UNIQUE with NULL columns

2001-03-07 Thread john r. durand
with MySQL 3.23.33 on Linux, shouldn't UNIQUE columns that contain NULL values still reject rows that are the same? this isn't working (it allows duplicate rows to be included if one of the columns is NULL). this seems wrong. here's an example: mysql> create table n ( i