/ Check-in [177862c1]
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:Add a test case of the form "WHERE a<2 OR a<3" using PRAGMA count_changes. This test case was failing before the 3.9.0 release.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 177862c1d50ba899d890fbc35f35e7423bc6aed5
User & Date: drh 2015-12-08 04:18:33
Context
2015-12-08
16:08
Avoid doing comparisons with pointers that might have been previously been passed to realloc() and/or free(). check-in: f20396ad user: drh tags: trunk
14:37
Avoid unnecessary work inside of verifyDbFile() in the unix VFS. Closed-Leaf check-in: f3c0579e user: drh tags: unix-vfs-optimization
04:18
Add a test case of the form "WHERE a<2 OR a<3" using PRAGMA count_changes. This test case was failing before the 3.9.0 release. check-in: 177862c1 user: drh tags: trunk
00:47
Update the TclKit download URL. check-in: 07e5199c user: mistachkin tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/where7.test.

    43     43       INSERT INTO t1 VALUES(4,5,10,15);
    44     44       INSERT INTO t1 VALUES(5,10,100,1000);
    45     45       CREATE INDEX t1b ON t1(b);
    46     46       CREATE INDEX t1c ON t1(c);
    47     47       SELECT * FROM t1;
    48     48     }
    49     49   } {1 2 3 4 2 3 4 5 3 4 6 8 4 5 10 15 5 10 100 1000}
           50  +do_execsql_test where7-1.1.1 {
           51  +  CREATE TABLE t(a);
           52  +  CREATE INDEX ta ON t(a);
           53  +  INSERT INTO t(a) VALUES(1),(2);
           54  +  SELECT * FROM t ORDER BY a;
           55  +  SELECT * FROM t WHERE a<2 OR a<3 ORDER BY a;
           56  +  PRAGMA count_changes=ON;
           57  +  DELETE FROM t WHERE a<2 OR a<3;
           58  +  SELECT * FROM t;
           59  +  PRAGMA count_changes=OFF;
           60  +  DROP TABLE t;
           61  +} {1 2 1 2 2}
    50     62   do_test where7-1.2 {
    51     63     count_steps {
    52     64       SELECT a FROM t1 WHERE b=3 OR c=6 ORDER BY a
    53     65     }
    54     66   } {2 3 scan 0 sort 1}
    55     67   do_test where7-1.3 {
    56     68     count_steps {