/ 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 check-ins occurring around 47b40fefa67f7c56.

2009-07-24
12:35
Simplifications and comment improvements in pager.c. (CVS 6926) check-in: 2d2f42ca user: drh tags: trunk
2009-07-23
01:44
Simplifications and comment enhancements on btree.c. (CVS 6925) check-in: 5ba880dd user: drh tags: trunk
2009-07-22
18:24
Modify mksqlite3c.tcl so that it inserts SQLITE_API macros into sqlite3.h. Ticket #3983. (CVS 6924) check-in: 803ec79f user: danielk1977 tags: trunk
18:07
Simplifications to btree.c in support of coverage testing. (CVS 6923) check-in: 375fd6f9 user: drh tags: trunk
16:41
Avoid leaving a suspect page in the page-cache if an error occurs during sqlite3PagerAcquire(). (CVS 6922) check-in: 2594f01c user: danielk1977 tags: trunk
14:08
Fix a double-free that can occur after database corruption is detected. (CVS 6921) check-in: 5260e8b1 user: danielk1977 tags: trunk
13:19
Add a NEVER() macro around a pager.c conditional that must always be false in the current implementation. (CVS 6920) check-in: 1e510d7f user: drh tags: trunk
07:27
Changes to test code (only) to allow veryquick.test to run with OMIT_UTF16 builsd. Ticket #3985. (CVS 6919) check-in: 7f3fc7f2 user: danielk1977 tags: trunk
02:02
Remove an ALWAYS() from a condition that can in fact be false under very obscure circumstances. (CVS 6918) check-in: 38083228 user: drh tags: trunk
00:35
Further simplifications to btree.c, especially the sqlite3BtreeKey() and sqlite3BtreeData() functions. New assert() statements added to verify that these routines are called correctly. (CVS 6917) check-in: 96cfd079 user: drh tags: trunk
2009-07-21
19:25
Change getAndInitPage() (btree.c) to use only PagerAcquire(), not PagerLookup() and PagerAcquire(). (CVS 6916) check-in: 0b41dfc0 user: danielk1977 tags: trunk
19:02
Additional simplifications to btree.c in support of coverage testing. (CVS 6915) check-in: 716fccea user: drh tags: trunk
15:33
Remove an assert() in btree.c which is no longer true due to changes in the error reporting behavior of ptrmapPut(). (CVS 6914) check-in: 110998f1 user: drh tags: trunk
11:52
Changes to btree.c in support of coverage testing. (CVS 6913) check-in: 4cf23e9e user: drh tags: trunk
2009-07-20
19:30
Reverse the order of two conditionals in a test in order to achieve coverage of them both. Also: clarifications to comments in btree.c. (CVS 6912) check-in: a159e9d2 user: drh tags: trunk
17:11
Modify various routines inside btree.c to take a pointer to the return-code as a parameter and to no-op if the return-code storage location already contains a non-zero code. (CVS 6911) check-in: 7dcf2a78 user: drh tags: trunk
12:33
Use an ALWAYS() on a conditional in btmutex.c that is always true. (CVS 6910) check-in: 609022ca user: drh tags: trunk
12:25
Corrections to the comment that is inserted at the top of the amalgamation. Ticket #3981. (CVS 6909) check-in: 7572991b user: drh tags: trunk
11:32
Always provide a name for the TEMP database even if SQLite is compiled using SQLITE_OMIT_TEMPDB. (CVS 6908) check-in: 0ba17c04 user: drh tags: trunk
2009-07-18
20:01
Code tweaks in support of full-coverage testing. (CVS 6907) check-in: 22c6dbfd user: drh tags: trunk
14:36
Add some code to sqlite3VdbeMemSetZeroBlob() so that it works (less efficiently) even when OMIT_INCRBLOB is defined. Ticket #3977. (CVS 6906) check-in: f5f7259d user: danielk1977 tags: trunk
11:52
When the asynchronous IO backend opens a file with the EXCLUSIVE flag set, make sure only a single file-descriptor is opened (not one for reading and one for writing). This change fixes #3978. (CVS 6905) check-in: 630e669b user: danielk1977 tags: trunk
08:30
Changes to test scripts so that (make test) works when OMIT_INCRBLOB is defined. (CVS 6904) check-in: 1dd834a3 user: danielk1977 tags: trunk
2009-07-17
17:25
Fix a subtle problem that can occur when a transaction is automatically rolled back, and afterwards a VM that had opened a statement transaction within the abandoned transaction is finalized. Fixes an assert() that was failing in rtree3.test. (CVS 6903) check-in: 910df46e user: danielk1977 tags: trunk
16:54
Return a meaningful error message if a keyword is used as an rtree table column name. Ticket #3970. (CVS 6902) check-in: 046efe46 user: danielk1977 tags: trunk
14:37
Skip all tests in tableapi.test if SQLITE_OMIT_GET_TABLE defined. Ticket #3975. (CVS 6901) check-in: 0219a543 user: shane tags: trunk
11:44
Code simplifications in support of structural testing. (CVS 6900) check-in: fb1b955d user: drh tags: trunk
2009-07-16
18:21
Code simplifications and comment improvements in support of structural coverage testing. (CVS 6899) check-in: 94525179 user: drh tags: trunk
12:41
Remove an unused variable from sqlite3ExprListDup(). Ticket #3973. (CVS 6898) check-in: 17c05aef user: drh tags: trunk
2009-07-15
18:15
Fix a potential database corruption following DROP TABLE when the pending byte page corresponds to a ptrmap page. This situation cannot happen in a real deployment - but it still needs to be fixed. (CVS 6897) check-in: 6242db39 user: drh tags: trunk
17:25
Simplifications to btree.c in support of structural testing. Renamed the "skip" field of the BtCursor object to "skipNext" to make it easier to search for places where it is used. (CVS 6896) check-in: d3897235 user: drh tags: trunk
16:30
Remove an assert() from vdbeaux.c that might not be true if the database file is corrupt. (CVS 6895) check-in: a42dc51e user: drh tags: trunk
11:26
Added the SQLITE_TESTCTRL_RESERVE option to sqlite3_test_control(). Simplifications to btree.c to facilitate structural coverage testing. (CVS 6894) check-in: cfbeda1b user: drh tags: trunk
2009-07-14
18:35
Add comments and assert() statements to show that the return value from sqlite3BtreeKeySize() and sqlite3BtreeData() usually do not matter. Ticket #3968. Also remove a NEVER() macro that can sometimes be true - discovered while testing the previous change. (CVS 6893) check-in: 0c710c1b user: drh tags: trunk
17:48
Simplifications to the PRAGMA integrity_check logic. Remove unreachable code. (CVS 6892) check-in: 17749fa5 user: drh tags: trunk
14:15
Simplifications and tweaks to vdbeaux.c resulting from structural testing. (CVS 6891) check-in: fa49666f user: drh tags: trunk
02:33
Make sure the IN operator works with zeroblobs. Ticket #3965. Other simplifications associated with structural testing. (CVS 6890) check-in: 25dd3422 user: drh tags: trunk
2009-07-13
15:52
Remove the SQLITE_CommitBusy flag. This was an attempt to block recursion on the sqlite3_commit_hook() interface. But such recursion is explicitly disallowed, so the flag is pointless. (CVS 6889) check-in: 1c2bfc43 user: drh tags: trunk
13:18
Change an unreachable condition in btree.c to a NEVER(). (CVS 6888) check-in: 9f800e11 user: danielk1977 tags: trunk
11:22
In sqlite3PagerWrite(), do not set the PGHDR_NEED_SYNC flag on a page if an IO error occured while attempting to journal it. (CVS 6887) check-in: b9be365d user: danielk1977 tags: trunk
09:41
Remove an assert ("assert( subpage>0 )") from btree.c that may not be true for a corrupt database. Also add comments and other assert() statements to btree.c function moveToRoot(). (CVS 6886) check-in: 3151dab9 user: danielk1977 tags: trunk
07:30
Remove a case from BtreeMovetoUnpacked() that is unreachable as of (6881). (CVS 6885) check-in: 39ce2097 user: danielk1977 tags: trunk
2009-07-12
02:32
Simplifications to btree.c to help facilitate coverage testing. (CVS 6884) check-in: dfb146ef user: drh tags: trunk
02:31
When an OOM fault occurs while moving a page for autovacuum in an in-memory database, be sure to undo the page move prior to returning the error, to avoid corrupting the in-memory database file. (CVS 6883) check-in: d0964b93 user: drh tags: trunk
2009-07-11
18:26
Remove an unused parameter from the accessPayload() function in btree.c. (CVS 6882) check-in: 7deb6568 user: drh tags: trunk
17:39
Fix a case where deleting a row from a corrupt database could cause an assert to fail. (CVS 6881) check-in: 6994b41a user: danielk1977 tags: trunk
17:04
Bug fix in the computation of the number of pages to autovacuum when nReserve is greater than zero. (CVS 6880) check-in: 618a83d6 user: drh tags: trunk
13:13
Unwind some complex conditions in sqlite3BtreeDelete() into separate "if" statements. (CVS 6879) check-in: d99bde9c user: drh tags: trunk
11:45
Remove another unreachable branch from btree.c. (CVS 6878) check-in: b0853100 user: danielk1977 tags: trunk
06:55
Modify the integrity-check code so that each b-tree page inspected is reinitialized while doing so, even if an initialized copy exists in the cache. This prevents an assert from failing when running integrity_check on a corrupt database. (CVS 6877) check-in: 709576c6 user: danielk1977 tags: trunk
05:06
Remove unreachable condition from btree.c. (CVS 6876) check-in: 47b40fef user: danielk1977 tags: trunk
2009-07-10
16:51
Fix a pager reference count leak in btree that occurs on an OOM following a database page size change. (CVS 6875) check-in: c6dfc8bd user: drh tags: trunk
09:24
Fix a double-free that can occur when using the fts3 legacy syntax '-' operator. Add tests for the same operator. Ticket #3960. (CVS 6874) check-in: c19d419e user: danielk1977 tags: trunk
02:52
Simplifications to the PRAGMA integrity_check logic in btree.c. (CVS 6873) check-in: 440c573c user: drh tags: trunk
2009-07-09
13:25
Fix two faulty assert() statements btree. (It was possible for the assertions to be false given a corrupt database file as input.) (CVS 6872) check-in: 9403f04d user: drh tags: trunk
11:36
Remove an unused branch from btree.c. (CVS 6871) check-in: 45efb78a user: danielk1977 tags: trunk
08:27
In btree.c, have setSharedCacheLock() assume that the b-tree is sharable instead of checking to see if it is. The caller has already performed this check. (CVS 6870) check-in: 3190eefd user: danielk1977 tags: trunk
05:07
Restore (btree_set_cache_size) to test3.c. This is used on unix for the tcl "crash tests". Make some functions no longer used outside of btree.c static. (CVS 6869) check-in: 1d96ce8c user: danielk1977 tags: trunk
03:20
removed the test function sqlite3BtreeFlags() (test code only); (CVS 6868) check-in: 579ba6c8 user: shane tags: trunk
02:48
removed unused functions from test3.c (test code only); (CVS 6867) check-in: 0eb69e8d user: shane tags: trunk
02:24
Simplifications and additional testcase() macros for btree.c. (CVS 6866) check-in: 1b8c3a82 user: drh tags: trunk
2009-07-08
18:50
Fix a typo in (6861): "ifndef SQLITE_TEST" -> "ifdef SQLITE_TEST". (CVS 6865) check-in: 890dbab2 user: danielk1977 tags: trunk
18:45
Revert part of (6860) that was accidentally checked in. (CVS 6864) check-in: 11e295cc user: danielk1977 tags: trunk
18:12
Add another boundary-condition testcase() macro to btree.c. Correct the comment on modifyPagePointer(). (CVS 6863) check-in: fed66e86 user: drh tags: trunk
16:54
Improvements to comments in btree.c:freeSpace(). Added a testcase() macro to verify a boundary case is tested in sqlite3BtreeInitPage(). (CVS 6862) check-in: 5ac991b3 user: drh tags: trunk
15:14
Comment out sqlite3BtreeFlags() when not in debug mode. Tweaks to database corruption detection logic in freeSpace(). (CVS 6861) check-in: 196cbf82 user: drh tags: trunk
13:55
Fix error handling in sqlite3BtreePutData(). (CVS 6860) check-in: 86eba4f1 user: danielk1977 tags: trunk
08:05
Remove an ALWAYS clause that could be false if an IO error within a statement executed by a virtual table caused an emergency rollback. (CVS 6859) check-in: 0cc705c2 user: danielk1977 tags: trunk
01:49
Simplifications to sqlite3BtreeInsert() and allocateSpace(). Added many testcase() macros to verify boundary conditions in btree.c. (CVS 6858) check-in: aab82a22 user: drh tags: trunk
2009-07-07
17:38
Improvements to corrupt database detection in defragmentPage(). (CVS 6857) check-in: 87bbc8d6 user: drh tags: trunk
15:47
Do not load the root-page of a b-tree table/index when opening a cursor. Instead, allow it to be loaded when the cursor is first used (in function moveToRoot()). Also move the root-page flags sanity checks that were a part of the OP_OpenRead/OpenWrite opcodes into the moveToRoot() function. (CVS 6856) check-in: 06dcfe72 user: danielk1977 tags: trunk
13:56
If an error occurs in PagerBegin(), call pager_end_transaction() to reset the internal state of the pager object. (CVS 6855) check-in: ea7ed166 user: danielk1977 tags: trunk
11:39
Fix a reference count problem following database corruption detection in the ptrmapPut() routine of btree.c. (CVS 6854) check-in: ec1e27e3 user: drh tags: trunk
02:44
Simplifications to btree.c and vdbeaux.c in support of structural coverage testing. (CVS 6853) check-in: fc2a40a9 user: drh tags: trunk
2009-07-06
21:54
Fix the pager so that it remembers the name of the journal for an in-memory database as an empty string. This is important when committing a multi-database transaction that includes one or more attached memory databases. (CVS 6852) check-in: 31a5e819 user: drh tags: trunk
19:03
Fix the backup logic so that it detects a failure to sqlite3BtreeUpdateMeta() and reports that failure back up to the top level. (CVS 6851) check-in: 471b92f2 user: drh tags: trunk
18:56
Make the sqlite3BtreeMoveto function static, since it is only used from within btree.c. Remove unused function lockBtreeWithRetry from btree.c. (CVS 6850) check-in: 30d5ec62 user: danielk1977 tags: trunk
00:44
Simplifications and comment cleanup in vdbeaux.c. (CVS 6849) check-in: 1636e783 user: drh tags: trunk
2009-07-04
17:16
Remove unreachable code from function btreeCursor() in btree.c. (CVS 6848) check-in: c76a366e user: danielk1977 tags: trunk
15:41
Remove a redundant branch from btree.c. (CVS 6847) check-in: 133357d2 user: danielk1977 tags: trunk
2009-07-03
22:54
Remove two unused fields from the Parse structure. The TCL interface now removes leading whitespace from SQL statements before parsing them. (CVS 6846) check-in: 983cb692 user: drh tags: trunk
19:19
Remove unused code (that was commented out) from prepare.c. Remove an incorrect NEVER() macro. Fix the comment on schemaIsValid() to correctly describe its return behavior. (CVS 6845) check-in: 90deb658 user: drh tags: trunk
19:18
Cause sqlite3_exec() to return SQLITE_NOMEM if it cannot allocate memory to hold the error message for some other error. (CVS 6844) check-in: e9849292 user: drh tags: trunk
17:23
Remove an unused variable from the test code in test3.c. (CVS 6843) check-in: 9e35bec9 user: drh tags: trunk
17:09
Add a version of the Lemon parser template "lempar.c" to the src/ subfolder. This new parser template contains a couple of NEVER() macros that disable tests that are needed for general grammars but not for the specific grammar used by SQLite. SQLite builds with the modified lempar.c. (CVS 6842) check-in: d426cc64 user: drh tags: trunk
16:25
Simplify the way the read-uncommitted flag is handled to facilitate test coverage. (CVS 6841) check-in: e2112d61 user: danielk1977 tags: trunk
15:37
Make explicit the restrictions on UPDATE, DELETE, and INSERT statement syntax within triggers. Ticket #3947. (CVS 6840) check-in: c8bf40df user: drh tags: trunk
12:57
Test the result of pthread_create() and do not call pthread_join() if the thread creation failed. Ticket #3933. (CVS 6839) check-in: 304c5110 user: drh tags: trunk
2009-07-02
18:40
Fix to sqlite3AuthRead to accommodate "new" or "old" references that are used in a context where a column reference may also be used (i.e. "SELECT new. FROM <tble>"). Ticket #3944. (CVS 6838) check-in: 45fd5419 user: danielk1977 tags: trunk
17:21
When a b-tree transaction is committed when there are open cursors, downgrade shared-cache write-locks to read-locks instead of relinquishing all locks. Fix for #3942. (CVS 6837) check-in: 611e704f user: danielk1977 tags: trunk
07:47
Cause opening a transaction on a sharable b-tree module automatically obtain a read-lock on page 1. This means there is no way for sqlite3BtreeGetMeta() to fail. (CVS 6836) check-in: e3c055f1 user: danielk1977 tags: trunk
05:23
Fix for compilation with OMIT_AUTOVACUUM defined. Ticket #3940. (CVS 6835) check-in: 8f0591ae user: danielk1977 tags: trunk
2009-07-01
18:09
Change to test code and scripts allowing memsys3 to be tested using a build that has both memsys3 and memsys5 enabled. (CVS 6834) check-in: a00aeec2 user: danielk1977 tags: trunk
18:04
Fix a 1-byte buffer overwrite that can occur when a virtual table overloads an SQL function. (CVS 6833) check-in: bfe336a8 user: danielk1977 tags: trunk
16:12
Report an error if a USING or ON clause is specified following a from-list element that is not to the right of a join operator. Fix for #3846. (CVS 6832) check-in: 29b48972 user: danielk1977 tags: trunk
14:56
Do not ignore alias "a" in a query of the form "SELECT ... FROM (...) AS a" Fix for #3935. Also expand upon (6751) to fix some similar obscure memory leaks. (CVS 6831) check-in: 42f9d1e5 user: danielk1977 tags: trunk
2009-06-29
06:00
Cause incremental-blob read/write operations lock shared-cache tables in the same way as normal SQL read/writes. Add complex assert statements to make sure tehe correct shared-cache locks are held when accessing the database. Eliminate some redundant checks from btree.c. (CVS 6830) check-in: f17ef378 user: danielk1977 tags: trunk
2009-06-27
14:10
Version 3.6.16 (CVS 6829) check-in: ff691a6b user: drh tags: trunk, release
11:17
Fix an instance where sqlite3JumpHere() might be called with a negative address following an OOM fault. (CVS 6828) check-in: 49f22e55 user: drh tags: trunk
00:48
Fix a bug in sqlite3_realloc() - if called with a size of more than 2147483392 it returns 0 but it also releases the prior allocation. (CVS 6827) check-in: 653df0af user: drh tags: trunk