aboutsummaryrefslogtreecommitdiff
path: root/src/trigger.c
Commit message (Collapse)AuthorAge
...
* Add a testcase() to confirm that an OOM on sqlite3DbStrNDup() is handleddrh2017-06-08
| | | | | correctly in trigger.c. FossilOrigin-Name: 343e55992f503efa662e49bb0f3c0d798defd0a11f2ee1c36968902fa7e06823
* All temp.sqlite_master to be used as an alias for sqlite_temp_master.drh2016-12-16
| | | FossilOrigin-Name: 8d646905b830d5bb29092e103ac5cb499b3c7e5a
* Revise the implementation of OP_Once so that it is smaller, faster, and usesdrh2016-09-18
| | | | | | less memory. This also fixes an obscure bug introduced 3 days ago by check-in [5990a1bdb4a073]. FossilOrigin-Name: 6bf5ba10d28f1b0a32aa9a560ae3143a1235eadb
* Fix SQLITE_OMIT_AUTHORIZATION so that it compiles cleanly.drh2016-09-16
| | | FossilOrigin-Name: a3e3b3e1c57178ccd38fc7375ec1de8e8ae45372
* Rename the Db.zName field to Db.zDbSName to make it more descriptive and todrh2016-08-18
| | | | | | distinguish it from all of the other "zName" variables scattered throughout the code. FossilOrigin-Name: 92a22f01343a898455fd61c3b8e7d7c954f5b569
* Improvements to the way that OOM errors are processed.drh2016-02-05
| | | FossilOrigin-Name: c3ef03478a5788c855b3aef385d43ae7f494f440
* Add the sqlite3TokenInit() utility function.drh2016-01-22
| | | FossilOrigin-Name: 7323175337b7ba85ac932ca892b28860f6a5b688
* Use sqlite3VdbeAddOp4() rather than a separate sqlite3VdbeChangeP4() call, fordrh2016-01-16
| | | | | a slightly smaller and faster binary. FossilOrigin-Name: a4258cd4613c55acacb5c7b61faa3de7eb0759d2
* Simplification of the DROP TRIGGER logic using sqlite3NestedParse() insteaddrh2015-12-09
| | | | | | of hand-coded VDBE code. This is a manual cherry-pick of the key change from check-in [c80bbf14b365d]. FossilOrigin-Name: 8021b4c8139ba56d6b1e2e26aeec4f9bf77f37c9
* Ensure that tables names are dequoted exactly once by the trigger logic.dan2015-04-21
| | | FossilOrigin-Name: 9d887b92f8086961e045f8acb9ee7a443796d411
* Fix some identifier name de-quoting issues in the foreign key and trigger logic.drh2015-04-21
| | | FossilOrigin-Name: 59e92bd9521f1e8315a9a7e7fd3d63b0c75eaf0e
* Remove unnecessary parser error count increments. Let the sqlite3ErrorMsg()drh2015-04-17
| | | | | take care of doing that. FossilOrigin-Name: 3f3b0f683af2fbee83811536f6bef770ff919385
* Make sure errors in coding triggers are propagated back up to the parser.drh2015-04-16
| | | FossilOrigin-Name: 928f973ca9adc7933015b2fb6b6fcb8e3154cb9c
* Remove two pointless assert() statements. This should silence harmlessdrh2015-04-09
| | | | | | compiler warnings reported at [https://bugzilla.mozilla.org/show_bug.cgi?id=1152845] FossilOrigin-Name: 83b342a44ffc9ea07dc4d59f2866cefc68ee4f13
* Fix typos in comments. No code changes.peter.d.reid2014-09-06
| | | FossilOrigin-Name: e62aab5e9290503869e1f4d5e0fefd2b4dee0a69
* Simplify the interface to the symbol table, saving 600 bytes of code space.drh2014-08-21
| | | FossilOrigin-Name: 14b0f561fe15622b61c6676c9c455dca6b9ba5f0
* Attempt to work around MSVC's treatment of __LINE__ as a non-constant valuedrh2014-03-10
| | | | | | in "Edit and Continue" mode by avoiding the use of __LINE__ when SQLITE_VDBE_COVERAGE is not defined. FossilOrigin-Name: 0a5318bc272b844e937cb1df3a07224034bc3450
* Add logic to do test coverage measurements on the VDBE code.drh2014-02-17
| | | FossilOrigin-Name: ce184c7bb16988641d37c908d9b3042456d4be3d
* Change the OP_Trace opcode to OP_Init and give it the ability to jump to thedrh2014-02-08
| | | | | | initialization code at the bottom of the program, thus avoiding the need for an extra OP_Goto. FossilOrigin-Name: 192dea97316144f15f6dd0eabff08a0bf9ef203e
* Allow a VALUES clause to be used any place that a SELECT statement can bedrh2014-01-10
| | | | | used. FossilOrigin-Name: c9ea7d199f06a7801ab639e7ac98ebeb98706f24
* Rework the logic that factors constant expressions out of inner loops, makingdrh2013-11-15
| | | | | it both simpler and faster. FossilOrigin-Name: 8dc5c76c766828d7c28090bec30ff48227e7b140
* Add the SQLITE_ENABLE_EXPLAIN_COMMENTS compile-time option to enable extradrh2013-10-30
| | | | | | commentary in the EXPLAIN output. Formerly, this was only available with SQLITE_DEBUG. FossilOrigin-Name: e1a89b56f7173166bb9224e2e360fd67ad3399c3
* The sqlite3FixInit() routine cannot fail. So change the return type from "int"drh2013-10-03
| | | | | to "void". FossilOrigin-Name: 500c5932fe3f5fcd0940522f7839d581c555e0eb
* Return an error if an attempt is made to create a trigger with an SQL ↵dan2013-10-03
| | | | | variable embedded within it. If such a variable reference is found within a trigger definition loaded from the sqlite_master table, silently replace it with a NULL. FossilOrigin-Name: f35f6ae3da77dbdf5f7a4a9927475659fc6e0ca6
* Many small harmless comment changes. Removal of obsolete comments anddrh2013-05-28
| | | | | fixing misspelled words. No changes to code. FossilOrigin-Name: a0d5cc9315dc6e9ef7dee4c3dfabf4e562d64376
* Apply the same restrictions on constant refactoring to statements within a ↵dan2012-12-06
| | | | | trigger program as top-level statements. Candidate fix for [ae3c5670b6]. FossilOrigin-Name: 0c31a46801746191d1a53332d75beda880fe1fd7
* Fix all known instances of 'repeated the' style typos in comments. No ↵mistachkin2012-08-25
| | | | | changes to code. FossilOrigin-Name: 9b19b847533f944f289d93dcdba29c0d67bf251c
* Modify the OP_Once opcode so that it works correctly in trigger ↵dan2011-12-09
| | | | | sub-programs. This is a candidate fix for [7bbfb7d442]. FossilOrigin-Name: 557c69055a300b4082830b5f4803091dca1c3140
* Ignore the database name on the target table when parsing a CREATE TABLEdrh2011-07-01
| | | | | | statement out of the sqlite_master table. This is a fix for ticket [d6ddba6706353] that preserves backwards compatibility. FossilOrigin-Name: 009c96ea7836edf75d65b150055e920079bb45e3
* Create and use a function especially for adding the ParseSchema opcode.drh2011-06-03
| | | | | This gives a small reduction in code and a small performance increase. FossilOrigin-Name: 957b2ab67c6185f0e1062593d237de5c434a38bf
* Add VerifyCookie instructions to "DROP XXX IF EXISTS" statements if the ↵dan2011-04-09
| | | | | specified database object does not exist when the statement is prepared. FossilOrigin-Name: a46f32900a013aa6bb2dad2a9ed3ce00ab2493fd
* Add an OP_VerifyCookie instruction to "CREATE XXX IF NOT EXISTS" commands. ↵dan2011-04-09
| | | | | This way, if the specified database object existed when the statement was compiled but removed from the database before sqlite3_step() was called, the statement still works as expected (and creates the object). FossilOrigin-Name: b9dbd9936191666c3fc9889e938344a82cc03aeb
* Merge the scheme-parse-refactor changes into trunk: (1) addeddrh2011-04-05
|\ | | | | | | | | | | sqlite3SchemaMutexHeld() asserts, (2) Use -1 instead of 0 to mean "all" in sqlite3ResetInternalSchema(), and other cosmetic changes. FossilOrigin-Name: 5db4511d8a77b74be3503a7c34257ef6b07541f5
| * Add a description of access rules for the Schema object and lots of assertsdrh2011-04-04
| | | | | | | | | | to verify that the access rules are followed. FossilOrigin-Name: ae8374af057b6e6546e9265148cfffe32fcb0849
* | Fix the P4_TRANSIENT constant so that it works correct - so that it reallydrh2011-04-05
|/ | | | | | makes a copy of the string for the P4 argument. Use P4_TRANSIENT wherever appropriate. Change P4_STATICs of schema names to P4_TRANSIENT. FossilOrigin-Name: bf664b206bf6f5c1941da1986dfe2c0d1831d5e4
* Add the ability to enable and disable foreign key constraints and triggersdrh2011-03-21
| | | | | using calls to sqlite3_db_config(). FossilOrigin-Name: 09e167f9c14625924b17bbb1f292f89ac9ddc93a
* Remove dead code identified by the clang static analyzer.drh2011-03-06
| | | FossilOrigin-Name: 01a79d5a7af48fb7e50291c0c7c6283d3fb359d0
* Change the way SubProgram objects are deleted so that the code is the same ↵dan2010-07-26
| | | | | for deletion and measurement. FossilOrigin-Name: 00e55102a8309eb6df08ad4a8937ba02688bac62
* Currently, if SQLite cannot find a table or index referred to by a query, it ↵dan2010-06-28
| | | | | reloads the database schema from disk to see if the table or index has been added since the schema was cached in memory. Extend this behaviour to columns (which may have been added using ALTER TABLE) and fix some obscure cases related to tables and indexes (INDEXED BY, DROP TABLE etc.). FossilOrigin-Name: 4932f22848b3d15a2b6dc5fa2cd69ce19182e2a4
* Automatically generate transient indices for tables in joins that woulddrh2010-04-06
| | | | | otherwise have to use a full table scan. FossilOrigin-Name: 1b2a04125f964e14f3fb90171c5ab86a0641d1c9
* When creating a trigger on a main database table when there is a TEMP tabledrh2010-02-15
| | | | | | with the same name, make sure the trigger is bound to the main table. Ticket [985771e11612]. FossilOrigin-Name: ec914af32675e472694270d46f3ba2214eb2fe90
* Fix a compiler warning in shell.c. Updates to comments in trigger.c.drh2010-02-15
| | | FossilOrigin-Name: c727601eecd85a26dbd4fc36823d77bec34da3c3
* Move [7d30880114] to the trunk. Add optimizations to reduce the number of ↵dan2009-11-27
| | | | | opcodes used for BEFORE UPDATE triggers. FossilOrigin-Name: 1b7c5250ccb63182324bfc3f1ea28f17b6db357a
* Remove the obsolete "$Id:$" RCS identifier strings from the source code.drh2009-11-10
| | | FossilOrigin-Name: f6c045f649036958078cb15cd9d5453680c82b0c
* Fixed warnings with MSVC compile.drh2009-10-13
| | | FossilOrigin-Name: e0aa50c382a56bb02eaa589619b7e670006a26b3
* Fix the DROP TABLE command so that it cannot be used to bypass foreign key ↵dan2009-09-28
| | | | | constraints (if foreign key support is enabled). FossilOrigin-Name: 8353808c9e70412fdee31bfda7810e948f1c7485
* Remove unused parameter from sqlite3CodeRowTrigger(). Fix header comments ↵dan2009-09-24
| | | | | for this function and CodeRowTriggerDirect(). FossilOrigin-Name: 0443f7c9112ca91aa45c78a3d6287e5fcf5c3b73
* Check in implementation of foreign key constraints.dan2009-09-19
| | | FossilOrigin-Name: d5d399811876391642937edeb9e8434dd9e356f5
* When coding a trigger, assume that the "oldmask" requires all columns untildrh2009-09-17
| | | | | | | we know otherwise. That pessimistic assumption assures that all necessary parameters are available on a cascading delete trigger. Ticket [e25d9ea771f] FossilOrigin-Name: 03e464be51a1c36fc02cf31178ae91f736dfddd6
* Further simplifications to the VDBE - removing functionality that is no longerdrh2009-09-08
| | | | | used. FossilOrigin-Name: b271e16621831957468a1d3925174aac73f58891