SQLite

Timeline
Login

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

100 check-ins occurring around b5bedb2a9f349b32.

2006-01-16
02:37
Fix the script that cross-compiles the windows DLL so that it works correctly with the latest interface. Ticket #1614. Do not strip the windows DLL. Ticket #1474. (CVS 2954) (check-in: 6591d365 user: drh tags: trunk)
00:05
Version 3.3.1 (withdrawn - see ticket #1614) (CVS 2955) (check-in: ed0f1d90 user: drh tags: trunk)
2006-01-15
20:28
Code size reductions in the pager. (CVS 2952) (check-in: c7da3aa9 user: drh tags: trunk)
18:29
Prepare for the 3.3.1 alpha release. (CVS 2951) (check-in: 3e32bcf0 user: drh tags: trunk)
17:27
Clean up comments in os_unix.c. (CVS 2950) (check-in: 2170e803 user: drh tags: trunk)
14:11
Correctly set the length of the string in bytes when transforming an OP_String8 to OP_String in a utf-16 vdbe program. (CVS 2949) (check-in: 69f996e0 user: danielk1977 tags: trunk)
13:13
Fix a buffer-overrun that could occur after a malloc() failure. (CVS 2948) (check-in: 66252221 user: danielk1977 tags: trunk)
11:39
Rollback any open write-transaction when a shared-cache connection is closed. (CVS 2947) (check-in: 1944d92b user: danielk1977 tags: trunk)
02:43
Closing a file from the wrong thread is harmless on most systems. (See ticket #1611) But on systems like RedHat9 with broken fcntl() locks, it leaks file descriptors. That is better than the alternative of prematurely breaking locks and causing database corruption. Nevertheless, it would be good if we could figure out a way to report errors when closing a file from the wrong thread. (CVS 2946) (check-in: ad8f12ca user: drh tags: trunk)
02:30
Add tests and fix bugs in the new cross-thread lock resolution code. When an unlock fails, do not leak file descriptors (ticket #1611). But we really ought to report SQLITE_MISUSE or some other error instead of just returning SQLITE_OK. (CVS 2945) (check-in: f68e05cb user: drh tags: trunk)
00:13
Documentation updates. Fix to date.c. But most importantly: database connections are now allowed to change threads as long as they are not holding a lock. (CVS 2944) (check-in: 03c422ec user: drh tags: trunk)
2006-01-14
08:02
Fixes for OMIT_SUBQUERY builds: Disable where clause OR->IN optimization. Include EXISTS keyword (for new CREATE TABLE syntax). Test file fixes. (CVS 2943) (check-in: 8e79a0c2 user: danielk1977 tags: trunk)
2006-01-13
18:06
Account for multi-byte characters in ALTER TABLE code. Fix for #1609. (CVS 2942) (check-in: d634f8b2 user: danielk1977 tags: trunk)
17:12
Tweaks to make OP_Column run a fraction faster. (CVS 2941) (check-in: 2d74cc22 user: danielk1977 tags: trunk)
15:58
Avoid parsing an entire record header when it is not required. (CVS 2940) (check-in: 0de729d9 user: danielk1977 tags: trunk)
13:55
Make sure the authenticator does not try to authenticate columns in subqueries. Ticket #1607. (CVS 2939) (check-in: 55b7dfaf user: drh tags: trunk)
13:01
Fix a vdbe stack overflow problem that could occur with a correlated sub-query. (CVS 2938) (check-in: caa7da80 user: danielk1977 tags: trunk)
11:22
Remove a few duplicate variable initializations in sqlite3BtreeCursor(). (CVS 2937) (check-in: 5e46ec01 user: danielk1977 tags: trunk)
06:33
Minor modification to restoreOrClearCursorPosition() to improve efficiency. Do not allocate the extra 8-bytes if memory-management is not enabled. (CVS 2936) (check-in: dd705955 user: danielk1977 tags: trunk)
04:31
Additional speed enhancements in btree.c. (CVS 2935) (check-in: 48b550ce user: drh tags: trunk)
02:35
Small performance improvement on sqlite3BtreeMoveto. (CVS 2934) (check-in: c780152f user: drh tags: trunk)
01:48
Add a high-speed version of sqlite3GetVarint32 to vdbe.c for a 3% performance gain. (CVS 2933) (check-in: a64e8251 user: drh tags: trunk)
01:25
Add tests to make sure "PRAGMA table_info" works using sqlite3_prepare16. Ticket #1606. (CVS 2932) (check-in: ace8ba81 user: drh tags: trunk)
01:17
Terminate the va_start in the getDigits function of date.c. (CVS 2931) (check-in: 94eac140 user: drh tags: trunk)
2006-01-12
22:17
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) (check-in: a7f528ff user: drh tags: trunk)
20:28
Performance boost in sqlite3VdbeRecordCompare. (CVS 2929) (check-in: 14c42307 user: drh tags: trunk)
19:42
Automatically cast BLOBs to strings prior to handing them over to functions like LIKE that want strings. Ticket #1605. (CVS 2928) (check-in: 730ddb0b user: drh tags: trunk)
17:20
Cache the encoding value inside VdbeExec. (CVS 2927) (check-in: 6d2a816e user: drh tags: trunk)
15:01
Additional performance improvements in sqlite3BtreeMoveto. (CVS 2926) (check-in: 52b3be96 user: drh tags: trunk)
14:30
BtreeMoveto optimization goes about 1.5% faster. (CVS 2925) (check-in: 4e4a6504 user: drh tags: trunk)
12:43
About a 2.5% speed improvement by reducing the number of sqlite3ThreadData calls in the parser. (CVS 2924) (check-in: 0caa1994 user: drh tags: trunk)
02:50
Mark the end of the return codes in the sqlite3.h.in template file. (CVS 2923) (check-in: 19b848d9 user: drh tags: trunk)
01:56
Add the legacy_file_format pragma. (CVS 2922) (check-in: b2dbd1a5 user: drh tags: trunk)
01:25
Improve performance by about 10% by avoiding excess calls to get the thread-specific data. (CVS 2921) (check-in: a8c74feb user: drh tags: trunk)
2006-01-11
23:40
Testing of the automatic TSD deallocation logic. The sqlite3_thread_cleanup() API is documented. This should close ticket #1601. (CVS 2920) (check-in: fb518b0c user: drh tags: trunk)
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) (check-in: 5d9c6aa9 user: drh tags: trunk)
16:10
Ensure the database attached as part of VACUUM can be detached successfully after a malloc() failure. (CVS 2918) (check-in: 8c26893c user: danielk1977 tags: trunk)
14:09
Fix bugs caused by assuming that shared-schemas are initialized. (CVS 2917) (check-in: 3970eb87 user: danielk1977 tags: trunk)
05:49
Fix typo noted by #1599. (CVS 2916) (check-in: 1b368c7c user: danielk1977 tags: trunk)
01:28
Version 3.3.0 (alpha) (CVS 2915) (check-in: 59a7a56c user: drh tags: trunk)
01:28
Add new APIs to the sqlite3.def file. (CVS 2914) (check-in: 9258931a user: drh tags: trunk)
01:08
Prepare for the release of version 3.3.0. (CVS 2913) (check-in: 302993ae user: drh tags: trunk)
2006-01-10
23:00
Fix a typo in the FAQ. (CVS 2912) (check-in: 5be03a36 user: drh tags: trunk)
20:36
Fix bug in the server1 test script. (CVS 2911) (check-in: 25db22b6 user: drh tags: trunk)
20:32
Combine multiple small calls to sqlite3OsWrite into one larger call. (CVS 2910) (check-in: e6e6750c user: drh tags: trunk)
20:01
Improved comments on the server and asynchronous I/O demo programs. (CVS 2909) (check-in: c0f47ccb user: drh tags: trunk)
19:45
More pedantic changes to comments in VDBE. No changes to code. Ticket #1596. (CVS 2908) (check-in: 1cf68554 user: drh tags: trunk)
18:44
Fix opcode name in comments. No changes to code. (CVS 2907) (check-in: 511ac9db user: drh tags: trunk)
18:27
Initialize variables in malloc3.test (was causing error in all.test). (CVS 2906) (check-in: 16a8172a user: danielk1977 tags: trunk)
18:08
Typos in new documentation. (CVS 2905) (check-in: b5bedb2a user: danielk1977 tags: trunk)
17:58
Store collation sequence names instead of pointers in sharable schema data structures. (CVS 2904) (check-in: 0f0213be user: danielk1977 tags: trunk)
15:18
Updates to the C-API documentation. Change the parameter type of sqlite3_soft_heap_limit to integer. (CVS 2903) (check-in: bdd35e9f user: drh tags: trunk)
13:58
Move the implementation of sqlite3_enable_shared_cache from btree.c to main.c. (CVS 2902) (check-in: 4f2ec952 user: drh tags: trunk)
12:31
Fix a problem with shared-schemas and temp triggers. (CVS 2901) (check-in: 9c18a1ce user: danielk1977 tags: trunk)
07:14
If compiled with memory-debugging, write garbage to memory when it is freed. Fix for #1594. (CVS 2900) (check-in: bd02a6fa user: danielk1977 tags: trunk)
02:30
Enable shared cache on the server demonstration. (CVS 2899) (check-in: 8719f880 user: drh tags: trunk)
2006-01-09
23:50
Add the first simple tests of server mode. Get the Makefile generated from the configure script working again. (CVS 2898) (check-in: 66f84068 user: drh tags: trunk)
23:40
Added database server example code (untested). Fixed serveral bugs including the autovacuum compile problem described by ticket #1593. (CVS 2897) (check-in: ec332d88 user: drh tags: trunk)
17:29
Reinstate the asynchronous I/O demonstration code and tests with minor changes. (CVS 2896) (check-in: eeebc640 user: drh tags: trunk)
16:12
Fix some errors to do with attached databases and text encodings in shared-cache mode. (CVS 2895) (check-in: 3e75d3d5 user: danielk1977 tags: trunk)
09:59
Add a runtime interface to enable memory-management features. (CVS 2894) (check-in: 44f8e313 user: danielk1977 tags: trunk)
06:29
Rename DbSchema to "Schema" and SqliteTsd to "ThreadData". (CVS 2893) (check-in: 82b81f69 user: danielk1977 tags: trunk)
05:36
Minor changes so that OMIT_SHARED_CACHE works. (CVS 2892) (check-in: cc963f8c user: danielk1977 tags: trunk)
00:18
Fix timezone parsing in the date/time functions. Ticket #1587. (CVS 2891) (check-in: 94c87b70 user: drh tags: trunk)
00:09
Remove benign reference to an uninitialized variable. Ticket #1590. (CVS 2890) (check-in: 32998fe8 user: drh tags: trunk)
2006-01-08
18:10
Get LIMIT and OFFSET working again for negative limits and offsets. Ticket #1586. (CVS 2889) (check-in: b2ac0be0 user: drh tags: trunk)
05:26
Remove some cruft from the VDBE. Bring comments up to date. (CVS 2888) (check-in: 41aef649 user: drh tags: trunk)
05:02
Reduce memory requirements for ORDER BY combined with LIMIT. Ticket #1586. (CVS 2887) (check-in: 55e703ec user: drh tags: trunk)
2006-01-07
18:48
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) (check-in: 0ae46131 user: drh tags: trunk)
18:14
Continued progress toward a working wince backend. (CVS 2885) (check-in: 15fda14e user: drh tags: trunk)
18:10
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) (check-in: 19f71a6d user: drh tags: trunk)
16:06
Enable redefinable I/O if the SQLITE_ENABLE_REDEF_IO macro exists. (CVS 2883) (check-in: e170e157 user: drh tags: trunk)
14:02
Fix some memory leaks caused by obscure syntax errors in SQL. (CVS 2882) (check-in: 6593199a user: danielk1977 tags: trunk)
13:21
In shared-cache mode, lock all required tables before beginning to execute the body of the statement program. (CVS 2881) (check-in: 23b587b0 user: danielk1977 tags: trunk)
04:06
Drop the mutex if the TSD key allocation fails. Ticket #1585. (CVS 2880) (check-in: 77ac231c user: drh tags: trunk)
2006-01-06
22:11
Fix bugs in test scripts that came of of sse testing. (CVS 2879) (check-in: 22bf1a2f user: drh tags: trunk)
21:52
Changes so that SQLITE_OMIT_PARSER and SQLITE_OMIT_DISKIO work. (CVS 2878) (check-in: 9d71b7de user: drh tags: trunk)
21:09
Additional changes for wince. (CVS 2877) (check-in: b10343d9 user: drh tags: trunk)
20:40
More changes to support wince. (CVS 2876) (check-in: f3cbd995 user: drh tags: trunk)
20:22
Additional efforts to get it to build on WinCE. (CVS 2875) (check-in: b45c076f user: drh tags: trunk)
16:17
A first attempt at adding native support for WinCE. (CVS 2874) (check-in: 43440567 user: drh tags: trunk)
15:03
Fix a crash caused by adding a trigger to a shared-schema and then deleting it using a different connection. (CVS 2873) (check-in: 19f93e13 user: danielk1977 tags: trunk)
14:46
Fix an alignment problem in the sqlite3OsRandomSeed(). Ticket #1584. (CVS 2872) (check-in: 373b56f0 user: drh tags: trunk)
14:41
Remove vestigial file: crashtest1.c (CVS 2871) (check-in: 6676c703 user: drh tags: trunk)
14:32
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) (check-in: 2529c2e1 user: drh tags: trunk)
13:00
Add some simple tests and fixes for shared-schema locking. (CVS 2869) (check-in: d054bed1 user: danielk1977 tags: trunk)
12:03
Back out the addition of the new header file - bad idea. (CVS 2868) (check-in: 0c4c45c3 user: drh tags: trunk)
06:33
Fix a bug that was emptying shared-schema tables during an ATTACH. (CVS 2867) (check-in: 752a2754 user: danielk1977 tags: trunk)
03:29
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) (check-in: b8332aa8 user: drh tags: trunk)
01:42
Formatting changes in btree.c. (CVS 2865) (check-in: f1922da2 user: drh tags: trunk)
00:36
Windows implementation of the thread-specific data interface. (CVS 2864) (check-in: 3aa8befe user: drh tags: trunk)
2006-01-05
23:42
Disable the update hook for the truncation optimization used by DELETE. (CVS 2863) (check-in: 448b3b9d user: drh tags: trunk)
15:50
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) (check-in: 98194a45 user: drh tags: trunk)
14:22
Fix for ticket #1582 (Double delete of invalid LIMIT clause Expr* applied to a UNION ALL query). (CVS 2861) (check-in: 5dec3a39 user: danielk1977 tags: trunk)
13:48
Disable automatic invocation of sqlite3_release_memory() when a malloc() fails in those cases where the global mutex is held. (CVS 2860) (check-in: 6fdbb8b7 user: danielk1977 tags: trunk)
11:34
Add the shared schema/pager modifications. Very few tests so far. (CVS 2859) (check-in: deeda0dc user: danielk1977 tags: trunk)
2006-01-04
21:40
Bug fix in the IF NOT EXISTS logic. (CVS 2858) (check-in: cb9095ac user: drh tags: trunk)
18:13
Bug fix in the new "exists" method of the TCL interface. (CVS 2857) (check-in: d0e3d466 user: drh tags: trunk)
15:58
Update document for CREATE INDEX IF NOT EXISTS and DROP INDEX IF EXISTS (CVS 2856) (check-in: 963ba8b8 user: drh tags: trunk)
15:54
Add support for CREATE INDEX IF NOT EXISTS and DROP INDEX IF EXISTS. (CVS 2855) (check-in: 551cdd6c user: drh tags: trunk)