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 | |