Is this the right behavior?
CREATE TABLE t1(x INTEGER NOT NULL, y INTEGER);
INSERT INTO t1(x, y) VALUES (1, 0);
INSERT INTO t1(x, y) VALUES (2, 1);
INSERT INTO t1(x, y) VALUES (3, NULL);
sqlite> SELECT * FROM t1 A NATURAL JOIN t1 B;
1|0
2|1
I sense this could be right, but anyway... why isn't the null-row added to the
result?
Sure, NULL != NULL, but in this case it's the very same value in the database.
Please enlighten me!
Thanks
_________________________________________________________________
Hitta kärleken nu i vår!
http://dejting.se.msn.com/channel/index.aspx?trackingid=1002952
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
