/ Check-in [c4db5b64]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Modifications to the "like.test" script in order to expose the problem reported by ticket [25ee81271091ec27a8c5].
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: c4db5b640638a211b096454ba90b58faf595392b
User & Date: drh 2011-06-26 23:44:35
Context
2011-06-27
00:01
Make sure all new statements begin life unexpired, even if they registered functions or did other actions during preparation that would have expired all statements. Fix for ticket [25ee81271091] check-in: faa38c87 user: drh tags: trunk
2011-06-26
23:44
Modifications to the "like.test" script in order to expose the problem reported by ticket [25ee81271091ec27a8c5]. check-in: c4db5b64 user: drh tags: trunk
2011-06-25
01:14
Support using nmake via cmd.exe, allow Tcl related variables to be overridden via the environment, and add 'dll' to the 'all' target. check-in: 0cb0f306 user: mistachkin tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/like.test.

    66     66   } {ABC abc}
    67     67   do_test like-1.4 {
    68     68     execsql {
    69     69       SELECT x FROM t1 WHERE x LIKE 'aBc' ORDER BY 1;
    70     70     }
    71     71   } {ABC abc}
    72     72   do_test like-1.5.1 {
           73  +  # Use sqlite3_exec() to verify fix for ticket [25ee81271091] 2011-06-26
           74  +  sqlite3_exec db {PRAGMA case_sensitive_like=on}
           75  +} {0 {}}
           76  +do_test like-1.5.2 {
    73     77     execsql {
    74         -    PRAGMA case_sensitive_like=on;
    75     78       SELECT x FROM t1 WHERE x LIKE 'abc' ORDER BY 1;
    76     79     }
    77     80   } {abc}
    78         -do_test like-1.5.2 {
           81  +do_test like-1.5.3 {
    79     82     execsql {
    80     83       PRAGMA case_sensitive_like; -- no argument; does not change setting
    81     84       SELECT x FROM t1 WHERE x LIKE 'abc' ORDER BY 1;
    82     85     }
    83     86   } {abc}
    84     87   do_test like-1.6 {
    85     88     execsql {