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

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

History for test/orderby1.test

2020-01-03
14:27
[6bf0ce45] part of check-in [9d791116] Fix a possible NULL pointer dereference caused by using a "VALUES(...)" as a component of a compound SELECT with non-integer ORDER BY clause terms. (check-in: [9d791116] user: dan branch: trunk, size: 15949)
2018-05-05
16:50
[e4501f54] part of check-in [5d61e75f] 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. (check-in: [5d61e75f] user: drh branch: trunk, size: 15812)
2018-05-03
01:37
[bb8535f5] part of check-in [c75eee69] Enhance EXPLAIN QUERY PLAN to report the generation of constant rows using VALUES or just a SELECT without FROM. (check-in: [c75eee69] user: drh branch: rework-EQP, size: 15470)
2018-05-02
18:00
[c4bbefbd] part of check-in [5f0e803e] 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. (check-in: [5f0e803e] user: drh branch: rework-EQP, size: 15456)
2016-11-02
16:29
[66ca14d7] part of check-in [8e4ba115] 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. (check-in: [8e4ba115] user: drh branch: branch-3.8.9, size: 14711)
2016-01-13
17:50
[4d22a7c7] part of check-in [cdbb0947] 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]. (check-in: [cdbb0947] user: drh branch: trunk, size: 15454)
2015-04-12
01:22
[870e1504] part of check-in [e527d96a] Avoid problems when a query has a GROUP BY and an ORDER BY but no FROM clause. (check-in: [e527d96a] user: drh branch: trunk, size: 14943)
2015-04-11
20:20
[d69a2c99] part of check-in [acca97ef] Fix a problem with sorting large amounts of partially ordered data. (check-in: [acca97ef] user: dan branch: trunk, size: 14873)
2014-09-19
02:01
[eb246e37] part of check-in [72727b68] Make sure that the sorting-index pre-filter recognizes that a rowid reference might be sortable. This fixes a performance regression. (check-in: [72727b68] user: drh branch: Cplusplus-comment, size: 14200)
2014-06-03
14:42
[12426f99] part of check-in [6d818052] Avoid closing a pseudo-table associated with sorting in a co-routine since that pseudo-table might be used again in an outer loop. (check-in: [6d818052] user: drh branch: trunk, size: 13701)
2014-06-02
11:26
[2a616416] part of check-in [9f18b303] 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. (check-in: [9f18b303] user: drh branch: trunk, size: 13138)
2013-06-12
17:08
[9b524aff] part of check-in [addd7f46] "make test" now passing. (check-in: [addd7f46] user: drh branch: nextgen-query-plan-exp, size: 12851)
2013-06-04
15:31
[3c5ff32c] part of check-in [0360fec7] Test case updates. (check-in: [0360fec7] user: drh branch: nextgen-query-plan-exp, size: 12843)
2012-11-09
17:59
[f3396864] part of check-in [94255634] Try to take into account the cost of inner loops when selecting which table of a join to use for the outer loop. (check-in: [94255634] user: drh branch: inner-loop-cost, size: 12310)
2012-10-08
21:01
[ef4f7c40] part of check-in [8314fd60] All test cases (veryquick.tcl and min.rc) pass. A few branch operations in ORDER BY optimization logic are untested by min.rc. (check-in: [8314fd60] user: drh branch: qp-enhancements, size: 12028)
2012-10-02
15:19
[4875a2a0] part of check-in [abcf6a5d] 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. (check-in: [abcf6a5d] user: drh branch: trunk, size: 12213)
14:11
[1f7e942a] part of check-in [b0e7b4df] 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. (check-in: [b0e7b4df] user: drh branch: trunk, size: 12241)
2012-09-27
19:53
[31c98656] part of check-in [0d573320] More test cases an bug fixes for the ORDER BY optimization of joins. All veryquick tests now pass. (check-in: [0d573320] user: drh branch: qp-enhancements, size: 11885)
17:31
Added: [868a4f88] part of check-in [75cda864] 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. (check-in: [75cda864] user: drh branch: qp-enhancements, size: 4323)