Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
92 events for the month beginning 2012-03-01 by user drh
Following month ↑|
2012-03-31
| ||
| 19:12 | Fix a compiler warning by removing a redundant variable. (check-in: af602d87 user: drh tags: trunk) | |
| 18:03 | • Edit [d2bf0efa7da59448|d2bf0efa]: Edit check-in comment. (artifact: b46f50f4 user: drh) | |
| 18:02 | • Fixed ticket [27ca74af]: Nested SAVEPOINT release causes pending query abort plus 1 other change (artifact: e578202f user: drh) | |
| 17:50 | Test cases for RELEASE and ROLLBACK TO of a nested savepoint while queries are pending. Ticket [27ca74af3c083] (check-in: d2bf0efa user: drh tags: trunk) | |
| 17:17 | Do not abort pending queries on a RELEASE of a nested SAVEPOINT. This is a candidate fix for ticket [27ca74af3c083f787]. (check-in: 79a4a3a8 user: drh tags: trunk) | |
| 17:15 | • Ticket [27ca74af] Nested SAVEPOINT release causes pending query abort status still Open with 3 other changes (artifact: d44befae user: drh) ... 1 similar event omitted. | |
| 02:46 | Merge all the latest trunk changes into the apple-osx branch. (check-in: 18ec60ca user: drh tags: apple-osx) | |
| 02:34 | Do more aggressive optimization of the AND operator where one side or the other is always false. (check-in: f9a7e179 user: drh tags: trunk) | |
|
2012-03-30
| ||
| 17:33 | • Edit [fa82062c659ffbe7|fa82062c]: Edit check-in comment. (artifact: 97a231d5 user: drh) | |
| 17:30 | Merge all recent trunk changes into the sessions branch. (check-in: fb9b9987 user: drh tags: sessions) | |
| 15:57 | Simplify the winRead and winWrite VFS functions to reduce the number of system calls. (check-in: b3449186 user: drh tags: trunk) | |
| 15:48 | When a named CHECK constraint fails, include the name of the constraint in the error message. (check-in: 1b75f301 user: drh tags: trunk) | |
| 15:05 | • Edit [7ed9d2f24a650b42|7ed9d2f2]: Mark "Closed". (artifact: 1352e518 user: drh) | |
| 15:05 | • Edit [0d841c957c6ec4af|0d841c95]: Mark "Closed". (artifact: c334e993 user: drh) | |
| 14:59 | Fix MSVC compiler warnings in test code. (check-in: cb7a8504 user: drh tags: trunk) | |
| 14:01 | Merge the latest trunk changes into the winrt branch. (check-in: a1a85b84 user: drh tags: winrt) | |
| 13:34 | Fix an FTS4 test script problem for windows. (check-in: 36aa6665 user: drh tags: trunk) | |
| 12:59 | • Edit [66c4aaadda433c9d|66c4aaad]: Mark "Closed". (artifact: 0d0a9756 user: drh) | |
| 12:59 | • Edit [83037d58443ab1ca|83037d58]: Mark "Closed". (artifact: 65a14a44 user: drh) | |
| 12:10 | Change the name of a local variable from "not" to "bNot" to lessen the chances of it colliding with some prior #define in the appliation. (check-in: cbdd8638 user: drh tags: trunk) | |
| 00:05 | In the ".output" command of the shell, if the first character of the output filename is '|' then use popen() instead of fopen(). (check-in: fa82062c user: drh tags: trunk) | |
| 00:00 | Fix compiler warnings on GCC and MSVC and fix a C89-ism that broke the build for MSVC. (check-in: b451c0f9 user: drh tags: trunk) | |
|
2012-03-28
| ||
| 16:44 | • Edit [868394761e41b748|86839476]: Mark "Closed". (artifact: d558c150 user: drh) | |
| 16:44 | Merge in the latest changes from trunk. (Closed-Leaf check-in: 66c4aaad user: drh tags: fts4-incr-merge) | |
| 16:22 | Avoid loading overflow pages just to satisfy typeof() or length() functions if the correct result can be computed without the extra page fetches. (check-in: 0733c98c user: drh tags: trunk) | |
| 16:14 | Minor changes to the core of OP_Column for performance and to clarify the critical path. (Closed-Leaf check-in: 86839476 user: drh tags: faster-typeof-and-length) | |
| 16:10 | • Edit [4d516240d2e465b2|4d516240]: Move to branch mistake. Mark "Closed". Edit check-in comment. (artifact: 08346f08 user: drh) | |
| 15:44 | This change turned out to the code slower. Side track it. Was: Tweaks to the OP_Column opcode for clarity of presentation. (Closed-Leaf check-in: 4d516240 user: drh tags: mistake) | |
| 13:41 | Improvements to comments. Minor changes to code in the hot path of OP_Column - with the hope of get a few cycles of performance improvement. (check-in: ca093103 user: drh tags: faster-typeof-and-length) | |
| 02:51 | Test cases for length() of a large blob in an aggregate query. (check-in: d095fa4b user: drh tags: faster-typeof-and-length) | |
| 02:43 | Fix the typeof() and length() optimization so that it works for aggregates as well as scalar queries. (check-in: bc18215a user: drh tags: faster-typeof-and-length) | |
| 02:32 | • Edit [b899dbeb60752843|b899dbeb]: Move to branch faster-typeof-and-length. (artifact: 6078df32 user: drh) | |
| 01:34 | Evaluate typeof(X) and length(Y) where X is any column and Y is a blob column without actually loading X and Y from disk. (check-in: b899dbeb user: drh tags: faster-typeof-and-length) | |
|
2012-03-27
| ||
| 18:00 | Add output of PRAGMAs auto_vacuum and encoding to the "schema" command of the fts3view utility program. (check-in: e3107631 user: drh tags: fts4-incr-merge) | |
| 14:54 | In the fts3view utility, label the blank segments used to mark the end of a segment sequence for a level/idx as "null". Improve the alignment of root segment names. (check-in: 04aea024 user: drh tags: fts4-incr-merge) | |
| 13:51 | Enhance the fts3view tool with the big-segment command and fix a bug in the display of doclists. (check-in: e9436d80 user: drh tags: fts4-incr-merge) | |
| 00:38 | Minor correct errors in the file format description for FTS3/4 contained in the fts3.c header comment. (check-in: fb8aacdd user: drh tags: fts4-incr-merge) | |
| 00:34 | Enhance fts3view to show decodes of segments and doclists. (check-in: 6d09de23 user: drh tags: fts4-incr-merge) | |
|
2012-03-26
| ||
| 21:57 | Add the fts3view utility program. (check-in: f936c8ea user: drh tags: fts4-incr-merge) | |
| 14:36 | Fix FTS3 so that it works even without SQLITE_DEBUG. (check-in: a18c1031 user: drh tags: fts4-incr-merge) | |
|
2012-03-25
| ||
| 17:25 | Increase the version number to 3.7.12 (check-in: d95f9fb7 user: drh tags: trunk) | |
|
2012-03-24
| ||
| 20:09 | Add SQLITE_DBSTATUS_CACHE_WRITE to the command-line shell. (check-in: 30b8dd32 user: drh tags: trunk) | |
| 20:06 | Add SQLITE_DBSTATUS_CACHE_WRITE. Used to query a database connection for the cumulative number of database pages written. (check-in: 05f98d4e user: drh tags: trunk) | |
| 17:29 | Enable fts3 tables to use incremental merge by automatically creating the %_stat table when it is needed. (check-in: cc051fc0 user: drh tags: fts4-incr-merge) | |
| 16:18 | Fix a bug in debugging code enabled when FTS3_LOG_MERGES is defined. (check-in: 2e06babf user: drh tags: fts4-incr-merge) | |
| 02:20 | An attempt at automatic incremental merging for FTS4. (check-in: ed69434c user: drh tags: fts4-auto-incr-merge) | |
|
2012-03-23
| ||
| 14:23 | When an incremental blob cursor is invalidated (occurs when an SQL statement modifies or deletes the row the blob cursor points to) release all page references held by the cursor. Otherwise, the presence of these references may cause other code in btree.c to incorrectly infer that the database is corrupt. (check-in: 341b703c user: drh tags: trunk) | |
|
2012-03-22
| ||
| 12:50 | Always quote the names of tables in the output of the shell's ".dump" command, even if the name is pure alphabetic text, in case the name is a keyword. (check-in: 638b7115 user: drh tags: trunk) | |
|
2012-03-20
| ||
| 17:04 | Merge trunk changes into the fts4-incr-merge branch. (check-in: f61d5fb0 user: drh tags: fts4-incr-merge) | |
| 15:10 | Remove the _SafeInit() entry points from the TCL interface. They have long been no-ops. Removing them completely avoids confusion as to why they don't work. (check-in: 0fb26c7b user: drh tags: trunk) | |
| 11:36 | • Edit [00bb9c9ce4f465e6|00bb9c9c]: Change background color to "#d0c0ff". Add tag "release". (artifact: f60f33bf user: drh) | |
| 11:35 | Version 3.7.11 (check-in: 00bb9c9c user: drh tags: trunk, release, version-3.7.11) | |
| 03:10 | Fix out-of-bounds array references in the "echo" virtual table module used for testing. No changes to the SQLite core. (check-in: 7b449b30 user: drh tags: trunk) | |
|
2012-03-19
| ||
| 19:16 | • Edit [549f4fd00d8325c1|549f4fd0]: Mark "Closed". (artifact: 6354f8ce user: drh) | |
| 19:15 | • Edit [922bcbb42361b5a2|922bcbb4]: Mark "Closed". (artifact: ca8a56a4 user: drh) | |
| 19:15 | • Edit [254f99ea9ff15349|254f99ea]: Mark "Closed". (artifact: 170a3b35 user: drh) | |
| 17:42 | Add additional test cases to e_insert.test. Update evidence marks. no changes to core code. (check-in: 036395c0 user: drh tags: trunk) | |
| 14:57 | Fix one more compiler warning missed by the previous check-in. (check-in: bc03d99a user: drh tags: trunk) | |
| 14:51 | Suppress harmless compiler warnings on windows in FTS4 and RTREE. (check-in: 4fd68647 user: drh tags: trunk) | |
| 14:28 | Avoid a compiler warning (an incorrect compiler warning, at that) in vs2010. (check-in: 7dd97f12 user: drh tags: trunk) | |
|
2012-03-16
| ||
| 17:00 | Update the trace2.test script for languageid. (check-in: a11528ac user: drh tags: trunk) | |
| 16:52 | Cherrypick the [3475092cff] fix for 32-bit overflow with large language-ids into trunk. (check-in: 2755edc7 user: drh tags: trunk) | |
| 00:28 | Fix harmless compiler warnings. (check-in: 74eadeec user: drh tags: trunk) | |
|
2012-03-15
| ||
| 22:54 | Add the sqlite3_db_readonly() API to trunk. (check-in: fed134a5 user: drh tags: trunk) | |
| 21:28 | Add the sqlite3_db_readonly() interface. This is still tentative, pending a closer look at other ideas to accomplish the same thing. (Closed-Leaf check-in: 254f99ea user: drh tags: db-readonly-api) | |
|
2012-03-13
| ||
| 14:10 | • Ticket [b7c8682c] Incorrect result from LEFT JOIN with OR in the WHERE clause status still Fixed with 1 other change (artifact: b6174c4a user: drh) ... 1 similar event omitted. | |
|
2012-03-09
| ||
| 22:02 | Candidate fix for the optimizer problem described in ticket [b7c8682cc17f3] which can causes a LEFT JOIN to be changed into a INNER JOIN if there are OR terms in the WHERE clause. (check-in: 0dc4cb93 user: drh tags: trunk) | |
| 16:58 | • New ticket [b7c8682c] Incorrect result from LEFT JOIN with OR in the WHERE clause. (artifact: 7aedf2b6 user: drh) | |
| 12:52 | Minor commenting and stylistic changes only. (check-in: a1747086 user: drh tags: fts4-incr-merge) | |
|
2012-03-07
| ||
| 19:13 | If a CHECK constraint is named, report that name on the error message when the constraint fails. (Closed-Leaf check-in: 9a0f90d9 user: drh tags: named-check-constraints) | |
| 16:52 | Merge in the latest trunk changes. (check-in: ca470853 user: drh tags: winrt) | |
|
2012-03-06
| ||
| 12:36 | • Edit [f8e9c445dd358c40|f8e9c445]: Mark "Closed". (artifact: fcc7f49f user: drh) | |
|
2012-03-05
| ||
| 16:39 | Pull in all the latest trunk changes. (check-in: 504bf490 user: drh tags: apple-osx) | |
| 16:26 | Merge in the latest trunk changes. (check-in: ff86875c user: drh tags: sessions) | |
|
2012-03-03
| ||
| 01:44 | • Fixed ticket [3557ad65]: Incorrect DISTINCT on an indexed query with IN plus 1 other change (artifact: f0ee3546 user: drh) | |
| 01:44 | Add a test case for ticket [3557ad65a076c]. (check-in: 4f34d707 user: drh tags: trunk) | |
| 01:35 | • Ticket [3557ad65] Incorrect DISTINCT on an indexed query with IN status still Open with 3 other changes (artifact: bf8e83ba user: drh) | |
| 00:34 | Fix a bug [3557ad65a07] that causes incorrect DISTINCT processing on an indexed query involving the IN operator. (check-in: dec9a995 user: drh tags: trunk) | |
| 00:17 | • New ticket [3557ad65] Incorrect DISTINCT on an indexed query with IN. (artifact: 2c17c043 user: drh) | |
|
2012-03-02
| ||
| 20:34 | Remove an obsolete comment from FTS3. No code changes. (check-in: 74d224b1 user: drh tags: trunk) | |
| 00:00 | Omit all ANSI APIs for winRT. (check-in: cbf23b46 user: drh tags: winrt) | |
|
2012-03-01
| ||
| 22:44 | Use GetInformationByHandleEx() instead of GetFileSize() on winRT. (check-in: 119f251d user: drh tags: winrt) | |
| 22:33 | Do not run the large file tests if a file named "skip-big-file" exists in the test directory. This enables tests to be run much faster on systems that lack sparse file support. (check-in: 5a839123 user: drh tags: winrt) | |
| 22:06 | Use SetFilePointerEx() instead of SetFilePointer() on winRT. (check-in: 36efafc6 user: drh tags: winrt) | |
| 21:30 | Fix a typo in the header comment of sqlite3_commit_hook(). (check-in: 3784d147 user: drh tags: trunk) | |
| 21:19 | Use WaitForSingleObjectEx() as a substitute for Sleep on winRT. (check-in: bf897be0 user: drh tags: winrt) | |
| 20:05 | Add recognition of the SQLITE_OS_WINRT compile-time option. Use InitializeCriticalSectionEx() under winRT. (check-in: 8b7ca8a0 user: drh tags: winrt) | |
| 19:14 | Add back in some #includes that were removed incorrectly by the previous check-in. (check-in: 71890536 user: drh tags: winrt) | |
| 18:53 | • Edit [c0891296b49fb959|c0891296]: Move to branch winrt. (artifact: e43f9c19 user: drh) | |
| 18:16 | Remove unused #defines from os.h. (check-in: c0891296 user: drh tags: winrt) | |