aboutsummaryrefslogtreecommitdiff
path: root/src/trigger.c
Commit message (Collapse)AuthorAge
...
* Transform OP_HexBlob and OP_String8 to OP_Blob and OP_String the first time ↵danielk19772004-05-29
| | | | | they are executed. (CVS 1492) FossilOrigin-Name: 3225de8902b0e7e60c4d9f3a5ef51bc74f57d364
* Fix vacuum so that it works with blobs. (CVS 1490)danielk19772004-05-29
| | | FossilOrigin-Name: 4feb4b9a71ce7a92924d2358a7ccecb4cca19223
* Allow CREATE and DROP TRIGGER on attached databases. (CVS 1488)danielk19772004-05-29
| | | FossilOrigin-Name: 4060a37d0baaa60c50f2dde4a1ab344133fcabbb
* Allow CREATE TABLE and CREATE INDEX on attached databases. (CVS 1483)danielk19772004-05-28
| | | FossilOrigin-Name: 4984a130ccf3b8e486941a5d0d0cc70a691f0dac
* Fix many problems with manifest types and column affinity. Most things aredanielk19772004-05-18
| | | | | working now. (CVS 1393) FossilOrigin-Name: ad4a964158ba9ca9d221cf7ea0439577f3894890
* Change the names of external symbols from sqlite_XXX to sqlite3_XXX. (CVS 1338)danielk19772004-05-10
| | | FossilOrigin-Name: 2242423e31a5e81e89ffcc99e62307c5cc0120d5
* Change lots of internal symbols from sqliteXXX to sqlite3XXX so that thedanielk19772004-05-08
| | | | | | library links again. It doesn't work yet, due to changes in the btree layer calling convention. (CVS 1324) FossilOrigin-Name: 8af6474c49263ae26216dff9465b33f76b500cf4
* More code cleanup and size reduction. (CVS 1256)drh2004-02-21
| | | FossilOrigin-Name: 8e3eda2a909bd80b2b14ace36ab44303750a4409
* Fixed behaviour of last_insert_rowid() with triggers and add ↵rdc2004-02-20
| | | | | last_statement_change_count() function that works correctly with triggers. (CVS 1251) FossilOrigin-Name: 3383413a53bff0fef0765144de3bb9a298a5bb5c
* Eliminate the use of callbacks during schema initialization. (CVS 1242)drh2004-02-14
| | | FossilOrigin-Name: af5c2be4aed1c50f69eb9634cf051a26263dcf51
* 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
* Additional testing of the ATTACH command with bug fixes for the new problemsdrh2003-06-03
| | | | | that the tests found. (CVS 998) FossilOrigin-Name: 3e8889d7ce5e99fc855526fc1bb62ddbe282bfc5
* 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
* VDBE cursors numbers for tables in a join do not have to be consecutive.drh2003-05-02
| | | | | This is one step on the road to fixing ticket #272. (CVS 947) FossilOrigin-Name: be7aed2011b4af868b6a0c370c3d41354ae0cdf4
* Report the correct authorization context in the authorization callbackdrh2003-04-25
| | | | | when coding an INSTEAD OF trigger on an update or delete. (CVS 936) FossilOrigin-Name: 67746833fc8de3afff80db413bd63a362bb28218
* Fix some issues with INSTEAD OF triggers. (CVS 930)drh2003-04-24
| | | FossilOrigin-Name: 206b17397b1d2b55179c935927ff1d8215728c32
* Update the authorizer API so that it reports the database that table anddrh2003-04-22
| | | | | | indices belong to and so that it reports when actions are taken in response to a trigger. (CVS 928) FossilOrigin-Name: c675a5504138f34cae6def782b5d3add2c67d2bc
* Add support for TEMPORARY triggers. Such triggers can write temporary ordrh2003-04-21
| | | | | permanent tables. (CVS 926) FossilOrigin-Name: 58ddd587b0f5d565ae3b0ba3a1fa5c20d459f3fc
* Fix triggers to work in an ATTACHed database. Ticket #295. (CVS 915)drh2003-04-17
| | | FossilOrigin-Name: 1e5e00fb73c308378efd034cb291caf338c9fe84
* Get triggers working on tables with INTEGER PRIMARY KEYs. Ticket #291.drh2003-04-15
| | | | | | This may also fix #159. Still need to add tests so both bugs remain open for the time being. (CVS 908) FossilOrigin-Name: 0b996959b8d8bc2c82eab9cccc190befd0056505
* Add the sqliteErrorMsg() function and use it to generate error messagedrh2003-03-31
| | | | | | text during parsing and code generation. This simplifies the code somewhat and makes it easier to handle names with a database prefix. (CVS 891) FossilOrigin-Name: 1d3fc977211abdc7ba3fd51d661863e8ce5aef69
* Fix a memory leak in triggers and update tests to show the latest errordrh2003-03-30
| | | | | message text. (CVS 886) FossilOrigin-Name: b90d9de32d10a71fe81f5bfd0cf57faae8c5c3b4
* Regression tests now work - except for some changes in error messagedrh2003-03-27
| | | | | text. The library is now safe to use for experimental work. (CVS 885) FossilOrigin-Name: 8a593e9c2d57e758739a7ef54fa40ca6a0071a9a
* Fix a segfault in the trigger code. (CVS 884)drh2003-03-27
| | | FossilOrigin-Name: 7672914b196cd55744edda8e5d8f1b7b86f898f9
* Changes to the "sqlite" structure that allow simultaneous operations ondrh2003-03-27
| | | | | | multiple database files. Many regession tests pass - but not all of them. Do not use this version except for debugging SQLite itself. (CVS 883) FossilOrigin-Name: d2fb2bb50cf1e13feb90995079f291384abd6ba9
* Record the database name in addition to the table name for DELETE, INSERT,drh2003-03-20
| | | | | and UPDATE statements. (CVS 879) FossilOrigin-Name: a5d8fc95ee58dc3205a0bbbcadaa3b9c902a941b
* More tests of the sqlite_set_authorizer() API together with fixes for bugsdrh2003-01-14
| | | | | that the new tests uncovered. (CVS 832) FossilOrigin-Name: cc2ae781ac186f9ee1afacdc9117087421955369
* Revise the sqlite_set_authorizer API to provide more detailed informationdrh2003-01-13
| | | | | about the SQL statement being authorized. Only partially tested so far. (CVS 830) FossilOrigin-Name: 45de93f913a18026a45de6254963dbcd1b0f1a19
* Initial check-in of the code for the new sqlite_set_authorizer() API function.drh2003-01-12
| | | | | The code is mostly untested at this point. (CVS 827) FossilOrigin-Name: 52d5007f64d0af5286b2a0e1f0b9e53c86bece3f
* Do not put a write lock on the main database file when writing to a temporarydrh2002-09-14
| | | | | table. (CVS 750) FossilOrigin-Name: 3f253afe15d4f7392555f340a41d780d1248087f
* Fix for ticket #136: Added the OP_RenameCursor VDBE instruction and used itdrh2002-08-25
| | | | | | to make cursor numbers right on nested subqueries. Also added OP_Gosub and OP_Return but have not actually used them for anything yet. (CVS 727) FossilOrigin-Name: c602603e7cd8dc5c8bb9db2748eacab650de5bf0
* Change the way token memory is allocated in an effort to fix ticket #136.drh2002-08-24
| | | | | There is now a memory leak when using views of views. (CVS 725) FossilOrigin-Name: 22d8726e61eec0e53893f492cb2163824b87a23e
* Added support for the "sqlite_temp_master" table. Increased the versiondrh2002-06-25
| | | | | number to 2.5.2. (CVS 640) FossilOrigin-Name: 9c1432bf7485258e485bd652e3acdaeabbfe8850
* Add RAISE() function, which allows more advanced flow-control in trigger ↵danielk19772002-06-11
| | | | | programs (ticket #55) (CVS 614) FossilOrigin-Name: d4a2fb10067203a0d49317db747759872e62927e
* A SELECT statement inside the body of a TRIGGER uses the SRT_Discard targetdrh2002-05-27
| | | | | | to discard the query results. Such selects are intended to be used to call user-defined functions for their side-effects. They do not return results. (CVS 594) FossilOrigin-Name: f8041f3d4d3350b4086cd6ba3e9006bdde8546a9
* Require the INSTEAD OF syntax to create triggers on database views. (CVS 591)danielk19772002-05-26
| | | FossilOrigin-Name: d9e48cd5180e2aae7672b9d54e18c37d0fe5258a
* NULL values are distinct. A comparison involving a NULL is always false.drh2002-05-26
| | | | | | | | Operations on a NULL value yield a NULL result. This change makes SQLite operate more like the SQL spec, but it may break existing applications that assumed the old behavior. All the old tests pass but we still need to add new tests to better verify the new behavior. Fix for ticket #44. (CVS 589) FossilOrigin-Name: 9051173742f1b0e15a809d12a0c9c98fd2c4614d
* Initial implementation of LEFT OUTER JOIN including the expanded SQL92 joindrh2002-05-24
| | | | | | syntax. The basic functionality is there but there is still a lot of testing to do. (CVS 587) FossilOrigin-Name: 99bd1f5b9a1a20bfeefe15c00d96a34a5f40923e
* Split the IdList structure into IdList and SrcList. SrcList is used todrh2002-05-24
| | | | | | | represent a FROM clause and IdList is used for everything else. This change allows SrcList to grow to support outer joins without burdening the other uses of IdList. (CVS 584) FossilOrigin-Name: a167b71d8c27e870bc3079c6132e483bffc83298
* Change the names of the PushList and PopList opcodes to ListPush and ListPopdrh2002-05-23
| | | | | | so that they will appear together with the other List opcodes in the documentation. (CVS 583) FossilOrigin-Name: c53b0b9283c5c34def87d58b03fd979d03dc0890
* Fix some places where a malloc() failure would lead to a segfault. (CVS 580)drh2002-05-23
| | | FossilOrigin-Name: 01ad352c3c82a86d9c94010cbc85d098b8fbc08a
* Do not allow triggers on the SQLITE_MASTER table. (CVS 579)drh2002-05-23
| | | FossilOrigin-Name: 275ba356f351abcf9a079ac16b765c9443750f0e
* Clean up some compiler warnings. (CVS 575)drh2002-05-21
| | | FossilOrigin-Name: 3399b01219b9e75b93587b5634d199d9e6fb6e42
* Additional code cleanup resulting from a review of the new trigger code. ↵drh2002-05-21
| | | | | (CVS 572) FossilOrigin-Name: 37dbdd551e88440933066133ec9cc1e10b03fc1a
* Style fixes to triggers code in various *.c files (partial fix to ticket ↵danielk19772002-05-19
| | | | | #39) (CVS 571) FossilOrigin-Name: 8a4195c7466962291a296e8f53034ea8cb25005f
* Stylistic changes to src/trigger.c (partial fix to ticket #39). Also more ↵danielk19772002-05-17
| | | | | comments. (CVS 570) FossilOrigin-Name: b1d72cb5847a9f5f08e40b36ad117b5493232ea7
* Beginning to clean up the trigger code. Still lots of work to do. (CVS 566)drh2002-05-15
| | | FossilOrigin-Name: b10346818b25940c6dc85e94de8e36d20954161c
* Remove all tabs from the beginning of source code lines. Replace tabs withdrh2002-05-15
| | | | | the appropriate number of spaces. (CVS 565) FossilOrigin-Name: 690f9a163173c4c7af7e8e92e942cee4184c7974