]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
19 years agoAdd support for the TOTAL() aggregate function - works like SUM() except
drh [Thu, 12 Jan 2006 22:17:50 +0000 (22:17 +0000)] 
Add support for the TOTAL() aggregate function - works like SUM() except
that it returns 0 instead of NULL when presented with an empty list. (CVS 2930)

FossilOrigin-Name: a7f528ff3446d50b280fb0b85063879e3ac5751a

19 years agoPerformance boost in sqlite3VdbeRecordCompare. (CVS 2929)
drh [Thu, 12 Jan 2006 20:28:35 +0000 (20:28 +0000)] 
Performance boost in sqlite3VdbeRecordCompare. (CVS 2929)

FossilOrigin-Name: 14c423075bcebf42a3f4e24838bc865cfb90afda

19 years agoAutomatically cast BLOBs to strings prior to handing them over to
drh [Thu, 12 Jan 2006 19:42:41 +0000 (19:42 +0000)] 
Automatically cast BLOBs to strings prior to handing them over to
functions like LIKE that want strings.  Ticket #1605. (CVS 2928)

FossilOrigin-Name: 730ddb0b74ed23c916dabd7ce893bd6bc55f3549

19 years agoCache the encoding value inside VdbeExec. (CVS 2927)
drh [Thu, 12 Jan 2006 17:20:50 +0000 (17:20 +0000)] 
Cache the encoding value inside VdbeExec. (CVS 2927)

FossilOrigin-Name: 6d2a816ede8d17b993a21e418cf25edd103334de

19 years agoAdditional performance improvements in sqlite3BtreeMoveto. (CVS 2926)
drh [Thu, 12 Jan 2006 15:01:15 +0000 (15:01 +0000)] 
Additional performance improvements in sqlite3BtreeMoveto. (CVS 2926)

FossilOrigin-Name: 52b3be96b6e96994ec6fbcc67bf355cd05f61730

19 years agoBtreeMoveto optimization goes about 1.5% faster. (CVS 2925)
drh [Thu, 12 Jan 2006 14:30:19 +0000 (14:30 +0000)] 
BtreeMoveto optimization goes about 1.5% faster. (CVS 2925)

FossilOrigin-Name: 4e4a650484a39cac43386d8488ff42a8a0cc2820

19 years agoAbout a 2.5% speed improvement by reducing the number of sqlite3ThreadData
drh [Thu, 12 Jan 2006 12:43:36 +0000 (12:43 +0000)] 
About a 2.5% speed improvement by reducing the number of sqlite3ThreadData
calls in the parser. (CVS 2924)

FossilOrigin-Name: 0caa1994770142d6ca15284a26bad3879b07b15a

19 years agoMark the end of the return codes in the sqlite3.h.in template file. (CVS 2923)
drh [Thu, 12 Jan 2006 02:50:09 +0000 (02:50 +0000)] 
Mark the end of the return codes in the sqlite3.h.in template file. (CVS 2923)

FossilOrigin-Name: 19b848d99f215914454422edc0ce72422de0774e

19 years agoAdd the legacy_file_format pragma. (CVS 2922)
drh [Thu, 12 Jan 2006 01:56:43 +0000 (01:56 +0000)] 
Add the legacy_file_format pragma. (CVS 2922)

FossilOrigin-Name: b2dbd1a5b7f5a70049f25755f07b9c4c5116549b

19 years agoImprove performance by about 10% by avoiding excess calls to get
drh [Thu, 12 Jan 2006 01:25:18 +0000 (01:25 +0000)] 
Improve performance by about 10% by avoiding excess calls to get
the thread-specific data. (CVS 2921)

FossilOrigin-Name: a8c74febec11eb689ca9f6b454f8c8bbadfc49d7

19 years agoTesting of the automatic TSD deallocation logic. The sqlite3_thread_cleanup()
drh [Wed, 11 Jan 2006 23:40:33 +0000 (23:40 +0000)] 
Testing of the automatic TSD deallocation logic.  The sqlite3_thread_cleanup()
API is documented.  This should close ticket #1601. (CVS 2920)

FossilOrigin-Name: fb518b0ce4ddd4aaca5cccf61e651f173e735119

19 years agoAutomatically deallocate thread-specific data when it is no longer
drh [Wed, 11 Jan 2006 21:41:20 +0000 (21:41 +0000)] 
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)

FossilOrigin-Name: 5d9c6aa964305c3f36741ff0058da5b5f3ce0d24

19 years agoEnsure the database attached as part of VACUUM can be detached successfully after...
danielk1977 [Wed, 11 Jan 2006 16:10:20 +0000 (16:10 +0000)] 
Ensure the database attached as part of VACUUM can be detached successfully after a malloc() failure. (CVS 2918)

FossilOrigin-Name: 8c26893c65574b0667bb84bde3ca49751079cc8d

19 years agoFix bugs caused by assuming that shared-schemas are initialized. (CVS 2917)
danielk1977 [Wed, 11 Jan 2006 14:09:31 +0000 (14:09 +0000)] 
Fix bugs caused by assuming that shared-schemas are initialized. (CVS 2917)

FossilOrigin-Name: 3970eb875d1830d35b3a70a7583a8ab6b238cad6

19 years agoFix typo noted by #1599. (CVS 2916)
danielk1977 [Wed, 11 Jan 2006 05:49:50 +0000 (05:49 +0000)] 
Fix typo noted by #1599. (CVS 2916)

FossilOrigin-Name: 1b368c7c5ca7974e0975dc4e3c931680c9e8df1f

19 years agoVersion 3.3.0 (alpha) (CVS 2915)
drh [Wed, 11 Jan 2006 01:28:30 +0000 (01:28 +0000)] 
Version 3.3.0 (alpha) (CVS 2915)

FossilOrigin-Name: 59a7a56c1bba84b5c60a2f3e25bf51d933075aaf

19 years agoAdd new APIs to the sqlite3.def file. (CVS 2914)
drh [Wed, 11 Jan 2006 01:28:11 +0000 (01:28 +0000)] 
Add new APIs to the sqlite3.def file. (CVS 2914)

FossilOrigin-Name: 9258931a80e0dac78b015e1e200d1291a6177320

19 years agoPrepare for the release of version 3.3.0. (CVS 2913)
drh [Wed, 11 Jan 2006 01:08:34 +0000 (01:08 +0000)] 
Prepare for the release of version 3.3.0. (CVS 2913)

FossilOrigin-Name: 302993ae16750c56fd1418531ba716cff53d2df0

19 years agoFix a typo in the FAQ. (CVS 2912)
drh [Tue, 10 Jan 2006 23:00:41 +0000 (23:00 +0000)] 
Fix a typo in the FAQ. (CVS 2912)

FossilOrigin-Name: 5be03a361d9292ccdf311372be6add29ade4dd04

19 years agoFix bug in the server1 test script. (CVS 2911)
drh [Tue, 10 Jan 2006 20:36:39 +0000 (20:36 +0000)] 
Fix bug in the server1 test script. (CVS 2911)

FossilOrigin-Name: 25db22b6711590214f4f953e6e3cf6be2d7451db

19 years agoCombine multiple small calls to sqlite3OsWrite into one larger call. (CVS 2910)
drh [Tue, 10 Jan 2006 20:32:32 +0000 (20:32 +0000)] 
Combine multiple small calls to sqlite3OsWrite into one larger call. (CVS 2910)

FossilOrigin-Name: e6e6750c24dc8b87be96bdc0e93254d7f0700543

19 years agoImproved comments on the server and asynchronous I/O demo programs. (CVS 2909)
drh [Tue, 10 Jan 2006 20:01:18 +0000 (20:01 +0000)] 
Improved comments on the server and asynchronous I/O demo programs. (CVS 2909)

FossilOrigin-Name: c0f47ccbc915f20d56f393383c21b4026785e6a5

19 years agoMore pedantic changes to comments in VDBE. No changes to code. Ticket #1596. (CVS...
drh [Tue, 10 Jan 2006 19:45:49 +0000 (19:45 +0000)] 
More pedantic changes to comments in VDBE.  No changes to code.  Ticket #1596. (CVS 2908)

FossilOrigin-Name: 1cf6855430352ffbf921a977186345d7272fe272

19 years agoFix opcode name in comments. No changes to code. (CVS 2907)
drh [Tue, 10 Jan 2006 18:44:08 +0000 (18:44 +0000)] 
Fix opcode name in comments.  No changes to code. (CVS 2907)

FossilOrigin-Name: 511ac9db12ad84bb02d84568b75fc65cef661e88

19 years agoInitialize variables in malloc3.test (was causing error in all.test). (CVS 2906)
danielk1977 [Tue, 10 Jan 2006 18:27:41 +0000 (18:27 +0000)] 
Initialize variables in malloc3.test (was causing error in all.test). (CVS 2906)

FossilOrigin-Name: 16a8172a617d4ff739660ae67d3e381b2dea68e6

19 years agoTypos in new documentation. (CVS 2905)
danielk1977 [Tue, 10 Jan 2006 18:08:09 +0000 (18:08 +0000)] 
Typos in new documentation. (CVS 2905)

FossilOrigin-Name: b5bedb2a9f349b32acbd0356c61cdc30fd474eca

19 years agoStore collation sequence names instead of pointers in sharable schema data structures...
danielk1977 [Tue, 10 Jan 2006 17:58:23 +0000 (17:58 +0000)] 
Store collation sequence names instead of pointers in sharable schema data structures. (CVS 2904)

FossilOrigin-Name: 0f0213be4d064b3d24e31ff93ec16f6862003d26

19 years agoUpdates to the C-API documentation. Change the parameter type of
drh [Tue, 10 Jan 2006 15:18:27 +0000 (15:18 +0000)] 
Updates to the C-API documentation.  Change the parameter type of
sqlite3_soft_heap_limit to integer. (CVS 2903)

FossilOrigin-Name: bdd35e9fbb651fe7a1ed5042923c9529c3c5ab7c

19 years agoMove the implementation of sqlite3_enable_shared_cache from btree.c to main.c. (CVS...
drh [Tue, 10 Jan 2006 13:58:48 +0000 (13:58 +0000)] 
Move the implementation of sqlite3_enable_shared_cache from btree.c to main.c. (CVS 2902)

FossilOrigin-Name: 4f2ec95283f1ae0a28b2f9ce0afc5a7203de87fb

19 years agoFix a problem with shared-schemas and temp triggers. (CVS 2901)
danielk1977 [Tue, 10 Jan 2006 12:31:39 +0000 (12:31 +0000)] 
Fix a problem with shared-schemas and temp triggers. (CVS 2901)

FossilOrigin-Name: 9c18a1ce1e7ff6a02eb0f9ce344cab9660819740

19 years agoIf compiled with memory-debugging, write garbage to memory when it is freed. Fix...
danielk1977 [Tue, 10 Jan 2006 07:14:23 +0000 (07:14 +0000)] 
If compiled with memory-debugging, write garbage to memory when it is freed. Fix for #1594. (CVS 2900)

FossilOrigin-Name: bd02a6faefa3602d0b93d54bc57809a2222d5903

19 years agoEnable shared cache on the server demonstration. (CVS 2899)
drh [Tue, 10 Jan 2006 02:30:33 +0000 (02:30 +0000)] 
Enable shared cache on the server demonstration. (CVS 2899)

FossilOrigin-Name: 8719f880a395db8be65ea45615d8e55985306f1e

19 years agoAdd the first simple tests of server mode. Get the Makefile generated from
drh [Mon, 9 Jan 2006 23:50:11 +0000 (23:50 +0000)] 
Add the first simple tests of server mode.  Get the Makefile generated from
the configure script working again. (CVS 2898)

FossilOrigin-Name: 66f84068f3c7c0963ce88f84fc0ba6775f64cd19

19 years agoAdded database server example code (untested). Fixed serveral bugs including
drh [Mon, 9 Jan 2006 23:40:25 +0000 (23:40 +0000)] 
Added database server example code (untested).  Fixed serveral bugs including
the autovacuum compile problem described by ticket #1593. (CVS 2897)

FossilOrigin-Name: ec332d8822d1ac9673581a26ab2a2fce5f2554a3

19 years agoReinstate the asynchronous I/O demonstration code and tests with minor
drh [Mon, 9 Jan 2006 17:29:52 +0000 (17:29 +0000)] 
Reinstate the asynchronous I/O demonstration code and tests with minor
changes. (CVS 2896)

FossilOrigin-Name: eeebc640aaeeb0ab7f730d854069f159aa41968b

19 years agoFix some errors to do with attached databases and text encodings in shared-cache...
danielk1977 [Mon, 9 Jan 2006 16:12:04 +0000 (16:12 +0000)] 
Fix some errors to do with attached databases and text encodings in shared-cache mode. (CVS 2895)

FossilOrigin-Name: 3e75d3d5efebc0dfff1adfc13d85e85ec39db3eb

19 years agoAdd a runtime interface to enable memory-management features. (CVS 2894)
danielk1977 [Mon, 9 Jan 2006 09:59:49 +0000 (09:59 +0000)] 
Add a runtime interface to enable memory-management features. (CVS 2894)

FossilOrigin-Name: 44f8e3139aa3ad3fcce9028565dd9ad23bbe62a2

19 years agoRename DbSchema to "Schema" and SqliteTsd to "ThreadData". (CVS 2893)
danielk1977 [Mon, 9 Jan 2006 06:29:47 +0000 (06:29 +0000)] 
Rename DbSchema to "Schema" and SqliteTsd to "ThreadData". (CVS 2893)

FossilOrigin-Name: 82b81f69c78cb3f54634d9aea4f6a838474dc5e5

19 years agoMinor changes so that OMIT_SHARED_CACHE works. (CVS 2892)
danielk1977 [Mon, 9 Jan 2006 05:36:27 +0000 (05:36 +0000)] 
Minor changes so that OMIT_SHARED_CACHE works. (CVS 2892)

FossilOrigin-Name: cc963f8cfc6c704c645c627bffb8df21dfebffc6

19 years agoFix timezone parsing in the date/time functions. Ticket #1587. (CVS 2891)
drh [Mon, 9 Jan 2006 00:18:02 +0000 (00:18 +0000)] 
Fix timezone parsing in the date/time functions.  Ticket #1587. (CVS 2891)

FossilOrigin-Name: 94c87b70161d4d44fbf1602fc2baae22dca08759

19 years agoRemove benign reference to an uninitialized variable. Ticket #1590. (CVS 2890)
drh [Mon, 9 Jan 2006 00:09:01 +0000 (00:09 +0000)] 
Remove benign reference to an uninitialized variable.  Ticket #1590. (CVS 2890)

FossilOrigin-Name: 32998fe8ed38a79eb79d8b13051b47bf74661e3c

19 years agoGet LIMIT and OFFSET working again for negative limits and offsets.
drh [Sun, 8 Jan 2006 18:10:17 +0000 (18:10 +0000)] 
Get LIMIT and OFFSET working again for negative limits and offsets.
Ticket #1586. (CVS 2889)

FossilOrigin-Name: b2ac0be07ec76ab23b7e5b800c0bc62d0bc97f4b

19 years agoRemove some cruft from the VDBE. Bring comments up to date. (CVS 2888)
drh [Sun, 8 Jan 2006 05:26:41 +0000 (05:26 +0000)] 
Remove some cruft from the VDBE.  Bring comments up to date. (CVS 2888)

FossilOrigin-Name: 41aef6496a10c81e1095408dc8f69740d6ea7627

19 years agoReduce memory requirements for ORDER BY combined with LIMIT. Ticket #1586. (CVS...
drh [Sun, 8 Jan 2006 05:02:54 +0000 (05:02 +0000)] 
Reduce memory requirements for ORDER BY combined with LIMIT.  Ticket #1586. (CVS 2887)

FossilOrigin-Name: 55e703ecac6e03d7364c2d919ba18d7293d6b7f6

19 years agoInvalidate all VDBE cursor row caches in between calls to sqlite3_step()
drh [Sat, 7 Jan 2006 18:48:26 +0000 (18:48 +0000)] 
Invalidate all VDBE cursor row caches in between calls to sqlite3_step()
since the emphemeral content that those caches point to might change if
the statement is READ UNCOMMITTED. (CVS 2886)

FossilOrigin-Name: 0ae461313c1642a49a9f6cda608c42c7c0053ce4

19 years agoContinued progress toward a working wince backend. (CVS 2885)
drh [Sat, 7 Jan 2006 18:14:48 +0000 (18:14 +0000)] 
Continued progress toward a working wince backend. (CVS 2885)

FossilOrigin-Name: 15fda14ee0c0524d3064d767f48edd689c090d95

19 years agoMake sure there is no ephemeral data on the stack before returning from
drh [Sat, 7 Jan 2006 18:10:32 +0000 (18:10 +0000)] 
Make sure there is no ephemeral data on the stack before returning from
an sqlite3_step() call.  Otherwise, if the statement is in READ UNCOMMITTED
mode then the data might be deleted or changed out from under us. (CVS 2884)

FossilOrigin-Name: 19f71a6d1982e986f5436bff71ef38b1bcc2e11d

19 years agoEnable redefinable I/O if the SQLITE_ENABLE_REDEF_IO macro exists. (CVS 2883)
drh [Sat, 7 Jan 2006 16:06:07 +0000 (16:06 +0000)] 
Enable redefinable I/O if the SQLITE_ENABLE_REDEF_IO macro exists. (CVS 2883)

FossilOrigin-Name: e170e15766389e978991b42a0d2ec303162aaad6

19 years agoFix some memory leaks caused by obscure syntax errors in SQL. (CVS 2882)
danielk1977 [Sat, 7 Jan 2006 14:02:26 +0000 (14:02 +0000)] 
Fix some memory leaks caused by obscure syntax errors in SQL. (CVS 2882)

FossilOrigin-Name: 6593199a4d0d0e1f9cc2f48d30327b1c03a8170e

19 years agoIn shared-cache mode, lock all required tables before beginning to execute the body...
danielk1977 [Sat, 7 Jan 2006 13:21:04 +0000 (13:21 +0000)] 
In shared-cache mode, lock all required tables before beginning to execute the body of the statement program. (CVS 2881)

FossilOrigin-Name: 23b587b05b89727248805e6d9e5141e018cf2152

19 years agoDrop the mutex if the TSD key allocation fails. Ticket #1585. (CVS 2880)
drh [Sat, 7 Jan 2006 04:06:54 +0000 (04:06 +0000)] 
Drop the mutex if the TSD key allocation fails.  Ticket #1585. (CVS 2880)

FossilOrigin-Name: 77ac231c0e21c09c0b612a4e72bcc863f2c95fd3

19 years agoFix bugs in test scripts that came of of sse testing. (CVS 2879)
drh [Fri, 6 Jan 2006 22:11:20 +0000 (22:11 +0000)] 
Fix bugs in test scripts that came of of sse testing. (CVS 2879)

FossilOrigin-Name: 22bf1a2ffac503020dfa78d228b561d1cf6f3894

19 years agoChanges so that SQLITE_OMIT_PARSER and SQLITE_OMIT_DISKIO work. (CVS 2878)
drh [Fri, 6 Jan 2006 21:52:49 +0000 (21:52 +0000)] 
Changes so that SQLITE_OMIT_PARSER and SQLITE_OMIT_DISKIO work. (CVS 2878)

FossilOrigin-Name: 9d71b7deaffdd7eb9ddad1f03df3e4c51c2cbd98

19 years agoAdditional changes for wince. (CVS 2877)
drh [Fri, 6 Jan 2006 21:09:01 +0000 (21:09 +0000)] 
Additional changes for wince. (CVS 2877)

FossilOrigin-Name: b10343d9163263f97efb1bbc61af8307a2cfe8a4

19 years agoMore changes to support wince. (CVS 2876)
drh [Fri, 6 Jan 2006 20:40:28 +0000 (20:40 +0000)] 
More changes to support wince. (CVS 2876)

FossilOrigin-Name: f3cbd995c845dc19596678d05844e0691b63da54

19 years agoAdditional efforts to get it to build on WinCE. (CVS 2875)
drh [Fri, 6 Jan 2006 20:22:29 +0000 (20:22 +0000)] 
Additional efforts to get it to build on WinCE. (CVS 2875)

FossilOrigin-Name: b45c076f0d5f7c863287ccb5703c492e1010a99d

19 years agoA first attempt at adding native support for WinCE. (CVS 2874)
drh [Fri, 6 Jan 2006 16:17:05 +0000 (16:17 +0000)] 
A first attempt at adding native support for WinCE. (CVS 2874)

FossilOrigin-Name: 434405678778e7ce6e0bdec02fa7049a1ca68d27

19 years agoFix a crash caused by adding a trigger to a shared-schema and then deleting it
danielk1977 [Fri, 6 Jan 2006 15:03:48 +0000 (15:03 +0000)] 
Fix a crash caused by adding a trigger to a shared-schema and then deleting it
using a different connection. (CVS 2873)

FossilOrigin-Name: 19f93e135f1ff4f987d14afe74b955e119904017

19 years agoFix an alignment problem in the sqlite3OsRandomSeed(). Ticket #1584. (CVS 2872)
drh [Fri, 6 Jan 2006 14:46:46 +0000 (14:46 +0000)] 
Fix an alignment problem in the sqlite3OsRandomSeed().  Ticket #1584. (CVS 2872)

FossilOrigin-Name: 373b56f0048fd6a1946a97acfcca40fd12f7d572

19 years agoRemove vestigial file: crashtest1.c (CVS 2871)
drh [Fri, 6 Jan 2006 14:41:54 +0000 (14:41 +0000)] 
Remove vestigial file: crashtest1.c (CVS 2871)

FossilOrigin-Name: 6676c7031d81202ad702142ecf9e64f14d94d968

19 years agoChange the OS interface layer to use traditional direct function call
drh [Fri, 6 Jan 2006 14:32:19 +0000 (14:32 +0000)] 
Change the OS interface layer to use traditional direct function call
implementations instead of the more complicated virtual function table.
Omit the asynchronous I/O demo. (CVS 2870)

FossilOrigin-Name: 2529c2e11fa1d345ec61f647e4f6fae20a7133d6

19 years agoAdd some simple tests and fixes for shared-schema locking. (CVS 2869)
danielk1977 [Fri, 6 Jan 2006 13:00:28 +0000 (13:00 +0000)] 
Add some simple tests and fixes for shared-schema locking. (CVS 2869)

FossilOrigin-Name: d054bed15aee3edef93cc84c83be443cdd489946

19 years agoBack out the addition of the new header file - bad idea. (CVS 2868)
drh [Fri, 6 Jan 2006 12:03:19 +0000 (12:03 +0000)] 
Back out the addition of the new header file - bad idea. (CVS 2868)

FossilOrigin-Name: 0c4c45c36fe1c3c2980155ef5126a2ad53100d65

19 years agoFix a bug that was emptying shared-schema tables during an ATTACH. (CVS 2867)
danielk1977 [Fri, 6 Jan 2006 06:33:12 +0000 (06:33 +0000)] 
Fix a bug that was emptying shared-schema tables during an ATTACH. (CVS 2867)

FossilOrigin-Name: 752a2754879becc32da9f9b910f3330f8c7145e4

19 years agoEnable async testing. Modify the OS layer interface. Add the sqlite3_aux.h include...
drh [Fri, 6 Jan 2006 03:29:56 +0000 (03:29 +0000)] 
Enable async testing.  Modify the OS layer interface.  Add the sqlite3_aux.h include file.  Add tests for boolean value representation in file format 4. (CVS 2866)

FossilOrigin-Name: b8332aa8b83142898779972b3dff13cbe3c78623

19 years agoFormatting changes in btree.c. (CVS 2865)
drh [Fri, 6 Jan 2006 01:42:58 +0000 (01:42 +0000)] 
Formatting changes in btree.c. (CVS 2865)

FossilOrigin-Name: f1922da2d20c5091678e47cc4f43a2a9d141a3b1

19 years agoWindows implementation of the thread-specific data interface. (CVS 2864)
drh [Fri, 6 Jan 2006 00:36:00 +0000 (00:36 +0000)] 
Windows implementation of the thread-specific data interface. (CVS 2864)

FossilOrigin-Name: 3aa8befedf4534cd100a7309997a4ad2ba08af20

19 years agoDisable the update hook for the truncation optimization used by DELETE. (CVS 2863)
drh [Thu, 5 Jan 2006 23:42:50 +0000 (23:42 +0000)] 
Disable the update hook for the truncation optimization used by DELETE. (CVS 2863)

FossilOrigin-Name: 448b3b9dede724749df0004ca39c649951f1f2ca

19 years agoMove TCL interface for sqlite3_release_memory() and sqlite3_soft_heap_limit()
drh [Thu, 5 Jan 2006 15:50:06 +0000 (15:50 +0000)] 
Move TCL interface for sqlite3_release_memory() and sqlite3_soft_heap_limit()
out of tclsqlite.c and into test1.c.  Update the TCL interface documention
to describe the "exists" method. (CVS 2862)

FossilOrigin-Name: 98194a45cc60cb9942847f773bc797fb5463bd10

19 years agoFix for ticket #1582 (Double delete of invalid LIMIT clause Expr* applied to a UNION...
danielk1977 [Thu, 5 Jan 2006 14:22:33 +0000 (14:22 +0000)] 
Fix for ticket #1582 (Double delete of invalid LIMIT clause Expr* applied to a UNION ALL query). (CVS 2861)

FossilOrigin-Name: 5dec3a392ba3c249bbca899c12e99c26cc1b8cdb

19 years agoDisable automatic invocation of sqlite3_release_memory() when a malloc() fails
danielk1977 [Thu, 5 Jan 2006 13:48:29 +0000 (13:48 +0000)] 
Disable automatic invocation of sqlite3_release_memory() when a malloc() fails
in those cases where the global mutex is held. (CVS 2860)

FossilOrigin-Name: 6fdbb8b771e490f0d791326689245302c4fe18f5

19 years agoAdd the shared schema/pager modifications. Very few tests so far. (CVS 2859)
danielk1977 [Thu, 5 Jan 2006 11:34:32 +0000 (11:34 +0000)] 
Add the shared schema/pager modifications. Very few tests so far. (CVS 2859)

FossilOrigin-Name: deeda0dc06c1595aedd8d06a0c4e88a8abf78cf7

19 years agoBug fix in the IF NOT EXISTS logic. (CVS 2858)
drh [Wed, 4 Jan 2006 21:40:06 +0000 (21:40 +0000)] 
Bug fix in the IF NOT EXISTS logic. (CVS 2858)

FossilOrigin-Name: cb9095ac52e76926f274678ef55ebb9df4b9fcac

19 years agoBug fix in the new "exists" method of the TCL interface. (CVS 2857)
drh [Wed, 4 Jan 2006 18:13:26 +0000 (18:13 +0000)] 
Bug fix in the new "exists" method of the TCL interface. (CVS 2857)

FossilOrigin-Name: d0e3d466094f7b2f74ed7ebb324e5024ea8faa6f

19 years agoUpdate document for CREATE INDEX IF NOT EXISTS and DROP INDEX IF EXISTS (CVS 2856)
drh [Wed, 4 Jan 2006 15:58:28 +0000 (15:58 +0000)] 
Update document for CREATE INDEX IF NOT EXISTS and DROP INDEX IF EXISTS (CVS 2856)

FossilOrigin-Name: 963ba8b8f3b7b3a8bcd36b224e283cf3b86d4b1d

19 years agoAdd support for CREATE INDEX IF NOT EXISTS and DROP INDEX IF EXISTS. (CVS 2855)
drh [Wed, 4 Jan 2006 15:54:36 +0000 (15:54 +0000)] 
Add support for CREATE INDEX IF NOT EXISTS and DROP INDEX IF EXISTS. (CVS 2855)

FossilOrigin-Name: 551cdd6c309e75687abaeac5381b794cd5e4c10a

19 years agoAlways case 0 to (char*) on varargs functions. Otherwise there are problems
drh [Tue, 3 Jan 2006 15:16:26 +0000 (15:16 +0000)] 
Always case 0 to (char*) on varargs functions.  Otherwise there are problems
on 64-bit machines. (CVS 2854)

FossilOrigin-Name: 837dc77ff9f5271b7e1bb8602fc021670c7802d1

19 years agoAdd test files for the asynchronous IO concept. (CVS 2853)
danielk1977 [Tue, 3 Jan 2006 13:39:25 +0000 (13:39 +0000)] 
Add test files for the asynchronous IO concept. (CVS 2853)

FossilOrigin-Name: 7c3492c8404c39c808af4429b4fcdb7413539ab3

19 years agoThe sqlite TCL command no longer returns the hex address of the sqlite3*
drh [Tue, 3 Jan 2006 00:33:50 +0000 (00:33 +0000)] 
The sqlite TCL command no longer returns the hex address of the sqlite3*
structure.  Instead there is a new command in testfixture to find that
information. (CVS 2852)

FossilOrigin-Name: 70b228575e045bc56013aab945334203ceb31d8b

19 years agoAdd the xInMutex method to the os-layer switch for testing whether or not
drh [Mon, 2 Jan 2006 20:00:12 +0000 (20:00 +0000)] 
Add the xInMutex method to the os-layer switch for testing whether or not
mutexes are used correctly. (CVS 2851)

FossilOrigin-Name: a582b159595ff8d31c81e9b3044711d6590d3f0e

19 years agoAdditional tests for descending indices. Comment changes. (CVS 2850)
drh [Mon, 2 Jan 2006 18:24:40 +0000 (18:24 +0000)] 
Additional tests for descending indices.  Comment changes. (CVS 2850)

FossilOrigin-Name: 2622c5242b0cba5bc19f190a7c209ab9ed8f57e0

19 years agoRepair typo in previous commit. (CVS 2849)
danielk1977 [Fri, 30 Dec 2005 16:31:53 +0000 (16:31 +0000)] 
Repair typo in previous commit. (CVS 2849)

FossilOrigin-Name: a4aa0911bccd0627cd6d926c5bdd2a4f4b8f6cc5

19 years agoAdd part of the btree layer of the shared-cache feature. (CVS 2848)
danielk1977 [Fri, 30 Dec 2005 16:28:01 +0000 (16:28 +0000)] 
Add part of the btree layer of the shared-cache feature. (CVS 2848)

FossilOrigin-Name: 2afcad990190af97d1ad0010f211a5ca8f0fd745

19 years agoAdd support for CREATE TABLE IF NOT EXISTS. (CVS 2847)
drh [Thu, 29 Dec 2005 23:33:54 +0000 (23:33 +0000)] 
Add support for CREATE TABLE IF NOT EXISTS. (CVS 2847)

FossilOrigin-Name: 0bd9e35fd22946640f4fb1c1874922ae096916f7

19 years agoBug fix in codec processing. (CVS 2846)
drh [Thu, 29 Dec 2005 23:04:01 +0000 (23:04 +0000)] 
Bug fix in codec processing. (CVS 2846)

FossilOrigin-Name: a88580bce045ee1c11cc6fd986ee7bab043ded4f

19 years agoAdd serial-types 8 and 9 for integer constants of 0 and 1 that use zero
drh [Thu, 29 Dec 2005 19:23:06 +0000 (19:23 +0000)] 
Add serial-types 8 and 9 for integer constants of 0 and 1 that use zero
bytes of storage.  Make the default file format 4.  Add the
SQLITE_DEFAULT_FILE_FORMAT compile-time option to lower the default
file format number so that newly created databases can be read and
written by older versions of SQLite. (CVS 2845)

FossilOrigin-Name: ae301db8a61a74bc72f67f5766811d89a3b3ec72

19 years agoFix for ticket #1575. (CVS 2844)
drh [Thu, 29 Dec 2005 12:53:09 +0000 (12:53 +0000)] 
Fix for ticket #1575. (CVS 2844)

FossilOrigin-Name: 1586921b54da5ba3bea80e8e656a11d32996ab3a

19 years agoAdd support for DROP TABLE IF EXISTS. (CVS 2843)
drh [Thu, 29 Dec 2005 01:11:36 +0000 (01:11 +0000)] 
Add support for DROP TABLE IF EXISTS. (CVS 2843)

FossilOrigin-Name: a4c547de83d8b27f06a58f9e530a7c983ec1dc3a

19 years agoMake genericAllocationSize work on NULL pointers. (CVS 2842)
drh [Thu, 22 Dec 2005 13:47:49 +0000 (13:47 +0000)] 
Make genericAllocationSize work on NULL pointers. (CVS 2842)

FossilOrigin-Name: 326fc9cc11c86f2d96763537d60757200ce21a84

19 years agoBug fixes and additional testing of descending indices. (CVS 2841)
drh [Wed, 21 Dec 2005 18:36:45 +0000 (18:36 +0000)] 
Bug fixes and additional testing of descending indices. (CVS 2841)

FossilOrigin-Name: 5638a11ed5618dd833d3daffc1715951091d72b2

19 years agoBasic functionality for descending indices is in place. Lots more testing
drh [Wed, 21 Dec 2005 14:43:11 +0000 (14:43 +0000)] 
Basic functionality for descending indices is in place.  Lots more testing
needed. (CVS 2840)

FossilOrigin-Name: 7064433e5b06a4f858f39ce57650fba99fd72ffd

19 years agoProgress toward decending indices. (CVS 2839)
drh [Wed, 21 Dec 2005 03:16:42 +0000 (03:16 +0000)] 
Progress toward decending indices. (CVS 2839)

FossilOrigin-Name: 112a34b8dcceb39540cb0cd629e264a867400bfb

19 years agoInclude sqlite3_release_memory() code when SQLITE_MEMDEBUG is not defined. (CVS 2838)
danielk1977 [Tue, 20 Dec 2005 14:37:59 +0000 (14:37 +0000)] 
Include sqlite3_release_memory() code when SQLITE_MEMDEBUG is not defined. (CVS 2838)

FossilOrigin-Name: 77a37ceca7792e6cda6810e3387e6dda14a5c7ec

19 years agoAdd simple tests and fixes for sqlite3_soft_heap_limit() (CVS 2837)
danielk1977 [Tue, 20 Dec 2005 09:19:37 +0000 (09:19 +0000)] 
Add simple tests and fixes for sqlite3_soft_heap_limit() (CVS 2837)

FossilOrigin-Name: c2c5285442f4558dfca61b52f31b5a9cbefaed10

19 years agoWebsite changes in preparation for the release of 2.8.17. (CVS 2834)
drh [Mon, 19 Dec 2005 17:53:35 +0000 (17:53 +0000)] 
Website changes in preparation for the release of 2.8.17. (CVS 2834)

FossilOrigin-Name: a927696ba30da39cb94ba666a10b7311d46826c9

19 years agoWebsite changes for the release of 3.2.8. (CVS 2831)
drh [Mon, 19 Dec 2005 17:26:46 +0000 (17:26 +0000)] 
Website changes for the release of 3.2.8. (CVS 2831)

FossilOrigin-Name: 2f7ec117ded31f2c13f2e3ab9dd4e9a483434601

19 years agoTentative fix for ticket #1567: disable the sqlite3pager_dont_write()
drh [Mon, 19 Dec 2005 16:15:31 +0000 (16:15 +0000)] 
Tentative fix for ticket #1567:  disable the sqlite3pager_dont_write()
optimization when a statement transaction is active.  We continue to look
for a better fix. (CVS 2827)

FossilOrigin-Name: e6106cc133e5210bfa248d811122e9bf7d6f2b7c

19 years agoAdd some very simple test cases (and resulting bug fixes) for release_memory(). ...
danielk1977 [Mon, 19 Dec 2005 14:18:11 +0000 (14:18 +0000)] 
Add some very simple test cases (and resulting bug fixes) for release_memory(). (CVS 2826)

FossilOrigin-Name: 154282fca54bf03d310d6931660f99805bb5477f

19 years agoAdd the (untested) sqlite3_release_memory() function. (CVS 2825)
danielk1977 [Sun, 18 Dec 2005 08:51:22 +0000 (08:51 +0000)] 
Add the (untested) sqlite3_release_memory() function. (CVS 2825)

FossilOrigin-Name: 345addaa03d3bfa3429a59597fbd3addcff62e30

19 years agoVerify that the rollback-hook is invoked correctly when a malloc() failure occurs...
danielk1977 [Fri, 16 Dec 2005 15:24:28 +0000 (15:24 +0000)] 
Verify that the rollback-hook is invoked correctly when a malloc() failure occurs. (CVS 2824)

FossilOrigin-Name: 83c8ae5bee3b6bdb556d2e85fa260ba855742601