/ History for test/trigger1.test
Login

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

History for test/trigger1.test

2020-01-04
15:21
[d30cd09a] part of check-in [9da48a5c] Fix a false-positive in the register validity tracking logic by moving the temporary register release call before the jump that uses that temporary register. (check-in: [9da48a5c] user: drh branch: trunk, size: 22678)
2019-10-24
19:35
[746dc327] part of check-in [521f1d36] Correction to check-in [bec5b6d4d083556d] so that it detects *all* triggers that might perturb the insertion cursor. Ticket [50c09fc2cf0d91ce]. (check-in: [521f1d36] user: drh branch: trunk, size: 21768)
2019-08-27
10:05
[6be279c9] part of check-in [069c2f4c] If a TEMP TRIGGER references an auxiliary schema, and that auxiliary schema is detached, move the trigger to reference the TEMP schema before completing the detach, so that the trigger does not hold a dangling schema pointer. Ticket [ac8dd4a32ba4322f] (check-in: [069c2f4c] user: drh branch: trunk, size: 21363)
2018-04-26
18:34
[17e4b43e] part of check-in [9fd0faf5] The previous fix for ticket [d85fffd6ffe856092ed8da] in check-in [0a514e62ad1ebe5c12da8dae] did not completely address the probably in that it only worked for cases where the OP_SCopy that loaded the register was the last instruction in the sequence for the expression, which is not necessarily the case for expressions like CASE...END. This revision prevents the registered that will be recomputed from being cached in the first place. (check-in: [9fd0faf5] user: drh branch: trunk, size: 21010)
15:50
[254eb524] part of check-in [0a514e62] Ensure that new.* values of an UPDATE do not get clobbered after the BEFORE triggers run when unmodified columns of the row being updated are reloaded. Fix for ticket [d85fffd6ffe856092ed8da] (check-in: [0a514e62] user: drh branch: trunk, size: 20823)
15:04
[d7bdbff7] part of check-in [7bb23c2a] Clarification of the behavior of a BEFORE UPDATE trigger when the trigger changes the values of some of the columns used to compute new columns in the UPDATE. (check-in: [7bb23c2a] user: drh branch: trunk, size: 20444)
2015-05-19
19:44
[ea9624cc] part of check-in [f5d0ce80] Ensure that when the VM applies TEXT affinity to a value it discards any existing REAL or INTEGER value. Fix for [34cd55d6]. (check-in: [f5d0ce80] user: dan branch: trunk, size: 19602)
2013-02-09
15:37
[dc47573a] part of check-in [3f674375] Rename SQLITE_CONSTRAINT_RAISE to SQLITE_CONSTRAINT_TRIGGER. Put the extended constraint error codes in alphabetical order. Add many test cases for the extended constraint error codes. (check-in: [3f674375] user: drh branch: constraint-error-codes, size: 19110)
2012-10-07
05:34
[30f343f9] part of check-in [50679889] Corrections to test names to eliminate duplicates and follow naming conventions. (check-in: [50679889] user: mistachkin branch: trunk, size: 19052)
2012-10-05
18:35
[c3e4093e] part of check-in [ac81ae49] Backport fixes to shared-cache mode, from the shared-cache-fix branch, to version 3.7.9 (check-in: [ac81ae49] user: drh branch: branch-3.7.9, size: 18646)
2012-10-04
19:33
[70acedb7] part of check-in [2b370dea] Shared-cache mode fixes for views and virtual tables. (check-in: [2b370dea] user: dan branch: shared-cache-fix, size: 18984)
2012-02-13
10:00
[de42feb7] part of check-in [76bb649e] Changes to various test scripts so that veryquick.test runs with OMIT_COMPOUND_SELECT defined. (check-in: [76bb649e] user: dan branch: trunk, size: 18999)
2012-01-28
15:22
[38524d80] part of check-in [eb3b6a0c] Add support for multiple rows of VALUES in an INSERT statement. (check-in: [eb3b6a0c] user: drh branch: trunk, size: 18990)
2011-08-02
00:57
[38c657ea] part of check-in [9007586f] 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: [9007586f] user: mistachkin branch: winopen-retry-logic, size: 18661)
2009-08-28
18:53
[2e18561f] part of check-in [9b9c1921] Changes to support recursive triggers. (check-in: [9b9c1921] user: dan branch: trunk, size: 18675)
2009-07-03
15:37
[4ecf469e] part of check-in [c8bf40df] Make explicit the restrictions on UPDATE, DELETE, and INSERT statement syntax within triggers. Ticket #3947. (CVS 6840) (check-in: [c8bf40df] user: drh branch: trunk, size: 18417)
2008-10-09
18:48
[53342dfd] part of check-in [c2cf9d60] Fix an assert() failure that can occur if the user attempts to set an into an integer primary key column to a text value in a table that has a BEFORE UPDATE trigger. (CVS 5787) (check-in: [c2cf9d60] user: danielk1977 branch: trunk, size: 16257)
2007-10-09
08:29
[7c13f39c] part of check-in [07c00fff] Fixes to the test suite (no code changes) so that quick.test runs with OMIT_ATTACH builds. #2706. (CVS 4480) (check-in: [07c00fff] user: danielk1977 branch: trunk, size: 15893)
2007-04-06
11:26
[b361161c] part of check-in [8e2559b4] The FOR EACH STATEMENT clause in a trigger is now a syntax error. It used to be silently ignored. STATEMENT is no longer a keyword. (CVS 3821) (check-in: [8e2559b4] user: drh branch: trunk, size: 15885)
2006-09-11
23:45
[2c79e2bf] part of check-in [e4fe736c] Add support for IF EXISTS on CREATE/DROP TRIGGER/VIEW. Ticket #1899. (CVS 3406) (check-in: [e4fe736c] user: drh branch: trunk, size: 15694)
2006-03-29
00:24
[e8c717e9] part of check-in [4ba280dd] Properly record the names of triggers even if the name is quoted. Ticket #1737. (CVS 3158) (check-in: [4ba280dd] user: drh branch: trunk, size: 15444)
2006-01-17
09:35
[0c1d4488] part of check-in [3a54a33d] Test suite fixes for builds that define OMIT symbols. (CVS 2962) (check-in: [3a54a33d] user: danielk1977 branch: trunk, size: 15112)
2005-08-12
22:58
[152aed5a] part of check-in [3c00f598] Improved error message when a #NNN parameter appears on user input. Additional coverage testing. (CVS 2582) (check-in: [3c00f598] user: drh branch: trunk, size: 14963)
2005-03-29
03:10
[4c68031f] part of check-in [c41d5544] Add the SQLITE_OMIT_TEMPDB compile time macro. (CVS 2427) (check-in: [c41d5544] user: danielk1977 branch: trunk, size: 14835)
2005-01-21
04:25
[9db1a7c9] part of check-in [d4e19efc] Modify test scripts to work when SQLITE_OMIT_SUBQUERY (but no other OMIT macros) is defined. (CVS 2252) (check-in: [d4e19efc] user: danielk1977 branch: trunk, size: 14122)
2005-01-19
23:24
[98239dd6] part of check-in [d8b2a7e0] Continued refactoring of the name resolution logic and query optimizer. (CVS 2236) (check-in: [d8b2a7e0] user: drh branch: trunk, size: 14122)
2004-11-22
13:35
[0c60435f] part of check-in [007be591] Ensure tests pass when SQLITE_OMIT_COMPOUND_SELECT is defined. (CVS 2138) (check-in: [007be591] user: danielk1977 branch: trunk, size: 14121)
10:20
[65ee61f6] part of check-in [48c7eb7f] Fix a test-suite error made in check-in (2132) (CVS 2136) (check-in: [48c7eb7f] user: danielk1977 branch: trunk, size: 12978)
08:43
[5fd454a4] part of check-in [711e8d76] Modify test suite to work when SQLITE_OMIT_VIEW is defined. (CVS 2132) (check-in: [711e8d76] user: danielk1977 branch: trunk, size: 13012)
2004-11-02
18:30
[d2d38d8a] part of check-in [f77f7753] Disable trigger tests that use ATTACH in version 2.8 when there is a codec enabled. (CVS 2042) (check-in: [f77f7753] user: drh branch: version_2, size: 12917)
2004-10-31
02:22
[63a74ae1] part of check-in [be661acf] Insert #ifdefs that can optionally remove features at compiletime resulting in a database engine with a smaller footprint. (CVS 2034) (check-in: [be661acf] user: drh branch: trunk, size: 12842)
2004-06-19
04:23
[cf8c8bbd] part of check-in [cce250ea] Backport of (1628) to version 2. (CVS 1631) (check-in: [cce250ea] user: danielk1977 branch: version_2, size: 12735)
02:22
[dc015c41] part of check-in [1f43219a] Fix for #764. When reloading the schema, load the temp schema last. (CVS 1628) (check-in: [1f43219a] user: danielk1977 branch: trunk, size: 12794)
00:16
[b45ef390] part of check-in [d705d051] Change the name of the TCL command from "sqlite" to "sqlite3" so that both SQLite version 2 and SQLite version 3 can be used by Tcl at the same time. (CVS 1626) (check-in: [d705d051] user: drh branch: trunk, size: 10089)
2004-05-29
02:37
[99b7cd9a] part of check-in [4060a37d] Allow CREATE and DROP TRIGGER on attached databases. (CVS 1488) (check-in: [4060a37d] user: danielk1977 branch: trunk, size: 10083)
2004-02-14
16:31
[4538c1c7] part of check-in [9771ad1e] The sqlite_exec() function is now implemented using sqlite_compile() and sqlite_step(). This opens up lots of opportunity to remove old code. (CVS 1240) (check-in: [9771ad1e] user: drh branch: trunk, size: 10063)
2004-02-12
17:28
[d9f60044] part of check-in [a6b862a9] All REPLACE INTO syntax inside of triggers. Ticket #610. (CVS 1231) (check-in: [a6b862a9] user: drh branch: trunk, size: 10071)
2003-10-03
00:13
[3fe06dae] part of check-in [54aa0fb2] Allow quoted trigger names. Ticket #468. (CVS 1109) (check-in: [54aa0fb2] user: drh branch: trunk, size: 9535)
2003-08-16
12:37
[9f82134e] part of check-in [ef58f163] Do not delete tables with the same name when dropping triggers. Ticket #430. (CVS 1074) (check-in: [ef58f163] user: drh branch: trunk, size: 8505)
2003-06-15
23:42
[6efd402d] part of check-in [c9734c27] Enhance the "PRAGMA integrity_check" command to verify that all indices are correctly constructed. New calls to integrity_check are made in the test suite. These changes are intended to prevent any future problems such as seen in ticket #334. (CVS 1024) (check-in: [c9734c27] user: drh branch: trunk, size: 7454)
2003-05-31
16:21
[8e6c11a1] part of check-in [7202d4f1] Tighter binding of views, triggers, and indices to their respective databases. Ticket #323. Much more testing needs to be done to the sqliteFix...() routines in attach.c. (CVS 990) (check-in: [7202d4f1] user: drh branch: trunk, size: 7426)
2003-05-17
19:04
[589fb8f3] part of check-in [c8c823b0] Prevent an infinite loop when deleting a table that has a TEMP trigger. (CVS 984) (check-in: [c8c823b0] user: drh branch: trunk, size: 7449)
2003-04-21
18:48
[61ef4166] part of check-in [58ddd587] Add support for TEMPORARY triggers. Such triggers can write temporary or permanent tables. (CVS 926) (check-in: [58ddd587] user: drh branch: trunk, size: 6694)
2003-03-30
00:19
[6fa21c39] part of check-in [b90d9de3] Fix a memory leak in triggers and update tests to show the latest error message text. (CVS 886) (check-in: [b90d9de3] user: drh branch: trunk, size: 4841)
2002-09-14
12:04
[ec1da76e] part of check-in [6cb80ae1] Rename all tests so that the first part of the test name corresponds to the file that contains that test. This makes it much easier to find a particular test after it fail. (CVS 749) (check-in: [6cb80ae1] user: drh branch: trunk, size: 4856)
2002-05-26
23:24
[bb63749f] part of check-in [d9e48cd5] Require the INSTEAD OF syntax to create triggers on database views. (CVS 591) (check-in: [d9e48cd5] user: danielk1977 branch: trunk, size: 4842)
2002-05-23
12:50
[a0550c5c] part of check-in [4d27ee41] Partial fix for ticket #49. The correct result is computed, but now we have a memory leak. I'm not sure if the memory leak was pre-existing or a result of this change. (CVS 581) (check-in: [4d27ee41] user: drh branch: trunk, size: 3634)
00:30
[75f31403] part of check-in [275ba356] Do not allow triggers on the SQLITE_MASTER table. (CVS 579) (check-in: [275ba356] user: drh branch: trunk, size: 2730)
2002-05-15
08:30
[06dd4793] part of check-in [794bf67b] Added FOR EACH ROW triggers functionality (CVS 562) (check-in: [794bf67b] user: danielk1977 branch: trunk, size: 2526) Added