/ 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 56a9ce7774a6f163.

2010-09-28
07:24
Update the version number to 3.7.3 in preparation for the next release. check-in: 88108fff user: drh tags: trunk
07:14
Merge fixes for ticket [b351d95f9cd5ef17e9d9dbae18f5ca8611190001] into the trunk. check-in: 1f7ef0af user: drh tags: trunk
07:11
Replace some unreachable branch instructions with assert() statements. Closed-Leaf check-in: 88b84bf1 user: drh tags: bug-b351d95f9c
06:00
Tweaks to help facilitate structural test coverage. check-in: ff49a5f0 user: drh tags: bug-b351d95f9c
04:14
Test case and fix for the specific failure of ticket [b351d95f9cd5ef17e9d9dbae]. check-in: 57789cfe user: drh tags: bug-b351d95f9c
03:55
Use OP_Copy rather than OP_SCopy at one point in aggregate processing where it is needed to avoid shallow-copy misuse. check-in: a5eefd52 user: drh tags: bug-b351d95f9c
00:25
Continuing work toward detecting and fixing shallow-copy misuse. check-in: d0342f4b user: drh tags: bug-b351d95f9c
2010-09-27
21:09
Add assert() statements that fail when a shallow copy is accessed after the original has been modified. These assert() statements should detect the kinds of subtle SCopy bugs such as caused the fault in ticket [b351d95f9cd5ef17e9d9dbae18f]. check-in: 8b8e1732 user: drh tags: bug-b351d95f9c
18:14
Simplifications to the expression code generator. Remove about 80 lines of older and obsolete code. check-in: 53f5cfe1 user: drh tags: trunk
2010-09-25
22:32
Enhance the ANALYZE command so that it gathers statistics in the sqlite_stat1 table even for tables that are empty or have no indices. check-in: a7645d29 user: drh tags: trunk
17:29
Add new file e_createtable.test. check-in: 20e16fef user: dan tags: trunk
14:13
Do not call gethostuuid() on MacOS 10.4 and earlier, since it is not supported there. check-in: 44deaaef user: drh tags: trunk
07:51
Add tests to file e_reindex.test. check-in: eec7dc91 user: dan tags: trunk
2010-09-24
19:14
Modify some evidence tags to match updated gifs. check-in: f44de500 user: dan tags: trunk
18:08
Merge experimental branch back into trunk. check-in: 83ecec5d user: dan tags: trunk
18:04
Add new file e_vacuum.test. Move part of e_select.test into e_select2.test. Closed-Leaf check-in: 30801892 user: dan
09:32
Add experimental branch disallowing VACUUM when there are one or more active SQL statements. check-in: c1ebcacd user: dan tags: experimental
08:00
Modify testable statement ids in a few test files to account for recent docsrc changes. check-in: 7893e525 user: dan tags: trunk
2010-09-23
18:47
Add tests to e_delete.test. check-in: fab3b383 user: dan tags: trunk
2010-09-22
19:06
Further tests and changes to make the r-tree module more robust. check-in: 7ff3574b user: dan tags: trunk
14:19
Add new file rtreeA.test, to test that the r-tree extension doesn't crash if it encounters a corrupt or inconsistent database. check-in: 68a305fd user: dan tags: trunk
2010-09-21
19:00
Add new file e_delete.test. check-in: 14e8659e user: dan tags: trunk
16:59
Add tests to e_update.test. check-in: 528f71e2 user: dan tags: trunk
2010-09-20
19:17
Add test file e_update.test. check-in: 03985ed4 user: dan tags: trunk
14:55
Changes to test scripts to work with SQLITE_TEMP_STORE=2. check-in: ba8ca9c9 user: dan tags: trunk
14:05
Add further tests to e_insert.test. check-in: eb3d0d8b user: dan tags: trunk
08:47
Add a test case to verify that bug [313723c356] has been fixed. check-in: 4ea134a8 user: dan tags: trunk
2010-09-18
19:36
Make sure the pager cache is cleared if there is any difficulty starting a new read transaction in WAL mode. Ticket [313723c356483eff2a4c4bdd2c]. check-in: e14ef0e8 user: drh tags: trunk
19:00
Add new test file e_insert.test. check-in: 8023a309 user: dan tags: trunk
15:15
Fix a couple of stale evidence marks in e_select.test. check-in: 14227724 user: dan tags: trunk
15:03
Add tests to e_select.test. check-in: 0ee9e755 user: dan tags: trunk
2010-09-17
22:39
Clarifications to the sqlite3_auto_extension() documentation. check-in: ca96e0df user: drh tags: trunk
19:45
Updates to the documentation for sqlite3_create_collation(). check-in: 3df7715a user: drh tags: trunk
19:04
Add tests for some syntax diagrams in lang_select.html. check-in: 2254e93b user: dan tags: trunk
17:10
Remove additional occurrences of <ctype.h> from FTS2. check-in: ee52589c user: drh tags: trunk
16:01
Add new test file fts3shared.test to test the previous change. check-in: a207f744 user: dan tags: trunk
15:28
Have all FTS3 queries obtain a read or write table-lock at the shared-cache level before doing anything else. check-in: 018e82c7 user: dan tags: trunk
01:07
Completely remove all trace of ctype.h from FTS2. check-in: 87684566 user: drh tags: trunk
2010-09-16
23:18
Fix a comment typo in memjournal.c check-in: 9b272ed4 user: drh tags: trunk
19:49
Updates to the requirements on the sqlite3_create_function() family of interfaces. check-in: f03c6089 user: drh tags: trunk
18:51
Add tests for ORDER BY, LIMIT and OFFSET clauses to e_select.test. check-in: 7c989db5 user: dan tags: trunk
16:16
Further tweaks related to deleting files from malloc_common.tcl. check-in: 3e649f80 user: dan tags: trunk
15:58
Fix a problem with the previous change to malloc_common.tcl. check-in: e07a33ea user: dan tags: trunk
15:23
Change code in malloc_common.tcl (test code) to retry a "file delete -force" if it fails. check-in: ebfb04f0 user: dan tags: trunk
2010-09-15
23:41
Updates to the sqlite3_progress_handler() documentation. check-in: 78f659ee user: drh tags: trunk
19:02
Add tests for ORDER BY clauses to e_select.test. check-in: 14f15663 user: dan tags: trunk
17:54
Added the sqlite3_soft_heap_limit64() interface. Deprecate the older sqlite3_soft_heap_limit() interface. check-in: 82268a2c user: drh tags: trunk
11:42
Add trivial test case to make sure shared-cache mode does not automatically turn on exclusive-locking mode. check-in: a0ab3902 user: dan tags: trunk
2010-09-14
18:56
Further tests for compound SELECT statements. check-in: a0f01eba user: dan tags: trunk
18:23
Clarify the documentation to better explain when an automatic re-prepare can be induced by rebinding parameters. Add evidence marks to the automatic re-prepare logic. check-in: 3e11f515 user: drh tags: trunk
10:53
Fix some test failures found running releasetest.tcl. check-in: 56a9ce77 user: dan tags: trunk
2010-09-13
19:03
Fix walmode.test so that all tests pass with SQLITE_TEMP_STORE=3. check-in: 6ba6e59a user: dan tags: trunk
18:58
Add tests for compound SELECT statements to e_select.test. check-in: 8b0b009f user: dan tags: trunk
14:38
Fix a couple of test files so that they work with DEFAULT_AUTOVACUUM. check-in: 8cb39306 user: dan tags: trunk
12:15
Run the multi-threaded tests in test/threadtest3.c as part of releasetest.tcl. Remove the OMIT_BUILTIN_TEST symbol from the "Device-Two" configuration. check-in: 3f5406e3 user: dan tags: trunk
11:29
Alter some configurations in releasetest.tcl. Print out the wall-clock time taken for each test after it is executed. check-in: a91c5af3 user: dan tags: trunk
2010-09-11
17:37
Add tests for "DISTINCT" and "ALL" to e_select.test. check-in: 43a99d9a user: dan tags: trunk
16:25
Fix a couple of incorrect evidence marks on malloc(). check-in: f9b5c5cb user: drh tags: trunk
16:15
Additional evidence marks on the malloc() implementation. Update the documentation to explain that mallocs are not necessarily 8-byte aligned if the SQLITE_4_BYTE_ALIGNED_MALLOC compile-time option is used. check-in: 42b4bf9e user: drh tags: trunk
15:54
Add assert() statements to demonstrate that memory allocations are always aligned to an 8-byte boundary (unless SQLITE_4_BYTE_ALIGNED_MALLOC is defined). check-in: 305cc4e6 user: drh tags: trunk
05:15
When building from the amalgamation with ENABLE_RTREE defined, do not try to include sqlite3rtree.h. check-in: 5b63e981 user: dan tags: trunk
2010-09-10
23:16
fixed memory leak in proxy lock file error handling check-in: e01c5f3e user: adam tags: apple-osx
20:23
A further correction to the sqlite3_create_function() interface documentation. check-in: c65583db user: drh tags: trunk
20:19
replaced relative lock proxy paths with absolute check-in: 782c3351 user: adam tags: apple-osx
19:18
Add tests to e_select.test. check-in: 3a051a76 user: dan tags: trunk
16:38
Updates to the documentation on the sqlite3_create_function() family of interfaces. check-in: 9d277e0b user: drh tags: trunk
13:23
Make sure SQLite is running with MEMSTATUS enabled at the beginning of every test script. check-in: 69995314 user: drh tags: trunk
00:59
replaced relative lock proxy paths with absolute check-in: 6a88cd46 user: adam tags: apple-osx
00:18
Make sure SQLite is running with MEMSTATUS enabled at the beginning of every test script. check-in: b6e9a4d8 user: drh tags: apple-osx
2010-09-09
23:42
Make sure MEMSTATUS is enabled at the beginning of the memsubsys2.test script. check-in: c23b9721 user: drh tags: trunk
23:40
Make sure MEMSTATUS is enabled at the beginning of the memsubsys2.test script. check-in: cf23a354 user: drh tags: apple-osx
23:31
The merge for check-in [415c448dc4] did not do exactly write, resulting in a subtle bug in the SQLITE_FCNTL_SIZE_HINT logic. This check-in is the fix. check-in: badaaa18 user: drh tags: apple-osx
19:02
Add test cases to e_select.test. check-in: 5e73f7b2 user: dan tags: trunk
18:25
Further updates to the sqlite3_pcache_methods documentation, plus the addition of a few evidence marks related to pcache. check-in: 34edb54b user: drh tags: trunk
17:43
Make sure memory statistics are enabled for the dbstatus.test script. check-in: 35b943a0 user: drh tags: trunk
15:48
Updates to the sqlite3_pcache_methods documentation. check-in: b21425c4 user: drh tags: trunk
11:33
Add WHERE clause tests to e_select.test. check-in: 721b73fa user: dan tags: trunk
10:00
Add tests for sub-select statements in the FROM clause of a SELECT to e_select.test. check-in: 2c6b1ca9 user: dan tags: trunk
2010-09-08
19:16
Fix problem with test names in e_select.test. check-in: 8fe34faf user: dan tags: trunk
19:02
Add tests to e_select.test. check-in: 727ced6b user: dan tags: trunk
16:30
Updates to the documentation of the sqlite3_column_xxxx() family of interfaces. Enhance sqlite3_column_blob() so that it always returns a NULL pointer for a zero-length blob. check-in: a932fab2 user: drh tags: trunk
02:30
Improved documentation of SQLITE_THREADSAFE and sqlite3_column_text() and evidence marks for each. check-in: 0d7a5389 user: drh tags: trunk
2010-09-07
23:28
Updates to the documentation on the VFS xOpen method. check-in: 1719cb8f user: drh tags: trunk
19:10
Update the sqlite3_limit() documentation to explain that SQLITE_LIMIT_VDBE_OP is not enforced. check-in: 17be9bee user: drh tags: trunk
19:05
Add tests to e_select.test. check-in: 282dae7e user: dan tags: trunk
14:59
Revised documentation for sqlite3_limit(). Added some evidence marks and assert() statements to verify sqlite3_limit() behavior. check-in: 883b9b74 user: drh tags: trunk
14:12
Example icon file (32x32x4) for new logo. check-in: bd700794 user: shaneh tags: trunk
12:17
Remove a redundant test for multiple output columns in a scalar subquery. check-in: 657472bc user: drh tags: trunk
2010-09-06
20:28
In the test scripts, changes instances of the TCL interface option "-has_codec" into the correct "-has-codec". check-in: f53856a5 user: drh tags: trunk
18:50
Add test cases to e_select.test. check-in: 9db26d5e user: dan tags: trunk
18:44
Remove proprietary information from the releasetest.tcl script and add it to the public repository. check-in: e1d4a87e user: drh tags: trunk
2010-09-04
18:52
Add test file e_select.test. check-in: 8b9d8c22 user: dan tags: trunk
2010-09-03
18:50
Documentation enhancements for sqlite3_db_status(). Evidence marks on the SQL function call intrface. check-in: f06c7b19 user: drh tags: trunk
12:05
Improved documentation of the sqlite3_column_count() and sqlite3_data_count() interfaces. check-in: 0593373d user: drh tags: trunk
10:58
Add a few more subquery tests to e_expr.test. check-in: 189cba00 user: dan tags: trunk
04:29
Reduce the amount of memory taken up by WAL mmaped regions under Windows. check-in: f213e133 user: shaneh tags: trunk
03:32
Fix a discrepancy between the documented behavior of SQLITE_DBCONFIG_LOOKASIDE and what it actually does. Also add evidence marks on the DBCONFIG_LOOKASIDE implementation. check-in: f483be44 user: drh tags: trunk
2010-09-02
19:01
Move the test for an (illegal) scalar sub-query that returns more than one column to earlier in SELECT processing in order to avoid an assert() that can happen later on. check-in: a55842cf user: dan tags: trunk
18:13
Fix an off-by-one error in the scratch memory allocator. check-in: 5a959160 user: drh tags: trunk
17:15
Use sqlite3_mutex_notheld() instead of !sqlite3_mutex_held() inside of assert() statements since the former works when mutexing is disabled while the latter does not. check-in: 2211486b user: drh tags: trunk