SQLite

Timeline
Login

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

63 events for the month beginning 2010-02-01 by user drh

Following month ↑
2010-02-27
12:30 Ticket [ebdbadad] LEFT JOIN incorrect when ON clause does not reference right table. status still Fixed with 1 other change (artifact: 7017709a user: drh)
2010-02-26
16:37
Rename the sqlite_compile_option_*() SQL functions to sqlite_compileoption_*() for consistency with the C/C++ interface. (check-in: dd4962aa user: drh tags: trunk)
15:39
Remove the compile_option pragma (retaining compile_options - with an "s"). Updates to documentation. (check-in: 733778df user: drh tags: trunk)
13:07
Avoid incorrect compiler warnings by doing a couple of needless variable initializations. (check-in: 8f29490d user: drh tags: trunk)
12:58
Increase the version number to 3.6.23 in preparation for the next release. (check-in: b5835d3e user: drh tags: trunk)
2010-02-25
23:44
Fix to the database connection validity checker. Other test coverage enhancements. (check-in: 0f6291bb user: drh tags: trunk)
21:27
Test coverage enhancements. Additional documentation detail on the new sqlite3_log() interface. (check-in: d986e928 user: drh tags: trunk)
15:28
Minor simplifications to the compile-time option reporting functions and pragmas to facilitate coverage testing. (check-in: 633d8747 user: drh tags: trunk)
14:59 Edit [a25505978638bcb8|a2550597]: Timestamp 2010-02-25 14:44:09. (artifact: a7bed6c0 user: drh)
14:56
Expire pragma statements when reset, even if they were not run to completion. (check-in: b8fbf427 user: drh tags: branch-3.6.22)
14:47
Expire pragma statements when reset, even if they were not run to completion. (check-in: 78351d28 user: drh tags: trunk)
04:16 Fixed ticket [ebdbadad]: LEFT JOIN incorrect when ON clause does not reference right table. plus 1 other change (artifact: 89d8406e user: drh)
04:15
Make sure the ON clause of a LEFT JOIN does not cause an index to be used to speed access to a table to the left of the join. Ticket [ebdbadade5] (check-in: f0ae251a user: drh tags: trunk)
02:32
Merge in all of the logging enhancements. This is a cherrypick merge of the following check-ins: [103321e37a], [a8076aede3], [6d910245ad], [7c4cca6d1a], [edea3bb740], [1a6d4bb130], [a8c984c1d6], [69a493182f], and [1168763d2c]. (check-in: 46f406b2 user: drh tags: branch-3.6.22)
02:11
Fix a segfault that is possible for an OOM fault in ATTACH when in shared-cache mode. This is a cherrypick merge of check-in [e37137376a]. (check-in: f73cc0e9 user: drh tags: branch-3.6.22)
02:04
Enhance integrity_check to detect out-of-order rowids. This is a cherrypick merge of check-in [cae47c5b09]. (check-in: ecd22ef3 user: drh tags: branch-3.6.22)
01:54
Merge in the fix for VACUUM on auto_vacuumed databases with large schemas. Check-in [86d50ce57f]. Ticket [da1151f97df]. (check-in: ce624e39 user: drh tags: branch-3.6.22)
01:47
Start a new branch for release 3.6.22 plus limited enhancements and fixes. This first check-in includes the performance enhancements of check-ins [26cb1df735], [61a2c8d4d6], and [27dc5b1c52] (check-in: 95882598 user: drh tags: branch-3.6.22)
2010-02-24
22:36 Ticket [ebdbadad] LEFT JOIN incorrect when ON clause does not reference right table. status still Open with 3 other changes (artifact: 22676924 user: drh) ... 1 similar event omitted.
21:44
Add testcase() macros beside each sqlite3_log() call to make sure it is tested with both logging enable and disabled. (check-in: 1168763d user: drh tags: trunk)
19:23
Add a sqlite3_log() call on anonymous constraint failures. Fix the output of test cases having to do with improved reprepare reporting. Fix the VACUUM command to report more helpful error messages when things go wrong. (check-in: 69a49318 user: drh tags: trunk)
18:40
Fix an incorrect ALWAYS() macro in vdbeapi.c. Fix the output of a few test cases that changed due to better error propagation out of reprepare. (check-in: a8c984c1 user: drh tags: trunk)
18:25
Remove an unused variable from rtree. (check-in: 8e60d399 user: drh tags: trunk)
17:15
Enhancements to the way errors are reported up when an automatic statement reprepare fails. (check-in: 1a6d4bb1 user: drh tags: trunk)
15:11 Fixed ticket [d2f02d37]: Assertion fault on UPDATE involving two virtual tables. plus 1 other change (artifact: fe19816b user: drh)
15:10
Fix an assertion fault that occurs when two different virtual tables are used in a single UPDATE statement. Ticket [d2f02d37f52b]. (check-in: ff61e0fd user: drh tags: trunk)
14:03 Ticket [d2f02d37] Assertion fault on UPDATE involving two virtual tables. status still Open with 3 other changes (artifact: 150a3df0 user: drh) ... 1 similar event omitted.
2010-02-23
21:08
Fix the stmt.test test script so that it works with SQLITE_TEMP_STORE=3. (check-in: 8bf710ce user: drh tags: trunk)
20:32
Merge the compile-time option introspection interfaces into the trunk. (check-in: 9f429434 user: drh tags: trunk)
20:11
Continuing improvements to error reporting and the sqlite3_log() routine. (check-in: edea3bb7 user: drh tags: trunk)
17:36
Remove the obsolete sqlite3SafetyOn() mechanism. Add additional logging output for CORRUPT, and CANTOPEN errors. (check-in: 7c4cca6d user: drh tags: trunk)
01:47
Add the ".log" command to the shell. This shows that some errors are logged multiple times and other errors are never logged at all. (check-in: 6d910245 user: drh tags: trunk)
01:01
Remove the ".genfkey" command from the shell. We've had foreign-key support in the core since 3.6.19. Anyone who still needs the simulated foreign-key triggers can always generate them with an older version of the shell. (check-in: c4401fc9 user: drh tags: trunk)
2010-02-22
23:19 Fixed ticket [da1151f9]: Assertion fault on VACUUM in an auto_vacuumed database. plus 2 other changes (artifact: dd36168a user: drh)
23:17
Fix an assertion-fault/segfault problem that comes up when trying to VACUUM an auto-vacuumed database with a large schema. Ticket [da1151f97df244]. (check-in: 86d50ce5 user: drh tags: trunk)
22:57 New ticket [da1151f9] Assertion fault on VACUUM in an auto_vacuumed database.. (artifact: e9ecc159 user: drh)
19:37
Merge in the massive clean-up and ANSI-fication of Lemon carried out by Ryan Gordon. There are no functional changes to SQLite itself - Lemon still generates exactly the same parsing automaton from exactly the same grammar. (check-in: 1e8b8420 user: drh tags: trunk)
19:32
Log all error messages if logging is enabled. (check-in: a8076aed user: drh tags: trunk)
18:40 Edit [e6cbe1e5ee80db28|e6cbe1e5]: Change branch background color to "#c0fff0". Move to branch lemon-update-2010. Edit check-in comment. Timestamp 2010-02-14 00:48:50. (artifact: db8c1d41 user: drh)
2010-02-18
18:45
Add a new, experimental logging interface designed to aid in debugging of deeply embedded projects that use SQLite. (check-in: 103321e3 user: drh tags: trunk)
2010-02-17
19:34
Merge latest changes from the trunk into the apple-osx branch. (check-in: 4b72e39b user: drh tags: apple-osx)
2010-02-15
18:05 Fixed ticket [13336e9c]: ALTER TABLE RENAME fails to update foreign key references plus 2 other changes (artifact: 36863185 user: drh)
18:03
Fix the ALTER TABLE RENAME command so that it converts FOREIGN KEY constraints in ATTACH-ed and in TEMP tables as well as in the main database. Ticket [13336e9c3c8c3f]. (check-in: ab197d0a user: drh tags: trunk)
17:47 New ticket [13336e9c] ALTER TABLE RENAME fails to update foreign key references. (artifact: 91486f00 user: drh)
16:55 Fixed ticket [985771e1]: CREATE TRIGGER confused by TEMP/MAIN table name overlap plus 2 other changes (artifact: 239613c6 user: drh)
16:54
When creating a trigger on a main database table when there is a TEMP table with the same name, make sure the trigger is bound to the main table. Ticket [985771e11612]. (check-in: ec914af3 user: drh tags: trunk)
16:37 New ticket [985771e1] CREATE TRIGGER confused by TEMP/MAIN table name overlap. (artifact: cecc6bdc user: drh)
15:47
Fix a compiler warning in shell.c. Updates to comments in trigger.c. (check-in: c727601e user: drh tags: trunk)
15:17
Fix a typo in the documentation for the OP_OpenPseudo opcode. (check-in: 9acfb069 user: drh tags: trunk)
2010-02-13
02:47 Edit [f3676b243d94229f|f3676b24]: Change branch background color to "#c0ffc0". Timestamp 2010-02-12 22:43:48. (artifact: 141b9707 user: drh)
2010-02-12
19:46
Enhancements to the secure_delete pragma to make it easier to use. (check-in: 2bb38bb9 user: drh tags: trunk)
18:35 Edit [f72f8a870a0fc98a|f72f8a87]: Edit check-in comment. Timestamp 2010-02-12 18:18:39. (artifact: dc30e13d user: drh)
18:18
Allow the secure-delete setting to be changed at run-time using a pragma. The SQLITE_SECURE_DELETE compile-time option determines the default setting. (check-in: f72f8a87 user: drh tags: trunk)
2010-02-05
18:00
Make sure file descriptors are closed before unlinking in VxWorks. (check-in: f64b81f1 user: drh tags: trunk)
14:40 Edit [b6129f4cc28f6ba5|b6129f4c]: Change background color to "#ffc0d0". Timestamp 2008-05-14 16:18:11. (artifact: 7b9c0a08 user: drh)
14:12
Remove the use of 64-bit math in the offset computations of the OP_Column opcode for a small performance improvement. (check-in: 61a2c8d4 user: drh tags: trunk)
2010-02-04
17:38
Fix a performance glitch that appears for large transactions. (check-in: 26cb1df7 user: drh tags: trunk)
2010-02-03
19:55
Add a new full-text search variant that tracks the total number of documents and document sizes, to make ranking search results easier. Currently called FTS4. (check-in: 1b6e6094 user: drh tags: trunk)
2010-02-02
20:53 Closed ticket [8905af11]: NOT NULL interferes with ON CONFLICT REPLACE plus 2 other changes (artifact: e1bcfd4d user: drh) ... 2 similar events omitted.
Previous month ↓