Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
120 check-ins using file test/analyze6.test version 1ba1aea8
2012-08-25
| ||
00:49 | Backport check-in [62678be3df35cd]: When the same index is used for all OR-terms in a WHERE clause, then try to use that index as a covering index. (Leaf check-in: 865dfcba user: drh tags: branch-3.7.2) | |
2011-10-25
| ||
21:18 | Cherrypick the [3513bf6ee090d9] so that the sqlite_source_id() function works correctly even with newer versions of Fossil (check-in: 89d63a0e user: drh tags: branch-3.7.2) | |
20:36 | Cherrypick changes [53f5cfe115] and [1f7ef0af8d] in order to fix an issue with DISTINCT (check-in: 14bc58ca user: drh tags: branch-3.7.2) | |
2011-08-26
| ||
17:17 | Cherrypick the recursion fix to test_vfs.c from [065e5a5ea4f82]. Also fix the nan.test module to handle upper/lower case changes in TCL. (check-in: 41b5f869 user: drh tags: branch-3.7.2) | |
2011-07-13
| ||
18:53 | Cherrypicked from trunk: Do not try to use STAT2 for row estimates if the index is unique or nearly so. (check-in: d55b64ef user: drh tags: branch-3.7.2) | |
2011-07-12
| ||
14:48 | Cherrypick change [9f14fa56ba] (the fix for [54844eea3f]) from the trunk. (check-in: 7afb2354 user: dan tags: branch-3.7.2) | |
2011-07-02
| ||
15:42 | Cherrypick change [27c65d4d9c] into the 3.7.2 branch. (check-in: 9bbcd8c0 user: dan tags: branch-3.7.2) | |
13:34 | Cherrypick [45e581bff7] into the 3.7.2 branch. (check-in: c593792c user: dan tags: branch-3.7.2) | |
2011-05-01
| ||
22:57 | Backport check-ins [0900e35348f4b9bf3] and [4fead8e714c7e50] to the 3.7.2 branch. These check-ins provide hints to the btree layer for when it is possible to use a hash table rather than a btree to implement an index. The SQLite BTree layer does not use these hints, but alternative btree layers might. (check-in: 7155e6f3 user: drh tags: branch-3.7.2) | |
2011-04-15
| ||
15:18 | Backport check-in [9f9f32882501ac9] to provide EXPLAIN QUERY PLAN output for the count(*) optimization. Also backport check-in [a8761a9128de945aa] to prevent unordered indices from being used on a full table scan. The first backport was necessary in order to test the second. (check-in: 8d924e16 user: drh tags: branch-3.7.2) | |
2011-04-09
| ||
03:30 | Back port the unordered-index-hack to the 3.7.2 branch. (check-in: 80353020 user: drh tags: branch-3.7.2) | |
2011-04-08
| ||
23:36 | Backport test cases from trunk that seek to prove that the IS NOT NULL query optimization is working. (check-in: 9eff4702 user: drh tags: branch-3.7.2) | |
23:05 | Make sure the query planner is able to correctly analyze NULL value samples in the sqlite_stat2 table. This is a backport of changes from check-in [f73a167b434f] (check-in: 1d637889 user: drh tags: branch-3.7.2) | |
23:04 | Make sure the left-hand side of the IS NOT NULL operator is a simple column and not a general expression before applying the IS NOT NULL optimization. This is a backport of check-in [543f75a6abe3]. (check-in: e8177e01 user: drh tags: branch-3.7.2) | |
2011-04-01
| ||
20:28 | Add additional test data and documentation to the fuzzer virtual table. (Closed-Leaf check-in: a6a81d4f user: drh tags: word-fuzzer) | |
15:30 | If the sessions module is being built as part of the amalgamation, do not try to include sqliteInt.h and vdbeInt.h. (check-in: f87bfe6e user: dan tags: sessions) | |
14:22 | Removed dependency on sqliteInt.h so that multiplex VFS shim can be compiled as loadable module. (Closed-Leaf check-in: 718f1ad7 user: shaneh tags: multiplex-enhancements) | |
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) | |
15:11 | Enable/disable support. (check-in: b3c6d9aa user: shaneh tags: multiplex-enhancements) | |
13:14 | Add tests and fixes for SELECT multiplex_control(op, val); (check-in: fee9734c user: shaneh tags: multiplex-enhancements) | |
05:31 | Additional test cases; Round chunk size up to a multiple of max page size; (check-in: 36e364a3 user: shaneh tags: multiplex-enhancements) | |
2011-03-30
| ||
21:04 | Add the SQLITE_ENABLE_PREUPDATE_HOOK compile-time option. (check-in: 66345214 user: drh tags: sessions) | |
21:03 | Updates to multiplex.test script; misc. bug fixes; (check-in: c41ff235 user: shaneh tags: multiplex-enhancements) | |
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) | |
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:28 | Add tests to syscall.test and sysfault.test. (check-in: 3d2de011 user: dan tags: trunk) | |
18:21 | The first simple test-case appears to be working now. (check-in: dd41155b 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: dbe569a0 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: 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) | |
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: bc6cce81 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: bc02d0c1 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: 7270f80a 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: 0e1d20df 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: 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-25
| ||
19:06 | Improve coverage of session module a bit more. (check-in: 4255a9f6 user: dan tags: sessions) | |
10:52 | Improve coverage of session module code. (check-in: 666123c8 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: 7173b392 user: shaneh tags: trunk) | |
17:37 | Fix problem with tableapi.test on Windows. (check-in: 69fe0c87 user: shaneh tags: trunk) | |
16:53 | Fix handling of schema changes mid-session. (check-in: 76d2d2ad 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: 506a0d7a 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: 54298ee5 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: 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) | |
17:10 | Fix a bug in fts4 to do with matchinfo and deferred tokens. (check-in: 30d42dc6 user: dan tags: trunk) | |
16:03 | Add the "indirect flag" to the changeset blob format. Also the sqlite3session_indirect() API. (check-in: 1feaf2d3 user: dan tags: sessions) | |
11:16 | In the shell, make sure the ".log" command has at least one argument. (check-in: 1ed5e361 user: drh tags: trunk) | |
10:52 | Fix a numbering issue in rtree6.test. Add a couple of extra tests. (check-in: 0b7668a7 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: 387b55aa 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: bdea7089 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: 183c236e 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: e9037e4e user: dan tags: sessions) | |
12:08 | Add OOM tests and related fixes for the session module. (check-in: 06048a68 user: dan tags: sessions) | |
02:03 | Fix a couple typos for consistency in sessions documentation. (check-in: 510198f1 user: shaneh tags: sessions) | |
2011-03-21
| ||
19:41 | Remove some unreachable code in sqlite3session.c. Add test cases. (check-in: 39cdfa53 user: dan tags: sessions) | |
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) | |
16:17 | Add start of fault-injection tests for session module. Fix some bugs related to the same. (check-in: 32e95164 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: aed42730 user: dan tags: sessions) | |
11:03 | Fix session module problems with real (floating point) values. (check-in: a192d04f user: dan tags: sessions) | |
07:23 | Fix some typos in sqlite3session.h. (check-in: 0853e530 user: dan tags: sessions) | |
2011-03-20
| ||
11:20 | Documentation format updates to sqlite3session.h. (check-in: f227f602 user: dan tags: sessions) | |
2011-03-19
| ||
19:19 | Fix a problem involving session objects and attached databases. (check-in: ad91d300 user: dan tags: sessions) | |
18:46 | Fix a bug in changeset generation code. (check-in: 825df75b user: dan tags: sessions) | |
17:07 | Move session1.test from test/ to ext/session/. (check-in: c4436a93 user: dan tags: sessions) | |
16:26 | Fix a problem with resizing a hash table in sqlite3session.c. (check-in: 6e5907e1 user: dan tags: sessions) | |
15:37 | Fix some bugs in sqlite3changeset_apply(). (check-in: 7250318d user: dan tags: sessions) | |
08:38 | Fix a problem with INTEGER PRIMARY KEY columns and the pre-update hook. (check-in: 24d4d5dd user: dan tags: sessions) | |
02:37 | Merge the fix to ticket [f7b4edece25c99485] into the sessions branch. (check-in: 1b736ac2 user: drh tags: sessions) | |
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:03 | Hold the database mutex for the duration of an sqlite3changeset_apply() call. Also for the duration of all sqlite3session_xxx() calls. (check-in: c615c38c user: dan tags: sessions) | |
16:47 | Fixes for compiler warnings. Minor code cleanup. (check-in: 9604d130 user: drh tags: sessions) | |
16:13 | Further improvements to documentation in sqlite3session.h. (check-in: 07019bb9 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: bd94f4c8 user: drh tags: sessions) | |
13:05 | Update comments in sqlite3session.h. More to come. (check-in: e73e9082 user: dan 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) | |
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: cfa4a2f7 user: shaneh tags: multiplex-enhancements) | |
02:55 | Fix cut-and-paste typo in debugging print statement in winMutexTry(). (check-in: def98fd2 user: shaneh 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) | |
05:55 | Backport the SQLITE_OMIT_UNIQUE_ENFORCEMENT change from check-in [b86999436e] on the trunk. (check-in: 668b91db user: shaneh tags: branch-3.7.2) | |
04:58 | More tests for SQLITE_OMIT_UNIQUE_ENFORCEMENT and minor change to implementation. (check-in: b8699943 user: shaneh tags: trunk) | |
2011-03-11
| ||
16:15 | Remove an unused field from the unix sqlite3_file object. (check-in: f957f23a user: drh tags: trunk) | |
2011-03-10
| ||
21:48 | Simplification of tests and more added for SQLITE_OMIT_UNIQUE_ENFORCEMENT tests. (check-in: 75a38411 user: shaneh tags: trunk) | |
21:13 | Skip unique constraint enforcement if compiled with SQLITE_OMIT_UNIQUE_ENFORCEMENT. (check-in: ba85bf8c user: shaneh tags: trunk) | |
03:54 | Minor clean-up of previous mem5 allocator fix. (check-in: 36438423 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: 2d55234e 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: d7dae06f 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: 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
| ||
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-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
| ||
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) | |