SQLite

In a UNION ALL query with a LIMIT and OFFSET, if the OFFSET is greater than or equal to the number of rows in the first SELECT, then the LIMIT is disabled. For example, the following SQL outputs 5 rows instead of just 1:

CREATE TABLE t1(x);
INSERT INTO t1 VALUES('a');
INSERT INTO t1 VALUES('b');
INSERT INTO t1 VALUES('c');
INSERT INTO t1 VALUES('d');
INSERT INTO t1 VALUES('e');
SELECT * FROM (SELECT x, rowid FROM t1)
UNION ALL
SELECT * FROM (SELECT rowid, x FROM t1 ORDER BY x)
LIMIT 1 OFFSET 5;

But if the OFFSET is changed to 4, then the query correctly outputs just a single row.

This problem appears to have existed as far back as 3.5.1 (circa 2007).