/ 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 3240446853a11f5a.

2008-06-28
11:29
Added reminder message to terminate SQL statements with a semicolon on shell startup. This closes #3099. (CVS 5325) check-in: 0ab0b030 user: mihailim tags: trunk
11:23
Rearrange some ENABLE_LOCKING_STYLE related code in os_unix.c. (CVS 5324) check-in: f70d552b user: danielk1977 tags: trunk
2008-06-27
18:59
Changed copy-paste error in comment. Fixes #3193. (CVS 5323) check-in: 00eee53e user: mihailim tags: trunk
14:51
Documentation tweaks. (CVS 5322) check-in: fcbd3934 user: drh tags: trunk
14:05
Fix mem3.c (broken by (5320)). (CVS 5321) check-in: fef90a21 user: danielk1977 tags: trunk
13:27
Change mem5.c so that the minimum allocation size is runtime configurable. (CVS 5320) check-in: 4f95f4cd user: danielk1977 tags: trunk
00:52
Remove unused variable. Fix a compiler warning. (CVS 5319) check-in: 0b01ec5c user: drh tags: trunk
00:47
Tweaks to the IN expression code generator. Fix an an unrelated bug in the compound SELECT code generator. (CVS 5318) check-in: a4005782 user: drh tags: trunk
2008-06-26
21:45
Fix a bug introduced by check-in (5316). Add some VDBE comments to the IN expression code generator. (CVS 5317) check-in: 1043a605 user: drh tags: trunk
20:06
Avoid generating unnecessary SCopy instructions with the RHS of an IN operator is a list of values. (CVS 5316) check-in: ec80474b user: drh tags: trunk
18:16
Documentation updates in sqlite.h.in. No changes to code. (CVS 5315) check-in: 168fd6f8 user: drh tags: trunk
18:04
Fix handling of "x IN (...)" and "x NOT IN (...)" expressions when the set contains an SQL NULL value. (CVS 5314) check-in: d45a97be user: danielk1977 tags: trunk
15:04
Document the rules for when an sqlite3_blob object expires. (CVS 5313) check-in: e1de2287 user: drh tags: trunk
10:54
Change the TEMP_STORE preprocessor symbol to SQLITE_TEMP_STORE. (CVS 5312) check-in: 1e3b8308 user: danielk1977 tags: trunk
10:41
Change the OS_XXX pre-processor symbols to SQLITE_OS_XXX. Symbols "OS_UNIX", "OS_WIN", "OS_WINCE", "OS_OS2" and "OS_OTHER" are now "SQLITE_OS_UNIX", "SQLITE_OS_WIN", "SQLITE_OS_WINCE", "SQLITE_OS_OS2" and "SQLITE_OS_OTHER", respectively. (CVS 5311) check-in: cdd4cf4c user: danielk1977 tags: trunk
08:29
Fix a race condition in sqlite3_initialize(). (CVS 5310) check-in: 70b2ed2a user: danielk1977 tags: trunk
02:53
Documentation updates. No changes to code. (CVS 5309) check-in: cdc4e75a user: drh tags: trunk
2008-06-25
17:54
Change the makefiles so that "make test" now runs the veryquick.test script instead of quick.test. Also modify veryquick.test to reuse the code in quick.test. veryquick.test is now the same as quick.test except that it omits all testing related to malloc and IO error simulation. (CVS 5308) check-in: 8c65146e user: danielk1977 tags: trunk
17:19
Remove internal function sqlite3OsDefaultVfs(). The built-in VFS layers now register their VFS implementations by calling sqlite3_vfs_register() from within sqlite3_os_init(). (CVS 5307) check-in: 8fa33b79 user: danielk1977 tags: trunk
14:57
Have mem3.c and mem5.c grab a mutex when required. Include them both in the amalgamation again. (CVS 5306) check-in: 9e3c95ff user: danielk1977 tags: trunk
14:31
Test enhancements, especially to the new compound-SELECT merge logic. (CVS 5305) check-in: edf7f518 user: drh tags: trunk
14:26
Fix the allocator in mem5.c so that it can be enabled at run time using the sqlite3_config() function. (CVS 5304) check-in: 30ff6bb0 user: danielk1977 tags: trunk
10:34
Fix up some details to do with the mem3.c (memsys3) allocator. If the library is compiled with SQLITE_ENABLE_MEMSYS3, the memsys3 allocator can be selected at runtime. (CVS 5303) check-in: 9c6c8e01 user: danielk1977 tags: trunk
08:02
Fixed typo to close #1731. (CVS 5302) check-in: 9902be8d user: mihailim tags: trunk
02:47
If a unique index covers any prefix of the ORDER BY clause then let it satisfy the ORDER BY clause. (CVS 5301) check-in: e53403b6 user: drh tags: trunk
02:22
Add new test script for compound select statements. (CVS 5300) check-in: a193b161 user: drh tags: trunk
00:12
The compound-select merge optimization passes quick.test with no errors. (CVS 5299) check-in: 8bbfa978 user: drh tags: trunk
2008-06-24
22:50
OS/2 fixes for pre-C99 compilers and a return code correction in os2Access(). (CVS 5298) check-in: 3241a3bd user: pweilbacher tags: trunk
19:02
Modify the memory allocation system in mem3.c so to fit in with the new sqlite3_mem_methods scheme. At this point it only "mostly" works. (CVS 5297) check-in: 3febef54 user: danielk1977 tags: trunk
15:39
Add a few extra tests to select9.test. (CVS 5296) check-in: 37b084fd user: danielk1977 tags: trunk
12:46
Fix a problem in sqlite3ExprIsInteger() causing failures on select1-4.9.2. Other bug fixes in compound-merge. The compound-merge is still disabled in this check-in using "#if 0" due to additional bugs. (CVS 5295) check-in: 95037e6d user: drh tags: trunk
12:28
Remove a surplus "breakpoint" from select4.test. (CVS 5294) check-in: 3117238c user: drh tags: trunk
11:21
Add start of new test file "select9.test". To test LIMIT, OFFSET and ORDER BY on compound SELECT statements. (CVS 5293) check-in: 3a13e943 user: danielk1977 tags: trunk
09:52
Fix a typo in the documentation for the sqlite3_bind_XXX() APIs. (CVS 5292) check-in: 839457f1 user: danielk1977 tags: trunk
00:32
The compound-select merge optimization is mostly working with this check-in. But there are still a few problems and so the optimization is disabled by and "#if 0". This check-in is to synchronize with the other changes happening in parallel. (CVS 5291) check-in: e2ba324c user: drh tags: trunk
2008-06-23
22:13
Update OS/2 mutex implementation: make methods static and don't use them by the old names any more. Held/Notheld should be debug only. (CVS 5290) check-in: d92418ca user: pweilbacher tags: trunk
21:26
Reverted previous checkin (on second thought, changing case could break badly written homegrown parsers such as sometimes encountered in embedded firmware.) (CVS 5289) check-in: bf2e283d user: mihailim tags: trunk
21:18
Changed HTML mode output to use lowercase tags making good on the XHTML output promise (the DTDs indeed mandate lowercase) and closing #450. (CVS 5288) check-in: e07ed82c user: mihailim tags: trunk
20:55
Added ldconfig invocations for postinstall and postuninstall. Updated package URL and description to match the current website. (CVS 5287) check-in: 66529ae3 user: mihailim tags: trunk
18:49
Fix a bug in handling queries on the sqlite_master table with an empty (0 bytes in size) database file. (CVS 5286) check-in: f8238770 user: danielk1977 tags: trunk
17:56
Additional tests added to capi3.test. (CVS 5285) check-in: 1fdab2c6 user: drh tags: trunk
17:44
Fix a failure to report a failed malloc() within sqlite3_create_module(). (CVS 5284) check-in: 3ca7dab8 user: danielk1977 tags: trunk
16:53
Fix a bug causing the pager-cache size to be reset to its default value whenever the database schema was reloaded. (CVS 5283) check-in: 6dbe67da user: danielk1977 tags: trunk
15:55
Run (a subset of) the rtree tests from quick.test. (CVS 5282) check-in: e872c78c user: danielk1977 tags: trunk
15:10
Handle a real system malloc() failure in mem1.c. (CVS 5281) check-in: 006fd69b user: danielk1977 tags: trunk
14:40
Remove a non-ansi construct from mem1.c - an assert() statement before the variable declarations in a function. (CVS 5280) check-in: 1de98da6 user: danielk1977 tags: trunk
14:15
Avoid passing "void(*)(void)" as an argument to va_arg(). Codewarrior doesn't like it. (CVS 5279) check-in: edae76d6 user: danielk1977 tags: trunk
14:03
Fix some codewarrior compilation problems. (CVS 5278) check-in: e6ea8f87 user: danielk1977 tags: trunk
13:57
Fix a compilation problem with SQLITE_OMIT_VIRTUAL_TABLE is defined. (CVS 5277) check-in: 0421c099 user: danielk1977 tags: trunk
11:23
Fixed wrong type in sqlite3_create_collation16 declaration and definition (UTF-16 string had been passed as const char* instead of const void*) (CVS 5276) check-in: 4215e3e5 user: mihailim tags: trunk
11:11
Correct comments above sqlite3_release_memory() and sqlite3_soft_heap_limit(). Ticket #3138. (CVS 5275) check-in: 32404468 user: danielk1977 tags: trunk
09:50
Fix a bug whereby opening a connection to an existing shared-cache caused the cache-size (the value configured by "PRAGMA cache_size") to revert to its default value. (CVS 5274) check-in: 0492aa8e user: danielk1977 tags: trunk
2008-06-22
16:35
Removed INVARIANTS sections in the experimental extension loading API that I should not have added in the first place. No changes to code. (CVS 5273) check-in: e7610890 user: mihailim tags: trunk
12:37
Fix a bug in the KEYINFO handling within select.c. Change the OP_Move opcode to take a count and to move multiple registers. Initial code for the compound-select merge optimization is added but is incomplete and is commented out. (CVS 5272) check-in: 663a590e user: drh tags: trunk
10:21
Readded erroneously deleted {END} tag and doublechecked {(F,U,X)*}-{END} tag balancing. Minor documentation cleanup. No changes to code. (CVS 5271) check-in: b5559050 user: mihailim tags: trunk
09:55
More documentation spellcheck and cleanup. No changes to code. (CVS 5270) check-in: 3a88e3de user: mihailim tags: trunk
08:58
More documentation spellcheck and cleanup. No changes to code. (CVS 5269) check-in: d96b9bcd user: mihailim tags: trunk
2008-06-21
20:11
More documentation spellcheck and cleanup. No changes to code. (CVS 5268) check-in: 65edead1 user: mihailim tags: trunk
19:20
Prevent veryquick.test and all.test from running permutations.test directly. (CVS 5267) check-in: ae9e4c0e user: danielk1977 tags: trunk
19:10
Fix a bug in permutations.test causing the utf-16 tests to fail. (CVS 5266) check-in: 710621f3 user: danielk1977 tags: trunk
18:07
Add test file permutations.test, which runs various other test files with sqlite configured in various ways. This adds a few new tests and replaces test files autovacuum_crash.test, autovacuum_ioerr.test, exclusive3.test, jrnlmode2.test, jrnlmode3.test, jrnlmode4.test, mutex2 and onefile.test. (CVS 5265) check-in: 0e9df350 user: danielk1977 tags: trunk
18:02
More documentation spellcheck and cleanup. No changes to code. (CVS 5264) check-in: 9ae03f56 user: mihailim tags: trunk
16:47
More documentation spellcheck and cleanup. No changes to code. (CVS 5263) check-in: 3edfc64f user: mihailim tags: trunk
13:35
More documentation spellcheck and cleanup. No changes to code. (CVS 5262) check-in: 47b7b05e user: mihailim tags: trunk
12:15
Remove mutex2.test. It will be replaced later today by permutations.test. (CVS 5261) check-in: 98a6a0a3 user: danielk1977 tags: trunk
11:20
More documentation spellcheck and cleanup. No changes to code. (CVS 5260) check-in: 8c457fb0 user: mihailim tags: trunk
08:12
Fix a problem in the test suite that could cause a crash if using a pre-allocated block of memory for pages (the problem was that sqlite3_shutdown() was being called while there were still open database connections). (CVS 5259) check-in: 3d413e9b user: danielk1977 tags: trunk
06:16
Documentation spellcheck and cleanup. No changes to code. (CVS 5258) check-in: 2904d26b user: mihailim tags: trunk
2008-06-20
18:13
Add new Compare and Jump codes to the virtual machine. Use them in the implementation of aggregate queries. (CVS 5257) check-in: 08311365 user: drh tags: trunk
17:51
Add a test to check that opening a second connection to a shared cache does not reset the cache size to its default value. (CVS 5256) check-in: 3546e245 user: danielk1977 tags: trunk
15:24
Change the SRT_Subroutine mode into SRT_Coroutine. Use co-routines in the INSERT processing logic. (CVS 5255) check-in: 6b9d92fc user: drh tags: trunk
14:59
Add a mode to the sqlite3_test_control() interface to register hooks called at the beginning and end of "benign malloc failure" blocks. This allows malloc() failure testing to be done using public APIs only. (CVS 5254) check-in: 56c8af14 user: danielk1977 tags: trunk
11:05
Move (almost all) malloc failure test logic from fault.c to test_malloc.c. (CVS 5253) check-in: 4ae21e34 user: danielk1977 tags: trunk
00:03
Patch to memsubsys1.test in order to avoid a segfault in tableapi.test. (CVS 5252) check-in: 62411a6e user: drh tags: trunk
2008-06-19
18:39
Unset global TCL variables in the func.test script prior to use to avoid conflicts from other scripts. (CVS 5251) check-in: 9b04e10f user: drh tags: trunk
18:17
Move the malloc() failure simulation out of malloc.c and into a separate sqlite3_mem_methods interface. Still some related changes to come. (CVS 5250) check-in: d22cd2a5 user: danielk1977 tags: trunk
17:54
Documentation and test-script updates. (CVS 5249) check-in: 68d4f795 user: drh tags: trunk
16:07
Fix some minor compile problems. (CVS 5248) check-in: 7d38da3e user: drh tags: trunk
15:44
Additional test cases for loadable extensions. (CVS 5247) check-in: 9d73a68c user: drh tags: trunk
15:06
Add recent API additions to the loadable extension interface. (CVS 5246) check-in: 12ba27d9 user: drh tags: trunk
13:20
Check in the missing status.c source file. (CVS 5245) check-in: 298113d4 user: drh tags: trunk
08:51
Shuffle some of the mutex related documentation in sqlite.h.in to match the new sqlite3_mutex_methods based API. (CVS 5244) check-in: 9cd7f866 user: danielk1977 tags: trunk
02:52
Add the sqlite3_next_stmt() interface, including test cases. (CVS 5243) check-in: 565a5308 user: drh tags: trunk
01:50
Fix a bug in the noop-mutex implementation. (CVS 5242) check-in: eec9a54d user: drh tags: trunk
01:03
Bug fixes: Plug a memory leak introduced by the previous check-in. Get the amalgamation to the point where it will compile. (CVS 5241) check-in: 005f8eae user: drh tags: trunk
00:16
Add some test logic to the new memory allocation subsystem. (Lots more needed.) The test suite is currently indicating memory leaks, though it is unclear if this is a true code problem or just an instrumentation problem. (CVS 5240) check-in: cb1f11cd user: drh tags: trunk
2008-06-18
21:08
fix OS/2 files to compile again (looking at Windows equivalents for guidance) (CVS 5239) check-in: 8b14a220 user: pweilbacher tags: trunk
18:57
Remove public APIs sqlite3_mutex_init() and sqlite3_mutex_end(). This commit only changes the code, documentation is not updated yet. (CVS 5238) check-in: 42a2a8f4 user: danielk1977 tags: trunk
18:12
Added support for scratch-memory lookaside allocations. Largely untested. Added calls to sqlite3_initialize() within malloc APIs. (CVS 5237) check-in: 383a7860 user: drh tags: trunk
18:08
Add a call to sqlite3_initialize() to sqlite3_mutex_alloc() (CVS 5236) check-in: 8b23b719 user: danielk1977 tags: trunk
17:59
Fix a test case in mutex1.test that was failing when sqlite was compiled with SQLITE_THREADSAFE=0. (CVS 5235) check-in: d1a87c3b user: danielk1977 tags: trunk
17:09
Implement the 'CONFIG_SINGLETHREAD' and 'CONFIG_MULTITHREAD' configuration modes. (CVS 5234) check-in: 5059644c user: danielk1977 tags: trunk
15:34
Make sure aggregate functions can take any number of arguments up to the limit imposed by SQLITE_LIMIT_FUNCTION_ARGS. Ticket #3179. Modify the group_concat() function to take an unlimited number of arguments in order to facilitate testing this behavior. (CVS 5233) check-in: 70c6739f user: drh tags: trunk
13:47
Add documentation on the sqlite3_mutex_methods object. (CVS 5232) check-in: c3c7bfc9 user: drh tags: trunk
13:27
Added new configuration options to query the low-level malloc interface and to provide memory buffers for scratch, page-cache, and heap memory allocators. (CVS 5231) check-in: e36201a3 user: drh tags: trunk
09:45
Add some test infrastructure and cases for the new mutex api. (CVS 5230) check-in: 262baee9 user: danielk1977 tags: trunk
02:01
Remove mem3.c and mem5.c from the amalgamation for the time being, since they do not currently work. We will add them back later once they are fixed. (CVS 5229) check-in: 39b4e1ff user: drh tags: trunk
2008-06-17
18:57
Add the SQLITE_CONFIG_MUTEX symbol for use with sqlite3_config(). (CVS 5228) check-in: af1835bb user: danielk1977 tags: trunk
17:21
Change the mutex interface to be pluggable. This is an incremental checkin, there are still changes to come. (CVS 5227) check-in: 59728363 user: danielk1977 tags: trunk
15:12
Add internal interfaces: PageMalloc/PageFree and ScratchMalloc/ScratchFree. (CVS 5226) check-in: 3e797d0f user: drh tags: trunk