/ File History
Login

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

History of test/like3.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: [62bf82ac] check-in: [b4a9e09e] user: drh branch: trunk, size: 7957
2019-05-08
19:55
Fix another pattern for which the LIKE optimization does not work for a non-TEXT affinity. Case found by Manuel Rigger. file: [ac61947e] check-in: [74020110] user: drh branch: trunk, size: 7691
2019-05-02
01:41
The "LIKE Optimization" (which converts a LIKE into a BETWEEN operator that is able to use an index) does not work and cannot be used if the collating sequence of the column is not TEXT and if the pattern starts with a "+" sign. This is another case of ticket [c94369cae9b561b1f996d005]. The new test case was discovered by Manuel Rigger. file: [b065d1ca] check-in: [b043a54c] user: drh branch: trunk, size: 7430
2019-04-26
17:08
Omit tests of the LIKE optimization in like3.test when SQLITE_ENABLE_ICU is defined. file: [d3684b5c] check-in: [af53c41a] user: dan branch: trunk, size: 7135
2019-02-27
23:05
Enable the LIKE optimization when the ESCAPE keyword is present and the PRAGMA case_sensitive_like pragma is ON. file: [0ce2630e] check-in: [6ae4b8c5] user: drh branch: trunk, size: 7116
2018-09-28
23:53
Fix test cases so that they work with ICU. file: [430691e6] check-in: [d04b2013] user: drh branch: trunk, size: 5726
2018-09-10
12:40
Fix the LIKE optimization so that it is disabled when the LHS of the expression does not have TEXT affinity and the RHS is the pattern '/%' or the RHS begins with the escape character. Fix for ticket [c94369cae9b561b1f996d0054b]. file: [cf0ff2d0] check-in: [f191431d] user: drh branch: trunk, size: 5707
2015-12-01
21:23
Add the SQLITE_LIKE_DOESNT_MATCH_BLOBS compile-time option. file: [3608a204] check-in: [9e1d6d4c] user: drh branch: trunk, size: 4038
2015-03-07
12:58
New test cases for LIKE and GLOB with BLOB left-hand side values. file: [7b0525a3] check-in: [50fa3c5f] user: drh branch: like-opt-fix, size: 3984
02:51
Fix problems with reverse order sorting and indexes in the LIKE optimization. file: [2fd1fd45] check-in: [564b8fe7] user: drh branch: like-opt-fix, size: 3604
00:57
Refactor some jump opcodes in the VDBE. Add JumpZeroIncr and DecrJumpZero. Fix the LIKE optimization to work with DESC sort order. file: [f6fa86d6] check-in: [26cb5145] user: drh branch: like-opt-fix, size: 2494
2015-03-06
20:49
Test cases added. Comments fixed. Proposed solution for ticket [05f43be8fdda9fbd9]. file: [9c855872] check-in: [6b993bd5] user: drh branch: like-opt-fix, size: 1895 Added