SQLite

All files named ”test/limit2.test”
Login

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

History for test/limit2.test

2025-04-10
10:18
[621188fc3e] part of check-in [20acd630b9] Remove unnecessary "www." prefixes on domain names in URLs. (check-in: [20acd630b9] user: drh branch: trunk, size: 7721)
2018-09-08
20:09
[9409b03328] part of check-in [206720129e] Fix multiple issues with the ORDER BY LIMIT optimization. This is the proposed resolution to ticket [9936b2fa443fec03ff25]. (check-in: [206720129e] user: drh branch: trunk, size: 7737)
2017-12-13
18:01
[360982809e] part of check-in [65754dc3b8] Correctly invalidate a column cache line when it is overwritten with NULL. Fix for ticket [123c9ba32130a6c9d432]. (check-in: [65754dc3b8] user: drh branch: trunk, size: 6069)
2016-10-12
14:48
[e35f57bd3a] part of check-in [8e2b25f9b8] Fix a problem affecting queries that match the pattern (... WHERE ipk IN (....) ORDER BY ? LIMIT ?). Fix for [96c1454c]. (check-in: [8e2b25f9b8] user: dan branch: trunk, size: 5422)
2016-09-23
18:06
[7e7744cc54] part of check-in [0c3cafb7eb] Fix the ORDER BY LIMIT optimization backport so that it works when the ORDER BY uses the DESC direction. (check-in: [0c3cafb7eb] user: drh branch: branch-3.8.9, size: 4473)
2016-09-07
01:51
[ac97b8d070] part of check-in [820644b886] 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: [820644b886] user: drh branch: trunk, size: 4038)
2016-08-04
09:09
[40e79f3d95] part of check-in [13e3bd3de6] 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: [13e3bd3de6] user: drh branch: trunk, size: 3554)
2016-05-20
00:21
Added: [55c9f4d08c] part of check-in [08849eab0f] A few simple test cases for the ORDER BY LIMIT optimization. (check-in: [08849eab0f] user: drh branch: orderby-limit, size: 2836)