/ Check-in [51a95e52]
Login

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

Overview
Comment:Add further test cases to improve VDBE branch coverage.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 51a95e52fc58d8be2c9c51576dff7258c705735b66d203948f80db017b4c10d2
User & Date: dan 2019-04-04 20:55:37
Context
2019-04-05
15:44
In the xfer-optimization, do early detection of when the source and destination index share the same btree, to avoid a long delay prior to reporting the database corruption. check-in: af1e5873 user: drh tags: trunk
2019-04-04
21:40
Merge all the latest changes and enhancements from trunk. check-in: 521d5186 user: drh tags: apple-osx
20:55
Add further test cases to improve VDBE branch coverage. check-in: 51a95e52 user: dan tags: trunk
19:21
Fix a typo in the documentation for sqlite3_value_frombind(). Also add a new hyperlink to that same documentation. No code changes. check-in: bf3cd936 user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/in.test.

   709    709                              WHERE name='Bob'
   710    710                            ) AS 't'
   711    711                      WHERE x=1
   712    712                    )
   713    713                AND t6.id IN (1,id)
   714    714            );
   715    715   } {1 Alice}
          716  +
          717  +#-------------------------------------------------------------------------
          718  +reset_db
          719  +do_execsql_test in-16.0 {
          720  +  CREATE TABLE x1(a, b);
          721  +  INSERT INTO x1(a) VALUES(1), (2), (3), (4), (5), (6);
          722  +  CREATE INDEX x1i ON x1(a, b);
          723  +}
          724  +
          725  +do_execsql_test in-16.1 {
          726  +  SELECT * FROM x1 
          727  +  WHERE a IN (SELECT a FROM x1 WHERE (a%2)==0) 
          728  +  ORDER BY a DESC, b;
          729  +} {6 {} 4 {} 2 {}}
          730  +
          731  +do_execsql_test in-16.2 {
          732  +  SELECT * FROM x1 
          733  +  WHERE a IN (SELECT a FROM x1 WHERE (a%7)==0) 
          734  +  ORDER BY a DESC, b;
          735  +} {}
          736  +
   716    737   
   717    738   
   718    739   finish_test

Changes to test/skipscan2.test.

   196    196       execsql { INSERT INTO t3 VALUES($i%2, $i, 'xyz') }
   197    197     }
   198    198     execsql { ANALYZE }
   199    199   } {}
   200    200   do_eqp_test skipscan2-3.3eqp {
   201    201     SELECT * FROM t3 WHERE b=42;
   202    202   } {SEARCH TABLE t3 USING PRIMARY KEY (ANY(a) AND b=?)}
          203  +
   203    204   
   204    205   
   205    206   finish_test

Changes to test/without_rowid1.test.

   375    375   } {1 {UNIQUE constraint failed: t1.c}}
   376    376   do_catchsql_test 10.3 {
   377    377     UPDATE t1 SET c=1 WHERE (a, b) = ('b', 'a');
   378    378   } {1 {UNIQUE constraint failed: t1.c}}
   379    379   do_catchsql_test 10.4 {
   380    380     UPDATE t1 SET c=1 WHERE (a, b) = ('b', 'b');
   381    381   } {1 {UNIQUE constraint failed: t1.c}}
          382  +do_catchsql_test 10.5 {
          383  +  UPDATE t1 SET c=1 WHERE (a, b) = ('c', 'c');
          384  +} {0 {}}
          385  +
          386  +do_execsql_test 10.6 {
          387  +  CREATE TRIGGER t1_tr BEFORE UPDATE ON t1 BEGIN
          388  +    DELETE FROM t1 WHERE a = new.a;
          389  +  END;
          390  +  UPDATE t1 SET c = c+1 WHERE a = 'a';
          391  +  SELECT * FROM t1;
          392  +} {b a 3  b b 4}
   382    393   
   383    394     
   384    395   finish_test