/ 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 9b04e10f6c00c366.

2008-06-25
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
01:03
Do not allow a VACUUM to try to change the page_size on an encrypted database. (CVS 5225) check-in: d49e5020 user: drh tags: trunk
2008-06-16
20:51
Clean up obfuscated code in sqlite3_table_column_meta_data(). Be sure to invoke sqlite3_initialize() within sqlite3_mprintf(). (CVS 5224) check-in: bb4edb53 user: drh tags: trunk
14:36
Fix a recently introduced resource leak in test file incrblob2.test (forgot to close a blob handle). (CVS 5223) check-in: 88e1c609 user: danielk1977 tags: trunk
14:19
Fix a problem with the incremental blob API. sqlite3_blob_open() was always reading the data for the leftmost column of the row that the opened blob was stored in. If this column happened to contain a (the) large blob, sqlite would make a large memory allocation to read the data into. Which defeats the purpose of using incremental blobs. (CVS 5222) check-in: 1b9478da user: danielk1977 tags: trunk
06:31
Add a test to verify that IN(...) WHERE clause terms are not handled by virtual table implemetations. (CVS 5221) check-in: 85483c8f user: danielk1977 tags: trunk
2008-06-15
02:51
Continuing work on the new memory allocation subsystem. Added routines for temporary memory allocation. Right the btree balance mechanism to only do one temporary allocation at a time. (CVS 5220) check-in: 65fe7b62 user: drh tags: trunk
2008-06-14
16:56
Continuing progress on the new memory allocation subsystem. Added the sqlite3_mem_methods structure for defining new memory allocators at run-time. (CVS 5219) check-in: f00305f4 user: drh tags: trunk
2008-06-13
18:24
Progress toward implementation of sqlite3_config() and a rework of the mutex and memory allocation subsystems. This is an incremental check-in. (CVS 5218) check-in: a03c5af1 user: drh tags: trunk
2008-06-12
18:17
Enhance zeroblob tests to use the sqlite3_memory_highwater in order to double-check that no large allocations are occurring. (CVS 5217) check-in: e93079be user: drh tags: trunk
18:05
Fix a typo in the date/time function tests. Add additional cases to the zeroblob tests to make sure sqlite3_bind_zeroblob() does not use excess memory. (CVS 5216) check-in: c1006fb1 user: drh tags: trunk
16:35
Convert the date/time functions to work with milliseconds since the julian epoch internally (instead of days since the epoch) in order to avoid problems with floating-point roundoff error. The interface is unchanged. (CVS 5215) check-in: ed35f8a9 user: drh tags: trunk
14:42
Add another test to incrblob2.test. This test failed to reveal any new bugs. (CVS 5214) check-in: 20d8ea45 user: danielk1977 tags: trunk
13:50
Avoid unnecessary float->text->float conversions in date/time processing. This change necessary to reproduce the problem reported by BareFoot. (CVS 5213) check-in: 6ec4d765 user: drh tags: trunk
12:51
Add the ability to disable the "localtime" modifier in the date/time functions. This might be necessary for systems that do not support localtime_r() or localtime_s(). (CVS 5212) check-in: 12f3ba11 user: drh tags: trunk
12:40
Remove obsolete code from the test_osinst.c module. (CVS 5211) check-in: 699cec66 user: drh tags: trunk
12:38
Copy the latest VFS changes into the OS/2 implementation. This is a blind edit - I have no way to compile or test OS/2. (CVS 5210) check-in: b60508cc user: drh tags: trunk
05:16
Added additional testcases for julianday calculations with midnight boundary for UTC time. (CVS 5209) check-in: edd2cb00 user: shane tags: trunk
02:24
Added x86_64 version of hwtime function. Ticket #3156. (CVS 5208) check-in: 0729f5c3 user: shane tags: trunk
02:16
Removed all C++ style comments. Ticket #3172. (CVS 5207) check-in: 59f72425 user: shane tags: trunk
00:07
Additional refinements to the new sqlite3_initialize() interface design. (CVS 5206) check-in: 14a9b945 user: drh tags: trunk
2008-06-11
18:56
Adjust the error-message text in corrupt7.test. (CVS 5205) check-in: 4a77ff5b user: drh tags: trunk
18:27
Fix an error in the previous commit found by corrupt7.test. (CVS 5204) check-in: afcfba0a user: danielk1977 tags: trunk
18:15
Check that the offsets in the cell-offset array of a b-tree page are within range in sqlite3BtreeInit(). (CVS 5203) check-in: 82f27e28 user: danielk1977 tags: trunk
18:01
Add a test case for the database corruption in the form of cell offsets out of range in an otherwise valid btree page. (CVS 5202) check-in: c569a6cf user: drh tags: trunk