/ File History
Login

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

History of src/trigger.c

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