/ Check-in [a49e909c]
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

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

Overview
Comment:Enhance the processing of ORDER BY clauses on compound queries to better match terms of the order by against expressions in the result set, in order to enable better query optimization.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: a49e909c8738317c8383ce93771c0a9c4cf270bc
User & Date: drh 2012-04-27 01:09:06
References
2014-09-20
17:05 New ticket [d11a6e90] Query planner fault on three-way nested join. artifact: ce50af6b user: drh
Context
2012-04-27
16:38
Fix a minor deviation from the coding style guidelines. check-in: 1e51bffe user: drh tags: trunk
01:09
Enhance the processing of ORDER BY clauses on compound queries to better match terms of the order by against expressions in the result set, in order to enable better query optimization. check-in: a49e909c user: drh tags: trunk
01:08
Enhance the do_test proc in the test suite so that if the expected result is of the form "/.../" or "~/.../" then regular expression matching is done between result and the "..." part of the expectation. In the ~/.../ case, we expect there to be no match. check-in: c9a73440 user: drh tags: trunk
Changes
Unified Diffs Side-by-Side Diffs Patch

Changes to src/resolve.c.

Changes to test/select9.test.