]> git.ipfire.org Git - thirdparty/sqlite.git/commit
Fix a problem with the query optimizer for LIMIT/OFFSET queries when
authordrh <>
Thu, 4 Aug 2022 17:15:00 +0000 (17:15 +0000)
committerdrh <>
Thu, 4 Aug 2022 17:15:00 +0000 (17:15 +0000)
commitbffd5c1ece80bcf04512b2965d06bc89aaab7ba8
tree8e2dca4ab22a63358d11da85a74b7fad732c0aad
parente24a6f58ae24670446f386578e63962633e8d4a6
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:/forumpost/6b5e9188f0657616|forum post 6b5e9188f0657616].  The
problem was introduced in 2015 (SQLite version 3.9.0) by check-in
[4b631364354068af].  See also ticket [b65cb2c8d91f6685].

FossilOrigin-Name: 6c806f64bbc9e98891bad0868575ee2ec5d0951ceb0c71d3ed417b45d5f27561
manifest
manifest.uuid
src/select.c
test/offset1.test