Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
79 events for the month beginning 2012-10-01 by user drh
Following month ↑|
2012-10-30
| ||
| 21:03 | Pull all the latest trunk enhancements into the sessions branch. (check-in: fce667f2 user: drh tags: sessions) | |
| 18:09 | Enable the use of coroutines as an alternative to manifesting views used in a FROM clause. (check-in: 9dca18f5 user: drh tags: trunk) | |
| 15:31 | Make sure that the optimizer never tries to create an automatic index on a coroutine subquery. (Closed-Leaf check-in: f83aa0de user: drh tags: subquery-as-coroutine) | |
| 14:44 | Fix a typo in the header comment for the OpenPseudo opcode. (check-in: 4f106123 user: drh tags: subquery-as-coroutine) | |
| 14:39 | Make it possible to disable the subquery-by-coroutine optimization using sqlite3_test_control(). Remove an always-false conditional. (check-in: 564631f3 user: drh tags: subquery-as-coroutine) | |
| 00:29 | Add an optimization that attempts to run a subquery as a coroutine rather than manifesting it into a temporary table. (check-in: 7af3acbb user: drh tags: subquery-as-coroutine) | |
|
2012-10-29
| ||
| 14:27 | Note: Support For Windows Phone 8 (technote: [68380941] user: drh) | |
| 14:27 | Make the multiplexor and the IntArray extensions callable from C++. (check-in: cbd8fddf user: drh tags: trunk) | |
|
2012-10-26
| ||
| 18:40 | Make sure the automatic index optimization is checked even if the covering index scan optimization was previously selected. (check-in: ac1d5d8a user: drh tags: trunk) | |
| 13:46 | Add QNX-specific performance tweaks to the unix VFS. (Cherry-pick merge of [b02849e7bde458].) (check-in: 63a7dd75 user: drh tags: trunk) | |
| 13:34 | Backport the shared-cache-fix branch. (check-in: 325364a9 user: drh tags: branch-3.7.14) | |
| 13:25 | Add QNX-specific performance tweaks to the unix VFS. (Cherry-pick merge of [b02849e7bde458].) Put auxiliary libraries after libsqlite3.a in the testfixture target of the "main.mk" makefile. (Cherry-pick merge of [8fc8548f52ab8fcfb5].) (check-in: cbfd1b12 user: drh tags: branch-3.7.14) | |
| 00:55 | Make sure all virtual table cursors have been closed on a prepared statement prior to unlinking the perpared statement from its database connection. The test case for this is in TH3, in the main39.test module. (check-in: 6d42d806 user: drh tags: trunk) | |
| 00:11 | Make sure all virtual table cursors have been closed on a prepared statement prior to unlinking the perpared statement from its database connection. (Closed-Leaf check-in: f7c5abe8 user: drh tags: deferred-close-order) | |
|
2012-10-25
| ||
| 23:47 | Further work on getting ssdsim to run. This is an incremental checkin to save my place while jumping off to work on other things. (Leaf check-in: ae2f1627 user: drh tags: ssdsim) | |
| 17:21 | Use a constant string "BINARY" for the unspecified collating sequence. This is part of check-in [635e3a762dd] that is being back-ported. (check-in: 9078ea75 user: drh tags: branch-3.7.9) | |
| 15:32 | Merge the command-line shell enhancements from trunk. Other edits toward trying to get ssdsim to run. (check-in: 848f87e2 user: drh tags: ssdsim) | |
| 15:23 | Improvements to the command-line argument parsing in the command-line shell. Command-line options can now occur either before or after the database name and first command and are still accepted and processed. Command-line options are processed even if no database name is given (and :memory: is assumed). (check-in: 317c80cb user: drh tags: trunk) | |
| 03:07 | Implementation of the INSTR() SQL function, as found in SQL Server, MySQL, and Oracle. (Closed-Leaf check-in: 49ccae96 user: drh tags: instr) | |
| 01:50 | Initial check-in of a test VFS designed to simulate a NAND-flash SSD for the purpose of measuring and subsequently minimizing write amplification caused by SQLite. The code in this check-in compiles but does not run. (check-in: 9e6efcf0 user: drh tags: ssdsim) | |
|
2012-10-19
| ||
| 02:10 | Make sure substructure elements have proper alignment in the ICU tokenizers of FTS2 and FTS3. (check-in: aaa2d9b0 user: drh tags: trunk) | |
|
2012-10-18
| ||
| 20:49 | Put auxiliary libraries after libsqlite3.a in the testfixture target of the "main.mk" makefile. (check-in: 8fc8548f user: drh tags: trunk) | |
| 15:01 | Merge Watcom compiler warning fixes into trunk. (check-in: 5be96788 user: drh tags: trunk) | |
|
2012-10-17
| ||
| 13:15 | Remove an incorrect "#ifndef SQLITE_OMIT_AUTOVACUUM" from pager. (check-in: bf44d73d user: drh tags: trunk) | |
|
2012-10-16
| ||
| 23:17 | Enable optimization of IN operators on constraints to virtual tables. (check-in: aa650746 user: drh tags: vtab-IN-opt) | |
| 21:08 | An optimization that converts "a IN (b)" into "a==b". Seems to work, but needs additional test cases. (Leaf check-in: 8b4c3c5e user: drh tags: degenerate_IN) | |
|
2012-10-15
| ||
| 23:15 | Change the ICU tokenizer so that it does not attempt to call strlen(NULL). This is a cherry-pick of the fix in [04298f1ac42c40c] on 2012-03-31 first appearing in release 3.7.12. (check-in: 49ffbc11 user: drh tags: branch-3.7.9) | |
| 16:24 | Dequote column names generated by the query flattener. (check-in: 5526e0aa user: drh tags: trunk) | |
| 14:25 | Merge all the latest core changes into the sessions branch. (check-in: 76767d65 user: drh tags: sessions) | |
|
2012-10-13
| ||
| 23:16 | • Edit [ae025cae2266a91d|ae025cae]: Mark "Closed". (artifact: b87ef345 user: drh) | |
| 23:16 | Ensure that when the source of a backup is a database that is zero bytes in size, the final destination database consists of at least one page. Truncating it to zero bytes is equivalent to zeroing the schema cookie and change counter, which can cause problems for existing clients. (check-in: ca86138b user: drh tags: trunk) | |
| 20:55 | Mark an always-true conditional as such. (Closed-Leaf check-in: ae025cae user: drh tags: zero-byte-backup-fix) | |
|
2012-10-10
| ||
| 12:14 | Define the sqlite3PagerWalFramesize() function even if SQLITE_OMIT_WAL is used. (check-in: 96247853 user: drh tags: trunk) | |
| 10:52 | Add support for URI filenames in sqlite3_analyzer. (check-in: 6dc987d3 user: drh tags: trunk) | |
|
2012-10-09
| ||
| 21:07 | Merge the fix for ticket [d02e1406a58ea02] into trunk. (check-in: dd34bec3 user: drh tags: trunk) | |
| 18:51 | Attempt to suppress warnings generated by Coverity. (check-in: 7b1a6e6c user: drh tags: trunk) | |
| 14:58 | Merge the latest trunk changes, especially the ORDER BY optimizer enhancements but also other fixes, onto the sessions branch. (check-in: f1fbb8c5 user: drh tags: sessions) | |
| 14:36 | Avoid an assertion fault and/or freeing memory while it is still in use when an error occurs during virtual table construction. (check-in: a02599ad user: drh tags: trunk) | |
| 09:26 | Bring some comments up to date in the query planner, and especially the ORDER BY optimizer. Also add testcase() macros. (check-in: bb5c0f1c user: drh tags: trunk) | |
| 01:39 | Remove an unused variable. Fix code that occurs before a variable declaration. (check-in: 01dc032b user: drh tags: trunk) | |
| 01:23 | Replace an always-false conditional with an assert(). (check-in: 981b9943 user: drh tags: trunk) | |
|
2012-10-08
| ||
| 23:25 | Changes to facilitate full test coverage. (check-in: 28d1eb40 user: drh tags: trunk) | |
| 21:51 | Merge ORDER BY optimization refactoring and repair into trunk. (check-in: c027a9af user: drh tags: trunk) | |
| 21:01 | All test cases (veryquick.tcl and min.rc) pass. A few branch operations in ORDER BY optimization logic are untested by min.rc. (Closed-Leaf check-in: 8314fd60 user: drh tags: qp-enhancements) | |
| 20:27 | Further tweaks to the ORDER BY optimizer, to fix a bug and to get the optimizer to recognize some additional cases. (check-in: bcb4f262 user: drh tags: qp-enhancements) | |
| 19:41 | Bug fixes in the ORDER BY optimizer. (check-in: 301bbee4 user: drh tags: qp-enhancements) | |
| 18:23 | Continued refactoring of the ORDER BY optimization logic. This check-in is close to working, but it still has issues. A few test cases fail. (check-in: adbdc663 user: drh tags: qp-enhancements) | |
|
2012-10-05
| ||
| 19:10 | Add QNX-specific performance tweaks to the unix VFS. (check-in: b02849e7 user: drh tags: branch-3.7.9) | |
| 18:38 | Fix an accidental fork on branch-3.7.9. (check-in: cd9efeb3 user: drh tags: branch-3.7.9) | |
| 18:35 | Backport fixes to shared-cache mode, from the shared-cache-fix branch, to version 3.7.9 (check-in: ac81ae49 user: drh tags: branch-3.7.9) | |
| 14:43 | Consolidate all occurrences of the "no such collation sequence" error message into a single spot. (check-in: 8ea67522 user: drh tags: trunk) | |
|
2012-10-04
| ||
| 22:45 | Merge the 3.7.14.1 release including the fix for the LEFT JOIN problem into the sessions branch. (Leaf check-in: 17644c0e user: drh tags: sessions-3.7.14) | |
| 19:41 | • Fixed ticket [d02e1406]: LEFT JOIN with an OR in the ON clause causes segfault plus 2 other changes (artifact: 4a446dbe user: drh) | |
| 19:37 | Version 3.7.14.1 (check-in: 091570e4 user: drh tags: release, version-3.7.14.1, branch-3.7.14) | |
| 16:00 | Candidate fix for ticket [d02e1406a58ea02]. (check-in: 81fd941d user: drh tags: branch-3.7.14) | |
| 15:36 | Increase the version number to 3.7.14.1. The version of autoconf used is different from the previous release so there are huge differences in the generated "configure" script. (check-in: 972dbd5f user: drh tags: branch-3.7.14) | |
| 15:26 | • New ticket [d02e1406] LEFT JOIN with an OR in the ON clause causes segfault. (artifact: 28fef2d3 user: drh) | |
| 12:10 | Yet another refactoring of ORDER BY logic in the query planner. This particular check-in works mostly, but still has a few minor issues. (check-in: 8f448745 user: drh tags: qp-enhancements) | |
|
2012-10-03
| ||
| 18:26 | Work around an optimization issue with the MSVC compiler for ARM. (check-in: 2ce625fd user: drh tags: sessions-3.7.14) | |
| 18:21 | • Edit [86633e01fec2cbc0|86633e01]: Cancel background color. (artifact: d7688839 user: drh) | |
| 18:20 | A branch off of the sessions branch corresponding to release 3.7.14. (check-in: 86633e01 user: drh tags: sessions-3.7.14) | |
| 18:09 | Fix an out-of-order memset() that occurs before all variable declarations are finished. Also fix a line that exceeds the 80-character line length limit. (check-in: ba2f492f user: drh tags: trunk) | |
| 12:56 | • Edit [0f9bb90100aa304a|0f9bb901]: Mark "Closed". (artifact: 19cb817f user: drh) | |
| 12:56 | Update the query planner to recognize more cases where ORDER BY clauses can be optimized out. Add test cases to verify correct behavior of the ORDER BY optimization when the covering-index-scan optimization is disabled. Fix a harmless compiler warning in the TCL interface. (check-in: 956e4d7f user: drh tags: trunk) | |
| 12:38 | Fix a query planner problem that only occurs when covering-index-scan is disabled. Fix to tests whose output changed due to the new and more aggressive ORDER BY optimization. (Closed-Leaf check-in: 0f9bb901 user: drh tags: qp-enhancements) | |
| 11:11 | Fix the TCL interface so that SQL functions implemented in TCL honor the "nullvalue" setting. Also remove from the TCL interface some unused legacy UTF8 translation code left over from SQLite2. (check-in: 9bf64b66 user: drh tags: branch-3.7.14) | |
| 11:02 | Fix the TCL interface so that SQL functions implemented in TCL honor the "nullvalue" setting. Also remove from the TCL interface some unused legacy UTF8 translation code left over from SQLite2. (check-in: c1f10a26 user: drh tags: trunk) | |
| 00:25 | Further attempts to optimize out unnecessary ORDER BY clauses. (check-in: 6744d9a3 user: drh tags: qp-enhancements) | |
|
2012-10-02
| ||
| 23:26 | Work around an optimization issue with the MSVC compiler for ARM. (check-in: 9fab9edd user: drh tags: branch-3.7.14) | |
| 15:19 | More lenient handling of ORDER BY optimization in joins with mixed ASC/DESC. This is a better and less restrictive fix for the problem addressed by the previous check-in. (check-in: abcf6a5d user: drh tags: trunk) | |
| 14:11 | Only continue an ORDER BY optimization into inner loops if the equality constraints on the inner loop match terms of an outer ordered index that are actually used by the ORDER BY clause. (check-in: b0e7b4df user: drh tags: trunk) | |
| 01:46 | Factor an invariant out the loop termination condition for the ORDER BY satisfied-by-index analyzer routine. (check-in: 545bb336 user: drh tags: trunk) | |
| 01:25 | Make sure the outer loop cursor numbers are recorded in time for them to be used by the ORDER BY optimizer. (check-in: 351dc8d9 user: drh tags: trunk) | |
| 01:10 | Improvements to the wheretrace output. (check-in: 76b27765 user: drh tags: trunk) | |
|
2012-10-01
| ||
| 20:32 | Fix harmless compiler warnings. (check-in: 59c2be75 user: drh tags: trunk) | |
| 20:32 | • Edit [8b5f617c2a5f0bf7|8b5f617c]: Mark "Closed". (artifact: 4111ec7a user: drh) | |
| 17:44 | Minor changes to the query planner for improved test coverage. (check-in: c12044df user: drh tags: trunk) | |
| 12:44 | Omit the sqlite3GetReservedNoMutex() routine in build configurations where it is not used. (check-in: f193dbb6 user: drh tags: trunk) | |
| 12:16 | Make sure the size parameter to read and write VFS methods in the unix VFS do not become too big or go negative. This was not actually possible in the current code. The checks are added to make sure some future bug does not make it possible. (check-in: daebe3bd user: drh tags: trunk) | |