/ File History
Login

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

History of test/limit2.test

2018-09-08
20:09
Fix multiple issues with the ORDER BY LIMIT optimization. This is the proposed resolution to ticket [9936b2fa443fec03ff25]. file: [9409b033] check-in: [20672012] user: drh branch: trunk, size: 7737
2017-12-13
18:01
Correctly invalidate a column cache line when it is overwritten with NULL. Fix for ticket [123c9ba32130a6c9d432]. file: [36098280] check-in: [65754dc3] user: drh branch: trunk, size: 6069
2016-10-12
14:48
Fix a problem affecting queries that match the pattern (... WHERE ipk IN (....) ORDER BY ? LIMIT ?). Fix for [96c1454c]. file: [e35f57bd] check-in: [8e2b25f9] user: dan branch: trunk, size: 5422
2016-09-23
18:06
Fix the ORDER BY LIMIT optimization backport so that it works when the ORDER BY uses the DESC direction. file: [7e7744cc] check-in: [0c3cafb7] user: drh branch: branch-3.8.9, size: 4473
2016-09-07
01:51
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]. file: [ac97b8d0] check-in: [820644b8] user: drh branch: trunk, size: 4038
2016-08-04
09:09
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. file: [40e79f3d] check-in: [13e3bd3d] user: drh branch: trunk, size: 3554
2016-05-20
00:21
A few simple test cases for the ORDER BY LIMIT optimization. file: [55c9f4d0] check-in: [08849eab] user: drh branch: orderby-limit, size: 2836 Added