/ Check-in [29d02bf2]
Login

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

Overview
Comment:Reformat the white-space in a few test cases so that the tests work with Tcl 8.6.9.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 29d02bf2fa9ecacbcc3e862ca70382f5875da8c1dc7fd27366190045fcc42b15
User & Date: dan 2019-02-26 19:16:49
Context
2019-02-27
15:26
Verify that fts5 auxiliary functions cannot be used in aggregate queries. check-in: 122330db user: dan tags: trunk
2019-02-26
19:16
Reformat the white-space in a few test cases so that the tests work with Tcl 8.6.9. check-in: 29d02bf2 user: dan tags: trunk
18:21
Minor change to dbfuzz2 that allows it to be compiled against older versions of SQLite. check-in: 6d39d6a6 user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to ext/session/sessionB.test.

   254    254   }
   255    255   
   256    256   # INSERT + DELETE 
   257    257   do_patchconcat_test 4.3.3 {
   258    258     INSERT INTO t2 VALUES('a', 'a', 'a', 'a');
   259    259   } {
   260    260     DELETE FROM t2 WHERE c = 'a';
   261         -} {
   262         -}
          261  +} {}
   263    262   
   264    263   # INSERT + UPDATE
   265    264   do_patchconcat_test 4.3.4 {
   266    265     INSERT INTO t2 VALUES('a', 'a', 'a', 'a');
   267    266   } {
   268    267     UPDATE t2 SET d = 'b' WHERE c='a';
   269    268   } {

Changes to test/fts3expr4.test.

    64     64     AND {PHRASE 3 0 lol+} {PHRASE 3 0 h4h+}
    65     65   }
    66     66   
    67     67   do_icu_expr_test 3.2 {*lOl* *h4h*} {
    68     68     AND {AND {AND {PHRASE 3 0 *} {PHRASE 3 0 lol+}} {PHRASE 3 0 *}} {PHRASE 3 0 h4h+}
    69     69   }
    70     70   
    71         -do_simple_expr_test 3.3 { * }    { }
           71  +do_simple_expr_test 3.3 { * }    {}
    72     72   do_simple_expr_test 3.4 { *a }   { PHRASE 3 0 a }
    73     73   do_simple_expr_test 3.5 { a*b }  { AND {PHRASE 3 0 a+} {PHRASE 3 0 b} }
    74     74   do_simple_expr_test 3.6 { *a*b } { AND {PHRASE 3 0 a+} {PHRASE 3 0 b} }
    75     75   do_simple_expr_test 3.7 { *"abc" } { PHRASE 3 0 abc }
    76     76   do_simple_expr_test 3.8 { "abc"* } { PHRASE 3 0 abc }
    77     77   do_simple_expr_test 3.8 { "ab*c" } { PHRASE 3 0 ab+ c }
    78     78   
    79     79   do_icu_expr_test    3.9 { "ab*c" } { PHRASE 3 0 ab+ * c }
    80     80   do_icu_expr_test    3.10 { ab*c } { AND {PHRASE 3 0 ab+} {PHRASE 3 0 c}}
    81     81   
    82     82   finish_test

Changes to test/scanstatus.test.

   250    250       SELECT * FROM t2 WHERE x BETWEEN 20 AND 40;
   251    251     END;
   252    252     WITH d(x) AS (SELECT 1 UNION ALL SELECT x+1 AS n FROM d WHERE n<=100)
   253    253     INSERT INTO t2 SELECT x, x*2, x*3 FROM d;
   254    254   }
   255    255   
   256    256   do_execsql_test    4.1.1 { INSERT INTO t1 VALUES(1, 2, 3); }
   257         -do_scanstatus_test 4.1.2 { }
          257  +do_scanstatus_test 4.1.2 {}
   258    258   
   259    259   do_execsql_test 4.2 {
   260    260     CREATE TABLE p1(x PRIMARY KEY);
   261    261     INSERT INTO p1 VALUES(1), (2), (3), (4);
   262    262     CREATE TABLE c1(y REFERENCES p1);
   263    263     INSERT INTO c1 VALUES(1), (2), (3);
   264    264     PRAGMA foreign_keys=on;