Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix another minor problem in test file like.test. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
0953e74612358f48a9c9e3772876b514 |
| User & Date: | dan 2017-07-15 08:02:10 |
Context
|
2017-07-15
| ||
| 17:57 | Enhance the showstat4 utility program to show the full precision of floating point values in sqlite_stat4 tables. (check-in: 5ec37c62f6 user: drh tags: trunk) | |
| 13:35 | First release candidate for version 3.20.0. (check-in: 035a86ec3e user: drh tags: branch-3.20) | |
| 08:02 | Fix another minor problem in test file like.test. (check-in: 0953e74612 user: dan tags: trunk) | |
| 06:35 | Fix test problems causing the "prepare" permutation test to fail. (check-in: b61cc5a0f9 user: dan tags: trunk) | |
Changes
Changes to test/like.test.
213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 |
# The like optimization works even when the pattern is a bound parameter
#
# Exception: It does not work if sqlite3_prepare() is used instead of
# sqlite3_prepare_v2(), as in that case the statement cannot be reprepared
# after the parameter is bound.
#
set ::likepat abc%
if {[permutation]!="prepare"} {
do_test like-3.3.102 {
set sqlite_like_count 0
unset -nocomplain ::likepat
queryplan {
SELECT x FROM t1 WHERE x LIKE $::likepat ORDER BY 1;
}
} {abc abcd nosort {} i1}
do_test like-3.3.103 {
set sqlite_like_count
} 0
|
> < |
213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 |
# The like optimization works even when the pattern is a bound parameter
#
# Exception: It does not work if sqlite3_prepare() is used instead of
# sqlite3_prepare_v2(), as in that case the statement cannot be reprepared
# after the parameter is bound.
#
unset -nocomplain ::likepat
set ::likepat abc%
if {[permutation]!="prepare"} {
do_test like-3.3.102 {
set sqlite_like_count 0
queryplan {
SELECT x FROM t1 WHERE x LIKE $::likepat ORDER BY 1;
}
} {abc abcd nosort {} i1}
do_test like-3.3.103 {
set sqlite_like_count
} 0
|