Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History of test/trigger1.test
|
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 | |