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

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

History for test/orderby5.test

2020-02-13
11:46
[bd7d9e33] part of check-in [abfb043e] Fix an incorrect assert() statement that was added yesterday. Tickets [41c1456a6e61c0e7] and [fb8c538a8f57ae2a]. (check-in: [abfb043e] user: drh branch: trunk, size: 5200)
2020-02-12
11:57
[8511a749] part of check-in [16aed5d0] When determining whether an == or IS constraint in a WHERE clause makes an ORDER BY term redundant, consider the collation sequence used by the == or IS comparison, not the collation sequence of the comparison expression itself. Possible fix for [fb8c538a8f]. (check-in: [16aed5d0] user: dan branch: trunk, size: 4936)
2018-07-28
21:01
[5f4d6cb9] part of check-in [85b9beb4] Add a small cost penalty to sorting to bias the query planner in favor of plans that do not require a final sorting pass. (check-in: [85b9beb4] user: drh branch: trunk, size: 3594)
2014-04-26
20:21
[8f08a548] part of check-in [dee20409] Fix an sqlite3_stmt_status() problem caused by recent changs on this branch. (check-in: [dee20409] user: dan branch: experimental-costs, size: 3594)
2014-03-19
23:24
[2490183f] part of check-in [01afbf97] Fix query planner weights associated with choosing block-sorting. Fix block sorting of tables with collating functions. Fix various test cases. All "veryquick" tests are now passing, though more tests need to be added. (check-in: [01afbf97] user: drh branch: orderby-planning, size: 3576)
2013-11-06
12:56
[0eb82d58] part of check-in [8f1709ff] Improved ORDER BY optimization for WITHOUT ROWID tables. (check-in: [8f1709ff] user: drh branch: omit-rowid, size: 3089)
2013-06-14
02:51
Added: [02eca502] part of check-in [b920bb70] Add a new ORDER BY optimization that bypasses ORDER BY terms that are constrained by == and IS NULL terms of the WHERE clause. (check-in: [b920bb70] user: drh branch: nextgen-query-plan-exp, size: 2594)