Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Disable tests for the LIKE optimization when ICU is enabled, since the LIKE optimization only works for the built-in LIKE operator and ICU overrides the built-in. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
f5ef2e1bcd2790f960c15947f87cda19 |
| User & Date: | drh 2017-09-27 16:51:00 |
Context
|
2017-09-28
| ||
| 00:01 | In two places, change the magic number -1 to its proper symbol XN_ROWID. check-in: 80277d2f user: drh tags: trunk | |
|
2017-09-27
| ||
| 16:51 | Disable tests for the LIKE optimization when ICU is enabled, since the LIKE optimization only works for the built-in LIKE operator and ICU overrides the built-in. check-in: f5ef2e1b user: drh tags: trunk | |
|
2017-09-25
| ||
| 09:37 | Add an extra snapshot related test case. check-in: 24a95e14 user: dan tags: trunk | |
Changes
Changes to test/like.test.
1044
1045
1046
1047
1048
1049
1050
1051
1052
1053
1054
1055
1056
1057
....
1088
1089
1090
1091
1092
1093
1094
1095
1096
1097
1098
1099
|
db one {SELECT 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaz'LIKE'%a%a%a%a%a%a%a%a%y'}
}] 0]
puts -nonewline " ($x ms - want less than 1000) "
expr {$x<1000}
} {1}
}
# As of 2017-07-27 (3.21.0) the LIKE optimization works with ESCAPE as
# long as the ESCAPE is a single-byte literal.
#
db close
sqlite3 db :memory:
do_execsql_test like-15.100 {
CREATE TABLE t15(x TEXT COLLATE nocase, y, PRIMARY KEY(x));
................................................................................
do_execsql_test like-15.120 {
SELECT y FROM t15 WHERE x LIKE '/%bc%' ESCAPE '/';
} {22}
do_execsql_test like-15.121 {
EXPLAIN QUERY PLAN
SELECT y FROM t15 WHERE x LIKE '/%bc%' ESCAPE '/';
} {/SEARCH/}
finish_test
|
>
|
<
<
|
1044
1045
1046
1047
1048
1049
1050
1051
1052
1053
1054
1055
1056
1057
1058
....
1089
1090
1091
1092
1093
1094
1095
1096
1097
1098
|
db one {SELECT 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaz'LIKE'%a%a%a%a%a%a%a%a%y'}
}] 0]
puts -nonewline " ($x ms - want less than 1000) "
expr {$x<1000}
} {1}
}
ifcapable !icu {
# As of 2017-07-27 (3.21.0) the LIKE optimization works with ESCAPE as
# long as the ESCAPE is a single-byte literal.
#
db close
sqlite3 db :memory:
do_execsql_test like-15.100 {
CREATE TABLE t15(x TEXT COLLATE nocase, y, PRIMARY KEY(x));
................................................................................
do_execsql_test like-15.120 {
SELECT y FROM t15 WHERE x LIKE '/%bc%' ESCAPE '/';
} {22}
do_execsql_test like-15.121 {
EXPLAIN QUERY PLAN
SELECT y FROM t15 WHERE x LIKE '/%bc%' ESCAPE '/';
} {/SEARCH/}
}
finish_test
|