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 that NULL1 == NULL2 is TRUE in UNION and DISTINCT contices. >
Thanks, ingo _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users