/ Check-in [0953e746]
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

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: 0953e74612358f48a9c9e3772876b514bc79784f277497121c59302a3106110c
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: 5ec37c62 user: drh tags: trunk
13:35
First release candidate for version 3.20.0. check-in: 035a86ec user: drh tags: branch-3.20
08:02
Fix another minor problem in test file like.test. check-in: 0953e746 user: dan tags: trunk
06:35
Fix test problems causing the "prepare" permutation test to fail. check-in: b61cc5a0 user: dan tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

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