> Op 9 mei 2019, om 00:07 heeft Manuel Rigger <rigger.man...@gmail.com> het > volgende geschreven: > 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
Hi Mauel, This appears to have been fixed with the previous bug that you referred to. The example in the referred ticket is even more simple: CREATE TABLE t14(x INTEGER PRIMARY KEY); INSERT INTO t14(x) VALUES (100); SELECT * FROM t14 WHERE x < 'a' ORDER BY rowid ASC; SELECT * FROM t14 WHERE x < 'a' ORDER BY rowid DESC; Hope I'm not mistaken, E. Pasma _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
