drh
b7a002f836
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].
FossilOrigin-Name: f191431d63aba187000b5cbaf3e072ff5f1b1eef6a2a407fb4d1629bda4e4e8f
2018-09-10 12:40:57 +00:00
drh
41d2e66ef3
Add the SQLITE_LIKE_DOESNT_MATCH_BLOBS compile-time option.
...
FossilOrigin-Name: 9e1d6d4c391ff90077f0d1cdeb567969fee9f747
2015-12-01 21:23:07 +00:00
drh
560b7c72be
New test cases for LIKE and GLOB with BLOB left-hand side values.
...
FossilOrigin-Name: 50fa3c5fae90bd3b2f4121e99ab52d79963a6fda
2015-03-07 12:58:52 +00:00
drh
b7c60ba668
Fix problems with reverse order sorting and indexes in the LIKE optimization.
...
FossilOrigin-Name: 564b8fe79475d7584a21078e6098840b8ce6a6e1
2015-03-07 02:51:59 +00:00
drh
16897072b5
Refactor some jump opcodes in the VDBE. Add JumpZeroIncr and DecrJumpZero.
...
Fix the LIKE optimization to work with DESC sort order.
FossilOrigin-Name: 26cb5145bf52f8c3fffa8c69b6c24aee4d974883
2015-03-07 00:57:37 +00:00
drh
a9c18a9067
Test cases added. Comments fixed. Proposed solution for
...
ticket [05f43be8fdda9fbd9].
FossilOrigin-Name: 6b993bd54035b67f4d84941e3f444ca79b7feee1
2015-03-06 20:49:52 +00:00
