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