Re: [sqlite] [EXTERNAL] 'where ... isnull' in create index

On 5-6-2019 09:38, Hick Gunter wrote: > NULL is considered different from any other value, including another NULL, in > the context of UNIQUE. > > So your unique index has 2 entries (1, NULL1) for rowid 1 and (1, NULL2) for > rowid2. > > See https://sqlite.org/nulls.html > > It also states

Re: [sqlite] [EXTERNAL] 'where ... isnull' in create index

. -Ursprüngliche Nachricht- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von ingo Gesendet: Mittwoch, 05. Juni 2019 09:28 An: sqlite-users@mailinglists.sqlite.org Betreff: [EXTERNAL] [sqlite] 'where ... isnull' in create index For the second insert