aboutsummaryrefslogtreecommitdiff
path: root/test/trigger1.test
Commit message (Collapse)AuthorAge
* Remove unnecessary "www." prefixes on domain names in URLs.drh2025-04-10
| | | FossilOrigin-Name: 20acd630b91609725794ce84f9eda01d5f3c898407f0948264830851d25ccaa6
* Allow arbitrary expressions as the second argument to RAISE().drh2024-05-08
| | | FossilOrigin-Name: 003e1c8c27824cb917b3869bdf9000f32ff0b6887a2aff8516712cfe865cf34d
* Do not allocate new Trigger objects in the parser following a syntax error,drh2022-03-07
| | | | | | | to avoid violating invariants associated with Expr nodes. See [forum:/forumpost/2024e94071ef1531|forum thread 2024e94071ef1531] for more information. FossilOrigin-Name: 5e0ed49b3d739d292f5df3e498449ae8f4357cbb83394181fb34f98ed8372707
* Fix a false-positive in the register validity tracking logic by moving thedrh2020-01-04
| | | | | | temporary register release call before the jump that uses that temporary register. FossilOrigin-Name: 9da48a5ca66dc67c8f7fb2d2471dac7ea696e35ecba5ddf65747d08d452436c1
* Correction to check-in [bec5b6d4d083556d] so that it detects *all*drh2019-10-24
| | | | | | triggers that might perturb the insertion cursor. Ticket [50c09fc2cf0d91ce]. FossilOrigin-Name: 521f1d36282549488a47a434484a24924ee970d29f05a8ae499b7d536bcd692b
* If a TEMP TRIGGER references an auxiliary schema, and that auxiliary schemadrh2019-08-27
| | | | | | 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. FossilOrigin-Name: 069c2f4c61f06211a8981abc412afcc1536ece13380b13a70aa99123f8f527cd
* The previous fix for ticket [d85fffd6ffe856092ed8da] in check-in drh2018-04-26
| | | | | | | | | | [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. FossilOrigin-Name: 9fd0faf517993587d2f54212638545fc85fbbc84a031bcfae8c1e5894825d83b
* Ensure that new.* values of an UPDATE do not get clobbered after thedrh2018-04-26
| | | | | | BEFORE triggers run when unmodified columns of the row being updated are reloaded. Fix for ticket [d85fffd6ffe856092ed8da] FossilOrigin-Name: 0a514e62ad1ebe5c12da8daed429ae2f9d9910471d3c5cef3b6870bdadfefca1
* Clarification of the behavior of a BEFORE UPDATE trigger when the triggerdrh2018-04-26
| | | | | | changes the values of some of the columns used to compute new columns in the UPDATE. FossilOrigin-Name: 7bb23c2a3d37f0d5e5515b917860818906819d54a0066e1ba8e9792a82f7d279
* Ensure that when the VM applies TEXT affinity to a value it discards any ↵dan2015-05-19
| | | | | existing REAL or INTEGER value. FossilOrigin-Name: f5d0ce80792d58ef424300f973f8876d835ed4ad
* Rename SQLITE_CONSTRAINT_RAISE to SQLITE_CONSTRAINT_TRIGGER. Put the drh2013-02-09
| | | | | | extended constraint error codes in alphabetical order. Add many test cases for the extended constraint error codes. FossilOrigin-Name: 3f67437536591a1b0742a25b983707933aaa16d5
* Corrections to test names to eliminate duplicates and follow naming conventions.mistachkin2012-10-07
| | | FossilOrigin-Name: 50679889c75cd3205253b1682abfbddc5ff09175
* Shared-cache mode fixes for views and virtual tables.dan2012-10-04
| | | FossilOrigin-Name: 2b370dea704b59262c604af0efcef5660b194454
* Changes to various test scripts so that veryquick.test runs with ↵dan2012-02-13
| | | | | OMIT_COMPOUND_SELECT defined. FossilOrigin-Name: 76bb649ee2633226324130f5898622c348f93769
* Add support for multiple rows of VALUES in an INSERT statement.drh2012-01-28
| | | FossilOrigin-Name: eb3b6a0ceb8bfb9fd59ff5fec420f863a9b5c4e4
* Add retry logic for AV defense to winOpen. Also, refactor test suite to ↵mistachkin2011-08-02
| | | | | allow the key Tcl file operations (e.g. copy and delete) to be retried. FossilOrigin-Name: 9007586fdabed8dbcc78581ea9821cfd1f9a4c8c
* Changes to support recursive triggers.dan2009-08-28
| | | FossilOrigin-Name: 9b9c19211593d5ff7b39254a29c284560a8bcedb
* Make explicit the restrictions on UPDATE, DELETE, and INSERT statement syntaxdrh2009-07-03
| | | | | within triggers. Ticket #3947. (CVS 6840) FossilOrigin-Name: c8bf40df7be728b11bb633516d1988c6064a9d70
* Fix an assert() failure that can occur if the user attempts to set an into ↵danielk19772008-10-09
| | | | | an integer primary key column to a text value in a table that has a BEFORE UPDATE trigger. (CVS 5787) FossilOrigin-Name: c2cf9d60d6626844193b008a37e4417aa0a0f323
* Fixes to the test suite (no code changes) so that quick.test runs with ↵danielk19772007-10-09
| | | | | OMIT_ATTACH builds. #2706. (CVS 4480) FossilOrigin-Name: 07c00fffe50e8380748f7ae02328531a75d64610
* The FOR EACH STATEMENT clause in a trigger is now a syntax error. It useddrh2007-04-06
| | | | | to be silently ignored. STATEMENT is no longer a keyword. (CVS 3821) FossilOrigin-Name: 8e2559b4da6329d7c21925d0850f7f91a3731975
* Add support for IF EXISTS on CREATE/DROP TRIGGER/VIEW. Ticket #1899. (CVS 3406)drh2006-09-11
| | | FossilOrigin-Name: e4fe736cfbbdc081581911a01690576034877b72
* Properly record the names of triggers even if the name is quoted.drh2006-03-29
| | | | | Ticket #1737. (CVS 3158) FossilOrigin-Name: 4ba280ddd66d5cbf617263d6300b7582f65d47a9
* Test suite fixes for builds that define OMIT symbols. (CVS 2962)danielk19772006-01-17
| | | FossilOrigin-Name: 3a54a33dcb7e765ee3773397407e8929a8cfe1a9
* Improved error message when a #NNN parameter appears on user input.drh2005-08-12
| | | | | Additional coverage testing. (CVS 2582) FossilOrigin-Name: 3c00f5982ae61dfcd26c33ccdb81736628dbfce5
* Add the SQLITE_OMIT_TEMPDB compile time macro. (CVS 2427)danielk19772005-03-29
| | | FossilOrigin-Name: c41d55443c2dd532147962b87f542fb7d37075fd
* Modify test scripts to work when SQLITE_OMIT_SUBQUERY (but no other OMIT ↵danielk19772005-01-21
| | | | | macros) is defined. (CVS 2252) FossilOrigin-Name: d4e19efcef68d834c55c7d496cdb3696d63a31a2
* Continued refactoring of the name resolution logic and query optimizer. (CVS ↵drh2005-01-19
| | | | | 2236) FossilOrigin-Name: d8b2a7e09187564fe66a2b4bf0992c6a017146cf
* Ensure tests pass when SQLITE_OMIT_COMPOUND_SELECT is defined. (CVS 2138)danielk19772004-11-22
| | | FossilOrigin-Name: 007be591b7829f9ff38e4b14ba5a5043796c2ff3
* Fix a test-suite error made in check-in (2132) (CVS 2136)danielk19772004-11-22
| | | FossilOrigin-Name: 48c7eb7fb9fbc2166aaa7dbdb7c7e92c68f8eff3
* Modify test suite to work when SQLITE_OMIT_VIEW is defined. (CVS 2132)danielk19772004-11-22
| | | FossilOrigin-Name: 711e8d7695dfc74b3f1ee00591dcdda2cd7fc7d5
* Insert #ifdefs that can optionally remove features at compiletime resultingdrh2004-10-31
| | | | | in a database engine with a smaller footprint. (CVS 2034) FossilOrigin-Name: be661acfa849bb0d5692797dd221f5a8a457f8ad
* Fix for #764. When reloading the schema, load the temp schema last. (CVS 1628)danielk19772004-06-19
| | | FossilOrigin-Name: 1f43219a7402af7255743466731dba2afb31d12b
* Change the name of the TCL command from "sqlite" to "sqlite3" so that bothdrh2004-06-19
| | | | | SQLite version 2 and SQLite version 3 can be used by Tcl at the same time. (CVS 1626) FossilOrigin-Name: d705d051bed2b92b6c3bbcc75fe5b056633b9c31
* Allow CREATE and DROP TRIGGER on attached databases. (CVS 1488)danielk19772004-05-29
| | | FossilOrigin-Name: 4060a37d0baaa60c50f2dde4a1ab344133fcabbb
* The sqlite_exec() function is now implemented using sqlite_compile() anddrh2004-02-14
| | | | | sqlite_step(). This opens up lots of opportunity to remove old code. (CVS 1240) FossilOrigin-Name: 9771ad1e811e02e10bb738550fbea447749083c5
* All REPLACE INTO syntax inside of triggers. Ticket #610. (CVS 1231)drh2004-02-12
| | | FossilOrigin-Name: a6b862a9db6d409a53cc13e7008b27d4848b5509
* Allow quoted trigger names. Ticket #468. (CVS 1109)drh2003-10-03
| | | FossilOrigin-Name: 54aa0fb236d17b53b194a667d68c71007c8e7687
* Do not delete tables with the same name when dropping triggers.drh2003-08-16
| | | | | Ticket #430. (CVS 1074) FossilOrigin-Name: ef58f163b08d13f8e9b69459bd83e0bf9d5b404b
* Enhance the "PRAGMA integrity_check" command to verify that all indices aredrh2003-06-15
| | | | | | | 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) FossilOrigin-Name: c9734c27074d2039a1896a8c6965c08d03711b13
* Tighter binding of views, triggers, and indices to their respectivedrh2003-05-31
| | | | | | databases. Ticket #323. Much more testing needs to be done to the sqliteFix...() routines in attach.c. (CVS 990) FossilOrigin-Name: 7202d4f1a8853368954a967b7ccca9d8a6645a2e
* Prevent an infinite loop when deleting a table that has a TEMP trigger. (CVS ↵drh2003-05-17
| | | | | 984) FossilOrigin-Name: c8c823b068916711857fa67db10fb479999b55c2
* Add support for TEMPORARY triggers. Such triggers can write temporary ordrh2003-04-21
| | | | | permanent tables. (CVS 926) FossilOrigin-Name: 58ddd587b0f5d565ae3b0ba3a1fa5c20d459f3fc
* Fix a memory leak in triggers and update tests to show the latest errordrh2003-03-30
| | | | | message text. (CVS 886) FossilOrigin-Name: b90d9de32d10a71fe81f5bfd0cf57faae8c5c3b4
* Rename all tests so that the first part of the test name corresponds to thedrh2002-09-14
| | | | | | file that contains that test. This makes it much easier to find a particular test after it fail. (CVS 749) FossilOrigin-Name: 6cb80ae10af60863cc25c22a6442ba1d43b7409c
* Require the INSTEAD OF syntax to create triggers on database views. (CVS 591)danielk19772002-05-26
| | | FossilOrigin-Name: d9e48cd5180e2aae7672b9d54e18c37d0fe5258a
* Partial fix for ticket #49. The correct result is computed, but now we havedrh2002-05-23
| | | | | | a memory leak. I'm not sure if the memory leak was pre-existing or a result of this change. (CVS 581) FossilOrigin-Name: 4d27ee411902a197cd72416ca9da9197d3f87f13
* Do not allow triggers on the SQLITE_MASTER table. (CVS 579)drh2002-05-23
| | | FossilOrigin-Name: 275ba356f351abcf9a079ac16b765c9443750f0e
* Added FOR EACH ROW triggers functionality (CVS 562)danielk19772002-05-15
FossilOrigin-Name: 794bf67b6b36fce8854d5daff12f21dbb943240c
generated by cgit v1.2.3 (git 2.25.1) at 2025-07-15 17:02:00 +0000