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

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

History for test/like.test

2020-03-19
18:13
[47b81d5d] part of check-in [11e0844f] Change the ESCAPE clause on the LIKE operator to override wildcard characters, in order to match the behavior of PosgreSQL. (check-in: [11e0844f] user: drh branch: trunk, size: 28816)
2019-08-08
15:24
[3d702d79] part of check-in [1e17ea2f] 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. (check-in: [1e17ea2f] user: drh branch: omit-stat3, size: 28391)
2019-06-10
13:46
[5013f18e] part of check-in [94b58ab0] 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]. (check-in: [94b58ab0] user: dan branch: trunk, size: 28392)
2017-09-27
16:51
[11cfd7d4] part of check-in [f5ef2e1b] 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. (check-in: [f5ef2e1b] user: drh branch: trunk, size: 27939)
2017-07-27
22:16
[1908852f] part of check-in [2495acf7] Enhance the like optimization so that it works with an ESCAPE clause. (check-in: [2495acf7] user: drh branch: branch-3.8.9, size: 25333)
20:24
[67d7431c] part of check-in [f5d330f4] Enhance the like optimization so that it works with an ESCAPE clause. (check-in: [f5d330f4] user: drh branch: trunk, size: 27923)
2017-07-15
08:02
[3d26ae14] part of check-in [0953e746] Fix another minor problem in test file like.test. (check-in: [0953e746] user: dan branch: trunk, size: 26537)
06:35
[7c649e82] part of check-in [b61cc5a0] Fix test problems causing the "prepare" permutation test to fail. (check-in: [b61cc5a0] user: dan branch: trunk, size: 26541)
2017-06-26
13:57
[e7b1e724] part of check-in [7076e828] 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. (check-in: [7076e828] user: drh branch: enable-QPSG, size: 26310)
2016-12-02
02:19
[0603f4fa] part of check-in [0bdb7ae1] Test cases for the improved LIKE/GLOB matcher. (check-in: [0bdb7ae1] user: drh branch: trunk, size: 25298)
2016-01-20
14:22
[81632c43] part of check-in [204432ee] 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. (check-in: [204432ee] user: drh branch: trunk, size: 24716)
2015-12-01
21:23
[edcf6d0a] part of check-in [9e1d6d4c] Add the SQLITE_LIKE_DOESNT_MATCH_BLOBS compile-time option. (check-in: [9e1d6d4c] user: drh branch: trunk, size: 24336)
2015-03-06
20:49
[4f2a71d3] part of check-in [6b993bd5] Test cases added. Comments fixed. Proposed solution for ticket [05f43be8fdda9fbd9]. (check-in: [6b993bd5] user: drh branch: like-opt-fix, size: 23954)
2014-01-16
15:31
[e191e536] part of check-in [16bd5478] 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. (check-in: [16bd5478] user: drh branch: trunk, size: 23954)
2013-06-11
02:32
[935fb4f6] part of check-in [36373b85] Fixes to EXPLAIN QUERY PLAN output. Change weights back to something closer to what they are in legacy. More test case fixes. (check-in: [36373b85] user: drh branch: nextgen-query-plan-logcost, size: 22073)
2013-06-03
22:08
[52e650ad] part of check-in [eb27086e] Remove more vestiges of sqlite_query_plan from the test cases. (check-in: [eb27086e] user: drh branch: nextgen-query-plan-exp, size: 22073)
2012-09-15
18:45
[0e5412f4] part of check-in [cfaa7bc1] 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. (check-in: [cfaa7bc1] user: drh branch: fullscan-covering-index, size: 21509)
2012-09-12
18:45
[25bca9aa] part of check-in [8398f77c] Add an implementation of the REGEXP operator and function. Only defined if compiled with SQLITE_ENABLE_REGEXP. (check-in: [8398f77c] user: drh branch: regexp, size: 21643)
2011-08-17
00:40
[7b4aaa4a] part of check-in [f01766f4] 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. (check-in: [f01766f4] user: drh branch: trunk, size: 21489)
2011-06-26
23:44
[9cc5261d] part of check-in [c4db5b64] Modifications to the "like.test" script in order to expose the problem reported by ticket [25ee81271091ec27a8c5]. (check-in: [c4db5b64] user: drh branch: trunk, size: 21465)
2011-01-28
01:57
[a47f5269] part of check-in [4847c6cb] 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. (check-in: [4847c6cb] user: drh branch: stat2-enhancement, size: 21346)
2010-11-01
05:42
[0f64aeae] part of check-in [465c819f] Changes to test scripts so that they work with SQLITE_ENABLE_ICU. (check-in: [465c819f] user: dan branch: trunk, size: 21327)
2010-07-22
17:49
[565d2403] part of check-in [9f932655] 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]. (check-in: [9f932655] user: drh branch: trunk, size: 21107)
12:33
[1048b39d] part of check-in [613a87d6] Try to optimize LIKE and GLOB operators when RHS contains no wildcard. Ticket [e090183531fc274747] (check-in: [613a87d6] user: drh branch: trunk, size: 18534)
2009-06-07
23:45
[4b594af9] part of check-in [a255c645] Disable the LIKE optimization if the affinity of the LHS column is not TEXT. Ticket #3901. (CVS 6727) (check-in: [a255c645] user: drh branch: trunk, size: 17572)
2009-01-09
21:41
[22f7857f] part of check-in [64c56226] Coverage improvements in pragma.c. Change the __DARWIN__ macro to __APPLE__, which is available by default on Leopard. (CVS 6153) (check-in: [64c56226] user: drh branch: trunk, size: 14991)
2009-01-07
18:24
[e55cbbc2] part of check-in [fe90e911] Fix a bug in the LIKE query optimization. (Found by coverage testing.) (CVS 6137) (check-in: [fe90e911] user: drh branch: trunk, size: 14646)
2008-09-09
12:31
[fef92492] part of check-in [5aa5b804] 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) (check-in: [5aa5b804] user: drh branch: trunk, size: 12944)
2008-02-23
21:55
[2a3ddbd5] part of check-in [610574b2] 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) (check-in: [610574b2] user: drh branch: trunk, size: 11717)
2008-01-23
12:52
[d2d5efc4] part of check-in [9f95d79d] Improvements to test coverage in the lemon-generated parser and in the sqlite3_get_table() interface. (CVS 4745) (check-in: [9f95d79d] user: drh branch: trunk, size: 8855)
2007-09-12
17:01
[2a2cd2d6] part of check-in [c8405b15] Fixes for compilation/testing when the various OMIT macros are defined. (CVS 4423) (check-in: [c8405b15] user: danielk1977 branch: trunk, size: 8777)
2007-06-11
12:56
[9b8eb634] part of check-in [abf64d1d] Fix a bug in the LIKE optimization that was causing the pattern string to be dequoted twice. Ticket #2407. (CVS 4056) (check-in: [abf64d1d] user: drh branch: trunk, size: 8732)
2006-06-14
08:48
[5f7d7657] part of check-in [b4024c39] Add tests for the new MATCH operator. (CVS 3238) (check-in: [b4024c39] user: danielk1977 branch: trunk, size: 8414)
2006-01-17
09:35
[1665284b] part of check-in [3a54a33d] Test suite fixes for builds that define OMIT symbols. (CVS 2962) (check-in: [3a54a33d] user: danielk1977 branch: trunk, size: 8069)
2005-08-28
17:00
[145382e6] part of check-in [ef84ff79] 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) (check-in: [ef84ff79] user: drh branch: trunk, size: 8061)
2005-08-19
00:14
[b1e77e32] part of check-in [2fe0ac4f] Bring testing coverage of the analyze.c file up to 100%. Bugs found and fixed in the process. (CVS 2599) (check-in: [2fe0ac4f] user: drh branch: trunk, size: 6803)
2005-08-14
01:20
Added: [b94052f7] part of check-in [72ee21c0] The case_sensitive_like pragma added. Test cases added for the LIKE optimization. (CVS 2592) (check-in: [72ee21c0] user: drh branch: trunk, size: 6087)