Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
1178 check-ins using file src/hash.h version 1b0c445e1c
|
2006-02-13
| ||
| 18:42 | Disable the /./ and /../ collapser logic in sqlite3OsFullPathname under Unix. (CVS 3092) (check-in: 111a426b3e user: drh tags: trunk) | |
| 18:35 | Fix a bug in the handling of sqlite3OsTruncate by the test_async.c demo. Added trans.test to the suite of tests for asychronous I/O. (CVS 3091) (check-in: 5b16c43542 user: drh tags: trunk) | |
| 17:03 | Add in-process file locking to test_async.c. The unix implementation of sqlite3OsFullPathname() now attempts to remove /./ and /../ elements from the path. (CVS 3090) (check-in: 42379c6230 user: drh tags: trunk) | |
| 15:29 | Fix a deadlock problem on the sqlite3async_wait test interface. Improvements to tracing in test_async.c. (CVS 3089) (check-in: 58c6d50138 user: drh tags: trunk) | |
| 14:49 | Improvements to the TRACE macro in test_async.c. (CVS 3088) (check-in: 4c6dfec54f user: drh tags: trunk) | |
| 13:50 | I/O errors shut down all processing on the same file in test_async.c. (CVS 3087) (check-in: 4366e71217 user: drh tags: trunk) | |
| 13:30 | Fix overlapping read logic in the test_async.c demonstration. (CVS 3086) (check-in: ad25127b06 user: drh tags: trunk) | |
| 13:23 | Fix a memory leak in test_async.c. (CVS 3085) (check-in: 904ffa4dfb user: drh tags: trunk) | |
|
2006-02-11
| ||
| 17:34 | I give up. SUM() now throws an error on integer overflow. Those of us who think this is goofy can use TOTAL() instead. Tickets #1664, #1669, #1670, #1674. (CVS 3084) (check-in: 1c3e6002cd user: drh tags: trunk) | |
| 02:12 | Version 3.3.4 (CVS 3083) (check-in: 033aaab67f user: drh tags: trunk) | |
| 02:03 | Fix typo in os_unix.c. (CVS 3082) (check-in: c0e987bcfa user: drh tags: trunk) | |
| 01:56 | Prepare for the release of 3.3.4. (CVS 3081) (check-in: 951f3322c0 user: drh tags: trunk) | |
| 01:25 | Add support and documentation for the fullfsync pragma. Also include some other unrelated documentation updates. (CVS 3080) (check-in: f2069d0bf3 user: drh tags: trunk) | |
|
2006-02-10
| ||
| 18:08 | Make sure pointers are always aligned to 8-bytes when creating internal Index structures. (CVS 3079) (check-in: d20a33ac2a user: drh tags: trunk) | |
| 14:02 | Clean up pointer misuse in vdbe.c. (CVS 3078) (check-in: 9e82b92749 user: drh tags: trunk) | |
| 13:33 | Minor test file modifications for builds compiled with OMIT options. (CVS 3077) (check-in: c468aa349d user: danielk1977 tags: trunk) | |
| 13:14 | Add documentation for new APIs. (CVS 3076) (check-in: 84c2a5c4d7 user: danielk1977 tags: trunk) | |
| 13:11 | More comments on the unix locking code. Ticket #1672. (CVS 3075) (check-in: 4b6f568884 user: drh tags: trunk) | |
| 12:48 | Add trivial tests to increase coverage of sqlite3_table_column_metadata(). (CVS 3074) (check-in: 424ce5ecd0 user: danielk1977 tags: trunk) | |
| 08:24 | Work around the case where the pending-byte page is also a a pointer-map page. Ticket #1667. (CVS 3073) (check-in: 5ea87fbbe0 user: danielk1977 tags: trunk) | |
| 07:07 | Fix the origin APIs so that they correctly handle views and subqueries that cannot be flattened. (CVS 3072) (check-in: 5e8611e13d user: danielk1977 tags: trunk) | |
| 04:33 | Fix deadlock problem in the unix mutex. Ticket #1672. (CVS 3071) (check-in: a6c30be214 user: drh tags: trunk) | |
| 03:06 | Add a symbol P3_TRANSIENT to pass to VdbeSetColName() to make it copy the string parameter up to the first 0 byte. (CVS 3070) (check-in: 6ebb8f9bb2 user: danielk1977 tags: trunk) | |
| 02:27 | Add the column_origin_name() etc. APIs. (CVS 3069) (check-in: 82f502cdc1 user: danielk1977 tags: trunk) | |
|
2006-02-09
| ||
| 23:05 | Ignore errors when when calling fsync() on a directory. Ticket #1657. (CVS 3068) (check-in: d54d3b82c4 user: drh tags: trunk) | |
| 22:24 | Allow '@' to introduce host parameter names for compatibility with MS SQL Server. Ticket #1671. (CVS 3067) (check-in: 0738ef818d user: drh tags: trunk) | |
| 22:13 | SUM never gives an error. An integer result is returned for exact results and a floating point result is returned for approximate results. Tickets #1664, #1669, and #1670. (CVS 3066) (check-in: 9e04f8fdf1 user: drh tags: trunk) | |
| 18:35 | Deprecate the sqlite3_aggregate_count() API. Make sure all aggregate counters are 64 bits. Remove unused StdDev structure from func.c. Ticket #1669. (CVS 3065) (check-in: 44bd7ba432 user: drh tags: trunk) | |
| 17:47 | Integer overflow in SUM causes an exception. Ticket #1669. (CVS 3064) (check-in: c72b946198 user: drh tags: trunk) | |
| 16:52 | Back out check-in (3058) - it breaks too much application code. (CVS 3063) (check-in: 731f1e3245 user: drh tags: trunk) | |
| 13:43 | Add the sqlite3_table_column_meta() API. (CVS 3062) (check-in: 1ac72f68c0 user: danielk1977 tags: trunk) | |
| 13:38 | Avoid overflowing the 48-bit mantissa of a floating point number when summing large integers in the SUM() function. Ticket #1664. (CVS 3061) (check-in: a9169e879d user: drh tags: trunk) | |
| 02:56 | Correctly handle COLLATE clauses in tables being modified by an ALTER TABLE ADD COLUMN command. Ticket #1665. (CVS 3060) (check-in: baef2f66be user: drh tags: trunk) | |
| 02:41 | Use 64-bit integers in sqlite3_analyzer. Ticket #1666. (CVS 3059) (check-in: 8b3068aca7 user: drh tags: trunk) | |
|
2006-02-06
| ||
| 21:34 | Add "autoinc" and "collseq" columns to the table_info() pragma. (CVS 3058) (check-in: 7940a590ab user: drh tags: trunk) | |
| 21:22 | Keep correct track of the amount of outstanding memory even when the system memory allocator returns a different number of bytes than requested. Ticket #1660. (CVS 3057) (check-in: 6f5eb74fd9 user: drh tags: trunk) | |
| 13:59 | Update the per-thread bytes allocated counter with the number of bytes actually allocated, not the number requested. Ticket #1660. (CVS 3056) (check-in: 3f0a0ff197 user: danielk1977 tags: trunk) | |
|
2006-02-05
| ||
| 18:55 | Detect circularly defined views and issue an error message. Ticket #1658. (CVS 3055) (check-in: f5341529d0 user: drh tags: trunk) | |
|
2006-02-01
| ||
| 14:39 | Typecast to silence (incorrect) compiler warning. (CVS 3054) (check-in: 3a04fc45cc user: drh tags: trunk) | |
| 13:50 | Always register BINARY collating sequences for UTF-16BE and UTF-16LE both. Formerly we were only registering the native byte order by default. Ticket #1654. Note: There may still be problems with collating sequence synthesis. (CVS 3053) (check-in: 3861377bd9 user: drh tags: trunk) | |
| 02:45 | In joins of the form: "A, B left C" make sure that the reordering optimization does not put table A after table C. Ticket #1652. (CVS 3052) (check-in: 248b9be93d user: drh tags: trunk) | |
| 01:55 | Added support for the -enable-thread-override-lock option on the configure script. (CVS 3051) (check-in: 82f558bd11 user: drh tags: trunk) | |
|
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: e83a19e8cb user: drh tags: trunk) | |
| 20:49 | Patches to support linux on embedded platforms. (CVS 3049) (check-in: a088eb6d6e user: drh tags: trunk) | |
| 19:31 | Fix some pointless warnings from overly-pedantic compilers. (CVS 3048) (check-in: b922c8e45f 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: 1e68ac590d user: drh tags: trunk) | |
| 16:21 | Version 3.3.3 (CVS 3046) (check-in: 10a3f56546 user: drh tags: trunk) | |
| 16:20 | Put in the correct release date for version 3.3.3. (CVS 3045) (check-in: 1133a84039 user: drh tags: trunk) | |
| 15:19 | Fix an problem in the test scripts that was show false failures under windows. (CVS 3044) (check-in: 0cf4e3c6e7 user: drh tags: trunk) | |
| 14:28 | Authorization callback on the ALTER TABLE ADD COLUMN command. Ticket #1479. (CVS 3043) (check-in: 461f586973 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: 669bcf5ab6 user: drh tags: trunk) | |
| 22:48 | Memory DB works with autovacuum. (CVS 3041) (check-in: 34dff874a2 user: drh tags: trunk) | |
| 22:35 | Make sure the 3rd parameter to sqlite3_prepare() is honored. Ticket #1650. (CVS 3040) (check-in: 9d53cc880f 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: 8efc8c5710 user: drh tags: trunk) | |
| 16:20 | Documentation updates in preparation for the release of 3.3.3 stable. (CVS 3038) (check-in: 6537b5713a user: drh tags: trunk) | |
| 15:41 | Add a couple of extra test cases for #1644. (CVS 3037) (check-in: e10d229ff2 user: danielk1977 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: 4cd4efaf5e user: drh tags: trunk) | |
| 14:36 | Fix bug with CHECK constraints contain an IN operator. Ticket #1645. (CVS 3035) (check-in: 944df310ce user: drh tags: trunk) | |
|
2006-01-27
| ||
| 06:32 | Fix a couple of (harmless) intel compiler warnings. (CVS 3034) (check-in: 2e23231f0c user: danielk1977 tags: trunk) | |
|
2006-01-26
| ||
| 14:29 | Enhanced comments on the opcode.h building script. (CVS 3033) (check-in: 7ccebf68eb user: drh tags: trunk) | |
| 13:25 | Fix an error in the collation sequence examples in datatype3.html. Ticket #1641. (CVS 3032) (check-in: 1658ea53c9 user: danielk1977 tags: trunk) | |
| 13:11 | Add omittest.tcl script to automate testing compile-time OMIT symbols. (CVS 3031) (check-in: 540d28a7d3 user: danielk1977 tags: trunk) | |
| 10:35 | Handle a malloc() failure in resizeOpArray(). (CVS 3030) (check-in: 5cecb4527b user: danielk1977 tags: trunk) | |
|
2006-01-25
| ||
| 22:50 | Minor comment changes and code optimizations. (CVS 3029) (check-in: 9e55dcd1a5 user: drh tags: trunk) | |
| 15:55 | Rename files using for testing only so that their name begins with "test". (CVS 3028) (check-in: e4e6a205e4 user: drh tags: trunk) | |
|
2006-01-24
| ||
| 16:37 | Handle errors in saving cursor positions during a rollback by aborting all active statements. (CVS 3027) (check-in: 5df9f022bf user: danielk1977 tags: trunk) | |
| 14:21 | Save the position of any open cursors before a rollback. (CVS 3026) (check-in: 32d45bcf74 user: danielk1977 tags: trunk) | |
| 13:09 | Return code was being dropped because of overridden variable in OP_IsUnique. Fix this and the test logic problem that hid it. (CVS 3025) (check-in: c30705a00d user: danielk1977 tags: trunk) | |
| 12:09 | Rename some variables to avoid hiding others. Also add "static" to two function signatures that were missing it. (CVS 3024) (check-in: d86f18a427 user: danielk1977 tags: trunk) | |
| 11:30 | Coverage improvements for main.c. (CVS 3023) (check-in: 50964ef9b0 user: danielk1977 tags: trunk) | |
| 10:58 | General test coverage improvements. (CVS 3022) (check-in: 153940af5a user: danielk1977 tags: trunk) | |
| 02:19 | Sqlite3_analyzer reports an error if it runs into trouble. (CVS 3021) (check-in: 388b926228 user: drh tags: trunk) | |
| 02:00 | Update the publish scripts to correctly build the TCL DLL for windows. (CVS 3020) (check-in: 5254874a96 user: drh tags: trunk) | |
| 00:40 | Version 3.3.2 (beta) (CVS 3019) (check-in: 1fdde6c506 user: drh tags: trunk) | |
| 00:15 | More test script changes to get it to run without -DSQLITE_MEMDEBUG. (CVS 3018) (check-in: 0ede5e496b 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: 7a2617f6a5 user: drh tags: trunk) | |
| 23:49 | Disable shared-cache OOM tests if not compiled with -DSQLITE_MEMDEBUG. (CVS 3016) (check-in: 2d896667e4 user: drh tags: trunk) | |
| 22:15 | Bug fix in the WinCE bindings. (CVS 3015) (check-in: c57922838a user: drh tags: trunk) | |
| 21:44 | More progress toward getting SQLITE_OMIT_FLOATING_POINT to pass tests. Ticket #1621. (CVS 3014) (check-in: b52674e564 user: drh tags: trunk) | |
| 21:38 | Fix the shared pager tests so that they work under windows. (CVS 3013) (check-in: 4a1a9f3e9d user: drh tags: trunk) | |
| 21:37 | Progress toward getting SQLITE_OMIT_FLOATING_POINT to pass all tests. Ticket #1621 (CVS 3012) (check-in: c4c90965c9 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: 4f56949bd6 user: drh tags: trunk) | |
| 18:14 | Add documentation on the IF NOT EXISTS clause to CREATE statements. Ticket #1608. (CVS 3010) (check-in: d4e4ba132a user: drh tags: trunk) | |
| 18:06 | Makefile changes so that builds work on Solaris. Ticket #1604. (CVS 3009) (check-in: 7addf70445 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: dfe2823868 user: drh tags: trunk) | |
| 16:25 | Get I/O error tests working on windows. (CVS 3007) (check-in: 2ef8b85db7 user: drh tags: trunk) | |
| 16:24 | Fix uninitialized variable in os_unix.c. (CVS 3006) (check-in: 892e644d20 user: drh tags: trunk) | |
| 16:21 | Add "#ifndef NDEBUG" around sqlite3pager_iswriteable() (only used in assert() expressions). Also set the internal page number of a page to zero if it fails to initialise. (CVS 3005) (check-in: 77969c671c user: danielk1977 tags: trunk) | |
| 15:59 | Changes to the enc2.test script so that it will run on windows. (CVS 3004) (check-in: 4c1818eceb user: drh tags: trunk) | |
| 15:54 | Cut over the patches to support WinCE. Ticket #1600. (CVS 3003) (check-in: 436287c2bf 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: 8c7e18c3f2 user: drh tags: trunk) | |
| 15:25 | Further coverage improvements for pager.c and another IO error bug fix. (CVS 3001) (check-in: a9ec5ee472 user: danielk1977 tags: trunk) | |
| 14:05 | Fix os_common.h so that the code builds without -DSQLITE_MEMDEBUG. (CVS 3000) (check-in: 06d6540026 user: drh tags: trunk) | |
| 13:47 | Do not automatically rollback at the btree or pager level if a commit fails. (CVS 2999) (check-in: 0f6329ef1f user: danielk1977 tags: trunk) | |
| 13:28 | Fix to sqlite3AllocMalloc() when it is a no-op macro. (CVS 2998) (check-in: 8caa9f95b8 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: 1f42a338e2 user: drh tags: trunk) | |
| 13:14 | Work around buggy malloc() implementations that cause problems on malloc(0). Ticket #1572. (CVS 2996) (check-in: ada5490f12 user: drh tags: trunk) | |
| 13:09 | Improve coverage of pager.c and fix an IO error handling bug found in the process. (CVS 2995) (check-in: 6ec8e6b785 user: danielk1977 tags: trunk) | |
| 13:00 | Fix additional compiler warnings. Tickets #1615, #1616, #1627 (CVS 2994) (check-in: 6385628edd user: drh tags: trunk) | |
| 07:52 | Fixes for OMIT_UTF16 and OMIT_COMPOUND (CVS 2993) (check-in: f58bbdc0ac user: danielk1977 tags: trunk) | |
| 05:50 | Improve coverage of expr.c and btree.c slightly. (CVS 2992) (check-in: cc2e8e87cf user: danielk1977 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: a65e85f0e0 user: drh tags: trunk) | |
|
2006-01-22
| ||
| 21:52 | Performance optimization in btree.c. (CVS 2990) (check-in: 3e1e6affe2 user: drh tags: trunk) | |
| 00:42 | Code size reductions in select.c. (CVS 2989) (check-in: 3c2eee5e1f user: drh tags: trunk) | |
| 00:14 | Tests for the subquery flattening fix of check-in (2987). (CVS 2988) (check-in: 72a067f0df 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: af18c0f431 user: drh tags: trunk) | |
| 19:57 | Fix a bug in os.h. How did this slip by before now? (CVS 2986) (check-in: 29725de474 user: drh tags: trunk) | |
| 12:08 | Fix more problems with malloc() and IO failures. (CVS 2985) (check-in: 29281dea81 user: danielk1977 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: 507653a98c user: drh tags: trunk) | |
| 17:56 | Fix some compiler warnings. (CVS 2983) (check-in: b7bdac0afd user: drh tags: trunk) | |
| 16:32 | Fix another couple of IO or malloc() failure problems in a shared-cache context. (CVS 2982) (check-in: 7e34163a65 user: danielk1977 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: fd4a6bb1ac user: drh tags: trunk) | |
| 10:55 | Handle some of the IO error conditions that may occur in a shared-cache context. (CVS 2980) (check-in: 97491d4eb5 user: danielk1977 tags: trunk) | |
|
2006-01-19
| ||
| 17:42 | Make sure sqlite3_thread_cleanup() does not try to allocate memory. (CVS 2979) (check-in: 0208e4221a user: drh tags: trunk) | |
| 11:28 | Fix the #ifdef around sqlite3OutstandingMallocs() in test1.c. (CVS 2978) (check-in: 218c6184c8 user: drh tags: trunk) | |
| 08:43 | Account for read-uncommitted cursors in sqlite3BtreeClearTable(). (CVS 2977) (check-in: 9507983268 user: danielk1977 tags: trunk) | |
| 07:18 | Fix a bug with internally saving cursors open on index tables. Also increase coverage of util.c and btree.c. (CVS 2976) (check-in: a628d84d31 user: danielk1977 tags: trunk) | |
|
2006-01-18
| ||
| 18:33 | Omit thread2.test if memory-management is enabled at compile time. (CVS 2975) (check-in: df91f685ca user: danielk1977 tags: trunk) | |
| 18:22 | Include the ThreadData structure in internal malloc() testing. Also fixes for revealed bugs. (CVS 2974) (check-in: c7b9d50d0a user: danielk1977 tags: trunk) | |
| 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: e1ad9df1cf user: drh tags: trunk) | |
| 16:51 | Use a global variable protected by a mutex instead of thread-specific-data to record malloc() failures. (CVS 2972) (check-in: ac090f2ab3 user: danielk1977 tags: trunk) | |
| 15:39 | Fix compilation error when neither MEMDEBUG or ENABLE_MEMORY_MANAGEMENT is enabled. (CVS 2971) (check-in: 4de5c52920 user: danielk1977 tags: trunk) | |
| 15:25 | Change sqlite3MallocClearFailed() calls to sqlite3ApiExit(), a better API. (CVS 2970) (check-in: e0b022e5b2 user: danielk1977 tags: trunk) | |
| 14:20 | Recursive mutexes in os_win.c. (CVS 2969) (check-in: dd3e07cae4 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: 8830bbbac8 user: drh tags: trunk) | |
| 05:51 | Handle malloc() failures that occur in open16() and errmsg16(). (CVS 2967) (check-in: 86eab9e53d user: danielk1977 tags: trunk) | |
| 04:26 | Handle malloc() failures that occur inside create_collation() calls. (CVS 2966) (check-in: 95c5903f36 user: danielk1977 tags: trunk) | |
|
2006-01-17
| ||
| 16:10 | Arrange for ThreadData to be automatically deallocated even if SQLITE_MEMDEBUG is defined. Fix for #1623. (CVS 2965) (check-in: 9e2e40845d user: danielk1977 tags: trunk) | |
| 15:36 | Fix compilation errors when building SQLITE_DEBUG defined but without SQLITE_MEMDEBUG. (CVS 2964) (check-in: 62dd242778 user: danielk1977 tags: trunk) | |
| 13:21 | Various fixes that allow the malloc() failure tests to pass again. (CVS 2963) (check-in: 0505405fb9 user: danielk1977 tags: trunk) | |
| 09:35 | Test suite fixes for builds that define OMIT symbols. (CVS 2962) (check-in: 3a54a33dcb user: danielk1977 tags: trunk) | |
|
2006-01-16
| ||
| 16:24 | Test file fixes for libaries compiled with various SQLITE_OMIT_ macros. (CVS 2961) (check-in: c058f483a5 user: danielk1977 tags: trunk) | |
| 15:32 | Fix problems compiling with memory-management enabled. Ticket #1619. (CVS 2960) (check-in: 36b0325965 user: danielk1977 tags: trunk) | |
| 15:14 | Fix some of the issues raised in #1615. (CVS 2959) (check-in: 0d5d83bcbd user: danielk1977 tags: trunk) | |
| 14:29 | Correctly handle malloc() failure in GenericMalloc() and GenericRealloc(). Fix for #1617. (CVS 2958) (check-in: 9dfc4a880b user: danielk1977 tags: trunk) | |
| 12:46 | Run the tests in shared.test a second time using an autovacuum database. (CVS 2957) (check-in: 9927522923 user: danielk1977 tags: trunk) | |
| 11:29 | Clarify error handling in pager code. No functional changes. (CVS 2956) (check-in: 7b48836214 user: danielk1977 tags: trunk) | |
| 02:39 | Version 3.3.1 (alpha) (CVS 2953) (check-in: bd7c569993 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: 6591d365d4 user: drh tags: trunk) | |
| 00:05 | Version 3.3.1 (withdrawn - see ticket #1614) (CVS 2955) (check-in: ed0f1d9086 user: drh tags: trunk) | |
|
2006-01-15
| ||
| 20:28 | Code size reductions in the pager. (CVS 2952) (check-in: c7da3aa9bd user: drh tags: trunk) | |
| 18:29 | Prepare for the 3.3.1 alpha release. (CVS 2951) (check-in: 3e32bcf0b8 user: drh tags: trunk) | |
| 17:27 | Clean up comments in os_unix.c. (CVS 2950) (check-in: 2170e803ad 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: 69f996e0fa user: danielk1977 tags: trunk) | |
| 13:13 | Fix a buffer-overrun that could occur after a malloc() failure. (CVS 2948) (check-in: 662522218f user: danielk1977 tags: trunk) | |
| 11:39 | Rollback any open write-transaction when a shared-cache connection is closed. (CVS 2947) (check-in: 1944d92b53 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: ad8f12cad1 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: f68e05cb2b 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: 03c422ecb5 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: 8e79a0c24a 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: d634f8b28a user: danielk1977 tags: trunk) | |
| 17:12 | Tweaks to make OP_Column run a fraction faster. (CVS 2941) (check-in: 2d74cc22de user: danielk1977 tags: trunk) | |
| 15:58 | Avoid parsing an entire record header when it is not required. (CVS 2940) (check-in: 0de729d914 user: danielk1977 tags: trunk) | |
| 13:55 | Make sure the authenticator does not try to authenticate columns in subqueries. Ticket #1607. (CVS 2939) (check-in: 55b7dfaf4d user: drh tags: trunk) | |
| 13:01 | Fix a vdbe stack overflow problem that could occur with a correlated sub-query. (CVS 2938) (check-in: caa7da807d user: danielk1977 tags: trunk) | |
| 11:22 | Remove a few duplicate variable initializations in sqlite3BtreeCursor(). (CVS 2937) (check-in: 5e46ec01ff 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: dd70595542 user: danielk1977 tags: trunk) | |
| 04:31 | Additional speed enhancements in btree.c. (CVS 2935) (check-in: 48b550ce2e user: drh tags: trunk) | |
| 02:35 | Small performance improvement on sqlite3BtreeMoveto. (CVS 2934) (check-in: c780152f3c 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: a64e8251a6 user: drh tags: trunk) | |
| 01:25 | Add tests to make sure "PRAGMA table_info" works using sqlite3_prepare16. Ticket #1606. (CVS 2932) (check-in: ace8ba8177 user: drh tags: trunk) | |
| 01:17 | Terminate the va_start in the getDigits function of date.c. (CVS 2931) (check-in: 94eac140f2 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: a7f528ff34 user: drh tags: trunk) | |
| 20:28 | Performance boost in sqlite3VdbeRecordCompare. (CVS 2929) (check-in: 14c423075b 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: 730ddb0b74 user: drh tags: trunk) | |
| 17:20 | Cache the encoding value inside VdbeExec. (CVS 2927) (check-in: 6d2a816ede user: drh tags: trunk) | |
| 15:01 | Additional performance improvements in sqlite3BtreeMoveto. (CVS 2926) (check-in: 52b3be96b6 user: drh tags: trunk) | |
| 14:30 | BtreeMoveto optimization goes about 1.5% faster. (CVS 2925) (check-in: 4e4a650484 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: 0caa199477 user: drh tags: trunk) | |
| 02:50 | Mark the end of the return codes in the sqlite3.h.in template file. (CVS 2923) (check-in: 19b848d99f user: drh tags: trunk) | |
| 01:56 | Add the legacy_file_format pragma. (CVS 2922) (check-in: b2dbd1a5b7 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: a8c74febec 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: fb518b0ce4 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: 5d9c6aa964 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: 8c26893c65 user: danielk1977 tags: trunk) | |
| 14:09 | Fix bugs caused by assuming that shared-schemas are initialized. (CVS 2917) (check-in: 3970eb875d user: danielk1977 tags: trunk) | |
| 05:49 | Fix typo noted by #1599. (CVS 2916) (check-in: 1b368c7c5c user: danielk1977 tags: trunk) | |
| 01:28 | Version 3.3.0 (alpha) (CVS 2915) (check-in: 59a7a56c1b user: drh tags: trunk) | |
| 01:28 | Add new APIs to the sqlite3.def file. (CVS 2914) (check-in: 9258931a80 user: drh tags: trunk) | |
| 01:08 | Prepare for the release of version 3.3.0. (CVS 2913) (check-in: 302993ae16 user: drh tags: trunk) | |
|
2006-01-10
| ||
| 23:00 | Fix a typo in the FAQ. (CVS 2912) (check-in: 5be03a361d user: drh tags: trunk) | |
| 20:36 | Fix bug in the server1 test script. (CVS 2911) (check-in: 25db22b671 user: drh tags: trunk) | |
| 20:32 | Combine multiple small calls to sqlite3OsWrite into one larger call. (CVS 2910) (check-in: e6e6750c24 user: drh tags: trunk) | |
| 20:01 | Improved comments on the server and asynchronous I/O demo programs. (CVS 2909) (check-in: c0f47ccbc9 user: drh tags: trunk) | |
| 19:45 | More pedantic changes to comments in VDBE. No changes to code. Ticket #1596. (CVS 2908) (check-in: 1cf6855430 user: drh tags: trunk) | |
| 18:44 | Fix opcode name in comments. No changes to code. (CVS 2907) (check-in: 511ac9db12 user: drh tags: trunk) | |
| 18:27 | Initialize variables in malloc3.test (was causing error in all.test). (CVS 2906) (check-in: 16a8172a61 user: danielk1977 tags: trunk) | |
| 18:08 | Typos in new documentation. (CVS 2905) (check-in: b5bedb2a9f user: danielk1977 tags: trunk) | |
| 17:58 | Store collation sequence names instead of pointers in sharable schema data structures. (CVS 2904) (check-in: 0f0213be4d 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: bdd35e9fbb user: drh tags: trunk) | |
| 13:58 | Move the implementation of sqlite3_enable_shared_cache from btree.c to main.c. (CVS 2902) (check-in: 4f2ec95283 user: drh tags: trunk) | |
| 12:31 | Fix a problem with shared-schemas and temp triggers. (CVS 2901) (check-in: 9c18a1ce1e 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: bd02a6faef user: danielk1977 tags: trunk) | |
| 02:30 | Enable shared cache on the server demonstration. (CVS 2899) (check-in: 8719f880a3 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: 66f84068f3 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: ec332d8822 user: drh tags: trunk) | |
| 17:29 | Reinstate the asynchronous I/O demonstration code and tests with minor changes. (CVS 2896) (check-in: eeebc640aa 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: 3e75d3d5ef user: danielk1977 tags: trunk) | |
| 09:59 | Add a runtime interface to enable memory-management features. (CVS 2894) (check-in: 44f8e3139a user: danielk1977 tags: trunk) | |
| 06:29 | Rename DbSchema to "Schema" and SqliteTsd to "ThreadData". (CVS 2893) (check-in: 82b81f69c7 user: danielk1977 tags: trunk) | |
| 05:36 | Minor changes so that OMIT_SHARED_CACHE works. (CVS 2892) (check-in: cc963f8cfc user: danielk1977 tags: trunk) | |
| 00:18 | Fix timezone parsing in the date/time functions. Ticket #1587. (CVS 2891) (check-in: 94c87b7016 user: drh tags: trunk) | |
| 00:09 | Remove benign reference to an uninitialized variable. Ticket #1590. (CVS 2890) (check-in: 32998fe8ed 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: b2ac0be07e user: drh tags: trunk) | |
| 05:26 | Remove some cruft from the VDBE. Bring comments up to date. (CVS 2888) (check-in: 41aef6496a user: drh tags: trunk) | |
| 05:02 | Reduce memory requirements for ORDER BY combined with LIMIT. Ticket #1586. (CVS 2887) (check-in: 55e703ecac 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: 0ae461313c user: drh tags: trunk) | |
| 18:14 | Continued progress toward a working wince backend. (CVS 2885) (check-in: 15fda14ee0 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: 19f71a6d19 user: drh tags: trunk) | |
| 16:06 | Enable redefinable I/O if the SQLITE_ENABLE_REDEF_IO macro exists. (CVS 2883) (check-in: e170e15766 user: drh tags: trunk) | |
| 14:02 | Fix some memory leaks caused by obscure syntax errors in SQL. (CVS 2882) (check-in: 6593199a4d 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: 23b587b05b user: danielk1977 tags: trunk) | |
| 04:06 | Drop the mutex if the TSD key allocation fails. Ticket #1585. (CVS 2880) (check-in: 77ac231c0e user: drh tags: trunk) | |
|
2006-01-06
| ||
| 22:11 | Fix bugs in test scripts that came of of sse testing. (CVS 2879) (check-in: 22bf1a2ffa user: drh tags: trunk) | |
| 21:52 | Changes so that SQLITE_OMIT_PARSER and SQLITE_OMIT_DISKIO work. (CVS 2878) (check-in: 9d71b7deaf user: drh tags: trunk) | |
| 21:09 | Additional changes for wince. (CVS 2877) (check-in: b10343d916 user: drh tags: trunk) | |
| 20:40 | More changes to support wince. (CVS 2876) (check-in: f3cbd995c8 user: drh tags: trunk) | |
| 20:22 | Additional efforts to get it to build on WinCE. (CVS 2875) (check-in: b45c076f0d user: drh tags: trunk) | |
| 16:17 | A first attempt at adding native support for WinCE. (CVS 2874) (check-in: 4344056787 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: 19f93e135f user: danielk1977 tags: trunk) | |
| 14:46 | Fix an alignment problem in the sqlite3OsRandomSeed(). Ticket #1584. (CVS 2872) (check-in: 373b56f004 user: drh tags: trunk) | |
| 14:41 | Remove vestigial file: crashtest1.c (CVS 2871) (check-in: 6676c7031d 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: 2529c2e11f user: drh tags: trunk) | |
| 13:00 | Add some simple tests and fixes for shared-schema locking. (CVS 2869) (check-in: d054bed15a user: danielk1977 tags: trunk) | |
| 12:03 | Back out the addition of the new header file - bad idea. (CVS 2868) (check-in: 0c4c45c36f user: drh tags: trunk) | |
| 06:33 | Fix a bug that was emptying shared-schema tables during an ATTACH. (CVS 2867) (check-in: 752a275487 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: b8332aa8b8 user: drh tags: trunk) | |
| 01:42 | Formatting changes in btree.c. (CVS 2865) (check-in: f1922da2d2 user: drh tags: trunk) | |
| 00:36 | Windows implementation of the thread-specific data interface. (CVS 2864) (check-in: 3aa8befedf user: drh tags: trunk) | |
|
2006-01-05
| ||
| 23:42 | Disable the update hook for the truncation optimization used by DELETE. (CVS 2863) (check-in: 448b3b9ded 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: 98194a45cc 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: 5dec3a392b 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: 6fdbb8b771 user: danielk1977 tags: trunk) | |
| 11:34 | Add the shared schema/pager modifications. Very few tests so far. (CVS 2859) (check-in: deeda0dc06 user: danielk1977 tags: trunk) | |
|
2006-01-04
| ||
| 21:40 | Bug fix in the IF NOT EXISTS logic. (CVS 2858) (check-in: cb9095ac52 user: drh tags: trunk) | |
| 18:13 | Bug fix in the new "exists" method of the TCL interface. (CVS 2857) (check-in: d0e3d46609 user: drh tags: trunk) | |
| 15:58 | Update document for CREATE INDEX IF NOT EXISTS and DROP INDEX IF EXISTS (CVS 2856) (check-in: 963ba8b8f3 user: drh tags: trunk) | |
| 15:54 | Add support for CREATE INDEX IF NOT EXISTS and DROP INDEX IF EXISTS. (CVS 2855) (check-in: 551cdd6c30 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: 837dc77ff9 user: drh tags: trunk) | |
| 13:39 | Add test files for the asynchronous IO concept. (CVS 2853) (check-in: 7c3492c840 user: danielk1977 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: 70b228575e 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: a582b15959 user: drh tags: trunk) | |
| 18:24 | Additional tests for descending indices. Comment changes. (CVS 2850) (check-in: 2622c5242b user: drh tags: trunk) | |
|
2005-12-30
| ||
| 16:31 | Repair typo in previous commit. (CVS 2849) (check-in: a4aa0911bc user: danielk1977 tags: trunk) | |
| 16:28 | Add part of the btree layer of the shared-cache feature. (CVS 2848) (check-in: 2afcad9901 user: danielk1977 tags: trunk) | |
|
2005-12-29
| ||
| 23:33 | Add support for CREATE TABLE IF NOT EXISTS. (CVS 2847) (check-in: 0bd9e35fd2 user: drh tags: trunk) | |
| 23:04 | Bug fix in codec processing. (CVS 2846) (check-in: a88580bce0 user: drh tags: trunk) | |
| 19:23 | 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) (check-in: ae301db8a6 user: drh tags: trunk) | |
| 12:53 | Fix for ticket #1575. (CVS 2844) (check-in: 1586921b54 user: drh tags: trunk) | |
| 01:11 | Add support for DROP TABLE IF EXISTS. (CVS 2843) (check-in: a4c547de83 user: drh tags: trunk) | |
|
2005-12-22
| ||
| 13:47 | Make genericAllocationSize work on NULL pointers. (CVS 2842) (check-in: 326fc9cc11 user: drh tags: trunk) | |
|
2005-12-21
| ||
| 18:36 | Bug fixes and additional testing of descending indices. (CVS 2841) (check-in: 5638a11ed5 user: drh tags: trunk) | |
| 14:43 | Basic functionality for descending indices is in place. Lots more testing needed. (CVS 2840) (check-in: 7064433e5b user: drh tags: trunk) | |
| 03:16 | Progress toward decending indices. (CVS 2839) (check-in: 112a34b8dc user: drh tags: trunk) | |
|
2005-12-20
| ||
| 14:38 | Include sqlite3_release_memory() code when SQLITE_MEMDEBUG is not defined. (CVS 2838) (check-in: 77a37ceca7 user: danielk1977 tags: trunk) | |
| 09:19 | Add simple tests and fixes for sqlite3_soft_heap_limit() (CVS 2837) (check-in: c2c5285442 user: danielk1977 tags: trunk) | |
|
2005-12-19
| ||
| 17:53 | Website changes in preparation for the release of 2.8.17. (CVS 2834) (check-in: a927696ba3 user: drh tags: trunk) | |
| 17:27 | Version 3.2.8 (CVS 2835) (Leaf check-in: e61382aed4 user: drh tags: branch_3_2) | |
| 17:26 | Website changes for the release of 3.2.8. (CVS 2831) (check-in: 2f7ec117de user: drh tags: trunk) | |
| 16:34 | Bump the version number on the 3.2 branch to 3.2.8. (CVS 2830) (check-in: d8e74af5b0 user: drh tags: branch_3_2) | |
| 16:29 | Backport the fix for ticket #1567 into the 3.2 branch. (CVS 2829) (check-in: 3339774228 user: drh tags: branch_3_2) | |
| 16:15 | 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) (check-in: e6106cc133 user: drh tags: trunk) | |
| 14:18 | Add some very simple test cases (and resulting bug fixes) for release_memory(). (CVS 2826) (check-in: 154282fca5 user: danielk1977 tags: trunk) | |
|
2005-12-18
| ||
| 08:51 | Add the (untested) sqlite3_release_memory() function. (CVS 2825) (check-in: 345addaa03 user: danielk1977 tags: trunk) | |
|
2005-12-16
| ||
| 15:24 | Verify that the rollback-hook is invoked correctly when a malloc() failure occurs. (CVS 2824) (check-in: 83c8ae5bee user: danielk1977 tags: trunk) | |
| 06:54 | Add the sqlite3_rollback_hook() API. Still requires further testing. (CVS 2823) (check-in: 3baa3ff324 user: danielk1977 tags: trunk) | |
| 01:06 | Initial infrastructure for recognizing DESC indices and being able to read and write older databases that specify DESC indices but do not really use them. Nothing is close to working yet. (CVS 2822) (check-in: cd110aa225 user: drh tags: trunk) | |
|
2005-12-15
| ||
| 22:34 | Fix the utf8 to utf16 conversion routine for short strings. Bug introduced by check-in (2817). (CVS 2821) (check-in: 4fba2db38e user: drh tags: trunk) | |
| 15:22 | Add the sqlite3_update_hook() API. (CVS 2820) (check-in: 3622901881 user: danielk1977 tags: trunk) | |
| 10:50 | Move malloc(), free(), realloc() and allocationSize() into the Os vtbl. (CVS 2819) (check-in: 81a41f6637 user: danielk1977 tags: trunk) | |
| 10:11 | Add the sqlite3_os_routine_set()/get() functions. (CVS 2818) (check-in: c1ed79f594 user: danielk1977 tags: trunk) | |
| 03:04 | Fix memory allocation problems on the utf-16 versions of collating function control routines. (CVS 2817) (check-in: ad292e2733 user: drh tags: trunk) | |
|
2005-12-14
| ||
| 22:51 | Avoid using the transient value in the UTF-16 collation needed callback. (CVS 2816) (check-in: ab6241af29 user: drh tags: trunk) | |
| 20:11 | Properly zero-terminate UTF-16 collation names on an sqlite3_collation_needed16 callback. (CVS 2815) (check-in: 71a49d05bf user: drh tags: trunk) | |
|
2005-12-12
| ||
| 06:53 | Fix minor malloc() related problems and add sqlite3_soft_heap_limit() stubs. (CVS 2814) (check-in: 1637f37960 user: danielk1977 tags: trunk) | |
|
2005-12-10
| ||
| 21:19 | Add the "exists" method to the TCL interface. (CVS 2813) (check-in: 8a355d7aad user: drh tags: trunk) | |
|
2005-12-09
| ||
| 20:54 | New bind tests (check-ins (2797) and (2798)) only work right on a UTF8 database. So make sure they are only run when the database is UTF8. (CVS 2812) (check-in: 3980379069 user: drh tags: trunk) | |
| 20:21 | More annoying and pointless signedness warnings fixed. (CVS 2811) (check-in: 590578bef8 user: drh tags: trunk) | |
| 20:02 | Clean up annoying (and pointless) compiler warnings about differing signedness. (CVS 2810) (check-in: 83a5915155 user: drh tags: trunk) | |
| 14:39 | Define the sqliteMalloc() macro differently to avoid a compiler warning. (CVS 2809) (check-in: 3d177bde71 user: danielk1977 tags: trunk) | |
| 14:25 | Many small changes to ensure memory is not leaked after malloc() fails. (CVS 2808) (check-in: 601c335463 user: danielk1977 tags: trunk) | |
| 02:35 | Add more stress testing to autovacuum in an (unsuccessful) attempt to reproduce a reported problem. Even though these tests did not uncover anything amiss, extra tests never hurt... (CVS 2807) (check-in: d8a8933ff3 user: drh tags: trunk) | |
|
2005-12-08
| ||
| 18:12 | Provide a pragma to set the codec key. (CVS 2806) (check-in: a7c9e8989c user: drh tags: trunk) | |
|
2005-12-07
| ||
| 06:27 | Add some tests for malloc() failure within the column_name() and column_decl() APIs. (CVS 2805) (check-in: 78f10ca0a6 user: danielk1977 tags: trunk) | |
|
2005-12-06
| ||
| 17:48 | Allow VACUUM to detach the auxillary database after malloc() fails. (CVS 2804) (check-in: 6824a78bc7 user: danielk1977 tags: trunk) | |
| 17:19 | Modify ATTACH and DETACH to execute at runtime instead of compile time. (CVS 2803) (check-in: 5e04ec694a user: danielk1977 tags: trunk) | |
| 13:19 | Report errors out of sqlite3_open16(). (CVS 2802) (check-in: f5b58163d4 user: drh tags: trunk) | |
| 12:57 | Add test file for new malloc() failure handling. (CVS 2801) (check-in: 0b82f9623c user: danielk1977 tags: trunk) | |
| 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) (check-in: e1606658f1 user: danielk1977 tags: trunk) | |
|
2005-12-05
| ||
| 22:22 | Update mailing list hyperlink on the support page. (CVS 2799) (check-in: 41a7aeeeb4 user: drh tags: trunk) | |
| 13:20 | Make sure sqlite3_result_text can handle text strings with embedded '\000' characters. (CVS 2798) (check-in: 9d6057cd14 user: drh tags: trunk) | |
|
2005-12-02
| ||
| 02:44 | Add a test to verify that binding text with embedded '\000' works. Also comment changes in os.h. (CVS 2797) (check-in: 31251a9098 user: drh tags: trunk) | |
| 01:57 | Documentation updates. (CVS 2796) (check-in: 2ffb90c39d user: drh tags: trunk) | |
|
2005-11-30
| ||
| 03:20 | Restructure the OS interface yet again. This time make the OsFile object a virtual base class which is subclassed for unix, windows, and the crash test simulator. Add the new file "os.c" for common os layer code. Move all OS-specific routines into the sqlite3Os structure. (CVS 2795) (check-in: bd8740d1ae user: drh tags: trunk) | |
|
2005-11-29
| ||
| 19:56 | The crash test works now, at least on unix. Untested on windows. But it never worked on windows before so if it still does not there is no big loss. I am still troubled by the current design of the OS overloading mechanism. Expect to see more changes. (CVS 2794) (check-in: fa1d7ecfcc user: drh tags: trunk) | |
| 19:50 | Make the build work on windows again. Ticket #1544. (CVS 2793) (check-in: 59bdca2552 user: drh tags: trunk) | |
| 18:37 | The crash tests now compile, at least. But they get wrong results. The problem is fundamental and suggests I need to completely rethink how the new OS backend should work. (CVS 2792) (check-in: 966bc68e1b user: drh tags: trunk) | |
| 03:13 | Make the OsFile structure opaque with its internal structure known only to the appropriate os_*.c implementation. Omit the os_unix.h and os_win.h include files. The crash tests are broken by this patch. (CVS 2791) (check-in: 058f317538 user: drh tags: trunk) | |
|
2005-11-28
| ||
| 12:36 | Replace a call to sprintf() with sqlite3MPrintf() since on some embedded platforms, sprintf() is busted. Need to go through and do similar replacements elsewhere in the code. (CVS 2790) (check-in: 1b4f2d89bb user: drh tags: trunk) | |
|
2005-11-26
| ||
| 14:24 | Disable the OR-clause optimization if it does not result in an index being used that would not have been used otherwise. In other words, do not convert OR clauses into an IN statement if it does not help the optimizer. (CVS 2789) (check-in: 7e7cfce0f8 user: drh tags: trunk) | |
| 14:08 | Make sure left joins still work even when the OR clause optimization fires. Ticket #1537. (CVS 2788) (check-in: cbbeb9de00 user: drh tags: trunk) | |
| 03:51 | Remove some vestiges of the old OS_TEST driver. (CVS 2787) (check-in: 008f676f20 user: drh tags: trunk) | |
| 03:43 | Add an OS method for making copies of file descriptors. This fixes the crash tests. (CVS 2786) (check-in: 57a674fc71 user: drh tags: trunk) | |
| 00:25 | Modify the OS layer so that I/O routines are called through a virtual function table. The os_test.c module has been replaced by test6.c. The crash tests are busted now and need to be fixed. (CVS 2785) (check-in: 1f69aec285 user: drh tags: trunk) | |
|
2005-11-25
| ||
| 10:55 | Ensure a low system limit on the number of open files does not cause manydb.test to fail. (CVS 2784) (check-in: dba2cc0d0e user: danielk1977 tags: trunk) | |
| 10:38 | Add the compilation option SQLITE_DISABLE_DIRSYNC (CVS 2783) (check-in: f9f5ecbb79 user: danielk1977 tags: trunk) | |
| 10:38 | Add the compilation option SQLITE_DISABLE_DIRSYNC (CVS 2782) (check-in: f1298bb103 user: danielk1977 tags: trunk) | |
| 09:01 | If SQLITE_DISABLE_LFS is defined, omit the bigfile tests. (CVS 2781) (check-in: f882a516da user: danielk1977 tags: trunk) | |
| 08:47 | Check the return code of full_fsync() when used to sync a directory fd. (CVS 2780) (check-in: 84aae3b0ae user: danielk1977 tags: trunk) | |
| 02:43 | Preserve 64-bit last insert rowids across triggers. (CVS 2779) (check-in: 4dd7cfaa58 user: drh tags: trunk) | |
|
2005-11-24
| ||
| 23:14 | The --enable-cross-thread-connect configuration option or the -DSQLITE_ALLOW_XTHREAD_CONNECT compile-time option permits database connections to be moved across threads. This will cause latch-ups and failures on some linux systems such as RedHat-9. Do not use these options if you want a portable build. (CVS 2778) (check-in: 84aa4d5800 user: drh tags: trunk) | |
| 22:33 | Make sure sqliteInt.h is included before any system includes. This is required for QNX. Ticket #1478. (CVS 2777) (check-in: ab76453553 user: drh tags: trunk) | |
| 22:22 | Reduce the number of distinct token symbols in the parser so that the parser can store tokens in a single byte and thus be smaller in size. (CVS 2776) (check-in: 2dfc986391 user: drh tags: trunk) | |
| 14:34 | Comment changes. No changes to code. (CVS 2775) (check-in: 786e23b295 user: drh tags: trunk) | |
| 14:24 | Fix a comment in btree.c. No code changes. (CVS 2774) (check-in: 0d8bd133a7 user: drh tags: trunk) | |
| 13:15 | Fix incorrect type conversions when copying from a table into itself. Ticket #1536. (CVS 2773) (check-in: a2e55a3828 user: drh tags: trunk) | |
|
2005-11-21
| ||
| 12:48 | Less verbose output when EXPLAIN QUERY PLAN identifies use of the primary key. (CVS 2772) (check-in: 5045f09933 user: drh tags: trunk) | |
| 12:46 | The EXPLAIN QUERY PLAN now identifies when tables use the integer primary key. (CVS 2771) (check-in: 80721e2c90 user: drh tags: trunk) | |
|
2005-11-16
| ||
| 13:47 | Fix a problem with the sorting of literals in a compound query. Ticket #1501. (CVS 2770) (check-in: b3882b434a user: drh tags: trunk) | |
| 12:53 | Do not allow aggregate functions in a WHERE clause. Ticket #1514. (CVS 2769) (check-in: bb866ed880 user: drh tags: trunk) | |
| 04:34 | Avoid unnecessary strlen() calls in the OP_String opcode. (CVS 2768) (check-in: 2e195e96bc user: drh tags: trunk) | |
|
2005-11-15
| ||
| 02:14 | Fix a bug in UTF-16 handling introduced by the previous check-in. (CVS 2767) (check-in: 25fa16a2e1 user: drh tags: trunk) | |
|
2005-11-14
| ||
| 22:29 | Create separate affinities for INTEGER and REAL. (CVS 2766) (check-in: ce06c123d0 user: drh tags: trunk) | |
| 11:51 | Fix documentation typo. (CVS 2765) (check-in: c9b413ea22 user: drh tags: trunk) | |
|
2005-11-06
| ||
| 04:06 | About 0.5KiB of additional compression in the parser tables. (CVS 2764) (check-in: f39974ebd8 user: drh tags: trunk) | |
|
2005-11-05
| ||
| 15:11 | Work around a bug in MSVC++. Ticket #1513. (CVS 2763) (check-in: 6331860e77 user: drh tags: trunk) | |
| 15:07 | Remove a C++-ism that slipped into the code during the recent CHECK enhancements. Ticket #1513. (CVS 2762) (check-in: e66289b52f user: drh tags: trunk) | |
| 15:04 | Improved table compression in lemon reduces the overall library size by about 1.5KiB. (CVS 2761) (check-in: 86ac114769 user: drh tags: trunk) | |
|
2005-11-04
| ||
| 22:03 | VACUUM works even on an empty database. Ticket #1512. (CVS 2760) (check-in: 1b6bf4188e user: drh tags: trunk) | |
|
2005-11-03
| ||
| 14:29 | sqlite3_column_int() and similar routines return 0 or 0.0 on an out-of-memory condition, not some mysterious error code. (CVS 2759) (check-in: 7780f5e9d5 user: drh tags: trunk) | |
| 12:33 | Prohibit parameters in CHECK constraint expressions. (CVS 2758) (check-in: bb94ef64b2 user: drh tags: trunk) | |
| 02:15 | Add the ignore_check_constraints pragma. VACUUM works even on a database that contains table entries that violate check constraints. (CVS 2757) (check-in: be83bfee02 user: drh tags: trunk) | |
| 02:03 | Disallow subqueries in CHECK constraints. (CVS 2756) (check-in: db27afc4cd user: drh tags: trunk) | |
| 01:22 | CHECK constraints that evaluate to NULL pass. (CVS 2755) (check-in: 55b314a22c user: drh tags: trunk) | |
| 00:41 | First cut at supporting CHECK constraints. Everything appears to work, but much more testing is needed as well as documentation. (CVS 2754) (check-in: 2313d912ba user: drh tags: trunk) | |
|
2005-11-01
| ||
| 15:48 | Omit the SQLITE_AFF_INTEGER type affinity. All numeric values are now of type real, though an integer representation is still sometimes used internally for efficiency. (CVS 2753) (check-in: e0d6f61c7d user: drh tags: trunk) | |
|
2005-10-29
| ||
| 15:48 | Fix the shift operators so that they work with 64-bit quantities. (CVS 2752) (check-in: 0d3357b5f6 user: drh tags: trunk) | |
|
2005-10-23
| ||
| 11:29 | Report an error if the input SQL contains an unterminated string. Ticket #1497. (CVS 2751) (check-in: c9c476dd83 user: drh tags: trunk) | |
|
2005-10-20
| ||
| 07:28 | Changes to prevent various compiler warnings. (CVS 2750) (check-in: e261b8b09a user: drh tags: trunk) | |
|
2005-10-13
| ||
| 02:09 | Attempt to fix the SQLite core so that no floating point operations are used anywhere if SQLITE_OMIT_FLOATING_POINT is defined at compile-time. This is useful to people who use SQLite on embedded processors that lack floating point support. (CVS 2749) (check-in: a0bdb58468 user: drh tags: trunk) | |
|
2005-10-10
| ||
| 00:05 | Make the default TEMP_STORE=1 (TEMP tables stored on disk) in the configure script. (CVS 2748) (check-in: 9753af5349 user: drh tags: trunk) | |
|
2005-10-06
| ||
| 16:53 | More efficient handling of the LIMIT clause. Scalar subqueries and EXISTS on compound SELECT statements now working properly. Ticket #1473. (CVS 2747) (check-in: edca8913ca user: drh tags: trunk) | |
| 13:59 | Check-in (2744) as incomplete and broke pragma integrity_check. This completes the change and fixes the problem. (CVS 2746) (check-in: 4862eaafd8 user: drh tags: trunk) | |
|
2005-10-05
| ||
| 22:31 | Make the SQLite logo on the website a hyperlink to the home page. Ticket #1471. (CVS 2745) (check-in: 9709f0f6bc user: drh tags: trunk) | |
| 11:41 | Make sure pragma integrity_check does not report "ok" after first finding a bunch of errors. (CVS 2744) (check-in: efec04dedf user: drh tags: trunk) | |
| 11:35 | Fix an assert or memory leak that occurs when trying to EXPLAIN a statement other than a SELECT that outputs results. Examples of such statements include PRAGMA integrity_check or INSERT/DELETE/UPDATE with PRAGMA count_changes=ON. (CVS 2743) (check-in: 533a85eee2 user: drh tags: trunk) | |
| 10:40 | Changes to support TEA on cygwin. (CVS 2742) (check-in: e80fecc986 user: drh tags: trunk) | |
| 10:29 | Another attempt to get fdatasync to be ignored on non-conforming posix systems. Now a system has to opt-in for fdatasync instead of opt-out. Ticket #1467. (CVS 2741) (check-in: 115340d4e8 user: drh tags: trunk) | |
| 02:13 | Add the SQLITE_OMIT_GET_TABLE compile-time flag. (CVS 2740) (check-in: 6d4bc8f83b user: drh tags: trunk) | |
|
2005-10-04
| ||
| 18:38 | Automatically check for the fdatasync() function and replace it with fsync() if not found. (CVS 2739) (check-in: 385a08afef user: drh tags: trunk) | |
|
2005-10-03
| ||
| 15:11 | The hash tables deallocate when empty in order to avoid nuisanse complaints from valgrind. Added tests to verify no hash table memory leaks in os_unix.c. (CVS 2738) (check-in: 080eadca58 user: drh tags: trunk) | |
|
2005-09-25
| ||
| 01:13 | Make sure the default storage for virtual tables is the disk not memory while running conflict.test. Ticket #1453. (CVS 2737) (check-in: 6d780ca6cf user: drh tags: trunk) | |
|
2005-09-24
| ||
| 15:25 | Version 3.2.7 (CVS 2736) (check-in: bd141a7c12 user: drh tags: trunk) | |
| 15:10 | Perparations for version 3.2.7. (CVS 2735) (check-in: 70937d5cfa user: drh tags: trunk) | |
| 11:01 | Add the SQLite console source code in the contrib section of the source tree. (CVS 2734) (check-in: 079c6348f9 user: drh tags: trunk) | |
|
2005-09-23
| ||
| 21:11 | Fix an uninitialized structure member that was causing a malfunction when you used deeply nested and very complex views. Ticket #1449. (CVS 2733) (check-in: 352cc9f53b user: drh tags: trunk) | |
|
2005-09-22
| ||
| 15:45 | Optionally call fdatasync() instead of fsync() only if _POSIX_SYNCHRONIZED_IO is positive, which should only be the case on operating systems that actually support fdatasync(). (CVS 2732) (check-in: a9b341dccf user: drh tags: trunk) | |
|
2005-09-20
| ||
| 18:13 | Add VM code comments on the group-by processing. Extra group-by test case. (CVS 2731) (check-in: 655e75ac7d user: drh tags: trunk) | |
| 17:42 | Code cleanup and simplification. Three new Mem opcodes added. The sqlite3VdbeJumpHere function added. (CVS 2730) (check-in: 2471957fee user: drh tags: trunk) | |
| 13:55 | Cleanup the implementation and the documentation of the new 0x200 P1 flag on the VDBE comparison operands. (CVS 2729) (check-in: f22d0f64a0 user: drh tags: trunk) | |
| 13:12 | NULLs compare equal to each other when computing GROUP BY categories. (CVS 2728) (check-in: d9b0c97053 user: drh tags: trunk) | |
| 08:47 | Update comments in where.c. No code changes. (CVS 2727) (check-in: bb84d27eda user: drh tags: trunk) | |
| 01:36 | Documentation updates. (CVS 2726) (check-in: 6ec8883c36 user: drh tags: trunk) | |
|
2005-09-19
| ||
| 21:05 | ON-clause terms in a LEFT JOIN that restrict only the left table, should not really restrict the left table but instead rows that fail to meet the condition to be joined with NULL rows from the right table. (CVS 2725) (check-in: ea10f9785e user: drh tags: trunk) | |
| 19:05 | Set the default maximum page size to 32768, not 8192. (CVS 2724) (check-in: b32e9ec248 user: drh tags: trunk) | |
| 17:35 | Do not optimize views with an ORDER BY clause if they are used in a UNION ALL that also has an ORDER BY clause. Ticket #1444. (CVS 2723) (check-in: 6cc57fcf15 user: drh tags: trunk) | |
| 15:37 | Fix uninitialized value on a UNION ALL select with an ORDER BY clause. (CVS 2722) (check-in: 92126a2161 user: drh tags: trunk) | |
| 13:15 | The sqlite3_query_plan debugging variable now only appears with SQLITE_TEST=1. (CVS 2721) (check-in: 41e226d2ff user: drh tags: trunk) | |
| 12:53 | Work around limitations of MSVC++ 6. Tickets #1429, #1437, and #1440. (CVS 2720) (check-in: b2d1803c25 user: drh tags: trunk) | |
| 12:37 | Change some debugging #defines in order to get SSE working again after recent upgrades. (CVS 2719) (check-in: 86eb7d8363 user: drh tags: trunk) | |
|
2005-09-17
| ||
| 19:28 | Download page reports sizes in MiB and KiB instead of just bytes. (CVS 2718) (check-in: e985f02d20 user: drh tags: trunk) | |
| 19:14 | Update to the download page on the website. (CVS 2717) (check-in: 91bc0d0032 user: drh tags: trunk) | |
| 18:49 | Version 3.2.6 (CVS 2716) (check-in: 1cdfe66714 user: drh tags: trunk) | |
| 18:34 | The sqlite3ReallocOrFree routine should set its pointer to NULL when it fails. (CVS 2715) (check-in: 0e85af44fa user: drh tags: trunk) | |
| 18:02 | Fix up the busy test so that it can be run multiple times in a row without giving false errors on 2nd and subsequent runs. (CVS 2714) (check-in: 7a7ba73fb5 user: drh tags: trunk) | |
| 17:58 | Fix a memory leak that occurs after malloc fails. (CVS 2713) (check-in: 85b931bf72 user: drh tags: trunk) | |
| 17:05 | Fix the crash.test script to accomodate recent changes. (CVS 2712) (check-in: d594608ff3 user: drh tags: trunk) | |
| 16:48 | Fix a bug in the lock2 test script introduced by check-in (2709) (CVS 2711) (check-in: c3bf17436b user: drh tags: trunk) | |
| 16:36 | Fix a problem with the lock_status pragma and the UTF-16 encoding. (CVS 2710) (check-in: 1a737b457c user: drh tags: trunk) | |
| 15:20 | Changes to make corruption errors easier to track down. (CVS 2709) (check-in: c07330000b user: drh tags: trunk) | |
| 15:17 | Update the webpage description of 3.2.6 changes to talk about ticket #1432. (CVS 2708) (check-in: 0e23c28b25 user: drh tags: trunk) | |
| 13:29 | Bug fix in the ORDER BY optimizer. Ticket #1435. (CVS 2707) (check-in: 553b7ba8f8 user: drh tags: trunk) | |
| 13:07 | Make sure dependencies on the right-hand side of IN operators are checked correctly. Ticket #1433. (CVS 2706) (check-in: 21740794ab user: drh tags: trunk) | |
| 02:34 | Updates to the FAQ. (CVS 2705) (check-in: 0eaf430d95 user: drh tags: trunk) | |
|
2005-09-16
| ||
| 17:16 | Do not journal the locking page which doing an autovacuum. Similar to the problem of #1432 except that this one occurs on autovacuum instead of vacuum. An assert() has been added to catch any future incidents of this type. (CVS 2704) (check-in: 5b6dc12b7d user: drh tags: trunk) | |
| 11:32 | Do not journal the file locking page when doing a database copy as part of a VACUUM. Ticket #1432. (CVS 2703) (check-in: 248f77972b user: drh tags: trunk) | |
| 10:18 | Prevent the sqlite3_pagecount() function from ever returning the pending-byte page. (CVS 2702) (check-in: 35a8893537 user: danielk1977 tags: trunk) | |
| 10:13 | Move the definition of sqlite3_pending_byte from test2.c to os_common.h. (CVS 2701) (check-in: bedf702f53 user: danielk1977 tags: trunk) | |
| 09:52 | Fix an auto-vacuum problem with the PENDING_BYTE page. Also link the Tcl variable sqlite_pending_byte to the internal pending-byte location when in test mode. (CVS 2700) (check-in: 9115e0621d user: danielk1977 tags: trunk) | |
| 02:55 | Documentation changes in preparation for the release of 3.2.6. (CVS 2698) (check-in: 243f455c7c user: drh tags: trunk) | |
| 02:48 | Undo check-in (2694). (CVS 2697) (check-in: 6017b19625 user: drh tags: trunk) | |
| 02:38 | Fix a whole host of newly discovered memory leaks the occur after a failure of realloc(). (CVS 2696) (check-in: 4686d64975 user: drh tags: trunk) | |
| 00:27 | Fix a memory leak: a failure to deallocate the P3 parameter on a call to sqlite3VdbeChangeP3. (CVS 2695) (check-in: 714254cbc1 user: drh tags: trunk) | |
|
2005-09-15
| ||
| 21:24 | The table_info pragma now gives the order of columns in the primary key. (CVS 2694) (check-in: 9b60f48de7 user: drh tags: trunk) | |
|
2005-09-13
| ||
| 16:12 | Correct the sense of a test for SQLITE_DEBUG on the resent NDEBUG change. Ticket #1425 (CVS 2693) (check-in: 81fdffdff6 user: drh tags: trunk) | |
| 07:00 | Updates to the documentation on the TCL bindings. (CVS 2692) (check-in: 94aa2d3245 user: drh tags: trunk) | |
| 00:02 | Fix a comment typo in the previous check-in. (CVS 2691) (check-in: 49c952807d user: drh tags: trunk) | |
| 00:00 | Automatically set the NDEBUG preprocessor macro unless SQLITE_DEBUG is set. In this way, assert() statements become opt-in rather than opt-out. (CVS 2690) (check-in: 2ec2bd8574 user: drh tags: trunk) | |
|
2005-09-12
| ||
| 23:03 | Bug fix in the new COUNT(DISTINCT) logic. Ticket #1420. (CVS 2689) (check-in: 37116550d3 user: drh tags: trunk) | |
|
2005-09-11
| ||
| 11:56 | COUNT(DISTINCT x) is now fully functional, though it could benefit from additional testing. (CVS 2688) (check-in: 2f397bd814 user: drh tags: trunk) | |
| 02:03 | The ".dump" command from the shell correctly saves the state of the sqlite_sequence and sqlite_stat1 tables, if they exist. Ticket #1419. (CVS 2687) (check-in: 3f191cf497 user: drh tags: trunk) | |
|
2005-09-10
| ||
| 22:40 | The shell does not output the sqlite_stat1 table on .dump or .schema. The ANALYZE command now gathers statistics on tables that have only a single index because this sometimes helps when reordering tables in a join. (CVS 2686) (check-in: 26565b8931 user: drh tags: trunk) | |
| 16:46 | Add the experimental EXPLAIN QUERY PLAN diagnostic capability. (CVS 2685) (check-in: 986efb7b12 user: drh tags: trunk) | |
| 15:35 | Avoid a memory leak and/or assertion failure when parsing a table declaration that contains a duplicate column name. Ticket #1418. (CVS 2684) (check-in: f43427742b user: drh tags: trunk) | |
| 15:28 | Use of the CROSS keyword in a join prevents table reordering. Ticket #1414. (CVS 2683) (check-in: 415b8b2462 user: drh tags: trunk) | |
|
2005-09-09
| ||
| 10:46 | Enhanced disk-full tests. (CVS 2682) (check-in: 0288fa5d25 user: drh tags: trunk) | |
| 10:17 | Detect errors returned by SetFilePointer on windows. (CVS 2681) (check-in: bc8c33f94c user: drh tags: trunk) | |
| 01:33 | Infrastructure for the DISTINCT keyword in aggregate functions. But it does not work yet. If you try to use it you get an error message. (CVS 2680) (check-in: 4d62e36fe3 user: drh tags: trunk) | |
| 01:32 | Defend against disk I/O errors that happen during an sqlite3OsSeek(). (CVS 2679) (check-in: 461e3a0a27 user: drh tags: trunk) | |
|
2005-09-08
| ||
| 20:37 | SUM returns NULL when it has no inputs. Ticket #1413. (CVS 2678) (check-in: 6281859425 user: drh tags: trunk) | |
| 19:45 | A SUM() of all NULLs returns NULL. A SUM() of nothing return 0. A SUM() of a mixture of NULLs and numbers returns the sum of the numbers. Ticket #1413. (CVS 2677) (check-in: 2e6230edfd user: drh tags: trunk) | |
| 19:01 | Remove a C++ism that snuck in on one of the reason changes. (CVS 2676) (check-in: 48f6a331ef user: drh tags: trunk) | |
| 14:17 | Remove a few unused variables detected by Borland C. Ticket #1412. (CVS 2675) (check-in: cdfe372a95 user: drh tags: trunk) | |
| 12:57 | Aggregates with GROUP BY can sometimes return no result rows. (CVS 2674) (check-in: 0c3e368d47 user: drh tags: trunk) | |
| 12:38 | While doing a transaction comment, use fdatasync() instead of fsync() in cases there the file size is unchanged. (CVS 2673) (check-in: 3c555a8749 user: drh tags: trunk) | |
| 12:37 | Fix another test to account for SUM() returning integer rather than float. (CVS 2672) (check-in: bc723235e6 user: drh tags: trunk) | |
| 11:04 | Fix typos in documentation. Ticket #1239. (CVS 2671) (check-in: 73fbb8d968 user: drh tags: trunk) | |
| 10:58 | Fix a comment in sqlite.h. Ticket #1321. (CVS 2670) (check-in: ed4e9e751b user: drh tags: trunk) | |
| 10:37 | The SUM() aggregate function returns an integer result if all inputs are integers. Any single non-integer input causes the result to be a floating point value. (CVS 2669) (check-in: 21adf4bd99 user: drh tags: trunk) | |
| 02:00 | Changes to comments only in sqliteInt.h. No changes to code. (CVS 2668) (check-in: cc2a61650e user: drh tags: trunk) | |
| 01:58 | Optimizations and refinements. Improvements to test coverage. (CVS 2667) (check-in: 7283f7c29d user: drh tags: trunk) | |
| 00:13 | All regression tests now pass. But I am sure there must still be problems. New tests need to be added. (CVS 2666) (check-in: bcc7d722ce user: drh tags: trunk) | |
|
2005-09-07
| ||
| 23:05 | More bug fixes. All of the "quick" tests pass. The full test suite still shows problems. (CVS 2665) (check-in: a1b6d910cd user: drh tags: trunk) | |
| 22:48 | More bug fixes. But there are still tests that fail. (CVS 2664) (check-in: 7e85a162d0 user: drh tags: trunk) | |
| 22:09 | Bug fixes in aggregate processing. Fewer tests fail. (CVS 2663) (check-in: c3ac58592f user: drh tags: trunk) | |
| 21:22 | Rewrite the aggregate handling logic so that it runs in O(1) space. This is the first cut at the code. Many regression tests fail. (CVS 2662) (check-in: 17039ec3ff user: drh tags: trunk) | |
|
2005-09-06
| ||
| 21:40 | Changes to reduce the amount of stack space required. (CVS 2661) (check-in: b86bd70f30 user: drh tags: trunk) | |
| 20:36 | Cleanup the processing of MEM_Agg elements. (CVS 2660) (check-in: 7ecf3654aa user: drh tags: trunk) | |
| 10:26 | Fix ANALYZE so that it works even if the empty_result_callbacks pragma is enabled. Ticket #1409. (CVS 2659) (check-in: bfdaef1224 user: drh tags: trunk) | |
|
2005-09-05
| ||
| 20:35 | Make due with "sub()" instead of "gsub()" in awk scripts so that builds will work on Solaris which will runs an archiac version of AWK. (CVS 2658) (check-in: 449a789599 user: drh tags: trunk) | |
| 20:06 | Fix bugs introduced by checkin (2656) and do some modest code enhancements. (CVS 2657) (check-in: 7b56763a8b user: drh tags: trunk) | |
| 19:08 | Use the unicode API to win32 where available. Tickets #1407, #1396, #1331, #1243, #1206 (CVS 2656) (check-in: 3ec58c673a user: drh tags: trunk) | |
|
2005-09-01
| ||
| 17:47 | Fix over-aggressive optimization of ORDER BY as reported on the mailing list. (CVS 2655) (check-in: efbb4bc83c user: drh tags: trunk) | |
| 12:16 | All regression tests now pass with the new bounded-memory sort code. There is still lots of opportunity for optimization, however. (CVS 2654) (check-in: 81259a01f1 user: drh tags: trunk) | |
| 03:07 | Sorting is now done using a sorting index rather than loading the entire result set into memory and doing a merge sort. The old merge sort technique was a carry-over from SQLite version 1. The new method uses a bounded amount of memory and scales to much larger result sets. There are still errors: some 39 regression tests fail. (CVS 2653) (check-in: 09db0a2424 user: drh tags: trunk) | |
|
2005-08-31
| ||
| 18:20 | {quote: KeyInfo} generation moved to a common subroutine. (CVS 2652) (check-in: a25801df06 user: drh tags: trunk) | |
| 13:48 | Updates to the query optimizer overview document. (CVS 2651) (check-in: b1dceef050 user: drh tags: trunk) | |
| 13:13 | Explicit typecasts to silence nuisance compiler warnings. Ticket #1398. (CVS 2650) (check-in: 90712ea727 user: drh tags: trunk) | |
| 03:13 | Refinements to the optimizer overview and integration into the website. (CVS 2649) (check-in: ccd12e9e79 user: drh tags: trunk) | |
| 02:46 | Update the FAQ to include an entry about binary versus decimal numbers. (CVS 2648) (check-in: 0bbe73fccf user: drh tags: trunk) | |
| 01:49 | Adding the first cut of the optimizer overview document. (CVS 2647) (check-in: 4c8d0a4c26 user: drh tags: trunk) | |
|
2005-08-30
| ||
| 22:44 | Adjust the makefile for new optimizer documentation. (CVS 2646) (check-in: 14668c85b8 user: drh tags: trunk) | |
| 22:44 | Initial work on documentation describing the optimizer. (CVS 2645) (check-in: 5cebd7ba3c user: drh tags: trunk) | |
| 20:12 | The CSV output mode does not sign-extend bytes where the high-order bit is set. Ticket #1397. (CVS 2644) (check-in: 528df777e5 user: drh tags: trunk) | |
| 19:30 | Fix printf.c so that it handles 10.0 correctly. (CVS 2643) (check-in: 0f7a53f78d user: drh tags: trunk) | |
| 00:54 | Minor code enhancements. (CVS 2642) (check-in: 4ab994a87e user: drh tags: trunk) | |
| 00:10 | Update the home page to brag about 150KiB code footprint when optional features are omitted. (CVS 2641) (check-in: 0e1ac1284c user: drh tags: trunk) | |
|
2005-08-29
| ||
| 23:06 | Make the shell aware of SQLITE_OMIT_MEMORYDB. Ticket #1395. (CVS 2640) (check-in: 71a71cef5b user: drh tags: trunk) | |
| 23:00 | Increase resolution of time-of-day on unix. Add an experimental sqlite3_profile() API. (CVS 2639) (check-in: ed2ca0873f user: drh tags: trunk) | |
| 16:40 | Initialize a local variable to avoid a nuisance compiler warning. Ticket #1394. (CVS 2638) (check-in: 9b914901a1 user: drh tags: trunk) | |
|
2005-08-28
| ||
| 17:00 | The LIKE optimization does the right thing when collating sequences are present. LIKE expressions where the left-hand side has COLLATE NOCASE are optimized in the default case. (CVS 2637) (check-in: ef84ff795c user: drh tags: trunk) | |
| 01:38 | Improvements to the formatting and layout of the code in the previous checkin. (CVS 2636) (check-in: 73b430de0c user: drh tags: trunk) | |
| 01:34 | Add an assert to verify that floating point values and integers use the same byte order. Add a comment to the SELECT code generator. (CVS 2635) (check-in: 07b4892149 user: drh tags: trunk) | |
|
2005-08-27
| ||
| 17:23 | Version 3.2.5 (CVS 2634) (check-in: b2415a749c user: drh tags: trunk) | |
| 17:22 | Change the wording of the news line for release 3.2.5. (CVS 2633) (check-in: 70db46d3ef user: drh tags: trunk) | |
| 17:19 | Get the date right. Today is the 27th, not the 25th or the 28th. (CVS 2632) (check-in: 905b9d6c5e user: drh tags: trunk) | |
| 17:06 | Increase the version number and update web pages for the next release. (CVS 2631) (check-in: e6039e909a user: drh tags: trunk) | |
| 16:36 | Disable synchronous writes to the master journal when PRAGMA synchronous=OFF for all database files. Ticket #1375. (CVS 2630) (check-in: 644b96aa23 user: drh tags: trunk) | |
| 13:16 | Fix comment in vdbeapi.c. Remove unused structure definition from func.c. (CVS 2629) (check-in: 51a381345d user: drh tags: trunk) | |
| 13:11 | Remove the words "statically linked" from the description of the shell on the download page. Ticket #1391. (CVS 2628) (check-in: ecb9604457 user: drh tags: trunk) | |
| 09:07 | Remove GNUmake extensions from the makefile. Ticket #1390. (CVS 2627) (check-in: d0691fed43 user: drh tags: trunk) | |
| 01:51 | Do not change fields of stale sqlite3 handles. Ticket #1384. (CVS 2626) (check-in: 7e05b7ca0c user: drh tags: trunk) | |
| 01:50 | Widen the opcode column of explain output in the shell. (CVS 2625) (check-in: dd3b00aa0b user: drh tags: trunk) | |
|
2005-08-25
| ||
| 12:45 | When the left-hand side of an IN operator is constant and the right-hand side is a SELECT, recognize that the IN operator is not constant. Ticket #1380. (CVS 2624) (check-in: fc9e04609b user: drh tags: trunk) | |
|
2005-08-24
| ||
| 18:04 | Fix the --enable-threadsafe option to the configure script. Ticket #1378. (CVS 2623) (check-in: 76ec0b3d3a user: drh tags: trunk) | |
| 17:07 | Additional defense against the rowid-fifo overflow problem. (CVS 2622) (check-in: 881dcf5fb1 user: drh tags: trunk) | |
| 16:54 | Remove a stray C++ style comment causing problems for some compilers. (CVS 2621) (check-in: aa7dd3f2c7 user: drh tags: trunk) | |
| 16:13 | Fix a bug in DELETE that might cause a segfault when deleting more than 40940 rows of data all at once. (CVS 2620) (check-in: 7c599bae33 user: drh tags: trunk) | |
| 11:14 | Version 3.2.4 (CVS 2619) (check-in: 8cef2c1ae7 user: drh tags: trunk) | |
| 11:07 | Increase the version number and update the change log prior to release. (CVS 2618) (check-in: 139a28d231 user: drh tags: trunk) | |
| 03:52 | After calling realloc() on an array to resize it, be sure not to use pointers into the old array. Ticket #1376. (CVS 2617) (check-in: 9f9a257123 user: drh tags: trunk) | |
|
2005-08-23
| ||
| 11:31 | Allow floating point literals to being or end with a decimal point. Ticket #1371. (CVS 2616) (check-in: a715e70012 user: drh tags: trunk) | |
| 11:17 | Handle empty blob constants correctly. Ticket #1373. (CVS 2615) (check-in: 5cada745ac user: drh tags: trunk) | |
| 11:03 | Fix another documentation typo. (CVS 2614) (check-in: 55f4b14e19 user: drh tags: trunk) | |
| 11:00 | Fix typos in syntax documentation. Ticket #1374 and a report on the mailing list. (CVS 2613) (check-in: 990d1f3a5b user: drh tags: trunk) | |
|
2005-08-22
| ||
| 02:10 | Update the download page of the website to handle TEA builds and starkits. (CVS 2612) (check-in: 1fab599b6f user: drh tags: trunk) | |
|
2005-08-21
| ||
| 21:45 | Clean up possible locking problem in multithreaded applications that take a malloc failure. (CVS 2611) (check-in: 545e702a23 user: drh tags: trunk) | |
| 18:54 | Version 3.2.3 (CVS 2610) (check-in: f620319b44 user: drh tags: trunk) | |
| 18:40 | Increase the version number and adjust documentation prior to the next release. (CVS 2609) (check-in: b15ed7db4d user: drh tags: trunk) | |
| 18:21 | Disable malloc tests when not compiled with SQLITE_DEBUG. (CVS 2608) (check-in: f372682fa3 user: drh tags: trunk) | |
| 17:48 | Do not create an error message if there is no error. (CVS 2607) (check-in: 3aa47c5587 user: drh tags: trunk) | |
| 16:54 | Do not overwrite small files (less than 1024 bytes) that are not databases. Ticket #1370. (CVS 2606) (check-in: 7f4302686e user: drh tags: trunk) | |
|
2005-08-20
| ||
| 13:47 | More test coverage improvements. (CVS 2605) (check-in: e559e810a5 user: drh tags: trunk) | |
| 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) (check-in: f786f37a5e user: drh tags: trunk) | |
|
2005-08-19
| ||
| 19:14 | Increase test coverage of alter.c to 100%. Fix bugs found in the process. (CVS 2603) (check-in: b550d04d43 user: drh tags: trunk) | |
| 03:03 | Additional tests for better coverage. (CVS 2602) (check-in: 4281a838f2 user: drh tags: trunk) | |
| 02:26 | Increased test coverage on trigger.c and printf.c. (CVS 2601) (check-in: 842a80bd8f user: drh tags: trunk) | |
| 01:07 | More test coverage enhancements. (CVS 2600) (check-in: 0b6cd5acc0 user: drh tags: trunk) | |
| 00:14 | Bring testing coverage of the analyze.c file up to 100%. Bugs found and fixed in the process. (CVS 2599) (check-in: 2fe0ac4fa4 user: drh tags: trunk) | |
|
2005-08-18
| ||
| 18:15 | Comment fixes. No changes to the underlying code. (CVS 2598) (check-in: b865e243ee user: drh tags: trunk) | |
|
2005-08-16
| ||
| 14:44 | Fix typo in documentation. (CVS 2597) (check-in: 32efcd2461 user: drh tags: trunk) | |
| 11:11 | Null-terminate the strings array passed to Tcl_GetIndexFromObj. Bug reported on the mailing list. (CVS 2596) (check-in: 3a7918a66b user: drh tags: trunk) | |
|
2005-08-14
| ||
| 20:47 | General code cleanup resulting in smaller footprint. (CVS 2595) (check-in: 98338abf9e user: drh tags: trunk) | |
| 17:53 | Split the sqlite3_complete() API out into a separate source file so that in static links where it is not used it will not take up space in the resulting binary. (CVS 2594) (check-in: 62b87751de user: drh tags: trunk) | |
| 01:34 | Declare local-use functions as static. Ticket #1363. (CVS 2593) (check-in: 94efd79088 user: drh tags: trunk) | |
| 01:20 | The case_sensitive_like pragma added. Test cases added for the LIKE optimization. (CVS 2592) (check-in: 72ee21c05e user: drh tags: trunk) | |
|
2005-08-13
| ||
| 18:15 | Provide grave accent quoting of identifiers for MySQL compatibility. Ticket #1337. (CVS 2591) (check-in: 6b7a4e9752 user: drh tags: trunk) | |
| 17:17 | Give the same access permissions to journal files as is given to databases. (CVS 2590) (check-in: 7961ec0ccb user: drh tags: trunk) | |
| 16:13 | Disable an overzealous optimization the omitted sorting on a join if the first table gave a unique result. The sort can only be omitted if all tables in the join are unique. Ticket #1358. (CVS 2589) (check-in: 4f07661279 user: drh tags: trunk) | |
| 13:40 | Fix a comment in printf. (CVS 2588) (check-in: 1054685f15 user: drh tags: trunk) | |
| 13:39 | Additional cleanup and optimization of the printf function. (CVS 2587) (check-in: 240bb04900 user: drh tags: trunk) | |
| 12:59 | Add the "!" flag to the "%g" mprintf conversion parameter to force a decimal point. This prevents floating point values from appearing as integers. Use this flag when converting floating point to text. Ticket #1362. (CVS 2586) (check-in: 4b98dace6b user: drh tags: trunk) | |
| 03:07 | Make the round() function work correctly on numbers with very large exponents. Ticket #1340. (CVS 2585) (check-in: 4f47c3c884 user: drh tags: trunk) | |
| 00:56 | Fix a memory leak that occurs when a CREATE TABLE that contains a DEFAULT VALUE fails due to a name conflict. Tickets #1356 and #1357. (CVS 2584) (check-in: 25cfe9390d user: drh tags: trunk) | |
|
2005-08-12
| ||
| 23:20 | 3rd argument to sqlite3Error() should always be a format string, never user-supplied error message text. Ticket #1354. (CVS 2583) (check-in: d6146a542a user: drh tags: trunk) | |
| 22:58 | Improved error message when a #NNN parameter appears on user input. Additional coverage testing. (CVS 2582) (check-in: 3c00f5982a user: drh tags: trunk) | |
| 22:56 | Optimize LIKE and GLOB operators in the WHERE clause. Code passes all regression tests but still needs additional tests. (CVS 2581) (check-in: 3edbe8d621 user: drh tags: trunk) | |
|
2005-08-11
| ||
| 02:10 | Improve the error message associated with SQLITE_FULL. Ticket #1353. Also remove error messages for obsolete error codes SQLITE_INTERNAL, SQLITE_NOTFOUND, and SQLITE_TOOBIG. (CVS 2580) (check-in: fa7403c7d9 user: drh tags: trunk) | |
| 01:25 | Add 2005 open source award badge and news announcement. (CVS 2579) (check-in: 8e007f8c06 user: drh tags: trunk) | |
|
2005-08-05
| ||
| 18:50 | Make sure the .import command strips newlines off the end of the last field in each line imported. Ticket #1348 (CVS 2578) (check-in: 73fafd2148 user: drh tags: trunk) | |
|
2005-08-02
| ||
| 21:42 | Comment out the use of memory high-water marks when not compiling with SQLITE_MEMDEBUG. (CVS 2577) (check-in: fb7a258fd3 user: drh tags: trunk) | |
| 17:48 | Minor refactoring of the new optimizer code. (CVS 2576) (check-in: 868322f7b7 user: drh tags: trunk) | |
| 17:38 | Update the documentation for the new transaction method on the TCL interface. (CVS 2575) (check-in: 3dc823a0ac user: drh tags: trunk) | |
| 17:15 | Tests and bug fixes on the new transaction method in the TCL interface. (CVS 2574) (check-in: 68dd0ed5e3 user: drh tags: trunk) | |
| 17:13 | Fix a bug in the btree balancer. ticket #1346. (CVS 2573) (check-in: 3af69a4928 user: drh tags: trunk) | |
| 12:21 | Add the "transaction" coommand to the TCL interface. Untested. (CVS 2572) (check-in: a5ce6c58c3 user: drh tags: trunk) | |
|
2005-07-29
| ||
| 19:43 | Fix problems caused by over-agressive optimization of ORDER BY in joins. Lots more testing needed. (CVS 2571) (check-in: 1a4e526d46 user: drh tags: trunk) | |
| 15:36 | Fix authentication so that it works with AS aliases. Ticket #1338. (CVS 2570) (check-in: cc7ae73ed0 user: drh tags: trunk) | |
| 15:10 | Optimizer now converts OR-connected WHERE-clause terms into an IN operator so that they can be used with indices. There are known problems with the ORDER BY optimization in this and in several prior check-ins. This check-in is not recommended for production use. (CVS 2569) (check-in: d23c8bf81e user: drh tags: trunk) | |
|
2005-07-28
| ||
| 23:12 | The BETWEEN operator in a WHERE clause is now able to use indices. (CVS 2568) (check-in: cdf8c9584b user: drh tags: trunk) | |
| 20:51 | Test cases and tuning of the new optimizer code. (CVS 2567) (check-in: 4b02703dec user: drh tags: trunk) | |
| 16:51 | The new optimizer now passes all regression tests. (CVS 2566) (check-in: a212128433 user: drh tags: trunk) | |
|
2005-07-27
| ||
| 20:41 | More work on the new optimizer. Fewer tests fail now. (CVS 2565) (check-in: ee3a08e353 user: drh tags: trunk) | |
|
2005-07-23
| ||
| 22:59 | A new optimizer that breaks a lot of tests. But none of them critically, I think. Nevertheless, there is a lot of work ahead to stabilize the code. (CVS 2564) (check-in: 86ce56ccea user: drh tags: trunk) | |
| 14:52 | Store the total number of rows as part of the ANALYZE statistics. (CVS 2563) (check-in: 868279c78e user: drh tags: trunk) | |
| 03:18 | The results of ANALYZE are now loaded into internal data structures where they can be used. But they are not actually used yet. (CVS 2562) (check-in: 1996bacfb9 user: drh tags: trunk) | |
| 02:17 | Full-coverage testing and documentation for the ANALYZE command. The results of analysis are still not loaded or used, however. (CVS 2561) (check-in: bd7583a5d6 user: drh tags: trunk) | |
| 00:41 | First code for the ANALYZE command. Mostly untested. The analysis is not loaded into the symbol tables and is not used by the optimizer. (CVS 2560) (check-in: a4886b114d user: drh tags: trunk) | |
|
2005-07-22
| ||
| 23:56 | Clarify the meaning of the TEMP keyword on CREATE TABLE. (CVS 2559) (check-in: 1a573619f5 user: drh tags: trunk) | |
| 22:53 | Correct the documentation to show that sqlite3_column_text() returns a NULL pointer (not an empty string) when the column value is NULL. The same goes for sqlite3_column_blob(). Ticket #1334. (CVS 2558) (check-in: fd1e013a14 user: drh tags: trunk) | |
| 00:31 | Begin adding code to support multiple IN constraints on the same index. (CVS 2557) (check-in: 103f8ccb90 user: drh tags: trunk) | |
|
2005-07-21
| ||
| 18:23 | Split the OP_Integer opcode into OP_Integer and OP_Int64. This allows comments to be added to OP_Integer. Cleanup in the optimizer. Allow terms of the FROM clause to be reordered automatically. (CVS 2556) (check-in: e2f822ac82 user: drh tags: trunk) | |
| 03:48 | Add comments to test cases. Improvements to the query plan test variable. (CVS 2555) (check-in: ef3a157f46 user: drh tags: trunk) | |
| 03:15 | In where.c, split out the code that selects an index into a separate subroutine. (CVS 2554) (check-in: c30cbba9ea user: drh tags: trunk) | |
|
2005-07-20
| ||
| 14:31 | Extra memory usage instrumentation added. (CVS 2553) (check-in: ac669f56c0 user: drh tags: trunk) | |
|
2005-07-19
| ||
| 22:22 | More refactoring in where.c. (CVS 2552) (check-in: a35bd50af8 user: drh tags: trunk) | |
| 17:38 | Refactoring of the query optimizer in advance of adding better optimization. (CVS 2551) (check-in: 57c6bd3760 user: drh tags: trunk) | |
|
2005-07-16
| ||
| 13:33 | Allow an unlimited number of terms in the WHERE clause. The old limit was 100. (CVS 2550) (check-in: ca69f36832 user: drh tags: trunk) | |
|
2005-07-15
| ||
| 23:24 | Fix bugs in the new query plan instrumention logic. (CVS 2549) (check-in: 578490c913 user: drh tags: trunk) | |
| 13:05 | Add test instrumentation that will be needed during the development of forthcoming optimizer enhancements. (CVS 2548) (check-in: dfd5fd77b0 user: drh tags: trunk) | |
|
2005-07-09
| ||
| 23:11 | Add remark in the changelog that mentions 64-bit alignment fixes in 3.2.2. (CVS 2547) (check-in: ead583cfad user: drh tags: trunk) | |
| 02:39 | Fix a comment error. No changes to code. Ticket #1320. (CVS 2546) (check-in: e050af70ad user: drh tags: trunk) | |
| 02:38 | Use the internal sqlite3_snprintf function instead of sprintf to avoid cross-platform incompatibilities. Ticket #1316. (CVS 2545) (check-in: 431999da7b user: drh tags: trunk) | |
| 02:23 | Patch to Makefile.in so that it works with OS X. Ticket #1292. (CVS 2544) (check-in: 0dfabca641 user: drh tags: trunk) | |
| 02:16 | Make sure there is only one busy counter. Ticket #1315. (CVS 2543) (check-in: af2a0ba4a3 user: drh tags: trunk) | |
|
2005-07-08
| ||
| 18:25 | Allow the IN operator to take a list of arbitrary expressions on its right-hand side. The expressions no longer need to be constant. The current implementation seems to work but needs more testing and optimization. (CVS 2542) (check-in: ba56478dd8 user: drh tags: trunk) | |
| 17:13 | Change the name of the OpenTemp opcode to OpenVirtual which is more descriptive of what it does. (CVS 2541) (check-in: 3bb9ce5f20 user: drh tags: trunk) | |
| 14:14 | Add the EP_OptOnly flag on expressions for WHERE clause terms that are added by the optimizer but should not be coded. (CVS 2540) (check-in: f4a66ed04d user: drh tags: trunk) | |
| 13:53 | Add the SQLITE_CASE_SENSITIVE_LIKE compile-time option. (CVS 2539) (check-in: b72bff81f9 user: drh tags: trunk) | |
| 13:08 | Replace OP_List with OP_Fifo. This is the first step toward allowing recursive delete triggers and later foreign keys with cascading deletes. (CVS 2538) (check-in: 94c120bb78 user: drh tags: trunk) | |
| 12:13 | Add infrastructure for the ANALYZE command. Does not yet actually do anything. (CVS 2537) (check-in: 05b6ac9a76 user: drh tags: trunk) | |
|
2005-07-06
| ||
| 13:51 | Fix a quoting problem in the configure script. (CVS 2536) (check-in: b34647a2eb user: drh tags: trunk) | |
|
2005-07-01
| ||
| 11:38 | Fix typos in comments. No changes to code. (CVS 2535) (check-in: d3b03495a4 user: drh tags: trunk) | |
|
2005-06-30
| ||
| 17:04 | Allow the DEFAULT value of a column to be obtained by calling a function that has constant arguments, such as julianday('now'). (CVS 2534) (check-in: d273766ef2 user: drh tags: trunk) | |
|
2005-06-29
| ||
| 17:24 | Check for zero-byte allocations in sqlite3MallocRaw. (CVS 2533) (check-in: 78cb8a9a17 user: drh tags: trunk) | |
| 15:33 | Make sqlite3Malloc always return NULL when the number of bytes to allocate is 0. (CVS 2532) (check-in: 657d74ebc1 user: drh tags: trunk) | |
|
2005-06-26
| ||
| 20:00 | Update SQL syntax documentation to describe the new CAST expressions. (CVS 2531) (check-in: d5392866bf user: drh tags: trunk) | |
| 17:55 | Tcl interface uses Tcl_Objs to implement user-defined functions, thus allowing BLOB values to be transferred correctly. Ticket #1304. (CVS 2530) (check-in: 514aaab3f9 user: drh tags: trunk) | |
|
2005-06-25
| ||
| 19:42 | Documentation fixes. Ticket #1306. (CVS 2529) (check-in: 3dcdb7942e user: drh tags: trunk) | |
| 19:31 | The TCL interface binds variables as BLOB only if they have a bytearray representation but no text representation. Ticket #1287. (CVS 2528) (check-in: 8c99dca60a user: drh tags: trunk) | |
| 18:42 | Remove the blob(), text() and numeric() functions added in (2524) and replace them with the standard CAST operator. Ticket #1287. (CVS 2527) (check-in: 17631785f9 user: drh tags: trunk) | |
|
2005-06-24
| ||
| 03:53 | NULL values in a row of a unique index cause the row to be distinct. Ticket #1301. More testing and optimization needs to be done on this before closing the ticket. (CVS 2526) (check-in: 06a71b162b user: drh tags: trunk) | |
|
2005-06-23
| ||
| 03:15 | Make sure the String8 opcode always has a non-null P3 argument in the foreign_key_list pragma. Ticket #1297. (CVS 2525) (check-in: bcf62dc7a1 user: drh tags: trunk) | |
|
2005-06-22
| ||
| 10:53 | Add built-in functions numeric(), text(), and blob() that coerce types. Ticket #1287. (CVS 2524) (check-in: affb0fa2e8 user: drh tags: trunk) | |
| 08:48 | Allow parameters to be introduced by characters ':', '$' and '#'. This is an experimental change. (CVS 2523) (check-in: f3427a139c user: drh tags: trunk) | |
| 02:36 | Fix a bug in an assert found while investigating ticket #1287 but otherwise unrelated to that problem. (CVS 2522) (check-in: 60f752ed18 user: drh tags: trunk) | |
|
2005-06-16
| ||
| 19:48 | Change the documentation to explain that a database handle can only be used in the same thread in which it was created. Ticket #1272. (CVS 2521) (check-in: 59c95731f7 user: drh tags: trunk) | |
| 18:47 | Fix the THREADSAFE macro in Makefile.in. We really need to rework the whole autoconf build system.... (CVS 2520) (check-in: 98a4de76e0 user: drh tags: trunk) | |
| 16:51 | Change to Makefile.in to fix a problem with the Borland linker. Ticket #1291. (CVS 2519) (check-in: bc25397735 user: drh tags: trunk) | |
|
2005-06-15
| ||
| 18:07 | Fix to the "make doc" makefile target. Ticket #1289. (CVS 2518) (check-in: 4713b1e104 user: drh tags: trunk) | |
| 17:47 | Changes to the unix OS layer aimed at finding and fixing tickets #1272 and #1285. (CVS 2517) (check-in: 006dda3119 user: drh tags: trunk) | |
|
2005-06-14
| ||
| 17:47 | Fix an NDEBUG versus SQLITE_DEBUG confusion issue. (CVS 2516) (check-in: 833c016023 user: drh tags: trunk) | |
| 16:04 | Provide the SQLITE_FILE_HEADER command-line option for changing the text that appears at the beginning of databases. (CVS 2515) (check-in: 3d7ee5b92d user: drh tags: trunk) | |
| 02:24 | Fix a bug in the default busy handler for systems that lack usleep(). Ticket #1284. (CVS 2514) (check-in: a42cb81d11 user: drh tags: trunk) | |
| 02:12 | Do not record existance the sqlite_sequence table until it is actually created. Ticket #1283. (CVS 2513) (check-in: 95256d953c user: drh tags: trunk) | |
|
2005-06-13
| ||
| 00:48 | Fix documentation typo. Ticket #1282. (CVS 2512) (check-in: ce6b62fa46 user: drh tags: trunk) | |
|
2005-06-12
| ||
| 23:17 | Version 3.2.2 (CVS 2511) (check-in: 0e190e9d91 user: drh tags: trunk) | |
| 23:16 | Update the EXPORT definitions list to include the latest additions to the API. (CVS 2510) (check-in: 44e54b132e user: drh tags: trunk) | |
| 22:23 | Updates in preparation for the release of version 3.2.2. (CVS 2509) (check-in: e9602c4a9d user: drh tags: trunk) | |
| 22:12 | Fix documentation typos. (CVS 2508) (check-in: 41049062cd user: drh tags: trunk) | |
| 22:01 | Documentation updates (ticket #1279). Add the sqlite3_db_handle API. (ticket #1275). (CVS 2507) (check-in: 21d44fa5e7 user: drh tags: trunk) | |
| 21:35 | Update older opcode names to be more meaningful in light of the latest code design. (CVS 2506) (check-in: 36f2da1f8d user: drh tags: trunk) | |
| 12:01 | Elminiate a VM opcode that was no longer needed. (CVS 2505) (check-in: 97b348a5ad user: drh tags: trunk) | |
|
2005-06-07
| ||
| 22:22 | Changes to support linking without a parser and without a disk I/O interface. (CVS 2504) (check-in: 62a7353d4a user: drh tags: trunk) | |
| 20:07 | In the documentation, amplify the fact that encodings cannot be changed on a database that already exists. Ticket #1277. (CVS 2503) (check-in: 4704f3a19a user: drh tags: trunk) | |
| 09:21 | Remove SSE vacuum hook. (CVS 2502) (check-in: 59960a5915 user: danielk1977 tags: trunk) | |
| 07:58 | Add "#ifndef OMIT_DISKIO" condition around sqlite3_opentemp_count variable in test interface code. (CVS 2501) (check-in: f2ce662e81 user: danielk1977 tags: trunk) | |
| 02:12 | Add tests to make sure statement journals are only opened when necessary. (CVS 2500) (check-in: 914d6e6549 user: drh tags: trunk) | |
| 01:43 | Do not open a statement journal unless absolutely necessary. (CVS 2499) (check-in: 989573a53b user: drh tags: trunk) | |
|
2005-06-06
| ||
| 21:19 | Reference count Table structures so that they are not deallocated too soon. Ticket #1210. (CVS 2498) (check-in: e73d25c741 user: drh tags: trunk) | |
| 17:54 | Return SQLITE_MISUSE when passing a NULL pointer into sqlite3_bind routines. Ticket #1219. (CVS 2497) (check-in: 12c32f139b user: drh tags: trunk) | |
| 17:27 | Any non-zero value is considered TRUE in a WHERE clause. Ticket #1211. (CVS 2496) (check-in: 0f7af62379 user: drh tags: trunk) | |
| 17:11 | Avoid ambiguous column name errors when the column name is in the USING clause of a join. Ticket #743. (CVS 2495) (check-in: 6a51bdeeff user: drh tags: trunk) | |
| 16:59 | Naming the join columns in the result set of a natural join does not result in an "ambiguous column name" error. Ticket #1217. (CVS 2494) (check-in: 265fb6079c user: drh tags: trunk) | |
| 16:34 | Honor the full_column_names pragma on * results. Ticket #1263. (CVS 2493) (check-in: 0d57f851ae user: drh tags: trunk) | |
| 15:32 | Do not allow parameters in VIEW definitions. Ticket #1270. (CVS 2492) (check-in: 0d46289f02 user: drh tags: trunk) | |
| 15:06 | Handle failures of getcwd() without segfaulting. Ticket #1274. (CVS 2490) (check-in: c1691004d6 user: drh tags: trunk) | |
| 14:45 | Fix a bug in the malloc2 tests introduced by checkin (2473). (CVS 2489) (check-in: fafaa18eea user: drh tags: trunk) | |
|
2005-05-29
| ||
| 14:23 | Omit a couple of test cases if the library is compiled without subqueries. (CVS 2488) (check-in: 6bc3729783 user: danielk1977 tags: trunk) | |
|
2005-05-27
| ||
| 09:41 | Minor changes to help build and test SSE. (CVS 2487) (check-in: 3ac4a212bd user: danielk1977 tags: trunk) | |
|
2005-05-26
| ||
| 16:23 | Add an experimental sqlite3_get_autocommit() API used to test whether or not changes are committed automatically. (CVS 2486) (check-in: 4a7f127585 user: drh tags: trunk) | |
| 15:20 | Add a -cleanup option to Tcl test proc do_ioerr_test. (CVS 2485) (check-in: b0a898c05a user: danielk1977 tags: trunk) | |
| 14:41 | If SSE is enabled, set the P1 field of OP_AggInit instructions to the number of arguments that will be passed to the aggregate function. (CVS 2484) (check-in: 7f67b9f0f3 user: danielk1977 tags: trunk) | |
| 12:37 | Fix minor problems with the SSE hooks. (CVS 2483) (check-in: 3516ca29da user: danielk1977 tags: trunk) | |
|
2005-05-25
| ||
| 10:45 | Rearrange code so that SSE can invoke the collation factory. (CVS 2482) (check-in: ea061d2ed3 user: danielk1977 tags: trunk) | |
| 04:11 | Split main.c into two files to make building without the parser easier. (CVS 2481) (check-in: d50915fafb user: danielk1977 tags: trunk) | |
|
2005-05-24
| ||
| 20:19 | Remove the config.h file from the build. Ticket #1224. (CVS 2480) (check-in: 3e64f1ab41 user: drh tags: trunk) | |
| 12:01 | Move a few things around to make building without the parser easier. (CVS 2479) (check-in: 5fadb464eb user: danielk1977 tags: trunk) | |
|
2005-05-23
| ||
| 17:26 | The REGEXP operator is recognized. It tries to invoke a function named regexp() which does not exist in the native build. But users who want to can add an appropriate regexp() function using sqlite3_create_function(). (CVS 2478) (check-in: 42a626ace1 user: drh tags: trunk) | |
| 15:06 | Make sure that the use of a double-quoted string literal does not trick the optimizer into using a correlated subquery when a static subquery would suffice. (CVS 2477) (check-in: ef4059e3af user: drh tags: trunk) | |
| 13:00 | Retain the error string if an error is generated by SSE during a VACUUM. (CVS 2476) (check-in: f7b76d02e0 user: danielk1977 tags: trunk) | |
| 04:51 | Add pFetch variable (used by SSE) to sqlite3 structure. (CVS 2475) (check-in: 2a8ac86967 user: danielk1977 tags: trunk) | |
|
2005-05-22
| ||
| 20:30 | The cache_size pragma should not reset the synchronous pragma. Ticket #1260. (CVS 2474) (check-in: 2db2b32f26 user: drh tags: trunk) | |
| 20:12 | Never user a pointer to standard library routines malloc() and free(). This rule is to work around limitations of MSVC and the _fastcall calling convention. Ticket #1256. (CVS 2473) (check-in: a39c446726 user: drh tags: trunk) | |
| 19:21 | Fix a memory leak. Ticket #1259. (CVS 2472) (check-in: 254ac2213e user: drh tags: trunk) | |
| 10:44 | Add hook to register SSE user-functions. (CVS 2471) (check-in: 20bd303e8c user: danielk1977 tags: trunk) | |
| 06:49 | Allow schema objects beginning with sqlite_ to be created if the SQLITE_WriteSchema flag is set. (CVS 2470) (check-in: afc8ce42b6 user: danielk1977 tags: trunk) | |
|
2005-05-21
| ||
| 18:32 | Speed improvements as described by tickets #1257 and #1258. These changes help some but are nowhere near the 23% claimed in the tickets. (CVS 2469) (check-in: 3fa177c54a user: drh tags: trunk) | |
| 02:48 | More structure rearrangements for additional size reductions. Ticket #1253. (CVS 2468) (check-in: 6b6e525b29 user: drh tags: trunk) | |
|
2005-05-20
| ||
| 20:11 | Reorder structure fields to reduce code footprint. Ticket #1253. Need to do more of this. (CVS 2467) (check-in: 27025613bc user: drh tags: trunk) | |
| 20:01 | Do not allow the pagesize of :memory: databases to be changed. Silently ignore PRAGMA page_size=N requests for :memory: databases. Ticket #1144 and #1252. (CVS 2466) (check-in: f29a1d8826 user: drh tags: trunk) | |
| 19:36 | Comment changes in vdbeapi.c (CVS 2465) (check-in: ab7805fb2f user: drh tags: trunk) | |
| 09:40 | Fix memory leaks in Tcl user function interface. (CVS 2464) (check-in: f5d9a8061a user: danielk1977 tags: trunk) | |
|
2005-05-19
| ||
| 08:43 | Always use a more specific type (P3_FUNCDEF) instead of P3_POINTER as the P3 type of a vdbe instruction. (CVS 2463) (check-in: 79a41674be user: danielk1977 tags: trunk) | |
| 01:26 | Fix an array index that is out of bounds. Ticket #1251. (CVS 2462) (check-in: bcf87e4d16 user: drh tags: trunk) | |
|
2005-05-17
| ||
| 11:25 | Provide a compile-time parameter to set the default file creation permissions under Unix. Ticket #1247. (CVS 2461) (check-in: bfa55bec32 user: drh tags: trunk) | |
|
2005-05-16
| ||
| 22:37 | Fix an uninitialized variable. Ticket #1244. (CVS 2460) (check-in: 582cb77d72 user: drh tags: trunk) | |
| 02:13 | Modify documentation to explain default value of "pragma synchronous". No code changes. (CVS 2459) (check-in: 453014421e user: danielk1977 tags: trunk) | |
|
2005-05-11
| ||
| 14:28 | Change to the lemon parser suggested by Geert Janssen. Appears to have no impact on SQLite. (CVS 2458) (check-in: 6fda60083f user: drh tags: trunk) | |
|
2005-05-10
| ||
| 16:11 | Fix a typo in the CREATE TABLE documentation. (CVS 2457) (check-in: 748771a8ad user: drh tags: trunk) | |
|
2005-05-06
| ||
| 22:05 | Timing fix in the default busy handler. (CVS 2456) (check-in: 76090ed84c user: drh tags: trunk) | |
|
2005-05-05
| ||
| 18:14 | Patch to fix an alignment problem on sparc. Ticket #1234. (CVS 2455) (check-in: 240cce10d4 user: drh tags: trunk) | |
| 11:04 | Fix a datatype in trigger6.test that changed due to the previous check-in. (CVS 2454) (check-in: c2af7d2c94 user: drh tags: trunk) | |
| 10:30 | In the TCL interface, user-defined functions preserve the datatype returned by the Tcl procedure. (CVS 2453) (check-in: 99dcba1fb1 user: drh tags: trunk) | |
|
2005-05-03
| ||
| 12:30 | Make sure all data structures have 8-byte alignment - necessary for the sparc architecture and helpful on other 64-bit platforms. Ticket #1232. Also update some comments in build.c. (CVS 2452) (check-in: d9418851ce user: drh tags: trunk) | |
|
2005-05-01
| ||
| 22:52 | Remove the psAligned value from the BTree structure - the pageSize is now always aligned to an 8-byte boundary. Add comments on a confusing bit of code. Ticket #1231. (CVS 2451) (check-in: 535523e1be user: drh tags: trunk) | |
|
2005-04-29
| ||
| 02:10 | Prevent a segfault described by ticket #1229. (CVS 2450) (check-in: 0667eae9a9 user: drh tags: trunk) | |
|
2005-04-28
| ||
| 19:03 | Add hooks for the SSE extension. (CVS 2449) (check-in: 90f4cf2ad5 user: drh tags: trunk) | |
| 17:18 | Enhancements to allow for extensions. (CVS 2448) (check-in: 6863703abc user: drh tags: trunk) | |
| 12:06 | Fix an array index bug in the default busy callback handler. Ticket #1198. (CVS 2447) (check-in: 3cc14b7606 user: drh tags: trunk) | |
|
2005-04-22
| ||
| 02:38 | Remove some vestigal code. Add the experimental sqlite3_transfer_bindings() API. (CVS 2446) (check-in: 88b39436f0 user: drh tags: trunk) | |
|
2005-04-15
| ||
| 12:04 | Correctly store large integers. Ticket #1212. (CVS 2445) (check-in: 00e20690bb user: drh tags: trunk) | |
|
2005-04-08
| ||
| 19:48 | Added tests to exercise delete, insert, and update triggers on views (tkt #1169) (CVS 2444) (check-in: 6cd19ddcba user: kwel tags: trunk) | |
| 16:08 | Fixed stack growth in update trigger on views (tkt #1169) (CVS 2443) (check-in: 99fcd5561b user: kwel tags: trunk) | |
| 16:07 | Fixed stack growth in delete trigger on views (tkt #1169) (CVS 2442) (check-in: 1a757ba132 user: kwel tags: trunk) | |
|
2005-04-03
| ||
| 23:54 | Apply Tcl 'nullvalue' patch from Stefan Finzel. (CVS 2441) (check-in: 9906ae37b9 user: danielk1977 tags: trunk) | |
|
2005-04-01
| ||
| 16:29 | Documentation updates. (CVS 2440) (check-in: 7e6f688d46 user: drh tags: trunk) | |
| 10:47 | Make the ORDER BY clause return equal elements in the same order they were seen (a stable sort). It was returning them in exactly the reverse order. (CVS 2439) (check-in: e8391491a6 user: drh tags: trunk) | |
|
2005-03-31
| ||
| 22:26 | Add a "const" declaration to a constant. Fix a typo in a comment. (CVS 2438) (check-in: 67aaa26906 user: drh tags: trunk) | |
| 21:02 | Update comments and documentation to give the true maximum page size as 32K, not 64K as was previously (and erroneously) reported. Ticket #1194. (CVS 2437) (check-in: 58dd436b65 user: drh tags: trunk) | |
| 18:40 | Make sure integer primary keys larger than 2^31 are handled properly. Ticket #1188. (CVS 2436) (check-in: 1d04c2ab29 user: drh tags: trunk) | |
| 18:26 | Fix a memory leak in the TCL bindings. (CVS 2435) (check-in: c31ea6332f user: drh tags: trunk) | |
|
2005-03-29
| ||
| 23:34 | Fix a problem with threads and the global database list in main.c. (CVS 2434) (check-in: 4aa05d2251 user: danielk1977 tags: trunk) | |
| 13:37 | Version 3.2.1 (CVS 2433) (check-in: 844f01af72 user: drh tags: trunk) | |
| 13:19 | Change the date of the 3.2.1 release. (CVS 2432) (check-in: afa42e2fa4 user: drh tags: trunk) | |
| 13:18 | Fix minor display bugs in sqlite3_analyzer. (CVS 2431) (check-in: d89aaba5b0 user: drh tags: trunk) | |
| 13:17 | Fix a C++-ism in the code. (CVS 2430) (check-in: 312587acf9 user: drh tags: trunk) | |
| 13:07 | Change 'stack' to the more descriptive 'no-push' in vdbe.c. (CVS 2429) (check-in: 7e54d3c728 user: danielk1977 tags: trunk) | |
| 08:26 | Reduce the space allocated for the runtime virtual machine stack. (CVS 2428) (check-in: 7d6818da33 user: danielk1977 tags: trunk) | |
| 03:10 | Add the SQLITE_OMIT_TEMPDB compile time macro. (CVS 2427) (check-in: c41d55443c user: danielk1977 tags: trunk) | |
| 02:54 | Fix segfault due to exception handler being run with uninitialised variable. (CVS 2426) (check-in: 78df3d0404 user: danielk1977 tags: trunk) | |
|
2005-03-28
| ||
| 18:04 | Fix another memory leak in the pager. (CVS 2425) (check-in: 4ca11ca015 user: drh tags: trunk) | |
| 16:56 | Increment version number and update documentation in preparation for version 3.2.1. (CVS 2424) (check-in: b0409b9310 user: drh tags: trunk) | |
| 16:50 | Changes to alter3.test to allow it to work with a codec. (CVS 2423) (check-in: 9e856bab2b user: drh tags: trunk) | |
| 08:44 | Modifications to reduce memory consumption. (CVS 2422) (check-in: 0fd5ce4eef user: danielk1977 tags: trunk) | |
| 03:39 | Fix some memory leaks that occur after a malloc failure. (CVS 2421) (check-in: bcb5d72ef1 user: drh tags: trunk) | |
| 00:07 | Use SQL function substr() correctly from ALTER TABLE code. Ticket #1182. (CVS 2420) (check-in: ccb9f4022b user: danielk1977 tags: trunk) | |
|
2005-03-27
| ||
| 01:56 | Correctly allocate new columns array in ALTER TABLE .. ADD COLUMN. Ticket #1183. (CVS 2419) (check-in: 3c86e63389 user: danielk1977 tags: trunk) | |
|
2005-03-23
| ||
| 01:48 | Fix a typo in vdbeInt.h. This was potentially a serious mistake, but we got lucky and it is benign. (CVS 2418) (check-in: f0d64dc8aa user: drh tags: trunk) | |
| 01:05 | Fix typo in the formatchng.html document. (CVS 2417) (check-in: 35ace66f3e user: drh tags: trunk) | |
|
2005-03-21
| ||
| 19:51 | Version 3.2.0 (CVS 2415) (check-in: debf40e8ff user: drh tags: trunk) | |
| 19:48 | Documentation changes prior to the release of version 3.2.0. (CVS 2416) (check-in: cc5a2c8e5d user: drh tags: trunk) | |
| 04:04 | Add function to recover from a malloc() failure. (CVS 2414) (check-in: 1f9d10d796 user: danielk1977 tags: trunk) | |
| 03:53 | Assorted fixes to the handling of various malloc() failures. (CVS 2413) (check-in: e7844a01c2 user: danielk1977 tags: trunk) | |
| 01:31 | Update docs to say that the default_synchronous pragma has been removed. Ticket #1049. (CVS 2412) (check-in: 21012bba17 user: drh tags: trunk) | |
| 01:24 | fix typo in CREATE VIEW documentation. Ticket #1135. (CVS 2411) (check-in: 38897a509a user: drh tags: trunk) | |
| 01:20 | Fix an infinite loop in the code generator for INSERT. Ticket #1140. (CVS 2410) (check-in: 876d09d914 user: drh tags: trunk) | |
| 00:47 | README file updated to suggest running "make install". Ticket #1168. (CVS 2409) (check-in: b48784cf65 user: drh tags: trunk) | |
| 00:43 | Allow the character "T" between date and time in ISO-8601 date/time formats. Ticket #1170. (CVS 2408) (check-in: 2bf88daa57 user: drh tags: trunk) | |
| 00:36 | Improved support for cygwin. Ticket #1165. (CVS 2407) (check-in: fcb5cee440 user: drh tags: trunk) | |
| 00:28 | Fix a formatting error in the syntax documentation. Ticket #1145. (CVS 2406) (check-in: 59892be6a4 user: drh tags: trunk) | |
|
2005-03-20
| ||
| 23:18 | Fix for ticket #1167 (CVS 2405) (check-in: d9aa0aa9ae user: drh tags: trunk) | |
| 22:54 | Do not attempt to read the journal file on windows because manditory locking on windows will not allow it. Ticket #1166. (CVS 2404) (check-in: 1865e0d81c user: drh tags: trunk) | |
| 22:47 | More changes for ticket #1171 after additional analysis. (CVS 2403) (check-in: 0471d6b86f user: drh tags: trunk) | |
| 19:10 | Tentative fix for ticket #1171. More research and testing needed. (CVS 2402) (check-in: f0a39cee78 user: drh tags: trunk) | |
|
2005-03-19
| ||
| 15:10 | More documentation updates. (CVS 2401) (check-in: f065b6102d user: drh tags: trunk) | |
| 14:45 | Preparations for the release of version 3.2.0. (CVS 2400) (check-in: 90a00e9066 user: drh tags: trunk) | |
| 03:41 | Fix typos in documentation. (CVS 2399) (check-in: aee888ca58 user: drh tags: trunk) | |
| 01:41 | Updates to comments and documentation. No changes to code. (CVS 2398) (check-in: e53c77268c user: drh tags: trunk) | |
|
2005-03-18
| ||
| 14:03 | Remove unused code from util.c. Enhance the trace output in os_unix.c. (CVS 2397) (check-in: f2f31919fd user: drh tags: trunk) | |
|
2005-03-17
| ||
| 12:33 | Fixed a typo in alter3.test. (CVS 2396) (check-in: 698be25d3e user: drh tags: trunk) | |
| 07:00 | Don't run the tests in alter3.test if SQLITE_OMIT_ALTERTABLE is defined. (CVS 2395) (check-in: 800fb3bf06 user: danielk1977 tags: trunk) | |
| 05:06 | Update to keyword list for ALTER TABLE ... ADD COLUMN command. (CVS 2394) (check-in: 173e26961f user: danielk1977 tags: trunk) | |
| 05:03 | Add the ALTER TABLE ... ADD COLUMN command. (CVS 2393) (check-in: 94185dd4f7 user: danielk1977 tags: trunk) | |
| 04:01 | Version 3.1.6 (CVS 2392) (check-in: 6a3f4e4be6 user: drh tags: trunk) | |
| 03:52 | Strengthen an assert() in vdbe.c. (CVS 2391) (check-in: 3f45cf3516 user: drh tags: trunk) | |
| 03:33 | Preparing for the release of 3.1.6. (CVS 2390) (check-in: 45cbf27e80 user: drh tags: trunk) | |
| 03:15 | Fix a bug in the calculation of the table record header size. Ticket #1163. (CVS 2389) (check-in: bf82a04ff7 user: drh tags: trunk) | |
|
2005-03-16
| ||
| 12:15 | Fix some memory leaks that can occur if a memory allocation fails. (CVS 2388) (check-in: 9a358fc33d user: danielk1977 tags: trunk) | |
|
2005-03-15
| ||
| 17:09 | When creating a new database, delete any preexisting journal that might be left over from a prior database with the same name. Ticket #1152. (CVS 2387) (check-in: 856e2ec968 user: drh tags: trunk) | |
| 02:04 | Allow the database name in a DETACH statement to be quoted. Ticket #1151. (CVS 2386) (check-in: 24e8877352 user: drh tags: trunk) | |
|
2005-03-14
| ||
| 02:01 | Be more aggressive about using the busy handler. Ticket #1159. (CVS 2385) (check-in: 644c6398e5 user: drh tags: trunk) | |
|
2005-03-12
| ||
| 18:03 | Fix typo in documentation. (CVS 2384) (check-in: 78012246fc user: drh tags: trunk) | |
| 15:55 | Documentation updates. Added the "distinctive features" page. (CVS 2383) (check-in: 33a0191638 user: drh tags: trunk) | |
|
2005-03-11
| ||
| 18:06 | Version 3.1.5 (CVS 2382) (check-in: b1792ae516 user: drh tags: trunk) | |
| 18:06 | Disable GNU readline in the build of the command-line shell for linux since some systems (ex: SuSE) do not support it. (CVS 2381) (check-in: baddb06450 user: drh tags: trunk) | |
| 17:55 | Updates to the homepage prior to 3.1.5. (CVS 2380) (check-in: c78611f620 user: drh tags: trunk) | |
| 17:52 | Fix bugs discovered in 3.1.4. F_FULLFSYNC not F_FULLSYNC. And a bug in "make doc". Also typos in the documentation. (CVS 2379) (check-in: 3c57a4571f user: drh tags: trunk) | |
| 04:53 | Version 3.1.4 (CVS 2378) (check-in: 3d070a9b4d user: drh tags: trunk) | |
| 04:41 | Fixes so that the FULLSYNC changes will build on windows. They do not have any effect, but neither do they cause errors. (CVS 2377) (check-in: ace3e30de1 user: drh tags: trunk) | |
| 04:40 | Increase the version number to 3.1.4. (CVS 2376) (check-in: e438b65cf9 user: drh tags: trunk) | |
| 04:39 | Documentation updates for version 3.1.4. (CVS 2375) (check-in: a7261f1590 user: drh tags: trunk) | |
|
2005-03-10
| ||
| 17:06 | Another case of returning SQLITE_CORRUPT when a corrupt database file is detected. (CVS 2374) (check-in: 8710192797 user: drh tags: trunk) | |
| 14:32 | Fix a problem with crashtest caused by the F_FULLSYNC change. (CVS 2373) (check-in: f11c6e7452 user: drh tags: trunk) | |
| 14:11 | Disable F_FULLSYNC if the sychronous pragma is not set to FULL. (CVS 2372) (check-in: 58b8733b96 user: drh tags: trunk) | |
| 12:58 | Disable the use of ./crashtest in builds that include a codec. (CVS 2371) (check-in: 7e4af62238 user: drh tags: trunk) | |
| 12:52 | Disable the alter2 tests if there is a codec compiled into the library. (CVS 2370) (check-in: 06a48da67b user: drh tags: trunk) | |
| 12:35 | Fix a #ifdef in util.c. (CVS 2369) (check-in: f426c625c4 user: drh tags: trunk) | |
|
2005-03-09
| ||
| 13:09 | Fix a file corruption bug in CREATE INDEX in auto-vacuum databases. (CVS 2368) (check-in: 64c4c717d3 user: danielk1977 tags: trunk) | |
| 12:26 | Support for a future ALTER TABLE command to add columns with default values. (CVS 2367) (check-in: 9d5abc1ddf user: danielk1977 tags: trunk) | |
|
2005-03-02
| ||
| 05:18 | Print an error message and quit if the regression tests are run as root. Ticket #1153. (CVS 2366) (check-in: 9b96078763 user: drh tags: trunk) | |
| 05:18 | Fix the header comment on experimental.c. (CVS 2365) (check-in: 0c4d2b11c9 user: drh tags: trunk) | |
|
2005-02-28
| ||
| 01:52 | Version 3.1.3.1 (not an official release) (CVS 2364) (check-in: 957333a7b2 user: drh tags: trunk) | |
| 01:42 | Bump the version number to 3.1.3.1. (CVS 2363) (check-in: 1ca8bbf749 user: drh tags: trunk) | |
|
2005-02-26
| ||
| 18:10 | Add the SQLITE_OMIT_FLAG_PRAGMAS compile-time option. (CVS 2362) (check-in: c167e90542 user: drh tags: trunk) | |
| 17:31 | Fix an assertion fault that can occur while autovacuuming a corrupt database file. Add the SQLITE_OMIT_COMPLETE compile-time parameter. (CVS 2361) (check-in: bb0e7e3857 user: drh tags: trunk) | |
|
2005-02-24
| ||
| 04:51 | Revised man page from Bill Bumgarner. (CVS 2360) (check-in: 5c99bea5a4 user: drh tags: trunk) | |
|
2005-02-23
| ||
| 12:35 | Remove strcasecmp from shell.c. Tickets #1108, #1122. (CVS 2359) (check-in: 4ae1a9fc2c user: drh tags: trunk) | |
| 00:26 | The script that cross-compiles the windows DLLs now exports the symbols Tclsqlite_Init and Sqlite_Init used to initialize the TCL extension. Ticket #1137. (CVS 2358) (check-in: f187047774 user: drh tags: trunk) | |
|
2005-02-22
| ||
| 09:47 | Fix bug reported on the mailing list for WHERE clauses like (rowid<'2'). (CVS 2357) (check-in: b323f0f283 user: danielk1977 tags: trunk) | |
|
2005-02-20
| ||
| 02:25 | Version 3.1.3 (CVS 2356) (check-in: 36dbf5e929 user: drh tags: trunk) | |
|
2005-02-19
| ||
| 13:46 | Prepare for the release of 3.1.3. (CVS 2355) (check-in: 5b66631fd4 user: drh tags: trunk) | |
| 13:05 | Rework parts of the pragma documentation. Ticket #1081. (CVS 2354) (check-in: 25141d9e21 user: drh tags: trunk) | |
| 12:44 | Add documentation on the EXISTS expression. Ticket #1082. (CVS 2353) (check-in: 76cacb4a39 user: drh tags: trunk) | |
| 12:32 | Remove duplicate word from documentation. Ticket #1103. (CVS 2352) (check-in: c1fc0a8aa9 user: drh tags: trunk) | |
| 08:18 | Support for a future file format that includes 'short' records. (CVS 2351) (check-in: 173aeb256e user: danielk1977 tags: trunk) | |
|
2005-02-18
| ||
| 01:15 | Fix typos in documentation for pragma short_column_names. Ticket #1130. (CVS 2350) (check-in: fac56fa1e0 user: danielk1977 tags: trunk) | |
|
2005-02-17
| ||
| 00:03 | Compile-time option to limit the size of AUTOINCREMENT rowids to 32-bits. (CVS 2349) (check-in: c5366deaf5 user: drh tags: trunk) | |
|
2005-02-16
| ||
| 23:43 | Clarify that columns are indexed from 0 when using sqlite3_column_XXX() APIs. No code changes. (CVS 2348) (check-in: d5eb25d8d0 user: danielk1977 tags: trunk) | |
| 03:45 | Change to configure.ac contributed by a reader. (CVS 2346) (check-in: 0cd3bf02d2 user: drh tags: trunk) | |
| 03:35 | Patch the command-line error message printing for lemon. Ticket #1120. (CVS 2345) (check-in: 97c7aaf187 user: drh tags: trunk) | |
| 03:27 | Get vacuum working on database that used to have autoincrement tables but where all such tables have been dropped. Ticket #1121. (CVS 2344) (check-in: 8f7c639da0 user: drh tags: trunk) | |
|
2005-02-15
| ||
| 21:36 | Move the special built-in SQL functions used by ALTER TABLE out of func.c and into alter.c. (CVS 2343) (check-in: dbd11a0c58 user: drh tags: trunk) | |
| 20:47 | Split the logic for the ALTER TABLE command off into a separate source code file. (CVS 2342) (check-in: 90d6573c26 user: drh tags: trunk) | |
| 16:23 | Btree checks the autovacuum flag after locking the database file. (CVS 2341) (check-in: 6610188f09 user: drh tags: trunk) | |
| 16:15 | Append the version number to the directory name in source code tarballs. Tickets #793, #855, and #1055. (CVS 2340) (check-in: 138577d0a5 user: drh tags: trunk) | |
| 13:38 | Fix a hyperlink bug on the homepage. (CVS 2338) (check-in: 9fd9d9fbee user: drh tags: trunk) | |
| 13:08 | Version 3.1.2 (CVS 2337) (check-in: e9012d917a user: drh tags: trunk) | |
| 13:07 | Updates to the script that generates the download page for the website. (CVS 2335) (check-in: 363590d37f user: drh tags: trunk) | |
| 12:56 | Update the change log. (CVS 2334) (check-in: 94c3f20e8c user: drh tags: trunk) | |
| 12:51 | Update the homepage prior to releases 2.8.16 and 3.1.2. (CVS 2333) (check-in: 603bbe47dd user: drh tags: trunk) | |
| 03:38 | Ensure a database file is not truncated without an exclusive lock. Fix for ticket #1114. (CVS 2332) (check-in: dcbc983355 user: danielk1977 tags: trunk) | |
| 02:54 | Check that read-only pages are not being modified (disabled by default). (CVS 2331) (check-in: 8514a4feb2 user: danielk1977 tags: trunk) | |
|
2005-02-14
| ||
| 20:48 | Make sure that when a CREATE INDEX fails, it does not leave a residue behind that can corrupt the database. Ticket #1115. (CVS 2330) (check-in: cbed92f397 user: drh tags: trunk) | |
| 06:38 | Tighten up the CREATE INDEX syntax accepted by the parser. (CVS 2329) (check-in: 41d2214b83 user: danielk1977 tags: trunk) | |
|
2005-02-13
| ||
| 23:34 | Update the version number in preparation for the release of 3.1.2. (CVS 2325) (check-in: f3c51de759 user: drh tags: trunk) | |
|
2005-02-12
| ||
| 08:59 | Fix a problem with sub-queries and the flattening optimization. Also handle an extra case of database corruption. (CVS 2324) (check-in: f7858d8830 user: danielk1977 tags: trunk) | |
| 00:19 | Fix a problem with VACUUM that can lead to database corruption. (CVS 2323) (check-in: 63894baf1b user: drh tags: trunk) | |
|
2005-02-09
| ||
| 07:05 | Return SQLITE_BUSY if the database is locked reading the schema within sqlite_prepare(). Ticket #1106. (CVS 2322) (check-in: c33c02d606 user: danielk1977 tags: trunk) | |
| 03:20 | Add experimental collation_list pragma. (CVS 2321) (check-in: f73a8aa34a user: danielk1977 tags: trunk) | |
| 01:40 | Document SQLITE_DEFAULT_CACHE_SIZE and SQLITE_DEFAULT_TEMP_CACHE_SIZE macros. (CVS 2320) (check-in: ddcea6f889 user: danielk1977 tags: trunk) | |
|
2005-02-08
| ||
| 08:42 | Fix a buggy interaction between "INSERT ... SELECT" processing and optimization (2170). (CVS 2319) (check-in: c54ad21236 user: danielk1977 tags: trunk) | |
| 07:50 | Fix for correlated subqueries where the parent is an aggregate. Ticket #1105. (CVS 2318) (check-in: f0d3ca10c5 user: danielk1977 tags: trunk) | |
|
2005-02-06
| ||
| 02:45 | Add the (highly experimental) omit_readlock pragma that disables the use of readlocks on read-only databases that are connected using ATTACH. (CVS 2317) (check-in: 2155448d21 user: drh tags: trunk) | |
|
2005-02-05
| ||
| 12:48 | Allow expressions (including variables) in LIMIT and OFFSET clauses. Ticket #1096. (CVS 2316) (check-in: 515e5033a5 user: danielk1977 tags: trunk) | |
| 07:33 | Add a numeric version number. Ticket #1097. (CVS 2315) (check-in: a9c33a804d user: danielk1977 tags: trunk) | |
| 06:49 | Detect database corruption in rootpage flags (see also (2313)). (CVS 2314) (check-in: 6d91a1e91b user: danielk1977 tags: trunk) | |
|
2005-02-04
| ||
| 21:13 | Detect and report a subtle case of database file corruption. (CVS 2313) (check-in: 9fc0a5cbf8 user: drh tags: trunk) | |
| 04:07 | Remove code for SQL cursors. (CVS 2312) (check-in: 2eb9087055 user: danielk1977 tags: trunk) | |
|
2005-02-03
| ||
| 01:08 | Get AUTOINCREMENT and VACUUM working together. Ticket #1095. (CVS 2311) (check-in: 332a531d06 user: drh tags: trunk) | |
| 00:42 | Fix the ".dump" command in the shell so that it works with AUTOVACUUM. This is related to ticket #1095. (CVS 2310) (check-in: 76c4a96c5a user: drh tags: trunk) | |
| 00:29 | Make sure the rc variable in OsWrite of os_win.c is always initialized. Also assert that the amt parameter is always greater than zero. Ticket #1094. (CVS 2309) (check-in: 4b399ae779 user: drh tags: trunk) | |
|
2005-02-02
| ||
| 01:13 | Fix a comment in sqlite3.h. No code changes. Ticket #1093. (CVS 2308) (check-in: d1ea2fb70b user: danielk1977 tags: trunk) | |
| 01:10 | Handle "rowid<=X ORDER BY rowid DESC" where X is an integer. Fix for ticket #1092. (CVS 2307) (check-in: 506088796c user: danielk1977 tags: trunk) | |
|
2005-02-01
| ||
| 17:05 | Version 3.1.1 (beta) (CVS 2306) (check-in: 2e1c71c468 user: drh tags: trunk) | |
| 15:57 | Increment the version number to 3.1.1beta. (CVS 2305) (check-in: 076f9868a4 user: drh tags: trunk) | |
| 10:36 | Space analyzer: Format integer results as integers. Also fix the calculation of average-fanout. (CVS 2304) (check-in: 52e473b946 user: danielk1977 tags: trunk) | |
| 10:35 | Have debugging code handle sqliteMalloc(n) where n<0 in the same way as production. (CVS 2303) (check-in: ab85e1d012 user: danielk1977 tags: trunk) | |
| 04:09 | More performance tweaking in the parser. (CVS 2302) (check-in: a3d12726bb user: drh tags: trunk) | |
| 03:46 | Fix an error introduced with (2299). (CVS 2301) (check-in: 22041d5f26 user: danielk1977 tags: trunk) | |
| 03:20 | Lemon optimization: When doing a shift following a reduce that pops one or more elements off the stack, no need to check for stack overflow. (CVS 2300) (check-in: adcd9a3fa2 user: drh tags: trunk) | |
| 03:09 | Avoid allocating a vdbe in sqlite3FinishCoding() if one has not been allocated already. (CVS 2299) (check-in: eaf1866e4d user: danielk1977 tags: trunk) | |
| 02:13 | Change to sqlite3AffinityType() to remove hex constants. (CVS 2298) (check-in: d8b4b0ef13 user: danielk1977 tags: trunk) | |
| 01:40 | Tweaks to the keyword hash generator. Tried to make it a little faster. If nothing else, the keyword hash table is now a little smaller. (CVS 2297) (check-in: 4eca6c05ab user: drh tags: trunk) | |
| 01:21 | Replace sqlite3AffinityType() with a slightly faster version. (CVS 2296) (check-in: abe9f5e81f user: danielk1977 tags: trunk) | |
|
2005-01-31
| ||
| 23:45 | Performance tweaks for sqlite3AffinityType. (CVS 2295) (check-in: 32b926154a user: drh tags: trunk) | |
| 12:56 | Move sqlite3HashNoCase to hash.c. (CVS 2294) (check-in: 5c10ccd8e9 user: danielk1977 tags: trunk) | |
| 12:42 | Assorted minor changes to speed up loading the database schema. (CVS 2293) (check-in: dfbd684a91 user: danielk1977 tags: trunk) | |
|
2005-01-30
| ||
| 22:10 | User-contributed chagnes to tclinstaller so that it supports DESTDIR. (CVS 2292) (check-in: ab8dbcf563 user: drh tags: trunk) | |
| 11:11 | Respect collation sequences in views. Ticket #1088. (CVS 2291) (check-in: 9843c0dd79 user: danielk1977 tags: trunk) | |
| 09:17 | Have the optimization introduced in (2170) deal with OP_NullRow as well as OP_Column and OP_Recno. Fix for #1086. (CVS 2290) (check-in: 356d31e03f user: danielk1977 tags: trunk) | |
|
2005-01-29
| ||
| 09:14 | Update to test files to support builds with OMIT macros defined. (CVS 2289) (check-in: 808e16a7dd user: danielk1977 tags: trunk) | |
| 09:00 | Fix a test bug causing a segfault in bind.test. (CVS 2288) (check-in: a8b921d45e user: danielk1977 tags: trunk) | |
| 08:36 | Update ioerr.test to be more deterministic. (CVS 2287) (check-in: d0b16bae65 user: danielk1977 tags: trunk) | |
| 08:32 | Modify sub-query handling. Tickets #1083 and #1084. (CVS 2286) (check-in: b1b50f3158 user: danielk1977 tags: trunk) | |
| 01:54 | Modification to schema.test so that it works with SQLITE_OMIT_TRIGGER and SQLITE_OMIT_UTF16 defined. (CVS 2285) (check-in: 95ecb2745f user: danielk1977 tags: trunk) | |
|
2005-01-28
| ||
| 01:29 | Make sure the #include of "sqliteInt.h" always comes first in C source files. (CVS 2284) (check-in: 522c094f79 user: drh tags: trunk) | |
|
2005-01-27
| ||
| 00:33 | Fix a warning introduced by (2280). (CVS 2283) (check-in: dc1b8106c4 user: danielk1977 tags: trunk) | |
| 00:33 | More changes to improve propagation of SQLITE_CORRUPT errors. (CVS 2282) (check-in: e4b5c16858 user: drh tags: trunk) | |
| 00:30 | Test that it is ok to execute ALTER TABLE immediately after opening a database connection. (CVS 2281) (check-in: 1d5ebb1146 user: danielk1977 tags: trunk) | |
| 00:22 | Have REINDEX handle missing collation sequences correctly. (CVS 2280) (check-in: 1c1904f443 user: danielk1977 tags: trunk) | |
|
2005-01-26
| ||
| 21:55 | Propagate detected database corruption up through the call stack. (CVS 2279) (check-in: 2c54aba5ba user: drh tags: trunk) | |
| 17:47 | An optimization to sqlite3VdbeSerialType(). (CVS 2278) (check-in: db36773830 user: drh tags: trunk) | |
| 10:39 | Add an entry to faq.tcl regarding SQLITE_SCHEMA errors. (CVS 2277) (check-in: 12defe8cd6 user: danielk1977 tags: trunk) | |
| 03:58 | Allow GROUP BY on non-aggregate queries. Ticket #1064 (CVS 2276) (check-in: 0642d3e3d6 user: danielk1977 tags: trunk) | |
|
2005-01-25
| ||
| 04:27 | Prevent collation sequences and user functions from being deleted or changed while SQL statements are executing. (CVS 2275) (check-in: cabab62bc1 user: danielk1977 tags: trunk) | |
|
2005-01-24
| ||
| 23:27 | Clarify documentation of DEFAULT CURRENT_TIME etc. (version 3.1.0 and greater only). (CVS 2274) (check-in: 557eb2ec9d user: danielk1977 tags: trunk) | |
| 13:03 | More test cases to do with invalidating precompiled statements. (CVS 2273) (check-in: b243681a0e user: danielk1977 tags: trunk) | |
| 12:46 | Use the cache with loading a large table in select2-2.0. (CVS 2272) (check-in: bd65b1805c user: drh tags: trunk) | |
| 10:25 | Modifications and bugfixes so that the test suite passes with the TCL statement cache turned on. (CVS 2271) (check-in: d5233e0747 user: danielk1977 tags: trunk) | |
| 01:38 | Flush the TCL statement cache before each lock_status pragma. (CVS 2270) (check-in: 8beae3ff8c user: drh tags: trunk) | |
| 00:28 | Change the TCL interface so that it can cache VMs and reuse them without recompiling. But for now leave the cache turned off by default. (CVS 2269) (check-in: 8db6bfef52 user: drh tags: trunk) | |
|
2005-01-23
| ||
| 23:43 | Modification to shell.c to avoid a compiler warning on some compilers. (CVS 2268) (check-in: 0778383b6f user: danielk1977 tags: trunk) | |
| 22:41 | Minor changes to avoid warnings on some compilers. (CVS 2267) (check-in: 4daf1d1f9d user: danielk1977 tags: trunk) | |
| 19:04 | Fix a bug in change counting that comes up when sqlite3_finalize() is called right after sqlite3_reset(). (CVS 2266) (check-in: 1a64295e05 user: drh tags: trunk) | |
| 13:14 | ATTACH and DETACH cause prepared statements to expire. sqlite3_finalize() can now be called right after sqlite3_reset(). (CVS 2265) (check-in: 6c631b86e5 user: drh tags: trunk) | |
|
2005-01-22
| ||
| 03:39 | Test script changes: Bug fix and cleanup on ioerr tests. Also, don't use TCL "file copy" command on windows. (CVS 2264) (check-in: 764b55adb5 user: danielk1977 tags: trunk) | |
| 03:03 | Add the experimental sqlite3_expired() API. (CVS 2263) (check-in: df648d50c0 user: drh tags: trunk) | |
|
2005-01-21
| ||
| 21:31 | Add <stddef.h> to sqliteInt.h. (CVS 2262) (check-in: fede252d19 user: drh tags: trunk) | |
| 21:22 | More documentation changes. Allow SQLITE_DEFAULT_CACHE_SIZE to set the default cache size for the pager at compile-time. (CVS 2261) (check-in: 2ddb674875 user: drh tags: trunk) | |
| 18:28 | Version 3.1.0 (alpha) (CVS 2260) (check-in: 45094abe38 user: drh tags: trunk) | |
| 18:19 | Documentation updates prior to 3.1.0. (CVS 2259) (check-in: fc4f1f13d0 user: drh tags: trunk) | |
| 17:53 | Initialize the random number generator from /dev/urandom, if available. (CVS 2258) (check-in: aab8e7f8d8 user: drh tags: trunk) | |
| 17:07 | Change to mkopcodeh.awk to accomodate windows systems. (CVS 2257) (check-in: 39786aa894 user: drh tags: trunk) | |
| 17:03 | Update change log for version 3.1.0. (CVS 2256) (check-in: 4d9b858746 user: drh tags: trunk) | |
| 15:52 | Final preparations for the 3.1.0 alpha release. (CVS 2255) (check-in: 17122c7e8e user: drh tags: trunk) | |
| 11:55 | Improve test coverage for minimum feature builds. (CVS 2254) (check-in: 9c4d0e13e8 user: danielk1977 tags: trunk) | |
| 08:13 | Exclude a few more lines of code using OMIT macros. (CVS 2253) (check-in: c6fc49e610 user: danielk1977 tags: trunk) | |
| 04:25 | Modify test scripts to work when SQLITE_OMIT_SUBQUERY (but no other OMIT macros) is defined. (CVS 2252) (check-in: d4e19efcef user: danielk1977 tags: trunk) | |
| 03:12 | Modify test scripts to work when SQLITE_OMIT_SUBQUERY (along with other OMIT macros) is defined. (CVS 2251) (check-in: bb0254ab14 user: danielk1977 tags: trunk) | |
| 02:34 | Add a new test file for subqueries. (CVS 2250) (check-in: de8ee3a29e user: drh tags: trunk) | |
| 00:44 | Change the implementation of ALTER TABLE so that it does not use the IN() operattor. (CVS 2249) (check-in: 06887afb32 user: danielk1977 tags: trunk) | |
| 00:22 | Fix a segfault that occurs on a corrupt database. (CVS 2248) (check-in: d1166472fd user: drh tags: trunk) | |
|
2005-01-20
| ||
| 23:23 | Fix comment typo in mkopcodec.awk. (CVS 2247) (check-in: 6177148260 user: drh tags: trunk) | |
| 22:48 | Bug fixes and enhancements entered while on jury recess. (CVS 2246) (check-in: 38401dfbd5 user: drh tags: trunk) | |
| 13:36 | Added the SQLITE_OMIT_SUBQUERY compile-time option and the EXISTS operator. Regression tests are currently failing with an assertion fault. (CVS 2245) (check-in: d30fdf0f2c user: drh tags: trunk) | |
| 13:03 | Remove a few more lines of code when SQLITE_OMIT_** macros are defined. (CVS 2244) (check-in: 417bbba93a user: danielk1977 tags: trunk) | |
| 11:32 | Extend the influence of a couple of SQLITE_OMIT_** macros a little bit. (CVS 2243) (check-in: 5b1a9bf6aa user: danielk1977 tags: trunk) | |
| 05:24 | Changes so that crash.test works when SQLITE_OMIT_PAGER_PRAGMAS is defined. (CVS 2242) (check-in: f0add0a60e user: danielk1977 tags: trunk) | |
| 02:17 | Fix some test scripts so that they work with a minimal build configuration. (CVS 2241) (check-in: d267fb3ca3 user: danielk1977 tags: trunk) | |
| 02:14 | Turn SQLITE_OMIT_CURSOR on by default. (CVS 2240) (check-in: 2d3ab1ab5a user: drh tags: trunk) | |
| 01:51 | Expression generator bug fix. (CVS 2239) (check-in: 39cf97a902 user: drh tags: trunk) | |
| 01:17 | Minor fix for sqlite3_clear_bindings(). (CVS 2238) (check-in: ff5b338cfb user: danielk1977 tags: trunk) | |
| 01:14 | Add the experimental sqlite3_sleep() and sqlite3_clear_bindings() APIs. (CVS 2237) (check-in: 9480209e86 user: danielk1977 tags: trunk) | |
|
2005-01-19
| ||
| 23:24 | Continued refactoring of the name resolution logic and query optimizer. (CVS 2236) (check-in: d8b2a7e091 user: drh tags: trunk) | |
| 03:52 | Another fix along the same lines as (2234) (CVS 2235) (check-in: 27cf83224c user: danielk1977 tags: trunk) | |
| 03:47 | A few test cases were failing on windows due to mandatory locking. Omit them on that platform. (CVS 2234) (check-in: 441316f1af user: danielk1977 tags: trunk) | |
|
2005-01-18
| ||
| 17:40 | Make sure USING and NATURAL work on joins even if the columns are renamed using an AS phrase. Ticket #523. (CVS 2233) (check-in: c06add57bf user: drh tags: trunk) | |
| 17:20 | CREATE TABLE ... AS ... uses short names for columns. Ticket #1036. (CVS 2232) (check-in: b1d4c42d2b user: drh tags: trunk) | |
| 16:02 | Column names coming back from a SELECT are now just the name of the source column without the "table." prefix. In other words, "PRAGMA short_column_names=ON" is now the default. This makes the names of columns behave more like other SQL engines. The old behavior can be restored by setting "PRAGMA short_column_names=OFF". (CVS 2231) (check-in: 9295050af1 user: drh tags: trunk) | |
| 14:45 | Continue refactoring name resolution. Fix for ticket #1047. (CVS 2230) (check-in: 88d4834fec user: drh tags: trunk) | |
| 04:00 | Refinements to the name resolution logic. Change the name of the keywordhash.c file to keywordhash.h. (CVS 2229) (check-in: 0142ae6f00 user: drh tags: trunk) | |
|
2005-01-17
| ||
| 22:08 | Infrastructure changes to handle name resolution differently. This is needed to fix various long-standing problems with column names in joins. It will also make the implementation of correlated subqueries easier. (CVS 2228) (check-in: 4a7534396a user: drh tags: trunk) | |
| 08:57 | Fix a bug reported on the mailing list concerning a conflict between "INSERT INTO ... SELECT" statements and the "SELECT max(x) FROM tbl" optimization. (CVS 2227) (check-in: 5a9da62ae3 user: danielk1977 tags: trunk) | |
| 07:53 | Fix some memory leak problems with corrupt.test and auto-vacuum databases. (CVS 2226) (check-in: 6244252915 user: danielk1977 tags: trunk) | |
| 03:42 | Add incomplete, preliminary drafts of new documentation. (CVS 2225) (check-in: a01159e8cb user: drh tags: trunk) | |
| 03:40 | Fix a memory leak that occurs as a result of an IO error. (CVS 2224) (check-in: 1edfdcbf14 user: danielk1977 tags: trunk) | |
| 02:12 | Change some assert()s that could fail if the database is corrupt to return SQLITE_CORRUPT instead. (CVS 2223) (check-in: 2d58c0afa7 user: danielk1977 tags: trunk) | |
| 01:33 | Have sqlite3pager_get() return SQLITE_CORRUPT for a page number greater than 2^31. (CVS 2222) (check-in: feb49d10e8 user: danielk1977 tags: trunk) | |
|
2005-01-16
| ||
| 23:21 | Turn on quick-balance by default. (CVS 2221) (check-in: d0356dee55 user: drh tags: trunk) | |
| 20:47 | Drop support for MAC OS9. SQLite 3 has never worked for that OS because the developers do not have access to a machine running it and nobody from the community has stepped forward to provide a port. By moving the os_mac.c file into the attic, we make the lack of support official. (CVS 2220) (check-in: de9ad673d0 user: drh tags: trunk) | |
| 11:07 | Changes to make sure tests work when SQLITE_DEFAULT_AUTOVACUUM is defined. (CVS 2219) (check-in: 6237c294d1 user: danielk1977 tags: trunk) | |
| 09:06 | Fixes so that compiling and testing works when SQLITE_OMIT_AUTOVACUUM is defined. (CVS 2218) (check-in: fe548561a0 user: danielk1977 tags: trunk) | |
| 08:00 | Move duplicate code to update pointer-map wrt overflow pages into a function. (CVS 2217) (check-in: a5c2121410 user: danielk1977 tags: trunk) | |
|
2005-01-15
| ||
| 12:45 | Enhance the performance of auto-vacuum databases by reducing the number of pointer-map entries written during tree balancing. Also fix bugs in balance_quick(). (CVS 2216) (check-in: 0ae29538cc user: danielk1977 tags: trunk) | |
| 01:52 | Test coverage improvements. (CVS 2215) (check-in: 92f9d2b2f4 user: drh tags: trunk) | |
| 00:40 | Improved test coverage for update.c. (CVS 2214) (check-in: 3ef95d5fe9 user: drh tags: trunk) | |
| 00:36 | Improved coverage for insert.c. (CVS 2213) (check-in: 997d8afff9 user: drh tags: trunk) | |
|
2005-01-14
| ||
| 22:55 | Add comments to the new balance_quick() routine. (CVS 2212) (check-in: 183c42eac8 user: drh tags: trunk) | |
| 13:50 | Experimental patch to balance() (use -DSQLITE_BALANCE_QUICK). (CVS 2211) (check-in: c550d80c25 user: danielk1977 tags: trunk) | |
| 01:22 | Improved test coverage on insert.c. (CVS 2210) (check-in: c772f75166 user: drh tags: trunk) | |
|
2005-01-13
| ||
| 23:54 | Need SQLITE_MEMDEBUG instead of SQLITE_DEBUG in tclsqlite.c. (CVS 2209) (check-in: 6e905270a9 user: drh tags: trunk) | |
| 23:54 | Fix a bug in lemon that does not effect SQLite. Ticket #1068. (CVS 2208) (check-in: 7113b5ed8d user: drh tags: trunk) | |
| 13:35 | Tidy up malloc.test a bit. (CVS 2207) (check-in: 94cf91cc5d user: danielk1977 tags: trunk) | |
| 11:10 | Fix typo in shell .help. Ticket #1071. (CVS 2206) (check-in: 2c7a1a1698 user: danielk1977 tags: trunk) | |
| 11:07 | Test cases to improve coverage of pager.c. (CVS 2205) (check-in: 0428a14801 user: danielk1977 tags: trunk) | |
| 02:14 | Fixes to 'configure' build system. Also extra coverage for main.c. (CVS 2204) (check-in: 8378455f32 user: danielk1977 tags: trunk) | |
|
2005-01-12
| ||
| 13:04 | Fix a test bug introduce with the previous commit. (CVS 2203) (check-in: 1c19e8bdca user: danielk1977 tags: trunk) | |
| 12:44 | Tests to improve coverage of main.c. (CVS 2202) (check-in: 4e28c82ada user: danielk1977 tags: trunk) | |
| 09:10 | Tests to improve coverage of vdbeaux.c. (CVS 2201) (check-in: 2b3e21ce2e user: danielk1977 tags: trunk) | |
| 07:15 | Tests to improve coverage of vdbemem.c. (CVS 2200) (check-in: 319bb4a906 user: danielk1977 tags: trunk) | |
| 00:08 | Fix a bug in tclsqlite.c. (CVS 2199) (check-in: 50f1e22965 user: drh tags: trunk) | |
|
2005-01-11
| ||
| 18:13 | Fix for ticket #1062: Correctly handle redundant terms in a WHERE clause. (CVS 2198) (check-in: 1bee1bb91d user: drh tags: trunk) | |
| 17:59 | Allow '$' in the middle of identifiers. Ticket #1066. This is an experimental change. It might be backed out at a later date. (CVS 2197) (check-in: 00a352ea79 user: drh tags: trunk) | |
| 17:46 | Test coverage improvements on tokenize.c. (CVS 2196) (check-in: 5767850cca user: drh tags: trunk) | |
| 16:54 | Improved test coverage for vdbeaux.c. (CVS 2195) (check-in: 3f46cd7767 user: drh tags: trunk) | |
| 15:28 | Improved test coverage for util.c. (CVS 2194) (check-in: ad451a2ddc user: drh tags: trunk) | |
| 13:02 | Test cases to improve coverage of vdbe.c. (CVS 2193) (check-in: a6b4572207 user: danielk1977 tags: trunk) | |
| 11:08 | Remove a C++ style comment that went in with the previous commit. (CVS 2192) (check-in: ce8e4e885a user: danielk1977 tags: trunk) | |
| 10:25 | Test cases to improve coverage of btree.c (and minor bugfixes). (CVS 2191) (check-in: a37e0108de user: danielk1977 tags: trunk) | |
| 10:25 | Test cases to improve coverage of btree.c (and minor bugfixes). (CVS 2190) (check-in: 8ced491588 user: danielk1977 tags: trunk) | |
|
2005-01-10
| ||
| 12:59 | Extra test cases to improve coverage of btree.c (CVS 2189) (check-in: a461988661 user: danielk1977 tags: trunk) | |
| 06:39 | Update some documentation for version 3.1. (CVS 2188) (check-in: 5b7a5a4d69 user: danielk1977 tags: trunk) | |
| 02:48 | Fix an assertion failure due to interaction between the count_changes pragma and triggers. (CVS 2187) (check-in: 6c7bec1b3a user: danielk1977 tags: trunk) | |
|
2005-01-08
| ||
| 18:42 | Tcl interface does as sqlite3 or as sqlite. A compile-time option allows duel linking. Also fix a bug in the pragma change from earlier today. (CVS 2186) (check-in: ad10953799 user: drh tags: trunk) | |
| 15:44 | Fixes to the temp_store_directory pragma. (CVS 2185) (check-in: 0a90eaf398 user: drh tags: trunk) | |
| 15:43 | Fix a comment. (CVS 2184) (check-in: 26fbac8f03 user: drh tags: trunk) | |
| 12:42 | Fix a problem with auto-vacuum databases and the VACUUM command. Also add "pages read" and "pages written" statistics to the pager layer. (CVS 2183) (check-in: fb3bf68d0e user: danielk1977 tags: trunk) | |
| 02:35 | Minor test script changes to allow all.test to run when SQLITE_DEFAULT_AUTOVACUUM=1 is defined. (CVS 2182) (check-in: 5023b1dba2 user: danielk1977 tags: trunk) | |
|
2005-01-07
| ||
| 10:42 | Reset the temp_store_directory each iteration of tests in all.test. (CVS 2181) (check-in: 7373a5d4cf user: danielk1977 tags: trunk) | |
| 08:56 | Fix a read of invalid memory that could occur in btree.c. (CVS 2180) (check-in: 929745c183 user: danielk1977 tags: trunk) | |
| 01:56 | Remove incorrect assert() and add extra option to account for non-standard 'sort' program in some linux versions. (CVS 2179) (check-in: bf14387697 user: danielk1977 tags: trunk) | |
|
2005-01-03
| ||
| 21:28 | add --enable-debug to configure options, controls -DNDEBUG flag (CVS 2178) (check-in: 9d674d1dc0 user: tpoindex tags: trunk) | |
| 18:13 | add comment that table is accessed by primary key (CVS 2177) (check-in: 707690c5f2 user: tpoindex tags: trunk) | |
| 02:26 | Allow GROUP BY on aggregate queries only. Ticket #1039. (CVS 2176) (check-in: 8ef2c644eb user: drh tags: trunk) | |
| 01:33 | Fix typos in comments in test code. (Oops. This check-in also picked up some unrelated changes to documentation.) (CVS 2175) (check-in: 586acc85b1 user: drh tags: trunk) | |
| 01:28 | Fix a typo in a comment. No code changes. Ticket #1052. (CVS 2174) (check-in: 9fb1402f08 user: drh tags: trunk) | |
| 01:27 | Fix comment typos. no code changes. (CVS 2173) (check-in: 4165217e51 user: drh tags: trunk) | |
|
2004-12-25
| ||
| 01:03 | Fix ticket #1046 by removing code and simplifying the query optimizer. Remarkably, this simplification also makes the optimizer do a better job. Ticket #1051 was fixed as a side-effect. (CVS 2172) (check-in: 5fd1f47118 user: drh tags: trunk) | |
|
2004-12-20
| ||
| 19:01 | Add PRAGMA 'temp_store_directory'. Added os_*.c function sqlite3OsIsDirWritable(), split pragma.c changeTempStorage() function into invalidateTempStorage(). (CVS 2171) (check-in: 772e22cbd6 user: tpoindex tags: trunk) | |
|
2004-12-19
| ||
| 00:11 | The optimizer now uses only the index and ignores the table if it can get away with doing so, thus saving a single BTree search per row of result. This could potentially double the speed of certain queries. The code passes all regression tests but new tests to exercise the new functionality are yet to be added. (CVS 2170) (check-in: e5aa489453 user: drh tags: trunk) | |
|
2004-12-18
| ||
| 18:40 | Improvements to the query optimizer. This is a work in progress. (CVS 2169) (check-in: 9b86993ff7 user: drh tags: trunk) | |
|
2004-12-17
| ||
| 20:48 | Fix a C++-ism in the previous change to tclsqlite.c. (CVS 2168) (check-in: b49b8fdd11 user: drh tags: trunk) | |
| 15:41 | Add 'copy' method for tcl interface. Behaves similar to shell .import or COPY statment in 2.x. (CVS 2167) (check-in: a9311d9df0 user: tpoindex tags: trunk) | |
|
2004-12-16
| ||
| 21:09 | Make sure LIMITs are handled correctly on UNION operators. Ticket #1035. (CVS 2166) (check-in: ece0085f86 user: drh tags: trunk) | |
|
2004-12-14
| ||
| 03:34 | Minor code and comment cleanup. (CVS 2165) (check-in: d012628a78 user: drh tags: trunk) | |
|
2004-12-10
| ||
| 18:00 | Factor the test for zName==NULL out of the loop. Ticket #1032. (CVS 2164) (check-in: 7f38f67c7b user: drh tags: trunk) | |
| 17:17 | Fix a problem with the automatic generation of the opcode name table. (CVS 2163) (check-in: 9eefabc92d user: drh tags: trunk) | |
| 03:08 | Back out the USE_TCL_STUBS changes because it breaks the build. I think the strategy needs to be to abandon libtool and use tcl.m4 to figure out how to build our own shared libraries. Ticket #1034. (CVS 2162) (check-in: 7f4679b92e user: drh tags: trunk) | |
| 02:20 | Improvements to the --help option to configure. Ticket #1033. (CVS 2161) (check-in: 3032cc2b88 user: drh tags: trunk) | |
| 02:08 | Add a -DUSE_TCL_STUBS to the standard Makefile. This might help with ticket #1034. Or maybe not. (CVS 2160) (check-in: 4c30c373ef user: drh tags: trunk) | |
|
2004-12-09
| ||
| 18:29 | Enhance sqlite3_bind_parameter_index so that is does not segfault if you call it incorrectly by passing NULL in place of the parameter name. Ticket #1032. (CVS 2159) (check-in: bf81aabff1 user: drh tags: trunk) | |
|
2004-12-07
| ||
| 15:41 | Only evaluate expressions once for UPDATE and INSERT statements that have BEFORE triggers. Fix for ticket #980. (CVS 2158) (check-in: 4852186aca user: drh tags: trunk) | |
| 14:06 | Simplify the trigger logic for DELETE, INSERT, and UPDATE. (CVS 2157) (check-in: 8e164ab277 user: drh tags: trunk) | |
| 12:29 | Remove the unused sqlite3_context.isStep element. (CVS 2156) (check-in: 7b20f2b71f user: drh tags: trunk) | |
| 02:14 | Updates to API documentation and comments in sqlite3.h. (CVS 2155) (check-in: 46584348f3 user: drh tags: trunk) | |
|
2004-12-02
| ||
| 20:17 | Get the build of sqlite3_analyzer working with Makefile.in. (CVS 2154) (check-in: f7415a0d64 user: drh tags: trunk) | |
|
2004-11-27
| ||
| 15:52 | Disable the cursors. "make install" now builds and installs a TCL package for SQLite if TCL is installed on the system. (CVS 2153) (check-in: d75014c299 user: drh tags: trunk) | |
|
2004-11-25
| ||
| 13:50 | The configure script now automatically detects tclConfig.sh and builds the Tcl extension only if tclConfig.sh is present. The Tcl extension can be disabled using --disable-tcl. (CVS 2152) (check-in: 12424bef77 user: drh tags: trunk) | |
|
2004-11-24
| ||
| 01:16 | Fix a memory leak in pager.c. (CVS 2151) (check-in: 0ad4ed87ce user: drh tags: trunk) | |
|
2004-11-23
| ||
| 22:16 | fulltest runs now, but still finds a memory leak. (CVS 2150) (check-in: 5944d51e6c user: drh tags: trunk) | |
| 16:31 | Fix a memory leak in ALTER TABLE. (CVS 2149) (check-in: ba71716ce2 user: danielk1977 tags: trunk) | |
| 15:41 | Add authorization callbacks for REINDEX. (CVS 2148) (check-in: 9f0d744ee4 user: danielk1977 tags: trunk) | |
| 12:24 | Include the 'FOR' keyword in builds that include cursors but not triggers. (CVS 2147) (check-in: 3053d82d71 user: danielk1977 tags: trunk) | |
| 11:16 | Make the test suite pass when SQLITE_OMIT_SCHEMA_VERSION_PRAGMAS is defined. (CVS 2146) (check-in: ff20c623c6 user: danielk1977 tags: trunk) | |
| 10:52 | Ensure the test suite runs with SQLITE_OMIT_PAGER_PRAGMAS defined. (CVS 2145) (check-in: 2d1f0b923d user: danielk1977 tags: trunk) | |
| 10:13 | Have tests pass when SQLITE_OMIT_SCHEMA_PRAGMAS is defined. (CVS 2144) (check-in: 6ccb589bd9 user: danielk1977 tags: trunk) | |
| 09:06 | Fix a bug involving balance_shallow() and the sqlite_master table. (CVS 2143) (check-in: 557be3ff5b user: danielk1977 tags: trunk) | |
| 01:47 | More work on the implementation of cursors, but they are still not functioning. (CVS 2142) (check-in: 8b61d1ae1c user: drh tags: trunk) | |
|
2004-11-22
| ||
| 19:12 | Add initial infrastructure for cursors. In where.c, optimize out clauses of the form "ORDER BY rowid" if a table scan is being performed. Do a reverse table scan if "ORDER BY rowid DESC" is present. (CVS 2141) (check-in: fc8c1393c8 user: drh tags: trunk) | |
| 19:07 | Fix a long-standing bug in btree.c in the sqlite3BtreePrevious() routine. The problem has gone unnoticed before now because it only occurs when you use the OP_Prev opcode on a B+Tree. (CVS 2140) (check-in: 3d2536c479 user: drh tags: trunk) | |
| 15:05 | Fix a couple of extra test-suite problems with SQLITE_OMIT_VIEW. (CVS 2139) (check-in: 894c142d11 user: danielk1977 tags: trunk) | |
| 13:35 | Ensure tests pass when SQLITE_OMIT_COMPOUND_SELECT is defined. (CVS 2138) (check-in: 007be591b7 user: danielk1977 tags: trunk) | |
| 11:51 | Ensure tests pass when SQLITE_OMIT_TRIGGER is defined. (CVS 2137) (check-in: 53894988ac user: danielk1977 tags: trunk) | |
| 10:20 | Fix a test-suite error made in check-in (2132) (CVS 2136) (check-in: 48c7eb7fb9 user: danielk1977 tags: trunk) | |
| 10:02 | Back out changes allowing writes to tables that have open cursors. (CVS 2135) (check-in: ec6b48f4b2 user: danielk1977 tags: trunk) | |
| 10:02 | Back out changes allowing writes to tables that have open cursors. (CVS 2134) (check-in: af635cab8a user: danielk1977 tags: trunk) | |
| 10:02 | Back out changes allowing writes to tables that have open cursors. (CVS 2133) (check-in: 91acd87e52 user: danielk1977 tags: trunk) | |
| 08:43 | Modify test suite to work when SQLITE_OMIT_VIEW is defined. (CVS 2132) (check-in: 711e8d7695 user: danielk1977 tags: trunk) | |
| 05:26 | Have tests pass when SQLITE_OMIT_MEMORYDB is defined. (CVS 2131) (check-in: 9df837c039 user: danielk1977 tags: trunk) | |
| 03:34 | Fix auth.test to work when SQLITE_OMIT_ALTERTABLE is defined. (CVS 2130) (check-in: 27a8379b54 user: danielk1977 tags: trunk) | |
|
2004-11-21
| ||
| 01:02 | AUTOINCREMENT documentation added. Improvements to lang.html. (CVS 2129) (check-in: ac72a1d551 user: drh tags: trunk) | |
|
2004-11-20
| ||
| 21:02 | Fix to the documentation on sqlite3_create_function. Ticket #899. (CVS 2128) (check-in: 4ab1d012f0 user: drh tags: trunk) | |
| 20:44 | Avoid excess heap usage when copying expressions. Ticket #979. (CVS 2127) (check-in: d10560c752 user: drh tags: trunk) | |
| 20:31 | Correct use of usableSize versus pageSize in btree.c. Ticket #1010. (CVS 2125) (check-in: 5a4013ec9c user: drh tags: trunk) | |
| 20:18 | Better error message on an SQLITE_RANGE error. Ticket #991. (CVS 2124) (check-in: accd432e4d user: drh tags: trunk) | |
| 19:55 | Rename source file sqlite.1 as sqlite3.1. Ticket #995. (CVS 2123) (check-in: 297559c6d1 user: drh tags: trunk) | |
| 19:18 | Omit the maximum loop count on the random name chooser in the VACUUM command. Add a comment to explain why this is safe and does not result in an infinite loop. Ticket #1009. (CVS 2122) (check-in: 1241086f23 user: drh tags: trunk) | |
| 19:18 | Rig the sqliteMalloc() routine so that we can make it fail multiple times in a row. Modify the malloc.test procedure to make malloc fail in this way and verify that the failures are still handled correctly. (CVS 2121) (check-in: 519bc9d997 user: drh tags: trunk) | |
| 18:13 | Fix segfaults that might occur after a malloc failure. (CVS 2119) (check-in: 368774487e user: drh tags: trunk) | |
| 08:17 | Documentation for REINDEX and ALTER TABLE commands. (CVS 2118) (check-in: aceaa5f6e9 user: danielk1977 tags: trunk) | |
| 06:05 | Add a documentation page for compilation options. Still some work to go. (CVS 2117) (check-in: 5efa2d2a60 user: danielk1977 tags: trunk) | |
|
2004-11-19
| ||
| 11:59 | Split up the lang.html page into a seperate page for each command. (CVS 2116) (check-in: ea315668e5 user: danielk1977 tags: trunk) | |
| 08:41 | Ensure ALTER TABLE respects the system table convention - "sqlite_*". (CVS 2115) (check-in: f635b6aae6 user: danielk1977 tags: trunk) | |
| 08:02 | Update the sqlite_sequence table when a table is renamed with ALTER_TABLE. (CVS 2114) (check-in: 6e97186880 user: danielk1977 tags: trunk) | |
| 07:07 | When dropping a table, update the sqlite_sequence table first, as auto-vacuum mode may need to move sqlite_sequence when the btree table is dropped. (CVS 2113) (check-in: 0514107bff user: danielk1977 tags: trunk) | |
| 05:14 | Fix bugs in ALTER TABLE related to (a) whitespace in table defn, (b) temp triggers. (CVS 2112) (check-in: 1fd8e835a3 user: danielk1977 tags: trunk) | |
|
2004-11-18
| ||
| 15:44 | Handle triggers correctly in ALTER TABLE. (CVS 2111) (check-in: c61b7de107 user: danielk1977 tags: trunk) | |
| 13:49 | Speed improvement on the LIKE command. (CVS 2110) (check-in: 85d56beb74 user: drh tags: trunk) | |
| 02:10 | Fix an obsolete comment that resulted in incorrect documentation. Ticket #1003. (CVS 2109) (check-in: c93a9e18d2 user: drh tags: trunk) | |
| 02:04 | Clarify the documentation of the sqlite3_create_function API. Ticket #1004. (CVS 2108) (check-in: ae45ad863b user: drh tags: trunk) | |
|
2004-11-17
| ||
| 16:41 | Add the ESCAPE clause to the LIKE operator. Not fully tested yet. (CVS 2107) (check-in: 49268c2b7a user: danielk1977 tags: trunk) | |
| 10:22 | Extra tests and resulting bugfixes for btree cursors. (CVS 2106) (check-in: e1530854c9 user: danielk1977 tags: trunk) | |
|
2004-11-16
| ||
| 23:21 | Clarify the LIMIT clause in the documentation. Ticket #1002. (CVS 2105) (check-in: e05f52d907 user: drh tags: trunk) | |
| 15:50 | Perform deletes in a single pass. (CVS 2104) (check-in: a2e1c35b32 user: danielk1977 tags: trunk) | |
| 04:57 | Allow btree cursors to persist through BtreeDelete() calls. (CVS 2103) (check-in: 6ad5fc8e1a user: danielk1977 tags: trunk) | |
|
2004-11-15
| ||
| 23:42 | Fix a typo in the header comment to the MakeRecord opcode so that the documentation generator will actually see the opcode description. Ticket #1001. (CVS 2102) (check-in: 33c9b647aa user: drh tags: trunk) | |
| 01:40 | Add test cases for escape characters in the GLOB operator. (CVS 2101) (check-in: bb2d9ff881 user: drh tags: trunk) | |
|
2004-11-14
| ||
| 21:56 | The SQLITE_OMIT_UTF16 macro now removes lots of code and all tests still pass. (CVS 2100) (check-in: 98c7a55478 user: drh tags: trunk) | |
| 04:04 | Changes toward reducing code size when SQLITE_OMIT_UTF16 is enabled. (CVS 2099) (check-in: 59a0a8b7ce user: drh tags: trunk) | |
|
2004-11-13
| ||
| 15:59 | More compile-time options for removing components. (CVS 2098) (check-in: dcbc0c22cf user: drh tags: trunk) | |
| 13:19 | Code toward having btree cursors persist when their table is written too. Doesn't work properly yet. (CVS 2097) (check-in: 5eaa18d43f user: danielk1977 tags: trunk) | |
| 03:59 | Fix the keyword generator so that it works with SQLITE_OMIT_ALTERTABLE. (CVS 2096) (check-in: 60ace9985d user: drh tags: trunk) | |
| 03:48 | Autoincrement is now working and has regression tests. (CVS 2095) (check-in: 10c712a219 user: drh tags: trunk) | |
|
2004-11-12
| ||
| 16:12 | Change pragmas schema_cookie and user_cookie to schema_version and user_version. (CVS 2094) (check-in: 5e05831844 user: danielk1977 tags: trunk) | |
| 15:53 | Add authorization callbacks to ALTER TABLE. (CVS 2093) (check-in: c4115aa3a1 user: danielk1977 tags: trunk) | |
| 13:42 | Add the "ALTER TABLE xxx RENAME TO yyy" command. (CVS 2092) (check-in: a1b2cc63e6 user: danielk1977 tags: trunk) | |
| 03:56 | Autoincrement code installed. Simple smoke-testing only. No regression tests developed yet. (CVS 2091) (check-in: 8fde833c81 user: drh tags: trunk) | |
|
2004-11-11
| ||
| 19:32 | Website updates. (CVS 2090) (check-in: 60fb0cef09 user: drh tags: trunk) | |
| 05:10 | Add the schema_cookie and user_cookie pragmas. (CVS 2089) (check-in: d28d1d68e5 user: danielk1977 tags: trunk) | |
| 01:50 | Add documentation for DEFAULT CURRENT_TIME & co. (CVS 2088) (check-in: c85f13f8f2 user: danielk1977 tags: trunk) | |
|
2004-11-10
| ||
| 15:27 | Ensure the test suite can run with either SQLITE_OMIT_AUTOVACUUM or SQLITE_DEFAULT_AUTOVACUUM=1 defined. (CVS 2087) (check-in: 0747b55882 user: danielk1977 tags: trunk) | |
| 12:34 | Fix expr.test so that it works when the date-time functions are compiled out of the library. (CVS 2086) (check-in: 540ce7de1b user: danielk1977 tags: trunk) | |
| 11:55 | Ensure tables cannot be created/dropped when btree cursors are open. (CVS 2085) (check-in: 8e5c2e5df8 user: danielk1977 tags: trunk) | |
| 05:48 | Add user documentation for the "pragma auto_vacuum" command. (CVS 2084) (check-in: fe200eaf37 user: danielk1977 tags: trunk) | |
|
2004-11-09
| ||
| 16:13 | Have "DEFAULT CURRENT_TIME" & co. work even if SQLITE_OMIT_DATETIME_FUNCS is defined. (CVS 2083) (check-in: f81b9c1c02 user: danielk1977 tags: trunk) | |
| 12:44 | Port the "DEFAULT CURRENT_TIME" etc. functionality from an earlier fork of sqlite. (CVS 2082) (check-in: 0d27c8ff48 user: danielk1977 tags: trunk) | |
| 07:42 | Refactor the space-analysis script for readability. (CVS 2081) (check-in: 63f2ee22e2 user: danielk1977 tags: trunk) | |
|
2004-11-08
| ||
| 16:15 | Update the space-analyzer tool to support auto-vacuum databases. (CVS 2080) (check-in: 1cb8086612 user: danielk1977 tags: trunk) | |
| 12:32 | A few more auto-vacuum tests. (CVS 2079) (check-in: 9d4a60bbd6 user: danielk1977 tags: trunk) | |
| 09:51 | Check in the file autovacuum_crash.test that should be part of the previous check-in. (CVS 2078) (check-in: 9d7cd1f732 user: danielk1977 tags: trunk) | |
| 09:26 | Test auto-vacuum mode for crash-proofness. Also fix a bug related to the same. (CVS 2077) (check-in: 839ad771a6 user: danielk1977 tags: trunk) | |
| 07:13 | Auto-vacuum: Account for the page reserved for windows locking (PENDING_BYTE). (CVS 2076) (check-in: d633569869 user: danielk1977 tags: trunk) | |
|
2004-11-07
| ||
| 13:01 | Reindex tests added and bugs fixed. (CVS 2075) (check-in: ad433ec2b6 user: drh tags: trunk) | |
|
2004-11-06
| ||
| 12:26 | Auto-vacuum: Ensure pages to be removed by database truncation are in the journal file. Also fix an sqlite3pager_movepage() bug. (CVS 2074) (check-in: 081676e491 user: danielk1977 tags: trunk) | |
| 00:02 | Compile and pass the quick regression tests with autovacuum disabled. (CVS 2073) (check-in: 89b9026a53 user: drh tags: trunk) | |
|
2004-11-05
| ||
| 23:46 | First cut at a REINDEX command. Basic testing only. No documentation. (CVS 2072) (check-in: 11dba47e61 user: drh tags: trunk) | |
| 22:18 | Use sqlite3NestedParse to implement DROP INDEX. (CVS 2071) (check-in: 0f81aa5b05 user: drh tags: trunk) | |
| 20:58 | Use sqlite3NestedParse to implement CREATE INDEX. (CVS 2070) (check-in: 47d8ebdaad user: drh tags: trunk) | |
| 17:17 | Create table now works with sqlite3NestedParse. This changed uncovered a latent bug in xprintf which is also fixed. (CVS 2069) (check-in: b0506bdd70 user: drh tags: trunk) | |
| 16:37 | Do not truncate a database file until after fsync() has been called on the journal. (CVS 2068) (check-in: cfee7f4a00 user: danielk1977 tags: trunk) | |
| 15:45 | Make auto-vacuum a run-time option (default determined by SQLITE_DEFAULT_AUTOVACUUM macro). (CVS 2067) (check-in: b9d5f007fc user: danielk1977 tags: trunk) | |
| 12:58 | Auto-vacuum bug: Don't set meta(3) to a pointer-map page number when deleting a table. (CVS 2066) (check-in: 44a015b3a3 user: danielk1977 tags: trunk) | |
| 12:27 | Fix allocation of tables in an auto-vacuum database when the required root-page is on the free-list. (CVS 2065) (check-in: 4e2433378e user: danielk1977 tags: trunk) | |
| 09:19 | Don't code an OP_Statement within sqlite3NestedParse(). Also a correction to the UPDATE statement used within destroyRootPage(). (CVS 2064) (check-in: fdcc31f0c6 user: danielk1977 tags: trunk) | |
| 06:02 | When using sqlite3NestedParse() to modify the sqlite_master table, do not code OP_Callback. (CVS 2063) (check-in: 296a298c48 user: danielk1977 tags: trunk) | |
| 05:23 | Another bug fix from two check-ins ago. (CVS 2062) (check-in: c46eef2f6d user: drh tags: trunk) | |
| 05:20 | Fix a bug in the previous check-in. (CVS 2061) (check-in: 9d259d48de user: drh tags: trunk) | |
| 05:10 | More use of sqlite3NestedParse. This version of the code does not work. (CVS 2060) (check-in: ac2d5a605c user: drh tags: trunk) | |
| 03:56 | Begin using sqlite3NestedParse() to generate sections of code. (CVS 2059) (check-in: 2d302931a6 user: drh tags: trunk) | |
| 01:45 | Fix bug introduced with (2057). (CVS 2058) (check-in: aed2e623ec user: danielk1977 tags: trunk) | |
| 01:24 | Pop the value pushed by OP_Destroy if SQLITE_OMIT_AUTOVACUUM is defined. (CVS 2057) (check-in: b0c103340a user: danielk1977 tags: trunk) | |
| 00:43 | Incremental check-in of changes that will ultimately lead to a working autoincrement. (CVS 2056) (check-in: 10c3d88305 user: drh tags: trunk) | |
|
2004-11-04
| ||
| 14:47 | All tests pass when SQLITE_OMIT_INTEGRITY_CHECK is defined. (CVS 2055) (check-in: 158a2d16a8 user: drh tags: trunk) | |
| 14:30 | Support root-page allocation/deallocation in auto-vacuum databases. Still a few problems. (CVS 2054) (check-in: 1da361fae8 user: danielk1977 tags: trunk) | |
| 04:42 | All tests pass even if OMIT_TRIGGER is defined. (CVS 2053) (check-in: c33b3a6137 user: drh tags: trunk) | |
| 04:34 | Fix a #ifdef in util.c. Ticket #984. (CVS 2052) (check-in: da045bd183 user: drh tags: trunk) | |
| 02:57 | Add support for table allocation (not deallocation) in auto-vacuum databases. (CVS 2051) (check-in: 571de52376 user: danielk1977 tags: trunk) | |
|
2004-11-03
| ||
| 16:27 | Update tests to work even if some features of the library are disabled. (CVS 2050) (check-in: b11fc9b3f3 user: drh tags: trunk) | |
| 13:59 | More work on optionally removing unused features at compile-time. (CVS 2049) (check-in: a82980fd70 user: drh tags: trunk) | |
| 11:37 | Auto-vacuum bug: Deallocate pointer-map pages when shrinking a database file. (CVS 2048) (check-in: bec6a65aca user: danielk1977 tags: trunk) | |
| 09:30 | Comment the autovacuum.test script. No code or test-case changes. (CVS 2047) (check-in: 2eacd38620 user: danielk1977 tags: trunk) | |
| 08:44 | Auto-vacuum bug: Correctly manipulate page cache hash-table entries in sqlite3pager_movepage(). (CVS 2046) (check-in: 719c1b7967 user: danielk1977 tags: trunk) | |
| 03:59 | The makefile now runs mkkeywordhash.c. Keywords that are unused are omitted from the keyword hash table. (CVS 2045) (check-in: 007aec1133 user: drh tags: trunk) | |
| 03:52 | Auto-vacuum bugfix: Do not attempt to move a pointer-map page during auto-vacuum. (CVS 2044) (check-in: bd50fbb5fe user: danielk1977 tags: trunk) | |
| 03:01 | Fix an auto-vacuum bug that occurs when a btree cell is promoted to the parent page during a delete. (CVS 2043) (check-in: b7d953e119 user: danielk1977 tags: trunk) | |
|
2004-11-02
| ||
| 18:15 | Fix a problem in the pragma.test script. (CVS 2041) (check-in: a2c9c45c80 user: drh tags: trunk) | |
| 18:05 | Get btree.c to compile with -DNDEBUG=1. (CVS 2040) (check-in: 8378c144c1 user: drh tags: trunk) | |
| 14:40 | Fix an auto-vacuum bug for btree entries that span more than one overflow page. (CVS 2039) (check-in: 40249ed19c user: danielk1977 tags: trunk) | |
| 14:24 | Require that the page size be a power of 2. (CVS 2038) (check-in: c33b34dbe9 user: drh tags: trunk) | |
| 12:56 | Code to auto-vacuum the database if all root pages happen to be in the right place. Not active by default and largely untested. (CVS 2037) (check-in: d12481f09c user: danielk1977 tags: trunk) | |
|
2004-11-01
| ||
| 16:03 | Updates to the support.html page. (CVS 2036) (check-in: 5515accee3 user: drh tags: trunk) | |
|
2004-10-31
| ||
| 16:25 | Add code to create/update the btree 'pointer-map' for auto-vacuum mode. (CVS 2035) (check-in: bebd967f36 user: danielk1977 tags: trunk) | |
| 02:22 | Insert #ifdefs that can optionally remove features at compiletime resulting in a database engine with a smaller footprint. (CVS 2034) (check-in: be661acfa8 user: drh tags: trunk) | |
|
2004-10-30
| ||
| 20:23 | Begin adding the ability to remove unused features at compile-time and still have all the tests pass. (CVS 2033) (check-in: 2aa506ccb0 user: drh tags: trunk) | |
|
2004-10-26
| ||
| 16:34 | Move affinity.html into the attic. (CVS 2032) (check-in: 87a3c668f0 user: drh tags: trunk) | |
| 16:33 | Mark the affinity.html file as obsolete. (CVS 2031) (check-in: 09de96b6b2 user: drh tags: trunk) | |
| 00:08 | Fix a bug in the ".databases" command of the command-line shell. Ticket #973 (CVS 2030) (check-in: 507d8e6f5c user: drh tags: trunk) | |
|
2004-10-25
| ||
| 20:33 | Minor optimizations in the pragma module. (CVS 2029) (check-in: 63efd50a16 user: drh tags: trunk) | |
|
2004-10-23
| ||
| 05:10 | Tighter encoding of the keyword hash table in the tokenizer. (CVS 2028) (check-in: 7b9886f8d4 user: drh tags: trunk) | |
|
2004-10-22
| ||
| 20:29 | Add the experimental and scary pragma "writable_schema". (CVS 2027) (check-in: 39f7870a54 user: drh tags: trunk) | |
| 16:22 | Fix alignment problems in btree and pager and allow page sizes that are not a multiple of 8. (CVS 2026) (check-in: 0539c2d2b8 user: drh tags: trunk) | |
|
2004-10-19
| ||
| 16:40 | Reinsert code deleted by (1998) that we thought was unused but was in fact needed. Fix for ticket #966. (CVS 2025) (check-in: 370ca53950 user: drh tags: trunk) | |
| 01:31 | Fix a typo in the quickstart document. (CVS 2024) (check-in: 55b03c560d user: drh tags: trunk) | |
|
2004-10-18
| ||
| 21:34 | Fix typos in the names of some regression tests. Ticket #962. (CVS 2023) (check-in: 77542beb31 user: drh tags: trunk) | |
|
2004-10-12
| ||
| 02:38 | Fix typo on homepage. Ticket #956. (CVS 2022) (check-in: 552ec6770a user: drh tags: trunk) | |
| 00:56 | Version 3.0.8 (CVS 2021) (check-in: 7dd66d7653 user: drh tags: trunk) | |
| 00:50 | Updates to the README file (CVS 2020) (check-in: d3d0d7a8bb user: drh tags: trunk) | |
|
2004-10-11
| ||
| 22:26 | Increment the version number. Prepare for release of version 3.0.8. (CVS 2019) (check-in: ff04d7d48b user: drh tags: trunk) | |
| 21:49 | Fix typo on the homepage. (CVS 2018) (check-in: 7f190f85e2 user: drh tags: trunk) | |
| 21:48 | Fix typo in the lockingv3.html page on the website. (CVS 2017) (check-in: a31b647727 user: drh tags: trunk) | |
|
2004-10-10
| ||
| 19:11 | The mkopcodeh.awk script removes \r for use with msys. Ticket #954. (CVS 2016) (check-in: c4fb44fd5f user: drh tags: trunk) | |
| 18:00 | Documentation updates (CVS 2015) (check-in: a4546c09d7 user: drh tags: trunk) | |
| 17:24 | Typos and spelling errors in documention. (CVS 2014) (check-in: 16e2ace2db user: drh tags: trunk) | |
|
2004-10-09
| ||
| 15:54 | New links on the common header page of the website. (CVS 2013) (check-in: 6d6246f150 user: drh tags: trunk) | |
|
2004-10-07
| ||
| 22:22 | Sort the output of glob in test script attach2.test. Ticket #948. (CVS 2012) (check-in: 3d04eef9b7 user: drh tags: trunk) | |
| 19:03 | Optimizations to the tokenizer. (CVS 2011) (check-in: e5540ce047 user: drh tags: trunk) | |
| 03:06 | Additional parser optimizations. (CVS 2010) (check-in: 618dee121e user: drh tags: trunk) | |
| 00:32 | In the command-line shell in CSV move, put strings in C-style double-quotes. Ticket #911. (CVS 2009) (check-in: 1376a0bb8d user: drh tags: trunk) | |
|
2004-10-06
| ||
| 15:52 | Fix naming conflict between sqlite.h and sqlite3.h. Ticket #946. (CVS 2007) (check-in: 3037041263 user: drh tags: trunk) | |
| 15:41 | Convert many constants to have type "const". (CVS 2006) (check-in: d790c84c5a user: drh tags: trunk) | |
| 15:03 | Move some work out of the makefiles and into awk scripts in separate files. Ticket #940. (CVS 2005) (check-in: 4d0f29d54c user: drh tags: trunk) | |
| 14:39 | Size optimization in the parser. (CVS 2004) (check-in: 8e2ae24498 user: drh tags: trunk) | |
| 14:39 | Fix the ".import" command of the command-line shell so that it ignores \n and \r at the end of a line. Ticket #939. (CVS 2003) (check-in: dcbf4817a7 user: drh tags: trunk) | |
|
2004-10-05
| ||
| 17:37 | Rearrange memory allocation in sqlite3VdbeMakeReady to try to work around some byte-alignment problems on Sparc. (CVS 2002) (check-in: f623d6e74f user: drh tags: trunk) | |
| 15:42 | Use the database name supplied to table_info() and related pragmas. (CVS 2001) (check-in: 0415af3257 user: drh tags: trunk) | |
| 02:41 | Add support for DEFERRED, IMMEDIATE, and EXCLUSIVE transactions. (CVS 2000) (check-in: 81ff8107ad user: drh tags: trunk) | |
|
2004-10-04
| ||
| 13:38 | More changes to take advantage of the TK_ and OP_ alignments to avoid unnecessary translations. (CVS 1999) (check-in: e8e972ba65 user: drh tags: trunk) | |
| 13:19 | Save about 800 bytes of code space by aligning TK_ and OP_ constants so that we do not have to translate between them. (CVS 1998) (check-in: 4c817e3f29 user: drh tags: trunk) | |
|
2004-10-02
| ||
| 20:38 | Fixes to the OsUnlock() interface. Correctly leave a SHARED lock behind when requested. Honor the error code that OsUnlock() returns. Ticket #913 and #938. (CVS 1997) (check-in: c4697503d0 user: drh tags: trunk) | |
|
2004-10-01
| ||
| 18:21 | make diskfull test work on Windows; see check-in (1994) (CVS 1996) (check-in: 4493e28780 user: dougcurrie tags: trunk) | |
| 14:38 | Additional code to test the SQLITE_FULL return when the disk is full. (CVS 1994) (check-in: 44e56f0bba user: drh tags: trunk) | |
| 03:02 | Fully release exclusive locks in the Unlock primitive of Unix. Ticket #913. (CVS 1993) (check-in: 11a37a74b1 user: drh tags: trunk) | |
| 02:00 | Use type i64 instead of off_t for file offsets since off_t is giving portability problems. Ticket #924. (CVS 1992) (check-in: 8972c004dc user: drh tags: trunk) | |
|
2004-09-30
| ||
| 14:24 | Strict prototype on sqlite3_libversion(). Ticket #936 (CVS 1991) (check-in: 1d3c6f7351 user: drh tags: trunk) | |
| 14:22 | Correctly parser column typenames that contain more than one identifier. Ticket #934. (CVS 1990) (check-in: 85ad18712d user: drh tags: trunk) | |
| 13:43 | Allow functions to be created when there are outstanding VMs. (Ticket #926) Fix problems with sqlite3_errcode(). Add tests for sqlite3_errcode(). (CVS 1989) (check-in: d0f1dc5898 user: drh tags: trunk) | |
|
2004-09-27
| ||
| 13:19 | Comment changes in btree.c. No changes to code. (CVS 1988) (check-in: b15abf984f user: drh tags: trunk) | |
| 12:20 | Bug fix in btree.c in cases where usableSize!=pageSize. Ticket #925. (CVS 1987) (check-in: cb3e12372d user: drh tags: trunk) | |
|
2004-09-25
| ||
| 15:29 | Remove unused CLUSTER keyword from the parser. (CVS 1986) (check-in: 54ee1664aa user: drh tags: trunk) | |
| 15:25 | Optimizations in the tokenizer. (CVS 1985) (check-in: 26898c57cb user: drh tags: trunk) | |
| 14:39 | Code cleanup: get rid of the sqlite3SetNString utility function. (CVS 1984) (check-in: 9ef4c24a9a user: drh tags: trunk) | |
| 13:12 | Code simplifications and size reductions. (CVS 1983) (check-in: cb631a135d user: drh tags: trunk) | |
|
2004-09-24
| ||
| 23:59 | Size optimizations in vdbeapi.c. (CVS 1982) (check-in: b2f3d4bb8e user: drh tags: trunk) | |
| 23:20 | Save a few bytes in utf.c. (CVS 1981) (check-in: 8154d545e8 user: drh tags: trunk) | |
| 22:32 | Optimizations to vdbeaux.c and printf.c (CVS 1980) (check-in: eabc77c99b user: drh tags: trunk) | |
| 19:39 | Improvements to the debugging code. (CVS 1979) (check-in: bdc3bb070f user: drh tags: trunk) | |
| 12:50 | Fix typo in ".help" output from the shell. Ticket #914. (CVS 1978) (check-in: 1ee3a787ad user: drh tags: trunk) | |
| 12:48 | Avoid a segfault in sqlite3_bind_parameter_index when there are unnamed parameters. Ticket #918. (CVS 1977) (check-in: 49f25ddf83 user: drh tags: trunk) | |
| 12:24 | Simplification of the trigger code. (CVS 1976) (check-in: 9fa904d94e user: drh tags: trunk) | |
| 12:24 | Fix for tickets #912 and #922. Problem introduced by check-in (1973). (CVS 1975) (check-in: 9001e2220d user: drh tags: trunk) | |
|
2004-09-20
| ||
| 14:57 | Pthread is now conditionally included in makefile, see ticket #910 (CVS 1974) (check-in: a35e522769 user: dougcurrie tags: trunk) | |
|
2004-09-19
| ||
| 02:15 | Add comments to unused P3 fields of selected instructions when NDEBUG is not defined. This makes VDBE program dumps more readable during debugging. (CVS 1973) (check-in: 4871c77f8f user: drh tags: trunk) | |
| 00:50 | Merge the ListPush and ListPop VDBE opcodes into ContextPush and ContextPop. (CVS 1972) (check-in: eb9b501ad8 user: drh tags: trunk) | |
|
2004-09-18
| ||
| 18:51 | Fix typo on homepage. (CVS 1971) (check-in: 5d3b3a96bc user: drh tags: trunk) | |
| 18:45 | Version 3.0.7 (CVS 1970) (check-in: d82ded9543 user: drh tags: trunk) | |
| 18:00 | Up the version number and prepare documentation files for the 3.0.7 release. (CVS 1969) (check-in: 63e4ed3cc6 user: drh tags: trunk) | |
|
2004-09-17
| ||
| 21:35 | Always include -lpthread on link lines even if it is not needed. (CVS 1968) (check-in: 46a96890f7 user: drh tags: trunk) | |
| 21:07 | Make use of $(libdir) in the Makefile.in. Ticket #904. (CVS 1967) (check-in: 10b5e51733 user: drh tags: trunk) | |
| 20:47 | Create directories using "mkdir -p". Ticket #903. (CVS 1966) (check-in: 02de1cf95e user: drh tags: trunk) | |
| 20:46 | Close stray statements prior to finishing trace.test, to avoid a file descriptor leak. (CVS 1965) (check-in: 8bb0221da8 user: drh tags: trunk) | |
| 20:25 | The page_size pragma preserves the reserved area at the end of each page. (CVS 1964) (check-in: c34f3209e5 user: drh tags: trunk) | |
| 20:02 | Get VACUUM working on databases that have reserved bytes at the end of each page. (CVS 1963) (check-in: 90bb3af6cd user: drh tags: trunk) | |
| 19:39 | Fix a bug in the test3.c module that was causing failures in btree5.test. (CVS 1962) (check-in: cd200cf833 user: drh tags: trunk) | |
| 17:23 | The INSERT code generator does a better job of detecting if the table being written into is used in the SELECT on the right-hand side. ticket #901. (CVS 1961) (check-in: 709bb22d6d user: drh tags: trunk) | |
|
2004-09-15
| ||
| 13:38 | The callback on sqlite3_trace() is invoked the first time sqlite3_step() is called after sqlite3_prepare() or sqlite3_reset(). Ticket #900. (CVS 1960) (check-in: 0cc2f40e6a user: drh tags: trunk) | |
|
2004-09-13
| ||
| 13:46 | Remove the encode/decode from the version 3.0 source tree. (CVS 1959) (check-in: c1f1320be5 user: drh tags: trunk) | |
| 13:16 | The TCL interface responds correctly to "break", "continue", and "return" inside of the script of an eval statement. (CVS 1958) (check-in: dd62224ae8 user: drh tags: trunk) | |
| 13:13 | Fix an uninitialized variable bug in nullif(). Ticket #898. (CVS 1957) (check-in: ee335b501c user: drh tags: trunk) | |
|
2004-09-10
| ||
| 00:14 | In lemon, allows open() using the "b" option to avoid \r problems on windows. Ticket #897. (CVS 1956) (check-in: b5b2e3db09 user: drh tags: trunk) | |
|
2004-09-09
| ||
| 14:01 | Fix lemon so that inserted code always ends in a newline. Ticket #895. (CVS 1955) (check-in: 13fba17e3f user: drh tags: trunk) | |
| 13:55 | Fix a segfault in the authorizer when it is given a SELECT statement with no FROM clause. Ticket #896. (CVS 1954) (check-in: 97d63b9290 user: drh tags: trunk) | |
| 00:35 | Trying to get some tests in printf.test to pass on 64-bit systems. (CVS 1952) (check-in: b12fc46dcd user: drh tags: trunk) | |
|
2004-09-08
| ||
| 21:12 | Update the makefile so that util.c gets the -DSQLITE_DEBUG=1 flag when building the test fixture. (CVS 1951) (check-in: 8d0c9a8d94 user: drh tags: trunk) | |
| 20:13 | More changes directed at getting things to work on 64-bit platforms. (CVS 1950) (check-in: 5a3f823c14 user: drh tags: trunk) | |
| 20:13 | More changes directed at getting things to work on 64-bit platforms. (CVS 1949) (check-in: 39755d2166 user: drh tags: trunk) | |
| 15:09 | Always cast 0 to (char*)0 when it is an argument in a varargs function. (CVS 1948) (check-in: a1f532520c user: drh tags: trunk) | |
| 13:07 | Add new APIs to sqlite3.def: sqlite3_bind_parameter_name and sqlite3_bind_parameter_index. (CVS 1947) (check-in: ff256fb528 user: drh tags: trunk) | |
| 13:06 | Documentation updates. (CVS 1946) (check-in: 799f5383c0 user: drh tags: trunk) | |
|
2004-09-07
| ||
| 16:19 | Wildcards with the same name map into the same variable number. New api sqlite3_bind_parameter_index() added to map wildcard names into wildcard index numbers. Support for "?nnn" wildcards. (CVS 1945) (check-in: 435b3f301f user: drh tags: trunk) | |
| 13:20 | Fix the onecolumn method in the TCL interface so that it works the same as the eval method in all ways except for returning just the first value in the result set. (CVS 1944) (check-in: f323e4f86a user: drh tags: trunk) | |
| 11:28 | Lemon escapes backslashes in filenames in #line directives it generates. Ticket #892. (CVS 1943) (check-in: d53047cbbc user: drh tags: trunk) | |
|
2004-09-06
| ||
| 17:34 | Fix more name collisions. Allow sqlite.h and sqlite3.h to both be included in the same C/C++ source file. (CVS 1942) (check-in: 23e5bed1c5 user: drh tags: trunk) | |
| 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) (check-in: 3ddf5a9d1c user: drh tags: trunk) | |
|
2004-09-05
| ||
| 23:23 | Comment changes and minor code cleanup. (CVS 1940) (check-in: dfa9ea89c4 user: drh tags: trunk) | |
| 00:33 | Make VACUUM work when the page size is different than the default 1024. Ticket #890. (CVS 1939) (check-in: fa82becae7 user: drh tags: trunk) | |
|
2004-09-03
| ||
| 23:32 | Fix a comment. (CVS 1938) (check-in: af44ddeea1 user: drh tags: trunk) | |
| 18:38 | Modify btree.c so that is allocates big data structures using malloc() instead of allocating from the stack. Stack allocations cause problems for embedded systems and pthreads implementations that only allocate a limited amount of stack space. (CVS 1937) (check-in: 4595292f93 user: drh tags: trunk) | |
| 00:27 | More tests of sqlite3_step() and SQLITE_BUSY added. (CVS 1936) (check-in: 9e6645dd78 user: drh tags: trunk) | |
|
2004-09-02
| ||
| 16:53 | Fix a typo in the "News" on the homepage. (CVS 1935) (check-in: 45d7158878 user: drh tags: trunk) | |
| 16:45 | Version 3.0.6 (beta) (CVS 1934) (check-in: c190b95c30 user: drh tags: trunk) | |
| 16:36 | Update version number and documentation for version 3.0.6. (CVS 1933) (check-in: 67370926e3 user: drh tags: trunk) | |
| 15:53 | Address some minor 32/64 bit issues. (CVS 1932) (check-in: 6c9be972c1 user: drh tags: trunk) | |
| 15:49 | Fix a bug in the pagesize test script. (CVS 1931) (check-in: 1cf05bc607 user: drh tags: trunk) | |
| 15:27 | Fix VACUUM so that it works on files whose name contains '. Ticket #873 (CVS 1930) (check-in: 8dd938e480 user: drh tags: trunk) | |
| 15:14 | Fix a problem with EXPLAIN on pragmas that return single integer values. Ticket #886 (CVS 1929) (check-in: 8ce3d730b0 user: drh tags: trunk) | |
| 14:57 | Transactions commit on the last sqlite3_step(), not on sqlite3_finalize(). This allows the sqlite3_step() to return SQLITE_BUSY if the commit is blocked by a lock. Ticket #885. (CVS 1928) (check-in: d1b2915655 user: drh tags: trunk) | |
|
2004-09-01
| ||
| 16:12 | Work around a bug in the Borland C++ compiler. Ticket #881. (CVS 1927) (check-in: 18af6ba580 user: drh tags: trunk) | |
| 03:06 | Optimizations on the SELECT code generator. (CVS 1926) (check-in: 9c411c3c8d user: drh tags: trunk) | |
|
2004-08-31
| ||
| 23:41 | Changes to support compiling under windows. (CVS 1925) (check-in: 68a712f372 user: drh tags: trunk) | |
| 13:45 | Simplifications and optimizations. Also: disable the corrupt.test for now. (CVS 1924) (check-in: 8fd65e7048 user: drh tags: trunk) | |
| 00:52 | Combine the implementation of LIKE and GLOB into a single parameterized function. (CVS 1923) (check-in: 0a47c8f86d user: drh tags: trunk) | |
|
2004-08-30
| ||
| 16:52 | Better detection and handling of corrupt database files. (CVS 1922) (check-in: 8f5b199e84 user: drh tags: trunk) | |
| 14:58 | Documentation updates (CVS 1921) (check-in: 9322c439c5 user: drh tags: trunk) | |
| 14:22 | Remove the \001 character that lemon inserts automatically in its output file. The need for this character has expired and it creates confusion for users. Ticket #877 (CVS 1920) (check-in: acfc59186a user: drh tags: trunk) | |
| 01:54 | Modify the sqlite shell program so that the ".dump" command does not give up if it encounters an SQLITE_CORRUPT error. It tries to keep going in order to extract as much information as it can from the corrupt database. (CVS 1919) (check-in: d3f3acb77f user: drh tags: trunk) | |
|
2004-08-29
| ||
| 23:42 | Change the name of the global variable to sqlite3_temp_directory to avoid a naming conflict with version 2.8. (CVS 1918) (check-in: 431f7436a6 user: drh tags: trunk) | |
| 20:08 | Fix a bug in the NOCASE collating function. (CVS 1917) (check-in: 32c2974af6 user: drh tags: trunk) | |
| 18:14 | Version 3.0.5 (beta) (CVS 1916) (check-in: f3fe8c9fa6 user: drh tags: trunk) | |
| 18:14 | Adjustments to the download.html page generator script. (CVS 1915) (check-in: a6dc133139 user: drh tags: trunk) | |
| 17:52 | Increase the version number and update the change log in preparation for the release of version 3.0.5. (CVS 1914) (check-in: 69922aabb5 user: drh tags: trunk) | |
| 17:30 | Back out an optimization that was causing problems in UTF-16 databases. (CVS 1913) (check-in: 988cb064ab user: drh tags: trunk) | |
| 16:25 | Corrections to transient table handling in compound select statments. Tickets #826 and #875. (CVS 1912) (check-in: 9cc765be46 user: drh tags: trunk) | |
| 01:31 | Progress toward fixing iproblems with compound selects. (CVS 1911) (check-in: 307478593d user: drh tags: trunk) | |
|
2004-08-28
| ||
| 18:21 | Add prototype in sqlite3.h for the sqlite3_libversion() function. (CVS 1910) (check-in: d50c47b499 user: drh tags: trunk) | |
| 18:17 | Memory handling fixes and optimizations in the VDBE. Ticket #862. (CVS 1909) (check-in: 5f8d246852 user: drh tags: trunk) | |
| 16:19 | Add the sqlite3_libversion() API (ticket #834). Fix the build scripts to correctly build the shared libraries with version 8.4 of Tcl. (CVS 1908) (check-in: 6db26a19ea user: drh tags: trunk) | |
| 14:49 | Add new defenses against misuse of the C API. Ticket #870. (CVS 1906) (check-in: 6ef1f662d7 user: drh tags: trunk) | |
| 01:12 | Add sqlite_temp_directory to the windows driver. (CVS 1905) (check-in: f5b0e5b0b2 user: drh tags: trunk) | |
|
2004-08-26
| ||
| 01:12 | Update the TCL binding documentation to describe the newly added ability to specify TCL variable names in the body of an SQL statement. (CVS 1904) (check-in: b3b9e58103 user: drh tags: trunk) | |
| 00:56 | Protect Tcl_Obj pointers from change using Tcl_IncrRefCount() while executing SQL statements in the TCL bindings. (CVS 1903) (check-in: 6199f2f243 user: drh tags: trunk) | |
|
2004-08-25
| ||
| 04:07 | Host parameter names conform to SQL-2003. (CVS 1902) (check-in: fd584d1ccf user: drh tags: trunk) | |
|
2004-08-24
| ||
| 15:23 | Fix a bug in the parsing of wildcards that begin with '$'. (CVS 1901) (check-in: 054dd8901d user: drh tags: trunk) | |
|
2004-08-21
| ||
| 19:20 | Fix a pager bug that might have made multi-database commits non-atomic if a power failure occurred at just the wrong moment. (CVS 1900) (check-in: b6eb4bf8c7 user: drh tags: trunk) | |
| 17:54 | Optimizations to the code generator. (CVS 1899) (check-in: bd6649c5aa user: drh tags: trunk) | |
|
2004-08-20
| ||
| 18:34 | Tcl interface transfers values directly between SQLite and Tcl_Objs, without at translation to strings. (CVS 1898) (check-in: e97c331362 user: drh tags: trunk) | |
| 16:02 | Add support for named wildcards in SQL statements. (CVS 1897) (check-in: d3be0b7c5a user: drh tags: trunk) | |
| 14:08 | Optimizations in the hash table module. (CVS 1896) (check-in: d5b0269e0d user: drh tags: trunk) | |