/ File History
Login

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

History of test/orderby1.test

2018-05-05
16:50
In an ORDER BY LIMIT, make sure the ORDER BY expression evaluator does not try to reuse values from the result set if the result set has not yet be computed. This fixes a bug in the recent deferred-row loading optimization, check-in [c381f0ea57002a264fd958b28e]. OSSFuzz discovered the problem. file: [e4501f54] check-in: [5d61e75f] user: drh branch: trunk, size: 15812
2018-05-03
01:37
Enhance EXPLAIN QUERY PLAN to report the generation of constant rows using VALUES or just a SELECT without FROM. file: [bb8535f5] check-in: [c75eee69] user: drh branch: rework-EQP, size: 15470
2018-05-02
18:00
Fix test cases so that they work with the new EXPLAIN QUERY PLAN output format. Only some of the cases have been fixed. This is an incremental check-in. file: [c4bbefbd] check-in: [5f0e803e] user: drh branch: rework-EQP, size: 15456
2016-11-02
16:29
When the block sorting optimization is used in a scalar subquery, be sure to exit the loop as soon as the first valid output row is received. Fix for ticket [cb3aa0641d9a4] backported to the 3.8.9 branch. file: [66ca14d7] check-in: [8e4ba115] user: drh branch: branch-3.8.9, size: 14711
2016-01-13
17:50
When the block sorting optimization is used in a scalar subquery, be sure to exit the loop as soon as the first valid output row is received. Fix for ticket [cb3aa0641d9a4]. file: [4d22a7c7] check-in: [cdbb0947] user: drh branch: trunk, size: 15454
2015-04-12
01:22
Avoid problems when a query has a GROUP BY and an ORDER BY but no FROM clause. file: [870e1504] check-in: [e527d96a] user: drh branch: trunk, size: 14943
2015-04-11
20:20
Fix a problem with sorting large amounts of partially ordered data. file: [d69a2c99] check-in: [acca97ef] user: dan branch: trunk, size: 14873
2014-09-19
02:01
Make sure that the sorting-index pre-filter recognizes that a rowid reference might be sortable. This fixes a performance regression. file: [eb246e37] check-in: [72727b68] user: drh branch: Cplusplus-comment, size: 14200
2014-06-03
14:42
Avoid closing a pseudo-table associated with sorting in a co-routine since that pseudo-table might be used again in an outer loop. file: [12426f99] check-in: [6d818052] user: drh branch: trunk, size: 13701
2014-06-02
11:26
Fix the query planner so that it once again knows that queries without a FROM clause will never return more than one row and hence do not require sorting. file: [2a616416] check-in: [9f18b303] user: drh branch: trunk, size: 13138
2013-06-12
17:08
"make test" now passing. file: [9b524aff] check-in: [addd7f46] user: drh branch: nextgen-query-plan-exp, size: 12851
2013-06-04
15:31
Test case updates. file: [3c5ff32c] check-in: [0360fec7] user: drh branch: nextgen-query-plan-exp, size: 12843
2012-11-09
17:59
Try to take into account the cost of inner loops when selecting which table of a join to use for the outer loop. file: [f3396864] check-in: [94255634] user: drh branch: inner-loop-cost, size: 12310
2012-10-08
21:01
All test cases (veryquick.tcl and min.rc) pass. A few branch operations in ORDER BY optimization logic are untested by min.rc. file: [ef4f7c40] check-in: [8314fd60] user: drh branch: qp-enhancements, size: 12028
2012-10-02
15:19
More lenient handling of ORDER BY optimization in joins with mixed ASC/DESC. This is a better and less restrictive fix for the problem addressed by the previous check-in. file: [4875a2a0] check-in: [abcf6a5d] user: drh branch: trunk, size: 12213
14:11
Only continue an ORDER BY optimization into inner loops if the equality constraints on the inner loop match terms of an outer ordered index that are actually used by the ORDER BY clause. file: [1f7e942a] check-in: [b0e7b4df] user: drh branch: trunk, size: 12241
2012-09-27
19:53
More test cases an bug fixes for the ORDER BY optimization of joins. All veryquick tests now pass. file: [31c98656] check-in: [0d573320] user: drh branch: qp-enhancements, size: 11885
17:31
Test cases and bug fixes applied to the ORDER BY optimization for joins. Some test cases fail, but except for the new orderby1.test failures, all failures appear to be issues with the tests, not with the core code. file: [868a4f88] check-in: [75cda864] user: drh branch: qp-enhancements, size: 4323 Added