2 Commits

Author	SHA1	Message	Date
drh	0b316cb36d	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	2022-08-04 17:17:41 +00:00
drh	9f1ef45f6a	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]. FossilOrigin-Name: 4b631364354068af95a01630469cb6fbfe8b52fd	2015-10-06 17:27:18 +00:00