/ Timeline
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

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

100 descendants and 100 ancestors of [33cf8359]

2009-06-09
14:27
Modify mkkeywordhash.c so that it puts the original text of each token in a comment beside the "testcase()" macros. (CVS 6736) check-in: a7d0817c user: drh tags: trunk
13:42
Enable cell overflow checking in sqlite3BtreeInitPage() using the compile-time option SQLITE_ENABLE_OVERSIZE_CELL_CHECK. Change the tests so that they recognize different error messages depending on the setting of this macro. (CVS 6735) check-in: 56bff6eb user: drh tags: trunk
11:34
Avoid calling fillInCell() to create an internal node intkey cell from balance_nonroot(). A single putVarint() does the same thing more quickly. (CVS 6734) check-in: 2e5d42ae user: danielk1977 tags: trunk
10:37
Only do the cell overread checks in sqlite3BtreeInitPage if SQLITE_OVERREAD_CHECK is defined at compile-time. (CVS 6733) check-in: 49f544eb user: drh tags: trunk
09:41
Do not clear the MemPage.nFree variable when insertCell() adds an overflow cell to a page. Not doing this means balance_quick() can avoid a call to sqlite3BtreeInitPage(). (CVS 6732) check-in: 8f1c1f61 user: danielk1977 tags: trunk
2009-06-08
19:44
Additional comments to clarify the operation of the LIKE optimizer in where.c. (CVS 6731) check-in: cc9c1217 user: drh tags: trunk
17:11
Clarification of the operation of the OR-term optimizer in where.c. (CVS 6730) check-in: 6b42dc3d user: drh tags: trunk
14:49
Change the btree balance code so that it does not call balance_nonroot() recursively. (CVS 6729) check-in: 7863db90 user: danielk1977 tags: trunk
12:52
Increase the version number to 3.6.15 in preparation for the next release. (CVS 6728) check-in: 456ea541 user: drh tags: trunk
2009-06-07
23:45
Disable the LIKE optimization if the affinity of the LHS column is not TEXT. Ticket #3901. (CVS 6727) check-in: a255c645 user: drh tags: trunk
2009-06-06
19:21
Update the error message on one of the corruption tests to account for the fact that we are finding the corruption sooner. (CVS 6726) check-in: ba9848e7 user: drh tags: trunk
16:08
Fix an error in the malloc.test test script causing a small buffer overread. (CVS 6725) check-in: 4d129bee user: danielk1977 tags: trunk
15:17
Make sure the result of sqlite3VdbeGetOp() is not used as an array following an OOM error, since after (6691) it might be a single-entry dummy opcode. (CVS 6724) check-in: 127b1398 user: drh tags: trunk
14:13
When building in debug mode with gcc, force the nullMem variable in function columnMem() to be aligned to an 8-byte boundary. Otherwise an assert() statement may fail. (CVS 6723) check-in: 3fd6c72d user: danielk1977 tags: trunk
2009-06-05
18:44
Detect when database corruption causes an attemp to set the pointer map value for a pointer map page and report the corruption. (CVS 6722) check-in: 3ae4880b user: drh tags: trunk
17:09
Remove leftover "breakpoint" commands from test scripts. Also remove blank lines at the end of scripts. (CVS 6721) check-in: 1fef16ec user: drh tags: trunk
16:46
Do not cast an unsigned int into an int for comparison. (CVS 6720) check-in: 302ab855 user: drh tags: trunk
14:17
Take care that a corrupt variable-length integer does not cause 32-bit integer overflow when parsing a record format, nor cause excessively large memory allocations. (CVS 6719) check-in: 38b20327 user: drh tags: trunk
2009-06-04
19:06
Earlier detection of freelist corruption in the page allocation routines. (CVS 6718) check-in: e557c8e5 user: drh tags: trunk
17:02
Fix an assertion fault in balance_quick() that occurs when an interior btree node has zero cells due to database corruption. Also update the corrupt7.test result vectors for a couple of cases where the error report on database corruption changed due to earlier detection. (CVS 6717) check-in: 1335e444 user: drh tags: trunk
16:14
If the root page of a btree is empty and is also not a leaf page and the page is not page 1, then report database corruption. (CVS 6716) check-in: 52b02ca5 user: drh tags: trunk
14:46
Reduce the stack usage of balance_quick(). (CVS 6715) check-in: e7ad68e9 user: danielk1977 tags: trunk
02:47
Minor updates to comments in test scripts. (CVS 6714) check-in: 453ff88f user: shane tags: trunk
02:46
Minor tweak to test script to ensure every byte in file touched at least once. (CVS 6713) check-in: bc6c2d89 user: shane tags: trunk
00:11
Fix two instances where a malformed header in a database file (in other words a corrupt database file) can lead to an assertion fault. (CVS 6712) check-in: 4e92c7f2 user: drh tags: trunk
2009-06-03
21:04
Change the pcache1.c implementation so that the "header" occurs at the end of page buffer, not at the beginning. This insures that the 20 bytes immediately following the page buffer are mapped if a read of the page buffer overruns due to a malformed cell. (CVS 6711) check-in: c54de1f5 user: drh tags: trunk
17:26
Add corruptD.test, a container for testing the "cell overflow" problem. Also shuffle a small amount of code in BtreeInitPage() to check that the page header pointer to the start of the cell offset array is set to a sane value. (CVS 6710) check-in: 7fa5d3cb user: danielk1977 tags: trunk
11:25
Define a set of constants to use as the "index" argument to sqlite3BtreeGetMeta and UpdateMeta. This makes some parts of the code easier to follow. (CVS 6709) check-in: 6dbf4eca user: danielk1977 tags: trunk
01:24
Additional changes to reduce stack usage. The SQLITE_SMALL_STACK compile-time option is now available. (CVS 6708) check-in: baea79fd user: drh tags: trunk
2009-06-02
21:31
Further reductions in the amount of stack space required. (CVS 6707) check-in: 04bad9eb user: drh tags: trunk
16:06
Tweaks to vdbe.c to further reduce stack space requirements. (CVS 6706) check-in: 6f2aab3f user: drh tags: trunk
15:47
Add a test case for ticket #3893 and ticket #3894. (CVS 6705) check-in: 2472f6db user: drh tags: trunk
15:21
Add the vdbe-compress.tcl script which automatically refactors the sqlite3VdbeExec() routine to use less stack space. Use this script when constructing the amalgamation. (CVS 6704) check-in: 7f433918 user: drh tags: trunk
2009-06-01
19:53
Avoid allocating large objects on the stack in the incremental BLOB I/O interface. (CVS 6703) check-in: ea7dfde7 user: drh tags: trunk
18:18
Malloc for space to hold the Parse object in sqlite3_prepare() and friends. Or, if compiled with SQLITE_USE_ALLOCA, obtain space for the object from alloca(). (CVS 6702) check-in: c7c0c58e user: drh tags: trunk
17:10
Added assert to verify winMutex system is inited before "static" mutexes are used. (CVS 6701) check-in: b126013b user: shane tags: trunk
17:06
Ensure that "static" mutexes are deleted on shutdown so that they are not leaked across restarts. (CVS 6700) check-in: 4e75897e user: shane tags: trunk
16:53
Fix compiler warnings with MSVC build. (CVS 6699) check-in: 07915885 user: shane tags: trunk
16:42
Fix a couple of Windows only issues with test scripts. (CVS 6698) check-in: 0f6bc5e1 user: shane tags: trunk
2009-05-31
21:21
Code simplifications to facilitate coverage testing following the recent changes to the Expr object. (CVS 6697) check-in: ee9a144d user: drh tags: trunk
17:16
Fix the ".genfkey" command of the CLI so that it does not leak memory if sqlite3_realloc() fails. Ticket #3891. (CVS 6696) check-in: a028d69c user: drh tags: trunk
2009-05-30
23:35
Fix typo reported by ticket #3888. Other minor edits to facilitate coverage testing. (CVS 6695) check-in: 164adf26 user: drh tags: trunk
20:49
Simplifications to the expr.c source module resulting from structural testing. (CVS 6694) check-in: f760bb7a user: drh tags: trunk
14:16
Fix for ticket #3887. Other unrelated bits of code cleanup in the expr.c source module. (CVS 6693) check-in: 00e7250f user: drh tags: trunk
10:46
In vacuum.c use "PagerIsMemdb(X)" instead of "PagerFile(X)->pMethods==0". (CVS 6692) check-in: 874295ce user: danielk1977 tags: trunk
2009-05-29
19:00
Enhance the sqlite3VdbeGetOp() routine so that it always returns a pointer to VdbeOp, even following an OOM fault. This simplifies error handling in callers. Cleanup to the column cache logic and the expr.c source module. (CVS 6691) check-in: ede06dac user: drh tags: trunk
14:39
Refinements in expression handling logic that have resulted from recent structural testing. (CVS 6690) check-in: bd89f2c2 user: drh tags: trunk
11:57
Still more refinements to the hasHotJournal() fix of ticket #3883. (CVS 6689) check-in: 726b425e user: drh tags: trunk
10:55
The hasHotJournal() fix of check-in (6687) causes some minor problems in various alternative operating modes, such as locking_mode=EXCLUSIVE. This additional patch attempts to fix those concerns. Ticket #3883. (CVS 6688) check-in: a2ba61d9 user: drh tags: trunk
00:30
Modify the hasHotJournal() routine to return a false-positive if it is unable to open the journal file to check its header due to a race condition. Processing downstream of hasHotJournal() already knows how to deal with false-positives. Ticket #3883. (CVS 6687) check-in: d6b5d8e1 user: drh tags: trunk
2009-05-28
21:04
Remove references to deleted function sqlite3ExprRegister(). Changes to the expr.c source module to promote better testing. (CVS 6686) check-in: 6ae4ad6e user: drh tags: trunk
14:34
Fix a NULL pointer dereference following an OOM error in the column name resolver. (CVS 6685) check-in: 3b461425 user: drh tags: trunk
12:49
Make sure the column name resolver does not try to duplicate Expr.u.zToken when the Expr.u.iValue union member is the element being used. (CVS 6684) check-in: 376ecf0d user: drh tags: trunk
11:05
Workaround the need for internal API sqlite3BtreeCursorDb(). It was only being used for an assert() statement, which can be done differently. (CVS 6683) check-in: 5904af6e user: danielk1977 tags: trunk
01:00
Additional refinements to Expr handling. Restore compression of trigger expressions. Change Expr.zToken to Expr.u.zToken and added Expr.u.iValue. Remove an unnecessary ExprDup from CHECK constraint processing. And so forth. (CVS 6682) check-in: 4ac2bdfb user: drh tags: trunk
2009-05-27
10:31
Simplifications to the Expr object: Remove Expr.span completely and convert Expr.token into a char* Expr.zToken. Also simplify the Token object by removing the Token.dyn and Token.quoted fields. (CVS 6681) check-in: 7cb1c3ba user: drh tags: trunk
2009-05-25
14:17
Fix the rtree test module so that it works even if the ext/ subfolder is omitted from the tree. (CVS 6679) check-in: 086206e1 user: drh tags: trunk
11:46
When pinning a temp register after it is reused by the column cache, make sure all instances of that register in the cache are pinned so that the register is never reused for a different purpose. Ticket #3879. (CVS 6676) check-in: 5f358e63 user: drh tags: trunk
11:46
Add a test case for ticket #3879. (CVS 6675) check-in: 5b9b66f4 user: danielk1977 tags: trunk
2009-05-24
21:59
Additional clarification of the 3rd parameter to sqlite3_create_function(). Documentation change only; no changes to code. Ticket #3875. (CVS 6674) check-in: dd75e376 user: drh tags: trunk
11:08
In the previous, the upper bound on the number of function arguments is 127, not 255. Ticket #3876 (CVS 6673) check-in: 4fe4c5fa user: drh tags: trunk
11:07
Correct and clarify the documentation on the third parameter to sqlite3_create_function(). (CVS 6672) check-in: 6b7929ed user: drh tags: trunk
2009-05-22
15:43
Do not transform a WHERE clause of the form "a = ? OR a = ?" to "a IN (?, ?)" if "a" is a column of a virtual table. Ticket #3871. (CVS 6671) check-in: fad88e71 user: danielk1977 tags: trunk
11:12
Add an assert() to pcache1.c to double-check that page cache buffer memory is never allocated if pcache1 is not enabled. Ticket #3872 (CVS 6670) check-in: 93369d91 user: drh tags: trunk
11:10
Additional changes to pcache1 to prevent the page buffer memory from being configured if pcache1 is not enabled. Ticket #3872. (CVS 6669) check-in: 5153ad19 user: drh tags: trunk
10:53
Make sure sqlite3_shutdown() completely disables the default pager cache mechanism in pcache1.c. Ticket #3872. Also fix some comments associated with configuring the page cache. (CVS 6668) check-in: 6240992c user: drh tags: trunk
01:02
Add omitted word in the documentation for total_change_count(). ticket #3870. (CVS 6667) check-in: 3f6fd16f user: drh tags: trunk
01:00
Fix an 8-byte alignment problem on HP/UX. Ticket #3869 (CVS 6666) check-in: fc64f850 user: drh tags: trunk
2009-05-21
20:41
Simplifications to expr.c in support of full coverage testing. (CVS 6665) check-in: 309adb5e user: drh tags: trunk
15:15
In the CLI in the ".dump" command, do not attempt to clear the sqlite_sequence table until the first row of content of that table is seen. Ticket #3867 (CVS 6664) check-in: bedd5ad1 user: drh tags: trunk
14:51
In the CLI, always "dump" the sqlite_sequence table last. Ticket #3867 (CVS 6663) check-in: a0028d48 user: drh tags: trunk
04:42
Add conditional 'extern "C"' block to sqlite3async.h. Ticket #3866. (CVS 6662) check-in: e4d1b117 user: danielk1977 tags: trunk
2009-05-20
20:10
Fix a memory leak that occurs when an out-of-memory error occurs while preparing a statement that has multiple virtual table updates within triggers. Other virtual table changes to support full-coverage testing. (CVS 6661) check-in: 02b77a58 user: drh tags: trunk
16:22
Remove unused, undocumented, and untested error reporting logic from the xFindFunction interface in virtual tables. (CVS 6660) check-in: 55d6ced2 user: drh tags: trunk
02:40
Updates to the extension loading logic to support full coverage testing. (CVS 6659) check-in: 929cfbc6 user: drh tags: trunk
2009-05-19
19:04
Changes to select.c to facilitate full coverage testing. (CVS 6658) check-in: f678ed34 user: drh tags: trunk
14:21
Improvements to the SQLITE_INT_TO_PTR macro to reduce the number of warnings. For some platforms it might be necessary to compile with the -DHAVE_STDINT_H flag. Ticket #3860. (CVS 6657) check-in: 1b0ee9d1 user: drh tags: trunk
03:21
Update the showdb.c utility so that it works with databases larger than 4GiB. (CVS 6656) check-in: 9675b622 user: drh tags: trunk
2009-05-18
16:04
Fix memdb.test so that it works when OMIT_AUTOVACUUM is defined. (CVS 6649) check-in: 8c3c0c24 user: danielk1977 tags: trunk
15:46
Changes to select.c in support of full coverage testing. (CVS 6647) check-in: e225f365 user: drh tags: trunk
13:34
Fix a typo on a comment associated with check-in (6641) and ticket #3860. (CVS 6646) check-in: 43051e03 user: drh tags: trunk
2009-05-17
15:29
Remove debugging code accidently left in check-in (6642). Ticket #3862. (CVS 6645) check-in: 0d974613 user: drh tags: trunk
15:26
Take care to free the memory for the ORDER BY clause on SELECT statements containing errors and contained within triggers. Ticket #3863. (CVS 6644) check-in: dd665eac user: drh tags: trunk
12:07
Fix a typo in the sqlite3_blob_open() documentation. (CVS 6643) check-in: 92866482 user: drh tags: trunk
02:06
Tweaks and simplifications to select.c to facility full coverage testing. (CVS 6642) check-in: e3ccbc69 user: drh tags: trunk
2009-05-16
17:38
Attempt to provide a version of the SQLITE_INT_TO_PTR macro that works on both llvm-gcc-4.2 and MSVC. Ticket #3860. (CVS 6641) check-in: ddee7ff2 user: drh tags: trunk
2009-05-15
14:41
Re-enable file locking in async4.test. (CVS 6640) check-in: f7098187 user: danielk1977 tags: trunk
2009-05-14
22:37
Documentation enhancements for sqlite3_update_hook(), sqlite3_commit_hook(), and the various incremental blob I/O routines. No changes to code. (CVS 6639) check-in: e8ca932d user: drh tags: trunk
19:26
Change the sqlite3_backup_finish() interface so that calling it with a NULL pointer is a harmless no-op. One other change to backup.c to facilitate full coverage testing. (CVS 6638) check-in: 06bc8917 user: drh tags: trunk
03:21
Documentation updates to better explain the SQLITE_OPEN_EXCLUSIVE flag. Ticket #3855. (CVS 6637) check-in: 6bd44f36 user: shane tags: trunk
2009-05-13
22:58
Additional simplifications to build.c in support full coverage testing. (CVS 6636) check-in: 913d1114 user: drh tags: trunk
17:35
Remove incorrect NEVER() macro in the previous check-in (6634). (CVS 6635) check-in: c6849579 user: drh tags: trunk
17:21
Changes to build.c to help facilitate full coverage testing. (CVS 6634) check-in: 264ace50 user: drh tags: trunk
14:46
Do not run async4.test as part of the "journaltest" permutation. It specifically tests that the asynchronous IO backend can be configured to violate the assumptions made by journaltest. (CVS 6633) check-in: b19bf39b user: danielk1977 tags: trunk
07:52
When locking a database file, check if any backup objects need to be restarted even if the page cache is empty. Ticket #3858. (CVS 6632) check-in: 90309008 user: danielk1977 tags: trunk
2009-05-12
18:00
Remove debugging comments left in the prior check-in by mistake. (CVS 6631) check-in: 82070560 user: drh tags: trunk
17:46
Move the sqlite3MinimumFileFormat() routine from build.c over to alter.c since alter.c is the only code that uses it. Additional changes and cleanup to build.c to facility coverage testing. (CVS 6630) check-in: 6fe3750a user: drh tags: trunk
13:35
Make sure the SQLITE_OPEN_EXCLUSIVE flag is ignored by sqlite3_open_v2(). That flag is to be used by the VFS interface only. Ticket #3855. (CVS 6629) check-in: c37f0279 user: drh tags: trunk
00:40
Tweaks to build.c to facilitate coverage testing. (CVS 6628) check-in: 6572b438 user: drh tags: trunk
2009-05-11
23:38
If a virtual table constructor returns SQLITE_NOMEM, set the mallocFailed flag in the corresponding database connection to insure that the error is propagated back to the top layer. (CVS 6627) check-in: 5635666f user: drh tags: trunk
20:53
Rework the logic that generates a schema for tables created using "CREATE TABLE ... AS SELECT ...". Instead of trying to copy the raw datatype string from the right-hand side, just make the type one of TEXT, INT, REAL, NUM, or nothing. This is much simpler than trying to parse and quote datatype strings. Other minor implifications to build.c are bundled with this change. (CVS 6626) check-in: 33cf8359 user: drh tags: trunk
18:22
Enhance the parser to allow nested parentheses in the module argument of a CREATE VIRTUAL TABLE statement. (CVS 6625) check-in: 93772bd7 user: drh tags: trunk
2009-05-09
23:29
Convert an always-true condition in hash.c into an assert(). (CVS 6624) check-in: 42372999 user: drh tags: trunk
18:59
Add the SQLITE_TESTCTRL_ASSERT and SQLITE_TESTCTRL_ALWAYS codes for the sqlite3_test_control() interface. (CVS 6623) check-in: 38df91c2 user: drh tags: trunk
15:17
Change sqlite_blob_open() so that it zeros the output pBlob pointer when it fails. The other sqlite3_blob interfaces accept a NULL pointer as input. (CVS 6622) check-in: 999d507b user: drh tags: trunk
00:18
Changes to the trigger.c module that facilitate full coverage testing. (CVS 6621) check-in: 567ccc68 user: drh tags: trunk
2009-05-08
11:34
Fix a warning in the osx-specific part of os_unix.c. Ticket #3847. (CVS 6620) check-in: 254ca327 user: danielk1977 tags: trunk
06:52
Correctly update the cache page-count when discarding pages in the xTruncate() method of the default pcache implementation. Otherwise the effective configured size of the cache shrinks each time xTruncate() is called. Fix for #3844. (CVS 6619) check-in: 88211cee user: danielk1977 tags: trunk
2009-05-07
14:11
If compiling FTS3 in the amalgamation, include the ctype.h header file. Ticket #3843. (CVS 6618) check-in: 660108ef user: drh tags: trunk
13:43
Change the sqlite3_create_function() family of routines to return SQLITE_MISUSE instead of SQLITE_ERROR if their parameters are incorrect. (CVS 6617) check-in: 866f13e2 user: drh tags: trunk
12:17
Make sure the iteration counter on aggregate functions is reset each time the aggregate is used in an correlated subquery. Ticket #3841. (CVS 6616) check-in: 4a86de35 user: drh tags: trunk
02:26
Version 3.6.14 (CVS 6615) check-in: 469ad1de user: drh tags: trunk, release
2009-05-06
19:03
Fix compiler warning found with gcc -Wextra. (CVS 6614) check-in: 93bdbc5e user: drh tags: trunk
18:57
Changes to silence compiler warnings under MSVC. (CVS 6613) check-in: df599237 user: shane tags: trunk
18:42
Fix three variable initialization problems found by valgrind. (CVS 6612) check-in: 37428435 user: drh tags: trunk
15:24
updated vxworks makefile for 3.6.14 release (CVS 6611) check-in: 5d4bffaa user: chw tags: trunk
00:52
Add a short pause to force a context swap while waiting for a separate process to clear its lock in the lock4.test script. (CVS 6610) check-in: 4357e76d user: drh tags: trunk
00:49
Fix the test case misc3-6.11 so that it works correctly on UTF16 databases after the fix of for ticket #3838, check-in (6603) (CVS 6609) check-in: c1e739e3 user: drh tags: trunk
2009-05-05
20:02
Minor changes to the sqlite3_exec() implementation in legacy.c to facility full coverage testing. (CVS 6608) check-in: 9e3016c1 user: drh tags: trunk
18:01
Bump the version number up to 3.6.14. (CVS 6607) check-in: f4549904 user: drh tags: trunk
17:37
Changes to vacuum.c to facilitate full coverage testing. (CVS 6606) check-in: 86628465 user: drh tags: trunk
15:46
Make sure the left-shift operator never overflows. (CVS 6605) check-in: 300da301 user: drh tags: trunk
15:46
Changes to update.c to facilitate full coverage testing. (CVS 6604) check-in: 25a11b9e user: drh tags: trunk
12:54
Make sure the default value on a column added using ALTER TABLE has the correct encoding. Ticket #3838. (CVS 6603) check-in: 7f89a860 user: drh tags: trunk
2009-05-04
20:20
Make sure va_arg() does not occur on the same line as any "if" statement or "?" operator. (CVS 6602) check-in: 3543be6e user: drh tags: trunk
19:01
Avoid parsing cells that fit entirely on the b-tree page when searching a b-tree index. (CVS 6601) check-in: 77a82395 user: danielk1977 tags: trunk
18:01
Changes to auth.c to promote full coverage testing. (CVS 6600) check-in: c7615b44 user: drh tags: trunk
11:42
Speed up INSERT operations that add data to UNIQUE or PRIMARY KEY indexes by rationalizing duplicate seek operations. (CVS 6599) check-in: cac4f3d8 user: danielk1977 tags: trunk
01:58
Work toward cleaning up the authorizer interface. Work is on-going. This is an incremental check-in. (CVS 6598) check-in: 694662f7 user: drh tags: trunk
2009-05-03
20:23
Changes to facility full coverage testing of util.c. (CVS 6597) check-in: a6122990 user: drh tags: trunk
01:01
More changes to insert.c to facilitate full coverage testing. (CVS 6596) check-in: 46c4ec96 user: drh tags: trunk
2009-05-02
15:46
Simplifications to the uniqueness constraint failure error message generation code. (CVS 6595) check-in: 8f3cac76 user: drh tags: trunk
13:29
Remove the aFKey hash table, which was not being used. Simplify the FKey object. Simplify the hash.c module since the copyKey parameter formerly used only by aFKey is now no longer required. (CVS 6594) check-in: 80c43a35 user: drh tags: trunk
12:02
Reduce the size of an integer literal in rowhash.tcl so that the test is able to run with the default TCL installation on Mac OS 10.5. (CVS 6593) check-in: 2229acce user: drh tags: trunk
10:03
When a cursor points at the last entry of an intkey btree after an insert, leave it there (instead of moving it to the tree root node). This speeds up statements of the form "INSERT INTO ... SELECT ..." that use auto-generated rowids. (CVS 6592) check-in: 9950c0a7 user: danielk1977 tags: trunk
07:36
Do not reset the cursor before seeking it in sqlite3BtreeInsert(). This speeds up INSERT operations that use auto-generated rowid values. (CVS 6591) check-in: 20c4acc2 user: danielk1977 tags: trunk
00:28
When checking indices for xfer compatibility, compare collating sequences by string, not by pointer. (CVS 6590) check-in: 7d2b80c7 user: drh tags: trunk
2009-05-01
21:13
Record within the Token structure itself whether or not the token has been dequoted. This steals one bit from the length of a token and thus limits the size of tokens to 1GiB. (CVS 6589) check-in: 12bcb03d user: drh tags: trunk
15:17
Fix an error message that is generated if the number of columns do not match on an INSERT into a virtual table with hidden columns. (CVS 6588) check-in: 795b453c user: drh tags: trunk
13:16
Update PRAGMA integrity_check so that it treats SQLITE_IOERR_NOMEM errors from underlying components the same as SQLITE_NOMEM errors. (CVS 6587) check-in: 26444f2a user: drh tags: trunk
10:55
Change lock2.test so that it does not enter a busy loop if the child process exists unexpectedly. (CVS 6586) check-in: 164a7f5a user: danielk1977 tags: trunk
06:19
Remove a NEVER() clause from a condition that is true at least once when running attachmalloc.test. (CVS 6585) check-in: 514efc73 user: danielk1977 tags: trunk
05:23
Fix for tempdb.test so that it passes when running the inmemory_journal permutation test. (CVS 6584) check-in: 0256187b user: danielk1977 tags: trunk
02:08
Fix processing of BEFORE triggers on INSERT statements with RHS SELECTs that insert a NULL into the INTEGER PRIMARY KEY. Ticket #3832. (CVS 6583) check-in: 4a1f6a3a user: drh tags: trunk
2009-04-30
17:45
More cleanup, etc. to support MSVC compiles. (CVS 6582) check-in: 2cd9655e user: shane tags: trunk
17:38
Disable an always-false test in the attach.c module. (CVS 6581) check-in: 92b69481 user: drh tags: trunk
16:41
Fix a problem with in-memory sub-journals and exclusive locking mode. Also a test script problem introduced by (6575). (CVS 6580) check-in: d67af3f5 user: danielk1977 tags: trunk
15:59
Documentation updates for sqlite3_set_authorizer(). No changes to code. (CVS 6579) check-in: 41f39c31 user: drh tags: trunk
13:30
Disallow attaching the same database multiple times to the same db connection in shared cache mode, since doing so leads to deadlock. (CVS 6578) check-in: 715f14f1 user: drh tags: trunk
12:25
Fix apparent typo on exclusive.test in the (6575) check-in. (CVS 6577) check-in: 95d22405 user: drh tags: trunk
12:25
Changes sqlite3TempInMemory() to take a const parameter. (CVS 6576) check-in: aa29a14c user: drh tags: trunk
09:10
When SQLite is configured to use in-memory temp files (either by setting SQLITE_TEMP_STORE during compilation or using the temp_store pragma at run time), store statement/savepoint journals in memory also. Ticket #3825. (CVS 6575) check-in: 38f8c5a1 user: danielk1977 tags: trunk
05:40
Fix a memory leak introduced in the previous check-in. (CVS 6574) check-in: f082bf36 user: drh tags: trunk
05:19
Take care not to leave a zombie attached database if the attachment fails due to an encoding mismatch. Update attach logic to always use dynamically allocated error message strings. (CVS 6573) check-in: a6cb4002 user: drh tags: trunk
01:22
Remove always-true tests from attach.c. In btree.c, always test the return from sqlite3PagerSetPagesize() since it might return SQLITE_NOMEM. (CVS 6572) check-in: 8bf60b24 user: drh tags: trunk
00:11
Remove an always-true test from delete.c. Move the sqlite3OpenTable() routine from delete.c to insert.c since it is not used in delete.c. (CVS 6571) check-in: 71756dc8 user: drh tags: trunk
2009-04-29
18:12
Fixed compile for MSVC; removed compiler warnings; changes for NDEBUG build; minor code tweaks. (CVS 6570) check-in: e98b1242 user: shane tags: trunk
17:49
Modify the assemblePage() function in btree.c so that it runs slightly faster. (CVS 6569) check-in: 7ec42e98 user: danielk1977 tags: trunk
14:33
Update the documentation on the sqlite3_changes() and sqlite3_total_changes() functions. (CVS 6568) check-in: 58c7bdb2 user: drh tags: trunk
11:50
Fix a case in where.c where a crash can follow a malloc failure. Also modify test code in test8.c to check a return code that was being dropped (causing a test in vtab_err.test to fail). (CVS 6567) check-in: 9664e2b6 user: danielk1977 tags: trunk
11:31
Add a version of cellSizePtr() that is faster than using sqlite3BtreeParseCellPtr(). This speeds up balance_nonroot(). (CVS 6566) check-in: e8f7f7b7 user: danielk1977 tags: trunk
06:27
Simplify a conditional expression in btree.c. (CVS 6565) check-in: fc3a5ac2 user: danielk1977 tags: trunk
2009-04-28
18:00
Fix an out-of-order test number in blob.test. Cosmetic change. No changes to code. Ticket #3830. (CVS 6564) check-in: e8556542 user: drh tags: trunk
17:33
Fix asserts in hash.c so that zero-length symbols can be used. (CVS 6563) check-in: fe9f00aa user: drh tags: trunk
16:37
When testing with TEMP_STORE=3 and the test pcache, only run 20 iterations in trans.test. Otherwise the test pcache runs out of memory. (CVS 6562) check-in: 0799b729 user: danielk1977 tags: trunk
16:35
Remove an unused function declaration from hash.h. (CVS 6561) check-in: fcf70bb8 user: drh tags: trunk
15:48
Further adjustment to rowhash.test to account for rowid collisions. (CVS 6560) check-in: 94a23f99 user: danielk1977 tags: trunk
15:43
Simplifications to the symbol table implementation in hash.c. For very small symbol tables (less than 10 entries) a simple linked list is used instead of a hash table. Number of hash table buckets is limited to prevent large allocations. (CVS 6559) check-in: 5c737835 user: drh tags: trunk
15:35
Have sqlite3_create_collation() return MISUSE if passed an encoding value other than SQLITE_UTF8, SQLITE_UTF16LE, SQLITE_UTF16BE, SQLITE_UTF16 or SQLITE_UTF16_ALIGNED. (CVS 6558) check-in: 7975b6f2 user: danielk1977 tags: trunk
13:01
Do not store the zero string terminator as part of the name when holding symbols in the symbol table. (CVS 6557) check-in: 23d67af3 user: drh tags: trunk
12:08
Another fix to the same assert as in (6555). It can also fail after a malloc error. (CVS 6556) check-in: e096f90a user: danielk1977 tags: trunk
11:10
Fix an assert that could fail after a parse error in expr.c. (CVS 6555) check-in: a37d1174 user: danielk1977 tags: trunk
05:27
Avoid changing the pager journal-mode once a write-transaction is open, even if no database pages have been modified. (CVS 6554) check-in: ad8aba3e user: danielk1977 tags: trunk
04:51
Add test cases for sqlite3_complete with an EXPLAIN QUERY PLAN on a CREATE TRIGGER statement. Ticket #3828. (CVS 6553) check-in: 6b86b40e user: drh tags: trunk
04:47
Make sure sqlite3_open16() always zeros the db return pointer if SQLite initialization fails. (CVS 6552) check-in: 057c7d17 user: drh tags: trunk
04:46
Enhance sqlite3_complete() so that it understands EXPLAIN QUERY PLAN. Ticket #3828. Testing is done in TH3. (CVS 6551) check-in: 3ac1b15f user: drh tags: trunk
2009-04-27
18:46
Bring the documenation and implementation of sqlite3_collation_needed() into agreement. Use a more efficient implementation of sqlite3ErrStr(). sqlite3_result_error_code() now calls sqlite3ErrStr() if no prior error string was set. (CVS 6550) check-in: cb9af829 user: drh tags: trunk
2009-04-25
08:39
Tests for the new asynchronous IO API. (CVS 6549) check-in: 11b2564e user: danielk1977 tags: trunk
2009-04-24
20:32
Add another test case for the "x IS NULL" uniqueness problem of ticket #3824. No changes to code. This just double-checks that everything is working now. (CVS 6548) check-in: 3ceae357 user: drh tags: trunk
18:06
Dequote the "from" table in a FOREIGN KEY definition (affects the output of "pragma foreign_key_list). Fix for #3800. (CVS 6547) check-in: 600482d1 user: danielk1977 tags: trunk
15:46
Get rid of the special RowSet processing in where.c and move that into clients. Added the WHERE_DUPLICATES_OK option to eliminate an unnecessary RowSet during DELETE with a WHERE clause containing ORs. (CVS 6546) check-in: 98606bee user: drh tags: trunk
14:51
Make sure that the optimizer realizes that an "x IS NULL" contraint does not necessarily give a single-row result even on a UNIQUE index. Ticket #3824. (CVS 6545) check-in: 207335fd user: drh tags: trunk
10:13
Make selecting the asynchronous IO file-locking mode a runtime operation. Still untested. (CVS 6544) check-in: 577277e8 user: danielk1977 tags: trunk
09:27
Improve comments and documentation of the asynchronous IO VFS module. (CVS 6543) check-in: 92bc6be2 user: danielk1977 tags: trunk
2009-04-23
19:08
os_win.c, winOpen(), changed to handle the SQLITE_OPEN_EXCLUSIVE flag and sharing modes in the same manner as os_unix.c. Ticket #3821. (CVS 6542) check-in: 18fef3fc user: shane tags: trunk
18:42
Updated misc. test scripts for Windows testing with gcc/cygwin; (CVS 6541) check-in: 1e2c7159 user: shane tags: trunk
18:41
Remove some incorrect async tests; (CVS 6540) check-in: 03af25b3 user: shane tags: trunk
14:58
Move the asynchronous IO code from src/test_async.c to ext/async/. Refactor it to be a standalone module and to support windows. (CVS 6539) check-in: e71fb0fb user: danielk1977 tags: trunk
13:22
Rework the column-cache mechanism to be more robust (and more correct). The column-alias cache is currently disabled, (CVS 6538) check-in: dd4d67a6 user: drh tags: trunk
2009-04-22
17:15
Eliminate the OP_VRowid opcode. The regular OP_Rowid now work for both regular and virtual tables. (CVS 6537) check-in: ecbef450 user: drh tags: trunk
15:32
Change the OP_Rowid opcode so that a deferred OP_Seek is pending, it simply pulls the rowid from the deferred seek target and does not actually move the cursor or do a seek. Other where.c cleanups. (CVS 6536) check-in: 1c508a99 user: drh tags: trunk
02:15
Remove the rowhash object from the code. Rowset now fills its role. (CVS 6535) check-in: e963bed0 user: drh tags: trunk
00:47
Extend the Rowset object to contain all the capabilities of Rowhash in addition to its legacy capabilities. Use Rowset to replace Rowhash. In addition to requiring less code, This removes the 2^32 result row limitation, uses less memory, and gives better bounds on worst-case performance. The Rowhash implementation has yet to be removed. (CVS 6534) check-in: b101cf70 user: drh tags: trunk
2009-04-21
18:20
Move RowHashBlock.nUsed to RowHash.nUsed. Fix a typo in a comment in test_async.c. (CVS 6533) check-in: 799d31d9 user: danielk1977 tags: trunk
17:23
Fix a segfault that followed a malloc failure introduced by (6527). (CVS 6532) check-in: 08e71b11 user: danielk1977 tags: trunk
17:13
Adjust the rowhash.test module so that it recovers gracefully in the rare event of a rowid collision. (CVS 6531) check-in: 72e16809 user: drh tags: trunk
16:15
Allocate the initial RowHash object using lookaside. (CVS 6530) check-in: 9b30ab71 user: drh tags: trunk
15:05
New comments and minor refactoring of rowhash.c. (CVS 6529) check-in: b8cb4f3e user: drh tags: trunk
12:02
Remove a redundant test from sqlite3_shutdown(). (CVS 6528) check-in: 6f481ceb user: drh tags: trunk
09:02
Attempt to optimize virtual table queries with 'OR' expressions in the WHERE clause. (CVS 6527) check-in: f61e4cd9 user: danielk1977 tags: trunk
2009-04-20
17:43
Change the journal_mode pragma so that it always returns the current journal mode, even on a failed attempt to change the journal mode. Allow the journal mode to be changed as long as there is not a pending transaction. Ticket #3811. (CVS 6526) check-in: 419e320a user: drh tags: trunk