/ File History
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.

History of test/tkt-78e04e52ea.test

2019-06-14
12:28
Refactor the LIKE optimization decision logic so that it uses sqlite3AtoF() on both boundary keys to determine if the optimization can be used when the LHS is something that might not have TEXT affinity. Ticket [ce8717f0885af975]. See also [c94369cae9b561b1], [b043a54c3de54b28], [fd76310a5e843e07], and [158290c0abafde67]. file: [cb44d0f5] check-in: [b4a9e09e] user: drh branch: trunk, size: 1613
2018-05-02
19:42
More test case updates. Tests are all running now. file: [1b5be1ba] check-in: [dab5e529] user: drh branch: rework-EQP, size: 1614
2017-02-17
02:04
Fix a test case that was made to fail by the LIKE optimization enhancement in check-in [158290c0ab] but which went unnoticed because test builds were running with ICU enabled and ICU disables the LIKE optimization. file: [1b2e6bf4] check-in: [218b2bbb] user: drh branch: trunk, size: 1635
2013-11-05
13:33
Standardize the error messages generated by constraint failures to a format of "$TYPE constraint failed: $DETAIL". This involves many changes to the expected output of test cases. file: [813779f8] check-in: [54b22192] user: drh branch: omit-rowid, size: 1634
2013-10-04
15:58
Fix test cases so that they work when the query planner uses index size estimates to determine whether or not to try an covering index scan. file: [b0190d33] check-in: [2f394de8] user: drh branch: index-scan-rate, size: 1628
2013-06-10
23:30
Fix test cases for the new EXPLAIN QUERY PLAN format. Add the wherecosttest tool. Other fixes to logarithm cost. file: [787b70cf] check-in: [aa580e36] user: drh branch: nextgen-query-plan-logcost, size: 1582
2012-09-15
18:45
Attempt to use a covering index even on a full table scan, under the theory that the index will be smaller and require less disk I/O and thus be faster. file: [703e0bfb] check-in: [cfaa7bc1] user: drh branch: fullscan-covering-index, size: 1623
2010-11-13
16:42
Change the EXPLAIN QUERY PLAN output to use "USING INDEX" instead of "BY INDEX", and to use "SEARCH" instead of "SCAN" for loops that are not full-table scans. file: [ab52f0c1] check-in: [6611b76b] user: dan branch: experimental, size: 1599
2010-11-11
10:36
Modifications to test cases to account for new EXPLAIN QUERY PLAN output. file: [567dcb06] check-in: [30904ef8] user: dan branch: experimental, size: 1594
2009-12-08
14:34
Allow zero-length names for tables, columns, and indices. Fix for ticket [78e04e52eaf]. file: [fb5430c6] check-in: [7b1cfd65] user: drh branch: trunk, size: 1519 Added