]> git.ipfire.org Git - thirdparty/sqlite.git/commit
projects / thirdparty / sqlite.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 71dc5f8) | patch
Fix a problem with the query optimizer for LIMIT/OFFSET queries when
authordrh <>
Thu, 4 Aug 2022 17:17:41 +0000 (17:17 +0000)
committerdrh <>
Thu, 4 Aug 2022 17:17:41 +0000 (17:17 +0000)
commit0b316cb36d659e4b73b5e23ca9950f4232b7b2dd
treef0e2be0690034b740fbd862fbc1c9acd6c7e4f70tree | snapshot
parent71dc5f83f4fcadbbd2351edec3ddccd5a7993609commit | 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: 5e1db87cfa262deb85447c1e0bc0412bcebec2ee5503b01f309c61c548a7f32c
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