SQLite

Timeline
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

75 events for the month beginning 2009-12-01 by user drh

Following month ↑
2009-12-31
20:35
Add comments and an assert() to help clarify the operation of the sqlite3VdbeList() routine used to implement EXPLAIN. (check-in: e1ccdb93 user: drh tags: trunk)
15:51
Change evidence marks to track requirement number changes in the foreign-key documentation. (check-in: 6b4fcd81 user: drh tags: trunk)
2009-12-30
14:19
Change the version number to 3.6.22. (check-in: 96919a46 user: drh tags: trunk)
14:12
Adjustments to column cache handling in order to restore 100% branch test coverage. (check-in: cc6b959b user: drh tags: trunk)
12:42 Ticket [0d676cd6] Triggers: new/old.oid is interpreted as the IPK, even if there is another column "oid" status still Closed with 1 other change (artifact: e9d7c6d1 user: drh)
01:13
Remove some code in the column cache that is no longer used. Replace it with an assert(). (check-in: 1f890efb user: drh tags: trunk)
00:12
Remove obsolete comment text from expr.c. No functional code changes. (check-in: 84058be0 user: drh tags: trunk)
2009-12-29
23:39 Fixed ticket [34d2ae1c]: Overloaded column named "ROWID" mishandled in triggers. plus 3 other changes (artifact: e1cacfb4 user: drh)
23:39
Within the special new.* and old.* tables of a trigger, recognize all the original table names even if those names overload the "rowid", "oid", or "_rowid_" special names. Ticket [34d2ae1c6d0]. (check-in: 1a0e5fa9 user: drh tags: trunk)
21:59 New ticket [34d2ae1c] Overloaded column named "ROWID" mishandled in triggers.. (artifact: 94513543 user: drh)
2009-12-24
16:01 Fixed ticket [eb5548a8]: CAST in WHERE clause causes inconsistent query results plus 3 other changes (artifact: 5ad1607e user: drh)
16:00
Immediately purge entries from the column cache when the associated register undergoes an affinity change. Ticket [eb5548a849]. Enhance the SQLITE_TESTCTRL_OPTIMIZATIONS setting of sqlite3_test_control so that it can disable the column cache for testing purposes, in an effort to prevent future problems of a similar nature to this one. (check-in: ea4e57e1 user: drh tags: trunk)
13:16 New ticket [eb5548a8] CAST in WHERE clause causes inconsistent query results. (artifact: cd72ca77 user: drh)
2009-12-23
18:06
Fix the main.mk makefile so that the sqlrr extension is built into the amalgamation correctly. (check-in: a3204d8a user: drh tags: apple-osx)
2009-12-22
23:52
Move the query flattener turn-off from a pragma to an sqlite3_test_control() call. Make provisions (not yet implemented) to turn off other optimizers using the same call. (check-in: 4a97c623 user: drh tags: trunk)
00:29
Add a pragma to disable the query flattener - for use during testing. (check-in: 1d8550e5 user: drh tags: trunk)
2009-12-17
03:49
Disable trace when recursively running commands while vacuuming. (check-in: 69a1348a user: drh tags: trunk)
02:13
Change the REGEXP function in ICU to require exactly 2 arguments. (check-in: c34cf23e user: drh tags: trunk)
2009-12-16
23:46
Merge the latest changes on trunk (and especially the fix for the (xANDy)OR(z) bug) into apple-osx. (check-in: 5754a3a5 user: drh tags: apple-osx)
23:43
Remove unreachable code that was added by the fix to the "(xANDy)OR(z)" bug in the previous check-in. (check-in: 04915562 user: drh tags: trunk)
23:29 Edit [867347323b0c0951|86734732]: Change branch background color to "#c0f0ff". Move to branch branch-3.6.21. Timestamp 2009-12-16 23:28:32. (artifact: 1185db4a user: drh)
23:28
Fix for the "(x AND y) OR z" bug backported to version 3.6.21. (Leaf check-in: 86734732 user: drh tags: branch-3.6.21)
22:11 Fixed ticket [31338dca]: OR operator in WHERE clause gives wrong answer when indexed plus 2 other changes (artifact: 4fe3aebf user: drh)
22:10
Ensure WHERE clause terms involving tables on the right end of a join are not prematurely evaluated when tables on the left end of the join make use of the OR-clause optimization. Fix for ticket [31338dca7e]. (check-in: 2c2de252 user: drh tags: trunk)
16:52 Ticket [31338dca] OR operator in WHERE clause gives wrong answer when indexed status still Open with 1 other change (artifact: c9fd070a user: drh) ... 3 similar events omitted.
2009-12-14
17:42
Add a few simple evidence comments to the tokenizer. No functional changes. (check-in: 0daec309 user: drh tags: trunk)
2009-12-13
23:03
Additional corrections to documentation comments. No functional code changes. (check-in: b3740b0a user: drh tags: trunk)
22:20
Minor documentation updates. No functional changes. (check-in: 6ae7e40b user: drh tags: trunk)
2009-12-12
23:57
Fix some documentation comments in sqlite.h.in. No functional code changes. (check-in: c16b9bec user: drh tags: trunk)
13:58
Rename tkt-d82e3f3721.txt to use the (correct) .test suffix. (check-in: 68cccd62 user: drh tags: trunk)
2009-12-11
23:11
Additional changes to C-language interface documentation. (check-in: 1342916f user: drh tags: trunk)
16:04 Edit [87fc0ce151c89beb|87fc0ce1]: Edit check-in comment. Timestamp 2009-12-11 16:03:45. (artifact: 950f9ce6 user: drh)
03:44
Extensive edits to the comments in the sqlite.h.in source file to identify testable statements of truth about the C-language interface. (check-in: ea884e1e user: drh tags: trunk)
2009-12-10
01:17
Only declare the sqlite3_mutex_held() and sqlite3_mutex_notheld() interfaces in the header file if NDEBUG is not defined. (check-in: ee9b1c05 user: drh tags: trunk)
2009-12-09
21:43
Restore the incorrect legacy ON INSERT syntax to the parser as a no-op. That way, older databases that actually use this meaningless syntax will still be readable. (check-in: 54b955c3 user: drh tags: trunk)
18:23 Fixed ticket [f74beaab]: Problem with 3-way joins and the USING clause plus 2 other changes (artifact: 04c1a6e9 user: drh)
18:22
Added test cases for the multi-way USING and NATURAL JOIN fix. Ticket [f74beaabde]. (check-in: 0b34ab25 user: drh tags: trunk)
17:36
The USING clause and NATURAL JOIN look at all tables to the left when searching for a match, not just the one table to the immediate left. Tables further to the left are preferred. Fix for ticket [f74beaabde]. Still need to add test cases to complete the ticket. (check-in: b558e96f user: drh tags: trunk)
16:42 Ticket [f74beaab] Problem with 3-way joins and the USING clause status still Open with 1 other change (artifact: 2901c6ec user: drh)
2009-12-08
22:16
Change to order of two branches in vtab.c in order to a restore 100% test coverage. (check-in: fdfdc777 user: drh tags: trunk)
19:58
Add comments to better explain the two-pass memory allocation approach for prepared statements. (check-in: 0e5e18ea user: drh tags: trunk)
15:35
Avoid pointer aliasing in the allocSpace() routine in vdbeaux.c. (check-in: d6ae2751 user: drh tags: trunk)
15:16
Begin updating API documentation to use the new MD5-hash based automatic requirements numbering. Comment changes only. Many similar changes will follow. (check-in: 973c5c86 user: drh tags: trunk)
14:43 Fixed ticket [4abd1e4c]: omitted.html still says recursive triggers are not supported plus 3 other changes (artifact: 8249a772 user: drh)
14:34 Fixed ticket [78e04e52]: Assertion failure dropping table with zero length name plus 3 other changes (artifact: 17c1e71a user: drh)
14:34
Allow zero-length names for tables, columns, and indices. Fix for ticket [78e04e52eaf]. (check-in: 7b1cfd65 user: drh tags: trunk)
13:46 Fixed ticket [abe728bb]: Crash committing multi-file transaction including temp file plus 3 other changes (artifact: bd0bb454 user: drh)
13:44
Add test cases for ticket [abe728bbc311]. (check-in: 4eb9bf0b user: drh tags: trunk)
13:36
Avoid dereferencing a null pointer when doing a multi-database comment where one or more of the databases is an ATTACH-ed TEMP database. Ticket [abe728bbc311d]. (check-in: f43e37e0 user: drh tags: trunk)
02:06
Add evidence marks for the abs() and soundex() SQL functions. (check-in: 003f3ed1 user: drh tags: trunk)
2009-12-07
23:53
Merge all changes associated with the version 3.6.21 release into the OS-X branch. (check-in: ad08794d user: drh tags: apple-osx)
19:52 Edit [1ed88e9d01e9eda5|1ed88e9d]: Change background color to "#ffc0d0". Edit check-in comment. Timestamp 2009-12-07 16:39:13. Add tag "release". (artifact: 08997916 user: drh)
16:39
Version 3.6.21 (check-in: 1ed88e9d user: drh tags: trunk, release)
14:48
Version 3.6.21 release candidate 2. (check-in: 78f6baff user: drh tags: trunk)
2009-12-06
03:35
Enhanced detection of database corruption in btree.c:allocateSpace(). (check-in: 5a511f98 user: drh tags: trunk)
2009-12-05
18:34
Fix to check-in [f221f31eff]: Make sure local variable rc is declared even when compiled without SQLITE_DEBUG. (check-in: 7a9a3532 user: drh tags: trunk)
2009-12-04
23:10
Add the SQLITE_4_BYTE_ALIGNED_MALLOC compile-time option which tells some assert() statements that the underlying system only requires 4-byte alignment of 8-byte data objects like double or int64 and that system malloc() only guarantees 4-byte alignment of returned pointers. (check-in: 08faee68 user: drh tags: trunk)
22:51
Remove an assert() in btree.c:releasePage() that is not necessarily true when the btree is recovering from an OOM that occurs in the middle of a balance(). (check-in: 04fc9c76 user: drh tags: trunk)
14:25
In the OSTRACE debugging macros in os_unix.c, identify the VFS currently in use. (check-in: 082b8da0 user: drh tags: trunk)
13:43
Fix an FTS3 problem where an OOM error was not being propagated back out to the top-level interface. (check-in: 2ad1461f user: drh tags: trunk)
01:44
Clear a conflicting TCL variable in the fts3rnd.test test script. (check-in: f9047b2e user: drh tags: trunk)
2009-12-03
21:26
Fix an assert() in btree.c that might have fired on a corrupt database file. (check-in: 5ab2b3e3 user: drh tags: trunk)
19:40
Remove a NEVER() from btree.c that could occur in a very obscure tested evaluation with an I/O error on fstat(). (check-in: d5861d9f user: drh tags: trunk)
01:01
Add links from C/C++ interfaces to their equivalent SQL functions. Comment changes only - no changes to code. (check-in: acce10f7 user: drh tags: trunk)
2009-12-02
20:25
Change an error message in FTS3 to avoid using an uninitialized variable. (check-in: 620a8a2b user: drh tags: trunk)
18:03
Fix compiler warnings in test_hexio.c. (check-in: 6a2e0725 user: drh tags: trunk)
02:49
Make sure a variable is cleared before use in the where8.test script. (check-in: b3436529 user: drh tags: trunk)
2009-12-01
22:09
Add testcase() macros to make sure boundary cases in BEFORE UPDATE triggers are well tested. (check-in: 27175caa user: drh tags: trunk)
18:46
Fix a faulty function prototype in test_intarray.c. (check-in: 110956a6 user: drh tags: trunk)
14:32 Fixed ticket [97214a34]: Use of os2MutexNotheld before their definition plus 2 other changes (artifact: 8f8e1fad user: drh)
14:31
Reorder function declarations in mutex_os2.c. This is a blind change - we have no capability of testing on OS/2. Ticket [97214a34d814] (check-in: c40e4ef0 user: drh tags: trunk)
13:57
Changes to the TCL interface header to allow it to be compiled independently from the amalgamation. (check-in: 58113932 user: drh tags: trunk)
Previous month ↓