/ Check-in [58069252]
Login

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

Overview
Comment:Update triggerC.test to match the change to the way the trigger-recursion limit is handled.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1:5806925283b889867567c4ad92518bad000e9d9d
User & Date: dan 2009-10-08 06:24:41
Context
2009-10-08
11:57
Add tests to test/e_fkey.test. check-in: 533703d7 user: dan tags: trunk
06:24
Update triggerC.test to match the change to the way the trigger-recursion limit is handled. check-in: 58069252 user: dan tags: trunk
01:43
Fix a segfault that can occur following an OOM fault while renaming a table holding foreign key constraints. check-in: 33973814 user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/triggerC.test.

   300    300   } {1 {too many levels of trigger recursion}}
   301    301   do_test triggerC-3.2.2 {
   302    302     db eval {SELECT * FROM t3b}
   303    303   } {}
   304    304   
   305    305   do_test triggerC-3.3.1 {
   306    306     catchsql {
   307         -    INSERT INTO t3b VALUES(1000);
          307  +    INSERT INTO t3b VALUES(1001);
   308    308     }
   309    309   } {0 {}}
   310    310   do_test triggerC-3.3.2 {
   311    311     db eval {SELECT count(*), max(x), min(x) FROM t3b}
   312         -} {1001 2000 1000}
          312  +} {1000 2000 1001}
   313    313   
   314    314   do_test triggerC-3.4.1 {
   315    315     catchsql {
   316    316       DELETE FROM t3b;
   317    317       INSERT INTO t3b VALUES(999);
   318    318     }
   319    319   } {1 {too many levels of trigger recursion}}
................................................................................
   320    320   do_test triggerC-3.4.2 {
   321    321     db eval {SELECT count(*), max(x), min(x) FROM t3b}
   322    322   } {0 {} {}}
   323    323   
   324    324   do_test triggerC-3.5.1 {
   325    325     sqlite3_limit db SQLITE_LIMIT_TRIGGER_DEPTH 100
   326    326     catchsql {
   327         -    INSERT INTO t3b VALUES(1900);
          327  +    INSERT INTO t3b VALUES(1901);
   328    328     }
   329    329   } {0 {}}
   330    330   do_test triggerC-3.5.2 {
   331    331     db eval {SELECT count(*), max(x), min(x) FROM t3b}
   332         -} {101 2000 1900}
          332  +} {100 2000 1901}
   333    333   
   334    334   do_test triggerC-3.5.3 {
   335    335     catchsql {
   336    336       DELETE FROM t3b;
   337         -    INSERT INTO t3b VALUES(1899);
          337  +    INSERT INTO t3b VALUES(1900);
   338    338     }
   339    339   } {1 {too many levels of trigger recursion}}
   340    340   do_test triggerC-3.5.4 {
   341    341     db eval {SELECT count(*), max(x), min(x) FROM t3b}
   342    342   } {0 {} {}}
   343    343   
   344    344   do_test triggerC-3.6.1 {
   345    345     sqlite3_limit db SQLITE_LIMIT_TRIGGER_DEPTH 1
   346    346     catchsql {
   347         -    INSERT INTO t3b VALUES(1999);
          347  +    INSERT INTO t3b VALUES(2000);
   348    348     }
   349    349   } {0 {}}
   350    350   do_test triggerC-3.6.2 {
   351    351     db eval {SELECT count(*), max(x), min(x) FROM t3b}
   352         -} {2 2000 1999}
          352  +} {1 2000 2000}
   353    353   
   354    354   do_test triggerC-3.6.3 {
   355    355     catchsql {
   356    356       DELETE FROM t3b;
   357         -    INSERT INTO t3b VALUES(1998);
          357  +    INSERT INTO t3b VALUES(1999);
   358    358     }
   359    359   } {1 {too many levels of trigger recursion}}
   360    360   do_test triggerC-3.6.4 {
   361    361     db eval {SELECT count(*), max(x), min(x) FROM t3b}
   362    362   } {0 {} {}}
   363    363   sqlite3_limit db SQLITE_LIMIT_TRIGGER_DEPTH 1000
   364    364