/ 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/like.test

2019-08-08
15:24
Remove support for STAT3. The sqlite_stat3 tables are ignored, if they exist. STAT4 continues to work as it always has, and as it is a superset of STAT3 is the recommended replacement. file: [3d702d79] check-in: [1e17ea2f] user: drh branch: omit-stat3, size: 28391
2019-06-10
13:46
Do not attempt the LIKE optimization on a column with numeric affinity if the rhs of the operator begins with whitespace. Fix for ticket [fd76310a5e]. file: [5013f18e] check-in: [94b58ab0] user: dan branch: trunk, size: 28392
2017-09-27
16:51
Disable tests for the LIKE optimization when ICU is enabled, since the LIKE optimization only works for the built-in LIKE operator and ICU overrides the built-in. file: [11cfd7d4] check-in: [f5ef2e1b] user: drh branch: trunk, size: 27939
2017-07-27
22:16
Enhance the like optimization so that it works with an ESCAPE clause. file: [1908852f] check-in: [2495acf7] user: drh branch: branch-3.8.9, size: 25333
20:24
Enhance the like optimization so that it works with an ESCAPE clause. file: [67d7431c] check-in: [f5d330f4] user: drh branch: trunk, size: 27923
2017-07-15
08:02
Fix another minor problem in test file like.test. file: [3d26ae14] check-in: [0953e746] user: dan branch: trunk, size: 26537
06:35
Fix test problems causing the "prepare" permutation test to fail. file: [7c649e82] check-in: [b61cc5a0] user: dan branch: trunk, size: 26541
2017-06-26
13:57
Add the SQLITE_DBCONFIG_ENABLE_QPSG option to activate the query planner stability guarantee. This involves refactoring the sqlite3.flags bitvector to carve out a free bit to use. file: [e7b1e724] check-in: [7076e828] user: drh branch: enable-QPSG, size: 26310
2016-12-02
02:19
Test cases for the improved LIKE/GLOB matcher. file: [0603f4fa] check-in: [0bdb7ae1] user: drh branch: trunk, size: 25298
2016-01-20
14:22
Case folding in the LIKE operator should look at all bits of the character, not just the lower 8 bits. Fix for ticket [80369eddd5c94]. This is a back-out of check-in [0a99a8c4facf] with a testcase added. file: [81632c43] check-in: [204432ee] user: drh branch: trunk, size: 24716
2015-12-01
21:23
Add the SQLITE_LIKE_DOESNT_MATCH_BLOBS compile-time option. file: [edcf6d0a] check-in: [9e1d6d4c] user: drh branch: trunk, size: 24336
2015-03-06
20:49
Test cases added. Comments fixed. Proposed solution for ticket [05f43be8fdda9fbd9]. file: [4f2a71d3] check-in: [6b993bd5] user: drh branch: like-opt-fix, size: 23954
2014-01-16
15:31
Always use available indices to optimize LIKE operators even if the pattern of the LIKE operator has a COLLATE modifier. This fixes an ineffiency that was introduced into 3.7.15 by check-in [8542e6180d4] on 2012-12-08. file: [e191e536] check-in: [16bd5478] user: drh branch: trunk, size: 23954
2013-06-11
02:32
Fixes to EXPLAIN QUERY PLAN output. Change weights back to something closer to what they are in legacy. More test case fixes. file: [935fb4f6] check-in: [36373b85] user: drh branch: nextgen-query-plan-logcost, size: 22073
2013-06-03
22:08
Remove more vestiges of sqlite_query_plan from the test cases. file: [52e650ad] check-in: [eb27086e] user: drh branch: nextgen-query-plan-exp, size: 22073
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: [0e5412f4] check-in: [cfaa7bc1] user: drh branch: fullscan-covering-index, size: 21509
2012-09-12
18:45
Add an implementation of the REGEXP operator and function. Only defined if compiled with SQLITE_ENABLE_REGEXP. file: [25bca9aa] check-in: [8398f77c] user: drh branch: regexp, size: 21643
2011-08-17
00:40
Use OP_Sort rather than OP_Rewind in order to sort the content of a new index on the CREATE INDEX statement. Add an ALWAYS() to the merge sort logic to document an unreachable branch. file: [7b4aaa4a] check-in: [f01766f4] user: drh branch: trunk, size: 21489
2011-06-26
23:44
Modifications to the "like.test" script in order to expose the problem reported by ticket [25ee81271091ec27a8c5]. file: [9cc5261d] check-in: [c4db5b64] user: drh branch: trunk, size: 21465
2011-01-28
01:57
Change the weighting of binary searches on tables to 1/10th the cost of a search on an index. Change the assumed reduction in search space from a indexed range constraint from 1/3rd to 1/4th. Do not let the estimated number of rows drop below 1. file: [a47f5269] check-in: [4847c6cb] user: drh branch: stat2-enhancement, size: 21346
2010-11-01
05:42
Changes to test scripts so that they work with SQLITE_ENABLE_ICU. file: [0f64aeae] check-in: [465c819f] user: dan branch: trunk, size: 21327
2010-07-22
17:49
Enhance the LIKE/GLOB query optimization so that it works as long as there is an index with the appropriate collating sequence and even if the default collating sequence of the column is different. Ticket [4711020446da7d93d99]. file: [565d2403] check-in: [9f932655] user: drh branch: trunk, size: 21107
12:33
Try to optimize LIKE and GLOB operators when RHS contains no wildcard. Ticket [e090183531fc274747] file: [1048b39d] check-in: [613a87d6] user: drh branch: trunk, size: 18534
2009-06-07
23:45
Disable the LIKE optimization if the affinity of the LHS column is not TEXT. Ticket #3901. (CVS 6727) file: [4b594af9] check-in: [a255c645] user: drh branch: trunk, size: 17572
2009-01-09
21:41
Coverage improvements in pragma.c. Change the __DARWIN__ macro to __APPLE__, which is available by default on Leopard. (CVS 6153) file: [22f7857f] check-in: [64c56226] user: drh branch: trunk, size: 14991
2009-01-07
18:24
Fix a bug in the LIKE query optimization. (Found by coverage testing.) (CVS 6137) file: [e55cbbc2] check-in: [fe90e911] user: drh branch: trunk, size: 14646
2008-09-09
12:31
Calling sqlite3_create_function with nArg==(-1) does not override prior calls on the same function name with nArg>=0. Ticket #3345. Add the new -argcount option to the "function" method in the TCL interface. (CVS 5684) file: [fef92492] check-in: [5aa5b804] user: drh branch: trunk, size: 12944
2008-02-23
21:55
Fix a bug in the LIKE optimizer that occurs when the last character before the wildcard is an upper-case 'Z'. Ticket #2959. (CVS 4807) file: [2a3ddbd5] check-in: [610574b2] user: drh branch: trunk, size: 11717
2008-01-23
12:52
Improvements to test coverage in the lemon-generated parser and in the sqlite3_get_table() interface. (CVS 4745) file: [d2d5efc4] check-in: [9f95d79d] user: drh branch: trunk, size: 8855
2007-09-12
17:01
Fixes for compilation/testing when the various OMIT macros are defined. (CVS 4423) file: [2a2cd2d6] check-in: [c8405b15] user: danielk1977 branch: trunk, size: 8777
2007-06-11
12:56
Fix a bug in the LIKE optimization that was causing the pattern string to be dequoted twice. Ticket #2407. (CVS 4056) file: [9b8eb634] check-in: [abf64d1d] user: drh branch: trunk, size: 8732
2006-06-14
08:48
Add tests for the new MATCH operator. (CVS 3238) file: [5f7d7657] check-in: [b4024c39] user: danielk1977 branch: trunk, size: 8414
2006-01-17
09:35
Test suite fixes for builds that define OMIT symbols. (CVS 2962) file: [1665284b] check-in: [3a54a33d] user: danielk1977 branch: trunk, size: 8069
2005-08-28
17:00
The LIKE optimization does the right thing when collating sequences are present. LIKE expressions where the left-hand side has COLLATE NOCASE are optimized in the default case. (CVS 2637) file: [145382e6] check-in: [ef84ff79] user: drh branch: trunk, size: 8061
2005-08-19
00:14
Bring testing coverage of the analyze.c file up to 100%. Bugs found and fixed in the process. (CVS 2599) file: [b1e77e32] check-in: [2fe0ac4f] user: drh branch: trunk, size: 6803
2005-08-14
01:20
The case_sensitive_like pragma added. Test cases added for the LIKE optimization. (CVS 2592) file: [b94052f7] check-in: [72ee21c0] user: drh branch: trunk, size: 6087 Added