Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
126 check-ins for the month beginning 2011-03-01
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: a5aae1743a user: drh tags: branch-3.7.2) | |
| 15:11 | Enable/disable support. (check-in: b3c6d9aa9e user: shaneh tags: multiplex-enhancements) | |
| 13:14 | Add tests and fixes for SELECT multiplex_control(op, val); (check-in: fee9734c19 user: shaneh tags: multiplex-enhancements) | |
| 05:31 | Additional test cases; Round chunk size up to a multiple of max page size; (check-in: 36e364a3fe user: shaneh tags: multiplex-enhancements) | |
| 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: c8f9edd962 user: drh tags: analyze-idx) | |
|
2011-03-30
| ||
| 21:04 | Add the SQLITE_ENABLE_PREUPDATE_HOOK compile-time option. (check-in: 6634521461 user: drh tags: sessions) | |
| 21:03 | Updates to multiplex.test script; misc. bug fixes; (check-in: c41ff2358e user: shaneh tags: multiplex-enhancements) | |
| 19:08 | Further tests for os_unix.c. (check-in: a84f771194 user: dan tags: trunk) | |
| 17:25 | Disable the truncate optimization if there is a preupdate hook. (check-in: d051694e02 user: drh tags: sessions) | |
| 17:07 | Add documentation to the sqlite3_preupdate_hook() interface and its relatives. (check-in: 8180f2881f user: drh tags: sessions) | |
| 14:54 | Do not generate sqlite_stat1 entries for empty tables when running ANALYZE. Ticket [83ea97620bd31016451] (check-in: 3a27af5b3c user: drh tags: trunk) | |
| 02:03 | Merge in all the latest changes from trunk. (check-in: b11d941e92 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: 7958cbba73 user: drh tags: word-fuzzer) | |
|
2011-03-29
| ||
| 23:41 | Add support for rowid. (check-in: 2cf4158ff0 user: drh tags: word-fuzzer) | |
| 18:28 | Add tests to syscall.test and sysfault.test. (check-in: 3d2de01181 user: dan tags: trunk) | |
| 18:21 | The first simple test-case appears to be working now. (check-in: dd41155bc7 user: drh tags: word-fuzzer) | |
| 15:40 | Fix a problem whereby following an IO error in CommitPhaseTwo() of a multi-file transaction the b-tree layer could be left in TRANS_WRITE state, causing problems later on. (check-in: dbe569a099 user: dan tags: trunk) | |
| 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: 3b964155f6 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: 5f2f2fce40 user: drh tags: word-fuzzer) | |
| 10:04 | Fix a problem in the unix VFS implementation of xNextSystemCall(). Also some typos that prevent compilation when HAVE_POSIX_FALLOCATE is defined. (check-in: bc6cce8156 user: dan tags: trunk) | |
| 05:06 | In-progress changes - do not use; Removed prefix support; Added file control interface to enable/disable and adjust chunk size; added app-def function for same; (check-in: bc02d0c193 user: shaneh tags: multiplex-enhancements) | |
| 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: 7270f80ac5 user: drh tags: trunk) | |
|
2011-03-28
| ||
| 19:10 | Add test infrastructure (and some tests) to inject faults into os_unix.c using the new xSetSystemCall interface. (check-in: 0e1d20dfae user: dan 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: fb4c31eac8 user: drh tags: word-fuzzer) | |
| 15:05 | Skeleton code for the word-fuzzer virtual table. (check-in: ea3a4ee136 user: drh tags: word-fuzzer) | |
|
2011-03-25
| ||
| 19:06 | Improve coverage of session module a bit more. (check-in: 4255a9f609 user: dan tags: sessions) | |
| 10:52 | Improve coverage of session module code. (check-in: 666123c8d0 user: dan tags: sessions) | |
|
2011-03-24
| ||
| 17:43 | Minor change to sqlite3Utf8Read() to make consistent with READ_UTF8() usage and avoid implementation defined usages of <<. Added some additional UTF-8 test cases. (check-in: 7173b3929f user: shaneh tags: trunk) | |
| 17:37 | Fix problem with tableapi.test on Windows. (check-in: 69fe0c873d user: shaneh tags: trunk) | |
| 16:53 | Fix handling of schema changes mid-session. (check-in: 76d2d2ad3b user: dan tags: sessions) | |
| 16:04 | Fix handling of schema mismatches in sqlite3session.c so that it matches the docs in sqlite3session.h. (check-in: 506a0d7a71 user: dan tags: sessions) | |
| 11:22 | Store primary key definitions for modified tables in changesets. Add the sqlite3changeset_pk() API to extract this data from a changeset iterator. (check-in: 54298ee5ed user: dan tags: sessions) | |
| 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: b6e268fce1 user: drh tags: trunk) | |
|
2011-03-23
| ||
| 22:54 | Fix a signed/unsigned comparison compiler warning. (check-in: c81da6f98d 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: ad4dc7b95f 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: 9c3a6e4799 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: e059152adc user: drh tags: trunk) | |
| 18:22 | Increase the upper bound on SQLITE_MAX_ATTACHED from 30 to 62. (check-in: 7aaf877227 user: drh tags: trunk) | |
| 17:10 | Fix a bug in fts4 to do with matchinfo and deferred tokens. (check-in: 30d42dc66f user: dan tags: trunk) | |
| 16:03 | Add the "indirect flag" to the changeset blob format. Also the sqlite3session_indirect() API. (check-in: 1feaf2d35f user: dan tags: sessions) | |
| 11:16 | In the shell, make sure the ".log" command has at least one argument. (check-in: 1ed5e361ca user: drh tags: trunk) | |
| 10:52 | Fix a numbering issue in rtree6.test. Add a couple of extra tests. (check-in: 0b7668a71e user: dan tags: trunk) | |
| 10:38 | Change the rtree module to support queries with multiple comparison operators (i.e. > or <) of the same type on a single column. (check-in: 387b55aa9b user: dan tags: trunk) | |
|
2011-03-22
| ||
| 18:45 | Add API function sqlite3_preupdate_depth(), for determining the depth of the trigger stack from within a pre-update callback. (check-in: bdea70895c user: dan tags: sessions) | |
| 16:54 | Fix a crash that can follow an OOM when "all tables" are registered with a session module. (check-in: 183c236e99 user: dan tags: sessions) | |
| 15:21 | If a NULL pointer is passed to sqlite3session_attach() in place of a table name, attach all database tables to the session object. (check-in: e9037e4e4c user: dan tags: sessions) | |
| 12:08 | Add OOM tests and related fixes for the session module. (check-in: 06048a68b3 user: dan tags: sessions) | |
| 02:03 | Fix a couple typos for consistency in sessions documentation. (check-in: 510198f171 user: shaneh tags: sessions) | |
|
2011-03-21
| ||
| 19:41 | Remove some unreachable code in sqlite3session.c. Add test cases. (check-in: 39cdfa5324 user: dan tags: sessions) | |
| 17:17 | Merge in the sqlite3_db_config() enhancements for enabling and disabling FKs and triggers from trunk. (check-in: 2b3c8b9d9a 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: 09e167f9c1 user: drh tags: trunk) | |
| 16:17 | Add start of fault-injection tests for session module. Fix some bugs related to the same. (check-in: 32e95164d1 user: dan tags: sessions) | |
| 11:55 | Clarify handling of NULL values in PK columns in sqlite3session.h. Add tests and fixes for the same. (check-in: aed4273054 user: dan tags: sessions) | |
| 11:03 | Fix session module problems with real (floating point) values. (check-in: a192d04f4e user: dan tags: sessions) | |
| 07:23 | Fix some typos in sqlite3session.h. (check-in: 0853e530cc user: dan tags: sessions) | |
|
2011-03-20
| ||
| 11:20 | Documentation format updates to sqlite3session.h. (check-in: f227f60210 user: dan tags: sessions) | |
|
2011-03-19
| ||
| 19:19 | Fix a problem involving session objects and attached databases. (check-in: ad91d30073 user: dan tags: sessions) | |
| 18:46 | Fix a bug in changeset generation code. (check-in: 825df75ba4 user: dan tags: sessions) | |
| 17:07 | Move session1.test from test/ to ext/session/. (check-in: c4436a936a user: dan tags: sessions) | |
| 16:26 | Fix a problem with resizing a hash table in sqlite3session.c. (check-in: 6e5907e14d user: dan tags: sessions) | |
| 15:37 | Fix some bugs in sqlite3changeset_apply(). (check-in: 7250318dda user: dan tags: sessions) | |
| 08:38 | Fix a problem with INTEGER PRIMARY KEY columns and the pre-update hook. (check-in: 24d4d5dd00 user: dan tags: sessions) | |
| 02:37 | Merge the fix to ticket [f7b4edece25c99485] into the sessions branch. (check-in: 1b736ac293 user: drh tags: sessions) | |
| 02:04 | Add a test case to verify that ticket [f7b4edece25c994857] is fixed. (check-in: eedbcf0a0b 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: 36c04dd169 user: drh tags: trunk) | |
| 18:03 | Hold the database mutex for the duration of an sqlite3changeset_apply() call. Also for the duration of all sqlite3session_xxx() calls. (check-in: c615c38c32 user: dan tags: sessions) | |
| 16:47 | Fixes for compiler warnings. Minor code cleanup. (check-in: 9604d13001 user: drh tags: sessions) | |
| 16:13 | Further improvements to documentation in sqlite3session.h. (check-in: 07019bb9e8 user: dan 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: bd94f4c8b1 user: drh tags: sessions) | |
| 13:05 | Update comments in sqlite3session.h. More to come. (check-in: e73e9082f3 user: dan tags: sessions) | |
| 12:35 | Merge all the latest trunk enhancements into the sessions branch. (check-in: 94fd5bb6da user: drh tags: sessions) | |
|
2011-03-17
| ||
| 19:20 | Change to the session module to use user-defined primary keys instead of rowids when collecting changes. (check-in: 6614cfcb9c user: dan tags: sessions) | |
| 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: 54bacb95dd user: drh tags: trunk) | |
| 01:58 | Comment enhancement to better explain the logic in the "x IS NULL" optimization. (check-in: 869f894798 user: drh tags: trunk) | |
| 01:53 | Backport the "x IS NULL" query planner enhancement of [2353176811f] to the 3.7.2 branch. (check-in: 68daf20d01 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: 2353176811 user: drh tags: trunk) | |
|
2011-03-16
| ||
| 19:59 | Add the sqlite3_preupdate_new() API, for retrieving the new.* values from within a pre-update callback. (check-in: 526545c49f user: dan tags: sessions) | |
| 18:54 | Additional interpretation of flags and constants in the VFS trace output. (check-in: 3e984195f1 user: drh tags: trunk) | |
| 17:05 | Add the -vfstrace option to the usage error message in the shell. (check-in: baca45c549 user: drh tags: trunk) | |
| 16:56 | Add the VFS-trace shim. (check-in: f49a9ef338 user: drh tags: trunk) | |
| 09:49 | Remove the sqlite3_transaction_hook() API. (check-in: b0015a1cfe user: dan tags: sessions) | |
|
2011-03-15
| ||
| 19:08 | Make the "unix-excl" VFS work exactly like "unix" if the database file is read-only. (check-in: d984683499 user: drh tags: trunk) | |
| 18:35 | Fix an out-of-order variable declaration in shell.c. (check-in: 7257084650 user: drh tags: trunk) | |
| 16:37 | Fix some bugs and other code issues in the session module. (check-in: f2930840e4 user: dan tags: sessions) | |
| 04:45 | Allow multiplex file names to be preceeded by prefix of the form ":multiplex:chunksize:maxchunks:" Still work to be done, though it compiles and prefixes are ignored. (check-in: cfa4a2f7ea user: shaneh tags: multiplex-enhancements) | |
| 02:55 | Fix cut-and-paste typo in debugging print statement in winMutexTry(). (check-in: def98fd23e user: shaneh tags: trunk) | |
|
2011-03-14
| ||
| 19:49 | Fix handling of return values from the conflict handler. Document the conflict handler arguments and return codes in sqlite3session.h. (check-in: cbbb274e50 user: dan tags: sessions) | |
| 13:54 | Merge the unix-excl VFS into the trunk. This merge also adds the -vfs option to the command-line shell. (check-in: 3934b004e9 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: a05a6d4087 user: drh tags: unix-excl) | |
| 17:22 | Fix some issues with UPDATE changes in the session module. (check-in: 57862efe71 user: dan tags: sessions) | |
| 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: 00051c3296 user: drh tags: unix-excl) | |
| 05:55 | Backport the SQLITE_OMIT_UNIQUE_ENFORCEMENT change from check-in [b86999436e] on the trunk. (check-in: 668b91dbff user: shaneh tags: branch-3.7.2) | |
| 04:58 | More tests for SQLITE_OMIT_UNIQUE_ENFORCEMENT and minor change to implementation. (check-in: b86999436e user: shaneh tags: trunk) | |
|
2011-03-11
| ||
| 19:05 | Add the sqlite3changeset_apply() function. Does not yet handle all cases. (check-in: 2b19be7bf7 user: dan tags: sessions) | |
| 16:15 | Remove an unused field from the unix sqlite3_file object. (check-in: f957f23a8a user: drh tags: trunk) | |
|
2011-03-10
| ||
| 21:48 | Simplification of tests and more added for SQLITE_OMIT_UNIQUE_ENFORCEMENT tests. (check-in: 75a38411a8 user: shaneh tags: trunk) | |
| 21:13 | Skip unique constraint enforcement if compiled with SQLITE_OMIT_UNIQUE_ENFORCEMENT. (check-in: ba85bf8cb8 user: shaneh tags: trunk) | |
| 03:54 | Minor clean-up of previous mem5 allocator fix. (check-in: 3643842316 user: shaneh 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: 2d55234ea3 user: drh tags: branch-3.7.2) | |
| 21:36 | Fix issue with mem5 allocator when min request size is larger thatn 2^30. (check-in: d7dae06fb2 user: shaneh tags: trunk) | |
| 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: f000c9b2b7 user: drh tags: trunk) | |
| 11:17 | Add a function to the session extension invert a changeset. (check-in: 75d5dff725 user: dan tags: sessions) | |
| 11:04 | Updates to the OS/2 implementation from Rich Walsh. (check-in: dc46156a22 user: drh tags: trunk) | |
|
2011-03-08
| ||
| 19:22 | Add start of sessions feature. (check-in: 269a81a37d user: dan tags: sessions) | |
| 16:39 | Merge the syscall-override changes into trunk. (check-in: 36d79e6f54 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: ddb747d33a user: drh tags: trunk) | |
| 13:06 | Fix two compiler warnings. No functional code changes. (check-in: c829868aa2 user: drh tags: trunk) | |
| 02:38 | Fix additional cases of possible signed integer overflow, especially with regard to negation. (check-in: 2d5800bd8c 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: df3436405e user: drh tags: branch-3.6.1) | |
|
2011-03-06
| ||
| 21:54 | Another minor simplification brought to light by clang. (check-in: 3bfbf026dd user: drh tags: trunk) | |
| 21:28 | Remove dead code identified by the clang static analyzer. (check-in: 01a79d5a7a 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: 55fc25fdab 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: abf2139412 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: 04abab71ec user: drh tags: trunk) | |
|
2011-03-04
| ||
| 15:43 | Handle EINTR errors from open(). (Closed-Leaf check-in: a7d176b27c user: drh tags: syscall-override) | |
| 01:23 | Backport the query planner enhancement of [952f5e8c69904] to the 3.7.2 branch. (check-in: 440d995661 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: 952f5e8c69 user: drh tags: trunk) | |
|
2011-03-03
| ||
| 20:06 | Add the experimental sqlite3_transaction_hook() API. (check-in: 093d8cd8e2 user: dan tags: sessions) | |
|
2011-03-02
| ||
| 22:07 | Fix quoting of the result in rtreeB.test. (check-in: c6532b35cc 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: 3855836349 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: 80fac2a6e0 user: drh tags: syscall-override) | |
| 17:54 | Fix bugs in [7b6e30e6a7] that only show up on Mac. (check-in: ec55e8c6bb 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: 24602557fc user: drh tags: trunk) | |
| 15:09 | Proof-of-concept prototype for the proposed xSetSystemCall extension method on the VFS. (check-in: 92b5a76abc 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: 7b6e30e6a7 user: drh tags: trunk) | |
|
2011-03-01
| ||
| 18:42 | Add the experimental sqlite3_preupdate_hook() API. (check-in: 6145d7b89f user: dan tags: sessions) | |