/ Check-in [956e4d7f]
Login

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

Overview
Comment: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.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 956e4d7f8958e7065ff2d61cd71519d6f4113d4a
User & Date: drh 2012-10-03 12:56:18
References
2013-03-27
11:39 Ticket [a179fe74] Incorrect output order on a join with an ORDER BY status still Open with 7 other changes artifact: 41623a1a user: drh
2013-01-09
09:39 New ticket [c997b11c] ORDER BY clause ignored in 3-way join query. artifact: 55771e45 user: dan
Context
2012-10-03
18:09
Fix an out-of-order memset() that occurs before all variable declarations are finished. Also fix a line that exceeds the 80-character line length limit. check-in: ba2f492f user: drh tags: trunk
12:56
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 tags: trunk
12:38
Fix a query planner problem that only occurs when covering-index-scan is disabled. Fix to tests whose output changed due to the new and more aggressive ORDER BY optimization. Closed-Leaf check-in: 0f9bb901 user: drh tags: qp-enhancements
11:02
Fix the TCL interface so that SQL functions implemented in TCL honor the "nullvalue" setting. Also remove from the TCL interface some unused legacy UTF8 translation code left over from SQLite2. check-in: c1f10a26 user: drh tags: trunk
Changes
Unified Diffs Side-by-Side Diffs Patch

Changes to src/tclsqlite.c.

Changes to src/where.c.

Changes to test/fuzzer1.test.

Changes to test/orderby2.test.

Changes to test/where.test.