Hi everyone,
I discovered what I think is a bug, as demonstrated below:
CREATE TABLE t0(c0);
CREATE TABLE t1(c0 INTEGER PRIMARY KEY);
PRAGMA reverse_unordered_selects=true;
INSERT INTO t1(c0) VALUES (0);
INSERT INTO t0(c0) VALUES ('a');
SELECT * FROM t1, t0 WHERE t1.c0 < t0.c0;
I would expect (0, 'a') to be fetched, which is not the case. The
comparison should be true, as demonstrated by this query:
SELECT t1.c0 < t0.c0 FROM t1, t0; -- 1
The bug is only triggered when setting the PRAGMA and when c0 is an INTEGER
PRIMARY KEY.
Best,
Manuel
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
