SQLite

This table setup and query, -- From test/exists2.test CREATE TABLE t3(a TEXT PRIMARY KEY, b TEXT, x INT) WITHOUT ROWID; CREATE TABLE t4(c TEXT COLLATE nocase, y INT); INSERT INTO t3 VALUES('one', 'i', 1); INSERT INTO t3 VALUES('two', 'ii', 2); INSERT INTO t3 VALUES('three', 'iii', 3); INSERT INTO t3 VALUES('four', 'iv', 4); INSERT INTO t3 VALUES('five', 'v', 5); INSERT INTO t4 VALUES('FIVE',5), ('four',4), ('TWO',2), ('one',1); -- new test case: SELECT a FROM t3 WHERE EXISTS (SELECT 1 FROM t4 WHERE (a,x)=(c,y) LIMIT 1); returns nothing when, without the limit clause, it returns more (as it should.)

Reported via email by Marco Bonardo mbonardo@mozilla.com Date: Mon, 29 Mar 2021 22:00:52 +0200