]> git.ipfire.org Git - thirdparty/sqlite.git/commit
projects / thirdparty / sqlite.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: e24a6f5) | patch
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
tree8e2dca4ab22a63358d11da85a74b7fad732c0aadtree | snapshot
parente24a6f58ae24670446f386578e63962633e8d4a6commit | diff
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 diff | blob | blame | history
manifest.uuid diff | blob | blame | history
src/select.c diff | blob | blame | history
test/offset1.test diff | blob | blame | history
Mirror of https://github.com/sqlite/sqlite.git