Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History of test/like3.test
|
2019-09-16
| ||
| 18:19 | Do not attempt the LIKE optimization for non-text columns and a pattern prefix of "-". Ticket [0f0428096f17252a] file: [4f940ad2] check-in: [6fe0367f] user: drh branch: trunk, size: 8263 | |
|
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 | |