SQLite

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
[bd7d9e3380] part of check-in [abfb043ebb] Fix an incorrect assert() statement that was added yesterday. Tickets [41c1456a6e61c0e7] and [fb8c538a8f57ae2a]. (check-in: [abfb043ebb] user: drh branch: trunk, size: 5200)
2020-02-12
11:57
[8511a749d9] part of check-in [16aed5d0c6] 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: [16aed5d0c6] user: dan branch: trunk, size: 4936)
2018-07-28
21:01
[5f4d6cb93c] part of check-in [85b9beb460] 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: [85b9beb460] user: drh branch: trunk, size: 3594)
2014-04-26
20:21
[8f08a54836] part of check-in [dee2040924] Fix an sqlite3_stmt_status() problem caused by recent changs on this branch. (check-in: [dee2040924] user: dan branch: experimental-costs, size: 3594)
2014-03-19
23:24
[2490183fef] part of check-in [01afbf97c0] 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: [01afbf97c0] user: drh branch: orderby-planning, size: 3576)
2013-11-06
12:56
[0eb82d5890] part of check-in [8f1709ff2d] Improved ORDER BY optimization for WITHOUT ROWID tables. (check-in: [8f1709ff2d] user: drh branch: omit-rowid, size: 3089)
2013-06-14
02:51
Added: [02eca502a0] part of check-in [b920bb70bb] 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: [b920bb70bb] user: drh branch: nextgen-query-plan-exp, size: 2594)