SQLite

All files named ”test/triggerC.test”
Login

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

History for test/triggerC.test

2019-08-08
15:24
[29f5a28d0f] part of check-in [1e17ea2fd1] Remove support for STAT3. The sqlite_stat3 tables are ignored, if they exist. STAT4 continues to work as it always has, and as it is a superset of STAT3 is the recommended replacement. (check-in: [1e17ea2fd1] user: drh branch: omit-stat3, size: 32531)
2019-04-04
17:58
[f121092192] part of check-in [4cef609d61] Add test cases to improve coverage of VDBE branches. Still some to go. (check-in: [4cef609d61] user: dan branch: trunk, size: 32532)
2018-12-20
15:04
[c7fbc3eb24] part of check-in [ddf06db702] Fix a segfault caused by using the RAISE function incorrectly (library now returns an error instead of crashing). (check-in: [ddf06db702] user: dan branch: trunk, size: 32153)
2015-05-21
02:20
[a8fad3c4c8] part of check-in [9e3f64a4f4] Ensure that tables names are dequoted exactly once by the trigger logic. Cherrypick [59e92bd9521f1e8] and [9d887b92f8086961e]. (check-in: [9e3f64a4f4] user: drh branch: branch-3.7.11, size: 30137)
2015-04-21
16:38
[302d8995f5] part of check-in [9d887b92f8] Ensure that tables names are dequoted exactly once by the trigger logic. (check-in: [9d887b92f8] user: dan branch: trunk, size: 31641)
2013-11-05
13:33
[a68980c595] part of check-in [54b2219297] Standardize the error messages generated by constraint failures to a format of "$TYPE constraint failed: $DETAIL". This involves many changes to the expected output of test cases. (check-in: [54b2219297] user: drh branch: omit-rowid, size: 30274)
2012-12-06
20:27
[c9e59c1c88] part of check-in [34aafb7436] Cherrypick [79ef8e3c77] (Apply the same restrictions on constant refactoring to statements within a trigger program as top-level statements). (check-in: [34aafb7436] user: dan branch: branch-3.7.9, size: 30150)
19:37
[a7b4367392] part of check-in [0c31a46801] Apply the same restrictions on constant refactoring to statements within a trigger program as top-level statements. Candidate fix for [ae3c5670b6]. (check-in: [0c31a46801] user: dan branch: constant-refactoring-in-triggers, size: 30270)
2012-09-15
18:45
[29173df06f] part of check-in [cfaa7bc128] Attempt to use a covering index even on a full table scan, under the theory that the index will be smaller and require less disk I/O and thus be faster. (check-in: [cfaa7bc128] user: drh branch: fullscan-covering-index, size: 28890)
2011-08-02
00:57
[4d4bdaf023] part of check-in [9007586fda] Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried. (check-in: [9007586fda] user: mistachkin branch: winopen-retry-logic, size: 28770)
2011-06-22
14:43
[02c690febf] part of check-in [f14339c54b] Adjust a test case in triggerC.test to handle non-default SQLITE_MAX_TRIGGER_DEPTH settings. (check-in: [f14339c54b] user: shaneh branch: trunk, size: 28777)
2011-04-17
00:55
[811ab569af] part of check-in [9d6c6129fd] Adjust some test cases in triggerC.test to handle non-default SQLITE_MAX_TRIGGER_DEPTH settings. (check-in: [9d6c6129fd] user: shaneh branch: trunk, size: 28706)
2010-12-01
08:04
[8a691ff6dd] part of check-in [119ffe955e] Avoid recursive calls to sqlite3VdbeMemRelease() when deleting VM frames used by trigger programs. (check-in: [119ffe955e] user: dan branch: trunk, size: 27973)
2010-08-14
05:04
[2a23edcc00] part of check-in [d4ec61e254] Test that it is possible to drop a trigger while there are active statements belonging to the same connection. (check-in: [d4ec61e254] user: dan branch: trunk, size: 27638)
2010-03-30
12:40
[cac41fe31a] part of check-in [ca359a3e80] Do not crash when compiling an "INSERT INTO tbl DEFAULT VALUES" when tbl has either BEFORE or INSTEAD OF triggers attached to it. Ticket [f3162063fd]. (check-in: [ca359a3e80] user: dan branch: trunk, size: 27132)
2009-11-27
12:12
[4083c64d80] part of check-in [1b7c5250cc] Move [7d30880114] to the trunk. Add optimizations to reduce the number of opcodes used for BEFORE UPDATE triggers. (check-in: [1b7c5250cc] user: dan branch: trunk, size: 25436)
2009-10-08
06:24
[0acc1d22d9] part of check-in [5806925283] Update triggerC.test to match the change to the way the trigger-recursion limit is handled. (check-in: [5806925283] user: dan branch: trunk, size: 22923)
2009-09-17
00:41
[4b1c11936b] part of check-in [03e464be51] When coding a trigger, assume that the "oldmask" requires all columns until we know otherwise. That pessimistic assumption assures that all necessary parameters are available on a cascading delete trigger. Ticket [e25d9ea771f] (check-in: [03e464be51] user: drh branch: trunk, size: 22923)
2009-09-09
15:06
[1ee7e3a78a] part of check-in [9a4c59a2dd] Add some tests that involve BEFORE UPDATE or BEFORE DELETE triggers messing with the row being updated or deleted. SQLite behaviour in this scenario is undefined, so the tests just check that the behaviour is relatively sane and there are no crashes. (check-in: [9a4c59a2dd] user: dan branch: trunk, size: 22312)
2009-09-08
19:15
[427f3036f0] part of check-in [aec9dbd8d2] Combine the OP_Statement and OP_Transaction opcodes. (check-in: [aec9dbd8d2] user: dan branch: trunk, size: 20255)
15:55
[3e13e9a879] part of check-in [85cb0c94a6] If recursive-triggers are enabled, fire DELETE triggers if database rows are removed as a result of OR REPLACE conflict resolution. (check-in: [85cb0c94a6] user: dan branch: trunk, size: 19870)
2009-09-07
18:14
[cc43b4a62f] part of check-in [d7dc8b4336] Add the SQLITE_LIMIT_TRIGGER_DEPTH option to sqlite3_limit(). (check-in: [d7dc8b4336] user: drh branch: trunk, size: 15679)
2009-09-01
17:11
[6ee1611c7e] part of check-in [e016cca363] Change "PRAGMA disable_recursive_triggers" to "PRAGMA recursive_triggers". Also a fix for compiling with OMIT_TRIGGER defined. (check-in: [e016cca363] user: dan branch: trunk, size: 13950)
16:19
Added: [3806d257b3] part of check-in [a2a062a4b5] Add new test script triggerC.test. (check-in: [a2a062a4b5] user: dan branch: trunk, size: 13957)