Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
74 events for the month beginning 2011-03-01 by user drh
Following month ↑|
2011-03-31
| ||
| 18:36 | Provide hints to the btree layer Next and Previous primitives to let them know if they can be no-ops if the underlying index is unique. (check-in: a5aae174 user: drh tags: branch-3.7.2) | |
| 02:03 | Change the ANALYZE command so that it will accept an index name as its argument and only reanalyze that one index. A quick smoke-test works. Need to study the implications to the query planner and test corner cases. (check-in: c8f9edd9 user: drh tags: analyze-idx) | |
|
2011-03-30
| ||
| 21:04 | Add the SQLITE_ENABLE_PREUPDATE_HOOK compile-time option. (check-in: 66345214 user: drh tags: sessions) | |
| 17:25 | Disable the truncate optimization if there is a preupdate hook. (check-in: d051694e user: drh tags: sessions) | |
| 17:07 | Add documentation to the sqlite3_preupdate_hook() interface and its relatives. (check-in: 8180f288 user: drh tags: sessions) | |
| 14:54 | • Fixed ticket [83ea9762]: ANALYZE on empty tables prevents the use of indices plus 2 other changes (artifact: 045510fe user: drh) | |
| 14:54 | Do not generate sqlite_stat1 entries for empty tables when running ANALYZE. Ticket [83ea97620bd31016451] (check-in: 3a27af5b user: drh tags: trunk) | |
| 13:34 | • New ticket [83ea9762] ANALYZE on empty tables prevents the use of indices. (artifact: 9bc84d40 user: drh) | |
| 02:03 | Merge in all the latest changes from trunk. (check-in: b11d941e user: drh tags: sessions) | |
| 01:43 | Move to an O(NlogN) algorithm for the priority queue. An insertion sort was way too slow. (check-in: 7958cbba user: drh tags: word-fuzzer) | |
|
2011-03-29
| ||
| 23:41 | Add support for rowid. (check-in: 2cf4158f user: drh tags: word-fuzzer) | |
| 18:21 | The first simple test-case appears to be working now. (check-in: dd41155b user: drh tags: word-fuzzer) | |
| 15:00 | If the keyword "unordered" appears at the end of the SQLITE_STAT1.STAT column for an index, then use that index for equality lookups only, never for range queries or sorting. (Closed-Leaf check-in: 3b964155 user: drh tags: unordered-index-hack) | |
| 14:08 | Further improvements to the fuzzer. It still is not quite working. Pausing to work on other things.... (check-in: 5f2f2fce user: drh tags: word-fuzzer) | |
| 12:53 | • Edit [cfa4a2f7ea948be0|cfa4a2f7]: Change branch background color to "#aaa8d3". (artifact: c7b219be user: drh) | |
| 01:47 | Fix the documentation for the sqlite3_column_*_name() functions to describe that the information can be invalidated when a prepared statement is reprepared by the first invocation of an sqlite3_step() for a particular execution cycle. (check-in: 7270f80a user: drh tags: trunk) | |
|
2011-03-26
| ||
| 19:04 | Added most of the logic. Simple test runs without segfaulting but does not give the correct answer. (check-in: fb4c31ea user: drh tags: word-fuzzer) | |
| 15:05 | Skeleton code for the word-fuzzer virtual table. (check-in: ea3a4ee1 user: drh tags: word-fuzzer) | |
|
2011-03-24
| ||
| 01:34 | The changes to fix [f7b4edece25c9948] mean that the schema is always loaded whenever a prepared statement is running. This means that a couple of branches can be eliminated and one operand of OP_ParseSchema can be removed. (check-in: b6e268fc user: drh tags: trunk) | |
|
2011-03-23
| ||
| 22:54 | Fix a signed/unsigned comparison compiler warning. (check-in: c81da6f9 user: drh tags: trunk) | |
| 22:51 | Update the test_vfstrace.c shim to conform to the new VFS interface for xSetSystemCall and xGetSystemCall. (check-in: ad4dc7b9 user: drh tags: trunk) | |
| 22:48 | Merge in all the latest changes from the trunk, and especially the interface changes to the SystemCall methods of the VFS. (check-in: 9c3a6e47 user: drh tags: sessions) | |
| 22:02 | Change the xSetSyscall methods of the VFS so that they do not cast object pointers into function pointers. Fix other unrelated compiler warnings. (check-in: e059152a user: drh tags: trunk) | |
| 18:22 | Increase the upper bound on SQLITE_MAX_ATTACHED from 30 to 62. (check-in: 7aaf8772 user: drh tags: trunk) | |
| 11:16 | In the shell, make sure the ".log" command has at least one argument. (check-in: 1ed5e361 user: drh tags: trunk) | |
|
2011-03-21
| ||
| 17:17 | Merge in the sqlite3_db_config() enhancements for enabling and disabling FKs and triggers from trunk. (check-in: 2b3c8b9d user: drh tags: sessions) | |
| 17:15 | Add the ability to enable and disable foreign key constraints and triggers using calls to sqlite3_db_config(). (check-in: 09e167f9 user: drh tags: trunk) | |
|
2011-03-19
| ||
| 15:50 | • Edit [6145d7b89f835003|6145d7b8]: Move to branch sessions. (artifact: 2a7dca62 user: drh) | |
| 02:37 | Merge the fix to ticket [f7b4edece25c99485] into the sessions branch. (check-in: 1b736ac2 user: drh tags: sessions) | |
| 02:04 | • Fixed ticket [f7b4edec]: sqlite3_update_hook gives incorrect table name with shared cache plus 2 other changes (artifact: 45ac238b user: drh) | |
| 02:04 | Add a test case to verify that ticket [f7b4edece25c994857] is fixed. (check-in: eedbcf0a user: drh tags: trunk) | |
|
2011-03-18
| ||
| 21:55 | Add a generation counter to the Schema object and enhance OP_VerifySchema to also check the Schema generation. Fix for ticket [f7b4edece25c99]. (check-in: 36c04dd1 user: drh tags: trunk) | |
| 18:55 | • New ticket [f7b4edec] sqlite3_update_hook gives incorrect table name with shared cache. (artifact: 126604a6 user: drh) | |
| 16:47 | Fixes for compiler warnings. Minor code cleanup. (check-in: 9604d130 user: drh tags: sessions) | |
| 15:13 | Fix a memory allocation issues in the preupdate hook so that the hook.test script runs clean in valgrind. (check-in: bd94f4c8 user: drh tags: sessions) | |
| 12:35 | Merge all the latest trunk enhancements into the sessions branch. (check-in: 94fd5bb6 user: drh tags: sessions) | |
|
2011-03-17
| ||
| 16:45 | Update the implementation of ".testctrl" in the command-line shell to use a look-up table rather than a long sequence of if-elses. Shorten source code lines of shell.c to 80 characters or less. (check-in: 54bacb95 user: drh tags: trunk) | |
| 01:58 | Comment enhancement to better explain the logic in the "x IS NULL" optimization. (check-in: 869f8947 user: drh tags: trunk) | |
| 01:53 | Backport the "x IS NULL" query planner enhancement of [2353176811f] to the 3.7.2 branch. (check-in: 68daf20d user: drh tags: branch-3.7.2) | |
| 01:34 | Enhances to the query planner such that "x IS NULL" constraints take the STAT2 statistics into account, just like "x=VALUE" constraints. (check-in: 23531768 user: drh tags: trunk) | |
|
2011-03-16
| ||
| 18:54 | Additional interpretation of flags and constants in the VFS trace output. (check-in: 3e984195 user: drh tags: trunk) | |
| 17:05 | Add the -vfstrace option to the usage error message in the shell. (check-in: baca45c5 user: drh tags: trunk) | |
| 16:56 | Add the VFS-trace shim. (check-in: f49a9ef3 user: drh tags: trunk) | |
|
2011-03-15
| ||
| 19:08 | Make the "unix-excl" VFS work exactly like "unix" if the database file is read-only. (check-in: d9846834 user: drh tags: trunk) | |
| 18:35 | Fix an out-of-order variable declaration in shell.c. (check-in: 72570846 user: drh tags: trunk) | |
|
2011-03-14
| ||
| 13:54 | Merge the unix-excl VFS into the trunk. This merge also adds the -vfs option to the command-line shell. (check-in: 3934b004 user: drh tags: trunk) | |
|
2011-03-12
| ||
| 18:10 | In the "unix-excl" VFS, use the heap for shared memory, since only a single process is able to read or write the database. (Closed-Leaf check-in: a05a6d40 user: drh tags: unix-excl) | |
| 17:02 | Add the new optional "unix-excl" VFS. This VFS grabs an exclusive lock on the database preventing other processes from accessing it, but continues to allow other database connections from the same process. (check-in: 00051c32 user: drh tags: unix-excl) | |
|
2011-03-11
| ||
| 16:15 | Remove an unused field from the unix sqlite3_file object. (check-in: f957f23a user: drh tags: trunk) | |
|
2011-03-09
| ||
| 22:09 | Backport the OP_Next and OP_Prev for UNIQUE indices patch from checkin [f000c9b2b7] on the trunk. (check-in: 2d55234e user: drh tags: branch-3.7.2) | |
| 21:02 | Omit unnecessary OP_Next and OP_Prev operators when uniqueness constraints guarantee that the code will only make one pass through the loop. (check-in: f000c9b2 user: drh tags: trunk) | |
| 11:04 | Updates to the OS/2 implementation from Rich Walsh. (check-in: dc46156a user: drh tags: trunk) | |
|
2011-03-08
| ||
| 17:04 | • Edit [a7d176b27cd73791|a7d176b2]: Mark "Closed". (artifact: 3b7199aa user: drh) | |
| 16:39 | Merge the syscall-override changes into trunk. (check-in: 36d79e6f user: drh tags: trunk) | |
| 14:05 | Unix errno integer can vary from one system to the next. So do not depend on specific errno values in test cases. (check-in: ddb747d3 user: drh tags: trunk) | |
| 13:06 | Fix two compiler warnings. No functional code changes. (check-in: c829868a user: drh tags: trunk) | |
| 02:38 | Fix additional cases of possible signed integer overflow, especially with regard to negation. (check-in: 2d5800bd user: drh tags: trunk) | |
|
2011-03-07
| ||
| 16:12 | Backport a fix from [6b0cabd017ed25] (version 3.6.16 - 2009-03-05) to the 3.6.1 branch, a fix that prevents a null pointer deref if one of the column access routines such as sqlite3_column_int() is called with a NULL first parameter. (check-in: df343640 user: drh tags: branch-3.6.1) | |
|
2011-03-06
| ||
| 21:54 | Another minor simplification brought to light by clang. (check-in: 3bfbf026 user: drh tags: trunk) | |
| 21:28 | Remove dead code identified by the clang static analyzer. (check-in: 01a79d5a user: drh tags: trunk) | |
|
2011-03-05
| ||
| 21:41 | Simplifications to the overflow-free multiplier. Also remove some commented-out code that was left in that subroutine by mistake on the previous check-in. (check-in: 55fc25fd user: drh tags: trunk) | |
| 20:59 | Fix all known instances of signed-integer overflow. Within SQL expressions, integer overflow now forces coercion to floating point. The shift operators work with any integer right-hand operand with negative values reversing the direction of the shift. (check-in: abf21394 user: drh tags: trunk) | |
| 13:54 | Fix an instance of signed arithmetic overflow and an one bit-shift overflow. Mark six other signed arithmetic overflow locations that need fixing. (check-in: 04abab71 user: drh tags: trunk) | |
|
2011-03-04
| ||
| 15:43 | Handle EINTR errors from open(). (Closed-Leaf check-in: a7d176b2 user: drh tags: syscall-override) | |
| 01:23 | Backport the query planner enhancement of [952f5e8c69904] to the 3.7.2 branch. (check-in: 440d9956 user: drh tags: branch-3.7.2) | |
| 00:56 | Do a better job of choosing the join table order when the tables having very different numbers of rows. (check-in: 952f5e8c user: drh tags: trunk) | |
|
2011-03-02
| ||
| 22:07 | Fix quoting of the result in rtreeB.test. (check-in: c6532b35 user: drh tags: trunk) | |
| 19:06 | Add additional VFS methods to retrieve system call pointers and to get a list of all changeable system calls. (check-in: 38558363 user: drh tags: syscall-override) | |
| 18:01 | Add more system calls to the set that can be overridden in os_unix.c. Also merge in recent fixes from trunk. (check-in: 80fac2a6 user: drh tags: syscall-override) | |
| 17:54 | Fix bugs in [7b6e30e6a7] that only show up on Mac. (check-in: ec55e8c6 user: drh tags: trunk) | |
| 15:44 | Make sure the rtreenode() testing and analysis routine in the RTREE extension can handle 64-bit rowids. This fix is in response to a message on the mailing list. (check-in: 24602557 user: drh tags: trunk) | |
| 15:09 | Proof-of-concept prototype for the proposed xSetSystemCall extension method on the VFS. (check-in: 92b5a76a user: drh tags: syscall-override) | |
| 02:08 | Log all error from close() in os_unix.c to sqlite3_log() but do not attempt to report errors back up to the application. Update the unix error logging to put the most important information earlier in the message. (check-in: 7b6e30e6 user: drh tags: trunk) | |
|
2011-03-01
| ||
| 20:39 | • Edit [6145d7b89f835003|6145d7b8]: Change branch background color to "#b1d3a8". (artifact: 2bcca2a6 user: drh) | |