SQLite
Branches
Not logged in

The initial check-in for each branch:

2014-10-29
01:07 [a8f9bd1e89] Call fsync() right after ftruncate() when in journal_mode=TRUNCATE and when synchronous=FULL in order to ensure that transactions are durable across a power loss that happens moments after the commit. Proposed fix for https://bugzilla.mozilla.org/show_bug.cgi?id=1072773. This is a cherrypick of 3e922208b68563489. (user: drh, tags: branch-3.8.7)
2014-10-24
00:35 [c297a84bc6] Add the SQLITE_ENABLE_API_ARMOR compile-time option. This is a work in progress and is not yet completely functional. (user: drh, tags: api-armor)
2014-10-23
17:26 [c6a5b67ae1] Leaf: Add debugging code to count the number of iterations of each loop made as part of statement execution. (user: dan, tags: debug-loopcounters)
2014-10-22
16:25 [1a5a5da331] Leaf: The _beginthreadex() / _endthreadex() functions should only be used when compiling with MSVC. (user: mistachkin, tags: msvcThreads)
02:43 [674848070e] Call fsync() right after ftruncate() when in journal_mode=TRUNCATE and when synchronous=FULL in order to ensure that transactions are durable across a power loss that happens moments after the commit. Proposed fix for https://bugzilla.mozilla.org/show_bug.cgi?id=1072773. This is a cherry-pick of 3e922208b68563 (user: drh, tags: branch-3.8.6)
2014-10-13
01:23 [b9c695e885] Add the OP_SorterColumns opcode - an experiment in using a special case opcode to decode the Sorter output rather than the generic OP_Column. This might be faster. And with further work, it could eventually eliminate the need for OP_OpenPseudo. (user: drh, tags: OP_SorterColumns)
2014-10-10
20:52 [2a9573962b] Closed-Leaf: Account for the ASC/DESC properties of ORDER BY expressions when using the same index for GROUP BY and ORDER BY. Candidate fix for [ba7cbfaedc]. (user: dan, tags: experimental)
2014-10-03
19:16 [e6f7f97dbc] Improve the accuracy of the estimates used when searching an index for values not present in any stat4 samples under some circumstances. (user: dan, tags: stat4-avgeq)
2014-09-30
21:24 [0efc6859d1] Leaf: Draw the TreeView debugging graphs using unicode box-drawing characters. (user: drh, tags: box-character-graph)
2014-09-29
18:47 [5e5d6e8680] Leaf: Add the OPFLAG_MULTICOLUMN flag to the OP_Column opcode. Rearrange OP_Column instructions to take advantage of the new flag for a small performance increase (user: drh, tags: faster-OP_Column)
2014-09-27
05:00 [3edab9957c] Reduce the amount of memcpy() required by defragmentPage(). (user: drh, tags: defrag-opt)
2014-09-24
04:38 [c705cf856d] Closed-Leaf: Experiment using linear interpolation, instead of a strict binary search, when looking for integer-keyed rows on a single b-tree page. The experiment was not successful. The number of key comparisons is reduced by about 15%, but the added complexity of the search logic causes an overall reduction in performance. The patch is saved for historical reference only. (user: drh, tags: linear-interpolation)
2014-09-20
18:18 [cbe0cf9ddf] Enable SELECT query planning tracing when compiled with SQLITE_ENABLE_SELECTTRACE and either SQLITE_DEBUG or SQLITE_TEST. (user: drh, tags: select-trace)
00:02 [35db3e2f35] Revise macro usage in 'sqliteInt.h'. (user: mistachkin, tags: sqliteIntMacros)
2014-09-19
00:43 [5b9b898779] Add the sqlite3VdbeMemClearAndResize() interface to be used in place of sqlite3VdbeMemGrow(). A C++ style comment was left in this check-in by mistake, and so it has been moved into a branch to avoid problems in any future bisects on windows. (user: drh, tags: Cplusplus-comment)
2014-09-16
14:16 [0be3019ed7] Reorder the elements of the Mem object for a small size reduction and performance improvement. Moved into a branch because MSVC is unable to handle named structure initializer on nullMem. (user: drh, tags: micro-optimizations)
2014-09-09
17:27 [94954850cf] Add new APIs that take 64-bit length parameters: sqlite3_malloc64(), sqlite3_realloc64(), sqlite3_bind_blob64(), sqlite3_bind_texte64(), sqlite3_result_blob64(), and sqlite3_result_texte64(). Internal memory allocation routines also now use 64-bit unsigned length parameters for safety. Also add the sqlite3_msize() interface. Fix the sqlite3_get_table() to use sqlite3_realloc64() to avoid a integer overflow problem. (user: drh, tags: 64-bit-lengths)
14:47 [8440f093ba] Non-working preliminary implementation attempts on user authentication. (user: drh, tags: user-auth)
2014-09-06
16:49 [e7fae33c07] Fixes to os_unix.c to support database (and other) files larger than 2GiB. (user: dan, tags: android-large-filles)
2014-09-02
19:59 [2954ab5010] Add an experimental extension for applying bulk updates to databases. (user: dan, tags: experimental-bulk-update)
2014-08-29
12:29 [462f42af52] Closed-Leaf: Contains a fault. Was: Avoid an unnecessary OP_Move operation for expression subqueries. (user: drh, tags: mistake)
11:24 [8c57bcc327] Closed-Leaf: Add the sqlite3VdbeChangeDest() routine that can be used to eliminate OP_Move opcodes. (user: drh, tags: experimental)
2014-08-28
16:01 [052d89b554] Fix a problem causing an inaccurate stat4-based estimate for the number of rows visited by a range scan. (user: dan, tags: stat4-experimental)
2014-08-22
14:34 [8267d82174] Get the sqlite3VdbeSerialGet() routine to run faster by avoiding the use of local variables. (user: drh, tags: experimental)
2014-08-21
19:11 [2f59e71fbf] For sqlite3_win32_is_nt(), assume WinRT is NT-based. (user: mistachkin, tags: winrt)
2014-08-20
11:56 [1cb1cd6493] Further size reduction and performance improvement in btree.c:allocateSpace(). (user: drh, tags: btree-speedup)
2014-08-18
15:08 [c2fcf0b9f4] Begin adding commands to the command-line interface for interacting with the sessions extension. This is the first check-in of a work-in-progress. (user: drh, tags: sessions_from_cli)
2014-08-14
18:31 [cc910b8e0c] Closed-Leaf: Fix compiler warnings on WinCE. (user: mistachkin, tags: winCeWarn)
2014-08-12
13:32 [169fc47e16] Leaf: Remove support for Win9x. (user: drh, tags: drop-win9x-support)
2014-08-08
16:52 [299b957027] Because SQLite internally calculates query plan costs using a logarithmic scale, very large estimated sorting costs can cause all other estimated costs to be rounded down to zero. In these cases break ties between plans with the same total cost by comparing the costs with sorting excluded. This is an alternative fix for the problem addressed by 2af630c572. (user: dan, tags: query-planner-fix)
2014-08-07
16:50 [ec5d84ba69] Oops! This check-in was on trunk. But it contains a debugging printf(). Original comment: When the estimated cost to do a sort overwhelms the estimated cost to do individual table lookups, make sure that the table lookup costs are still taken into consideration when selecting the lookup algorithm. (user: drh, tags: query-planner-fix)
2014-08-04
15:12 [2f724cbac9] Closed-Leaf: Changed my mind: This opcode name changes mere creates unnecessary diff marks between older and newer versions without significantly improving readability. Was: Rename the IsNull opcode to IfNull and rename the NotNull opcode to IfNotNull. (user: drh, tags: deadend)
2014-08-02
21:03 [436e884215] Enhancements to the code generator for the IN operator that result in much faster queries in some cases, for example when the RHS of the IN operator changes for each row of a large table scan. (user: drh, tags: IN-operator-improvements)
2014-08-01
14:46 [ee0fd6aaf9] Begin making changes to the IN operator in an attempt to make it run faster and to make the code easier to understand. (user: drh, tags: IN-operator-improvements)
2014-07-31
17:47 [bc14e64bdf] Leaf: Try to reuse sorter statements in fts5. Does not work due to circular references on VTable object. (user: dan, tags: save_sorter_stmt)
2014-07-29
05:49 [18984c3210] Enhancements and updates to the Win32 mutex subsystem. (user: mistachkin, tags: winMutex)
2014-07-23
18:36 [3e1e79e133] Improve the performance of the ANALYZE command by taking advantage of the fact that every row of a UNIQUE index is distinct. (user: drh, tags: faster-analyze)
01:26 [34a1f38b7a] Add support for parsing C-style hexadecimal literals. (user: drh, tags: hex-literal)
2014-07-19
20:15 [7fe601ead0] Add new ASCII mode to the shell capable of importing and exporting using the official unit and record separators (i.e. 0x1F and 0x1E, respectively). (user: mistachkin, tags: asciiMode)
2014-07-18
21:16 [6dc7b2f119] Fix harmless compiler warnings for MSVC in the showdb/showwal command line tools. (user: mistachkin, tags: toolWarnings)
2014-06-30
13:32 [8cb43eddab] Generate complete samples for sqlite_stat4 on WITHOUT ROWID tables. Ticket [b2fa5424e6fcb15b5] (user: drh, tags: stat4-without-rowid)
2014-06-26
20:21 [01dc810259] Attempt to use sqlite_stat4 data to estimate the number of rows visited by a range query that uses a skip-scan. This code is largely untested. (user: dan, tags: stat4-skipscan)
2014-06-23
11:33 [1e0648dcf2] Add some code for an experimental fts5 module. Does not work yet. (user: dan, tags: fts5)
2014-06-17
02:46 [d6883e960f] Do not attempt to create an automatic index on a constant constraint, as doing so is pointless. (user: drh, tags: autoindex-improvements)
2014-06-10
20:18 [401a0ca3dd] Leaf: Proposed change to the fix for ticket [1c69be2dafc28b] such that legacy applications that were exploiting the older buggy behavior in SQLite continue to work. (user: drh, tags: group-by-name-resolution)
2014-06-09
20:06 [c41df393c6] Closed-Leaf: Enhance the unix VFS so that it keeps track of the size of unlinked files internally and thus avoids the need to call fstat() on those files, since fstat() does not work reliably on unlinked files on some implementations of FuseFS. (user: drh, tags: omit-fstat-after-unlink)
2014-05-28
09:56 [7d445e593a] Leaf: Moved to "mistake" because this commit contains a typo causing a test to fail. Was: Add an extra test to further verify that the FTS notindexed option is working properly. (user: dan, tags: mistake)
03:27 [d43e2e59b5] Revise locking retry semantics in Win32 VFS to abort early if the file handle is reported as invalid. (user: mistachkin, tags: winLockHandle)
2014-05-26
20:06 [2c7e277bbe] Enable the OR optimization for WITHOUT ROWID tables. Use a temp table instead of the RowSet object to track the rows that have already been included in the result set. (user: dan, tags: without-rowid-or-opt)
2014-05-19
15:16 [17349a49d2] Changes to help ensure that a multiplication does not overflow when computing the number of bytes needed for a memory allocation, and cause a malfunction. No problems existing problems were discovered. However, these changes should help to ensure that no problems arise in the future. (user: drh, tags: safer-malloc)
2014-05-16
23:38 [7e60347e21] Closed-Leaf: Fix harmless compiler warnings. (user: mistachkin, tags: ftsWarnings)
2014-05-12
20:04 [b3b505a4dd] Experimental code to prevent FTS indexes from growing indefinitely as the table is updated. (user: dan, tags: fts4-experimental)
2014-05-08
22:01 [38cbcedbb6] Experimental changes to pre-cache a database file prior to it being fully opened. (user: mistachkin, tags: winPreCache)
2014-05-07
17:19 [0deac87375] Make sure the group_concat() function returns an empty string, not a NULL, if it has at least one input row. Fix for ticket [55746f9e65f8587]. (user: drh, tags: tkt-55746f9e)
2014-05-06
15:28 [8ad0a123a2] Leaf: Experimental changes that reduce the size of Expr objects from 72 to 64 bytes each on x64 and from 48 to 44 bytes each on x32. (user: drh, tags: smaller-expr)
2014-05-05
19:57 [35a9f3f178] Try to reduce the amount of memory used to hold the schema when PRAGMA ignore_check_constraints is active. (user: drh, tags: reduce-schema-size)
18:24 [857f2baf9b] Centralize and reform use of the Win32 related include files. (user: mistachkin, tags: winHdr)
2014-04-24
20:04 [c5a6ec0a88] Changes to the way the planner calculates the costs of various table and index scans. Some test cases still failing. (user: dan, tags: experimental-costs)
13:20 [34155c406c] Add sqlite3_log() diagnostic messages for a specific type of corruption where the file size is reported to be too small relative to the size in the header. This branch is intended to help debug a specific problem reported from the wild and is not for general use. (user: drh, tags: filesize-debug)
2014-04-23
12:00 [2029a396dc] Closed-Leaf: Enhancements to the date and time functions so that they optionally support a 5-digit year. Not sure we want to include this in trunk. Saved in a branch for future reference. (user: drh, tags: five-digit-year)
2014-04-22
19:30 [03e3c5a8b1] Add the win32-none VFS which omits rollback-journal locking. (user: drh, tags: win32-none)
2014-04-18
00:08 [a1b2f28ba8] Preliminary changes to support building VSIX packages for Windows Phone 8.1. (user: mistachkin, tags: vsixWinPhone81)
2014-04-15
21:06 [53688a25c2] Initial attempt at getting R-Tree queries to work using a priority queue. This check-in compiles, but R-Trees do not work well. And there are debugging printf()s left in the code. This is an incremental check-in. (user: drh, tags: rtree-queue)
2014-04-11
16:14 [20a73ec0b2] Update comments in the R-Tree module in preparation for some big changes. Add an "rtree" performance test to speedtest1. (user: drh, tags: rtree-enhancements)
2014-04-09
20:04 [f9d5e09afa] Experimental multi-threaded sorting changes to allow the sorter to begin returning items to the VDBE before all data is sorted. (user: dan, tags: threads-experimental)
2014-04-07
18:44 [cbfc0f6d49] Closed-Leaf: Experimental multi-threaded sorting changes to begin merging PMAs before SorterRewind() is called. (user: dan, tags: abandoned)
2014-04-02
14:16 [abbdb92516] Closed-Leaf: Incorrect change to a comment. (user: drh, tags: mistake)
2014-03-29
21:16 [8f869ca7a6] Experiments in picking better query plans, especially when the usage of one index is a subset of another. (user: drh, tags: query-plan-experiments)
19:48 [83a105c864] Closed-Leaf: Changes to make the multi-threaded sorter sort stably. (user: dan, tags: threads-closed)
2014-03-26
16:22 [db2935473e] Fix a potential buffer overread that could have occurred when searching a corrupt database file. (user: drh, tags: branch-3.8.4)
2014-03-24
12:33 [0b95b7a874] Closed-Leaf: Cancel column-cache entries that are involved in a comparison operator since the comparison might have forced an affinity change. Originally proposed as a fix for ticket [a8a0d2996a], but later determined to be incorrect. (user: drh, tags: tkt-a8a0d2996a)
2014-03-20
12:36 [eae6dfbe55] Closed-Leaf: One possible fix for the [e39d032577d] problem it to replace the failing assert() with a testcase() as shown here. (user: drh, tags: tkt-e39d0325)
08:59 [6f3a5c24d2] Add an experimental fix to avoid attempting to mmap memory from an offset that is not a multiple of the system page size on systems with page sizes larger than 32KB. (user: dan, tags: shm-mapping-fix)
2014-03-18
15:30 [b150902579] Experiments with the optimization of ORDER BY and GROUP BY clauses. (user: drh, tags: orderby-planning)
2014-03-11
20:33 [da59198505] Enable the b-tree cursor object's overflow page-number cache, which is normally enabled only for incr-blob cursors, for all cursors. (user: dan, tags: overflow-pgno-cache)
14:44 [04caffcef3] Closed-Leaf: Forgot to change the VERSION file. (user: drh, tags: mistake)
2014-03-05
01:29 [bac2820e13] Closed-Leaf: Experimental simplification of memory flags/type handling. (user: mistachkin, tags: noMemType)
2014-03-03
21:59 [aec5473a75] Refactor the sqlite3VdbeRecordCompare() routine used to compare btree records. Create a couple of fast-track routines to handle the common cases of a string with BINARY collation or integer values as the left-most column. This gives a significant performance boost in common use. Oops: This build does not work on the Beaglebone where "char" defaults to unsigned. (user: drh, tags: broken-on-arm)
2014-03-01
14:45 [4aeb3ae435] Add extra assert() statements trying to catch a Mem object in an inconsistent state. (user: drh, tags: enhanced-mem-check)
2014-02-26
19:05 [3ad687b7aa] Leaf: Only run the OP_OpenRead opcodes for a correlated subquery once, on the initial iteration. Keep the cursor open for subsequent runs. This was suppose to be a performance enhancement, but it is difficult to come up with a query where is makes a significant difference. Hence, the change is getting parked in a branch. (user: drh, tags: open-only-once)
2014-02-25
21:01 [85206e0bba] Attempt to speed up sqlite3VdbeRecordCompare() by various means. This code is in an interim state. (user: dan, tags: experimental)
19:38 [cc5eda5422] Closed-Leaf: Make sure temporary registers used within a co-routine are not also used outside of that co-routine, in order to prevent concurrent use of the same register for two different things. Ticket [8c63ff0eca81a9132d8] (user: drh, tags: tkt-8c63ff0eca)
2014-02-21
05:44 [6676475c47] Better loadable extension handling in the Win32 VFS when compiled for Cygwin. (user: mistachkin, tags: cygDlOpen)
2014-02-18
05:18 [adba783c70] Enhance the Win32 VFS I/O retry logic. (user: mistachkin, tags: winIoRetry)
2014-02-16
01:55 [aa2d8b0e81] Enhance the code generator for INSERT INTO ... SELECT so that the SELECT generates output directly in the registers that INSERT INTO will be using, in many cases, and OP_SCopy operations can thus be avoided. (user: drh, tags: insert-optimization)
2014-02-14
23:35 [e147230767] Better support for MinGW 4.x. (user: mistachkin, tags: mingw4x)
2014-02-10
19:37 [538f7b25e4] Experimental change to os_unix.c to delay creating a database file until it is first written. (user: dan, tags: deferred-open)
16:13 [90e9deae4a] Modify the command-line shell to print a warning when using an in-memory database. (user: drh, tags: memdb-warning)
2014-02-08
13:22 [35f2793db5] Fix a harmless compiler warning in VS2013. (user: drh, tags: branch-3.8.3)
2014-02-07
18:27 [1ec0e9dd4b] Get rid of the OP_Undef and OP_IsUndef opcodes in favor of higher-level OP_InitCoroutine and OP_EndCoroutine. (user: drh, tags: coroutine-refactor)
13:20 [6fb7448550] Add the OP_Undef and OP_IsUndef opcodes. With these, use the first register in the result register range as the flag to indicate EOF on an INSERT from a SELECT, rather than allocating a separate boolean register for that task. (user: drh, tags: coroutine-refactor)
2014-02-05
17:08 [a332908b70] Make the root page of an ephemeral index be page 1 instead of page 2. (user: drh, tags: subquery-codegen-refactor)
2014-01-31
06:35 [492585c820] Closed-Leaf: Minor change to TEA extension docs in an attempt to make links work correctly. (user: mistachkin, tags: teaDoc)
2014-01-30
11:12 [c723ec2784] Closed-Leaf: Enhance the MSVC makefile for better debugging symbol support. (user: mistachkin, tags: msvcDebug)
2014-01-21
22:25 [b2671e1133] Change the recursive common table expression algorithm to use a queue instead of a pair of tables. Runs about 25% faster on the sudoku solver query. The OP_SwapCursors opcode is no longer required. The current implementation uses just a fifo, but the plan is to change it into a queue that will support ORDER BY and LIMIT in a recursive query. (user: drh, tags: cte-via-queue)
00:19 [cc1cb32178] Add support for the LEVEL pseudo-column in the recursive part of a common table expression. LEVEL has the value of 1 on the first iteration and successively larger integer values of subsequent iterations. It cannot have a table qualifier. Actual columns named "level" can still be accessed by including the table name qualifier. (user: drh, tags: level-pseudocolumn)
2014-01-11
13:22 [da98b7205e] Parse common table expressions. But do not do anything with them (yet). (user: drh, tags: common-table-expr)
03:13 [4e4483b2d4] Closed-Leaf: Add the "%token_class" directive to the LEMON parser generator. This opens up the possibility of simplifying the parser. Also remove all calls to sprintf(), strcpy(), and strcat() from LEMON to avoid compiler warnings on OpenBSD. (user: drh, tags: buggy-lemon)
2014-01-10
23:21 [e43c522dde] Do not use sprintf(), strcpy() or strcat() in the implementation of the lemon parser generator tool, to avoid compiler warnings in OpenBSD. (user: drh, tags: lemon-updates)
2014-01-06
18:32 [4365ddd62d] Closed-Leaf: Start a new experimental branch for support of Oracle-style CONNECT BY syntax. (user: drh, tags: connect-by)
2014-01-04
14:16 [19f3208b26] Have the planner detect cases where a MATCH constraint is applied to a virtual table, and ignore any plans that do not allow the virtual table implementation to implement the MATCH filtering. (user: dan, tags: avoid-unusable-match)
2013-12-23
15:35 [ac5852d640] Make sure the WhereLoop.aLTerm[] array is large enough when processing the skip-scan optimization. Fix for ticket [520070ec7fbaac]. (user: drh, tags: branch-3.8.2)
2013-12-18
15:11 [4c6a659c43] Show changes to the column cache when PRAGMA vdbe_addoptrace=ON is set. (user: drh, tags: column-cache-debug)
2013-12-17
15:03 [6db7052eee] Add the printf() SQL function. (user: drh, tags: printf-sql-function)
2013-12-09
20:42 [32fb1784af] Modify the way some internal file-controls are invoked. In order to support multi-file transactions in the zipvfs extension. (user: dan, tags: zipvfs-multifile-commit)
2013-12-07
20:39 [3a9bec524e] If the SQLITE_ENABLE_CURSOR_HINTS macro is defined, then invoke the sqlite3BtreeCursorHint() interface to provide hints to the storage engine about rows that need not be returned. Hints can be disabled using SQLITE_TESTCTRL_OPTIMIZATIONS with SQLITE_CursorHints (0x2000). Cursor hints are not used by the built-in storage engine of SQLite but might be useful to applications that provide their own storage engine. The current code is work-in-progrss and contains bugs. (user: drh, tags: cursor-hints)
2013-12-06
15:37 [8759a8e4d8] Add code to detect if the database file is moved or deleted out from under SQLite and return an SQLITE_IOERR_NODB. (user: drh, tags: detect-moved-db)
2013-12-03
22:32 [52a44146dd] Add memory subsystem related defines to the compile-time options list. (user: mistachkin, tags: memTests)
2013-11-27
03:01 [0ea9e4722b] Closed-Leaf: Avoid using the GetVersionEx functions if they are considered deprecated. (user: mistachkin, tags: vs2013)
2013-11-25
09:36 [0d42c6b830] Initial work on isolating usage of the Windows header file. (user: mistachkin, tags: winHdr)
02:38 [d0fb7acea7] Performance improvements in sqlite3BtreeMovetoUnpacked(). (user: drh, tags: btree-optimization)
2013-11-24
23:18 [484162b6e5] Closed-Leaf: Better support for UTF-8 paths on Cygwin. (user: mistachkin, tags: cygUtf8)
2013-11-23
22:45 [8191b51212] Closed-Leaf: A much simpler fix is to simply change MEMSYS5 so that it takes any free block of the appropriate size (the first on the list of free blocks) rather than searching for the one with the smallest address. This is also faster than using the min-heap algorithm. Need to research to verify that the allocator still satisfies the Robson proof, however. (user: drh, tags: memsys5-performance)
21:30 [7d2cdfad0e] Closed-Leaf: Use a heap-based primary queue rather than a linked list to store the available free blocks of each size in MEMSYS5, since this provides faster access to the first available block. (user: drh, tags: memsys5-performance)
00:27 [f09f11e94b] Add experimental sqlite3_config option to control the native Win32 heap size. (user: mistachkin, tags: winHeapSize)
2013-11-20
17:25 [7c914e3997] Refactoring the OP_Column opcode for improved performance and maintainability. (user: drh, tags: OP_Column-refactor)
2013-11-16
20:13 [8f479a7275] Enhance the DELETE logic so that it can make use of WHERE_ONEPASS_DESIRED for rowid tables. (user: drh, tags: optimize-delete)
2013-11-15
01:10 [8dc5c76c76] Rework the logic that factors constant expressions out of inner loops, making it both simpler and faster. (user: drh, tags: expr-codegen-enhancement)
2013-11-14
15:35 [d1fbc6ca18] Leaf: An experimental virtual tables for showing the content of internal schema objects. (user: drh, tags: schema2-vtab)
2013-11-13
12:27 [27dd5993d1] Add the ability to use an index even if the left-most columns of the index are unconstrainted, provided that the left-most columns have few distinct values. (user: drh, tags: skip-scan)
2013-11-08
18:13 [c54dc9672b] Enhancements to the Win32 native heap integration. (user: mistachkin, tags: win32heap)
2013-11-07
22:11 [9d870d5f0d] Closed-Leaf: Fix temporary directory separator handling for Cygwin. (user: mistachkin, tags: cygDirSep)
2013-10-30
12:30 [5530cdc485] Leaf: Have the shell ".timer on" command cause the shell to report wall-clock time for each query (as well as user and system CPU time). (user: dan, tags: shell-wall-clock)
2013-10-21
13:15 [a00d2ed49c] Closed-Leaf: Drop the mutex on the multiplexor before entering the xRead VFS call. (user: drh, tags: multiplex-parallel-read)
2013-10-19
23:31 [0248ec5e6e] Experimental changes toward "index only" tables. Add the ability to specify options on CREATE TABLE statements using the WITH clause modeled after PostgreSQL and SQL Server. Only the "omit_rowid" option is currently recognized and that option is currently a no-op. (user: drh, tags: omit-rowid)
2013-10-16
09:49 [2470d1bb08] Closed-Leaf: Fix memory/resource leaks for WinCE and Cygwin. (user: mistachkin, tags: wince-fixes)
2013-10-15
10:43 [a38adeb7ff] Closed-Leaf: Fix harmless macro redefinition warnings in the totype extension. (user: mistachkin, tags: noWarnings)
2013-10-12
19:06 [8c13a7fd73] Closed-Leaf: In "PRAGMA foreign_key_check", treat missing parent tables as empty (instead of as errors). (user: dan, tags: fkc-missing-parent-tables)
09:32 [0c4dd9fff0] Closed-Leaf: Changes to the new initial row of PRAGMA index_list results. (user: mistachkin, tags: indexList)
2013-10-07
16:53 [8e78557a40] Leaf: Try to remember statistics from ANALYZE using LogEst instead of u64. (user: drh, tags: log-stats)
2013-10-05
18:16 [66c4a251d6] Begin an experimental refactoring to estimate the average number of bytes in table and index rows and to use that information in query planner. Begin by renaming WhereCost to LogEst and making that type and its conversion routines available outside of where.c. (user: drh, tags: row-size-est)
2013-10-03
19:21 [d59d97b0a8] Experimental branch allowing different postulated scan rates for each index. (user: drh, tags: index-scan-rate)
2013-09-30
11:42 [6622424a3a] Have fts4 full-text queries consider "docid<?" and similar constraints. (user: dan, tags: fts4-docid-range-constraints)
2013-09-12
16:50 [579a512538] Closed-Leaf: Increase the number of bits available in Expr.flags. Other tweaks aimed at making expression processing more robust. (user: drh, tags: expr-tuning)
2013-09-06
15:23 [036fc37a03] Initial implementation of the unlikely() SQL function used as a hint to the query planner. (user: drh, tags: unlikely-func)
2013-09-02
23:40 [d8daaba7da] Leaf: Add the experimental SQLITE_DEFAULT_INDEX_SHAPE=1 compile-time option that makes a much more pessimistic guess at the effectiveness of unanalyzed indices. (user: drh, tags: index-shape-1)
2013-08-30
21:52 [a411df7251] Add support for Cygwin when handling temporary file names. Improve error codes and diagnostic messages for temporary file name handling on Windows. Rename winConvertUtf8Filename to winConvertFromUtf8Filename. Improve placement and comments for forward function declarations. (user: mistachkin, tags: cygwinTempPath)
2013-08-29
21:26 [3426673e46] Never leave an open file descriptor pointing into the middle of the database file if the file descriptor number is 2 or less. (user: drh, tags: overwrite-avoidance)
13:15 [c3f75941e5] Cherrypick of c1152bdcbb and fix for [9f2eb3abac]: Have the whereShortCut() planner ignore indexes with more than four columns. (user: drh, tags: branch-3.8.0)
2013-08-24
00:59 [032c31593d] Unify the result of PRAGMA mmap_size when mmap support is disabled. (user: mistachkin, tags: mmapDisabled)
2013-08-19
21:15 [af49707211] Add tointeger() and toreal() SQL functions. (user: mistachkin, tags: toTypeFuncs)
2013-08-16
20:42 [cdb181c04f] Add the cache_spill pragma. (user: drh, tags: cache_spill)
2013-08-15
08:06 [c23acba11b] Closed-Leaf: Make it easy to attach a debugger the test fixture process prior to any tests being run. (user: mistachkin, tags: dbgTestFixture)
2013-08-03
20:24 [2beea303a1] Begin adding experimental sqlite_stat4 table. This commit is buggy. (user: dan, tags: sqlite_stat4)
2013-07-31
18:12 [6794b2dcb4] Here begins an experimental branch for exploring the idea of a partial index. This check-in is able to parse a WHERE clause on a CREATE INDEX statement, but does not actually do anythingn with that WHERE clause yet. (user: drh, tags: partial-indices)
2013-07-24
14:54 [de05eb75ec] Another attempt at generalizing the URI parsing so that it works with a wider variety of file URIs and yet remains backwards compatible. (user: drh, tags: uri-enhancement)
2013-07-23
20:54 [74c12dee17] Update the URI filename parser to allow (and ignore) authority names in unix and to pass the authority through to the OS on windows, as this appears to be what web-browsers are doing. (user: drh, tags: uri-enhancement)
2013-07-18
17:12 [71effa59c9] Ensure that all auxiliary data registered by calls to sqlite3_set_auxdata() is destroyed when the VM is halted. Partial fix for [406d3b2ef9]. DRH adds: Stray text accidentally inserted into vdbe.c just prior to the commit breaks the build. (user: dan, tags: typo)
2013-07-10
13:33 [ece960c496] Closed-Leaf: Experimental "PRAGMA query_only=BOOLEAN" statement that is able to turn write capabilities on and off. (user: drh, tags: query_only)
2013-07-04
23:53 [f2ab874782] Closed-Leaf: Modify several extensions to use the new exported function naming. Fix some shared library compilation issues. (user: mistachkin, tags: extRefactor)
2013-06-25
22:01 [f1366bab73] Closed-Leaf: Add a new (experimental) sqlite3_stmt_status() verb that returns the number of VM steps. (user: drh, tags: status-vm-step)
2013-06-21
17:30 [8ff2b8f594] Add the "notindexed" option to fts4. (user: dan, tags: fts4-notindexed)
00:35 [2c2577e69c] Modify the query planner interface so that it always passes in the result set. This is the first step toward adding an optimization that will omit tables from a join that do not contribute to the result. (user: drh, tags: omit-join-table-opt)
2013-06-20
18:53 [c5954c58c0] VSIX tooling changes to support Visual Studio 2013. (user: mistachkin, tags: vsix2013)
2013-06-19
20:13 [d36d7e6833] Add the languageid_bits= option to fts. Still some problems to work out. (user: dan, tags: fts-languageid-bits)
2013-06-13
00:32 [10bba8d082] Add a prototype for an extension that sits in between the SQLite native code virtual table interface and a CLR IDisposable object. (user: drh, tags: disposable-vtable)
2013-06-11
22:41 [6b77d61adb] Add the ability to disable future calls to virtual table methods by invoking sqlite3_create_module() with a NULL sqlite3_module pointer. (user: drh, tags: disable-vtab)
2013-06-10
19:12 [9e8109673c] First attempt to store costs and row counts as a logarithm. (user: drh, tags: nextgen-query-plan-logcost)
2013-06-09
17:21 [db2415fa67] High-speed version of NGQP. Still has some minor problems. (user: drh, tags: nextgen-query-plan-fast)
2013-06-08
19:58 [60fc77bc53] Candidate fix for a memory leak that occurs if a CREATE TABLE statement contains two or more COLLATE clauses on the same column definition. (user: drh, tags: memleak)
2013-05-27
17:19 [048865e8fd] Add the files used to build the amalgamation-autoconf package. (user: dan, tags: autoconf-package)
2013-05-13
18:23 [ea0428f9b6] Candidate fixes for problems revealed by notify2.test. Notify2.test is still failing at this point. (user: dan, tags: shared-cache-fixes)
2013-05-07
17:49 [fc3630cdef] Closed-Leaf: Make sure the ORDER BY collating sequences are compatible with the comparison collations before using the merge algorithm for compound SELECT statements. Candidate fix for ticket [6709574d2a8d8]. (user: drh, tags: tkt-6709574)
2013-05-02
00:15 [ccaf4c3f7e] Begin inserting some experimental code for the next generation query planner. (user: drh, tags: nextgen-query-plan-exp)
2013-05-01
19:49 [28c9e7fdee] Allocate 4 bytes of unused header space for an "Application ID". Add the "PRAGMA application_id" command to set and query this identifier. Add the "magic.txt" file to show how the posix file command might use this application id. (user: drh, tags: application-id)
2013-04-28
01:44 [b347b5d1a0] Initial work on reforming usage of OSTRACE by the Windows VFS. (user: mistachkin, tags: winOsTrace)
2013-04-26
16:09 [9c7523dabf] Closed-Leaf: Avoid using posix_fallocate() in WAL mode, as it is not supported by all file-systems. (user: dan, tags: avoid-fallocate)
2013-04-25
20:34 [f968d43f80] Rebalance FTS expressions after parsing to limit recursion during evaluation. Avoid recursion when deleting FTS expression trees. Enforce a limit on the depth of an expression tree. (user: dan, tags: fts3-expr-rebalance)
2013-04-23
20:10 [860fc393bf] Make "test_regexp.c" into a loadable extension and move it over to ext/misc/regexp.c. Add the "load_static_extension" command for testing purposes. (user: drh, tags: std-ext)
2013-04-18
22:56 [6cfa1d73d7] Experiments in making loadable extensions easier to program. The shared library filename tries various operating-system specific extensions if the bare library name does not work. And the entry point is derived from the filename is the legacy entry point name "sqlite3_extension_init" is not found. (user: drh, tags: loadext)
2013-04-13
19:59 [ad53924dca] Closed-Leaf: Only consider AS names from the result set as candidates for resolving identifiers in the WHERE clause if there are no other matches. In the ORDER BY clause, AS names take priority over any column names. Candidate fix for ticket [2500cdb9be]. (user: drh, tags: tkt-2500cdb9be)
2013-04-11
22:52 [daa168f3da] Closed-Leaf: Expand scope of the SQLITE_DISABLE_MMAP define for the Win32 VFS. (user: mistachkin, tags: winDisableMmap)
19:04 [86f26f9152] Increase the version number to 3.7.16.2 and cherrypick the fix for ticket [7ff3120e4fa54abb55]. This check-in is a release candidate. (user: drh, tags: branch-3.7.16)
00:13 [abedd7cb45] Closed-Leaf: Experimental changes to support a Win32 VSIX package flavor. (user: mistachkin, tags: vsixWin32)
2013-04-10
03:22 [bf6ca21b36] Leaf: Backport the multi-process tester to the last released version. (user: mistachkin, tags: branch-3.7.16)
2013-04-09
19:19 [96f04d99f3] Closed-Leaf: Check in the instrumented code for the mptest test case that appears to show a spontaneously disappearing journal file. (user: dan, tags: missing-journal-file)
2013-04-06
00:19 [c318fafe68] Add a prototype TH3-script-style test harness that starts multiple processes operating on the same database file at the same time. (user: drh, tags: mptest)
2013-03-27
15:04 [488089e615] A fix and test-case for the ORDER BY problem identified by ticket [a179fe7465]. This change causes sorting to occur in some cases where it is not strictly necessary. Further work is needed to avoid those extra sorts. (user: drh, tags: orderby-fix)
2013-03-26
20:32 [e7698cba9b] Change os_unix.c to use either one or two mappings internally. (user: dan, tags: two-mappings)
2013-03-14
18:34 [6f21d9cbf5] Use mmap() to read from the database file in rollback mode. This branch is unix only for now. (user: dan, tags: experimental-mmap)
2013-03-12
20:58 [7232093d6c] Closed-Leaf: Fix typo in sqlite3_close() function documentation reported on the mailing list. (user: mistachkin, tags: docTypo)
18:34 [614a038ad2] A proposed fix for the DESC ORDER BY bug of ticket [4dd95f6943fbd18]. Seems to work, but lots more testing is needed prior to moving to trunk. (user: drh, tags: desc-orderby-fix-1)
2013-03-11
11:49 [938b91e855] Closed-Leaf: Fixes for compiling with SQLITE_OMIT_AUTOVACUUM and/or SQLITE_OMIT_TRIGGER defined. (user: dan, tags: omit-fixes)
01:23 [465fd853d3] Add experimental tointeger() and todouble() SQL functions. (user: mistachkin, tags: toTypeFuncs)
2013-03-08
07:10 [69746ef787] Closed-Leaf: If SQLITE_OMIT_UTF16 is defined, avoid setting the 'enc' field of Schema objects to any value except SQLITE_UTF8. Otherwise, assert() statements may fail or spurious SQLITE_NOMEM errors may be returned at the vdbe level later on. (user: dan, tags: experimental)
2013-03-05
16:54 [4e6e07a60e] Failed merge experimental branch with trunk. (user: dan, tags: ex-robust-open)
15:09 [39247b14a5] Add extended error code SQLITE_READONLY_ROLLBACK. Returned if a read-only connection cannot read the database because doing so would require it to roll back a hot-journal. (user: dan, tags: experimental)
2013-02-26
05:44 [d2e7dfca5a] Closed-Leaf: Prevent Tcl file encoding issues in the tests for the unicode() and char() functions. (user: mistachkin, tags: funcTestEncoding)
2013-02-22
20:16 [c3939d2491] Avoid moving pages more than once in an incremental vacuum operation. (user: dan, tags: incr-vacuum-opt)
19:34 [209b21085b] Closed-Leaf: Two new SQL functions: unicode() and char(). (user: drh, tags: unicode-function)
2013-02-12
09:46 [09dfc0c915] Closed-Leaf: Improve memory allocation error handling on WinCE. (user: mistachkin, tags: wince)
2013-02-09
13:58 [5461104668a] Add extended error codes for constraint errors. (user: drh, tags: constraint-error-codes)
2013-02-07
21:15 [98bf668ab1] Allow an index to be used for sorting even if prior terms of the index are constrained by IN operators. (user: drh, tags: IN-with-ORDERBY)
2013-01-17
03:18 [652233d646] Closed-Leaf: Enhance RTree virtual table creation error messages that involve the getNodeSize() function. (user: mistachkin, tags: rtreeErrMsg)
03:18 [dd473cae5b] Closed-Leaf: Make the 'fs' virtual table module portable to Windows. (user: mistachkin, tags: fsVfsWin)
2013-01-16
17:08 [13171eb5dc] Enhance the query planner to exploit transitivity of join constraints in a multi-way join. (user: drh, tags: transitive-constraints)
2013-01-07
13:26 [0a1207c895] Closed-Leaf: Do not raise an error if an unknown SQL function is found in a CHECK constraint while parsing the schema of an existing database. This version causes a run-time error when processing STAT3 tables. (user: dan, tags: mistake)
2012-12-19
17:10 [bae528f486] Backport to the 3.7.15 branch the fix to the segfault problem of ticket [a7b7803e8d1e869] which involved the use of "AS" named result columns as logical terms of the WHERE clause. Also, change the version number to 3.7.15.1. (user: drh, tags: branch-3.7.15)
15:53 [3d0e00c731] Proposed fix for ticket [a7b7803e8d1e8699cd8a]. (user: drh, tags: tkt-a7b7803e)
02:36 [7344e791b9] Better resolution of table and column names in joins where some of the terms of the FROM clause are parenthesized. (user: drh, tags: name-resolution-fix)
2012-12-17
16:46 [01c980e9bb] Prototype for PRAGMA that checks all foreign key constraints on a table. (user: drh, tags: foreign-key-check)
2012-12-13
16:37 [7280e14cd8] Closed-Leaf: Attempt to further generalize the min/max optimization so that, if an appropriate index exists, it can be used by any aggregate query that contains only a single aggregate of the form max(colname) or min(colname) and does not contain a GROUP BY clause. (user: dan, tags: minmax-opt)
2012-12-06
19:37 [0c31a46801] Closed-Leaf: Apply the same restrictions on constant refactoring to statements within a trigger program as top-level statements. Candidate fix for [ae3c5670b6]. (user: dan, tags: constant-refactoring-in-triggers)
15:15 [cc6e0785df] Add a test case that demonstrates ticket [71e333e7d2e642]. (user: drh, tags: ticket-71e333e7)
00:16 [e1feab9834] Closed-Leaf: Stop using the TCL_LIBS configuration variable when linking with Tcl. Remove superfluous 'rm' command. (user: mistachkin, tags: noTclLibs)
2012-12-04
05:21 [59c233942e] Closed-Leaf: Add a test to ensure that the fix in b0c1ba655d has worked. (user: dan, tags: mistake)
00:23 [41fd9dd290] Closed-Leaf: Improvements to the 'tcl' shell output mode. Escape double quotes, set separator to space when mode is set, and skip separator after final column. (user: mistachkin, tags: tclMode)
2012-11-26
19:50 [cd501bbccf] Add an option to register global hooks used for logging all SQL executed by an application. (user: dan, tags: sqllog)
2012-11-21
02:10 [692ad3c02b] Closed-Leaf: In winDelete, determine that a file does not exist by checking for a last error of ERROR_FILE_NOT_FOUND or ERROR_PATH_NOT_FOUND. (user: mistachkin, tags: winNotFound)
2012-11-13
10:54 [356259617c] When available, use posix_fallocate() rather than ftruncate() to allocate space for mmap()ed -shm files, since posix_fallocate() gives an error if no disk space is available whereas ftruncate() is silent and leaves the system vulnerable to a SIGBUS upon first write to the mmap()ed region. Ticket [5eaa61ea1881040b17449ca043b6f8fd9ca55dc3] (user: drh, tags: tkt-5eaa61ea18)
2012-11-09
17:59 [942556342a] Try to take into account the cost of inner loops when selecting which table of a join to use for the outer loop. (user: drh, tags: inner-loop-cost)
2012-11-02
18:48 [18ae030dad] Proposed fix for ticket [bfbf38e5e9]. (user: drh, tags: ticket-bfbf38e5e9)
2012-10-30
00:29 [7af3acbbd4] Add an optimization that attempts to run a subquery as a coroutine rather than manifesting it into a temporary table. (user: drh, tags: subquery-as-coroutine)
2012-10-26
00:11 [f7c5abe873] Closed-Leaf: Make sure all virtual table cursors have been closed on a prepared statement prior to unlinking the perpared statement from its database connection. (user: drh, tags: deferred-close-order)
2012-10-25
03:07 [49ccae964f] Closed-Leaf: Implementation of the INSTR() SQL function, as found in SQL Server, MySQL, and Oracle. (user: drh, tags: instr)
01:50 [9e6efcf054] 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. (user: drh, tags: ssdsim)
2012-10-20
08:40 [702ebc646b] Modify VSIX build tools in support of an additional package flavor. (user: mistachkin, tags: vsixFlavor)
2012-10-18
09:39 [018e09c703] Fix harmless compiler warnings. (user: mistachkin, tags: warnings)
2012-10-16
23:17 [aa650746b1] Enable optimization of IN operators on constraints to virtual tables. (user: drh, tags: vtab-IN-opt)
21:08 [8b4c3c5e50] Leaf: An optimization that converts "a IN (b)" into "a==b". Seems to work, but needs additional test cases. (user: drh, tags: degenerate_IN)
2012-10-13
19:58 [af5c9ee4a4] 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. (user: dan, tags: zero-byte-backup-fix)
2012-10-07
00:52 [585e2070ee] Closed-Leaf: Manually define the Win32 file-mapping APIs for WAL if SQLITE_WIN32_FILEMAPPING_API is defined. (user: mistachkin, tags: winFileMapping)
2012-10-05
18:35 [ac81ae493f] Backport fixes to shared-cache mode, from the shared-cache-fix branch, to version 3.7.9 (user: drh, tags: branch-3.7.9)
2012-10-04
19:33 [2b370dea70] Shared-cache mode fixes for views and virtual tables. (user: dan, tags: shared-cache-fix)
12:10 [8f4487450b] Yet another refactoring of ORDER BY logic in the query planner. This particular check-in works mostly, but still has a few minor issues. (user: drh, tags: qp-enhancements)
2012-10-03
18:20 [86633e01fe] A branch off of the sessions branch corresponding to release 3.7.14. (user: drh, tags: sessions-3.7.14)
00:25 [6744d9a37f] Further attempts to optimize out unnecessary ORDER BY clauses. (user: drh, tags: qp-enhancements)
2012-10-02
23:26 [9fab9edd0d] Work around an optimization issue with the MSVC compiler for ARM. (user: drh, tags: branch-3.7.14)
2012-10-01
20:12 [8b5f617c2a] Closed-Leaf: Fix several compiler warnings seen with MSVC. (user: mistachkin, tags: msvcWarnings)
2012-09-25
14:29 [1104d42e10] Pass information around between the major routines of the query planner using a single pointer to a structure rather than a long list of parameters. (user: drh, tags: qp-enhancements)
2012-09-18
17:32 [2be661a480] Closed-Leaf: This change generates incorrect code when there are two or more IN operators in the WHERE clause that are both used by the same index. Was: Omit an unnecessary OP_IfNull that immediately follows an OP_Rowid. (user: drh, tags: mistake)
2012-09-15
18:45 [cfaa7bc128] Attempt to use a covering index even on a full table scan, under the theory that the index will be smaller and require less disk I/O and thus be faster. (user: drh, tags: fullscan-covering-index)
2012-09-12
18:45 [8398f77c5a] Closed-Leaf: Add an implementation of the REGEXP operator and function. Only defined if compiled with SQLITE_ENABLE_REGEXP. (user: drh, tags: regexp)
2012-09-10
10:29 [7c3401657a] Initial prototype of SQLITE_CONFIG_READONLY. (user: mistachkin, tags: configReadOnly)
07:56 [b8d5359bb7] Closed-Leaf: More test cleanup. (user: mistachkin, tags: testClean)
2012-09-07
16:46 [22ebc66851] Add an experimental busy_timeout pragma to facilitate access to the sqlite3_busy_timeout() interfaces for programmers that are working from behind a language wrapper that does not expose that interface. (user: drh, tags: busy-timeout-pragma)
2012-09-03
10:32 [e2f27d28b5] Add Win32 version resources to the applicable binaries built by the MSVC makefile. (user: mistachkin, tags: win32Resources)
2012-08-24
10:52 [1dc8c7c741] Experimental change to support the covering index optimization for queries with OR terms in the WHERE clause that search a single index more than once. (user: dan, tags: multi-or-covering-index)
2012-08-23
16:18 [3c3ffa901f] Further improvements to the processing of nested aggregate queries. (user: drh, tags: nested-agg)
2012-08-21
23:33 [600de08d40] Added sqlite3_win32_set_directory API to assist in portability to WinRT. (user: mistachkin, tags: win32SetDir)
13:08 [c2cf498513] Closed-Leaf: Update the spellfix virtual table so that all OOM errors are reported out to the application. ERROR: A single edit was missed in spellfix1 which means that this particular check-in won't build "make test". (user: drh, tags: mistake)
2012-08-16
20:05 [11dd05e598] Attempt to use two cores to do sorting. Unfortunately, instead of making sorts go faster as was hoped, this changes slows sorting down by about 10%. (Later:) The previous measurement was compiled using -pg. When compiled using -Os, this new code is roughly 10% faster than the original. (user: drh, tags: threads-sort-ex1)
2012-08-15
15:57 [2bb8c49261] Leaf: Experimental change to speed up ORDER BY clauses that sort based on a single expression. (user: dan, tags: sorter-exp)
2012-08-07
01:37 [28aed847c6] Leaf: Parser bug fix: Make sure the table constraints allowed by prior releases can still be parsed, even if they are technically not allowed by the syntax diagram. This is a cherry-pick of a1c014d8a87c8940b3, 38bf90af1ede6ee64e, and e536ac041815b118c4. (user: drh, tags: apple-osx-ml)
2012-08-06
23:21 [0620285da6] Closed-Leaf: Backport VSIX packaging support and related changes. (user: mistachkin, tags: vsix-3.7.13)
2012-07-23
19:25 [55e47ef338] Modify the code in vdbesort.c so that most reads and writes to temporary files are aligned page-sized blocks. (user: dan, tags: sorter-coalesce-writes)
2012-07-21
19:40 [0e4d977a4a] Add an internal interface that allows the code to take advantage of multiple cores by pushing subcomputations off into separate threads. The interface is not currently used. (user: drh, tags: threads)
2012-07-17
19:32 [8752237d12] Enhance the custom memory allocation interface to allow the user to specify a calloc() function. (user: dan, tags: calloc)
2012-07-13
19:26 [f24b9d87f6] Add the "matchlen" column to the spellfix1 virtual table. (user: dan, tags: spellfix-matchlen)
2012-07-12
19:43 [4a582c4d30] Add the "matchlen" column to the spellfix virtual table. (user: dan, tags: spellfix-matchlen)
2012-06-19
03:11 [8ecffca900] Improved accuracy on text-to-real and real-to-text conversions. Most conversions now round-trip correctly. Still need to fix some corner cases. (user: drh, tags: floating-point-conversions)
2012-06-18
14:23 [87597e988f] Closed-Leaf: Add the ieee754() SQL function that interprets a blob as a big-endian double. Arrange for the quote() SQL function to emit ieee754() functions in its output so that floating-point values in the database are exactly preserved by a ".dump" command in the shell. (user: drh, tags: ieee754-func)
08:00 [f970a3de61] Fix a few compilation issues that can occur with certain compilers (e.g. GCC 2.95.3, MSVC). (user: mistachkin, tags: compiler-compat)
2012-06-02
14:32 [e276a02b7f] The sqlite3_close() interface returns SQLITE_OK even if there are outstanding sqlite3_stmt and sqlite3_backup objects. The connection becomes a zombie. Resource deallocation is deferred until the last sqlite3_stmt or sqlite3_backup object closes. This is intended to help SQLite play nicer with garbage collectors. (user: drh, tags: deferred-close)
2012-05-28
19:19 [f4e8ff03ea] When converting 64-bit floating point coordinates to 32-bit in RTree, take care to round the values such that the size of the bounding box is enlarged. (user: drh, tags: rtree-32bit-rounding)
2012-05-26
18:06 [4590e433f2] Enable the use of shared cache for an in-memory database, so that separate database connections can share the same in-memory database. (user: drh, tags: shared-cache-memdb)
2012-05-25
17:50 [0c13570ec7] Add an experimental tokenizer to fts4 - "unicode". This tokenizer works in the same way except that it understands unicode "simple case folding" and recognizes all characters not classified as "Letters" or "Numbers" by unicode as token separators. (user: dan, tags: fts4-unicode)
2012-05-21
19:11 [722260969306778029b] Convert the NameContext object from using u8 booleans to using individual bits in a single u8 as its booleans. This change might become a basis for a fix for [c2ad16f997ee9c]. (user: drh, tags: nested-agg)
2012-05-20
20:14 [0c0a03987c] Closed-Leaf: Check-in included unrelated debugging code by mistake. Was: Fix a test case in the shell1.test script so that it works even for very long pathnames. (user: drh, tags: mistake)
2012-05-15
17:15 [46f4eb5430] When a connection disconnects from a shared-cache database, only delete the in-memory schema if there are no other connections. (user: dan, tags: shared-schema)
2012-05-07
13:15 [03875633f4] Do not do the AV retry loop on open if the file that is attempting to be opened is really a directory. (user: drh, tags: win-check-dir)
2012-05-04
02:58 [930115693a] Add an experimental tokenizer to FTS3/4: one that transliterates latin, greek, cyrillic, and hebrew characters into pure ascii. (user: drh, tags: translit-tokenizer)
2012-03-28
18:08 [83037d5844] Closed-Leaf: Do the accounting for incr-merge work in pages instead of blocks. (user: dan, tags: fts4-incr-merge-exp)
15:44 [4d516240d2] Closed-Leaf: This change turned out to the code slower. Side track it. Was: Tweaks to the OP_Column opcode for clarity of presentation. (user: drh, tags: mistake)
01:34 [b899dbeb60] 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. (user: drh, tags: faster-typeof-and-length)
2012-03-27
11:48 [7ed9d2f24a] Closed-Leaf: Allow multiple incremental merges to proceed concurrently. This is required to prevent a large crisis-merge from occuring while an even larger incremental-merge is underway. (user: dan, tags: fts4-incr-merge-exp)
2012-03-24
02:20 [ed69434cd8] An attempt at automatic incremental merging for FTS4. (user: drh, tags: fts4-auto-incr-merge)
2012-03-15
21:28 [254f99ea9f] Closed-Leaf: Add the sqlite3_db_readonly() interface. This is still tentative, pending a closer look at other ideas to accomplish the same thing. (user: drh, tags: db-readonly-api)
2012-03-08
18:39 [741b8f8977] Add the 'merge=?,?' command to fts4. This still needs some work. (user: dan, tags: fts4-incr-merge)
2012-03-07
19:13 [9a0f90d9de] Closed-Leaf: If a CHECK constraint is named, report that name on the error message when the constraint fails. (user: drh, tags: named-check-constraints)
2012-03-01
19:44 [bea257f70f] Add the "languageid=" option to fts4. This code is still largely untested and alsmost certainly buggy. (user: dan, tags: fts4-languageid)
18:16 [c0891296b4] Remove unused #defines from os.h. (user: drh, tags: winrt)
2012-02-22
14:45 [5be07904ba] Begin adding support for SQLITE_FCNTL_PRAGMA. (user: drh, tags: file-control-pragma)
2012-02-13
16:43 [9b66c79e05] Change the ROLLBACK command so that pending statements to not block it. The pending statements instead return SQLITE_ABORT upon next access. Note: This causes separate shared-cache connections in read_uncommitted mode to abort as well. (user: drh, tags: nonblocking-rollback)
13:44 [922bcbb423] Closed-Leaf: Generalize the interrupt mechanism so that individual statements can be interrupted and so that codes other than just SQLITE_INTERRUPT can be returned as a consequence of an interrupt. (user: drh, tags: generalize-interrupt)
2012-02-02
17:35 [adb29232b6] For queries of the form "SELECT p, max(q) FROM t1", the value of column p returned is the one on the same row that holds the maximum value of q. (user: drh, tags: output-minmax-row)
2012-01-03
21:33 [9e5add51ee] Closed-Leaf: Experimental changes to prevent buffer overreads when parsing a corrupt database file. (user: drh, tags: no-overread)
2011-12-17
16:09 [e0d44450b9] Add support for statvfs() in os_unix.c, for determining the sector size. This causes many TCL test failures under Linux. (user: drh, tags: statvfs)
2011-12-16
19:34 [91d0437c07] Proposed changes that ensure that the WAL header is written prior to the first commit mark. (user: drh, tags: wal-header-sync)
13:24 [6492af76ea] Closed-Leaf: Experimental fix for [a1fa75cbdd]. (user: dan, tags: experimental)
2011-12-14
17:53 [cdbfb553af] Closed-Leaf: Add a file-control that will discover the name of the bottom-level VFS and all the shims in between. (user: drh, tags: vfsname-filectrl)
2011-12-13
11:15 [255d21499b] Change the way IO errors are handled in the xFileSize method of the multiplexor VFS. Add test file multiplex3.test. (user: dan, tags: experimental)
2011-12-12
20:01 [c4e2ce4862] Backport a minimal set of changes needed to get 8+3 filenames and the multiplexor shim playing well together. (user: drh, tags: nx-devkit)
2011-12-09
16:21 [521d72bdf6] Make no assumptions about the initial state of VDBE registers. (user: drh, tags: uninit-vdbe-mem)
2011-12-06
19:44 [79ae51c5b1] Begin adding the data-structure explaining subsystem. All is contained within (user: drh, tags: tree-explain)
2011-12-01
18:44 [bd3ce723f1] Add stdio-like I/O interfaces to the test_quota VFS. This is a prototype change for discussion and is mostly untested. This is an alternative to adding stdio-like I/O interfaces in the core. There is no guarantee that this code will make it into the trunk. If it does get to trunk, there could be many changes to the interface first. (user: drh, tags: quota-stdio)
02:32 [8936542b22] Closed-Leaf: Add a prototype implementation of stdio-like routines for accessing the VFS. This is intended as documentation. The code is untested. There is no guarantee that any of this will ever make it into trunk. Substantial revision is possible prior to reaching trunk, if it ever does. (user: drh, tags: vfs-stdio)
2011-11-21
00:54 [7e657bbb80] Closed-Leaf: Cleanup the semantics surrounding use of the GetLastError function on Windows. (user: mistachkin, tags: winGetLastError)
2011-11-16
17:32 [06e0cdaf91] Closed-Leaf: Change the multiplexor suffix from 2 to 3 digits. (user: drh, tags: 3-digit-multiplex-suffix)
2011-11-14
02:53 [54cc119811] Fix a 8-byte alignment problem that causes a SIGBUS on Sparc. (user: drh, tags: branch-3.7.9)
01:55 [09be42d5fa] Begin making experimental changes to use mmap() for reading content from a database. The code compiles, but crashes on the test suite. (user: drh, tags: mmap-experimental)
2011-11-11
22:08 [ed88fb0024] Work in progress to implement the 'syscall' functionality for Windows. (user: mistachkin, tags: winSyscall)
2011-11-08
20:08 [c275c9d323] Experimental change to the pcache interface to allow page buffers to be allocated separately from their associated container structures. (user: dan, tags: experimental-pcache)
15:06 [a499ae3835] Closed-Leaf: Cherrypick the 5dbfaed8c3 patch so that SQLITE_OMIT_WAL works again. (user: drh, tags: omit-wal-fix)
2011-11-01
15:45 [72256634773f] Closed-Leaf: If the read() system call in unix returns fewer bytes than expected, retry it until it either returns zero or an error. (user: drh, tags: retry-short-reads)
2011-10-10
18:59 [aef7945c42] Cherrypick the sqlite_data_count() changes from d4f95b3b6e and 9913996e7b into the apple-osx branch for version 3.7.7. (user: drh, tags: apple-osx-377)
2011-10-07
13:33 [876bd21aaa] Begin an effort to enhance the query planner to do a better job with OR terms in the WHERE clause. This change allows ANDs outside of the OR to be factored into the OR terms if that is helpful in finding better indices. (user: drh, tags: or-opt)
2011-10-04
11:22 [1d27ea741f] Add experimental 'content' option to FTS4. (user: dan, tags: fts4-content)
2011-09-22
03:13 [646db97188] Closed-Leaf: Merge the cache-stats enhancement into trunk. (user: drh, tags: mistake)
2011-09-20
15:53 [892723575c] Closed-Leaf: Add SQLITE_STMTSTATUS_CACHE_HIT/MISS and SQLITE_DB_STATUS_CACHE_HIT/MISS. For querying the number of pager cache hits and misses on a statement or connection basis. (user: dan, tags: cache-stats)
2011-09-15
19:39 [62dfc51a49] Adding test case for ticket [002caede898] (user: drh, tags: tkt-002caede898)
2011-09-01
15:32 [bab2e560f6] Experimental code-generator changes to utilize new opcodes for sorting. (user: drh, tags: merge-sort)
2011-08-27
18:48 [1a24984525] Experimental changes to improve the performance of OP_Next. (user: dan, tags: experimental)
2011-08-26
13:52 [0df04f920b] Merge branches branch-3.7.2 and stat3-enhancement into a new branch for testing purposes. (user: drh, tags: stat3-3.7.2)
13:16 [63f2c7859f] Merge the stat3-enhancement branch with trunk, but keep the resulting merge in a separate branch for now. (user: drh, tags: stat3-trunk)
2011-08-24
16:13 [bf3d0ab538] Experimental work to allow SQLite to use the native Win32 heap API. (user: mistachkin, tags: winNativeHeap)
2011-08-19
18:15 [63597097ee] Experimental change: If SQLITE_PAGECACHE_BLOCKALLOC is defined, instead of allocating pages one at a time, allocate blocks of between 15 and 63 pages in a single allocation. (user: dan, tags: pager-blockalloc)
2011-08-12
01:51 [52e1d7e8dd] Begin a branch that experimentally replaces sqlite_stat2 with a new table called sqlite_stat3 that will hopefully facilitate better query planning decisions. (user: drh, tags: stat3-enhancement)
2011-08-05
21:13 [eb43422827] Add a column to the sqlite_stat2 table that contains the number of entries with exactly the same key as the sample. We do not yet do anything with this extra value. Some tests in analyze2.test are failing. (user: drh, tags: query-planner-tweaks)
2011-08-03
01:07 [c8ba8855d8] Adjust the output row estimating logic when using STAT2. (user: drh, tags: query-planner-tweaks)
2011-08-02
00:57 [9007586fda] Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried. (user: mistachkin, tags: winopen-retry-logic)
2011-07-26
16:03 [e34c553bf0] Prototype change for a new sqlite3_file_control() that will cause the -wal and -shm files to persist after the last database connection closes. (user: drh, tags: persistent-wal-patch)
2011-07-22
21:25 [a6b85c7340] Closed-Leaf: Add retry logic for AV defense to winAccess(). Also allow OS tracing to be enabled by a compile-time option. (user: drh, tags: av-defense)
2011-07-12
14:28 [30dbf0feab] Experimental support for speeding up CREATE INDEX commands using an offline merge sort. (user: dan, tags: experimental)
11:04 [89f1848d7f] Update the anti-virus retry logic for DeleteFile(). Invoke sqlite3_log() for each anti-virus retry. Make the retry delay configurable at compile-time. (user: drh, tags: av-defense)
2011-07-11
15:52 [8daf6e1b42] Closed-Leaf: Here is an attempted enhancement to the query planner that didn't work out. But it seems good to save this change for historical reference, even if it does not belong on the trunk. (user: drh, tags: query-planner-deadend)
2011-06-30
20:17 [f7ba0219ef] Experimental changes to improve optimization of DISTINCT queries. (user: dan, tags: experimental)
2011-06-27
23:32 [ec8f23fc04] Create a branch that contains just the fix for the case_sensitive_like pragma bug, ticket [25ee81271091ec]. (user: drh, tags: branch-3.7.7)
2011-06-23
17:09 [8230d83120] Fix some of the code issues (missing comments etc.) in the new FTS code. (user: dan, tags: fts3-changes)
2011-06-15
08:30 [7a3813138d] Add an interface to better test incremental loading of doclists by FTS4. Also some tests for this and term prefix queries. (user: dan, tags: broken-build)
2011-06-01
11:26 [2e5a912ad7] Leaf: Toward version 3.7.5.1. This check-in updates the version number and also patches the pager so that it never spills cache while in WAL mode. The latter patch fixes ticket [2d1a5c67dfc23] and also prevents excessive WAL file sizes if the pager cache starts thrashing. A few test cases fail. (user: drh, tags: branch-3.7.5)
2011-05-24
18:49 [b5bdc63989] If the fts4 option prefix=1 is specified, have the fts4 module maintain an index of prefixes as well as terms. (user: dan, tags: fts3-prefix-search)
2011-05-13
17:11 [f88dfac383] Closed-Leaf: Rather than document goofy behavior, it seems better to make the behavior less goofy. (Was: Updates to the sqlite3_last_insert_rowid() documentation - to make it clear that the function does not work for virtual tables.) (user: drh, tags: mistake)
2011-05-12
15:32 [97b9801076] Pull in the patches to support read-only WAL databases into a new branch off of the apple-osx branch. This also pulls in all the other pending 3.7.7 changes such as URI support. (user: drh, tags: apple-wal-readonly)
2011-05-10
17:31 [bb59f9862d] Add experimental support for read-only connections to WAL databases. (user: dan, tags: wal-readonly)
14:52 [489c453d4e] Closed-Leaf: Provide the ability to specify an alternative mutex subsystem at compile-time. - This check-in should have gone on the trunk, not on the 3.7.6 branch. (user: drh, tags: mistake)
2011-05-05
19:44 [1586244b6d] Closed-Leaf: Changes to various test scripts so that they pass on windows. (user: dan, tags: win32-test-fixes)
2011-04-25
18:49 [6d2633a6d0] Add support for on conflict clauses to fts3/fts4. (user: dan, tags: vtab-conflict)
2011-04-22
19:37 [b8a8132e71] Add the start of the "uri-filenames" feature. (user: dan, tags: uri)
2011-04-17
17:14 [986f2f25ba] Change the prototype for the open() system call to agree with Posix. Though a faulty function prototype in a pointer cast is a seemingly innocuous error, the correct prototype is necessary for pthreads to work correctly on NetBSD. (user: drh, tags: branch-3.7.6)
2011-04-15
13:29 [1cca9a49f2] Closed-Leaf: Add retry logic to GetFileAttributesEx() on windows. (user: drh, tags: experimental)
2011-04-02
16:28 [6a8ad6e31e] Begin a series of changes designed to reduce the scope and frequency of invalidating schemas. Design goals are that the internal schema should never be deleted out from under a prepared statement that is running and that all prepared statements should be expired if the schema is invalidated. At the same time, minimize the number of schema invalidations. This change merely revises the sqlite3ResetInternalSchema() function to use -1 as the wildcard for "all" rather than 0, so that we can reset the main schema independently of all the others. (user: drh, tags: schema-parse-refactor)
2011-03-31
02:03 [c8f9edd962] 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. (user: drh, tags: analyze-idx)
2011-03-29
15:00 [3b964155f6] Closed-Leaf: 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. (user: drh, tags: unordered-index-hack)
2011-03-26
15:05 [ea3a4ee136] Skeleton code for the word-fuzzer virtual table. (user: drh, tags: word-fuzzer)
2011-03-15
04:45 [cfa4a2f7ea] 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. (user: shaneh, tags: multiplex-enhancements)
2011-03-12
17:02 [00051c3296] 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. (user: drh, tags: unix-excl)
2011-03-02
15:09 [92b5a76abc] Proof-of-concept prototype for the proposed xSetSystemCall extension method on the VFS. (user: drh, tags: syscall-override)
2011-03-01
18:42 [6145d7b89f] Add the experimental sqlite3_preupdate_hook() API. (user: dan, tags: sessions)
2011-02-23
13:53 [e701efbd1d] Closed-Leaf: The robust_flock() fix that accidently included some unrelated, though harmless changes. I should follow my own checklist! (user: drh, tags: mistake)
2011-02-20
03:11 [bcc22c4b80] Backport the SQLITE_PROTOCOL fix and the extra defensive measure to version 3.7.4. (user: drh, tags: branch-3.7.4)
2011-02-12
01:59 [e72cf118cb] This is the beginning of an attempt to backport recent query planner enhancements to version 3.7.2. The code in this version builds and runs and seems to give correct answers, but it generates suboptimal query plans and hence many of the test cases fail. The test script gives up after 1000 errors. (user: drh, tags: branch-3.7.2)
2011-02-01
16:34 [b010ddcc52] Add virtual table module "fts4aux", used to inspect the full-text index of an fts4 table directly. Also add the "compress" and "uncompress" fts4 options. (user: dan, tags: fts4aux)
2011-01-28
17:02 [38ca1daa23] Closed-Leaf: Bogus release candidate. (user: drh, tags: mistake)
2011-01-24
16:00 [8063197ef1] Closed-Leaf: Ensure that if a deferred FK constraint is violated by a statement that creates its own implicit transaction, the statement is not an "active-write" after sqlite3_step() returns. (user: dan, tags: deferred-fk-quirk)
2011-01-20
02:56 [2cd374cd23] The first of a planned series of enhancements to the query planner that enable it to make better use of sqlite_stat2 histograms when the table has many repeated values. (user: drh, tags: stat2-enhancement)
2011-01-17
21:32 [d094a1bfb7] Here is a completely new implementation of the mutex-free-pcache. This one uses a common code base and automatically selects whether or not to use mutexes depending on compile-time and start-time options. (user: drh, tags: mutex-free-pcache)
2011-01-15
17:12 [c1e0d09cd3] Increment the change counter and update the SQLite version number whenever page 1 is added to the WAL. Ticket [5d863f876ee9561b9] (user: drh, tags: bug-5d863f87)
2011-01-14
16:12 [2ea5bd1287] Closed-Leaf: Provide an alternative and experimental pcache implementation that avoids the use of mutexes at the expense of using more memory. (user: drh, tags: mutex-free-pcache)
2011-01-11
01:42 [d1b3c54f42] Closed-Leaf: A proposed change to the sqlite3_step() API such that it will only auto-reset following an SQLITE_BUSY or SQLITE_LOCKED error. Calls after any other result other than SQLITE_ROW will return SQLITE_MISUSE. (user: drh, tags: step-autoreset)
2011-01-05
13:07 [6549e7672b] Leaf: Cherrypick the WAL error logging from the pre-3.7.5 line into a branch for version 3.7.2. Include the sqlite3_vsnprintf() interface. This checkin is intended for debugging and not for release. (user: drh, tags: wal-trace-372)
12:50 [2c2afdd0ad] Add detailed error logging to WAL in an effort to track down an obscure SQLITE_PROTOCOL problem. This code is intended for debugging and not for release. (user: drh, tags: wal-trace-375)
2010-12-20
15:51 [34613f1dc5] Closed-Leaf: Add additional DBSTATUS options for measuring the hit and miss rates against the lookaside memory pool - information useful in tuning the lookaside size. Currently experimental pending analysis of performance impact. (user: drh, tags: experimental)
2010-11-23
19:16 [9cf0f2b76b] Experimental changes to fts3 function matchinfo(). (user: dan, tags: fts3-experimental)
2010-11-19
14:37 [4425b0645d] Add the SQLITE_FCNTL_FILE_POINTER verb to sqlite3_file_control(). (user: drh, tags: superlock)
2010-11-16
18:56 [7e3fc2c833] Add experimental command "PRAGMA wal_blocking_checkpoint", which uses the busy-handler to block until all readers have finished in order to ensure the next writer will be able to wrap around to the start of the log file. (user: dan, tags: blocking-checkpoint)
2010-11-09
00:47 [77b343cfc3] Experimental changes to test defaulting to fullfsync for WAL mode (user: adam, tags: apple-osx-exp)
2010-11-08
19:01 [f4747eb83d] Experimental changes to EXPLAIN QUERY PLAN. (user: dan, tags: experimental)
2010-11-04
20:50 [dd4dc8a426] First attempt at a sharding VFS to split large DBs. (user: shaneh, tags: experimental)
20:46 [cc9d9a12c3] Updates for Windows. (user: shaneh, tags: experimental)
2010-10-27
19:23 [7324c7f2f8] Add tail recursion to the sqlite3ExprDelete() routine in order to keep down stack space usage for really, really large expressions. Later: The tail recursion is dangerous since the recursion might happen after the expression has been freed. (user: drh, tags: mistake)
2010-10-19
14:08 [5ae0ba447a] Experimental changes to fts4 to try to selectively avoid loading very large doclists. (user: dan, tags: experimental)
2010-10-01
15:11 [efda310480] Closed-Leaf: Not true: For a zeroblob, the Mem.z pointer can be null: The Mem.z pointer can never been NULL for a string or blob, even a zero-length string or blob. Assert this fact. (user: drh, tags: mistake)
2010-09-30
00:50 [14eed3a0e0] Rework the text to numeric conversion routines so that they work with either UTF8 or UTF16 and do not require a NULL terminator. This allowed text to numeric conversion without reallocating the string. (user: drh, tags: experimental)
2010-09-27
21:09 [8b8e1732e8] Add assert() statements that fail when a shallow copy is accessed after the original has been modified. These assert() statements should detect the kinds of subtle SCopy bugs such as caused the fault in ticket [b351d95f9cd5ef17e9d9dbae18f]. (user: drh, tags: bug-b351d95f9c)
2010-09-24
09:32 [c1ebcacd9b] Add experimental branch disallowing VACUUM when there are one or more active SQL statements. (user: dan, tags: experimental)
2010-09-01
11:40 [383eb87bbf] Add file test_quota.c, demonstrating how file-system quotas may be implemented as a VFS wrapper. (user: dan, tags: experimental)
2010-08-17
23:13 [220cca50da] Cherrypick the changes for enhancement requests [e090183531fc27474] (use indices on LIKE with no wildcards) and [4711020446da7d93d993] (use nocase index for LIKE even if the column is binary) into the 3.6.23.1 release of the Apple-OSX branch. (user: drh, tags: apple-osx-3623)
2010-08-04
11:59 [dec70c63d0] Backport the 65b8636ac6e5 fix for ticket [51ae9cad317a1] to version 3.7.0. (user: drh, tags: branch-3.7.0)
2010-07-27
18:34 [7cf0e851d4] Add experimental unix-only file-control to grow and truncate the database file by a configurable chunk size. (user: dan, tags: experimental)
2010-07-24
16:34 [ac1f37a647] Make sure all memory from sqlite3DbMalloc() is freed by sqlite3DbFree() and all memory from sqlite3_malloc() is freed by sqlite3_free(). (user: drh, tags: malloc-enhancement)
11:28 [9aa30342f4] Experimental code to measure memory consumed by database schemas and prepared statements. (user: dan, tags: experimental)
2010-07-13
14:33 [52577bb5e7] Add proposed interface change to sqlite.h.in. This commit breaks the build. (user: dan, tags: experimental)
2010-07-08
16:30 [8a5811ea80] Closed-Leaf: Changes to get crashsql() working on Windows. (user: shaneh, tags: experimental)
2010-07-02
17:05 [708338773919f] Fix some warnings when compiling under MSVC. (user: shaneh, tags: mistake)
2010-06-16
19:04 [bede8c8a14] Experimental change: On systems where it is not possible to unlink a file while one or more processes has it open (i.e. not unix), avoid closing the journal file each time the database is unlocked and reopening it at the start of each transaction. (user: dan, tags: experimental)
2010-06-11
19:04 [ca68472db0] Experimental change to the xShmXXX parts of the VFS interface. (user: dan, tags: experimental)
2010-06-09
11:02 [7c102c7b5f] Closed-Leaf: Fix for race condition in WAL locking code. (user: dan, tags: mistake)
2010-05-30
19:55 [ef3ba7a17f] Initial code for incremental checkpoint in WAL mode. This check-in compiles on unix and runs as long as you do not engage WAL mode. WAL mode crashes and burns. Consider this check-in a baseline implementation for getting the new capability up and running. (user: drh, tags: wal-incr-ckpt)
2010-05-18
12:37 [97d88a86e4] Closed-Leaf: Keep additional state information in the pager in an effort to reduce the number of SQLITE_FCNTL_SIZE_HINTs. (Note: This change was found to make no performance difference and so has been moved onto a side branch. Use the parent check-in instead of this one.) (user: drh, tags: branch-3.6.1-exp)
2010-05-12
19:02 [ee13c8849d] (Moved to the mistake branch due to compile errors in test_osinst.c.) Change the vfs instrumentation code in test_osinst.c to make it easier to deploy. Add a vtab implementation for reading the binary log file format. (user: dan, tags: mistake)
18:01 [2b00152c1a] Refactoring the VFS-SHM methods used by WAL. This version compiles and runs non-WAL test cases but crashes and burns on wal.test. (user: drh, tags: wal-refactor)
2010-05-11
02:49 [111ad59f21] Initial port of WAL VFS support from os_unix.c to os_win.c. (user: shaneh, tags: wal-win32)
2010-04-16
22:05 [c54e8dad01] Changes for branch coverage of notify.c. Fixed quirk of unlock_notify() where it would still think it was blocked after a callback was cleared (even after the transaction on the blocking connection was closed). (user: shaneh, tags: experimental)
2010-04-12
19:00 [409d61baeb] Import experimental write-ahead-logging code. (user: dan, tags: wal)
2010-04-06
15:57 [1b2a04125f] Automatically generate transient indices for tables in joins that would otherwise have to use a full table scan. (user: drh, tags: experimental)
2010-03-27
17:12 [b844ac6fcb] Experimental changes that cause SQLite to use bytes 28..31 of the database header to determine the database size, rather than using the actual database size. This allows database space to be preallocated. (user: drh, tags: experimental)
2010-03-26
17:37 [ca0bc2a22e] After any rollback that modifies the database file, sync the database before deleting the rollback journal. This is a cherry-pick merge of check-ins b21b911f23 and f2326dad4e (user: drh, tags: branch-3.6.23)
2010-03-04
22:36 [1a0fa8d19d] Closed-Leaf: Second thoughts: Let Tiger users set SQLITE_ENABLE_LOCKING_STYLE=0. Was: Change SQLITE_ENABLE_LOCKING_STYLE to default off, even on Macs, since older Macs (Tiger) cannot compile the latest proxy locking sources. (user: drh, tags: mistake)
2010-03-03
08:12 [587109c81a] Silence a compiler warning by using a constant value instead of a constant expression that some compilers mistakenly believe causes bitshift overflow. (user: dan, tags: mistake)
2010-02-26
22:05 [5c0afe70a5] fix merge error and compiler warning (user: adam, tags: apple-osx)
20:54 [62dfb44b3b] More double free paranoia (user: adam, tags: apple-osx)
2010-02-25
01:47 [9588259882541e] Start a new branch for release 3.6.22 plus limited enhancements and fixes. This first check-in includes the performance enhancements of check-ins 26cb1df735, 61a2c8d4d6, and 27dc5b1c52 (user: drh, tags: branch-3.6.22)
2010-02-23
04:19 [84c9756993] Test new api to report which options (defines) were used to compile SQLite. (user: shaneh, tags: compile_opts)
2010-02-14
00:48 [e6cbe1e5ee] Added -T option, to specify a template filename on the command line.    The default is still "lempar.c", though. (user: icculus, tags: lemon-update-2010)
2010-02-12
22:43 [f3676b243d] Closed-Leaf: Added experimental mutex implementation using interlocked ops and spin locks. (user: shaneh, tags: experimental)
2010-02-01
15:47 [784b718ec3] Create new branch named "wal" (user: dan, tags: wal)
2010-01-29
21:23 [ea3b941a71] Fix a missing mutex on page cache truncation during vacuum and auto-vacuum when SQLITE_ENABLE_MEMORY_MANAGEMENT is engaged. (user: drh, tags: branch-3.5.9)
19:46 [5ed168c48e] Changes to 3.5.9 proposed by Rob Stoddard. (user: drh, tags: branch-3.5.9)
2010-01-19
23:50 [a7a0c8d644] robustness fixes for preventing a finalized statement from being reused (user: adam, tags: apple-osx)
2010-01-05
18:06 [9f819ea6b2] Apply fix 097737e368 to the 3.6.1 branch. (user: dan, tags: branch-3.6.1)
2009-12-16
23:28 [867347323b] Leaf: Fix for the "(x AND y) OR z" bug backported to version 3.6.21. (user: drh, tags: branch-3.6.21)
2009-11-24
19:02 [7d30880114] Closed-Leaf: Recomputed unchanged column values in an UPDATE statement after running BEFORE triggers, in case the triggers have modified any of those values. (user: drh, tags: experimental)
2009-11-13
17:36 [30a92f1132] Start reworking fts3 code to match the rest of SQLite (code conventions, malloc-failure handling etc.). (user: dan, tags: fts3-refactor)
2009-11-06
03:22 [6bf4333804] Add some very basic tests for the commands available from the CLI. (user: shaneh, tags: trunk)
2009-11-05
02:34 [90e63b7d84] Initial implementation of a virtual table for CSV files. (user: shaneh, tags: csv_ext)
2009-11-04
21:49 [6f3081a8e5] Do not accept a codec no an in-memory database. (user: drh, tags: shunning-error)
18:51 [590d4ac1ee] Fix documentation typos. (user: drh, tags: shunning-error)
2009-11-03
22:34 [941a01eb86] Customizations for OSX contributed by Apple. (user: adam, tags: apple-osx)
2009-10-29
18:38 [65a1f1334d] Fix a 16-bit integer overflow that might occur in statements that use both an EXISTS clause and IN operator with a RHS holding in excess of 32K entries. (user: drh, tags: branch_3_6_16)
2009-10-15
18:35 [9bd6f3d886] Add the experimental sqlite3_reoptimize() API. (user: dan, tags: experimental)
2009-09-03
19:43 [715cecb8c7] Leaf: Fix a VDBE stack overflow issue with the UPDATE statement. (user: drh, tags: branch-3.3.6)
2009-05-18
16:12 [f06cae3b5e] Update the version number for the 3.6.14.1 branch. (CVS 6651) (user: drh, tags: branch_3_6_14)
2008-11-22
14:07 [15d88edf76] Port the corruption bug fix of check-in (5938) into a branch off of version 3.6.6. (CVS 5947) (user: drh, tags: branch_3_6_6)
2007-08-14
13:20 [f0029da32f] Leaf: Back-port critical soft heap limit fixes to version 3.3.17. The following check-ins were back-ported: (4031), (4037), (4097), (4202), (4203), (4207), (4208), (4214). (CVS 4222) (user: drh, tags: branch_3_3_17)
2007-05-10
21:31 [e91012b603] Leaf: Backport the stack-size reduction patch in (3673) to version 3.3.13. (CVS 3979) (user: drh, tags: branch_3_3_13)
2005-12-19
16:29 [33397742282425351157a] Backport the fix for ticket #1567 into the 3.2 branch. (CVS 2829) (user: drh, tags: branch_3_2)
2004-04-23
23:37 [635f674d20] Add some extra debugging logic to lemon.c. Ticket #692. (CVS 1304) (user: drh, tags: version_2)
2000-05-29
14:16 [704b122e53] initial empty check-in (user: drh, tags: trunk)