Hi, I discovered another bug that is triggered when "PRAGMA reverse_unordered_selects=true" is used. It's similar to a previous bug that I reported [1], but the statement triggering the bug has a compound expression that should always be true (for values that are not NULL) in the WHERE clause:
CREATE TABLE t0(c0 INTEGER PRIMARY KEY); INSERT INTO t0(c0) VALUES (1); PRAGMA reverse_unordered_selects=true; SELECT * FROM t0 WHERE ((t0.c0 > 'a') OR (t0.c0 <= 'a')); -- fetches no row SELECT ((t0.c0 > 'a') OR (t0.c0 <= 'a')) FROM t0; -- returns 1 Best, Manuel [1] https://www.sqlite.org/src/tktview?name=9cf6c9bb51 _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
