]> 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:17:41 +0000 (17:17 +0000)
committerdrh <>
Thu, 4 Aug 2022 17:17:41 +0000 (17:17 +0000)
commit0b316cb36d659e4b73b5e23ca9950f4232b7b2dd
treef0e2be0690034b740fbd862fbc1c9acd6c7e4f70
parent71dc5f83f4fcadbbd2351edec3ddccd5a7993609
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
manifest.uuid
src/select.c
test/offset1.test