aboutsummaryrefslogtreecommitdiff
path: root/test
diff options
context:
space:
mode:
authordrh <>2024-10-07 12:19:23 +0000
committerdrh <>2024-10-07 12:19:23 +0000
commitce527f2e971d0c50c779f00fa6a3af61cc94e52e (patch)
tree194eac6ea8594d4ba5322825c2e493941a6328ef /test
parent29f976432a87793d7b9e29fd4ed0209d634113f7 (diff)
downloadsqlite-ce527f2e971d0c50c779f00fa6a3af61cc94e52e.tar.gz
sqlite-ce527f2e971d0c50c779f00fa6a3af61cc94e52e.zip
Fix handling of U+fffd in the LIKE optimization.
dbsqlfuzz eee57fb9eea1dfa5aa40dfa87865cf8c84d12f96. FossilOrigin-Name: bce52ce2a6e7f3d3d1b2807d1ea95243d9b655e557c1bb6f0b8a9a6cefb1aed6
Diffstat (limited to 'test')
-rw-r--r--test/like.test6
1 files changed, 3 insertions, 3 deletions
diff --git a/test/like.test b/test/like.test
index d314e96a1..0d732b569 100644
--- a/test/like.test
+++ b/test/like.test
@@ -731,16 +731,16 @@ ifcapable like_opt&&!icu {
}
do_test like-9.5.1 {
set res [sqlite3_exec_hex db {
- SELECT x FROM t2 WHERE x LIKE '%fe%25'
+ SELECT 1 FROM t2 WHERE x LIKE '%fe%25'
}]
- } {0 {}}
+ } {0 {1 1}}
ifcapable explain {
do_test like-9.5.2 {
set res [sqlite3_exec_hex db {
EXPLAIN QUERY PLAN SELECT x FROM t2 WHERE x LIKE '%fe%25'
}]
regexp {INDEX i2} $res
- } {1}
+ } {0}
}
# Do an SQL statement. Append the search count to the end of the result.