[sqlite] PRAGMA reverse_unordered_selects=true results into row not being fetched

[Manuel Rigger]

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