/ Check-in [b90c3c16]
Login

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

Overview
Comment:Fix some test case numbers in expert1.test.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256:b90c3c16c04589583d2d1619320bb45a0b012c5960f23bd4e3f9dbe7c84b2eae
User & Date: dan 2018-06-13 16:08:22
Context
2018-06-13
16:52
Pad out the sqlite3_value structure to be a multiple of 8 bytes. check-in: f76dc33b user: drh tags: trunk
16:08
Fix some test case numbers in expert1.test. check-in: b90c3c16 user: dan tags: trunk
11:41
Unless SQLITE_OMIT_AUTOINIT is defined, allow sqlite3_vfs_unregister() to be called before sqlite3_initialize(). check-in: ab6c1ae4 user: dan tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to ext/expert/expert1.test.

   328    328     $expert destroy
   329    329   
   330    330     uplevel [list do_test $tn [list set {} $candidates] $res]
   331    331   }
   332    332   
   333    333   
   334    334   reset_db
   335         -do_execsql_test 3.0 {
          335  +do_execsql_test 4.0 {
   336    336     CREATE TABLE t1(a, b);
   337    337     CREATE TABLE t2(c, d);
   338    338   
   339    339     WITH s(i) AS ( VALUES(1) UNION ALL SELECT i+1 FROM s WHERE i<100)
   340    340     INSERT INTO t1 SELECT (i-1)/50, (i-1)/20 FROM s;
   341    341   
   342    342     WITH s(i) AS ( VALUES(1) UNION ALL SELECT i+1 FROM s WHERE i<100)
   343    343     INSERT INTO t2 SELECT (i-1)/20, (i-1)/5 FROM s;
   344    344   }
   345         -do_candidates_test 3.1 {
          345  +do_candidates_test 4.1 {
   346    346     SELECT * FROM t1,t2 WHERE (b=? OR a=?) AND (c=? OR d=?)
   347    347   } {
   348    348     CREATE INDEX t1_idx_00000062 ON t1(b); -- stat1: 100 20 
   349    349     CREATE INDEX t1_idx_00000061 ON t1(a); -- stat1: 100 50 
   350    350     CREATE INDEX t2_idx_00000063 ON t2(c); -- stat1: 100 20 
   351    351     CREATE INDEX t2_idx_00000064 ON t2(d); -- stat1: 100 5
   352    352   }
   353    353   
   354         -do_candidates_test 3.2 {
          354  +do_candidates_test 4.2 {
   355    355     SELECT * FROM t1,t2 WHERE a=? AND b=? AND c=? AND d=?
   356    356   } {
   357    357     CREATE INDEX t1_idx_000123a7 ON t1(a, b); -- stat1: 100 50 17
   358    358     CREATE INDEX t2_idx_0001295b ON t2(c, d); -- stat1: 100 20 5
   359    359   }
   360    360   
   361         -do_execsql_test 3.2 {
          361  +do_execsql_test 4.3 {
   362    362     CREATE INDEX t1_idx_00000061 ON t1(a); -- stat1: 100 50 
   363    363     CREATE INDEX t1_idx_00000062 ON t1(b); -- stat1: 100 20 
   364    364     CREATE INDEX t1_idx_000123a7 ON t1(a, b); -- stat1: 100 50 16
   365    365   
   366    366     CREATE INDEX t2_idx_00000063 ON t2(c); -- stat1: 100 20 
   367    367     CREATE INDEX t2_idx_00000064 ON t2(d); -- stat1: 100 5
   368    368     CREATE INDEX t2_idx_0001295b ON t2(c, d); -- stat1: 100 20 5