/ History for test/like3.test
Login

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

History for test/like3.test

2020-03-19
18:13
[03d1bdf8] 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: 8263)
2019-09-16
18:19
[4f940ad2] part of check-in [6fe0367f] Do not attempt the LIKE optimization for non-text columns and a pattern prefix of "-". Ticket [0f0428096f17252a] (check-in: [6fe0367f] user: drh branch: trunk, size: 8263)
2019-06-14
12:28
[62bf82ac] part of check-in [b4a9e09e] 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]. (check-in: [b4a9e09e] user: drh branch: trunk, size: 7957)
2019-05-08
19:55
[ac61947e] part of check-in [74020110] Fix another pattern for which the LIKE optimization does not work for a non-TEXT affinity. Case found by Manuel Rigger. (check-in: [74020110] user: drh branch: trunk, size: 7691)
2019-05-02
01:41
[b065d1ca] part of check-in [b043a54c] 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. (check-in: [b043a54c] user: drh branch: trunk, size: 7430)
2019-04-26
17:08
[d3684b5c] part of check-in [af53c41a] Omit tests of the LIKE optimization in like3.test when SQLITE_ENABLE_ICU is defined. (check-in: [af53c41a] user: dan branch: trunk, size: 7135)
2019-02-27
23:05
[0ce2630e] part of check-in [6ae4b8c5] Enable the LIKE optimization when the ESCAPE keyword is present and the PRAGMA case_sensitive_like pragma is ON. (check-in: [6ae4b8c5] user: drh branch: trunk, size: 7116)
2018-09-28
23:53
[430691e6] part of check-in [d04b2013] Fix test cases so that they work with ICU. (check-in: [d04b2013] user: drh branch: trunk, size: 5726)
2018-09-10
12:40
[cf0ff2d0] part of check-in [f191431d] 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]. (check-in: [f191431d] user: drh branch: trunk, size: 5707)
2015-12-01
21:23
[3608a204] part of check-in [9e1d6d4c] Add the SQLITE_LIKE_DOESNT_MATCH_BLOBS compile-time option. (check-in: [9e1d6d4c] user: drh branch: trunk, size: 4038)
2015-03-07
12:58
[7b0525a3] part of check-in [50fa3c5f] New test cases for LIKE and GLOB with BLOB left-hand side values. (check-in: [50fa3c5f] user: drh branch: like-opt-fix, size: 3984)
02:51
[2fd1fd45] part of check-in [564b8fe7] Fix problems with reverse order sorting and indexes in the LIKE optimization. (check-in: [564b8fe7] user: drh branch: like-opt-fix, size: 3604)
00:57
[f6fa86d6] part of check-in [26cb5145] Refactor some jump opcodes in the VDBE. Add JumpZeroIncr and DecrJumpZero. Fix the LIKE optimization to work with DESC sort order. (check-in: [26cb5145] user: drh branch: like-opt-fix, size: 2494)
2015-03-06
20:49
[9c855872] 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: 1895) Added