SQLite

All files named ”test/like3.test”
Login

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

History for test/like3.test

2025-06-13
11:08
[3eb98719a3] part of check-in [40a83da503] Further improvements to the EQP text for flex-search. (check-in: [40a83da503] user: drh branch: flex-search, size: 10261)
00:50
[86ffc7b04f] part of check-in [680e278c3e] Change the flex-search EQP message to be "SEARCH ... OR SCAN" as this seems less disruptive and more readable. (check-in: [680e278c3e] user: drh branch: flex-search, size: 10245)
2025-06-12
19:02
[fa69e88f4a] part of check-in [521948c64f] Preliminary code generation for flex-search. Add a no-op IfUseIndex opcode as a placeholder. (check-in: [521948c64f] user: drh branch: flex-search, size: 10233)
2025-04-10
10:18
[3c9be7a012] part of check-in [20acd630b9] Remove unnecessary "www." prefixes on domain names in URLs. (check-in: [20acd630b9] user: drh branch: trunk, size: 10213)
2025-02-14
10:28
[1179fef50a] part of check-in [5964616dc9] Fix test cases added for [4b4f33d791fe4318] so that they also work when compiling with ICU support. Forum post 2ca8a09a7e (check-in: [5964616dc9] user: drh branch: trunk, size: 10225)
2025-01-31
18:56
[b21284df22] part of check-in [6df2098c54] Fix test case numbering in tests recently added to like3.test. (check-in: [6df2098c54] user: drh branch: trunk, size: 9967)
14:52
[a9d7829742] part of check-in [4b4f33d791] Fix a problem with LIKE and GLOB processing in utf-16be databases in cases where the utf-8 encoding of a character ends with the byte 0xBF. Forum post d7b90d92ffbfc61f (check-in: [4b4f33d791] user: dan branch: trunk, size: 9924)
2021-03-20
15:11
[a76e5938fa] part of check-in [50fbd53260] Revise tests cases to align with the new EXPLAIN QUERY PLAN output. (check-in: [50fbd53260] user: drh branch: eqp-improvements, size: 8191)
2020-03-19
18:13
[03d1bdf848] part of check-in [11e0844f71] Change the ESCAPE clause on the LIKE operator to override wildcard characters, in order to match the behavior of PosgreSQL. (check-in: [11e0844f71] user: drh branch: trunk, size: 8263)
2019-09-16
18:19
[4f940ad275] part of check-in [6fe0367f9a] Do not attempt the LIKE optimization for non-text columns and a pattern prefix of "-". Ticket [0f0428096f17252a] (check-in: [6fe0367f9a] user: drh branch: trunk, size: 8263)
2019-06-14
12:28
[62bf82ac67] part of check-in [b4a9e09e60] 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: [b4a9e09e60] user: drh branch: trunk, size: 7957)
2019-05-08
19:55
[ac61947ef3] part of check-in [740201107a] Fix another pattern for which the LIKE optimization does not work for a non-TEXT affinity. Case found by Manuel Rigger. (check-in: [740201107a] user: drh branch: trunk, size: 7691)
2019-05-02
01:41
[b065d1ca38] part of check-in [b043a54c3d] 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: [b043a54c3d] user: drh branch: trunk, size: 7430)
2019-04-26
17:08
[d3684b5c60] part of check-in [af53c41a12] Omit tests of the LIKE optimization in like3.test when SQLITE_ENABLE_ICU is defined. (check-in: [af53c41a12] user: dan branch: trunk, size: 7135)
2019-02-27
23:05
[0ce2630e39] part of check-in [6ae4b8c525] Enable the LIKE optimization when the ESCAPE keyword is present and the PRAGMA case_sensitive_like pragma is ON. (check-in: [6ae4b8c525] user: drh branch: trunk, size: 7116)
2018-09-28
23:53
[430691e605] part of check-in [d04b2013b5] Fix test cases so that they work with ICU. (check-in: [d04b2013b5] user: drh branch: trunk, size: 5726)
2018-09-10
12:40
[cf0ff2d06c] part of check-in [f191431d63] 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: [f191431d63] user: drh branch: trunk, size: 5707)
2015-12-01
21:23
[3608a2042b] part of check-in [9e1d6d4c39] Add the SQLITE_LIKE_DOESNT_MATCH_BLOBS compile-time option. (check-in: [9e1d6d4c39] user: drh branch: trunk, size: 4038)
2015-03-07
12:58
[7b0525a39e] part of check-in [50fa3c5fae] New test cases for LIKE and GLOB with BLOB left-hand side values. (check-in: [50fa3c5fae] user: drh branch: like-opt-fix, size: 3984)
02:51
[2fd1fd45cf] part of check-in [564b8fe794] Fix problems with reverse order sorting and indexes in the LIKE optimization. (check-in: [564b8fe794] user: drh branch: like-opt-fix, size: 3604)
00:57
[f6fa86d6a8] part of check-in [26cb5145bf] Refactor some jump opcodes in the VDBE. Add JumpZeroIncr and DecrJumpZero. Fix the LIKE optimization to work with DESC sort order. (check-in: [26cb5145bf] user: drh branch: like-opt-fix, size: 2494)
2015-03-06
20:49
Added: [9c85587224] part of check-in [6b993bd540] Test cases added. Comments fixed. Proposed solution for ticket [05f43be8fdda9fbd9]. (check-in: [6b993bd540] user: drh branch: like-opt-fix, size: 1895)