Re: [sqlite] Unique Index not working properly

On Fri, May 25, 2007 at 09:16:25 +0300, Cariotoglou Mike wrote: > > > Seems that there is a problem on unique key fields when null > > > values are allowed > > > > > > CREATE TABLE z ( > > > id VARCHAR(32) NOT NULL, > > > f1 VARCHAR(32) NOT NULL, > > > f2 VARCHAR(20), > > > PRIMARY KEY (id)

[sqlite] Unique Index not working properly

> > Seems that there is a problem on unique key fields when null > > values are allowed > > > > CREATE TABLE z ( > > id VARCHAR(32) NOT NULL, > > f1 VARCHAR(32) NOT NULL, > > f2 VARCHAR(20), > > PRIMARY KEY (id) > > ); > > CREATE UNIQUE INDEX z_I1 ON z (f1, f2) > > > > insert into z values