/ Check-in [97f8a886]
Login

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

Overview
Comment:Minor changes to test scripts to support various SQLITE_OMIT options.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 97f8a886b6314b044a0522a88f569798fdfb3ef9
User & Date: shaneh 2009-12-31 19:48:29
Context
2009-12-31
20:35
Add comments and an assert() to help clarify the operation of the sqlite3VdbeList() routine used to implement EXPLAIN. check-in: e1ccdb93 user: drh tags: trunk
19:48
Minor changes to test scripts to support various SQLITE_OMIT options. check-in: 97f8a886 user: shaneh tags: trunk
19:06
Changes to remove warnings in MSVC build. check-in: 6cf76c2a user: shaneh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/check.test.

   235    235   } {1 10}
   236    236   do_test check-4.3 {
   237    237     execsql {
   238    238       UPDATE t4 SET x=4, y=3;
   239    239       SELECT * FROM t4
   240    240     }
   241    241   } {4 3}
   242         -do_test check-4.3 {
          242  +do_test check-4.4 {
   243    243     execsql {
   244    244       UPDATE t4 SET x=12, y=2;
   245    245       SELECT * FROM t4
   246    246     }
   247    247   } {12 2}
   248         -do_test check-4.4 {
          248  +do_test check-4.5 {
   249    249     execsql {
   250    250       UPDATE t4 SET x=12, y=-22;
   251    251       SELECT * FROM t4
   252    252     }
   253    253   } {12 -22}
   254         -do_test check-4.5 {
          254  +do_test check-4.6 {
   255    255     catchsql {
   256    256       UPDATE t4 SET x=0, y=1;
   257    257     }
   258    258   } {1 {constraint failed}}
   259         -do_test check-4.6 {
          259  +do_test check-4.7 {
   260    260     execsql {
   261    261       SELECT * FROM t4;
   262    262     }
   263    263   } {12 -22}
   264         -do_test check-4.7 {
          264  +do_test check-4.8 {
   265    265     execsql {
   266    266       PRAGMA ignore_check_constraints=ON;
   267    267       UPDATE t4 SET x=0, y=1;
   268    268       SELECT * FROM t4;
   269    269     }
   270    270   } {0 1}
   271         -do_test check-4.8 {
          271  +do_test check-4.9 {
   272    272     catchsql {
   273    273       PRAGMA ignore_check_constraints=OFF;
   274    274       UPDATE t4 SET x=0, y=2;
   275    275     }
   276    276   } {1 {constraint failed}}
   277    277   ifcapable vacuum {
   278         -  do_test check_4.9 {
          278  +  do_test check_4.10 {
   279    279       catchsql {
   280    280         VACUUM
   281    281       }
   282    282     } {0 {}}
   283    283   }
   284    284   
   285    285   do_test check-5.1 {

Changes to test/fuzz2.test.

    61     61   } {1}
    62     62   do_test fuzz2-2.11 {
    63     63     fuzzcatch {UPDATE OR IGNORE "AAAAAA" . "AAAAAA" SET "AAAAAA" = NOT #96}
    64     64   } {1}
    65     65   do_test fuzz2-2.12 {
    66     66     fuzzcatch {SELECT - #196}
    67     67   } {1}
           68  +
           69  +ifcapable {trigger} {  # Only do the following tests if triggers are enabled
           70  +
    68     71   do_test fuzz2-3.0 {
    69     72     fuzzcatch {CREATE TRIGGER "AAAAAA" . "AAAAAA" AFTER UPDATE OF "AAAAAA" , "AAAAAA" ON "AAAAAA" . "AAAAAA" FOR EACH ROW BEGIN UPDATE AAAAAA SET "AAAAAA" = #162;  END}
    70     73   } {1}
    71     74   do_test fuzz2-3.1 {
    72     75     fuzzcatch {CREATE TRIGGER IF NOT EXISTS "AAAAAA" UPDATE ON "AAAAAA" . AAAAAA FOR EACH ROW BEGIN DELETE FROM "AAAAAA" ; INSERT INTO AAAAAA ( "AAAAAA" ) SELECT DISTINCT "AAAAAA" "AAAAAA" , #167 AAAAAA , "AAAAAA" . * ORDER BY "AAAAAA" ASC , x'414141414141' BETWEEN RAISE ( FAIL , "AAAAAA" ) AND AAAAAA ( * ) NOT NULL DESC LIMIT AAAAAA ; REPLACE INTO AAAAAA ( AAAAAA ) VALUES ( AAAAAA ( * ) ) ; END}
    73     76   } {1}
    74     77   do_test fuzz2-3.2 {
    75     78     fuzzcatch {CREATE TEMP TRIGGER IF NOT EXISTS AAAAAA . "AAAAAA" BEFORE UPDATE OF "AAAAAA" ON AAAAAA . "AAAAAA" BEGIN SELECT ALL * , #175 "AAAAAA" FROM "AAAAAA" . AAAAAA;  END}
    76     79   } {1}
           80  +
           81  +} ;# End of ifcapable {trigger}
           82  +
    77     83   do_test fuzz2-4.0 {
    78     84     fuzzcatch {ATTACH DATABASE #168 AS whatever}
    79     85   } {1}
    80     86   do_test fuzz2-4.1 {
    81     87     fuzzcatch {DETACH #133}
    82     88   } {1}
    83     89   do_test fuzz2-5.0 {

Changes to test/schema.test.

   359    359   
   360    360     # The schema cookie now has the same value as it did when SQL statement
   361    361     # $::STMT was prepared. So unless it has been expired, it would be
   362    362     # possible to run the "CREATE TABLE t4" statement and create a
   363    363     # duplicate table.
   364    364     list [sqlite3_step $::STMT] [sqlite3_finalize $::STMT]
   365    365   } {SQLITE_ERROR SQLITE_SCHEMA}
          366  +
          367  +ifcapable {auth} {
   366    368   
   367    369   do_test schema-13.1 {
   368    370     set S [sqlite3_prepare_v2 db "SELECT * FROM sqlite_master" -1 dummy]
   369    371     db function hello hello
   370    372     db function hello {}
   371    373     db auth auth
   372    374     proc auth {args} {
................................................................................
   379    381   do_test schema-13.2 {
   380    382     sqlite3_step $S
   381    383   } {SQLITE_SCHEMA}
   382    384   
   383    385   do_test schema-13.3 {
   384    386     sqlite3_finalize $S
   385    387   } {SQLITE_SCHEMA}
          388  +
          389  +}
   386    390   
   387    391   finish_test

Changes to test/tkt-3fe897352e.test.

    12     12   #
    13     13   # This file implements tests to verify that ticket [3fe897352e8d8] has been
    14     14   # fixed.  
    15     15   #
    16     16   
    17     17   set testdir [file dirname $argv0]
    18     18   source $testdir/tester.tcl
           19  +
           20  +# The following tests use hex_to_utf16be() and hex_to_utf16le() which 
           21  +# which are only available if SQLite is built with UTF16 support.
           22  +ifcapable {!utf16} {
           23  +  finish_test
           24  +  return
           25  +}
    19     26   
    20     27   do_test tkt-3fe89-1.1 {
    21     28     db close
    22     29     sqlite3 db :memory:
    23     30     db eval {
    24     31       PRAGMA encoding=UTF8;
    25     32       CREATE TABLE t1(x);