SQLite
Timeline
Not logged in

200 most recent timeline items related to "trunk"

2016-07-25
02:42
[e1e02238] Leaf: Evidence marks and code reformatting for SQLITE_TRACE_STMT operation. (user: drh, tags: trunk)
02:31
[163e1522] Change SQLITE_TRACE_STMT to return unexpanded SQL text in the X argument. Add documentation on how and when to use sqlite3_expanded_sql(P) to compute the expanded text for legacy sqlite3_trace() compatibility. (user: drh, tags: trunk)
00:05
[1c5baae3] Fix code so that the deprecated sqlite3_trace() and sqlite3_profile() interfaces are not called when SQLITE_OMIT_DEPRECATED is used. (user: drh, tags: trunk)
2016-07-23
20:27
[c8e0539b] Use sqlite3_trace_v2() instead of sqlite3_trace() in the shell. (user: drh, tags: trunk)
19:34
[269892ab] Add the json_quote() function to the JSON1 extension. (user: drh, tags: trunk)
19:18
[8817dedb] Small tweak to the btree balancer for improved tree balance. (user: drh, tags: trunk)
14:50
[d0bcaf0c] Fix recently added tests so that they work in all configurations. (user: drh, tags: trunk)
05:22
[99a6c518] Add the sqlite3_expanded_sql() and sqlite3_trace_v2() interfaces. (user: drh, tags: trunk)
04:58
[0400f642] Closed-Leaf: Improvements to sqlite3_trace_v2() documentation. Fix the sqlite3VdbeExpandSql() routine to respond better to OOM conditions. (user: drh, tags: sqlite3_trace_v2)
2016-07-22
21:35
[f50a3fd6] Revise a warning fix from the previous check-in to improve clarity. Also, fix an incorrect test prefix (typo). (user: mistachkin, tags: trunk)
21:26
[8bb6e6fc] Fix harmless compiler warnings seen with MSVC. (user: mistachkin, tags: trunk)
17:58
[60fed5cd] Merge latest trunk changes with this branch. (user: dan, tags: rowvalue)
10:09
[87e25fc4] Fix a problem with upper case module names in the "sqldiff --vtab" command. (user: dan, tags: trunk)
2016-07-21
18:02
[bf98a2de] Add extra test cases to verify the fix in [64ca1a835]. (user: dan, tags: trunk)
16:43
[1b1ad0b2] Add new test file vacuummem.test. To test that any temporary memory used by VACUUM is freed as soon as the VACUUM has finished (not, for example, when sqlite3_close() is finally called). (user: dan, tags: trunk)
2016-07-15
19:17
[d0a1cf1c] Add the largely untested SQLITE_FTS5_NO_WITHOUT_ROWID compile time option to fts5. For building a dynamically loadable extension that does not use WITHOUT ROWID. (user: dan, tags: trunk)
02:55
[d2b1fa55] Merge fixes from trunk. Fix the tclsqlite.test script. (user: drh, tags: sqlite3_trace_v2)
02:50
[ec718089] Disable the CSV extension when virtual tables are disabled. (user: drh, tags: trunk)
2016-07-14
20:19
[46bd9533] Leaf: Experimental patch restore the slight bias in btree-balancing immediately after the change to reduces the amount of memcpy() work done by balancing. (user: drh, tags: btree-balance-bias)
19:48
[d2a0af7a] Closed-Leaf: Minor tweak the the b-tree balancer. (user: drh, tags: btree-tuning)
19:13
[a7db6e45] Fix ALTER TABLE so that it does not promote the schema version past 3, as that will cause DESC indexes to go corrupt. Ticket [f68bf68513a1c]. (user: drh, tags: trunk)
2016-07-13
21:30
[0c569f75] Interface design for a new sqlite3_trace_v2() method that supersedes sqlite3_trace() and sqlite3_profile(). (user: drh, tags: sqlite3_trace_v2)
13:05
[824b39e5] Fix harmless compiler warnings in shell.c for NetBSD. (user: drh, tags: trunk)
00:55
[021d0fb8] Fix header comments and remove an unnecessary version restriction from the carray() table-valued function implementation. (user: drh, tags: trunk)
2016-07-12
19:54
[3ef93950] Fix the error counter reset in Lemon generated parsers. This has no effect on SQLite. (user: drh, tags: trunk)
2016-07-10
19:35
[728c5aa4] Merge comment typo fixes from trunk. (user: mistachkin, tags: rowvalue)
19:35
[77c692a6] Fix typos in comments. No changes to code. (user: mistachkin, tags: trunk)
2016-07-09
20:23
[b2204215] Add some support for using row value constructors in certain parts of SQL expressions. There are many bugs on this branch. (user: dan, tags: rowvalue)
17:47
[c869bf34] Add the "#/value-list/" style of results for approximate value matching in the do_test command of the test infrastructure. Use this new result style to make the SQLITE_DBSTATUS_CACHE_SIZE_SHARED tests cross-platform. (user: drh, tags: trunk)
17:15
[29fb988f] Fix a compiler warning in test code - in the int64array_addr TCL command. (user: drh, tags: trunk)
16:38
[8b22f777] Fix compiler warnings on windows. (user: drh, tags: trunk)
16:14
[5471aca0] Fix various internal #defines to conform to new C-language naming restrictions, specifically that private-use macros names must not begin with "_". (user: drh, tags: trunk)
00:06
[b5f32a89] Add support for the win32-none VFS. (user: drh, tags: trunk)
2016-07-08
21:14
[549abe3f] Closed-Leaf: Initial work on a Win32 VFS with NOP locking. (user: mistachkin, tags: win32nolock)
19:54
[e1d8ef31] Another attempt to fix error handling in Lemon. This change is a no-op for SQLite's usage. (user: drh, tags: trunk)
02:14
[8bb8d886] In the sqldiff program, make sure the first argument to the db_prepare() utility function is always a valid format string. (user: drh, tags: trunk)
2016-07-06
18:42
[06cf2680] Add the SQLITE_DBSTATUS_CACHE_USED_SHARED sqlite3_db_status() parameter. This option is similar to DBSTATUS_CACHE_USED, except that it divides memory used by shared caches evenly between all connections. (user: dan, tags: trunk)
18:12
[d58401ab] Closed-Leaf: Change the name of the SQLITE_DBSTATUS_PROPORTIONAL_CACHE_USED to SQLITE_DBSTATUS_CACHE_USED_SHARED. (user: dan, tags: dbstatus-prop-cache-used)
10:17
[0c228f5d] Fix a test script problem causing a test to fail if the ICU extension is enabled. (user: dan, tags: trunk)
10:12
[118321c8] Add the SQLITE_DBSTATUS_PROPORTIONAL_CACHE_USED sqlite3_db_status() parameter. (user: dan, tags: dbstatus-prop-cache-used)
09:19
[724e4cdc] Fix a memory leak in recently added test code. (user: dan, tags: trunk)
2016-07-05
16:11
[2683b375] More fixes to Lemon so that it automatically resets its error counter at the end of a parse. (user: drh, tags: trunk)
12:47
[91889fa3] Attempt to reset the error count in the Lemon-generated parser after a parse failure. (user: drh, tags: trunk)
2016-07-04
11:47
[0357875f] 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: trunk)
11:34
[d8bc6feb] Add the carray() virtual table as a loadable extension. (user: drh, tags: trunk)
2016-07-03
02:35
[a204ba99] Closed-Leaf: Change the name of the intarray() extension to carray() and give it an optional third parameter that specifies the datatype as one of 'int32', 'int64', 'double', or 'char*'. 'int32' is the default. (user: drh, tags: prototype-int-array)
2016-07-02
20:51
[507fdbfb] Merge the alternative table-valued function RHS of IN operator implementation from trunk. (user: drh, tags: prototype-int-array)
12:33
[bead151e] Fix a problem in table-valued functions on the RHS of an IN operator that occurs following an OOM error. (user: drh, tags: trunk)
12:08
[ac6000f0] Add support for table-valued functions on the RHS of an IN operator. (user: drh, tags: trunk)
2016-07-01
20:12
[228a7879] 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] Closed-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] Closed-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 opcode. (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)