Re: [sqlite] Duplicate records (null handling)
On 6/17/06, David M. Cook <[EMAIL PROTECTED]> wrote: I took it to mean NULL is distinct from any other value, not that each NULL is distinct from any other NULL. I believe it means that NULL is distinct even with itself. In other words, I believe NULL == NULL is false.
Re: [sqlite] Duplicate records (null handling)
On Sat, Jun 17, 2006 at 10:16:47AM -0700, Will Leshner wrote: > But if NULL is distinct for UNIQUE columns, isn't that the result you > would expect? I took it to mean NULL is distinct from any other value, not that each NULL is distinct from any other NULL. Why would one want NULL to behave this way? Dave Cook
Re: [sqlite] Duplicate records (null handling)
On 6/17/06, David M. Cook <[EMAIL PROTECTED]> wrote: says that nulls are distinct in a column, but I haven't found that to be the case (this is a test with 3.3.5) create table foo (bar text, baz text, unique(bar, baz)); select * from foo; bar|baz quux|null quux|null quux|null But if NULL is distinct for UNIQUE columns, isn't that the result you would expect?