SQLite
Timeline
Not logged in

200 most recent timeline items related to "trunk"

2016-07-01
20:12
[228a7879] Leaf: Fix the transitive constraint logic error that can result in a null pointer dereference. Fix for ticket [e8d439c77685eca6]. (user: drh, tags: trunk)
19:48
[c952af89] Closed-Leaf: Add test cases to the transitive constraint fix. (user: drh, tags: planner-fix)
12:39
[92e7df0f] Leaf: Add the sqlite3rbu_state() API. Used to determine the current state (creating OAL, ready to move OAL, incremental-checkpoint, finished or error) of an RBU operation. (user: dan, tags: rbu-state-api)
2016-06-29
05:00
[233b3338] Add a prototype intarray($PTR,$N) table valued function. (user: drh, tags: prototype-int-array)
2016-06-28
22:27
[a33d2356] Proposed fix for a problem in the query planner. (user: drh, tags: planner-fix)
2016-06-26
04:06
[f8105085] Prevent the WhereLoop.rSetup cost estimate from going negative on complex queries. (user: drh, tags: trunk)
2016-06-25
11:43
[507014e4] Fix the handling of OP_Eq opcodes that compare a register against itself and that require an affinity change. (user: drh, tags: trunk)
2016-06-24
06:23
[77e4f7a3] Fix the ctime.test script so that it works with clang. (user: drh, tags: trunk)
02:50
[67c39e16] Fix the Makefile.in to avoid unnecessary recompiles of sqlite3.c. (user: drh, tags: trunk)
02:21
[a2778ae4] Leaf: Provide for a separate default page size for TEMP and transient database files and initialize that separate default page size to 1024 instead of 4096. (user: drh, tags: temp-page-size)
2016-06-23
16:48
[b8671e94] Update the sqldiff utility so that if the --vtab switch is specified "rtree", "fts3", "fts4" and "fts5" tables are diff'd directly and the underlying real database tables ignored. Without this switch, all virtual tables are ignored and the diff is performed on the underlying real tables. (user: dan, tags: trunk)
12:35
[91113142] Fix the build for -DSQLITE_OMIT_VIRTUALTABLE (user: drh, tags: trunk)
2016-06-21
10:34
[5d0a9d4c] Closed-Leaf: Update the sqldiff utility so that if the --vtab switch is specified "rtree", "fts3", "fts4" and "fts5" tables are diff'd directly and the underlying real database tables ignored. Without this switch, all virtual tables are ignored and the diff is performed on the underlying real tables. (user: dan, tags: sqldiff-vtab-support)
2016-06-20
17:25
[913e5956] For a table on the rhs of a LEFT JOIN operator, do not include terms like "IS NULL" from the WHERE clause in the cursor-hint. These may be false for rows that the cursor would otherwise visit, but true for a row of all NULL values generated by the LEFT JOIN. (user: dan, tags: trunk)
17:22
[7455d932] Closed-Leaf: Allow LIKE operators that appear in a WHERE clause to be included in the cursor-hint for a cursor on the rhs of a LEFT JOIN. (user: dan, tags: cursor-hints)
2016-06-17
14:33
[2a2346b0] If a table is on the rhs of a LEFT JOIN, include only terms from the joins ON(...) clause in the cursor-hint passed via OP_CursorHint. (user: dan, tags: cursor-hints)
13:01
[2c3714ae] Leaf: Add the json_quote() function to the JSON1 extension. (user: drh, tags: json_quote)
2016-06-16
17:14
[0b1579ca] Add a missing OP_ColumnsUsed opcode to code for expressions like "? IN (SELECT ...)" in cases where expression can use an index that may contain NULL values. (user: dan, tags: trunk)
11:16
[48b555c4] Fix a typo in a comment on the SrcList object. (user: drh, tags: trunk)
2016-06-15
10:21
[0f707d15] Leaf: Merge changes from trunk. (user: drh, tags: apple-osx)
2016-06-13
19:58
[0230ca17] Fix RBU so that it builds with -DSQLITE_ENABLE_8_3_NAMES. Fix "PRAGMA compile_options" for SQLITE_ENABLE_8_3_NAMES such that it reports the numeric setting: "1" or "2". (user: drh, tags: trunk)
15:59
[a1e1cdc5] Fix the declaration of the table implemented by DBSTAT so that it uses correct datatypes. (user: drh, tags: trunk)
12:51
[fcf6114b] Fix an incorrect assert() in the btree logic. (user: drh, tags: trunk)
12:34
[d362ba15] Fix the "onecolumn" and "exists" methods of the TCL interface so that they work in combination with the "profile" callback. (user: drh, tags: trunk)
2016-06-10
22:49
[53a1e5d5] Enhance "PRAGMA table_info" to that it provides information about eponymous virtual tables. (user: drh, tags: trunk)
2016-06-08
18:07
[fe187432] Prefer to use partial indexes for full table scans when that is possible. (user: drh, tags: trunk)
14:04
[f48a4ad3] Add the "dbhash.exe" utility program that computes a SHA1 hash over the invariant content of an SQLite database file. Free space in the file, the page size, auto_vacuum status, text encoding, and so forth do not change the hash. Only the content matters. (user: drh, tags: trunk)
13:59
[fb276815] Closed-Leaf: Fix an undersized buffer in the SHA1 implementation. (user: drh, tags: dbhash)
01:03
[2247649c] An initial attempt at a "dbhash" command-line utility. (user: drh, tags: dbhash)
2016-06-07
20:25
[2091a4c9] Fix the walcrash4.test test module so that it works on windows. (user: drh, tags: trunk)
2016-06-06
20:36
[e404ad70] In winFullPathname, translate '/X:' to 'X:' before doing anything else. (user: mistachkin, tags: trunk)
20:27
[f8470ffc] Translate filenames of the form "/c:/*" into just "c:/*" on WinRT and Cygwin. (SQLite has long done this for Win32/WinNT.) (user: drh, tags: trunk)
18:17
[3665a2f5] Fix lempar.c so that the shift-reduce optimization works for error processing. This is a Lemon issue only and has no impact on SQLite. (user: drh, tags: trunk)
13:24
[45531654] Initialize the yyerrcnt variable in the lemon parser template. This has no effect on SQLite itself. (user: drh, tags: trunk)
01:54
[e106a77d] Small performance boost and size decrease in sqlite3BtreeMovetoUnpacked(). (user: drh, tags: trunk)
01:48
[5fb0c354] Small performance improvement in the LIKE function. (user: drh, tags: trunk)
01:14
[2d831074] Btree interface refactoring: (1) The sqlite3BtreeKeySize() interface is renamed to sqlite3BtreeIntegerKey() and modified to work only for table btrees with a rowid. (2) The sqlite3BtreeDataSize() interface is renamed to sqlite3BtreePayloadSize() and modified to work with any btree. (3) The sqlite3BtreeDataFetch() and sqlite3BtreeKeyFetch() routines are combined into a single sqlite3BtreePayloadFetch() routine. The result of these changes is a smaller binary and fewer CPU cycles needed to run queries. (user: drh, tags: trunk)
2016-06-04
21:05
[5e269c2d] Closed-Leaf: Improved comment on cursorOwnsBtShared(). No changes to code. (user: drh, tags: btree-refactor)
20:37
[bef35e18] Change the sqlite3BtreeKeySize() interface into sqlite3BtreeIntegerKey() and make it only work for table btrees. Change sqlite3BtreeDataSize() into sqlite3BtreePayloadSize() and make it work for all btrees. Combine sqlite3BtreeDataFetch() and sqlite3BtreeKeyFetch() into a single sqlite3BtreePayloadFetch() routine. These changes seem to make the b-tree interface more rational and they reduce both binary size and CPU usage. (user: drh, tags: btree-refactor)
17:12
[b411107a] Allocate KeyInfo objects from lookaside if possible. (user: drh, tags: trunk)
16:33
[9583c0fb] Fix up speedtest1.c so that it will compile and run on SQLite versions prior to 3.6.18 (circa 2009-09-11). (user: drh, tags: trunk)
13:57
[313e990c] Remove an unreachable branch in the UNIQUE constraint parsing. (user: drh, tags: trunk)
2016-06-03
18:59
[fa3a89fc] The OR optimization is usable on virtual tables with LIKE, REGEXP and/or GLOB terms in the WHERE clause. (user: drh, tags: trunk)
18:44
[aa7e9d0c] Add support for virtual tables using a WITHOUT ROWID schema. This merge also includes enhancements to the CSV extension, which is used for testing of the new WITHOUT ROWID virtual table mechanism. (user: drh, tags: trunk)
18:21
[31b83a7d] Closed-Leaf: Fix a memory leak when a WITHOUT ROWID eponymous virtual table is used. (user: drh, tags: without-rowid-vtab)
13:35
[5908aa4d] Enhance the sqlite3_load_extension() interface to permit extensions to return SQLITE_OK_LOAD_PERMANENTLY which will prevents unloading when the database connection closes. (user: drh, tags: trunk)
2016-06-01
10:37
[3bd85fa5] Fix an issue preventing RBU vacuum from working with virtual tables. (user: dan, tags: trunk)
05:02
[f6e95652] Fix compilation issues with the VFS stat extension. (user: mistachkin, tags: trunk)
2016-05-31
21:18
[49638f18] An experimental branch with code that allows virtual tables to be declared as WITHOUT ROWID tables. This might be useful for virtual tables that model external data sources that do not have a convenient way of computing a unique rowid. The current check-in almost works, but there are still serious issues. (user: drh, tags: without-rowid-vtab)
18:44
[28ebeadd] Add the columns=N parameter to the CSV extension. (user: drh, tags: trunk)
18:08
[b93fb2fe] Add the testflags parameter to the csv extension. (user: drh, tags: trunk)
16:22
[00d3570c] Add the "csv" virtual table for reading CSV files, as an extension in the ext/misc/ subfolder. (user: drh, tags: trunk)
2016-05-30
08:28
[64ca1a83] Fix an FTS5 problem (segfault or incorrect query results) with "... MATCH 'x OR y' ORDER BY rank" queries when either token 'x' or 'y' is completely absent from the dataset. (user: dan, tags: trunk)
2016-05-28
18:53
[242507b4] Closed-Leaf: Experimental change to allow virtual tables to take advantage of LIKE, REGEXP and GLOB terms that are part of OR expressions within WHERE clauses. (user: dan, tags: vtab-experimental)
17:45
[24f258c2] Remove an unnecessary malloc from the vfsstat extension. (user: drh, tags: trunk)
17:23
[d3f99a5e] Closed-Leaf: Enhance the sqlite3_load_extension() interface to permit extensions to return SQLITE_OK_LOAD_PERMANENTLY which will prevent the extensions from unloading when the database connection closes. (user: drh, tags: load-permanently)
15:22
[6a0f2009] Enhance "PRAGMA compile_options" so that it shows the version of the compiler used to generate the executable, for common compilers. (user: drh, tags: trunk)
15:09
[cbf72b04] Update the amalgamation-tarball configure script so that it can use header file "readline/readline.h" with library file "libedit". (user: dan, tags: trunk)
15:03
[3a461043] Closed-Leaf: Enhance the sqlite3_load_extension() API so that the first parameter (the "db" parameter) can be NULL. An extension that is not associated with any database connection remains loaded for the life of the process. (user: drh, tags: persistent-extensions)
14:53
[0987487d] Add the vfsstat.c loadable extension - a VFS shim that measures the amount of I/O, and an eponymous virtual table that is used to extract and view the measurements. (user: drh, tags: trunk)
00:13
[3f710bc3] Closed-Leaf: Clang can define _MSC_VER in some circumstances; therefore, check for Clang first. (user: mistachkin, tags: ctimeCompiler)
2016-05-27
18:09
[d734e2df] Add basic compiler information to the results of 'PRAGMA compile_options'. (user: mistachkin, tags: ctimeCompiler)
12:30
[71087c12] Improvements to WHERE-clause debug tracing. Show TK_MATCH expressions and show more details on WhereTerm traces. (user: drh, tags: trunk)
04:10
[a9be4c2d] Fix Lemon so that it actually works with -DYYSTACKDEPTH=0. (user: drh, tags: trunk)
01:07
[28d439f8] Fix the Lemon-generated parser so that it compiles with -DYYSTACKDEPTH=0. It does compile now, but there are subtle issues still. (user: drh, tags: trunk)
2016-05-26
20:56
[ffe80a1b] Add a new OP_SeekRowid opcode, that combines the functions of OP_MustBeInt and OP_NotExists. This makes the code slightly smaller and faster. (user: drh, tags: trunk)
2016-05-25
18:53
[2a41f098] Add the libvers.c tool in the tool/ subdirectory. (user: drh, tags: trunk)
2016-05-24
18:55
[41fd46e2] Enhance Lemon and the parser template so that it can once again build parsers that have no unreachable branches. (user: drh, tags: trunk)
18:50
[61e239bc] Minor change to the walcrash4.test module so that it works when SQLITE_DEFAULT_WAL_SYNCHRONOUS is set to something other than 2. (user: drh, tags: trunk)
16:20
[37de3eab] Fix an obscure problem with transactions written in "PRAGMA synchronous=full" mode on systems that do not support POWERSAFE_OVERWRITE causing an xSync() call to be omitted if the last frame written by a transaction is aligned to a sector boundary. This means that if a power failure or OS crash occurs very soon after such a transaction is committed, it may be lost following system recovery. (user: dan, tags: trunk)
00:40
[3b28b68e] Improvements to the initialization of the push-down automoton for the Lemon-generated parser. Smaller and faster. (user: drh, tags: trunk)
2016-05-23
21:56
[3c2a7705] Use a pointer to the top of the stack rather than an index into the stack in the Lemon-generated parser template, for about 6.6% parser performance gain. (user: drh, tags: trunk)
19:02
[276e92f5] Avoid a minor error message when running RTREE without an sqlite_stat1 table. (user: drh, tags: trunk)
18:27
[9589e937] Closed-Leaf: Fix the rtreeG.test test case. (user: drh, tags: tree-stat1-fix)
18:06
[bfbb6dd8] Remove an extra "finish_test" from the end of rtreeC.test. (user: drh, tags: tree-stat1-fix)
16:16
[3ad2531e] Improve the error messages generated by the rtree module when a constraint fails. (user: dan, tags: trunk)
16:15
[a86e782a] Lemon enhancement: avoid unnecessary reduce actions that convert one non-terminal into another but have no side effects. (user: drh, tags: trunk)
14:24
[b91a5b82] Fix comment typos and improve clarity of presention in Lemon. The output should be identical. (user: drh, tags: trunk)
02:57
[815cc2bb] Merge changes from trunk. (user: drh, tags: apple-osx)
00:10
[90411a28] Update the configure script with additional hints on the location of tclConfig.sh, hints needed by the latest versions of Xcode. (user: drh, tags: trunk)
2016-05-21
23:25
[dec13075] More tweaks to improve the performance of the insert logic, slightly. (user: drh, tags: trunk)
20:03
[55f348cd] Simplify the sqlite3BtreeInsert() interface by gathering the five arguments describing the content to be inserted into the new BtreePayload structure, and thus reducing the number of parameters from eight to four. (user: drh, tags: trunk)
19:10
[2ce11667] Remove some unused legacy code from the btree insert logic. (user: drh, tags: trunk)
12:29
[1dbaf7a1] Yet another minor size reduction and performance increase in the b-tree insert logic. (user: drh, tags: trunk)
11:23
[656aa1ec] Small size reduction and performance increase in the sqlite3BtreeInsert() logic. (user: drh, tags: trunk)
00:45
[8e366f18] Add the shell-script used for routine performance testing. (user: drh, tags: trunk)
2016-05-20
23:51
[96cf821b] Add a simple TCL script for summing cachegrind information for each VDBE opcdoe. (user: drh, tags: trunk)
21:40
[1765672c] Another optimization on the OP_Column opcode. (user: drh, tags: trunk)
20:58
[9db8f214] Fix typo in comment. (user: mistachkin, tags: trunk)
19:51
[5c157474] Slight performance improvement in the OP_Column opcode. (user: drh, tags: trunk)
18:09
[f250166b] Remove the sqlite3PagerClearCache() routine, which does not accomplish anything useful. (user: drh, tags: trunk)
15:53
[4dc56e86] Performance optimization and size reduction on the freeP4() routine. (user: drh, tags: trunk)
15:24
[1a0d0576] Increase the version number to 3.14.0 since we are already making significant code changes. (user: drh, tags: trunk)
15:15
[3d55d24d] Use sqlite3VdbeAddOp0() to code OP_Expire, to save a few bytes. (user: drh, tags: trunk)
14:54
[9033afbb] Optimizations to link list merge sort code in vdbesort.c, pcache.c, and rowset.c. Resulting binaries are 10 bytes smaller and use 0.03% fewer CPU cycles. (user: drh, tags: trunk)
14:11
[559733b0] For queries with both ORDER BY and LIMIT, if the rows of the inner loop are emitted in ORDER BY order and the LIMIT has been reached, then optimize by exiting the inner loop and continuing with the next cycle of the first outer loop. (user: drh, tags: trunk)
13:44
[ed1b30dc] Closed-Leaf: Set the NULLEQ flag on the sequence counter comparison in the ORDER BY LIMIT optimization, to avoid coverage complaints about not testing the NULL case. (user: drh, tags: orderby-limit)
12:22
[645bd696] Autoconf configure.ac adjustment to try to get it to look for both editline and readline automatically. (user: drh, tags: trunk)
2016-05-19
22:13
[852d1eda] In a query with both ORDER BY and LIMIT, if the inner loop satisfies the ORDER BY then try to cut short each invocation of the inner loop once the LIMIT has been satisfied. This check-in is a partial implementation only. (user: drh, tags: orderby-limit)
19:31
[58b516e8] Fixup comments on wctrlFlags value definitions. (user: drh, tags: trunk)
18:56
[d0130584] Clean up the WHERE_* macros used for the wctrlFlags parameter on the sqlite3WhereBegin() interface, freeing up some bits to be used for other things. (user: drh, tags: trunk)
17:51
[cf273741] Optimization marks in vdbe.c. No logic changes. (user: drh, tags: trunk)
16:58
[4737cadc] Performance improvement in the OP_Column opcode. (user: drh, tags: trunk)
16:21
[1f577e1f] Add test cases to test some fts3/4 edge case behaviour surrounding the '*' character. (user: dan, tags: trunk)
11:12
[0d773061] Small size reduction and performance improvement in the OP_Column opcode. (user: drh, tags: trunk)
2016-05-18
21:03
[c981ab2a] Add the "scrub" utility program that simultaneously backs-up a live database and erases all deleted content. (user: drh, tags: trunk)
21:01
[915416d1] Omit the unnecessary WHERE_REOPEN_IDX flag in the WHERE interface. (user: drh, tags: trunk)
20:53
[e2e9b985] Merge the 3.13.0 release changes. (user: drh, tags: apple-osx)
10:57
[fc49f556] Version 3.13.0 (user: drh, tags: trunk, release, version-3.13.0)
2016-05-17
21:17
[ab1c5ce5] Closed-Leaf: Enhance the scrub utility program so that it does a FULL checkpoint prior to starting the backup, to ensure that the database file content matches what needs to be backed up without having to look at the WAL file. (user: drh, tags: scrub-backup)
17:11
[5021dfe1] Merge the latest changes from trunk. (user: drh, tags: scrub-backup)
2016-05-16
14:35
[995c084b] Do not run snapshot_fault.test as part of the inmemory_journal permutation. (user: dan, tags: trunk)
13:37
[0d9b82af] Merge recent fixes from trunk. (user: drh, tags: apple-osx)
11:55
[386bcbba] Disable shell.exe test cases for UTF8 filenames as they do not work on MinGW. (user: drh, tags: trunk)
2016-05-13
17:22
[b369980f] Improvements to a comment in the pcache.c file. No changes to code. (user: drh, tags: trunk)
15:22
[771c5411] Remove the unused PGHDR_NEED_READ flag. Add invariant checking (during SQLITE_DEBUG builds only) for the PgHdr object. (user: drh, tags: trunk)
12:12
[3401d9dc] Clarification of the pagerFlushOnCommit() logic. (user: drh, tags: trunk)
11:50
[9495d338] Fix pager_end_transaction() to ensure that a ROLLBACK does not clobber unwritten pages in a TEMP file pcache. (user: drh, tags: trunk)
04:24
[32a62e3b] Additional debugging and tracing logic for pcache.c, turned off by default using an "#if 0". (user: drh, tags: trunk)
2016-05-12
19:17
[24d9fbc1] Disable ALWAYS and NEVER when compiled with SQLITE_MUTATION_TEST. (user: drh, tags: trunk)
19:05
[1b0f4cc3] Simplification of the sqlite3FaultSim() call inside of sqlite3PagerCommitPhaseOne(). (user: drh, tags: trunk)
18:38
[3fd71092] Add an assert in pager.c to confirm that pPager->tempFile is always true for in-memory databases. (user: drh, tags: trunk)
17:06
[9d55b8f5] Add extra OPTIMIZATION-IF-FALSE comments where required to pcache.c. (user: dan, tags: trunk)
12:08
[06c1e27c] For in-memory databases, it does not matter if pcache entries are marked "clean" or "writable". (user: drh, tags: trunk)
12:01
[0dc50d99] Remove an unnecessary call to sqlite3PcacheMakeClean() inside of the ROLLBACK logic. (user: drh, tags: trunk)
09:48
[bc202e5b] Add a missing OPTIMIZATION-IF-FALSE comment to pcache.c. (user: dan, tags: trunk)
2016-05-11
23:54
[ad601c79] Closed-Leaf: For in-memory databases, it does not matter if pcache entries are marked "clean" or "writable". (user: drh, tags: pager-dev)
20:03
[3bfd2621] Remove a redundant condition from pcache.c. Add an OPTIMIZATION-IF-TRUE comment to another condition that requires it. (user: dan, tags: trunk)
18:20
[4533ed35] Closed-Leaf: Remove a redundant condition from pcache.c. Add an OPTIMIZATION-IF-TRUE comment to another condition that requires it. (user: dan, tags: mistake)
15:41
[9cc8cad7] Remove some a small amount of redundant code related to PCache.pSynced from pcache.c. (user: dan, tags: trunk)
12:47
[345ce1c9] Do not reset the page cache when a rollback journal truncate fails, as doing so can cause loss of information for an in-memory TEMP file. (user: drh, tags: trunk)
11:04
[42fb6f1e] Always truncate, rather than persist, the rollback journal of a TEMP database. (user: drh, tags: trunk)
10:57
[d9313d19] Add pcache tracing macros. Off by default. Requires changing an "#if 0" and recompiling to enable. (user: drh, tags: trunk)
2016-05-10
20:16
[22364024] Add another test case to temptable3.test. (user: dan, tags: trunk)
20:03
[20cf8811] Fix a problem in sqlite3PagerMovepage() when working on a temp table for which pages have been spilled. (user: drh, tags: trunk)
2016-05-09
23:11
[79ecd0ef] Fixes to requirements marks. No changes to code. (user: drh, tags: trunk)
22:35
[8a39c8ee] Enhancements to test/sort5.test so that it works with SEE. (user: drh, tags: trunk)
22:32
[f5875489] Remove some forgotten debugging lines from test/sort5.test. (user: drh, tags: trunk)
19:58
[da94a6e0] Closed-Leaf: Omit the unnecessary WHERE_REOPEN_IDX flag in the WHERE interface. (user: drh, tags: dev)
19:03
[14e53d0e] Update a comment in fts5.h. No changes to code. (user: dan, tags: trunk)
18:05
[48505cde] Fix the FTS5 xQueryPhrase() API function so that it recognizes column filters. (user: dan, tags: trunk)
2016-05-07
12:15
[d75140b8] Make the sqlite3DeleteTable() routine smaller and faster. (user: drh, tags: trunk)
12:15
[a45fda65] Fix typo in the intpkey-17.2 test. (user: drh, tags: trunk)
2016-05-06
20:23
[3a695263] Simplification to the logic used to decide between OP_Seek and OP_NotExists. Use OP_NotExists for both DELETE and UPDATE. (user: drh, tags: trunk)
18:47
[ab7ab415] Corrections to comments on the whereScanInit() interface. (user: drh, tags: trunk)
16:49
[93a2bace] For DELETE operations, make sure that seeks on the main table are not deferred, since if they are and none of the indexes reference columns of the table, the seek might never occur until the OP_Delete opcode, which is too late. Fix for ticket [16c9801ceba49]. (user: drh, tags: trunk)
16:30
[933a1c81] Fix an error in main.mk causing testfixture to use individual fts5 source code files instead of fts5.c. (user: dan, tags: trunk)
16:06
[150dd09e] Closed-Leaf: In the WHERE generator, when building code for a DELETE operation, make sure that seeks to the main table are not deferred. This is a better fix for the [16c9801ceba49] bug than the previous. (user: drh, tags: ticket-16c9801ce)
15:16
[dc37750d] Fix a bug in sqlite_analyzer causing it report (slightly) incorrect values for the number of entries in indexes or WITHOUT ROWID tables. (user: dan, tags: trunk)
11:31
[50312273] Do not scan indexes that have the integer primary key as their left-most column. This fixes the crash of ticket [16c9801ceba] but it seems like the wrong fix. More investigation needed. (user: drh, tags: ticket-16c9801ce)
2016-05-05
17:15
[bdf2ec77] Initial check-in of the "scrub.exe" utility program prototype. Not yet fully functional. In particular, no scrubbing is done. (user: drh, tags: scrub-backup)
11:53
[69d11447] Renumber internal constants in the printf() implemention for a small performance improvement. (user: drh, tags: trunk)
2016-05-04
21:06
[71af9ac1] Disable the session extension API if SQLITE_ENABLE_SESSION is not defined. (user: drh, tags: trunk)
19:04
[6c43ba1c] Fix typo in comment. No changes to code. (user: mistachkin, tags: trunk)
14:45
[aae38969] Only disable the one-pass DELETE optimization if the WHERE clause contains a correlated subquery. Uncorrelated subqueries are allowed. This is a refinement of check-in [3f221f592a9a1] that is the fix for ticket [dc6ebeda9396087]. (user: drh, tags: trunk)
14:20
[7184c4b8] Portability enhancements to the configure script on the amalgamation tarball. (user: drh, tags: trunk)
11:28
[6341ab2f] Disable the PagerDontWrite() optimization for temp tables. It can cause database corruption if a page passed to PagerDontWrite() is dirty at the start of a transaction that is subsequently rolled back. (user: dan, tags: trunk)
2016-05-03
19:40
[1b43358f] Minor style tweaks in the MSVC makefile. (user: mistachkin, tags: trunk)
19:36
[b6ddabe1] Leaf: Add the experimental SQLITE_FCNTL_WIN32_GET_HANDLE file control. (user: mistachkin, tags: win32GetHandle)
14:57
[bcaa650e] The session extension is disabled by default. To enable it using --enable-session on ./configure on unix and add SESSION=1 to the nmake on Windows. Or add -DSQLITE_ENABLE_SESSION and -DSQLITE_ENABLE_PREUPDATE_HOOK to build manually. (user: drh, tags: trunk)
13:14
[e462cde2] Closed-Leaf: Turn the session extension off by default. Enable using --enable-session on configure scripts, or using the SESSION=1 argument to nmake on Windows. (user: drh, tags: session-make)
00:04
[0715ce16] Avoid left-shifts of signed integers. (user: drh, tags: trunk)
2016-05-02
19:05
[5830cf72] Remove some randomness from test script temptable2.test. (user: dan, tags: trunk)
16:59
[088cf838] Fix a test case in temptable2.test so that it works on systems that lack a coherient cache (ex: OpenBSD) and thus do not support the "PRAGMA mmap_size" command. (user: drh, tags: trunk)
15:00
[f52765ee] Merge enhancements and bug fixes from trunk. (user: drh, tags: apple-osx)
13:57
[e4af9675] Fix harmless LLVM compiler warnings in the srcck1.c utility program used during the build process. (user: drh, tags: trunk)
12:18
[3f221f59] Disable the multi-row one-pass DELETE optimization when the WHERE clause contains a subquery. Fix for ticket [dc6ebeda9396087]. (user: drh, tags: trunk)
10:25
[54c63b32] Improvements to the way the LIKE optimization is implemented, resulting in slightly smaller and faster code that is easier to test. (user: drh, tags: trunk)
2016-04-30
19:23
[820c57bb] Change the way tester.tcl handes $argv so that in "permutations.test <permutation> <filename>" <filename> may be the name of any file in the test/ directory. (user: dan, tags: trunk)
18:10
[459a0b45] Remove an unnecessary branch from the OP_String8 opcode. (user: drh, tags: trunk)
17:19
[762bdc55] More bug fixes to Lemon identified by Kelvin Sherlock. None of these have any impact on SQLite. (user: drh, tags: trunk)
02:59
[daf4630f] Simplifications to the OP_Halt opcode implementation. (user: drh, tags: trunk)
2016-04-29
20:30
[614bb709] Fix the temporary directory search algorithm for unix so that it fails gracefully even if all candidate directories are inaccessible. This fixes a bug that was introduced by check-in [9b8fec60d8e]. (user: drh, tags: trunk)
16:01
[91e5c07e] Merge the latest enhancements from trunk. (user: drh, tags: begin-concurrent)
15:52
[81b76901] Merge enhancements from trunk, and in particular the TEMP file deferred I/O enhancements. (user: drh, tags: apple-osx)
15:39
[9d0a5ae0] Postpone I/O associated with TEMP files for as long as possible, with the hope that the I/O can ultimately be avoided completely. (user: drh, tags: trunk)
14:12
[b7bec7f2] Closed-Leaf: Fix test script temptable2.test so that it works with the "inmemory_journal" and "journaltest" permutations. (user: dan, tags: tempfiles-25)
11:35
[99794aca] Merge latest trunk changes, including test case fixes, with this branch. (user: dan, tags: tempfiles-25)
11:33
[4cbd5024] Modify the permutations.test script so as to set any permutation specific configuration values before running each individual test script. Fix a mostly harmless buffer overread in the sessions module. (user: dan, tags: trunk)
11:28
[4792d6db] Lemon bug fix: Do not merge action routines unless their destructors are also identical. Problem and suggested fix reported on the mailing list by Kelvin Sherlock. (user: drh, tags: trunk)
10:13
[89b0ee33] Closed-Leaf: Fix an almost entirely harmless buffer overread in the sessions module. (user: dan, tags: permutations-fix)
02:55
[e7c22e3b] Some optimization comments added to vdbe.c. No functional changes to code. (user: drh, tags: trunk)
2016-04-28
22:29
[9f15a520] Further simplifications and improved commentting on the rowset.c module, including several optimization comments. (user: drh, tags: trunk)
20:11
[8cdbe89a] Comment changes only: Add several optimization marks in rowset.c. Add a header comment that explains what the various special comments mean. (user: drh, tags: trunk)
19:23
[9f6f17b5] Fix typo in comment. No changes to code. (user: mistachkin, tags: trunk)
18:53
[5748e643] Rearrange some code in the RowSet logic for clarity of presentation, while adding an /*OPTIMIZATION-IF-TRUE*/ comment. It should operate identically. (user: drh, tags: trunk)
14:59
[45467ee4] Merge latest changes from trunk with this branch. (user: dan, tags: permutations-fix)
14:15
[33e62747] Use comments to mark several branches as optimizations. No changes to code. (user: drh, tags: trunk)
03:52
[fcf85bfe] Remove an unnecessary conditional from the sqlite3DecOrHexToI64() routine. (user: drh, tags: trunk)
00:32
[46d4ffff] Change the sqlite3Atoi64() routine so that it returns failure if not all of the input characters are consumed, even if it consumed all characters up to the first 0x00. This has no impact on external APIs as far as I can tell. (user: drh, tags: trunk)
2016-04-27
18:54
[2662d8fe] Modify the permutations.test script so as to set any permutation specific configuration values before running each individual test script. (user: dan, tags: permutations-fix)
15:24
[0065fe97] More simplification of the sqlite3AtoF() routine. Add special comments to indicate branches that are for optimization purposes only and that give the correct answer even if always or never taken. (user: drh, tags: trunk)
02:35
[3adfe9f3] Remove still more unnecessary branches from sqlite3AtoF(). (user: drh, tags: trunk)
2016-04-26
23:14
[dd69e53c] Further simplifications to sqlite3AtoF() to remove unneeded branches. (user: drh, tags: trunk)
21:02
[a9d00749] Remove an unnecessary line from the sqlite3AtoF() routine. (user: drh, tags: trunk)
18:58
[12418b10] The pcache and the built-in VFSes should not use mutexes when SQLITE_CONFIG_SINGLETHREAD is set. (user: drh, tags: trunk)
16:03
[04911cee] Merge the checksymbols fix from trunk into this branch. (user: dan, tags: tempfiles-25)
13:13
[d819bfbd] Fix the "checksymbols" target in Makefile.in to be able to deal with the sqlite3changegroup family of interfaces. (user: drh, tags: trunk)
2016-04-25
19:25
[7dd48c10] Update the RBU vacuum code so that databases that use custom collation sequences can be vacuumed. (user: dan, tags: trunk)
15:03
[a905d5e0] Merge bug fix from trunk. (user: drh, tags: tempfiles-25)