/ File History
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

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

History of test/trigger1.test

2019-08-27
10:05
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] file: [6be279c9] check-in: [069c2f4c] user: drh branch: trunk, size: 21363
2018-04-26
18:34
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. file: [17e4b43e] check-in: [9fd0faf5] user: drh branch: trunk, size: 21010
15:50
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] file: [254eb524] check-in: [0a514e62] user: drh branch: trunk, size: 20823
15:04
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. file: [d7bdbff7] check-in: [7bb23c2a] user: drh branch: trunk, size: 20444
2015-05-19
19:44
Ensure that when the VM applies TEXT affinity to a value it discards any existing REAL or INTEGER value. Fix for [34cd55d6]. file: [ea9624cc] check-in: [f5d0ce80] user: dan branch: trunk, size: 19602
2013-02-09
15:37
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. file: [dc47573a] check-in: [3f674375] user: drh branch: constraint-error-codes, size: 19110
2012-10-07
05:34
Corrections to test names to eliminate duplicates and follow naming conventions. file: [30f343f9] check-in: [50679889] user: mistachkin branch: trunk, size: 19052
2012-10-05
18:35
Backport fixes to shared-cache mode, from the shared-cache-fix branch, to version 3.7.9 file: [c3e4093e] check-in: [ac81ae49] user: drh branch: branch-3.7.9, size: 18646
2012-10-04
19:33
Shared-cache mode fixes for views and virtual tables. file: [70acedb7] check-in: [2b370dea] user: dan branch: shared-cache-fix, size: 18984
2012-02-13
10:00
Changes to various test scripts so that veryquick.test runs with OMIT_COMPOUND_SELECT defined. file: [de42feb7] check-in: [76bb649e] user: dan branch: trunk, size: 18999
2012-01-28
15:22
Add support for multiple rows of VALUES in an INSERT statement. file: [38524d80] check-in: [eb3b6a0c] user: drh branch: trunk, size: 18990
2011-08-02
00:57
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. file: [38c657ea] check-in: [9007586f] user: mistachkin branch: winopen-retry-logic, size: 18661
2009-08-28
18:53
Changes to support recursive triggers. file: [2e18561f] check-in: [9b9c1921] user: dan branch: trunk, size: 18675
2009-07-03
15:37
Make explicit the restrictions on UPDATE, DELETE, and INSERT statement syntax within triggers. Ticket #3947. (CVS 6840) file: [4ecf469e] check-in: [c8bf40df] user: drh branch: trunk, size: 18417
2008-10-09
18:48
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) file: [53342dfd] check-in: [c2cf9d60] user: danielk1977 branch: trunk, size: 16257
2007-10-09
08:29
Fixes to the test suite (no code changes) so that quick.test runs with OMIT_ATTACH builds. #2706. (CVS 4480) file: [7c13f39c] check-in: [07c00fff] user: danielk1977 branch: trunk, size: 15893
2007-04-06
11:26
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) file: [b361161c] check-in: [8e2559b4] user: drh branch: trunk, size: 15885
2006-09-11
23:45
Add support for IF EXISTS on CREATE/DROP TRIGGER/VIEW. Ticket #1899. (CVS 3406) file: [2c79e2bf] check-in: [e4fe736c] user: drh branch: trunk, size: 15694
2006-03-29
00:24
Properly record the names of triggers even if the name is quoted. Ticket #1737. (CVS 3158) file: [e8c717e9] check-in: [4ba280dd] user: drh branch: trunk, size: 15444
2006-01-17
09:35
Test suite fixes for builds that define OMIT symbols. (CVS 2962) file: [0c1d4488] check-in: [3a54a33d] user: danielk1977 branch: trunk, size: 15112
2005-08-12
22:58
Improved error message when a #NNN parameter appears on user input. Additional coverage testing. (CVS 2582) file: [152aed5a] check-in: [3c00f598] user: drh branch: trunk, size: 14963
2005-03-29
03:10
Add the SQLITE_OMIT_TEMPDB compile time macro. (CVS 2427) file: [4c68031f] check-in: [c41d5544] user: danielk1977 branch: trunk, size: 14835
2005-01-21
04:25
Modify test scripts to work when SQLITE_OMIT_SUBQUERY (but no other OMIT macros) is defined. (CVS 2252) file: [9db1a7c9] check-in: [d4e19efc] user: danielk1977 branch: trunk, size: 14122
2005-01-19
23:24
Continued refactoring of the name resolution logic and query optimizer. (CVS 2236) file: [98239dd6] check-in: [d8b2a7e0] user: drh branch: trunk, size: 14122
2004-11-22
13:35
Ensure tests pass when SQLITE_OMIT_COMPOUND_SELECT is defined. (CVS 2138) file: [0c60435f] check-in: [007be591] user: danielk1977 branch: trunk, size: 14121
10:20
Fix a test-suite error made in check-in (2132) (CVS 2136) file: [65ee61f6] check-in: [48c7eb7f] user: danielk1977 branch: trunk, size: 12978
08:43
Modify test suite to work when SQLITE_OMIT_VIEW is defined. (CVS 2132) file: [5fd454a4] check-in: [711e8d76] user: danielk1977 branch: trunk, size: 13012
2004-11-02
18:30
Disable trigger tests that use ATTACH in version 2.8 when there is a codec enabled. (CVS 2042) file: [d2d38d8a] check-in: [f77f7753] user: drh branch: version_2, size: 12917
2004-10-31
02:22
Insert #ifdefs that can optionally remove features at compiletime resulting in a database engine with a smaller footprint. (CVS 2034) file: [63a74ae1] check-in: [be661acf] user: drh branch: trunk, size: 12842
2004-06-19
04:23
Backport of (1628) to version 2. (CVS 1631) file: [cf8c8bbd] check-in: [cce250ea] user: danielk1977 branch: version_2, size: 12735
02:22
Fix for #764. When reloading the schema, load the temp schema last. (CVS 1628) file: [dc015c41] check-in: [1f43219a] user: danielk1977 branch: trunk, size: 12794
00:16
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) file: [b45ef390] check-in: [d705d051] user: drh branch: trunk, size: 10089
2004-05-29
02:37
Allow CREATE and DROP TRIGGER on attached databases. (CVS 1488) file: [99b7cd9a] check-in: [4060a37d] user: danielk1977 branch: trunk, size: 10083
2004-02-14
16:31
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) file: [4538c1c7] check-in: [9771ad1e] user: drh branch: trunk, size: 10063
2004-02-12
17:28
All REPLACE INTO syntax inside of triggers. Ticket #610. (CVS 1231) file: [d9f60044] check-in: [a6b862a9] user: drh branch: trunk, size: 10071
2003-10-03
00:13
Allow quoted trigger names. Ticket #468. (CVS 1109) file: [3fe06dae] check-in: [54aa0fb2] user: drh branch: trunk, size: 9535
2003-08-16
12:37
Do not delete tables with the same name when dropping triggers. Ticket #430. (CVS 1074) file: [9f82134e] check-in: [ef58f163] user: drh branch: trunk, size: 8505
2003-06-15
23:42
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) file: [6efd402d] check-in: [c9734c27] user: drh branch: trunk, size: 7454
2003-05-31
16:21
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) file: [8e6c11a1] check-in: [7202d4f1] user: drh branch: trunk, size: 7426
2003-05-17
19:04
Prevent an infinite loop when deleting a table that has a TEMP trigger. (CVS 984) file: [589fb8f3] check-in: [c8c823b0] user: drh branch: trunk, size: 7449
2003-04-21
18:48
Add support for TEMPORARY triggers. Such triggers can write temporary or permanent tables. (CVS 926) file: [61ef4166] check-in: [58ddd587] user: drh branch: trunk, size: 6694
2003-03-30
00:19
Fix a memory leak in triggers and update tests to show the latest error message text. (CVS 886) file: [6fa21c39] check-in: [b90d9de3] user: drh branch: trunk, size: 4841
2002-09-14
12:04
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) file: [ec1da76e] check-in: [6cb80ae1] user: drh branch: trunk, size: 4856
2002-05-26
23:24
Require the INSTEAD OF syntax to create triggers on database views. (CVS 591) file: [bb63749f] check-in: [d9e48cd5] user: danielk1977 branch: trunk, size: 4842
2002-05-23
12:50
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) file: [a0550c5c] check-in: [4d27ee41] user: drh branch: trunk, size: 3634
00:30
Do not allow triggers on the SQLITE_MASTER table. (CVS 579) file: [75f31403] check-in: [275ba356] user: drh branch: trunk, size: 2730
2002-05-15
08:30
Added FOR EACH ROW triggers functionality (CVS 562) file: [06dd4793] check-in: [794bf67b] user: danielk1977 branch: trunk, size: 2526 Added