SQLite
Timeline
Not logged in

132 timeline items tagged with "trunk" occurring on or after release.

2016-07-26
10:46
[483994a5] Leaf: Ensure that the sqlite3_scrub_backup() extension creates a backup database at least as large as indicated by the database header, even if the last page of the input database is a free-list leaf. (user: dan, tags: trunk)
04:49
[c0e7d98e] Copy the cache_spill setting from the main database over to the vacuum_db transient database when running a VACUUM. (user: drh, tags: trunk)
04:31
[b819bace] Make sure affinity is applied correctly on lower-bound range constraints in the min() optimization. Fix for ticket [a0bac8b3c3d1bb]. (user: drh, tags: trunk)
2016-07-25
22:40
[b78d9954] In the VACUUM command, set the cache_size of the transient vacuum_db database to be the same as the database being vacuumed. (user: drh, tags: trunk)
21:11
[a495f8e7] Fix a test case in FTS5 to make it compatible with Tcl 8.5. (user: drh, tags: trunk)
16:10
[8dcb9d50] Minor test infrastructure changes to better support SEE testing. (user: drh, tags: trunk)
14:40
[38a48cfb] Add a new %ifdef to parse.y so that the build works with SQLITE_OMIT_SUBQUERY. (user: drh, tags: trunk)
14:20
[9e7bedee] Changes to test scripts to get them all running on OpenBSD. (user: drh, tags: trunk)
12:10
[d6f6c87c] Disable the DBSTATUS_CACHE_USED_SHARED tests on mac when memsys3/5 is disabled due to differences in the allocation sizes for the Darwin memory allocator. (user: drh, tags: trunk)
12:01
[ea7fb98b] Update the vacuummem.test script so that it works on mac as well as on linux. (user: drh, tags: trunk)
11:57
[ccc22e14] If both MEMSYS3 and MEMSYS5 are enabled, than automatically disable MEMSYS3. (user: drh, tags: trunk)
11:39
[5f40e6ad] Another attempt at getting --enable-memsysN working. (user: drh, tags: trunk)
11:32
[67955255] Fix the --enable-memsysN options in configure so that they actually work. (user: drh, tags: trunk)
11:27
[67e1dc98] Add --enable-memsys3 and --enable-memsys5 options to the configure script. (user: drh, tags: trunk)
02:42
[e1e02238] 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)
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)
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:50
[ec718089] Disable the CSV extension when virtual tables are disabled. (user: drh, tags: trunk)
2016-07-14
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
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
[77c692a6] Fix typos in comments. No changes to code. (user: mistachkin, tags: trunk)
2016-07-09
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
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)
10:17
[0c228f5d] Fix a test script problem causing a test to fail if the ICU extension is enabled. (user: dan, tags: trunk)
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-02
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)
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)
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-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)
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-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)
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
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)
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
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
17:45
[24f258c2] Remove an unnecessary malloc from the vfsstat extension. (user: drh, tags: trunk)
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)
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)
2016-05-27
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)
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)
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)
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
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)
10:57
[fc49f556] Version 3.13.0 (user: drh, tags: trunk, release, version-3.13.0)