/ All files named "test/limit2.test"
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

History for test/limit2.test

2018-09-08
20:09
[9409b033] part of check-in [20672012] Fix multiple issues with the ORDER BY LIMIT optimization. This is the proposed resolution to ticket [9936b2fa443fec03ff25]. (check-in: [20672012] user: drh branch: trunk, size: 7737)
2017-12-13
18:01
[36098280] part of check-in [65754dc3] Correctly invalidate a column cache line when it is overwritten with NULL. Fix for ticket [123c9ba32130a6c9d432]. (check-in: [65754dc3] user: drh branch: trunk, size: 6069)
2016-10-12
14:48
[e35f57bd] part of check-in [8e2b25f9] Fix a problem affecting queries that match the pattern (... WHERE ipk IN (....) ORDER BY ? LIMIT ?). Fix for [96c1454c]. (check-in: [8e2b25f9] user: dan branch: trunk, size: 5422)
2016-09-23
18:06
[7e7744cc] part of check-in [0c3cafb7] Fix the ORDER BY LIMIT optimization backport so that it works when the ORDER BY uses the DESC direction. (check-in: [0c3cafb7] user: drh branch: branch-3.8.9, size: 4473)
2016-09-07
01:51
[ac97b8d0] part of check-in [820644b8] The ORDER BY LIMIT optimization is not valid unless the inner-most IN operator loop is actually used by the query plan. Fix for ticket [0c4df46116e90f92]. (check-in: [820644b8] user: drh branch: trunk, size: 4038)
2016-08-04
09:09
[40e79f3d] part of check-in [13e3bd3d] Make sure the ORDER BY LIMIT optimization is not applied if the inner-most loop can only have a single iteration and is hence not really a loop. (check-in: [13e3bd3d] user: drh branch: trunk, size: 3554)
2016-05-20
00:21
Added: [55c9f4d0] part of check-in [08849eab] A few simple test cases for the ORDER BY LIMIT optimization. (check-in: [08849eab] user: drh branch: orderby-limit, size: 2836)