/ History for src/trigger.c
Login

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

History for src/trigger.c

2020-08-11
14:55
[595153f5] part of check-in [b1a77b7e] Merge all changes since the 3.32.0 release into the reuse-schema branch. (check-in: [b1a77b7e] user: drh branch: reuse-schema, size: 43360)
2020-07-16
02:36
[ef67bde3] part of check-in [706c8da2] Fix a double-free of the FROM clause of an UPDATE inside of triggers. (check-in: [706c8da2] user: drh branch: update-from, size: 42531)
2020-07-14
19:51
[6ff9c64a] part of check-in [4f6d8d0e] Support UPDATE...FROM statements in trigger programs. (check-in: [4f6d8d0e] user: dan branch: update-from, size: 42577)
2020-06-19
13:33
[58721162] part of check-in [9536fa0a] Further refactoring of the schema table name. (check-in: [9536fa0a] user: drh branch: trunk, size: 42211)
2020-06-15
20:27
[6b1472e6] part of check-in [61782a7a] Provide "sqlite_schema" as an alternative name to the table that holds the database schema. (check-in: [61782a7a] user: drh branch: trunk, size: 42211)
2020-05-16
19:00
[fe34ac58] part of check-in [5af4abe9] Merge trunk enhancements in the reuse-schema branch. (Actual date of this check-in is 2020-05-18.) (check-in: [5af4abe9] user: drh branch: reuse-schema, size: 43019)
2020-03-21
15:10
[4ada1037] part of check-in [a85c63da] Consolidate some code on this branch. (check-in: [a85c63da] user: dan branch: main-alias-fix, size: 42190)
2020-03-20
20:54
[101b9c33] part of check-in [75c85ca3] Allow "main" to be used to refer to the main database even after SQLITE_DBCONFIG_MAINDBNAME has been used to assign another alias. (check-in: [75c85ca3] user: dan branch: main-alias-fix, size: 42258)
2020-01-17
15:24
[132009e2] part of check-in [3d13fbf2] Validate the type, name, and tbl_name fields of the sqlite_master table when loading the schema, unless writable_schema is engaged. (check-in: [3d13fbf2] user: drh branch: branch-3.28, size: 42007)
2020-01-15
14:26
[82562904] part of check-in [f7839178] Merge all recent enhancements and fixes from trunk. (check-in: [f7839178] user: drh branch: reuse-schema, size: 43028)
2019-12-12
20:22
[a40d50e8] part of check-in [d3783357] Change the name of the Expr.a.zName field to zEName, so that it has a name that is distinct from other fields and variables and is hence easier to grep for. (check-in: [d3783357] user: drh branch: two-size-lookaside, size: 42199)
2019-12-03
03:34
[681ccdb9] part of check-in [c4cb9708] Avoid a crash that could occur when a database containing a table with a temp trigger that has the same name as a temp table is detached. (check-in: [c4cb9708] user: dan branch: trunk, size: 42198)
2019-09-16
12:35
[63761fc1] part of check-in [27eb2236] Merge all recent trunk enhancements into the reuse-schema branch. (check-in: [27eb2236] user: drh branch: reuse-schema, size: 42961)
2019-08-27
19:59
[845ccc08] part of check-in [94085fb3] Add support for "ORDER BY ... NULLS FIRST" and "ORDER BY ... NULLS LAST". Use this to fix ticket [f8a7060e]. (check-in: [94085fb3] user: dan branch: trunk, size: 42132)
10:05
[f964d859] part of check-in [069c2f4c] 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] (check-in: [069c2f4c] user: drh branch: trunk, size: 42044)
2019-08-19
17:26
[d115eb6c] part of check-in [bb9767a2] Prevent NULLS FIRST/LAST from being used in CREATE INDEX and other statements. (check-in: [bb9767a2] user: dan branch: nulls-last, size: 42119)
2019-08-13
15:22
[fbe9b54f] part of check-in [5b4689d8] Merge latest trunk changes with this branch. (check-in: [5b4689d8] user: dan branch: reuse-schema, size: 42860)
2019-08-12
00:08
[23052718] part of check-in [724f4df9] Validate the type, name, and tbl_name fields of the sqlite_master table when loading the schema, unless writable_schema is engaged. (check-in: [724f4df9] user: drh branch: trunk, size: 42031)
2019-07-26
20:54
[b6a3541d] part of check-in [7f1e4e4b] Merge latest changes from trunk into this branch. (check-in: [7f1e4e4b] user: dan branch: reuse-schema, size: 42777)
2019-07-16
19:44
[563df580] part of check-in [9e664585] Add new assert() statements in an attempt to help static analyzers avoid false-positives. (check-in: [9e664585] user: drh branch: trunk, size: 41948)
2019-03-21
17:13
[020d7ad6] part of check-in [b8e53608] Disable the feature on this branch in non-SQLITE_ENABLE_SHARED_SCHEMA builds. (check-in: [b8e53608] user: dan branch: reuse-schema, size: 42753)
2019-03-20
20:02
[665001b5] part of check-in [c1be211c] Use the IsReuseSchema() macro more consistently. Also, rename it to IsSharedSchema(). (check-in: [c1be211c] user: dan branch: reuse-schema, size: 42500)
2019-02-08
19:30
[3d8c6173] part of check-in [2b2e9f81] Add test cases and fix problems on this branch. (check-in: [2b2e9f81] user: dan branch: reuse-schema, size: 42498)
2019-02-05
19:51
[5714a8d2] part of check-in [c089cc4f] Merge latest trunk into this branch. (check-in: [c089cc4f] user: dan branch: reuse-schema, size: 41967)
2019-01-17
15:40
[bb034c08] part of check-in [df08d472] Revamp the SrcList allocator routines to be methods of Parse instead of being methods of the "sqlite3" object, so that they can leave better error messages when the SrcList object grows too large. (check-in: [df08d472] user: drh branch: trunk, size: 41924)
2018-12-29
02:26
[77546bf5] part of check-in [4a0929ac] A new implementation of sqlite3VdbeMakeLabel() is faster and makes fewer memory allocations by deferring memory allocation until sqlite3VdbeResolveLabel() is called, at which point the code generator has a better idea of how big the relocation table needs to be. The sqlite3VdbeMakeLabel() routine now takes a Parse* parameter instead of Vdbe*. (check-in: [4a0929ac] user: drh branch: trunk, size: 41920)
2018-12-21
19:29
[252b6503] part of check-in [25666e3d] Add new sqlite3_prepare_v3() flag SQLITE_PREPARE_NO_VTAB, for preparing statements that are not allowed to use any virtual tables. Use this to prevent circular references in triggers on virtual table shadow tables from causing resource leaks. (check-in: [25666e3d] user: dan branch: prepare-no-vtab, size: 41912)
2018-11-20
16:02
[e143e102] part of check-in [dfab7170] Consolidate the two sqlite3SchemaToIndex() routines. (check-in: [dfab7170] user: dan branch: reuse-schema1, size: 42092)
2018-11-17
18:11
[dc20aaa7] part of check-in [6d7a7e5f] Fix further problems with the feature on this branch. (check-in: [6d7a7e5f] user: dan branch: reuse-schema1, size: 42095)
2018-11-15
21:20
[6e970e8d] part of check-in [31b6aee7] Fix some problems with the feature on this branch. Many problems remain. (check-in: [31b6aee7] user: dan branch: reuse-schema1, size: 42083)
2018-10-08
18:58
[9ec37388] part of check-in [2ac72114] Merge latest trunk changes into this branch. (check-in: [2ac72114] user: dan branch: reuse-schema, size: 41907)
2018-08-29
21:00
[d3d78568] part of check-in [01308bae] Extend RENAME TABLE to edit triggers and views. Still buggy. (check-in: [01308bae] user: dan branch: alter-table-rename-table, size: 41864)
2018-08-15
20:28
[f6760d78] part of check-in [e272dc2b] Have ALTER TABLE RENAME COLUMN edit trigger programs. Only partly working. (check-in: [e272dc2b] user: dan branch: edit-trigger-wrapper, size: 41656)
2018-08-13
17:14
[f3ba315c] part of check-in [5fdb6b0a] Edit the WHEN and UPDATE OF clauses of trigger programs as part of ALTER TABLE RENAME COLUMN. (check-in: [5fdb6b0a] user: dan branch: edit-trigger-wrapper, size: 41247)
2018-04-18
01:34
[4ace6d1d] part of check-in [266a99f7] Add new testcase() macros and fix a bug that was revealed when trying to cover all the new test cases. (check-in: [266a99f7] user: drh branch: upsert, size: 40925)
2018-04-16
13:00
[fcb566b0] part of check-in [0203f34f] Add support for the "excluded.*" names in the UPDATE clause of an upsert. (check-in: [0203f34f] user: drh branch: upsert, size: 40875)
2018-04-12
13:15
[00ef0b16] part of check-in [d83eaed5] Add the Upsert object for holding upsert clause information. (check-in: [d83eaed5] user: drh branch: upsert, size: 40872)
2018-04-07
15:04
[974377de] part of check-in [5cc2a5a3] More complete parsing of UPSERT, including UPSERT within a trigger. The sqlite3Insert() logic to actually perform the UPSERT is not yet implemented, however. (check-in: [5cc2a5a3] user: drh branch: upsert, size: 40814)
2017-12-27
21:30
[a34539c6] part of check-in [fda08e3d] Omit all sqlite3_trace() output from the triggers associated with foreign key constraints. (check-in: [fda08e3d] user: drh branch: span-refactor, size: 40646)
20:38
[5fa038ae] part of check-in [fe3d2b97] Show the text of individual statements within a trigger, as they execute, as comments in the output from sqlite3_trace() and sqlite3_trace_v2(). (check-in: [fe3d2b97] user: drh branch: span-refactor, size: 40571)
2017-11-28
20:43
[775053ee] part of check-in [75d69987] Fix an assertion fault found by OSSFuzz. (check-in: [75d69987] user: dan branch: trunk, size: 39253)
2017-11-14
23:48
[fc6be2a6] part of check-in [3925facd] In the parse tree, combine LIMIT and OFFSET into a single expression rooted on a TK_LIMIT node, for a small code size reduction and performance increase, and a reduction in code complexity. (check-in: [3925facd] user: drh branch: trunk, size: 39234)
18:26
[bdee9c6f] part of check-in [b2679d3b] Fix the SQLITE_ENABLE_UPDATE_DELETE_LIMIT functionality so that it works with views and WITHOUT ROWID tables. This is a modified cherrypick of [dae4a97a]. (check-in: [b2679d3b] user: dan branch: branch-3.8.9, size: 40053)
2017-11-10
20:13
[929b12bb] part of check-in [72be33f9] Omit some extra code from non-SQLITE_ENABLE_UPDATE_DELETE_LIMIT builds. (check-in: [72be33f9] user: dan branch: update-delete-limit-fix, size: 39240)
2017-08-09
20:35
[bda24e17] part of check-in [a6256980] Add experimental sqlite3_open_v2() flag SQLITE_OPEN_REUSE_SCHEMA. For sharing identical in-memory schema objects between connections. (check-in: [a6256980] user: dan branch: reuse-schema, size: 39265)
2017-07-26
19:59
[48e0f7ed] part of check-in [3808a00f] Add the new sqlite3.mDbFlags field. Factor out bits of sqlite3.flags that do not interact with PRAGMA statements into sqlite3.mDbFlags. (check-in: [3808a00f] user: drh branch: trunk, size: 39222)
2017-06-08
14:35
[d1cae560] part of check-in [343e5599] Add a testcase() to confirm that an OOM on sqlite3DbStrNDup() is handled correctly in trigger.c. (check-in: [343e5599] user: drh branch: trunk, size: 39220)
2017-04-17
17:03
[134b8e7b] part of check-in [159e8022] Add support for analyzing trigger programs to the sqlite3_expert code. (check-in: [159e8022] user: dan branch: schemalint, size: 39187)
2016-12-16
01:00
[c9f08100] part of check-in [8d646905] All temp.sqlite_master to be used as an alias for sqlite_temp_master. (check-in: [8d646905] user: drh branch: trunk, size: 39198)
2016-09-18
16:08
[3419bb98] part of check-in [6bf5ba10] Revise the implementation of OP_Once so that it is smaller, faster, and uses less memory. This also fixes an obscure bug introduced 3 days ago by check-in [5990a1bdb4a073]. (check-in: [6bf5ba10] user: drh branch: trunk, size: 39210)
2016-09-16
11:53
[cae81f6c] part of check-in [a3e3b3e1] Fix SQLITE_OMIT_AUTHORIZATION so that it compiles cleanly. (check-in: [a3e3b3e1] user: drh branch: trunk, size: 39250)
2016-08-18
14:33
[11e20b3b] part of check-in [92a22f01] Rename the Db.zName field to Db.zDbSName to make it more descriptive and to distinguish it from all of the other "zName" variables scattered throughout the code. (check-in: [92a22f01] user: drh branch: zDbSName, size: 39311)
2016-02-05
01:55
[e14840ee] part of check-in [c3ef0347] Improvements to the way that OOM errors are processed. (check-in: [c3ef0347] user: drh branch: oom-handling, size: 39249)
2016-01-22
17:48
[72d876b2] part of check-in [73231753] Add the sqlite3TokenInit() utility function. (check-in: [73231753] user: drh branch: trunk, size: 39250)
2016-01-16
15:12
[056e5118] part of check-in [a4258cd4] Use sqlite3VdbeAddOp4() rather than a separate sqlite3VdbeChangeP4() call, for a slightly smaller and faster binary. (check-in: [a4258cd4] user: drh branch: trunk, size: 39280)
2015-12-09
16:08
[de3ed31a] part of check-in [c80bbf14] Fix a problem with the DROP TABLE command on this branch. (check-in: [c80bbf14] user: dan branch: onepass-delete-or, size: 39290)
2015-05-21
02:20
[bc7f94ec] part of check-in [9e3f64a4] Ensure that tables names are dequoted exactly once by the trigger logic. Cherrypick [59e92bd9521f1e8] and [9d887b92f8086961e]. (check-in: [9e3f64a4] user: drh branch: branch-3.7.11, size: 40405)
2015-05-20
20:30
[27487473] part of check-in [bd357739] Ensure that tables names are dequoted exactly once by the trigger and FK logic. Cherrypick of [59e92bd9521f] and [9d887b92f808]. (check-in: [bd357739] user: dan branch: branch-3.8.6, size: 40272)
2015-04-21
16:38
[322f23aa] part of check-in [9d887b92] Ensure that tables names are dequoted exactly once by the trigger logic. (check-in: [9d887b92] user: dan branch: trunk, size: 40033)
03:13
[45db6f59] part of check-in [59e92bd9] Fix some identifier name de-quoting issues in the foreign key and trigger logic. (check-in: [59e92bd9] user: drh branch: trunk, size: 40107)
2015-04-17
18:22
[bc647c71] part of check-in [3f3b0f68] Remove unnecessary parser error count increments. Let the sqlite3ErrorMsg() take care of doing that. (check-in: [3f3b0f68] user: drh branch: trunk, size: 40014)
2015-04-16
15:47
[a261da05] part of check-in [928f973c] Make sure errors in coding triggers are propagated back up to the parser. (check-in: [928f973c] user: drh branch: trunk, size: 40034)
2015-04-09
16:30
[69a91bed] part of check-in [83b342a4] Remove two pointless assert() statements. This should silence harmless compiler warnings reported at https://bugzilla.mozilla.org/show_bug.cgi?id=1152845 (check-in: [83b342a4] user: drh branch: trunk, size: 40009)
2014-11-22
09:09
[6dcdf46a] part of check-in [600cefdd] Add SQLITE_ENABLE_OTA pre-processor directives so that this branch may be compiled with or without OTA. (check-in: [600cefdd] user: dan branch: ota-update, size: 40222)
2014-09-17
15:20
[eb921d12] part of check-in [39df35c4] Add tests and fixes for "PRAGMA ota_mode". (check-in: [39df35c4] user: dan branch: ota-update, size: 40216)
2014-09-06
16:39
[25571661] part of check-in [e62aab5e] Fix typos in comments. No code changes. (check-in: [e62aab5e] user: peter.d.reid branch: trunk, size: 40035)
2014-08-21
20:26
[4bddd128] part of check-in [14b0f561] Simplify the interface to the symbol table, saving 600 bytes of code space. (check-in: [14b0f561] user: drh branch: trunk, size: 40035)
2014-03-10
18:03
[66f3470b] part of check-in [0a5318bc] Attempt to work around MSVC's treatment of __LINE__ as a non-constant value in "Edit and Continue" mode by avoiding the use of __LINE__ when SQLITE_VDBE_COVERAGE is not defined. (check-in: [0a5318bc] user: drh branch: trunk, size: 40279)
2014-02-17
22:40
[a80036fc] part of check-in [ce184c7b] Add logic to do test coverage measurements on the VDBE code. (check-in: [ce184c7b] user: drh branch: insert-optimization, size: 40268)
2014-02-08
01:40
[a417d386] part of check-in [192dea97] Change the OP_Trace opcode to OP_Init and give it the ability to jump to the initialization code at the bottom of the program, thus avoiding the need for an extra OP_Goto. (check-in: [192dea97] user: drh branch: trunk, size: 40224)
2014-01-10
20:46
[5c1c0b89] part of check-in [c9ea7d19] Allow a VALUES clause to be used any place that a SELECT statement can be used. (check-in: [c9ea7d19] user: drh branch: trunk, size: 40695)
2013-11-15
01:10
[d84e1f36] part of check-in [8dc5c76c] Rework the logic that factors constant expressions out of inner loops, making it both simpler and faster. (check-in: [8dc5c76c] user: drh branch: expr-codegen-enhancement, size: 40998)
2013-10-30
02:28
[53d6b5d5] part of check-in [e1a89b56] Add the SQLITE_ENABLE_EXPLAIN_COMMENTS compile-time option to enable extra commentary in the EXPLAIN output. Formerly, this was only available with SQLITE_DEBUG. (check-in: [e1a89b56] user: drh branch: trunk, size: 40965)
2013-10-03
15:39
[ba0a883c] part of check-in [500c5932] The sqlite3FixInit() routine cannot fail. So change the return type from "int" to "void". (check-in: [500c5932] user: drh branch: trunk, size: 40947)
12:29
[9e6976b6] part of check-in [f35f6ae3] Return an error if an attempt is made to create a trigger with an SQL 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. (check-in: [f35f6ae3] user: dan branch: trunk, size: 40963)
2013-05-28
12:11
[5c0ea9b8] part of check-in [a0d5cc93] Many small harmless comment changes. Removal of obsolete comments and fixing misspelled words. No changes to code. (check-in: [a0d5cc93] user: drh branch: trunk, size: 40919)
2012-12-06
20:27
[84f90c64] part of check-in [34aafb74] Cherrypick [79ef8e3c77] (Apply the same restrictions on constant refactoring to statements within a trigger program as top-level statements). (check-in: [34aafb74] user: dan branch: branch-3.7.9, size: 40923)
19:37
[cd95ac64] part of check-in [0c31a468] Apply the same restrictions on constant refactoring to statements within a trigger program as top-level statements. Candidate fix for [ae3c5670b6]. (check-in: [0c31a468] user: dan branch: constant-refactoring-in-triggers, size: 40919)
2012-08-25
10:01
[3f258307] part of check-in [9b19b847] Fix all known instances of 'repeated the' style typos in comments. No changes to code. (check-in: [9b19b847] user: mistachkin branch: trunk, size: 40408)
2011-12-09
13:24
[ee7e178f] part of check-in [557c6905] Modify the OP_Once opcode so that it works correctly in trigger sub-programs. This is a candidate fix for [7bbfb7d442]. (check-in: [557c6905] user: dan branch: trunk, size: 40412)
2011-07-01
13:50
[1cfb80e2] part of check-in [009c96ea] Ignore the database name on the target table when parsing a CREATE TABLE statement out of the sqlite_master table. This is a fix for ticket [d6ddba6706353] that preserves backwards compatibility. (check-in: [009c96ea] user: drh branch: trunk, size: 40372)
2011-06-03
20:11
[c836a6ca] part of check-in [957b2ab6] Create and use a function especially for adding the ParseSchema opcode. This gives a small reduction in code and a small performance increase. (check-in: [957b2ab6] user: drh branch: trunk, size: 39906)
2011-04-09
17:32
[144cc18b] part of check-in [a46f3290] Add VerifyCookie instructions to "DROP XXX IF EXISTS" statements if the specified database object does not exist when the statement is prepared. (check-in: [a46f3290] user: dan branch: trunk, size: 39936)
15:39
[c31aeb3c] part of check-in [b9dbd993] Add an OP_VerifyCookie instruction to "CREATE XXX IF NOT EXISTS" commands. 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). (check-in: [b9dbd993] user: dan branch: trunk, size: 39876)
2011-04-05
13:12
[d5bc8b9f] part of check-in [5db4511d] Merge the scheme-parse-refactor changes into trunk: (1) added sqlite3SchemaMutexHeld() asserts, (2) Use -1 instead of 0 to mean "all" in sqlite3ResetInternalSchema(), and other cosmetic changes. (check-in: [5db4511d] user: drh branch: trunk, size: 39789)
12:25
[4c1ed08b] part of check-in [bf664b20] Fix the P4_TRANSIENT constant so that it works correct - so that it really makes a copy of the string for the P4 argument. Use P4_TRANSIENT wherever appropriate. Change P4_STATICs of schema names to P4_TRANSIENT. (check-in: [bf664b20] user: drh branch: trunk, size: 39465)
2011-04-04
18:22
[bb68c3d1] part of check-in [ae8374af] Add a description of access rules for the Schema object and lots of asserts to verify that the access rules are followed. (check-in: [ae8374af] user: drh branch: schema-parse-refactor, size: 39778)
2011-03-21
17:15
[ec481370] part of check-in [09e167f9] Add the ability to enable and disable foreign key constraints and triggers using calls to sqlite3_db_config(). (check-in: [09e167f9] user: drh branch: trunk, size: 39454)
2011-03-06
21:28
[95d2ff4b] part of check-in [01a79d5a] Remove dead code identified by the clang static analyzer. (check-in: [01a79d5a] user: drh branch: trunk, size: 39379)
2010-07-26
12:05
[b8bedb9c] part of check-in [00e55102] Change the way SubProgram objects are deleted so that the code is the same for deletion and measurement. (check-in: [00e55102] user: dan branch: experimental, size: 39410)
2010-06-28
10:15
[67e95c76] part of check-in [4932f228] Currently, if SQLite cannot find a table or index referred to by a query, it 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.). (check-in: [4932f228] user: dan branch: trunk, size: 39347)
2010-04-06
15:57
[8927588c] part of check-in [1b2a0412] Automatically generate transient indices for tables in joins that would otherwise have to use a full table scan. (check-in: [1b2a0412] user: drh branch: experimental, size: 39318)
2010-02-15
16:54
[340c9eca] part of check-in [ec914af3] When creating a trigger on a main database table when there is a TEMP table with the same name, make sure the trigger is bound to the main table. Ticket [985771e11612]. (check-in: [ec914af3] user: drh branch: trunk, size: 39272)
15:47
[a188f616] part of check-in [c727601e] Fix a compiler warning in shell.c. Updates to comments in trigger.c. (check-in: [c727601e] user: drh branch: trunk, size: 39244)
2009-11-27
12:12
[d46f9389] part of check-in [1b7c5250] Move [7d30880114] to the trunk. Add optimizations to reduce the number of opcodes used for BEFORE UPDATE triggers. (check-in: [1b7c5250] user: dan branch: trunk, size: 39232)
2009-11-10
01:30
[3c48db13] part of check-in [f6c045f6] Remove the obsolete "$Id:$" RCS identifier strings from the source code. (check-in: [f6c045f6] user: drh branch: trunk, size: 38474)
2009-10-13
19:19
[2053afa9] part of check-in [e0aa50c3] Fixed warnings with MSVC compile. (check-in: [e0aa50c3] user: shane branch: trunk, size: 38484)
2009-09-28
14:49
[643e27f9] part of check-in [8353808c] Fix the DROP TABLE command so that it cannot be used to bypass foreign key constraints (if foreign key support is enabled). (check-in: [8353808c] user: dan branch: trunk, size: 38478)
2009-09-24
09:05
[d2f31617] part of check-in [0443f7c9] Remove unused parameter from sqlite3CodeRowTrigger(). Fix header comments for this function and CodeRowTriggerDirect(). (check-in: [0443f7c9] user: dan branch: trunk, size: 38426)
2009-09-19
17:00
[c0d99c25] part of check-in [d5d39981] Check in implementation of foreign key constraints. (check-in: [d5d39981] user: dan branch: trunk, size: 37372)
2009-09-17
00:41
[45a2f8a8] part of check-in [03e464be] When coding a trigger, assume that the "oldmask" requires all columns until we know otherwise. That pessimistic assumption assures that all necessary parameters are available on a cascading delete trigger. Ticket [e25d9ea771f] (check-in: [03e464be] user: drh branch: trunk, size: 36538)
2009-09-08
02:27
[054c0833] part of check-in [b271e166] Further simplifications to the VDBE - removing functionality that is no longer used. (check-in: [b271e166] user: drh branch: trunk, size: 36508)
2009-09-07
04:38
[55cdf9d5] part of check-in [26cd015c] Warning cleanup from the MSVC compile. (check-in: [26cd015c] user: shane branch: trunk, size: 36511)
2009-09-01
12:16
[8158237f] part of check-in [38a9327b] More fixes and comment updates. (check-in: [38a9327b] user: dan branch: trunk, size: 36478)
2009-08-31
15:27
[d652d3a0] part of check-in [85d9f23b] More fixes for test cases. (check-in: [85d9f23b] user: dan branch: trunk, size: 35407)
08:22
[2b0bdab4] part of check-in [8a746fbf] Fix some authorization callback problems. (check-in: [8a746fbf] user: dan branch: trunk, size: 34910)
05:23
[42c93d1c] part of check-in [31199db0] Fix another test problem and some instances where an OOM may cause a segfault. (check-in: [31199db0] user: dan branch: trunk, size: 35063)
2009-08-30
11:42
[26e493ef] part of check-in [9eb91efd] Fixes for new triggers scheme. (check-in: [9eb91efd] user: dan branch: trunk, size: 34986)
2009-08-28
18:53
[135c1fc7] part of check-in [9b9c1921] Changes to support recursive triggers. (check-in: [9b9c1921] user: dan branch: trunk, size: 34605)
2009-08-24
01:35
[545f3b83] part of check-in [dee1b8eb] Run the column cache in a new context when generating code for trigger programs. Fix for ticket [efc02f9779]. (check-in: [dee1b8eb] user: drh branch: trunk, size: 30589)
2009-08-10
03:57
[9bc5278d] part of check-in [ee034cfc] Removed some warnings from the MSVC compile. (CVS 6965) (check-in: [ee034cfc] user: shane branch: trunk, size: 30515)
2009-08-06
17:43
[f2488510] part of check-in [ba1afc04] Alternative fix for ticket #3810. This is a replacement for check-in (6956). (CVS 6960) (check-in: [ba1afc04] user: drh branch: trunk, size: 30513)
2009-05-28
01:00
[c07c5157] part of check-in [4ac2bdfb] Additional refinements to Expr handling. Restore compression of trigger expressions. Change Expr.zToken to Expr.u.zToken and added Expr.u.iValue. Remove an unnecessary ExprDup from CHECK constraint processing. And so forth. (CVS 6682) (check-in: [4ac2bdfb] user: drh branch: trunk, size: 29766)
2009-05-27
10:31
[6d233d6d] part of check-in [7cb1c3ba] Simplifications to the Expr object: Remove Expr.span completely and convert Expr.token into a char* Expr.zToken. Also simplify the Token object by removing the Token.dyn and Token.quoted fields. (CVS 6681) (check-in: [7cb1c3ba] user: drh branch: trunk, size: 29669)
2009-05-09
00:18
[853bb30f] part of check-in [567ccc68] Changes to the trigger.c module that facilitate full coverage testing. (CVS 6621) (check-in: [567ccc68] user: drh branch: trunk, size: 30709)
2009-05-06
18:42
[5dcdcf5c] part of check-in [37428435] Fix three variable initialization problems found by valgrind. (CVS 6612) (check-in: [37428435] user: drh branch: trunk, size: 29928)
2009-04-28
13:01
[448615be] part of check-in [23d67af3] Do not store the zero string terminator as part of the name when holding symbols in the symbol table. (CVS 6557) (check-in: [23d67af3] user: drh branch: trunk, size: 29908)
2009-04-23
13:22
[c029d526] part of check-in [dd4d67a6] Rework the column-cache mechanism to be more robust (and more correct). The column-alias cache is currently disabled, (CVS 6538) (check-in: [dd4d67a6] user: drh branch: trunk, size: 29916)
2009-02-28
10:47
[21f39db4] part of check-in [3befe1ef] Instead of linking temporary triggers on non-temporary tables into the Table.pTrigger list, search the temp schema for them on demand. Fix for #3688. (CVS 6329) (check-in: [3befe1ef] user: danielk1977 branch: trunk, size: 29934)
2009-02-19
14:39
[9957e16e] part of check-in [d9f6ffbc] Changes to reduce the heap space consumed by triggers, views and tables in the in-memory representation of the schema. Also to reduce the space used by prepared statements slightly. (CVS 6305) (check-in: [d9f6ffbc] user: danielk1977 branch: trunk, size: 29180)
2008-12-26
07:56
[ca6d78f7] part of check-in [a1b1f6cd] Reset the column cache before coding each step of a trigger program. Candidate fix for #3554. (CVS 6065) (check-in: [a1b1f6cd] user: danielk1977 branch: trunk, size: 29065)
2008-12-10
19:26
[5a669d8f] part of check-in [c872d554] Never use strlen(). Use our own internal sqlite3Strlen30() which is guaranteed to never overflow an integer. Additional explicit casts to avoid nuisance warning messages. (CVS 6007) (check-in: [c872d554] user: drh branch: trunk, size: 29012)
2008-12-09
03:55
[9244c483] part of check-in [59ae0020] Get rid of more silly compiler warnings. (CVS 5996) (check-in: [59ae0020] user: drh branch: trunk, size: 28979)
2008-11-19
09:05
[b86eb6d2] part of check-in [88134322] Changes to avoid "unused parameter" compiler warnings. (CVS 5921) (check-in: [88134322] user: danielk1977 branch: trunk, size: 28840)
2008-08-20
16:35
[649940b5] part of check-in [daf730d1] Refactor the name resolution procedures in the code generator. (CVS 5569) (check-in: [daf730d1] user: drh branch: trunk, size: 28901)
2008-07-28
19:34
[b61aaf7b] part of check-in [e48f9697] Implement the "lookaside" memory allocation cache. Use of this cache makes the speed1.test script run about 15% faster. Added new interfaces to control the cache. (CVS 5488) (check-in: [e48f9697] user: drh branch: trunk, size: 28957)
2008-07-08
23:40
[bdb56bb9] part of check-in [cbd3c158] Remove obsolete code from select.c, including the "affinity" parameter to the sqlite3Select() module. (CVS 5380) (check-in: [cbd3c158] user: drh branch: trunk, size: 28775)
2008-05-16
04:51
[1e751f8d] part of check-in [81a8c70e] Add more version tags to files that lack them. Ticket #3120. (CVS 5137) (check-in: [81a8c70e] user: danielk1977 branch: trunk, size: 28786)
2008-01-17
16:22
[9bd3b6fa] part of check-in [706b41b7] Registerification of the VDBE is complete. The operand stack has been removed from the code. All instructions operate out of registers only. (CVS 4718) (check-in: [706b41b7] user: drh branch: trunk, size: 28718)
02:36
[5e869352] part of check-in [b3a141b2] Registerification of the WHERE clause logic. (CVS 4716) (check-in: [b3a141b2] user: drh branch: trunk, size: 28716)
2008-01-13
19:02
[3a863b99] part of check-in [23181f86] Fix some issues with out-of-memory recovery. (CVS 4710) (check-in: [23181f86] user: drh branch: trunk, size: 28716)
2008-01-12
21:35
[da3e11df] part of check-in [110c000d] The sqlite3_trace() callback now prints a message as each trigger fires within a statement. (CVS 4709) (check-in: [110c000d] user: drh branch: trunk, size: 28715)
2008-01-10
23:50
[69df777f] part of check-in [8cbd4651] More work toward converting the VM into a register-based machine. (CVS 4704) (check-in: [8cbd4651] user: drh branch: trunk, size: 28520)
2008-01-08
23:54
[1e77b3c2] part of check-in [8862ce9c] Registerify the comparison opcodes. (CVS 4697) (check-in: [8862ce9c] user: drh branch: trunk, size: 29741)
2008-01-06
00:25
[33071215] part of check-in [8201f717] Registerify the SRT_Subroutine destination for SELECT results. (CVS 4690) (check-in: [8201f717] user: drh branch: trunk, size: 29725)
2008-01-05
04:06
[91ff1552] part of check-in [cc149eb9] Get rid of OP_Dup, OP_MemStore, OP_MemLoad, and OP_MemMove. Replace with OP_Copy, OP_SCopy, and OP_Move. Add the infrastructure for operation properties in1, in2, in3, out2, and out3 but do not yet use any of these. (CVS 4682) (check-in: [cc149eb9] user: drh branch: trunk, size: 29690)
2008-01-03
18:03
[713b501b] part of check-in [0b849805] Registers (aka memory cells) in the VM are now numbered starting with 1 instead of 0. A register number of 0 means "no such register". (CVS 4669) (check-in: [0b849805] user: drh branch: trunk, size: 29690)
09:51
[caa971c1] part of check-in [46501f49] Change the OP_Insert opcode to read the key and data to insert from memory cells, not the stack. (CVS 4666) (check-in: [46501f49] user: danielk1977 branch: trunk, size: 29690)
01:28
[e7642cf6] part of check-in [4dc507d8] Revamp sqlite3VdbeAddOpList() so that the structure holds integer values for P1, P2, and P3. (CVS 4661) (check-in: [4dc507d8] user: drh branch: trunk, size: 29324)
00:01
[3267e5d6] part of check-in [027875e4] Refactoring the VM. The P3 parameter is changed to P4. A P5 parameter is added (though not currently used.) Add routines sqlite3VdbeAddOpX() where X is one of 0, 1, 2, 3, or 4. (CVS 4660) (check-in: [027875e4] user: drh branch: trunk, size: 29015)
2008-01-02
16:27
[907b819d] part of check-in [86dcdfe6] Combine the eDest and iParm arguments to sqlite3Select() into a single type - "SelectDest". (CVS 4657) (check-in: [86dcdfe6] user: danielk1977 branch: trunk, size: 28993)
00:34
[f8e2d42c] part of check-in [051ec01f] Begin setting a foundation on which to convert the VM from a stack-based to a register-based machine. Everything is still mostly stack based with this check-in. This change merely begins adding infrastructure to support a register-based architecture. (CVS 4652) (check-in: [051ec01f] user: drh branch: trunk, size: 28953)
2008-01-01
19:02
[24bdfee7] part of check-in [e08a33ed] Optimize trigger compilation to avoid populating the OLD.* and NEW.* pseudo-tables with data that will never be used. Some testing to come. (CVS 4651) (check-in: [e08a33ed] user: danielk1977 branch: trunk, size: 28957)
2007-11-16
14:55
[66695e13] part of check-in [c91bc8d3] Fix a crash that can occur after a malloc failure. Ticket #2775. (CVS 4547) (check-in: [c91bc8d3] user: danielk1977 branch: trunk, size: 28186)
2007-08-22
20:18
[724a77d5] part of check-in [db818430] The malloc.test script now passes all tests with no errors. (CVS 4271) (check-in: [db818430] user: drh branch: trunk, size: 28152)
2007-08-16
10:09
[dccc6fbf] part of check-in [77b16713] More work on refactoring of malloc() interfaces. There are still many errors. (CVS 4233) (check-in: [77b16713] user: danielk1977 branch: trunk, size: 28108)
04:30
[f29b1d40] part of check-in [deb7ecd6] Half-way through a major refactoring of the memory allocation. I have not even attempted to compile so I am certain there are countless errors. (CVS 4231) (check-in: [deb7ecd6] user: drh branch: trunk, size: 28098)
2007-08-07
17:13
[355cdf70] part of check-in [7550dd1d] Remove all tabs from source code files. Ticket #2556. (CVS 4198) (check-in: [7550dd1d] user: drh branch: trunk, size: 27591)
2007-04-06
11:26
[420192ef] part of check-in [8e2559b4] 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) (check-in: [8e2559b4] user: drh branch: trunk, size: 27549)
2007-03-31
01:34
[b3c22b72] part of check-in [6736f454] Fix memory leaks in WHERE clause processing and in TRIGGER parsing. (CVS 3775) (check-in: [6736f454] user: drh branch: trunk, size: 27638)
2007-03-30
20:40
[7f65762a] part of check-in [407a85e6] Fix a memory leak that occurs after a malloc failure in trigger parsing. (CVS 3772) (check-in: [407a85e6] user: drh branch: trunk, size: 27598)
2006-10-18
23:26
[8c55d318] part of check-in [ee4894b4] Fix a problems that arise if malloc() fails while compiling SELECT statements within a TRIGGER. (CVS 3478) (check-in: [ee4894b4] user: drh branch: trunk, size: 27520)
2006-09-11
23:45
[74ccec78] part of check-in [e4fe736c] Add support for IF EXISTS on CREATE/DROP TRIGGER/VIEW. Ticket #1899. (CVS 3406) (check-in: [e4fe736c] user: drh branch: trunk, size: 27509)
2006-06-14
19:00
[0fc40125] part of check-in [32c97b88] Added code to INSERT, DELETE and UPDATE virtual tables. The new code is mostly untested. (CVS 3248) (check-in: [32c97b88] user: drh branch: trunk, size: 27372)
2006-03-29
00:24
[48bbb94c] part of check-in [4ba280dd] Properly record the names of triggers even if the name is quoted. Ticket #1737. (CVS 3158) (check-in: [4ba280dd] user: drh branch: trunk, size: 27210)
2006-03-25
15:52
[825e5b98] part of check-in [c83ec81d] Add code to report an error on a recursive trigger, but leave it commented out - turning it on will likely break a lot of code. (CVS 3152) (check-in: [c83ec81d] user: drh branch: trunk, size: 27182)
2006-03-06
20:55
[6e63d6d8] part of check-in [e510e6dd] Code changes resulting from Coverity analysis. http://scan.coverity.com/ Found 1 potential segfault in sqlite3_mprintf(). Also 2 failures to fclose() following a malloc() failure. And lots of cases where unnecessary conditionals could be removed from the code. (CVS 3126) (check-in: [e510e6dd] user: drh branch: trunk, size: 27114)
2006-02-24
02:53
[bdead679] part of check-in [4b22e4b8] Remove unused parameters on internal APIs. Suppress warnings from CodeWarrior. (CVS 3110) (check-in: [4b22e4b8] user: drh branch: trunk, size: 27011)
2006-01-18
16:51
[4d3644cb] part of check-in [ac090f2a] Use a global variable protected by a mutex instead of thread-specific-data to record malloc() failures. (CVS 2972) (check-in: [ac090f2a] user: danielk1977 branch: trunk, size: 27148)
2006-01-11
21:41
[694b2474] part of check-in [5d9c6aa9] Automatically deallocate thread-specific data when it is no longer being used. Ticket #1601. Also implemented the suggestion of ticket #1603. Memory management is now off by default at compile-time. The sqlite3_enable_memory_management() API has been removed. (CVS 2919) (check-in: [5d9c6aa9] user: drh branch: trunk, size: 27228)
2006-01-10
12:31
[883b5f3b] part of check-in [9c18a1ce] Fix a problem with shared-schemas and temp triggers. (CVS 2901) (check-in: [9c18a1ce] user: danielk1977 branch: trunk, size: 27187)
2006-01-09
06:29
[c515afa5] part of check-in [82b81f69] Rename DbSchema to "Schema" and SqliteTsd to "ThreadData". (CVS 2893) (check-in: [82b81f69] user: danielk1977 branch: trunk, size: 27247)
2006-01-07
13:21
[d8e0fe91] part of check-in [23b587b0] In shared-cache mode, lock all required tables before beginning to execute the body of the statement program. (CVS 2881) (check-in: [23b587b0] user: danielk1977 branch: trunk, size: 27219)
2006-01-06
15:03
[13c449e6] part of check-in [19f93e13] Fix a crash caused by adding a trigger to a shared-schema and then deleting it using a different connection. (CVS 2873) (check-in: [19f93e13] user: danielk1977 branch: trunk, size: 27209)
2006-01-05
11:34
[858c0a49] part of check-in [deeda0dc] Add the shared schema/pager modifications. Very few tests so far. (CVS 2859) (check-in: [deeda0dc] user: danielk1977 branch: trunk, size: 27122)
2005-12-09
20:02
[2925ba96] part of check-in [83a59151] Clean up annoying (and pointless) compiler warnings about differing signedness. (CVS 2810) (check-in: [83a59151] user: drh branch: trunk, size: 26813)
14:25
[dfc1f8ee] part of check-in [601c3354] Many small changes to ensure memory is not leaked after malloc() fails. (CVS 2808) (check-in: [601c3354] user: danielk1977 branch: trunk, size: 26782)
2005-12-06
12:52
[388c13a2] part of check-in [e1606658] Some elements of the new malloc() failure handling. Not all cases work properly yet. Also, library is not threadsafe if malloc() fails right now. (CVS 2800) (check-in: [e1606658] user: danielk1977 branch: trunk, size: 26740)
2005-11-14
22:29
[aea0283a] part of check-in [ce06c123] Create separate affinities for INTEGER and REAL. (CVS 2766) (check-in: [ce06c123] user: drh branch: trunk, size: 26720)
2005-06-12
21:35
[f51dec15] part of check-in [36f2da1f] Update older opcode names to be more meaningful in light of the latest code design. (CVS 2506) (check-in: [36f2da1f] user: drh branch: trunk, size: 26720)
2005-03-29
03:10
[1a6d0c7c] part of check-in [c41d5544] Add the SQLITE_OMIT_TEMPDB compile time macro. (CVS 2427) (check-in: [c41d5544] user: danielk1977 branch: trunk, size: 26720)
2005-03-16
12:15
[0c3ec8a6] part of check-in [9a358fc3] Fix some memory leaks that can occur if a memory allocation fails. (CVS 2388) (check-in: [9a358fc3] user: danielk1977 branch: trunk, size: 26724)
2005-01-29
08:32
[038c8e12] part of check-in [b1b50f31] Modify sub-query handling. Tickets #1083 and #1084. (CVS 2286) (check-in: [b1b50f31] user: danielk1977 branch: trunk, size: 26397)
2005-01-24
13:03
[5da126ee] part of check-in [b243681a] More test cases to do with invalidating precompiled statements. (CVS 2273) (check-in: [b243681a] user: danielk1977 branch: trunk, size: 26354)
2005-01-19
23:24
[b3de6615] part of check-in [d8b2a7e0] Continued refactoring of the name resolution logic and query optimizer. (CVS 2236) (check-in: [d8b2a7e0] user: drh branch: trunk, size: 26357)
2005-01-18
04:00
[7b5da661] part of check-in [0142ae6f] Refinements to the name resolution logic. Change the name of the keywordhash.c file to keywordhash.h. (CVS 2229) (check-in: [0142ae6f] user: drh branch: trunk, size: 26352)
2005-01-17
22:08
[210fe50d] part of check-in [4a753439] Infrastructure changes to handle name resolution differently. This is needed to fix various long-standing problems with column names in joins. It will also make the implementation of correlated subqueries easier. (CVS 2228) (check-in: [4a753439] user: drh branch: trunk, size: 26354)
2004-12-07
14:06
[98f3b07c] part of check-in [8e164ab2] Simplify the trigger logic for DELETE, INSERT, and UPDATE. (CVS 2157) (check-in: [8e164ab2] user: drh branch: trunk, size: 26344)
2004-11-13
15:59
[0c91b561] part of check-in [dcbc0c22] More compile-time options for removing components. (CVS 2098) (check-in: [dcbc0c22] user: drh branch: trunk, size: 26427)
2004-10-31
02:22
[f9a0a8d3] part of check-in [be661acf] Insert #ifdefs that can optionally remove features at compiletime resulting in a database engine with a smaller footprint. (CVS 2034) (check-in: [be661acf] user: drh branch: trunk, size: 26943)
2004-10-06
15:41
[b51a120d] part of check-in [d790c84c] Convert many constants to have type "const". (CVS 2006) (check-in: [d790c84c] user: drh branch: trunk, size: 26872)
2004-10-05
02:41
[b983f8d7] part of check-in [81ff8107] Add support for DEFERRED, IMMEDIATE, and EXCLUSIVE transactions. (CVS 2000) (check-in: [81ff8107] user: drh branch: trunk, size: 26862)
2004-09-24
12:24
[d1f770ee] part of check-in [9fa904d9] Simplification of the trigger code. (CVS 1976) (check-in: [9fa904d9] user: drh branch: trunk, size: 26900)
2004-09-19
02:15
[3591b88b] part of check-in [4871c77f] Add comments to unused P3 fields of selected instructions when NDEBUG is not defined. This makes VDBE program dumps more readable during debugging. (CVS 1973) (check-in: [4871c77f] user: drh branch: trunk, size: 27055)
00:50
[b42ae6ca] part of check-in [eb9b501a] Merge the ListPush and ListPop VDBE opcodes into ContextPush and ContextPop. (CVS 1972) (check-in: [eb9b501a] user: drh branch: trunk, size: 26939)
2004-09-06
17:24
[98dd620b] part of check-in [3ddf5a9d] Fix a naming conflict between sqlite versions 2 and 3. An open sqlite3 connection now *must* be called "sqlite3". You cannot call it "sqlite". This might break existing code. (CVS 1941) (check-in: [3ddf5a9d] user: drh branch: trunk, size: 27207)
2004-08-31
13:45
[40e10f4b] part of check-in [8fd65e70] Simplifications and optimizations. Also: disable the corrupt.test for now. (CVS 1924) (check-in: [8fd65e70] user: drh branch: trunk, size: 27203)
2004-08-21
17:54
[8b147c6b] part of check-in [bd6649c5] Optimizations to the code generator. (CVS 1899) (check-in: [bd6649c5] user: drh branch: trunk, size: 27203)
2004-07-24
17:38
[360cf8f1] part of check-in [ebdb661e] Prepared statements now work with CREATE and DROP. All tests pass. No memory leaks. (CVS 1866) (check-in: [ebdb661e] user: drh branch: trunk, size: 27267)
2004-06-29
08:59
[6aaf6d79] part of check-in [157db33e] Fix error reporting path for errors that occur while reading the database schema. (CVS 1757) (check-in: [157db33e] user: danielk1977 branch: trunk, size: 26777)
2004-06-22
13:22
[296e888a] part of check-in [80151e72] Fix some segfaults that could have occurred after a malloc() failure. (CVS 1661) (check-in: [80151e72] user: drh branch: trunk, size: 27083)
2004-06-21
09:06
[368fb295] part of check-in [bbd3e933] Add the OP_Concat8 opcode, similar in concept to OP_String8. (CVS 1648) (check-in: [bbd3e933] user: danielk1977 branch: trunk, size: 27058)
06:50
[65fa5724] part of check-in [ae2f4a09] Update sqlite3_changes() to match the documentation and add sqlite3_total_changes(). (CVS 1645) (check-in: [ae2f4a09] user: danielk1977 branch: trunk, size: 27057)
2004-06-19
14:49
[fb38c34d] part of check-in [99d0436e] Omit the sqlite3VdbeCode() routine. Use sqlite3NameFromToken() more to reduce the amount of code. (CVS 1639) (check-in: [99d0436e] user: drh branch: trunk, size: 26685)
2004-06-18
17:10
[b05699cf] part of check-in [2590fffc] Changes to allow libsqlite3.a and libsqlite.a to be both linked into the same program at the same time. (CVS 1621) (check-in: [2590fffc] user: drh branch: trunk, size: 26690)
2004-06-16
12:02
[3325207e] part of check-in [7974c9a6] Trivial modifications to prevent compiler warnings. (CVS 1607) (check-in: [7974c9a6] user: danielk1977 branch: trunk, size: 26674)
10:39
[9b08b80d] part of check-in [b739ef2a] Fix handling of a failed malloc() in various places (CVS 1605) (check-in: [b739ef2a] user: danielk1977 branch: trunk, size: 26670)
2004-06-12
09:25
[3ff6f24e] part of check-in [5903f538] (1) Modifications to the user-function interface and (2) Internal changes to automatically created indices. (CVS 1575) (check-in: [5903f538] user: danielk1977 branch: trunk, size: 26628)
2004-06-09
12:30
[d1a4d7a5] part of check-in [beab038c] Fix error reporting when trying to attach a database with a foriegn text encoding. (CVS 1545) (check-in: [beab038c] user: danielk1977 branch: trunk, size: 26509)
00:48
[2c28bf37] part of check-in [10861964] Start all transactions and verify all schema cookies near the beginning of of each vdbe program. (CVS 1543) (check-in: [10861964] user: drh branch: trunk, size: 26462)
2004-06-07
07:52
[532daca4] part of check-in [983221b0] Add pragma to set/get text encoding. Also fix an obscure problem where a temp trigger could be accidently dropped. (CVS 1537) (check-in: [983221b0] user: danielk1977 branch: trunk, size: 26540)
2004-05-31
08:26
[04b2c310] part of check-in [b8ed812c] Replace OP_Begin, OP_Commit and OP_Rollback with OP_AutoCommit. (CVS 1500) (check-in: [b8ed812c] user: danielk1977 branch: trunk, size: 26557)
2004-05-29
11:24
[258ed8f9] part of check-in [3225de89] Transform OP_HexBlob and OP_String8 to OP_Blob and OP_String the first time they are executed. (CVS 1492) (check-in: [3225de89] user: danielk1977 branch: trunk, size: 26465)
10:23
[6a0751fd] part of check-in [4feb4b9a] Fix vacuum so that it works with blobs. (CVS 1490) (check-in: [4feb4b9a] user: danielk1977 branch: trunk, size: 26458)
02:37
[9040e5dd] part of check-in [4060a37d] Allow CREATE and DROP TRIGGER on attached databases. (CVS 1488) (check-in: [4060a37d] user: danielk1977 branch: trunk, size: 26363)
2004-05-28
11:37
[9ab75040] part of check-in [4984a130] Allow CREATE TABLE and CREATE INDEX on attached databases. (CVS 1483) (check-in: [4984a130] user: danielk1977 branch: trunk, size: 25668)
2004-05-18
10:06
[11afe9ab] part of check-in [ad4a9641] Fix many problems with manifest types and column affinity. Most things are working now. (CVS 1393) (check-in: [ad4a9641] user: danielk1977 branch: trunk, size: 25662)
2004-05-10
10:34
[8df308e0] part of check-in [2242423e] Change the names of external symbols from sqlite_XXX to sqlite3_XXX. (CVS 1338) (check-in: [2242423e] user: danielk1977 branch: trunk, size: 25659)
2004-05-08
08:23
[8b07ff87] part of check-in [8af6474c] Change lots of internal symbols from sqliteXXX to sqlite3XXX so that the library links again. It doesn't work yet, due to changes in the btree layer calling convention. (CVS 1324) (check-in: [8af6474c] user: danielk1977 branch: trunk, size: 25654)
2004-02-21
13:31
[a9927b57] part of check-in [8e3eda2a] More code cleanup and size reduction. (CVS 1256) (check-in: [8e3eda2a] user: drh branch: trunk, size: 25537)
2004-02-20
22:53
[0d4f0509] part of check-in [3383413a] Fixed behaviour of last_insert_rowid() with triggers and add last_statement_change_count() function that works correctly with triggers. (CVS 1251) (check-in: [3383413a] user: rdc branch: trunk, size: 25529)
2004-02-14
23:05
[c647a442] part of check-in [af5c2be4] Eliminate the use of callbacks during schema initialization. (CVS 1242) (check-in: [af5c2be4] user: drh branch: trunk, size: 25410)
2003-10-03
00:13
[ce83e017] part of check-in [54aa0fb2] Allow quoted trigger names. Ticket #468. (CVS 1109) (check-in: [54aa0fb2] user: drh branch: trunk, size: 25419)
2003-08-16
12:37
[474581ea] part of check-in [ef58f163] Do not delete tables with the same name when dropping triggers. Ticket #430. (CVS 1074) (check-in: [ef58f163] user: drh branch: trunk, size: 25395)
2003-06-03
01:47
[6ff205aa] part of check-in [3e8889d7] Additional testing of the ATTACH command with bug fixes for the new problems that the tests found. (CVS 998) (check-in: [3e8889d7] user: drh branch: trunk, size: 25355)
2003-05-31
16:21
[5caf7697] part of check-in [7202d4f1] 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) (check-in: [7202d4f1] user: drh branch: trunk, size: 25273)
2003-05-17
19:04
[7607b209] part of check-in [c8c823b0] Prevent an infinite loop when deleting a table that has a TEMP trigger. (CVS 984) (check-in: [c8c823b0] user: drh branch: trunk, size: 24025)
2003-05-02
14:32
[8ee81198] part of check-in [be7aed20] VDBE cursors numbers for tables in a join do not have to be consecutive. This is one step on the road to fixing ticket #272. (CVS 947) (check-in: [be7aed20] user: drh branch: trunk, size: 23556)
2003-04-25
17:52
[62d1e1b8] part of check-in [67746833] Report the correct authorization context in the authorization callback when coding an INSTEAD OF trigger on an update or delete. (CVS 936) (check-in: [67746833] user: drh branch: trunk, size: 23559)
2003-04-24
01:45
[e763f401] part of check-in [206b1739] Fix some issues with INSTEAD OF triggers. (CVS 930) (check-in: [206b1739] user: drh branch: trunk, size: 23606)
2003-04-22
20:30
[21ad1677] part of check-in [c675a550] Update the authorizer API so that it reports the database that table and indices belong to and so that it reports when actions are taken in response to a trigger. (CVS 928) (check-in: [c675a550] user: drh branch: trunk, size: 27388)
2003-04-21
18:48
[c461789f] part of check-in [58ddd587] Add support for TEMPORARY triggers. Such triggers can write temporary or permanent tables. (CVS 926) (check-in: [58ddd587] user: drh branch: trunk, size: 27176)
2003-04-17
22:57
[45b67f6c] part of check-in [1e5e00fb] Fix triggers to work in an ATTACHed database. Ticket #295. (CVS 915) (check-in: [1e5e00fb] user: drh branch: trunk, size: 26296)
2003-04-15
19:22
[4ca4499d] part of check-in [0b996959] Get triggers working on tables with INTEGER PRIMARY KEYs. Ticket #291. This may also fix #159. Still need to add tests so both bugs remain open for the time being. (CVS 908) (check-in: [0b996959] user: drh branch: trunk, size: 26047)
2003-03-31
02:12
[bd5a5b23] part of check-in [1d3fc977] Add the sqliteErrorMsg() function and use it to generate error message text during parsing and code generation. This simplifies the code somewhat and makes it easier to handle names with a database prefix. (CVS 891) (check-in: [1d3fc977] user: drh branch: trunk, size: 26043)
2003-03-30
00:19
[b07dc1ff] part of check-in [b90d9de3] Fix a memory leak in triggers and update tests to show the latest error message text. (CVS 886) (check-in: [b90d9de3] user: drh branch: trunk, size: 26313)
2003-03-27
13:50
[64ad4be5] part of check-in [8a593e9c] Regression tests now work - except for some changes in error message text. The library is now safe to use for experimental work. (CVS 885) (check-in: [8a593e9c] user: drh branch: trunk, size: 26257)
13:01
[5e2b4cd0] part of check-in [7672914b] Fix a segfault in the trigger code. (CVS 884) (check-in: [7672914b] user: drh branch: trunk, size: 26272)
12:51
[578e9d07] part of check-in [d2fb2bb5] Changes to the "sqlite" structure that allow simultaneous operations on multiple database files. Many regession tests pass - but not all of them. Do not use this version except for debugging SQLite itself. (CVS 883) (check-in: [d2fb2bb5] user: drh branch: trunk, size: 26271)
2003-03-20
01:16
[aafc83ea] part of check-in [a5d8fc95] Record the database name in addition to the table name for DELETE, INSERT, and UPDATE statements. (CVS 879) (check-in: [a5d8fc95] user: drh branch: trunk, size: 25864)
2003-01-14
02:49
[da142dec] part of check-in [cc2ae781] More tests of the sqlite_set_authorizer() API together with fixes for bugs that the new tests uncovered. (CVS 832) (check-in: [cc2ae781] user: drh branch: trunk, size: 25676)
2003-01-13
23:27
[cb72a337] part of check-in [45de93f9] Revise the sqlite_set_authorizer API to provide more detailed information about the SQL statement being authorized. Only partially tested so far. (CVS 830) (check-in: [45de93f9] user: drh branch: trunk, size: 25557)
2003-01-12
18:02
[dd3fb659] part of check-in [52d5007f] Initial check-in of the code for the new sqlite_set_authorizer() API function. The code is mostly untested at this point. (CVS 827) (check-in: [52d5007f] user: drh branch: trunk, size: 25341)
2002-09-14
13:47
[5ba917fc] part of check-in [3f253afe] Do not put a write lock on the main database file when writing to a temporary table. (CVS 750) (check-in: [3f253afe] user: drh branch: trunk, size: 24999)
2002-08-25
19:20
[c90a292a] part of check-in [c602603e] Fix for ticket #136: Added the OP_RenameCursor VDBE instruction and used it 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) (check-in: [c602603e] user: drh branch: trunk, size: 24990)
2002-08-24
18:24
[cc8c6769] part of check-in [22d8726e] Change the way token memory is allocated in an effort to fix ticket #136. There is now a memory leak when using views of views. (CVS 725) (check-in: [22d8726e] user: drh branch: trunk, size: 25013)
2002-06-25
01:09
[d88ab4d6] part of check-in [9c1432bf] Added support for the "sqlite_temp_master" table. Increased the version number to 2.5.2. (CVS 640) (check-in: [9c1432bf] user: drh branch: trunk, size: 24079)
2002-06-11
02:25
[21342af6] part of check-in [d4a2fb10] Add RAISE() function, which allows more advanced flow-control in trigger programs (ticket #55) (CVS 614) (check-in: [d4a2fb10] user: danielk1977 branch: trunk, size: 24347)
2002-05-27
12:24
[d02f8e35] part of check-in [f8041f3d] A SELECT statement inside the body of a TRIGGER uses the SRT_Discard target 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) (check-in: [f8041f3d] user: drh branch: trunk, size: 24102)
2002-05-26
23:24
[b7a93ffa] part of check-in [d9e48cd5] Require the INSTEAD OF syntax to create triggers on database views. (CVS 591) (check-in: [d9e48cd5] user: danielk1977 branch: trunk, size: 24339)
20:54
[f9adb404] part of check-in [90511737] NULL values are distinct. A comparison involving a NULL is always false. 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) (check-in: [90511737] user: drh branch: trunk, size: 23558)
2002-05-24
20:31
[75dd6480] part of check-in [99bd1f5b] Initial implementation of LEFT OUTER JOIN including the expanded SQL92 join syntax. The basic functionality is there but there is still a lot of testing to do. (CVS 587) (check-in: [99bd1f5b] user: drh branch: trunk, size: 23555)
02:04
[bf1a4f66] part of check-in [a167b71d] Split the IdList structure into IdList and SrcList. SrcList is used to 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) (check-in: [a167b71d] user: drh branch: trunk, size: 23649)
2002-05-23
22:07
[a7990d42] part of check-in [c53b0b92] Change the names of the PushList and PopList opcodes to ListPush and ListPop so that they will appear together with the other List opcodes in the documentation. (CVS 583) (check-in: [c53b0b92] user: drh branch: trunk, size: 23645)
02:09
[a5e6694f] part of check-in [01ad352c] Fix some places where a malloc() failure would lead to a segfault. (CVS 580) (check-in: [01ad352c] user: drh branch: trunk, size: 23645)
00:30
[0b86599d] part of check-in [275ba356] Do not allow triggers on the SQLITE_MASTER table. (CVS 579) (check-in: [275ba356] user: drh branch: trunk, size: 23344)
2002-05-21
13:18
[d4085373] part of check-in [3399b012] Clean up some compiler warnings. (CVS 575) (check-in: [3399b012] user: drh branch: trunk, size: 23124)
11:38
[143d3d2b] part of check-in [37dbdd55] Additional code cleanup resulting from a review of the new trigger code. (CVS 572) (check-in: [37dbdd55] user: drh branch: trunk, size: 23129)
2002-05-19
23:43
[43dbeb68] part of check-in [8a4195c7] Style fixes to triggers code in various *.c files (partial fix to ticket #39) (CVS 571) (check-in: [8a4195c7] user: danielk1977 branch: trunk, size: 21050)
2002-05-17
00:05
[e61b4a9e] part of check-in [b1d72cb5] Stylistic changes to src/trigger.c (partial fix to ticket #39). Also more comments. (CVS 570) (check-in: [b1d72cb5] user: danielk1977 branch: trunk, size: 20986)
2002-05-15
12:45
[491d5d3b] part of check-in [b1034681] Beginning to clean up the trigger code. Still lots of work to do. (CVS 566) (check-in: [b1034681] user: drh branch: trunk, size: 18557)
11:44
[768b895c] part of check-in [690f9a16] Remove all tabs from the beginning of source code lines. Replace tabs with the appropriate number of spaces. (CVS 565) (check-in: [690f9a16] user: drh branch: trunk, size: 18526)
08:30
[b8df3e8f] part of check-in [794bf67b] Added FOR EACH ROW triggers functionality (CVS 562) (check-in: [794bf67b] user: danielk1977 branch: trunk, size: 17654) Added