/ File History
Login

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

History of src/attach.c

2019-09-16
12:35
Merge all recent trunk enhancements into the reuse-schema branch. file: [6a1a045f] check-in: [27eb2236] user: drh branch: reuse-schema, size: 19497
2019-08-27
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: [3ca19504] check-in: [069c2f4c] user: drh branch: trunk, size: 19431
2019-08-15
20:04
Provide the SQLITE_DIRECTONLY flag for app-defined functions that prohibits the use of those functions within triggers or views. file: [a6f108eb] check-in: [fc745845] user: drh branch: directonly, size: 18985
2019-05-14
22:25
Merge all the latest trunk enhancements into the reuse-schema branch. file: [95c3e4b1] check-in: [018f3199] user: drh branch: reuse-schema, size: 19010
2019-04-15
15:41
Fix a problem with the user-auth extension and deserializing in-memory databases. file: [78e986ba] check-in: [09fa0b3c] user: dan branch: trunk, size: 18944
2019-03-20
20:02
Use the IsReuseSchema() macro more consistently. Also, rename it to IsSharedSchema(). file: [d42f6c3a] check-in: [c1be211c] user: dan branch: reuse-schema, size: 18986
16:03
Merge latest trunk changes into this branch. file: [bc39b470] check-in: [4cd20ca6] user: dan branch: reuse-schema, size: 18985
2019-03-13
11:40
When deserializing a database (sqlite3_deserialize()), do not attempt to parse the schema before the data is loaded. file: [732d45db] check-in: [4e1b005e] user: dan branch: trunk, size: 18920
2019-02-20
17:36
Add test and fixes for SQLITE_OPEN_SHARED_SCHEMA mode. file: [aef8849d] check-in: [9a78d89c] user: dan branch: reuse-schema, size: 18963
2019-02-15
19:00
Fix a problem with eponymous virtual tables and SHARED_SCHEMA databases. Also, after preparing statements that require all database schemas (REINDEX, ANALYZE, CREATE, DROP and some PRAGMA statements), do not allow the database connection to return more than one schema to each schema-pool. file: [06897ba0] check-in: [ecf6251e] user: dan branch: reuse-schema, size: 18926
2019-02-12
19:20
Share schemas between databases attached to the same database handle. file: [99c6496d] check-in: [ea611d7c] user: dan branch: reuse-schema, size: 18924
2019-02-02
15:59
Honor key query parameters for SEE on the URI filename for ATTACH and VACUUM INTO. file: [3f9b0f6c] check-in: [2e01096b] user: drh branch: trunk, size: 18880
2018-11-13
19:51
Turn on ASAN for the dbfuzz2 utility. Fix a buffer overread associated with sqlite3_deserialize(). file: [92b51739] check-in: [4e38f27b] user: drh branch: trunk, size: 18770
2018-11-02
17:38
Enhance triggers so that they can use table-valued-functions that exist in schemas outside of the schema in which the trigger is defined. file: [2d61c00d] check-in: [1fa74930] user: drh branch: trunk, size: 18812
2018-09-19
14:54
Reduce the size of Expr from 80 to 72 bytes moving the pRight field inside the "x" union. This is an incremental check-in that still has issues. file: [d06bf7ab] check-in: [147c61a6] user: drh branch: expr-simplify, size: 18869
2018-09-18
21:35
In the Expr object, the Expr.eX field determines what value is stored in the Expr.x union. This mostly works, but there are issues identified by valgrind. file: [8b8e5259] check-in: [8849a463] user: drh branch: expr-simplify, size: 18830
2018-06-14
19:06
Fix problem with window functions min() and max() when used with a PARTITION clause and a frame starting point other than "UNBOUNDED PRECEDING". file: [4bd5b926] check-in: [43eb1e75] user: dan branch: exp-window-functions, size: 18768
2018-05-16
20:58
Start of experimental implementation of SQL window functions. Does not yet work. file: [3af6abc4] check-in: [3781e520] user: dan branch: exp-window-functions, size: 18698
2018-04-25
12:01
Avoid many unnecessary calls to sqlite3ReadSchema() and sqlite3Init() when the schema is known to be valid already. file: [4a3138bd] check-in: [58cf812f] user: drh branch: trunk, size: 18678
2018-04-23
13:28
Ensure that there are no bind-parameters or incorrect schema references in the UPSERT portions of an INSERT within a TRIGGER. file: [f2ed3224] check-in: [d47a6bdd] user: drh branch: trunk, size: 18634
2018-04-11
16:04
Prohibit bound parameters in the arguments to table-valued functions within a trigger. Problem discovered by OSSFuzz. file: [bbdf97bb] check-in: [b7178209] user: drh branch: trunk, size: 18284
2018-03-06
21:43
Improved documentation for sqlite3_serialize() and sqlite3_deserialize(). Change the name of the compile-time option to enable these interfaces from SQLITE_ENABLE_MEMDB to SQLITE_ENABLE_DESERIALIZE. file: [f6f212c4] check-in: [f07e97ae] user: drh branch: memdb, size: 18183
20:54
Handle some boundary cases in memdb associated with OOM faults. file: [6a5619ea] check-in: [b58ca4cb] user: drh branch: memdb, size: 18177
2018-03-01
13:44
Merge the latest enhancements from trunk. file: [e79ef463] check-in: [c8083de1] user: drh branch: memdb, size: 18072
2018-02-20
16:39
Remove a superfluous "#if 1". No logic changes. file: [79cb6b36] check-in: [caaffd32] user: drh branch: trunk, size: 17098
2018-02-15
21:00
Do not allow parameters or schema references inside of WITH clause of triggers and views. This fixes a bug discovered by OSSFuzz and present since common-table-expressions were first added in 2014-02-03. file: [e1c0d72d] check-in: [b918d4b4] user: drh branch: trunk, size: 17111
2018-01-03
23:40
New test cases and fixes for minor problems. file: [81583942] check-in: [e0da2cc3] user: drh branch: memdb, size: 17876
22:48
Miscellaneous code and comment cleanup. file: [af582a55] check-in: [fa6069fb] user: drh branch: memdb, size: 17854
19:03
Replace sqlite3_memdb_config() with sqlite3_deserialize(). Remove the "db memdb" command from the TCL interface, replacing it with "db serialize" and "db deserialize". file: [52c34c2f] check-in: [2f6e9df9] user: drh branch: memdb, size: 17703
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: [84c477e8] check-in: [3925facd] user: drh branch: trunk, size: 16902
2017-07-26
18:26
Allow ATTACH and DETACH to occur inside of a transaction. file: [07b706e3] check-in: [ac1fd6be] user: drh branch: attach-in-trans, size: 16974
2017-06-16
18:31
Minor refactoring change to clarify how ATTACH works. No functional changes. file: [3bd555e2] check-in: [3944a32e] user: drh branch: trunk, size: 17265
2017-01-02
18:19
Avoid unnecessary calls to sqlite3BtreeEnterAll() and sqlite3BtreeLeaveAll() when no btree is using shared-cache. file: [8c476f8b] check-in: [cfb31582] user: drh branch: trunk, size: 17142
2016-11-11
03:37
Take care not to try to generate code for the ATTACH and DETACH commands if there were syntax errors during parsing. Fix for ticket [2f1b168ab4d4844] file: [f6725410] check-in: [b0ff183b] user: drh branch: trunk, size: 17116
2016-09-23
21:36
Add the EP_Leaf flag bit to the Expr.flags field to indicate Expr nodes that do not have substructure. Use that bit to avoid unnecessary recursion. file: [8c19066b] check-in: [8a6ea455] user: drh branch: trunk, size: 17078
2016-09-16
19:42
If no KEY is specified on ATTACH, copy the main schema key if the key size is non-zero. In other words, allow for -1 as a valid key size in support of the --textkey to SEE. file: [3e78d38a] check-in: [03573887] user: drh branch: trunk, size: 17070
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: [4711ff36] check-in: [92a22f01] user: drh branch: zDbSName, size: 17072
2016-03-08
15:30
Make the SQLITE_DEFAULT_SYNCHRONOUS and SQLITE_DEFAULT_WAL_SYNCHRONOUS values zero-based to agree with PRAGMA synchronous. file: [771153bd] check-in: [592d2104] user: drh branch: default-synchronous, size: 17057
14:40
Add compile-time options SQLITE_DEFAULT_SYNCHRONOUS and SQLITE_DEFAULT_WAL_SYNCHRONOUS used to specify the default synchronous settings for all database connections. file: [3d23c669] check-in: [1fefa967] user: drh branch: default-synchronous, size: 17055
14:16
Fix ATTACH to use the symbolic name PAGER_SYNCHRONOUS_FULL rather than an integer literal. file: [34b254f3] check-in: [c4e192a0] user: drh branch: trunk, size: 17051
2016-02-15
18:15
Add the SQLITE_NOMEM_BKPT macro to enhance the ability to debug OOM errors. Only effective with compiling with SQLITE_DEBUG. file: [a3724c64] check-in: [9b345476] user: drh branch: trunk, size: 17030
00:34
Improvements to the application-defined function mechanism so that it is more compact and runs faster, especially when the application defines thousands of new SQL functions. file: [07aa6e77] check-in: [3201fbcc] user: drh branch: many-app-functions, size: 17020
2016-02-13
23:43
Enhance ability to debug out-of-memory errors. file: [d9526ed4] check-in: [6a9c4a3e] user: mistachkin branch: noMemBkpt, size: 17162
2016-02-05
13:38
Add the slightly faster sqlite3DbMallocRawNN(db,n) routine for the majority cases where db is guaranteed to be not NULL. file: [c16c2648] check-in: [0a802e96] user: drh branch: oom-handling, size: 17152
01:55
Improvements to the way that OOM errors are processed. file: [b9435468] check-in: [c3ef0347] user: drh branch: oom-handling, size: 17150
2016-02-04
09:48
Refinements to synchronous logic: (1) Use PAGER_SYNCHRONOUS_FULL rather than the corresponding magic number. (2) Honor SQLITE_NO_SYNC on xDelete calls with sync (3) Count xDelete syncs during testing (4) Fix #ifs on SQLITE_EXTRA_DURABLE so that directory syncs on journal unlink are off by default. file: [27743a69] check-in: [e3157cb5] user: drh branch: trunk, size: 17152
2016-01-16
15:12
Use sqlite3VdbeAddOp4() rather than a separate sqlite3VdbeChangeP4() call, for a slightly smaller and faster binary. file: [07b3a34a] check-in: [a4258cd4] user: drh branch: trunk, size: 17109
2016-01-14
22:19
Combine the xFunc and xStep pointers of the FuncDef object into a single pointer xSFunc. file: [ec9f119c] check-in: [0d1b3d7d] user: drh branch: trunk, size: 17118
2015-06-26
18:16
Cache the sqlite3_context structure in the P4 operand of VDBE programs for faster SQL function dispatch. file: [e944d005] check-in: [2abc44eb] user: drh branch: trunk, size: 17184
2015-04-17
18:22
Remove unnecessary parser error count increments. Let the sqlite3ErrorMsg() take care of doing that. file: [c38ac5a5] check-in: [3f3b0f68] user: drh branch: trunk, size: 17183
2015-04-13
22:26
On a DETACH statement, keep all schemas intact except fo the one that is being detached, and thus avoid unnecessary schema reparsing. file: [3c1053a4] check-in: [661db19b] user: drh branch: trunk, size: 17203
2015-02-21
00:19
Keep track of the optimal number of reserved bytes (by looking at reserve byte requests in calls to sqlite3BtreeSetPageSize()) and then change the reserve byte count to the optimal when doing a VACUUM or when using the backup API. file: [880f9b86] check-in: [28c2b726] user: drh branch: trunk, size: 17209
2014-12-12
00:40
Make sure the Btree mutex is held when setting the locking mode and the secure delete flag when attaching a shared-cache database. file: [7f6b3faf] check-in: [6bef7ede] user: drh branch: threadtest4, size: 17202
2014-09-11
15:25
All interfaces working and tested. file: [f4e94df2] check-in: [96ea5c0b] user: drh branch: user-auth, size: 17134
13:44
Add support for the extra parameter on the sqlite3_set_authorizer() callback and support for failing an ATTACH with an authentication-required database using bad credentials. The extension is now feature complete, but much testing and bug-fixing remains. file: [cc9b3004] check-in: [596e728b] user: drh branch: user-auth, size: 17129
2014-05-19
15:16
Changes to help ensure that a multiplication does not overflow when computing the number of bytes needed for a memory allocation, and cause a malfunction. No problems existing problems were discovered. However, these changes should help to ensure that no problems arise in the future. file: [3f5a380a] check-in: [17349a49] user: drh branch: safer-malloc, size: 16921
2014-05-06
15:28
Experimental changes that reduce the size of Expr objects from 72 to 64 bytes each on x64 and from 48 to 44 bytes each on x32. file: [a1ada8e4] check-in: [8ad0a123] user: drh branch: smaller-expr, size: 16997
2013-12-20
14:48
Allow any arbitrary expression as the filename in an ATTACH statement, including functions and subqueries. file: [38011290] check-in: [df70a1f3] user: drh branch: trunk, size: 16916
2013-10-03
15:39
The sqlite3FixInit() routine cannot fail. So change the return type from "int" to "void". file: [0a17c936] check-in: [500c5932] user: drh branch: trunk, size: 17094
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: [64859892] check-in: [f35f6ae3] user: dan branch: trunk, size: 17287
2013-09-12
16:50
Increase the number of bits available in Expr.flags. Other tweaks aimed at making expression processing more robust. file: [4a2b6a6d] check-in: [579a5125] user: drh branch: expr-tuning, size: 16688
2013-09-06
13:10
Combine the FuncDef.iPrefEnc and FuncDef.flags fields into a single new FuncDef.funcFlags field. file: [eeb8d9d2] check-in: [97b10e66] user: drh branch: trunk, size: 16691
2013-08-23
17:33
Adjust #ifdefs to get SQLITE_OMIT_AUTOMATIC_INDEX and SQLITE_OMIT_PAGER_PRAGMAS to build. file: [fea00cab] check-in: [ed310201] user: drh branch: trunk, size: 16757
2013-08-17
15:42
The fullfsync, checkpoint_fullfsync, and cache_spill pragmas apply to all files of a database connection, including those opened by future ATTACH statements. file: [5df73791] check-in: [d07c4331] user: drh branch: cache_spill, size: 16716
2013-03-21
21:20
Many spelling fixes in comments. No changes to code. file: [1816f5a9] check-in: [6f6e2d50] user: mistachkin branch: trunk, size: 16638
2012-12-05
14:31
Make sure memory is freed using a routine that is compatible with the routine used to allocate the memory. The SQLITE_MEMDEBUG compile-time option enforces this. file: [ea5247f2] check-in: [9f6c6885] user: drh branch: trunk, size: 16638
2012-10-05
18:35
Backport fixes to shared-cache mode, from the shared-cache-fix branch, to version 3.7.9 file: [48c5736f] check-in: [ac81ae49] user: drh branch: branch-3.7.9, size: 16611
2012-10-04
19:33
Shared-cache mode fixes for views and virtual tables. file: [34c15ecd] check-in: [2b370dea] user: dan branch: shared-cache-fix, size: 16619
2012-05-15
18:28
The former sqlite3ResetInternalSchema() routine was really two different routines, selected by parameter, each with a confused mission. So split this routine up into three separate smaller routines, calling each separately as needed. Hopefully this will make further refactoring and schema reset collateral damage containment easier. file: [577bf567] check-in: [aa0c3493] user: drh branch: shared-schema, size: 16565
2011-05-11
14:57
Only open a read-only connection to shared-memory if the "readonly_shm=1" option is specified as part of the database file URI (and if a read-write connection fails). file: [a87bfb77] check-in: [671ba5fc] user: dan branch: wal-readonly, size: 16658
2011-05-07
18:40
Set the sqlite3.mallocFailed flag if sqlite3ParseUri fails with SQLITE_NOMEM. file: [12c69579] check-in: [ca3797d4] user: drh branch: trunk, size: 16557
14:40
Fix minor compiler warnings. file: [77caa25f] check-in: [139eecbe] user: drh branch: trunk, size: 16508
2011-04-23
15:54
Have the ATTACH command do URI interpretation in the same way as sqlite3_open() and sqlite3_open_v2() do. file: [79f8e5d2] check-in: [68240e75] user: dan branch: uri, size: 16499
2011-04-09
02:34
When ATTACH-ing a new database to an existing database with a codec, do not enable the codec in the attached database if it is not enabled in the existing database and it is not requested by the USING clause. file: [7f97ca76] check-in: [4caa5fc8] user: drh branch: trunk, size: 16190
2011-04-02
16:28
Begin a series of changes designed to reduce the scope and frequency of invalidating schemas. Design goals are that the internal schema should never be deleted out from under a prepared statement that is running and that all prepared statements should be expired if the schema is invalidated. At the same time, minimize the number of schema invalidations. This change merely revises the sqlite3ResetInternalSchema() function to use -1 as the wildcard for "all" rather than 0, so that we can reset the main schema independently of all the others. file: [7cae2cf0] check-in: [6a8ad6e3] user: drh branch: schema-parse-refactor, size: 16112
2011-02-04
00:51
Fix the ATTACH command so that the filename argument can be any expression and so that if authorizer callback gets a NULL pointer for the filename if the filename argument is anything other than a string literal. Ticket [9013e13dba5b58c7] file: [438ea6f6] check-in: [e64e1453] user: drh branch: trunk, size: 16110
2010-09-28
14:26
Fix several harmless compiler warnings. file: [252c4f7e] check-in: [7be03ecc] user: drh branch: trunk, size: 16081
2010-08-30
15:02
Remove the sqlite3BtreeFactory() wrapper routine. All modules now call sqlite3BtreeOpen() directly. file: [c689d516] check-in: [0900e353] user: drh branch: trunk, size: 16001
2010-07-08
17:40
Change the journal_mode pragma to remove the "default journal mode" concept. The journal_mode pragma only effects currently attached databases and does not change the behavior of future attachments. file: [17bec1f1] check-in: [e396184c] user: drh branch: trunk, size: 16061
2010-06-02
05:53
Add some 'const' markers to static data that is really constant. file: [47b23097] check-in: [e7073e23] user: dan branch: trunk, size: 16665
2010-05-10
11:20
Enhance the OP_JournalMode opcode with an ignore-errors option and use that option the ATTACH command. file: [7f1f760b] check-in: [0bdea4cf] user: drh branch: trunk, size: 16653
2010-05-06
21:37
The PRAGMA journal_mode=WAL; command now makes WAL the default journal mode for new databases added with ATTACH, so the behavior is consistent with the other journal modes. file: [0d7c4c82] check-in: [c3520460] user: drh branch: trunk, size: 16620
2010-02-25
02:32
Merge in all of the logging enhancements. This is a cherrypick merge of the following check-ins: [103321e37a], [a8076aede3], [6d910245ad], [7c4cca6d1a], [edea3bb740], [1a6d4bb130], [a8c984c1d6], [69a493182f], and [1168763d2c]. file: [ba4a1463] check-in: [46f406b2] user: drh branch: branch-3.6.22, size: 15988
02:11
Fix a segfault that is possible for an OOM fault in ATTACH when in shared-cache mode. This is a cherrypick merge of check-in [e37137376a]. file: [508d431e] check-in: [f73cc0e9] user: drh branch: branch-3.6.22, size: 16051
2010-02-23
18:05
Fix a segfault that can occur if a malloc fails in ATTACH in shared-cache mode. file: [7abe1607] check-in: [e3713737] user: dan branch: trunk, size: 16107
17:36
Remove the obsolete sqlite3SafetyOn() mechanism. Add additional logging output for CORRUPT, and CANTOPEN errors. file: [d855b36c] check-in: [7c4cca6d] user: drh branch: trunk, size: 16038
10:56
Fix a segfault that can occur if a malloc fails in ATTACH in shared-cache mode. file: [01fd6ce1] check-in: [875f8fa3] user: dan branch: compile_opts, size: 16170
10:50
Fix a segfault that can occur if a malloc fails in ATTACH in shared-cache mode. file: [c4adb24b] check-in: [d6343d03] user: dan branch: branch-3.6.1, size: 15571
2010-02-17
17:48
Consistent use of #ifdef for SQLITE_HAS_CODEC to avoid confusion. file: [f6d33268] check-in: [34a3413a] user: shaneh branch: trunk, size: 16101
2010-02-12
19:46
Enhancements to the secure_delete pragma to make it easier to use. file: [a6b5e97c] check-in: [2bb38bb9] user: drh branch: trunk, size: 16098
2009-11-10
01:30
Remove the obsolete "$Id:$" RCS identifier strings from the source code. file: [0ba38b38] check-in: [f6c045f6] user: drh branch: trunk, size: 15982
2009-11-04
01:56
Report errors back up to the ATTACH command if the codec fails to initialize. file: [1f2ae6ca] check-in: [a6c69610] user: drh branch: trunk, size: 16039
2009-05-31
21:21
Code simplifications to facilitate coverage testing following the recent changes to the Expr object. (CVS 6697) file: [13995348] check-in: [ee9a144d] user: drh branch: trunk, size: 16010
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: [ad7eeae1] check-in: [4ac2bdfb] user: drh branch: trunk, size: 16003
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: [92517f52] check-in: [7cb1c3ba] user: drh branch: trunk, size: 15999
2009-05-01
06:19
Remove a NEVER() clause from a condition that is true at least once when running attachmalloc.test. (CVS 6585) file: [3b99611f] check-in: [514efc73] user: danielk1977 branch: trunk, size: 16116
2009-04-30
17:38
Disable an always-false test in the attach.c module. (CVS 6581) file: [0342a96e] check-in: [92b69481] user: drh branch: trunk, size: 16115
13:30
Disallow attaching the same database multiple times to the same db connection in shared cache mode, since doing so leads to deadlock. (CVS 6578) file: [5e4c3871] check-in: [715f14f1] user: drh branch: trunk, size: 16108
05:40
Fix a memory leak introduced in the previous check-in. (CVS 6574) file: [2acdbf4b] check-in: [f082bf36] user: drh branch: trunk, size: 15971
05:19
Take care not to leave a zombie attached database if the attachment fails due to an encoding mismatch. Update attach logic to always use dynamically allocated error message strings. (CVS 6573) file: [38e6ad95] check-in: [a6cb4002] user: drh branch: trunk, size: 15937
01:22
Remove always-true tests from attach.c. In btree.c, always test the return from sqlite3PagerSetPagesize() since it might return SQLITE_NOMEM. (CVS 6572) file: [b3bc7d3c] check-in: [8bf60b24] user: drh branch: trunk, size: 16106
2009-04-08
13:51
Minor refactoring of the expression-compaction logic for clarity of presentation. New comments added. The EXPRDUP_DISTINCTSPAN flag is removed as obsolete. (CVS 6470) file: [af80fa85] check-in: [44ded2ea] user: drh branch: trunk, size: 16094
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: [d34589d5] check-in: [d9f6ffbc] user: danielk1977 branch: trunk, size: 16101
2009-02-03
16:51
Commit first version of the 'backup' feature. (CVS 6241) file: [81d37d19] check-in: [663479b4] user: danielk1977 branch: trunk, size: 15985
2008-12-10
16:45
Add explicit casts to silence nuisance warnings from VC++. (CVS 6004) file: [1c35f95d] check-in: [da1cbfa7] user: drh branch: trunk, size: 15941
2008-11-19
09:05
Changes to avoid "unused parameter" compiler warnings. (CVS 5921) file: [85c6a3d0] check-in: [88134322] user: danielk1977 branch: trunk, size: 15877
2008-10-28
17:52
Avoid exposing internal interfaces sqlite_attach() and sqlite_detach() as SQL scalar functions. Ticket #3466. (CVS 5846) file: [208881c8] check-in: [679c0b35] user: danielk1977 branch: trunk, size: 15811
2008-08-20
16:35
Refactor the name resolution procedures in the code generator. (CVS 5569) file: [db3f4a60] check-in: [daf730d1] user: drh branch: trunk, size: 15503
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: [a85c1461] check-in: [e48f9697] user: drh branch: trunk, size: 15503
2008-06-15
02:51
Continuing work on the new memory allocation subsystem. Added routines for temporary memory allocation. Right the btree balance mechanism to only do one temporary allocation at a time. (CVS 5220) file: [b18ba42c] check-in: [65fe7b62] user: drh branch: trunk, size: 15481
2008-04-17
17:02
Add the journal_mode pragma. This is currently just syntax - it is not operational. (CVS 5024) file: [496cc628] check-in: [8eaa0c71] user: drh branch: trunk, size: 15552
2008-03-20
14:03
Initial implementation of per-connection limits and the sqlite3_limit() API. The sqllimits1.test script crashes. SQLITE_LIMIT_PAGE_COUNT and SQLITE_LIMIT_VDBE_OP are currently ignored. (CVS 4897) file: [bdc75e75] check-in: [60c77882] user: drh branch: trunk, size: 15454
2008-03-19
21:45
Add a new interface, sqlite3_context_db_handle(), that returns the database connection pointer for an application-defined function. (CVS 4889) file: [e7cf4ae2] check-in: [54c55cae] user: drh branch: trunk, size: 15426
2008-02-13
18:25
Where possible, avoid freeing buffers allocated for vdbe memory cells in case they can be reused. (CVS 4783) file: [e13d6259] check-in: [990237e2] user: danielk1977 branch: trunk, size: 15420
2008-02-06
14:11
Add the sqlite3_result_error_code() application interface. Use it in the ATTACH function so that a failed attach returns a proper error code. Ticket #2914. (CVS 4775) file: [90665c7e] check-in: [c2461620] user: drh branch: trunk, size: 15410
2008-01-23
03:03
Make sqlite3SafetyOn() and sqlite3SafetyOff() macros which disappear when compiling without -DSQLITE_DEBUG=1. (CVS 4744) file: [2a0b1994] check-in: [5375ad6b] user: drh branch: trunk, size: 15359
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: [f7a34eb0] check-in: [706b41b7] user: drh branch: trunk, size: 15347
2008-01-12
19:03
Continuing work toward converting the VM to a register machine. (CVS 4708) file: [71f5c886] check-in: [426f31ec] user: drh branch: trunk, size: 15351
2008-01-09
23:04
All essential opcodes can now operate out of registers and completely avoid the stack. Many still optionally use the stack to support legacy code generation, but the stack is not required. The next step is to update all code generation to avoid using the stack. (CVS 4700) file: [61f0cae7] check-in: [e3cf1c1c] user: drh branch: trunk, size: 15237
2008-01-03
23:44
Change the sqlite3ExprCode() function so that callers can request that the result of the expression be left on the stack or in a register. (CVS 4673) file: [1c96631e] check-in: [61bfb77c] user: drh branch: trunk, size: 15212
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: [4b214b41] check-in: [027875e4] user: drh branch: trunk, size: 15203
2007-12-27
15:12
Fix a race condition that can occur when reloading the database schema in shared-cache mode. (CVS 4643) file: [95658e74] check-in: [b37babef] user: danielk1977 branch: trunk, size: 15212
2007-10-03
08:46
Add automatic recovery from the pager "error-state". Also add a new error code - SQLITE_IOERR_NOMEM. (CVS 4454) file: [a01d5515] check-in: [12eca32a] user: danielk1977 branch: trunk, size: 15152
2007-09-03
15:19
Honor the SQLITE_OPEN_ flags passed into sqlite3_open_v2(). Some test cases added but more are needed. Ticket #2616. (CVS 4376) file: [02fd8779] check-in: [020a2b10] user: drh branch: trunk, size: 15118
2007-08-16
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: [a52225c7] check-in: [deb7ecd6] user: drh branch: trunk, size: 15027
2007-05-09
20:31
Fix a problem with strange expressions being fed to an ATTACH or DETACH statement. (CVS 3965) file: [ba628db0] check-in: [0c91dc9e] user: drh branch: trunk, size: 14907
2007-05-08
01:08
Begin implementing a new system of upper bounds on the capabilities of SQLite. By clearly defining the upper bounds, we make those upper bounds explicitly testable. This check-in is just infrastructure. The upper bounds are not yet enforced. (CVS 3941) file: [a674f72b] check-in: [93b623b2] user: drh branch: trunk, size: 14732
2007-05-04
13:15
Eliminate all uses of sprintf() and strcpy(). These were not being misused. But getting rid of them removes a library dependency. And it avoids warnings from the OpenBSD compiler. Ticket #2336. (CVS 3916) file: [f088f815] check-in: [ba4845b3] user: drh branch: trunk, size: 14695
2007-03-27
21:47
Fix the prototype of the CodecAttach function in attach.c. (CVS 3731) file: [a16ada4a] check-in: [902413e8] user: drh branch: trunk, size: 14581
14:44
The -DSQLITE_OMIT_ATTACH=1 option now omits both the ATTACH and VACUUM commands. Ticket #2268. The regression test suite depends on both of these commands and will not run if compiled with this option. (CVS 3727) file: [12fa4f4c] check-in: [cbebfb89] user: drh branch: trunk, size: 14575
2007-03-24
16:45
Changes for exclusive access mode. There are still some bugs. (CVS 3712) file: [9b5a9c50] check-in: [b6c70037] user: danielk1977 branch: trunk, size: 14490
2007-03-15
15:35
Save an if(...) clause made redundant by (3691). (CVS 3692) file: [fd286a91] check-in: [8153edf8] user: danielk1977 branch: trunk, size: 14413
2006-06-27
16:34
Prevent databases from being DETACHed while they are in use. Fix for #1873. (CVS 3312) file: [b11eb4d5] check-in: [70a48b25] user: danielk1977 branch: trunk, size: 14442
2006-05-25
11:52
Handle NULL database names in ATTACH and DETACH as if they were empty strings. Ticket #1825. (CVS 3191) file: [27a31d3b] check-in: [79a818bb] user: drh branch: trunk, size: 14289
2006-04-10
13:37
Follow-up to check-in (3164). Make sure SQLITE_NOMEM is returned after a memory allocation failure. It is not sufficent to return an "out of memory" error message. The return code needs to be SQLITE_NOMEM. (CVS 3172) file: [765217a6] check-in: [9d95750e] user: drh branch: trunk, size: 14178
2006-04-05
11:57
Make sure SQLITE_NOMEM is reported out on a malloc failure in an ATTACH even if the malloc failure reports within a nested calls to sqlite3_prepare(). (CVS 3164) file: [514f9062] check-in: [3538a4e3] user: drh branch: trunk, size: 14149
2006-01-24
12:09
Rename some variables to avoid hiding others. Also add "static" to two function signatures that were missing it. (CVS 3024) file: [d73a3505] check-in: [d86f18a4] user: danielk1977 branch: trunk, size: 14029
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: [0081040e] check-in: [ac090f2a] user: danielk1977 branch: trunk, size: 14008
2006-01-17
13:21
Various fixes that allow the malloc() failure tests to pass again. (CVS 2963) file: [a447b467] check-in: [0505405f] user: danielk1977 branch: trunk, size: 14046
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: [d4b9d8bd] check-in: [5d9c6aa9] user: drh branch: trunk, size: 14050
14:09
Fix bugs caused by assuming that shared-schemas are initialized. (CVS 2917) file: [fb93d00a] check-in: [3970eb87] user: danielk1977 branch: trunk, size: 14042
2006-01-10
07:14
If compiled with memory-debugging, write garbage to memory when it is freed. Fix for #1594. (CVS 2900) file: [8438a280] check-in: [bd02a6fa] user: danielk1977 branch: trunk, size: 14080
2006-01-09
23:40
Added database server example code (untested). Fixed serveral bugs including the autovacuum compile problem described by ticket #1593. (CVS 2897) file: [b5b63e93] check-in: [ec332d88] user: drh branch: trunk, size: 14022
16:12
Fix some errors to do with attached databases and text encodings in shared-cache mode. (CVS 2895) file: [fed27f54] check-in: [3e75d3d5] user: danielk1977 branch: trunk, size: 14030
06:29
Rename DbSchema to "Schema" and SqliteTsd to "ThreadData". (CVS 2893) file: [833e38b4] check-in: [82b81f69] user: danielk1977 branch: trunk, size: 13830
2006-01-06
21:52
Changes so that SQLITE_OMIT_PARSER and SQLITE_OMIT_DISKIO work. (CVS 2878) file: [4a04ffcd] check-in: [9d71b7de] user: drh branch: trunk, size: 13808
2006-01-05
11:34
Add the shared schema/pager modifications. Very few tests so far. (CVS 2859) file: [999104c5] check-in: [deeda0dc] user: danielk1977 branch: trunk, size: 13752
2005-12-29
23:04
Bug fix in codec processing. (CVS 2846) file: [07822dbd] check-in: [a88580bc] user: drh branch: trunk, size: 13700
2005-12-09
14:25
Many small changes to ensure memory is not leaked after malloc() fails. (CVS 2808) file: [ee70131f] check-in: [601c3354] user: danielk1977 branch: trunk, size: 13679
2005-12-06
17:19
Modify ATTACH and DETACH to execute at runtime instead of compile time. (CVS 2803) file: [39e67803] check-in: [5e04ec69] user: danielk1977 branch: trunk, size: 13577
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: [8c3e0945] check-in: [e1606658] user: danielk1977 branch: trunk, size: 9984
2005-08-20
03:03
Increased test coverage. Some malloc tests now fail though this is believed to be an instrumentation problem not a real error. (CVS 2604) file: [4b216897] check-in: [f786f37a] user: drh branch: trunk, size: 9959
2005-03-16
12:15
Fix some memory leaks that can occur if a memory allocation fails. (CVS 2388) file: [3615dbe9] check-in: [9a358fc3] user: danielk1977 branch: trunk, size: 9912
2005-03-15
02:04
Allow the database name in a DETACH statement to be quoted. Ticket #1151. (CVS 2386) file: [43099c31] check-in: [24e88773] user: drh branch: trunk, size: 9792
2005-01-24
10:25
Modifications and bugfixes so that the test suite passes with the TCL statement cache turned on. (CVS 2271) file: [f78f76bc] check-in: [d5233e07] user: danielk1977 branch: trunk, size: 9788
2005-01-23
13:14
ATTACH and DETACH cause prepared statements to expire. sqlite3_finalize() can now be called right after sqlite3_reset(). (CVS 2265) file: [4fcdb303] check-in: [6c631b86] user: drh branch: trunk, size: 9778
2005-01-20
11:32
Extend the influence of a couple of SQLITE_OMIT_** macros a little bit. (CVS 2243) file: [cecf5ab4] check-in: [5b1a9bf6] user: danielk1977 branch: trunk, size: 9709
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: [e49d09da] check-in: [3ddf5a9d] user: drh branch: trunk, size: 9522
2004-09-05
23:23
Comment changes and minor code cleanup. (CVS 1940) file: [3fe50b71] check-in: [dfa9ea89] user: drh branch: trunk, size: 9519
2004-08-01
03:52
Fix a memory leak when the auxiliary data of a database structure is used. (CVS 1874) file: [0bd4f11d] check-in: [7ecff04a] user: drh branch: trunk, size: 9491
2004-07-22
15:02
Fix bugs associated with the codec. (CVS 1846) file: [78445662] check-in: [b0a3becd] user: drh branch: trunk, size: 9681
02:40
Changes in support of using a codec. (CVS 1844) file: [2e5d8eae] check-in: [b77bec35] user: drh branch: trunk, size: 8924
01:19
Initial implementation of variable page sizes and the temp_store pragma. (CVS 1843) file: [9e3fcd50] check-in: [4cf6e9db] user: drh branch: trunk, size: 8971
2004-07-19
00:56
A failed ATTACH leaves the database in a consistent state. Ticket #811. (CVS 1811) file: [5e37aaac] check-in: [c22f9feb] user: drh branch: trunk, size: 9017
2004-06-30
09:49
Coverage tests for vacuum.c (CVS 1776) file: [13249827] check-in: [152e9940] user: danielk1977 branch: trunk, size: 9035
2004-06-29
08:59
Fix error reporting path for errors that occur while reading the database schema. (CVS 1757) file: [678ded37] check-in: [157db33e] user: danielk1977 branch: trunk, size: 8997
2004-06-28
01:11
Fix a bunch of harmless warnings. (CVS 1749) file: [73b16e60] check-in: [fae7c6e0] user: danielk1977 branch: trunk, size: 8982
2004-06-26
06:37
Remove default_synchronous and temp_store pragmas. Allow the safety-level and cache-size to be set for attached databases. (CVS 1735) file: [b105aeb8] check-in: [212de3ce] user: danielk1977 branch: trunk, size: 8978
2004-06-19
16:06
Omit the DB_Locked and DB_Cookie flags. Other minor cleanup. (CVS 1642) file: [05102e2e] check-in: [01f74b42] user: drh branch: trunk, size: 8944
14:49
Omit the sqlite3VdbeCode() routine. Use sqlite3NameFromToken() more to reduce the amount of code. (CVS 1639) file: [78ca379f] check-in: [99d0436e] user: drh branch: trunk, size: 8950
09:08
Make sure ATTACH and DETACH fail if a transaction is active. (CVS 1633) file: [293da1e8] check-in: [c49d8bdc] user: danielk1977 branch: trunk, size: 9068
2004-06-09
12:30
Fix error reporting when trying to attach a database with a foriegn text encoding. (CVS 1545) file: [93b8ecec] check-in: [beab038c] user: danielk1977 branch: trunk, size: 8775
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: [e76e4590] check-in: [983221b0] user: danielk1977 branch: trunk, size: 8757
2004-05-11
07:11
Remove code dealing with old file formats. (CVS 1354) file: [c315c58c] check-in: [dfde1121] user: danielk1977 branch: trunk, size: 8769
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: [fa9a5823] check-in: [8af6474c] user: danielk1977 branch: trunk, size: 8957
2004-05-07
01:46
Fix a memory leak in DETACH when using the codec. (CVS 1317) file: [02670256] check-in: [c4bd99b7] user: drh branch: version_2, size: 8948
2004-02-12
18:46
Add hooks on each attached database connection for storing auxiliary information. Add the USING clause to ATTACH. (CVS 1232) file: [b01db0d3] check-in: [800c11f4] user: drh branch: trunk, size: 8891
2004-01-20
11:54
Make ATTACH and DETACH work with the non-callback API. Ticket #574. (CVS 1194) file: [4a0a3c08] check-in: [c32a80fe] user: drh branch: trunk, size: 8504
2003-12-06
22:22
Fail an ATTACH if the auxiliary database is locked. Ticket #514. (CVS 1127) file: [9a3764bb] check-in: [ac428c8d] user: drh branch: trunk, size: 8350
2003-06-14
12:04
Bug fix: sqliteFree() called twice on the same allocation during error handling in attach.c. (CVS 1020) file: [9f78b4aa] check-in: [9ec40935] user: drh branch: trunk, size: 8178
2003-06-06
19:00
Extend the authorization mechanism to disallow the ATTACH and DETACH commands. Ticket #340. (CVS 1010) file: [0f0dd4b0] check-in: [a97dca73] user: drh branch: trunk, size: 8203
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: [db89b086] check-in: [3e8889d7] user: drh branch: trunk, size: 7818
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: [4f0aa5ad] check-in: [7202d4f1] user: drh branch: trunk, size: 7771
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: [7ebc7487] check-in: [0b996959] user: drh branch: trunk, size: 3807
2003-04-13
18:26
Support in-memory databases for temp tables (CVS 903) file: [8c98e2c0] check-in: [96336bff] user: paul branch: trunk, size: 3776
2003-04-06
21:08
Split the implementation of COPY, PRAGMA, and ATTACH into separate source code files. (CVS 902) file: [1e429791] check-in: [73359037] user: drh branch: trunk, size: 3768 Added