/ Timeline
Login

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

100 descendants and 100 ancestors of [a154224b]

2007-05-02
13:30
Add support for zero-blobs to the OP_MakeRecord opcode. First test cases of zeroblob functionality. (CVS 3897) check-in: e6d560dd user: drh tags: trunk
13:16
Use the pointer-map pages to make the incremental blob API more efficient. (CVS 3896) check-in: 93a3bf71 user: danielk1977 tags: trunk
02:08
Fix some compiler warnings. Add the (untested) zeroblob() SQL function. (CVS 3895) check-in: 6f4f8ba7 user: drh tags: trunk
01:34
Begin adding the zeroblob API to support incremental blob i/o. (CVS 3894) check-in: 7a01836d user: drh tags: trunk
2007-05-01
18:25
Enable prefix-search in query-parsing and snippet generation. If the character immediately after the end of a term is '*', that term is marked for prefix matching. Modify term comparison in snippetOffsetsOfColumn() to respect isPrefix. fts2n.test runs prefix searching through some obvious test cases. (CVS 3893) check-in: 7c4c6592 user: shess tags: trunk
17:49
First approximation of incremental blob IO API. (CVS 3892) check-in: c444836e user: danielk1977 tags: trunk
17:14
Modify loadSegmentLeavesInt() to correctly handle prefix searching. The new function docListUnion() is used to accumulate a union of the hits for the matching terms, which will be merged across segments using docListMerge(). (CVS 3891) check-in: 72c79630 user: shess tags: trunk
16:59
The pager takes the sector size to be the larger of the sector size reported by sqlite3OsSectorSize() and the page size. (CVS 3890) check-in: e5e6af55 user: drh tags: trunk
2007-04-30
22:09
Propagate prefix flag through implementation of doclist query code. Also implement correct prefix-handling for traversal of interior nodes of segment tree. A given prefix can span multiple children of an interior node, and from there the branches need to be followed in parallel. (CVS 3889) check-in: cae844a0 user: shess tags: trunk
21:39
Fix a potential segfault following a malloc() failure during a call to sqlite3_prepare() where the nBytes parameter is positive but less than the length of the input SQL string. (CVS 3888) check-in: 27bf3fc3 user: drh tags: trunk
17:52
Lift docListMerge() call out of loadSegmentLeavesInt() for prefix search. Doclists from multiple prefix matches will need a union merge function, which will have to logically happen across a segment before doclists are merged between segments. (CVS 3887) check-in: 7ddb8266 user: shess tags: trunk
16:55
Try to avoid reading pages when moving overflow chains to the free-list. (CVS 3886) check-in: 8cccec68 user: danielk1977 tags: trunk
2007-04-28
15:47
Add some tests (and 2 resulting bug fixes) to incr vacuum mode. (CVS 3885) check-in: 89b1b3f8 user: danielk1977 tags: trunk
2007-04-27
22:02
Break interior-node and leaf-node readers apart in loadSegment(). Previously, the code looped until the block was a leaf node as indicated by a leading NUL. Now the code loops until it finds a block in the range of leaf nodes for this segment, then reads it using LeavesReader. This will make it easier to traverse a range of leaves when doing a prefix search. (CVS 3884) check-in: 9466367d user: shess tags: trunk
21:59
Internationalize the TRIM functions. Ticket #2323. (CVS 3883) check-in: ff1f4e74 user: drh tags: trunk
21:24
Lift code to traverse interior nodes out of loadSegment(). Refactoring towards prefix searching. (CVS 3882) check-in: 25935db7 user: shess tags: trunk
21:02
Refactor fts2 loadSegmentLeaf() in preparation for prefix-searching. Prefix-searching will want to accumulate data across multiple leaves in the segment, using LeavesReader instead of LeafReader is the first step in that direction. (CVS 3881) check-in: 22ffdae4 user: shess tags: trunk
17:16
Make sure sqlite3_value_bytes() does not reformat the content after a call to sqlite3_value_blob(). Add documentation to explain this hazard. Add many new tests. Ticket #2321. (CVS 3880) check-in: e92bd97a user: drh tags: trunk
07:55
Extra tests for incremental vacuum. (CVS 3879) check-in: 40ba6493 user: danielk1977 tags: trunk
07:05
Modifications to btree integrity check so that it can be run inside a transaction after an incr vacuum. (CVS 3878) check-in: 4d4180d6 user: danielk1977 tags: trunk
01:18
The replace() function should return NULL if the second argument is an empty string. Ticket #2324. (CVS 3877) check-in: e6a0c90d user: drh tags: trunk
2007-04-26
14:42
Add largely untested code for the incremental vacuum function. (CVS 3876) check-in: f6a6d2b8 user: danielk1977 tags: trunk
12:11
In the pager, load the content of pages which were initialized with noContent==1 if they are subsequently requested with noContent==0. (CVS 3875) check-in: d0745a43 user: drh tags: trunk
2007-04-25
18:23
Fix segfaults that can occur if a malloc failure happens just before a built-in function calls sqlite3_value_text(). (CVS 3874) check-in: 9cb0ed6e user: drh tags: trunk
15:42
Disable tests in misc7 that do not work on windows due to limitations of the windows file system. (CVS 3873) check-in: 66646d6f user: drh tags: trunk
12:07
Version 3.3.17 (CVS 3872) check-in: 16979f45 user: drh tags: trunk
12:06
Fix a file descriptor leak in the exclusive2 test script. (CVS 3871) check-in: 2d2e68da user: drh tags: trunk
11:42
Preparing for the release of 3.3.17. (CVS 3870) check-in: e278c4ef user: drh tags: trunk
11:32
Fix duplicate test IDs in the test suite. No changes to code. Ticket #2319. (CVS 3869) check-in: 0935cdf8 user: drh tags: trunk
11:28
Fix a bug in the sqlite3_changes() function reported on the mailing list. (CVS 3868) check-in: 58ea768c user: drh tags: trunk
2007-04-24
17:35
This fixes a missed case in check-in (3866). Do not apply patch (3866) without also applying this patch. (CVS 3867) check-in: 66c2fa08 user: drh tags: trunk
17:27
When the write_version flag in the database header is larger than what the library understands, make the database read-only. The old behavior was to make the database unreadable. (CVS 3866) check-in: 10648e99 user: drh tags: trunk
2007-04-23
23:56
Get the build working with -DSQLITE_OMIT_UTF16=1. Ticket #2314. (CVS 3865) check-in: 25c1c7aa user: drh tags: trunk
2007-04-21
16:37
Add the ability to turn the FTS2 module into an amalgamation. (CVS 3864) check-in: 94374654 user: drh tags: trunk
2007-04-20
12:22
Remove the ARRAYSIZE macro from where.c to avoid a name conflict with microsoft header files. Ticket #2311 (CVS 3863) check-in: 9389a15f user: drh tags: trunk
2007-04-19
18:36
Fix bug in fts2 handling of OR queries. When one doclist ends before the other, the code potentially tries to read past the end of the doclist. http://www.sqlite.org/cvstrac/tktview?tn=2309 (CVS 3862) check-in: dfac6082 user: shess tags: trunk
14:48
Better fix than (3860) for the same problem. (3860) could leave file-handles open in some circumstances. (CVS 3861) check-in: 5ad64533 user: danielk1977 tags: trunk
14:28
Fix a crash that can occur if an error happens in a virtual table xSync() function. (CVS 3860) check-in: d1afdd8c user: danielk1977 tags: trunk
12:30
Comment changes in the ioerr tests. No changes to code. (CVS 3859) check-in: b7ed0e1e user: drh tags: trunk
11:09
Fix a bug whereby sqlite3_prepare_v2() could return both an out-of-memory error and a valid statement handle. (CVS 3858) check-in: 8795d11c user: danielk1977 tags: trunk
00:24
Get the build working with SQLITE_OMIT_SHARED_CACHE. Ticket #2307. (CVS 3857) check-in: b623538c user: drh tags: trunk
2007-04-18
17:07
Fix a && where & was intended. This is a real problem, but it would be very difficult to devise a test case where it might lead to an unexpected result. Ticket #2306. (CVS 3856) check-in: 7f9f0444 user: drh tags: trunk
17:04
Better handle malloc() failures in the "echo" virtual table test module. (CVS 3855) check-in: 6881f921 user: danielk1977 tags: trunk
16:45
The sqlite3_step() routine reports SQLITE_ERROR after a commit failure, not SQLITE_DONE. This fix only effects the legacy sqlite3_prepare() interface. It already worked correctly with sqlite3_prepare_v2(). (CVS 3854) check-in: 165dc72d user: drh tags: trunk
15:33
Version 3.3.16 (CVS 3853) check-in: 8c6b5adb user: drh tags: trunk
14:47
Fix an assertion failure caused by (3851). (CVS 3852) check-in: 24683f1d user: danielk1977 tags: trunk
14:24
Minor changes (mainly to assert() macros) to handle malloc failure in vtab operations. (CVS 3851) check-in: 175156d1 user: danielk1977 tags: trunk
13:49
Bump the version number and update documents in preparation for 3.3.16. (CVS 3850) check-in: 852100a3 user: drh tags: trunk
2007-04-17
08:32
Avoid reloading the db schema after a failed OP_VerifyCookie if the in-memory schema cookie already matches the database file. (CVS 3849) check-in: 61c1d06d user: danielk1977 tags: trunk
2007-04-16
17:07
Fix a memory leak introduced by (3842) associated with ticket #2296. (CVS 3848) check-in: cdc7608b user: drh tags: trunk
15:49
Add test cases to make sure virtual tables cannot be used in shared-cache mode. (CVS 3847) check-in: 66e468ad user: danielk1977 tags: trunk
15:35
Make it clear in the docs that virtual tables and shared cache do not play well together. (CVS 3846) check-in: 62ef2b11 user: drh tags: trunk
15:06
Ensure sqlite3_finalize() can be called from within the xDisconnect() method of virtual tables. (CVS 3845) check-in: 8d6c3bfc user: danielk1977 tags: trunk
15:02
Detect database file changes using a 128-bit segment of the file header that includes the change counter. Ticket #2303. (CVS 3844) check-in: e44995de user: drh tags: trunk
2007-04-14
12:04
Update the whentouse.html document to mention that less bitmap memory is used for larger page sizes. (CVS 3843) check-in: 2c8e2a5b user: drh tags: trunk
2007-04-13
16:06
Match ORDER BY terms to columns using names in compound queries. Make sure this works for subqueries, especially in the right-hand side of an IN operator. Ticket #2296. (CVS 3842) check-in: cfc6f933 user: drh tags: trunk
04:01
Fix a bug in autovacuum introduced by (3839). (CVS 3841) check-in: e39efa19 user: drh tags: trunk
03:23
Additional tests designed to detect future performance regressions. (CVS 3840) check-in: 764e7262 user: drh tags: trunk
02:14
Fix multiple performance regressions (ticket #2298 among them) and add tests to make sure they do not come back. (CVS 3839) check-in: 32bb2d58 user: drh tags: trunk
2007-04-12
21:25
Changes toward fixes for tickets #2296 and #2291. (CVS 3838) check-in: 0dd3e2e4 user: drh tags: trunk
03:54
Get the column affinities right when processing an IN operator where the right-hand side is a subquery with an ORDER BY clause. Ticket #2295. This bug has likely been present since version 3.0.0 and it has just now been noticed, so it seems to be a obscure case. (CVS 3837) check-in: 4062ddf3 user: drh tags: trunk
2007-04-11
17:54
Blind check-in of changes to fix #2294 - I have no ability to test. Gentle wince users: please test this change and if it works leave a remark on the #2294 ticket. Tnx. (CVS 3836) check-in: ca56c3e2 user: drh tags: trunk
2007-04-10
18:17
Preliminary fix for ticket #2291. This fixes the immediate problem. But we really need to write more tests for the xfer optimization in order to look for other related problems before closing this ticket. (CVS 3835) check-in: 34fec312 user: drh tags: trunk
13:51
Be careful not to use the result of sqlite3_value_blob() after changing the representation of an object. Ticket #2290. (CVS 3834) check-in: e14374e4 user: drh tags: trunk
2007-04-09
20:45
Fix crash in delete when existing row has null fields. Previous code assumed that the row had values in all columns, sigh. Fixes bug http://www.sqlite.org/cvstrac/tktview?tn=2289 . (CVS 3833) check-in: 81be7290 user: shess tags: trunk
20:30
Fix stack buffer overrun problem in the test harness. (CVS 3832) check-in: cad9faf3 user: drh tags: trunk
13:49
Version 3.3.15 (CVS 3831) check-in: ba5f4a55 user: drh tags: trunk
13:18
Perparations for the release of 3.3.15. (CVS 3830) check-in: 8d0dea87 user: drh tags: trunk
12:45
Fix an obscure pager refcnt leak that occurs following a transient I/O error. (CVS 3829) check-in: ce6f56ec user: drh tags: trunk
11:20
Have the pager call xReiniter() instead of xDestructor() to restore btree level state after rolling back a page. (CVS 3828) check-in: 4e894133 user: danielk1977 tags: trunk
2007-04-08
16:52
Work around buggy TCL implementations in the exclusive2 test file. Ticket #2287 (CVS 3827) check-in: 5424fcc5 user: drh tags: trunk
2007-04-07
17:44
Make sure autovacuum is turned off for malloc5.test. (CVS 3826) check-in: 105a7efb user: drh tags: trunk
15:03
For filesystem databases, do not store a list of pages in the statement journal in main memory. (CVS 3825) check-in: 0af764a0 user: danielk1977 tags: trunk
2007-04-06
21:42
Changes to test scripts to support alternative configurations. (CVS 3824) check-in: 3471a226 user: drh tags: trunk
18:23
Additional coverage testing. (CVS 3823) check-in: 26b2e1ae user: drh tags: trunk
15:02
Binary file I/O infrastructure added and used to increase test coverage for detection of corrupt database files. (CVS 3822) check-in: 479b3d96 user: drh tags: trunk
11:26
The FOR EACH STATEMENT clause in a trigger is now a syntax error. It used to be silently ignored. STATEMENT is no longer a keyword. (CVS 3821) check-in: 8e2559b4 user: drh tags: trunk
02:32
Test coverage improvements. Over 90% of branches are now executed in both directions. (CVS 3820) check-in: a776d93c user: drh tags: trunk
01:04
Changes to increase test coverage. (CVS 3819) check-in: fd4da6b1 user: drh tags: trunk
01:03
Make sure the sqlite3BtreePrevious() routine terminates properly if the table is deleted out from under it. Ticket #2286. This bug was discovered while trying to increase test coverage from 98.5% to 99% - once again showing the value of full coverage testing. (CVS 3818) check-in: bebf8d2f user: drh tags: trunk
2007-04-05
21:58
Fix the amalgamation so that it works with -DSQLITE_ENABLE_REDEF_IO. Change tclsqlite.c so that it can be appended to the amalgamation. Create a new amalgamation of header files for use by projects that want to redefine their own I/O interface using -DSQLITE_ENABLE_REDEF_IO. (CVS 3817) check-in: f2caff87 user: drh tags: trunk
18:34
Add a target to the autoconf-generated makefile for amalgamation. (CVS 3816) check-in: 204e7d38 user: drh tags: trunk
17:36
New testfixture command: sqlite3_pager_refcounts. Returns a list of integers which is the pager refcount for each pager in the database. (CVS 3815) check-in: 7338e68e user: drh tags: trunk
17:15
Always truncate the pager cache when truncating the database file. Also reorganize the code to check the change-counter after first obtaining a shared lock. (CVS 3814) check-in: 9dc4100e user: danielk1977 tags: trunk
14:29
Use the MEMDB macro instead of OMIT_MEMORYDB in pager_recycle(). (CVS 3813) check-in: 97c51598 user: danielk1977 tags: trunk
13:12
Avoid attempting to reclaim memory from in-memory databases in sqlite3_release_memory(). (CVS 3812) check-in: c20f7563 user: danielk1977 tags: trunk
11:54
Add some assert() statements to pager.c. (CVS 3811) check-in: 973b2a5f user: danielk1977 tags: trunk
11:25
Improvements to coverage testing. (CVS 3810) check-in: 38af156d user: drh tags: trunk
08:40
Catch an IO error case introduced by (3808). (CVS 3809) check-in: 383a08e2 user: danielk1977 tags: trunk
05:46
Zero cached pages located beyond the end of the file before returning them. Ticket #2285. (CVS 3808) check-in: 5180810e user: danielk1977 tags: trunk
2007-04-04
01:27
Test coverage improvements. (CVS 3807) check-in: 25f49acc user: drh tags: trunk
2007-04-03
16:13
Add Tcl (flush) commands to exclusive2.test, which is failing on some systems but not others. (CVS 3806) check-in: 9e004c51 user: danielk1977 tags: trunk
2007-04-02
22:19
Fix to Makefile.in so that "make test" works. (CVS 3805) check-in: f592dd2d user: drh tags: trunk
18:06
Do not use the second parameter to gettimeofday() on unix. Pass it a NULL. (CVS 3804) check-in: 96b67881 user: drh tags: trunk
17:54
Fix a union initializer so that it works with the Borland compiler. (CVS 3803) check-in: a067f78b user: drh tags: trunk
16:46
Add a different form of I/O tests. So far has failed to expose new bugs. (CVS 3802) check-in: 9e129542 user: danielk1977 tags: trunk
16:45
If preprocessor macro OS_OTHER is defined, then ignore OS_UNIX, OS_WIN, and OS_OS2. This makes it easier to add proprietary backends.. (CVS 3801) check-in: 4fdafd3f user: drh tags: trunk
16:40
Provide a compile-time option to enable exclusive access mode by default. (CVS 3800) check-in: 93a41510 user: drh tags: trunk
15:31
Version 3.3.14 (CVS 3799) check-in: 3dbf4f98 user: drh tags: trunk
15:29
Changes to the download page. (CVS 3798) check-in: de8055bc user: drh tags: trunk
15:04
Update the build scripts and the homepage in preparation for version 3.3.14. (CVS 3797) check-in: a154224b user: drh tags: trunk
14:19
Cover an extra case in sqlite3PagerMovepage(). (CVS 3796) check-in: 7313688b user: danielk1977 tags: trunk
12:29
Fix for #2281. This was a problem with the test-case only. (CVS 3795) check-in: c036db62 user: danielk1977 tags: trunk
12:28
Cover a corrupt-db case in pager.c. (CVS 3794) check-in: 84077fa1 user: danielk1977 tags: trunk
12:22
In the amalgamation, put date.c before os.c so that the time_t typedef can be correctly resolved by windows compilers. (CVS 3793) check-in: 9c5697c7 user: drh tags: trunk
11:22
If an IO error is encountered on a commit, close the journal so that it persists and can (hopefully) rollback the failed transaction later. (CVS 3792) check-in: 22e10cc2 user: drh tags: trunk
11:08
Correctly handle the obscure case of a read-only hot-journal file. (CVS 3791) check-in: 4d8c6bf4 user: danielk1977 tags: trunk
05:07
Fix a resource leak introduced by the change-counter optimisation. Also add some test coverage. (CVS 3790) check-in: ba0538a4 user: danielk1977 tags: trunk
00:53
Update the version number and change comments in preparation for the release of 3.3.14. (CVS 3789) check-in: d9f6fdb7 user: drh tags: trunk
2007-04-01
23:49
Fix some warnings about unused and uninitialized variables. (CVS 3788) check-in: 18aec1dd user: drh tags: trunk
18:46
Make unix builds threadsafe by default. (CVS 3787) check-in: ddfc3b2d user: drh tags: trunk
01:57
Fix typos in the amalgamation builder script. (CVS 3786) check-in: a5070a2d user: drh tags: trunk
2007-03-31
22:34
Improvements to the output of the speed tests. (CVS 3785) check-in: 1a4d8024 user: drh tags: trunk
22:33
Remove unreachable code from util.c. (CVS 3784) check-in: 82b7a6f0 user: drh tags: trunk
22:29
Add the amalgamation generator to the makefile. (CVS 3783) check-in: a0f3c960 user: drh tags: trunk
16:29
Fix the amalgamation so that it can be compiled with REDEF_IO enabled. (CVS 3782) check-in: 6a3d6142 user: drh tags: trunk
15:28
Increase test coverage by statically defining SQLITE_BIGENDIAN and related macros for ix86 platforms. Still a run-time test for other architectures. Need to add additional cases to cover other popular processors. (CVS 3781) check-in: 476e7c3f user: drh tags: trunk
15:02
Improved test coverage for printf.c. (CVS 3780) check-in: c2badb20 user: drh tags: trunk
13:00
The XFER optimization works if the target table lacks an integer primary key and is not empty as long as it has no indices. It always has and continues to work if the target table was empty. (CVS 3779) check-in: 2c62ffcb user: drh tags: trunk
10:00
More coverage for pager.c. (CVS 3778) check-in: 665b119a user: danielk1977 tags: trunk
03:59
Fix a long-standing memory leak in the hash table. The leak only appears following a malloc failure of a hash that copies its keys, which rarely happens and so we have not previously noticed it. (CVS 3777) check-in: 2aae1964 user: drh tags: trunk
02:36
Fix a large memory leak in the btree layer that occurs following an I/O error when in shared cache mode. (CVS 3776) check-in: dce4cb84 user: drh tags: trunk
01:34
Fix memory leaks in WHERE clause processing and in TRIGGER parsing. (CVS 3775) check-in: 6736f454 user: drh tags: trunk
2007-03-30
20:46
Remove vestiges of SQLITE_PROTOCOL from the test scripts. (CVS 3774) check-in: e5e8d563 user: drh tags: trunk
20:43
Remove vestiges of the SQLITE_PROTOCOL error. (CVS 3773) check-in: 6dfd4a12 user: drh tags: trunk
20:40
Fix a memory leak that occurs after a malloc failure in trigger parsing. (CVS 3772) check-in: 407a85e6 user: drh tags: trunk
18:42
Fix a memory leak in multi-database commit. Also enhance a comment that explains why a particular valgrind error is harmless. (CVS 3771) check-in: 28c7ed1e user: drh tags: trunk
18:21
Coverage testing for a few lines in pager.c. (CVS 3770) check-in: c1aca18f user: danielk1977 tags: trunk
17:18
Remove asserts on the existing of journal files in pager - asserts that are not valid for certain kinds of simulated I/O errors or for async I/O. (CVS 3769) check-in: f5fad52a user: drh tags: trunk
17:17
Get the memleak.test script working again after recent changes. (CVS 3768) check-in: cd6ca078 user: drh tags: trunk
17:11
Coverage tests for some pragmas. (CVS 3767) check-in: eec7ab63 user: danielk1977 tags: trunk
16:01
Always enable exclusive access mode for TEMP databases. This cannot be changed. The locking_mode pragma has not effect on the TEMP database. (CVS 3766) check-in: 04d3b909 user: drh tags: trunk
14:56
Coverage improvements for where.c. (CVS 3765) check-in: df64894b user: danielk1977 tags: trunk
14:56
Coverage improvements for where.c. (CVS 3764) check-in: 7e0aa964 user: danielk1977 tags: trunk
14:46
Tease apart the two phases of pager commit. (CVS 3763) check-in: e5f17078 user: drh tags: trunk
14:06
Refactoring the btree and pager routines into distinct two-phase commit routines. We've always done a two-phase commit - this change is just making that more apparent in the code. (CVS 3762) check-in: 66b3ad09 user: drh tags: trunk
13:35
Make yypMinor available to the stack overflow callbacks in lemon generated parsers. This does not effect SQLite. (CVS 3761) check-in: 70c8c7e2 user: drh tags: trunk
13:01
Avoid using the "clock" command in test scripts since it is a proc in Tcl8.5 and is thus not available to testfixture. (CVS 3760) check-in: 339941d8 user: drh tags: trunk
11:29
Move the sqlite3_temp_directory global variable out of the OS porting layer and into main.c so that it is more accessible to non-standard OS porting layers. (CVS 3759) check-in: 23653f7a user: drh tags: trunk
11:23
Remove the anonymous union from the sqlite3_value structure since some compilers are unable to deal with it. (CVS 3758) check-in: 6b995259 user: drh tags: trunk
11:12
Comment changes in btree.c and added a missing "else" in pragma.c. (CVS 3757) check-in: 9a7d7e31 user: drh tags: trunk
09:13
Test coverage a few extra lines in where.c. (CVS 3756) check-in: ea49ddf6 user: danielk1977 tags: trunk
07:10
Extra test cases to improve coverage of main.c. (CVS 3755) check-in: 19fc3d78 user: danielk1977 tags: trunk
2007-03-29
20:19
Assume any return code from fcntl() other than -1 is success. Formerly we only assumed that 0 was success. Ticket #2173. (CVS 3754) check-in: 8d0073c0 user: drh tags: trunk
20:13
Fix to token destructors in Lemon. This does not impact SQLite. Ticket #2175. (CVS 3753) check-in: 6195af49 user: drh tags: trunk
18:46
Add the sqlite3_clear_bindings() API to the loadable extension interface. Ticket #2135. (CVS 3752) check-in: 3111b43e user: drh tags: trunk
18:41
Buffer updates per-transaction rather than per-update. If lots of updates happen within a single transaction, there was a lot of wasted encode/decode overhead due to segment merges. This code buffers updates in memory and writes out larger level-0 segments. It only works when documents are presented in ascending order by docid. Comparing a test set running 100 documents per transaction, the total runtime is cut almost in half. (CVS 3751) check-in: 0229cba6 user: shess tags: trunk
18:19
Change the name of PAGER_SECTOR_SIZE to SQLITE_DEFAULT_SECTOR_SIZE. Make the new OS-layer interface routine for finding sector size optional. (CVS 3750) check-in: 0fb9af1d user: drh tags: trunk
17:57
Make sure the strftime() date conversions put in leading zeros correctly. Ticket #2276. (CVS 3749) check-in: e853067e user: drh tags: trunk
17:28
Avoid calling OsDelete() on journal files when they are opened for temporary databases. Fix for #2255. (CVS 3748) check-in: e746832f user: danielk1977 tags: trunk
17:07
Add a couple of test cases to improve coverage testing. (CVS 3747) check-in: 0b22ce36 user: danielk1977 tags: trunk
16:30
Don't call ctype functions on hi-bit chars. Some platforms raise assertions when this occurs, and it's almost certainly not the right thing to do in the first place. (CVS 3746) check-in: f6c3abdc user: shess tags: trunk
15:00
Assume the malloc-failed flag cannot already be set when calling sqlite3_errmsg(16)(). (CVS 3745) check-in: 54fa2227 user: danielk1977 tags: trunk
13:35
Fix a bug in XFER optimization introduced by check-in (3736). (CVS 3744) check-in: 3714ac17 user: drh tags: trunk
12:24
Explicitly test some error cases that up until now have not been checked. (CVS 3743) check-in: 0b7bd9c3 user: danielk1977 tags: trunk
12:19
Explicitly test some error cases that up until now have not been checked. (CVS 3742) check-in: f26b0141 user: danielk1977 tags: trunk
05:51
Change BtreeMoveto so that it can be biased to the right or to the center. Use a right bias when appending and a center bias when searching. This gives about a 15% reduction in calls to sqlite3VdbeRecordCompare. (CVS 3741) check-in: ad4a6b1a user: drh tags: trunk
04:43
Bias the b-tree binary search toward the high end. The common case is to append data and this heuristic makes append run much faster because there are fewer comparisons. (CVS 3740) check-in: a9877f61 user: drh tags: trunk
02:26
Get LEMON working again when YYSTACKDEPTH is greater than zero. (CVS 3739) check-in: e72c81db user: drh tags: trunk
01:44
Lemon change: compile the resulting parser with -DYYSTACKDEPTH=0 or set the "%stack_size" parameter to 0 in the grammar and the parser stack will be dynamically allocated using realloc() and free(). The default behavior is to have a finite depth stack. (CVS 3738) check-in: 06719b74 user: drh tags: trunk
00:08
Patch so the the code compiles with -DSQLITE_OMIT_CHECK=1. (CVS 3737) check-in: 72cea358 user: drh tags: trunk
2007-03-28
18:04
Improvements to the XFER Optimization of the INSERT statement. (CVS 3736) check-in: 53fff7d1 user: drh tags: trunk
14:30
Correctly handle NULLs in IN operators. Ticket #2273. The changes in where.c and in the WhereLevel.aInLoop structure are not strictly necessary to fix this problem - they just make the code easier to read. Only the change in OP_Next/OP_Prev operator of vdbe.c is required. (CVS 3735) check-in: 26348556 user: drh tags: trunk
13:07
Update comments in sqlite3.h. No changes to code. (CVS 3734) check-in: 1c2656fd user: drh tags: trunk
01:59
Fix an memory allocation error revealed by malloc3.test. (CVS 3733) check-in: 0f7fdb02 user: drh tags: trunk
2007-03-27
22:24
The SQLITE_ENABLE_LOAD_EXTENSION macro enables the load_extension() SQL function by default without having to invoke sqlite3_enable_load_extension() first. (CVS 3732) check-in: 113aab2c user: drh tags: trunk
21:47
Fix the prototype of the CodecAttach function in attach.c. (CVS 3731) check-in: 902413e8 user: drh tags: trunk
17:37
Remove a c++ comment in pager.c. (CVS 3730) check-in: e4452e8a user: danielk1977 tags: trunk
16:19
Test handling of IO errors that occur in OsDelete() or OsTruncate() operations. Also use an anonymous file for temporary storage during a VACUUM. (CVS 3729) check-in: b24a6e7b user: danielk1977 tags: trunk
15:00
Updates to the VACUUM documentation. Ticket #2257. (CVS 3728) check-in: c61c97c9 user: drh tags: trunk
14:44
The -DSQLITE_OMIT_ATTACH=1 option now omits both the ATTACH and VACUUM commands. Ticket #2268. The regression test suite depends on both of these commands and will not run if compiled with this option. (CVS 3727) check-in: cbebfb89 user: drh tags: trunk
14:05
Fix off-by-one errors in the header comments of btree.c. Ticket #2272. (CVS 3726) check-in: a70ea720 user: drh tags: trunk
13:36
More strict aliasing fixes. The single source file library now runs successfully with -fstrict-alias. (CVS 3725) check-in: c8a8a189 user: drh tags: trunk
12:04
Get the -DSQLITE_OMIT_XFER_OPT option working. Run speed tests on a full regression. Add the script for generating sqlite3.c. (CVS 3724) check-in: 1dd9d077 user: drh tags: trunk
12:04
Get the -DSQLITE_OMIT_XFER_OPT option working. Run speed tests on a full regression. Add the script for generating sqlite3.c. (CVS 3723) check-in: 42c03851 user: drh tags: trunk
2007-03-26
22:05
Modify sources to that they can be combined into a single sqlite3.c source file. Eliminate all type-pruned pointer warnings. (CVS 3722) check-in: 0b832e21 user: drh tags: trunk
16:30
Set the same random seed for the speed tests. (CVS 3721) check-in: 8fe31705 user: drh tags: trunk
16:13
Run some malloc() tests with exclusive-access mode. (CVS 3720) check-in: 9ebba469 user: danielk1977 tags: trunk
15:46
Discard the pager-cache when the page-size is changed. (CVS 3719) check-in: e4209f71 user: danielk1977 tags: trunk
13:48
Avoid unnecessary calls to pager_unwritelock() when in exclusive-access mode. Add the speed2.test script to the test suite. (CVS 3718) check-in: ab53f508 user: drh tags: trunk
12:26
Run some malloc() tests with exclusive-access mode. (CVS 3717) check-in: 12745490 user: danielk1977 tags: trunk
10:27
Add some tests and fixes surrounding exclusive-access mode and the pager change-counter. (CVS 3716) check-in: 72cb2e1a user: danielk1977 tags: trunk
08:41
Add some documentation for pragma locking_mode. (CVS 3715) check-in: 394b174e user: danielk1977 tags: trunk
08:05
Some fixes and test cases for exclusive access mode. (CVS 3714) check-in: 899e6070 user: danielk1977 tags: trunk
2007-03-25
19:08
Add the sqlite3_prepare_v2 and sqlite3_prepare16_v2 APIs to the loadable extension interface. (CVS 3713) check-in: f02ba56d user: drh tags: trunk
2007-03-24
16:45
Changes for exclusive access mode. There are still some bugs. (CVS 3712) check-in: b6c70037 user: danielk1977 tags: trunk
2007-03-23
18:12
Discard the contents of the pager-cache only when the change-counter indicates that it is stale. (CVS 3711) check-in: 07b56965 user: danielk1977 tags: trunk
10:08
Add a comment to the OsSectorSize() function. (CVS 3710) check-in: 0fd9983a user: danielk1977 tags: trunk
2007-03-22
15:22
In os_unix.c, make a distinction between pread() and pread64(). Add a new compile-time macro USE_PREAD64 to select the latter. (CVS 3709) check-in: 177cd929 user: drh tags: trunk
15:20
Call sqlite3_free() instead of free() to release a buffer allocated by sqlite3_vmprintf() in test_async.c (test suite bug only). (CVS 3708) check-in: b078f09b user: danielk1977 tags: trunk
00:14
Refactor PLWriter to remove owned buffer. DLCollector (Document List Collector) now handles the case where PLWriter (Position List Writer) needed a local buffer. Change to using the associated DLWriter (Document List Writer) buffer, which reduces the number of memory copies needed in doclist processing, and brings PLWriter operation in line with DLWriter operation. (CVS 3707) check-in: d04fa3a1 user: shess tags: trunk
2007-03-20
23:52
Refactor PLWriter in preparation for buffered-document change. Currently, PLWriter (Position List Writer) creates a locally-owned DataBuffer to write into. This is necessary to support doclist collection during tokenization, where there is no obvious buffer to write output to, but is not necessary for the other users of PLWriter. This change adds a DLCollector (Doc List Collector) structure to handle the tokenization case.    Also fix a potential memory leak in writeZeroSegment(). In case of error from leafWriterStep(), the DataBuffer dl was being leaked. (CVS 3706) check-in: 1b9918e2 user: shess tags: trunk
2007-03-19
17:44
Modify the interface to the pager sub-system in preparation for performing IO in blocks based on sector-size, not database page-size. (CVS 3705) check-in: 7dc76588 user: danielk1977 tags: trunk
15:04
Add some test cases simulating crashes with various storage medium sector sizes. (CVS 3704) check-in: c3c5f658 user: danielk1977 tags: trunk
13:53
Fix some problems with test cases in shared_err.test. Also a real bug causing a segfault after an IO error in pager.c. (CVS 3703) check-in: 9f62ef1e user: danielk1977 tags: trunk
11:54
Fix a comment in btree.c (CVS 3702) check-in: 05700c11 user: drh tags: trunk
11:25
Changes to support medium sector sizes larger than the database page size. (CVS 3701) check-in: 3a3e8eb2 user: danielk1977 tags: trunk
05:54
Add new OS file method to return the sector-size of the underlying storage: sqlite3OsSectorSize() (CVS 3700) check-in: 5752d84d user: danielk1977 tags: trunk
2007-03-17
18:22
Add documentation of the REPLACE, TRIM, LTRIM, and RTRIM functions. (CVS 3699) check-in: d42c9636 user: drh tags: trunk
17:52
Added TRIM, LTRIM, and RTRIM functions. (CVS 3698) check-in: 6fe13eea user: drh tags: trunk
13:27
First cut at an implementation of the REPLACE() function. We might yet make this a compile-time option or move it into a separate source file. (CVS 3697) check-in: c2fe746e user: drh tags: trunk