Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.
|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|
|User & Date:||drh 2012-10-03 12:56:18|
|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)|
|09:39||• New ticket [c997b11c] ORDER BY clause ignored in 3-way join query. (artifact: 55771e45 user: dan)|
|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 to src/tclsqlite.c.
Changes to src/where.c.
Changes to test/fuzzer1.test.
Changes to test/orderby2.test.
Changes to test/where.test.