/ 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 8362d883248f00a8.

2009-04-17
15:18
Get the behavior of SQLITE_HAVE_ISNAN right. It was reversed in check-in (6517). Ticket #3809. (CVS 6518) check-in: 97c6ea23 user: drh tags: trunk
11:57
Add the SQLITE_HAVE_ISNAN compile-time option which, if present, causes SQLite to use the math library isnan() function rather than its own homebrew implementation of isnan(). (CVS 6517) check-in: 54d23521 user: drh tags: trunk
11:56
Check-in (6514) did not completely remove the obsolete test, resulting in a segfault. This check-in finishes the job. Ticket #3802. (CVS 6516) check-in: c29b37ea user: drh tags: trunk
2009-04-16
17:45
Add NEVER and ALWAYS tags to conditionals in analyze.c that always false or true. (CVS 6515) check-in: fbbc80ea user: drh tags: trunk
16:32
Remove obsolete test from bindxfer.tcl. Ticket #3802. (CVS 6514) check-in: b1b09617 user: drh tags: trunk
16:30
Changes to alter.c to enable full branch coverage testing. (CVS 6513) check-in: 6a91ab08 user: drh tags: trunk
12:58
Make sure the 'unixepoch' converter in the date and time functions rounds to the nearest millisecond rather than truncating downward to the next smaller millisecond. Ticket #3808. (CVS 6512) check-in: e6e036b3 user: drh tags: trunk
00:24
In a 3-fold compound SELECT make sure early code generation of the SELECTs to the right do not dereference non-existant columns in SELECTs on the left. (CVS 6511) check-in: 414f3408 user: drh tags: trunk
2009-04-15
15:16
Fix the group_concat() function so that it inserts the separator string even if the initial content strings are empty. Ticket #3806. (CVS 6510) check-in: b83fbf15 user: drh tags: trunk
14:36
Fix access violation on WinCE platforms. Ticket #3804. (CVS 6509) check-in: e203ad40 user: shane tags: trunk
13:39
Mark an branch in alter.c as always false. Only run the assert() on the sqlite3_aggregate_count() function in func.c if the SQLITE_OMIT_DEPRECATED compile-time option is off. (CVS 6508) check-in: c0bba77a user: drh tags: trunk
13:07
Disable the temptrigger.test test script when shared cache is disabled. Ticket #3801. (CVS 6507) check-in: feedbce8 user: drh tags: trunk
2009-04-14
18:44
nMax can be zero and subtracting 1 from an unsigned zero produces undesirable results (CVS 6506) check-in: a117d82d user: aswift tags: trunk
12:58
Change the sqlite3_bind_value() implementation to use a default branch on the type switch so that there are no untested jumps in the switch. (CVS 6505) check-in: d0a8bd6a user: drh tags: trunk
12:43
Reimplement the sqlite3_bind_value() interface so that it works when the value being bound comes from a different database connection. (CVS 6504) check-in: 3db0c798 user: drh tags: trunk
2009-04-13
14:43
Enhancements to virtual table documentation. Comment changes only. No changes to code. (CVS 6503) check-in: b0b2b283 user: drh tags: trunk
09:29
Version 3.6.13 (CVS 6502) check-in: 982cc7f4 user: drh tags: trunk, release
09:09
Rerun autoconf in preparation for 3.6.13. (CVS 6501) check-in: f683e222 user: drh tags: trunk
08:14
updated Makefile.vxwSH4 and renamed it to Makefile.vxworks, should now be able to support SH4 and PPC targets. (CVS 6500) check-in: e4a370c7 user: chw tags: trunk
2009-04-11
19:09
Fix malloc5.test so it work on both 64-bit and 32-bit systems. The ::tcl_platform(wordSize) variable has to be used to adjust some memory sizes. (CVS 6499) check-in: ea20f78e user: drh tags: trunk
16:27
Fix an obscure problem with recovery from I/O errors while rolling back. (CVS 6498) check-in: 24ff4861 user: drh tags: trunk
16:27
Add a comments and an assert() to the virtual table implementation. No functional changes. (CVS 6497) check-in: ac5d0c0a user: drh tags: trunk
16:06
Fix a case where a corrupt database could cause an assert() to fail. (CVS 6496) check-in: 2c560e05 user: danielk1977 tags: trunk
14:46
Allocate a little extra scratch space for the memsubsys1 tests. The extra space is needed in some configurations. (CVS 6495) check-in: 54844192 user: drh tags: trunk
11:38
Increase the hard upper bound on the number of pcache pages in test_pcache when the test harness is compiled for in-memory temp tables. Some of the test cases need to extra memory to avoid unplanned out of memory errors. (CVS 6494) check-in: 7f2d6a0b user: drh tags: trunk
10:25
Replace invocation of (really_finish_test) from async.test with (finish_test). Otherwise a tcl exception may be thrown when running permutations. (CVS 6493) check-in: e6465e9d user: danielk1977 tags: trunk
09:51
In sqlite3PagerMovepage(), avoid holding a reference to page number X when calling sqlite3PcacheRekey() to move another page to page number X. (CVS 6492) check-in: 4447c94f user: danielk1977 tags: trunk
2009-04-10
23:11
Remove more unused branches from vdbeapi.c. (CVS 6491) check-in: 447e9595 user: drh tags: trunk
20:55
In the async test, make sure procedures do not get renamed over top of one another. (CVS 6490) check-in: b6430cc4 user: drh tags: trunk
20:32
Remove unused branches from the vdbeapi.c module. (CVS 6489) check-in: 7ae0fc7e user: drh tags: trunk
18:41
Increase the error tolerance when verifying the approximate size of a pseudo-random database in backup_ioerr.test. Otherwise the test could fail depending on the PRNG seed. (CVS 6488) check-in: deda5ab3 user: danielk1977 tags: trunk
18:32
Do not run io.test as part of the inmemory_journal permutation. io.test uses the tcl API to test for journal files in the file-system (which of course never exist when running with in-memory journals). (CVS 6487) check-in: 493f03bd user: danielk1977 tags: trunk
18:21
Re-enable the alt_pcache tests in permutations.test so that they run automatically during a full regression. Fix async.test so that it works with the permutation.test pcacheNN test modules. (CVS 6486) check-in: 310192cc user: drh tags: trunk
15:42
Fix MSVC compiler warning in vdbeaux.c. (CVS 6485) check-in: d619465e user: shane tags: trunk
15:38
Disable the select1-15 tests when locking_mode is EXCLUSIVE. Ticket #3771. (CVS 6484) check-in: 88cefbb4 user: drh tags: trunk
15:02
Changes to jrnlmode.test to account for in-memory temp databases. (CVS 6483) check-in: c31d4359 user: danielk1977 tags: trunk
14:28
Simplifications and additional comments on the sqlite3_get_table() implementation. Changes to facilitate full branch test coverage. (CVS 6482) check-in: 57e3e6b3 user: drh tags: trunk
12:55
Changes to ensure that when running in shared-cache mode with a non-threadsafe build, the correct busy-handler callback is always invoked. (CVS 6481) check-in: 683e4bd7 user: danielk1977 tags: trunk
09:47
Always set BtShared.db when entering the BtShared mutex. Ticket #3793. (CVS 6480) check-in: ed6620ba user: danielk1977 tags: trunk
00:56
Force 8-byte alignment of sqlite3_value objects in the sqlite3VdbeUnpackRecord() primitive. Ticket #3777. (CVS 6479) check-in: 2cc68272 user: drh tags: trunk
2009-04-09
21:02
Increase the version number to 3.6.13 in preparation for the next release. (CVS 6478) check-in: 9a09a474 user: drh tags: trunk
14:27
Provide dummy DWORD arguments to output parameters of GetDiskFreeSpace(A|W), NULL causes access violations on Windows NT 4.0 (CVS 6477) check-in: 5350a658 user: chw tags: trunk
14:02
Remove misuse detection from the deprecated sqlite3_transfer_bindings() interface. The code was hard to test and was simply taking up space. (CVS 6476) check-in: 4cd82910 user: drh tags: trunk
01:23
Enhance sqlite3_shutdown() so that it automatically invokes sqlite3_reset_auto_extension(). This is a harmless no-op if applications are already calling sqlite3_reset_auto_extension() prior to sqlite3_shutdown(). And it prevents possible memory corruption if they do not. So it works either way. Most of the changes are to the test cases. (CVS 6475) check-in: 0c41f7cf user: drh tags: trunk
2009-04-08
23:05
Simplify the implementation of the columnName() function in vdbeapi.c. This is a code cleanup only - no behavior changes. (CVS 6474) check-in: 0628f586 user: drh tags: trunk
23:04
Add an assert() to the implementation of count(*) that checks the correct operation of the sqlite3_aggregate_count() function. (CVS 6473) check-in: f322be38 user: drh tags: trunk
16:10
Reconfigure the default case for the printf switch in order to improve branch coverage. (CVS 6472) check-in: 3cc79162 user: drh tags: trunk
15:45
Remove a pair unnecessary conditions from printf.c. The "db" parameter is now required for sqlite3MPrintf(). (CVS 6471) check-in: 6fe8b5d7 user: drh tags: trunk
13:51
Minor refactoring of the expression-compaction logic for clarity of presentation. New comments added. The EXPRDUP_DISTINCTSPAN flag is removed as obsolete. (CVS 6470) check-in: 44ded2ea user: drh tags: trunk
12:21
Do not attempt to walk a TokenOnly or SpanOnly expression tree node. Ticket #3791. (CVS 6469) check-in: 8362d883 user: drh tags: trunk
11:49
Add a comment to printf.c - no changes to code. (CVS 6468) check-in: ee5a4a0e user: drh tags: trunk
2009-04-07
22:06
Fix the sqlite3_unlock_notify() interface so that when the callback is NULL it simply cancels any outstanding callbacks. (CVS 6467) check-in: 9ccfcb76 user: drh tags: trunk
22:05
Remove two unused tests from the integrity_check pragma logic. (CVS 6466) check-in: 22999d31 user: drh tags: trunk
14:38
Fix an incorrect assert in btree.c. (CVS 6465) check-in: 2c1f5983 user: danielk1977 tags: trunk
14:14
Fix compilation and testing when SQLITE_OMIT_TRIGGER is defined. Ticket #3786. (CVS 6464) check-in: 277dace4 user: danielk1977 tags: trunk
13:48
Only enable WHERE-tracing when both TEST and DEBUG are enabled. (CVS 6463) check-in: 55b93649 user: drh tags: trunk
11:21
Change "... myfunction() { ... }" to "... myfunction(void) { ... }" in a few pla ces. Ticket #3783. (CVS 6462) check-in: 6f79e6ae user: danielk1977 tags: trunk
09:16
Have OP_IdxRowid handle the case where the index entry it is reading from is deleted. (CVS 6461) check-in: cdad29b5 user: danielk1977 tags: trunk
05:35
Compile fixes and improvements for vxwork: fixed deadlock in semClose, detect if fcntl is usable, fall back to named semaphores if not. (CVS 6460) check-in: efd0682b user: chw tags: trunk
00:49
Remove an unused test for EXPLAIN-mode in the PRAGMA processing. (CVS 6459) check-in: 909683b3 user: drh tags: trunk
00:43
Always enable WHERE-tracing on a test build. Oops - accidentally included a debugging change to pragma.c in this check-in. The real fix for the pragma problem is in the following checking. (CVS 6458) check-in: 567cf90b user: drh tags: trunk
00:35
It is OK for a unix file descriptor to be zero. It just can't be negative. Adjust an assert accordingly. Ticket #3781. (CVS 6457) check-in: 47aa7eb0 user: drh tags: trunk
2009-04-06
17:50
Test cases and minor code changes to increase coverage of btree.c. (CVS 6456) check-in: def3a016 user: danielk1977 tags: trunk
15:55
Updates and clarification to the documentation of the sqlite3_temp_directory global variable. No changes to code. (CVS 6455) check-in: aea99c57 user: drh tags: trunk
14:16
Allow "default" to be a keyword used by PRAGMA statements. (CVS 6454) check-in: ed99d2d9 user: drh tags: trunk
12:26
Make sure the reverse_unordered_selects pragma works even on unindexed tables that are queried without a WHERE clause (CVS 6453) check-in: d8c6b28a user: drh tags: trunk
11:11
Check-in (6450) introduced the possibility of calling memset() with a negative 3rd argument. This fixes that bug. Ticket #3777. (CVS 6452) check-in: 8ca612c4 user: drh tags: trunk
2009-04-05
15:18
Fix a segfault in Lemon that occurs if the input grammar does not define a type for tokens. This does not effect SQLite since the SQLite grammar does define a type for tokens. (CVS 6451) check-in: 4424aee9 user: drh tags: trunk
12:22
Additional code to make sure and to assert that memory allocations have 8-byte alignment. Ticket #3777. (CVS 6450) check-in: 208382e0 user: drh tags: trunk
2009-04-04
16:02
Allow the journal_size_limit to be larger than 2147483647 bytes. (CVS 6449) check-in: 81931259 user: drh tags: trunk
15:53
Allow the journal_mode for in-memory databases to be either OFF or MEMORY, not just MEMORY. (CVS 6448) check-in: 11c77f4c user: drh tags: trunk
14:04
Clarify the meanings of the SQLITE_SYNC_NORMAL and SQLITE_SYNC_FULL flags passed into the xSync method of the VFS. Comment changes only - no changes to code. (CVS 6447) check-in: c47aeb37 user: drh tags: trunk
2009-04-03
12:12
Remove a blank line in sqlite.h.in that was preventing the SQLITE_LOCKED_SHAREDCACHE constant appears in the automatically-generated documentation. Ticket #3775. (CVS 6446) check-in: 65f9d3b9 user: drh tags: trunk
12:04
Use integer rather than floating point compuations in converting from julian day number to unix-time to avoid round-off errors on Borland compilers. Ticket #3769. (CVS 6445) check-in: c26f97bd user: drh tags: trunk
01:43
Fix the PRAGMA parser so that it can accept negative numbers in parentheses, like the syntax diagrams say it should be able to. (CVS 6444) check-in: 286e8317 user: drh tags: trunk
2009-04-02
20:27
Make sure count(*) works on the sqlite_master table of an empty database. Ticket #3774. (CVS 6443) check-in: e0c1a780 user: drh tags: trunk
20:16
Make sure the VACUUM statement locks down the page_size and auto_vacuum modes after it runs. Otherwise, pragmas might change these settings on a populated database, resulting in problems. (CVS 6442) check-in: 85e6a474 user: drh tags: trunk
18:32
Fix the sqlite3_prepare() family of interfaces so that they zero the *ppStmt value even on an SQLITE_MISUSE return. Make it clear in the documentation that the ppStmt parameter cannot be zero. (CVS 6441) check-in: 23bf9f26 user: drh tags: trunk
18:28
Fix a problem causing the BtShared.isPending flag to be cleared to early. Also coverage improvements for btree.c. (CVS 6440) check-in: 8f142344 user: danielk1977 tags: trunk
17:23
Ensure the required VerifyCookie/Transaction/TableLock opcodes are added for "x IN (SELECT c FROM t)" expressions. Ticket #3771. (CVS 6439) check-in: 058a2f20 user: danielk1977 tags: trunk
17:22
Fix a couple of harmless nuisance warnings. (CVS 6438) check-in: 53dac0a4 user: drh tags: trunk
16:59
Disable the query flattening optimization when the subquery is a compound query with an ORDER BY clause. Ticket #3773 shows why that combination does not work. (CVS 6437) check-in: 23f90d50 user: drh tags: trunk
14:05
Change the way that the random() SQL function prevents the maximum negative integer so that it is testable. (CVS 6436) check-in: 995f2b9b user: drh tags: trunk
13:36
Use ALWAYS and NEVER macros on unchangeable conditions within func.c. (CVS 6435) check-in: eb65e64e user: drh tags: trunk
10:16
In the built-in SQL function implementations, improve some comments, fix an off-by-one error in detecting over-size strings, and add testcase() macros to verify that boundary values have been tested. (CVS 6434) check-in: 868a487f user: drh tags: trunk
09:07
Enforce the run-time sqlite3_limit() length limit on zeroblob(), not just the compile-time SQLITE_MAX_LENGTH limit. (CVS 6433) check-in: a04f9e79 user: drh tags: trunk
2009-04-01
23:49
Increase test coverage of bitvec.c slightly. Fix the line length on a comment in bitvec.c. (CVS 6432) check-in: ca3aa3ba user: drh tags: trunk
23:09
Mark untestable branches of memjournal.c as such. Reduce the size of a single block allocation to a power of two. Reenable the inmemory_journal permutation test. (CVS 6431) check-in: 05c182a5 user: drh tags: trunk
20:44
Fix the strftime() function so that the %s format can handle dates outside of the range of 1901 to 2038. Ticket #3769. (CVS 6430) check-in: a95b843a user: drh tags: trunk
19:35
Change an unreachable error condition test to an assert() in rowset.c. (CVS 6429) check-in: 36115e40 user: drh tags: trunk
19:07
Remove an unreachable branch from lockBtree(). Add comments. (CVS 6428) check-in: 85979295 user: danielk1977 tags: trunk
18:40
Fix a bug in the sqlite3Utf16ByteLen() function so that it computes the correct length even for strings that contain surrogate pairs. Ticket #3766. (CVS 6427) check-in: 766bb7e5 user: drh tags: trunk
18:25
Test that two database connections that use different VFS implementations may not share a cache. (CVS 6426) check-in: 3a92c956 user: danielk1977 tags: trunk
18:03
Remove the unused SQLITE_Vtab flag. (CVS 6425) check-in: fdd78962 user: danielk1977 tags: trunk
17:13
In pageReinit() in btree.c, only reinitialize a page if there are one or more references to it, not including the transient reference held by pager.c. This was always the intent. (CVS 6424) check-in: 0c5a7d11 user: danielk1977 tags: trunk
16:33
Remove dead code from the UTF conversion routines. Fix a bug in sqlite3_prepare16_v2() in which an out-of-memory error fails to set the statement return pointer to NULL. (CVS 6423) check-in: 94e2f815 user: drh tags: trunk
16:25
Remove an unreachable branch from allocateSpace() in btree.c. Add comments and asserts to the same function. (CVS 6422) check-in: f8e15a54 user: danielk1977 tags: trunk
09:41
Add some assert() statements to querySharedCacheTableLock(). (CVS 6421) check-in: 3e3b5e86 user: danielk1977 tags: trunk
07:38
add a sanity check to make sure the configure script and VERSION file are always in sync (CVS 6420) check-in: 1b9da6d7 user: vapier tags: trunk
2009-03-31
23:29
update configure script so it has proper VERSION in it (CVS 6419) check-in: ce683cbd user: vapier tags: trunk