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

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

History for test/orderby2.test

2012-10-03
12:56
[bc11009f] part of check-in [956e4d7f] Update the query planner to recognize more cases where ORDER BY clauses can be optimized out. Add test cases to verify correct behavior of the ORDER BY optimization when the covering-index-scan optimization is disabled. Fix a harmless compiler warning in the TCL interface. (check-in: [956e4d7f] user: drh branch: trunk, size: 3482)
00:25
[b799f7c9] part of check-in [6744d9a3] Further attempts to optimize out unnecessary ORDER BY clauses. (check-in: [6744d9a3] user: drh branch: qp-enhancements, size: 2814)
2012-10-02
14:11
[d8fa5991] 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: 2818)
2012-09-29
19:10
Added: [295d6639] part of check-in [62225b4a] Improved ORDER BY optimization when outer loops of a join return a single row. (check-in: [62225b4a] user: drh branch: trunk, size: 1736)