SQLite

All files named ”test/offset1.test”
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

History for test/offset1.test

2022-08-04
17:15
[72cca52482] part of check-in [6c806f64bb] Fix a problem with the query optimizer for LIMIT/OFFSET queries when underlying query is a UNION ALL and both arms of the UNION ALL are subqueries with an ORDER BY clause. This bug was reported at forum post 6b5e9188f0657616. The problem was introduced in 2015 (SQLite version 3.9.0) by check-in [4b631364354068af]. See also ticket [b65cb2c8d91f6685]. (check-in: [6c806f64bb] user: drh branch: trunk, size: 5154)
2015-10-06
17:27
Added: [f06b83657b] part of check-in [4b63136435] Fix the LIMIT and OFFSET handling for UNION ALL queries that contain a subquery with ORDER BY on the right-hand side. Fix for ticket [b65cb2c8d91f668584]. (check-in: [4b63136435] user: drh branch: trunk, size: 4049)