Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
131 events for the month beginning 2006-01-01 by user drh
Following month ↑|
2006-01-31
| ||
| 23:03 | Add the SQLITE_THREADS_OVERRIDE_LOCKS compile-time option that disables the run-time test to see if threads can override each others locks on unix. (CVS 3050) (check-in: e83a19e8 user: drh tags: trunk) | |
| 20:49 | Patches to support linux on embedded platforms. (CVS 3049) (check-in: a088eb6d user: drh tags: trunk) | |
| 19:31 | Fix some pointless warnings from overly-pedantic compilers. (CVS 3048) (check-in: b922c8e4 user: drh tags: trunk) | |
| 19:07 | 3rd parameter to sqlite3_prepare() should be -1 if the string length is unknown. Passing in zero causes a zero-length SQL statement to be prepared, which is a no-op. Ticket #1651. This bug introduced by the fix for ticket #1650. (CVS 3047) (check-in: 1e68ac59 user: drh tags: trunk) | |
| 16:21 | Version 3.3.3 (CVS 3046) (check-in: 10a3f565 user: drh tags: trunk) | |
| 16:20 | Put in the correct release date for version 3.3.3. (CVS 3045) (check-in: 1133a840 user: drh tags: trunk) | |
| 15:19 | Fix an problem in the test scripts that was show false failures under windows. (CVS 3044) (check-in: 0cf4e3c6 user: drh tags: trunk) | |
| 14:28 | Authorization callback on the ALTER TABLE ADD COLUMN command. Ticket #1479. (CVS 3043) (check-in: 461f5869 user: drh tags: trunk) | |
|
2006-01-30
| ||
| 23:04 | Remove support for the non-standard ON CONFLICT clause on CREATE INDEX. Ticket #1486. The ON CONFLICT clause has never worked on CREATE INDEX so removing it should not break anything. (CVS 3042) (check-in: 669bcf5a user: drh tags: trunk) | |
| 22:48 | Memory DB works with autovacuum. (CVS 3041) (check-in: 34dff874 user: drh tags: trunk) | |
| 22:35 | Make sure the 3rd parameter to sqlite3_prepare() is honored. Ticket #1650. (CVS 3040) (check-in: 9d53cc88 user: drh tags: trunk) | |
| 22:12 | Clarify that the nBytes parameter to sqlite3_prepare is always the number of bytes and never the number of characters. Ticket #1646. (CVS 3039) (check-in: 8efc8c57 user: drh tags: trunk) | |
| 16:20 | Documentation updates in preparation for the release of 3.3.3 stable. (CVS 3038) (check-in: 6537b571 user: drh tags: trunk) | |
| 15:34 | Expire all prepared statements whenever there is a change to the schema of the TEMP database. Ticket #1644. (CVS 3036) (check-in: 4cd4efaf user: drh tags: trunk) | |
| 14:36 | Fix bug with CHECK constraints contain an IN operator. Ticket #1645. (CVS 3035) (check-in: 944df310 user: drh tags: trunk) | |
|
2006-01-26
| ||
| 14:29 | Enhanced comments on the opcode.h building script. (CVS 3033) (check-in: 7ccebf68 user: drh tags: trunk) | |
|
2006-01-25
| ||
| 22:50 | Minor comment changes and code optimizations. (CVS 3029) (check-in: 9e55dcd1 user: drh tags: trunk) | |
| 15:55 | Rename files using for testing only so that their name begins with "test". (CVS 3028) (check-in: e4e6a205 user: drh tags: trunk) | |
|
2006-01-24
| ||
| 02:19 | Sqlite3_analyzer reports an error if it runs into trouble. (CVS 3021) (check-in: 388b9262 user: drh tags: trunk) | |
| 02:00 | Update the publish scripts to correctly build the TCL DLL for windows. (CVS 3020) (check-in: 5254874a user: drh tags: trunk) | |
| 00:40 | Version 3.3.2 (beta) (CVS 3019) (check-in: 1fdde6c5 user: drh tags: trunk) | |
| 00:15 | More test script changes to get it to run without -DSQLITE_MEMDEBUG. (CVS 3018) (check-in: 0ede5e49 user: drh tags: trunk) | |
|
2006-01-23
| ||
| 23:53 | Change the release date for version 3.3.2 to January 24. (CVS 3017) (check-in: 7a2617f6 user: drh tags: trunk) | |
| 23:49 | Disable shared-cache OOM tests if not compiled with -DSQLITE_MEMDEBUG. (CVS 3016) (check-in: 2d896667 user: drh tags: trunk) | |
| 22:15 | Bug fix in the WinCE bindings. (CVS 3015) (check-in: c5792283 user: drh tags: trunk) | |
| 21:44 | More progress toward getting SQLITE_OMIT_FLOATING_POINT to pass tests. Ticket #1621. (CVS 3014) (check-in: b52674e5 user: drh tags: trunk) | |
| 21:38 | Fix the shared pager tests so that they work under windows. (CVS 3013) (check-in: 4a1a9f3e user: drh tags: trunk) | |
| 21:37 | Progress toward getting SQLITE_OMIT_FLOATING_POINT to pass all tests. Ticket #1621 (CVS 3012) (check-in: c4c90965 user: drh tags: trunk) | |
| 18:42 | Bug fix in cases where a compound select has an ORDER BY clause with multiple terms. (CVS 3011) (check-in: 4f56949b user: drh tags: trunk) | |
| 18:14 | Add documentation on the IF NOT EXISTS clause to CREATE statements. Ticket #1608. (CVS 3010) (check-in: d4e4ba13 user: drh tags: trunk) | |
| 18:06 | Makefile changes so that builds work on Solaris. Ticket #1604. (CVS 3009) (check-in: 7addf704 user: drh tags: trunk) | |
| 17:43 | Bug fix in the ROWID generation logic of the VDBE. I think this is a benign bug - it never causes a real fault. But I am not certain. (CVS 3008) (check-in: dfe28238 user: drh tags: trunk) | |
| 16:25 | Get I/O error tests working on windows. (CVS 3007) (check-in: 2ef8b85d user: drh tags: trunk) | |
| 16:24 | Fix uninitialized variable in os_unix.c. (CVS 3006) (check-in: 892e644d user: drh tags: trunk) | |
| 15:59 | Changes to the enc2.test script so that it will run on windows. (CVS 3004) (check-in: 4c1818ec user: drh tags: trunk) | |
| 15:54 | Cut over the patches to support WinCE. Ticket #1600. (CVS 3003) (check-in: 436287c2 user: drh tags: trunk) | |
| 15:39 | Fix a bug in pager.c that was overwriting freed memory. Comment changes in util.c. (CVS 3002) (check-in: 8c7e18c3 user: drh tags: trunk) | |
| 14:05 | Fix os_common.h so that the code builds without -DSQLITE_MEMDEBUG. (CVS 3000) (check-in: 06d65400 user: drh tags: trunk) | |
| 13:28 | Fix to sqlite3AllocMalloc() when it is a no-op macro. (CVS 2998) (check-in: 8caa9f95 user: drh tags: trunk) | |
| 13:22 | Do not name variables "operator" because some compilers do not realize that "operator" is not a reserved word in ANSI-C. Ticket #1625. (CVS 2997) (check-in: 1f42a338 user: drh tags: trunk) | |
| 13:14 | Work around buggy malloc() implementations that cause problems on malloc(0). Ticket #1572. (CVS 2996) (check-in: ada5490f user: drh tags: trunk) | |
| 13:00 | Fix additional compiler warnings. Tickets #1615, #1616, #1627 (CVS 2994) (check-in: 6385628e user: drh tags: trunk) | |
| 00:04 | Remove vestiges of the older TSD code for handling OOM exceptions. Prepare for the release of 3.3.2. (CVS 2991) (check-in: a65e85f0 user: drh tags: trunk) | |
|
2006-01-22
| ||
| 21:52 | Performance optimization in btree.c. (CVS 2990) (check-in: 3e1e6aff user: drh tags: trunk) | |
| 00:42 | Code size reductions in select.c. (CVS 2989) (check-in: 3c2eee5e user: drh tags: trunk) | |
| 00:14 | Tests for the subquery flattening fix of check-in (2987). (CVS 2988) (check-in: 72a067f0 user: drh tags: trunk) | |
|
2006-01-21
| ||
| 22:19 | Do not flatten subqueries in a join where the subquery includes a LIMIT. Ticket #1634. This is just an initial fix. Many test cases need to be added prior to closing the ticket. (CVS 2987) (check-in: af18c0f4 user: drh tags: trunk) | |
| 19:57 | Fix a bug in os.h. How did this slip by before now? (CVS 2986) (check-in: 29725de4 user: drh tags: trunk) | |
|
2006-01-20
| ||
| 18:10 | More compiler warnings fixed - or in some cases comments are added to explain that the compiler is wrong. (CVS 2984) (check-in: 507653a9 user: drh tags: trunk) | |
| 17:56 | Fix some compiler warnings. (CVS 2983) (check-in: b7bdac0a user: drh tags: trunk) | |
| 15:45 | Fix and test the processing of sqlite3_result_error() withing aggregate functions. Allow errors to come from the step function (a new capability). Ticket #1632. (CVS 2981) (check-in: fd4a6bb1 user: drh tags: trunk) | |
|
2006-01-19
| ||
| 17:42 | Make sure sqlite3_thread_cleanup() does not try to allocate memory. (CVS 2979) (check-in: 0208e422 user: drh tags: trunk) | |
| 11:28 | Fix the #ifdef around sqlite3OutstandingMallocs() in test1.c. (CVS 2978) (check-in: 218c6184 user: drh tags: trunk) | |
|
2006-01-18
| ||
| 17:25 | Modify the sqlite3OsInMutex os-layer interface to take a single parameter to distinguish between mutexes held by the current thread and mutexes held by any thread. Part of the fix for ticket #1630. (CVS 2973) (check-in: e1ad9df1 user: drh tags: trunk) | |
| 14:20 | Recursive mutexes in os_win.c. (CVS 2969) (check-in: dd3e07ca user: drh tags: trunk) | |
| 14:06 | Convert the unix driver to use a recusive mutex. Similar changes to the windows driver are pending. (CVS 2968) (check-in: 8830bbba user: drh tags: trunk) | |
|
2006-01-16
| ||
| 02:39 | Version 3.3.1 (alpha) (CVS 2953) (check-in: bd7c5699 user: drh tags: trunk) | |
| 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) | |
| 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-13
| ||
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 12:03 | Back out the addition of the new header file - bad idea. (CVS 2868) (check-in: 0c4c45c3 user: drh 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) | |
|
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) | |
|
2006-01-03
| ||
| 15:16 | Always case 0 to (char*) on varargs functions. Otherwise there are problems on 64-bit machines. (CVS 2854) (check-in: 837dc77f user: drh tags: trunk) | |
| 00:33 | 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) (check-in: 70b22857 user: drh tags: trunk) | |
|
2006-01-02
| ||
| 20:00 | Add the xInMutex method to the os-layer switch for testing whether or not mutexes are used correctly. (CVS 2851) (check-in: a582b159 user: drh tags: trunk) | |
| 18:24 | Additional tests for descending indices. Comment changes. (CVS 2850) (check-in: 2622c524 user: drh tags: trunk) | |