/ Timeline
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

100 descendants and 100 ancestors of [2b5df3e8]

2017-07-11
16:36
Fix harmless compiler warnings seen with MSVC for lsm1. check-in: cf6da4a5 user: mistachkin tags: trunk
13:59
Add support for tab-completion (using the ext/misc/completion.c virtual table) to the command-line shell. check-in: 95cd1d9f user: drh tags: trunk
13:34
Change the src/shell.c file so that it is generated from a new script at tool/mkshellc.tcl and the template file src/shell.c.in, and automatically includes the extensions it needs out of ext/misc. check-in: 17e0bb12 user: drh tags: trunk
02:53
Fix a backup2 test case so that it works on FreeBSD. check-in: 724819b4 user: drh tags: trunk
02:05
Add the "phase" output column on the COMPLETION table-valued function, for debugging. Improved comments on the implementation. check-in: 0e213555 user: drh tags: trunk
01:38
The COMPLETION virtual table now looks at the names of databases, tables, and columns in addition to SQL keywords. check-in: 1cc97711 user: drh tags: trunk
00:09
Incomplete implementation of the COMPLETION table-valued function. So far it only works for SQL keywords. check-in: caefbc72 user: drh tags: trunk
2017-07-10
21:32
Fix harmless compiler warnings in lsmtest. check-in: bd8a1fb9 user: mistachkin tags: trunk
20:39
Fix errors in comments in the STMT virtual table. No code changes. check-in: 9a8f045d user: drh tags: trunk
20:33
Minor cleanup and refactoring of the Win32 VFS for lsm1. check-in: bf7eda67 user: mistachkin tags: trunk
19:54
Another spelling error in the README.md file. check-in: 05129374 user: drh tags: trunk
19:08
Spelling error in README.md check-in: 12bc47c5 user: drh tags: trunk
19:07
Yet another typo in README.md check-in: 75c9327b user: drh tags: trunk
19:05
Fix another README.md typo. check-in: 20b1f0ef user: drh tags: trunk
19:03
Fix an obsolete statement about Lemon in the README.md file. check-in: 4f6ce7a3 user: drh tags: trunk
18:57
Cleanup header usage in lsmtest for files that require _O_BINARY. check-in: f3a6a64e user: mistachkin tags: trunk
18:52
Updates to the repository README.md file. check-in: 7bfd3ab7 user: drh tags: trunk
18:33
In LSM, avoid calling the VFS xTestLock method to test for a lock that conflicts with one held by the same process. The results of such a call are considered undefined (since they are different under win32 and posix). check-in: a82a9bea user: dan tags: trunk
18:04
Add the "--newlines" option to the ".dump" command in the shell to disable the newline escaping mechanism. check-in: bde431b1 user: drh tags: trunk
17:00
When multiple constraints need to be evaluated for a row, do any constraints that involve correlated subqueries last. Hence, the priority is index-covered constraints first, correlated subquery constraints last, and all others in the middle. This is a follow-on and improvement to the push-down optimization of check-in [d7bb79ed]. check-in: c4cb9048 user: drh tags: trunk
16:38
Additional debugging Noop-comment in the constraint generator when wheretrace is enabled. Closed-Leaf check-in: 0ca7474f user: drh tags: defer-where-subqueries
15:26
Small performance optimization in sqlite3WhereExprUsage(). check-in: 38edc677 user: drh tags: defer-where-subqueries
15:17
Fix another problem on this branch. check-in: a4fc9811 user: dan tags: defer-where-subqueries
14:39
Fix a problem causing non-covered WHERE terms to be evaluated before covered WHERE terms. check-in: 7d3cb39f user: dan tags: defer-where-subqueries
14:33
When testing non-indexed WHERE constraints, test those that involve correlated sub-queries last of all. This increases the chances of not having to run the sub-query at all. check-in: 1f9c1f35 user: dan tags: defer-where-subqueries
13:24
For sqlite3TreeView() debugging output, show the Expr.flags field on scalar subqueries. check-in: dc857a96 user: drh tags: trunk
12:07
Update error message text for standard error codes to better describe the latest usage of those error codes. Modify sqlite3_open_v2() so that it does return a valid sqlite3 object in the event of SQLITE_MISUSE due to bad open flags, so that sqlite3_errmsg() does not report "out of memory" in that case. check-in: f27b6370 user: drh tags: trunk
11:17
Remove the error message text from disused error codes such as SQLITE_EMPTY and SQLITE_FORMAT. check-in: 871752f2 user: drh tags: trunk
2017-07-09
18:55
Always make "column%d" column-names 1-based, never 0-based. check-in: 70096c50 user: drh tags: trunk
00:30
Make sure the columns of a VALUES() clause are named "column%d" even if the VALUES() clause is a subquery in the FROM clause of an outer query. check-in: acf3b9cc user: drh tags: trunk
2017-07-08
22:30
Add the --icc, --gcc7, and --orm options to the speed-check.sh test script. check-in: 70dae08a user: drh tags: trunk
20:46
Support read-only MVCC transactions in server-mode. Started using "BEGIN READONLY". check-in: 5a043aa8 user: dan tags: server-process-edition
18:27
Disable compiler intrinsics when using the Intel C Compiler. Leaf check-in: dbb59f61 user: drh tags: icc-fix
2017-07-07
22:58
Merge in all the latest trunk enhancements. check-in: 7f48f6ab user: drh tags: apple-osx
22:47
Basic test cases for PRAGMA secure_delete=FAST. check-in: 0c246017 user: drh tags: trunk
21:20
Fix comment in the Win32 VFS for lsm1. check-in: 12a421bc user: mistachkin tags: trunk
21:15
For lsmtest, use a more portable means of setting open() files to binary. check-in: aea6e0ff user: mistachkin tags: trunk
20:35
Adjust copy_file() lsmtest function so it works properly for locked database files on Win32. check-in: 54a38555 user: mistachkin tags: trunk
20:06
Add the "PRAGMA secure_delete=FAST" option, which overwrites most deleted content without increasing the amount of I/O. Deleted content might persist on the free page list, however. And extra CPU cycles are used for zeroing, of course. check-in: 38978ce6 user: drh tags: trunk
19:43
Change the error message text for SQLITE_ERROR to omit the part about "missing database" as that meaning is now obsolete (since approx SQLite 2.0). check-in: 732f90d6 user: drh tags: trunk
19:22
Fix typos in Win32 VFS for lsm1. check-in: 0961ec87 user: mistachkin tags: trunk
19:12
Fix the memcpy calls in the lsmWin32OsShmMap function for lsm1. check-in: aa4890b9 user: mistachkin tags: trunk
19:02
Enhance the MSVC makefile 'clean' target to handle lsm1. check-in: 2d6faebc user: mistachkin tags: trunk
18:31
Add support for LSM_DEBUG to the MSVC makefile for lsm1. check-in: 277a7fed user: mistachkin tags: trunk
18:06
In the command-line shell, when running ".schema" give a sensible error when the database file is locked. check-in: cc329eb8 user: drh tags: trunk
17:57
Fix the usleep() macro in the Win32 test code for lsm1. check-in: 63599fa5 user: mistachkin tags: trunk
17:43
Add new PRAGMAs: "function_list", "module_list", and "pragma_list". All are enclosed within #ifdef SQLITE_INTROSPECTION_PRAGMAS. The compile-time option is not on ctime.c yet, since these are still experimental and one can always test "PRAGMA pragma_list" and see whether or not it returns an empty set. check-in: e0b6ae92 user: drh tags: trunk
17:33
Add the "Pragma_list" pragma. Put all three pragmas created on this branch inside of #ifdef SQLITE_INTROSPECTION_PRAGMAS. Closed-Leaf check-in: 2f3c3781 user: drh tags: list-pragmas
16:46
Improve clarity in the Win32 VFS for lsm1. check-in: 9c7a9e80 user: mistachkin tags: trunk
16:40
Merge latest trunk changes with this branch. check-in: 216c757f user: dan tags: server-process-edition
16:29
Add support for LSM_DEBUG_MEM to the MSVC makefile for lsm1. check-in: 3340de83 user: mistachkin tags: trunk
16:27
Remove a block from the Win32 VFS for lsm1 that is now superfluous. check-in: 5f726f28 user: dan tags: trunk
16:09
In lsmtest, use an empty string instead of ":memory:" when requesting a temporary database from SQLite. This prevents other test code from trying to unlink() ":memory:", which fails on win32. check-in: 281ad505 user: dan tags: trunk
16:07
Remove a block from the Win32 VFS for lsm1 that is now superfluous. check-in: db4a4140 user: mistachkin tags: trunk
16:06
Memory reallocation fix for the Win32 VFS for lsm1. check-in: 5a3140e4 user: mistachkin tags: trunk
16:00
Enhance the sqlite3VdbeMultiLoad() interface to automatically generate the OP_ResultRow opcode on PRAGMA implementations, for a small reduction in the library footprint. check-in: c46f0f07 user: drh tags: trunk
15:43
Add new pragmas: "function_list" and "module_list" check-in: e5f01d7f user: drh tags: list-pragmas
14:54
Fix an obsolete comment on the sqlite3_namelist() function implementation. Closed-Leaf check-in: f4229857 user: drh tags: experimental-namelist
14:26
Merge recent enhancements from trunk. check-in: 73d0fc02 user: drh tags: bind-pointer
13:59
Exploit the fact that Expr.pRight and Expr.x are never used at the same time for a small performance gain. check-in: aacbb9a4 user: drh tags: trunk
12:58
More efficient and compact implementation of walkExpr(). check-in: 115d4b83 user: drh tags: trunk
12:43
More aggressive use of EP_Leaf on expression nodes, to help prune searches. check-in: c1a1d68c user: drh tags: trunk
11:49
Very slightly smaller and faster sqlite3WalkSelect(). check-in: 9bc65635 user: drh tags: trunk
2017-07-06
22:43
Small adjustment to main.mk that facilitates giving non-standard compile-time options to the shell. check-in: 7c7d53a9 user: drh tags: trunk
22:40
Always load the schema before starting tab-completion. check-in: 907fd3aa user: drh tags: experimental-namelist
20:08
Tab-completion now also works using readline/editline. check-in: c906739f user: drh tags: experimental-namelist
19:26
Use the sqlite3_namelist() interface to implement simple tab-completion using linenoise. check-in: 5cc7b0e2 user: drh tags: experimental-namelist
18:52
Change the sqlite3_namelist() interface to return a pointer to an array of pointers to strings, and to avoid duplicates. check-in: 70291110 user: drh tags: experimental-namelist
18:25
The sqlite3_namelist() routine now works for all name types. check-in: e41d6217 user: drh tags: experimental-namelist
17:36
Initial implementation of a highly experimental interface for listing all keywords and symbolic names for an SQLite database connection. check-in: 04ef6783 user: drh tags: experimental-namelist
16:33
Change the (machine-generated) keywordhash.h file to increase the scope of the tables used for keyword matching, so that the tables are accessible to functions other then keywordCode(). check-in: c5ed5ebd user: drh tags: trunk
13:51
More compact implementation of the typeof() SQL function. check-in: efb4aab0 user: drh tags: trunk
13:23
Avoid unnecessary upper-to-lower case conversion for function names when registering the built-in functions. check-in: 06269257 user: drh tags: trunk
03:06
Small size reduction in findCollSeqEntry(). check-in: 55ecd303 user: drh tags: trunk
02:49
Avoid unnecessary calls to sqlite3GetCollSeq() for a small performance gain. check-in: 503ba172 user: drh tags: trunk
01:28
Slightly more compact implementation of the byte-code generator for the COMMIT and ROLLBACK commands. check-in: 4da663d9 user: drh tags: trunk
01:02
Small performance increase in sqlite3SrcListAppend(). check-in: 7b2623f1 user: drh tags: trunk
2017-07-05
23:33
Make the hash table implementation a little smaller and faster. check-in: f762f1ef user: drh tags: trunk
18:48
Have fts3 virtual table cursors free internal resources when they reach EOF, instead of waiting until the xClose method is called. check-in: b6b14ab6 user: dan tags: trunk
14:29
Fix a problem in lsmtest causing one test to fail for multi-threaded LSM connections. check-in: 2bce64c8 user: dan tags: trunk
2017-07-04
19:34
Add the count-of-view optimization when compiled using SQLITE_COUNTOFVIEW_OPTIMIZATION. check-in: d1ba2002 user: drh tags: trunk
19:23
Fix further OOM handling cases in LSM. check-in: ca757c86 user: dan tags: trunk
17:25
Fix a couple of problems in handling OOM conditions within LSM. check-in: 989a5c17 user: dan tags: trunk
12:50
Fix a problem in the lempar.c Lemon template for YYSTACKDEPTH<=0 introduced by check-in [36e54cd8b1fb37] check-in: 268a40f4 user: drh tags: trunk
2017-07-03
21:09
Fix compiler warnings in LSM1, especially in the test logic. check-in: 9bd3be92 user: drh tags: trunk
20:19
Fix a bug in lsm queries on levels undergoing incremental an merge that contain range-delete markers. check-in: b2c24879 user: dan tags: trunk
17:37
Attempt to improve documentation on sqlite3_column_ and sqlite3_value_ interfaces. check-in: 9111ac69 user: drh tags: trunk
09:00
Add more tests for LSM log file recovery. Fix a problem in recovering log files that contain range deletes. check-in: e34eafd4 user: dan tags: trunk
2017-07-01
20:59
Fix a memory management problem in lsm log recovery code. check-in: dd55af30 user: dan tags: trunk
15:21
Enhance the RTree module to detect node truncation early and report an error. check-in: 66de6f4a user: drh tags: trunk
2017-06-30
23:46
Update the carray() and remember() extension functions so that they user the new sqlite3_value_pointer() interface. check-in: a99fa94d user: drh tags: bind-pointer
23:09
Add APIs for binding pointers that can be used by app-defined functions. check-in: d9f4a831 user: drh tags: bind-pointer
20:11
Improved documentation for sqlite3_value_type(). check-in: 0db20efe user: drh tags: trunk
19:22
Add some assert() statements in the Win32 interface for lsm1. check-in: d076d58f user: mistachkin tags: trunk
18:12
Fix some minor typos in lsm1. check-in: 0ef777d7 user: mistachkin tags: trunk
11:44
Avoid constantly freeing and reallocing small internal buffers associated with LSM cursors. Instead, allow them to persist for the lifetime of the cursor if they are LSM_SEGMENTPTR_FREE_THRESHOLD (default 1024) bytes or smaller. This change is based on research by Martijn Blaauw. check-in: bacfe8cb user: dan tags: trunk
2017-06-29
21:33
In the command-line shell, add the -quote option to start up in quote mode. Enhance the ".mode" command so that it reports the current output mode if given no arguments. check-in: 5e3f9ea5 user: drh tags: trunk
21:11
Remove the ".explain" command from the ".help" output of the command-line shell, though keep the implementation around for backwards compatibility. check-in: 7782c04e user: drh tags: trunk
20:31
Some simple tests for the STMT virtual table. check-in: a26e17ee user: drh tags: trunk
20:23
Avoid reading or writing the 32 locking bytes at the end of the first meta-page of an LSM database. check-in: 3ed6877f user: dan tags: trunk
20:13
Avoid reading or writing the 32 locking bytes at the end of the first meta-page of an LSM database. Closed-Leaf check-in: 2b5df3e8 user: dan tags: lsm-metapage-fix
19:08
Fix issues in the POSIX and Win32 interfaces for lsm1. check-in: 38ec4141 user: mistachkin tags: trunk
17:27
Edit comments in sqlite.h.in used for generating documentation, to improve the description of the new sqlite3_prepare_v3() interfaces, and other miscellaneous cleanup. No changes to executable code. check-in: 284707a7 user: drh tags: trunk
16:51
More updates to the Win32 interface for lsm1. check-in: cae64769 user: mistachkin tags: trunk
15:57
Correct typo in the Win32 interface for lsm1. check-in: 1b4facb1 user: mistachkin tags: trunk
15:24
Add interfaces sqlite3_prepare_v3() and sqlite3_prepare16_v3() with the extra prepFlags argument. Add the SQLITE_PREPARE_PERSISTENT option as one bit in that argument. Use the new option in FTS3, FTS5, and RTREE. check-in: 03977248 user: drh tags: trunk
15:13
Further corrections to the Win32 interface for lsm1. check-in: 4df6e247 user: mistachkin tags: trunk
14:33
Rename the "stmts" virtual table to just "stmt" without the final "s". check-in: adfdb801 user: drh tags: trunk
14:17
A couple fixes for the Win32 interface for lsm1. check-in: ebbd98e9 user: mistachkin tags: trunk
13:41
Add the stmts virtual table to testfixture builds. Add new compile-time options SQLITE_ENABLE_QPSG and SQLITE_ENABLE_STMTSVTAB to ctime.c check-in: 60c62829 user: drh tags: trunk
13:35
Compilation fix for lsm1 using MSVC. check-in: b7794cc5 user: mistachkin tags: trunk
13:19
Add the LSM1 extension. check-in: 824e8327 user: drh tags: trunk
13:13
Add the "stmts" virtual table to the amalgamation, activated when compiled using -DSQLITE_ENABLE_STMTSVTAB. Add the SQLITE_STMTSTATUS_REPREPARE and SQLITE_STMTSTATUS_RUN statistics outputs from sqlite3_stmt_status() and add corresponding columns to the stmts virtual table. Change the numeric value of SQLITE_STMTSTATUS_MEMUSED to get it out of the way of counter values. check-in: 88976ae3 user: drh tags: trunk
12:59
The query planner examines the values of bound parameters to help determine if a partial index is usable. Reprepares may happen if the bindings change. This behavior is disabled by the QPSG setting. check-in: c322bfa2 user: drh tags: trunk
12:54
Implement xUnlink, xShmMap, and xShmUnmap for lsm1 on Win32. Closed-Leaf check-in: 680cc064 user: mistachkin tags: lsm-vtab
12:49
Add the SQLITE_STMTSTATUS_REPREPARE and SQLITE_STMTSTATUS_RUN options to sqlite3_stmt_status(). Use this for two new columns in the stmts virtual table. Closed-Leaf check-in: b0b0c8f8 user: drh tags: stmts-vtab
01:23
Fix the exprCompareVariable() routine so that it works for non-UTF8 text. Closed-Leaf check-in: 25acd965 user: drh tags: partial-index-variables
00:20
Implement xRemap for lsm1 on Win32. Also, zero file handle when closing it. check-in: 93c9aa7d user: mistachkin tags: lsm-vtab
2017-06-28
21:47
Alternative implementation of exprCompareVariable(). check-in: b959c629 user: drh tags: partial-index-variables
21:36
Implement xLock and xTestLock for lsm1 on Win32. check-in: 9112117d user: mistachkin tags: lsm-vtab
18:25
Make the query planners use of partial indexes based on bound variables responsive to the SQLITE_DBCONFIG_ENABLE_QPSG setting. check-in: a934dd14 user: drh tags: partial-index-variables
18:07
Merge the in the latest enhancements from trunk. check-in: 8f63c586 user: drh tags: partial-index-variables
15:56
Incorporate recent trunk changes. Closed-Leaf check-in: 62b8269b user: drh tags: prepare_v3
15:47
Build the "stmts" virtual table into the amalgamation. It is active only when compiled using SQLITE_ENABLE_STMTSVTAB. That option is supplied to the command-line shell. check-in: 0ff057d8 user: drh tags: stmts-vtab
15:17
Fix harmless compiler warnings in the CSV extension. check-in: f02a5459 user: drh tags: trunk
15:01
Faster parser stack overflow detection. check-in: 36e54cd8 user: drh tags: trunk
14:26
Minor tweak to the SQL grammar to make the parser tables a few bytes smaller. check-in: cc4810b2 user: drh tags: trunk
13:47
In the lemon-generated parser, store the number of symbols on the RHS of each rule as a negative number and add it to the stack pointer, rather than storing the value as a positive and subtracting it. This makes the parser faster. check-in: b362f0d8 user: drh tags: trunk
11:56
In the lemon-generated parser, automatically promote SHIFTREDUCE actions on nonterminal systems to pure REDUCE actions, for a performance enhancement. check-in: c46d94a8 user: drh tags: trunk
01:21
Simplify error handling logic in sqlite3_exec() to save about 40 bytes. check-in: 6480916c user: drh tags: trunk
01:12
Minor code simplification in the ALTER TABLE logic. check-in: bfc4e7f3 user: drh tags: trunk
00:55
Avoid an unnecessary call to sqlite3XPrintf() in the code generator, for a performance improvement. check-in: 29d6ceb3 user: drh tags: trunk
2017-06-27
23:36
Add SQLITE_DBCONFIG_ENABLE_QPSG that forces the query planner stability guarantee. This is the fix for ticket [b9f010107724c] check-in: b82efd2a user: drh tags: trunk
22:33
Improve a local variable name. check-in: d0f6973d user: mistachkin tags: lsm-vtab
22:27
Initial work on porting lsmtest to Win32. check-in: 7e669d9b user: mistachkin tags: lsm-vtab
18:15
Implement xFullpath for lsm1 on Win32. check-in: dbe9c8aa user: mistachkin tags: lsm-vtab
16:39
Fix a virtual table problem that can occur when the vtab is on the RHS of a LEFT JOIN and there is a MATCH constraint in the ON clause, or when the vtab is in a sub-query that is the RHS of a LEFT JOIN and there is a MATCH constraint in the WHERE clause of the sub-query. check-in: 87b38166 user: dan tags: trunk
06:28
Minor corrections to the previous check-in. check-in: e1cf8a78 user: mistachkin tags: lsm-vtab
05:59
Work in progress porting lsm1 to Win32. check-in: 2017636e user: mistachkin tags: lsm-vtab
2017-06-26
21:08
Add the -withoutnulls option to the "db eval" method in the TCL interface. check-in: 18f0616e user: drh tags: trunk
18:42
The ".import" command of the shell, and the csv virtual table extension both ignore a single UTF-8 BOM at the beginning of their input. check-in: 7c15d762 user: drh tags: trunk
14:46
Make sure sqlite3VdbeSetVarmask() is never invoked when QPSG is enabled. Closed-Leaf check-in: ebcfa73e user: drh tags: enable-QPSG
13:57
Add the SQLITE_DBCONFIG_ENABLE_QPSG option to activate the query planner stability guarantee. This involves refactoring the sqlite3.flags bitvector to carve out a free bit to use. check-in: 7076e828 user: drh tags: enable-QPSG
11:46
Remove an invalid assert() from lsm test code. check-in: ca8a7e99 user: dan tags: lsm-vtab
08:24
Fix another problem with multi-threaded mode in the LSM test code. check-in: 461ced77 user: dan tags: lsm-vtab
07:31
Update a test case to reflect the fact that the lsm blocksize is configured in KiB. And defaults to 1024, not 2048. check-in: d7015475 user: dan tags: lsm-vtab
06:53
Fix some compiler warnings in lsm_file.c. check-in: 23f16382 user: dan tags: lsm-vtab
2017-06-24
19:21
Disable shell tests for the .schema command if virtual tables are not available. check-in: c8186874 user: drh tags: trunk
18:10
Consider the values bound to SQL variables when determining whether or not a partial index may be used. check-in: 7b59c353 user: dan tags: partial-index-variables
16:35
Make sure the config.h header is included by ctime.c, if that header exists. check-in: c2ea6293 user: drh tags: trunk
16:03
Query planner tuning: When deciding between two plans with the same cost, bias the selection toward the one that does not use the sorter. check-in: f0ec36d4 user: drh tags: trunk
13:31
Make sure enough memory is allocated for pathological quoting cases when computing a quoted table name in the command-line shell. check-in: 0583b84a user: drh tags: trunk
2017-06-23
15:47
When generating individual loops for each ORed term of an OR scan, move any constant WHERE expressions outside of the loop, as is done for top-level loops. check-in: 712267c9 user: dan tags: trunk
2017-06-22
16:51
When generating individual loops for each ORed term of an OR scan, move any constant WHERE expressions outside of the loop, as is done for top-level loops. Closed-Leaf check-in: e4a022be user: dan tags: or-optimization
2017-06-21
01:36
Enable pragma virtual tables for the integrity_check, quick_check, and foreign_key_check pragmas. check-in: 118f7bb3 user: drh tags: trunk
2017-06-20
18:19
Rename the azCompileOpt global constant to avoid a harmless compiler warning about a name conflict with a local variable. check-in: 94e420ec user: drh tags: trunk
17:43
Ensure that the query planner knows that any column of a flattened LEFT JOIN can be NULL even if that column is labeled with "NOT NULL". Fix for ticket [892fc34f173e99d8]. check-in: 48346268 user: dan tags: trunk
2017-06-17
18:49
Fix a missing comma in the previous check-in. check-in: f3db02f4 user: drh tags: trunk
17:55
Rework the code in ctime.c a bit to report on more compile time options. And to only output configuration options passed in to SQLite, not the default values of #define symbols set automatically. Also generate the large array in ctime.c using new script tool/mkctime.tcl, instead of entering it manually. check-in: 9a443397 user: dan tags: trunk
17:29
Ensure that the value of the THREADSAFE symbol is always included when reporting compile time options, even if it was not explicitly configured. Closed-Leaf check-in: 95141c64 user: dan tags: ctime-refactor
16:39
Add extra test cases for sqlite3changeset_apply() and ALTER TABLE ADD COLUMN. check-in: 603838fc user: dan tags: trunk
2017-06-16
19:51
Rework the code in ctime.c a bit to report on more compile time options. And to only output configuration options passed in to SQLite, not the default values of #define symbols set automatically. Also generate the large array in ctime.c using new script tool/mkctime.tcl, instead of entering it manually. check-in: bc1951d6 user: dan tags: ctime-refactor
18:31
Minor refactoring change to clarify how ATTACH works. No functional changes. check-in: 3944a32e user: drh tags: trunk
13:43
Prevent pagesize changes on VACUUM in encrypted databases even when running the VACUUM on an attached database. check-in: 11693849 user: drh tags: trunk
2017-06-15
16:56
Move the "shell_add_schema()" SQL function used by the ".schema" command of the command-line shell to a different spot in the shell.c source file so that it is not in the middle of an unrelated module. check-in: 254617a1 user: drh tags: trunk
16:45
Fix typo and improve the wording of the description of "Metadata" in the output of the sqlite3_analyzer tool. check-in: ca1ff707 user: drh tags: trunk
15:06
Merge the latest changes from trunk. check-in: 60105c22 user: drh tags: lsm-vtab
13:07
Fix harmless compiler warnings in the shell.c file check-in: 9afd7a2f user: drh tags: trunk
12:50
Improvements to the ".tables" command in the command-line shell so that it shows the name of all schemas if the name is anything other than "main". check-in: c7f778b7 user: drh tags: trunk
12:21
In the command-line shell, enhance the ".schema" command show that it shows the schema for ATTACH-ed databases in addition to "main". check-in: 48e08628 user: drh tags: trunk
00:52
Enhance the sqlite3_analyzer.exe utility so that it computes and shows the number of bytes of metadata on btree pages and per table and index entry. check-in: 43ad41ef user: drh tags: trunk
2017-06-13
16:52
Fix sqlite3rbu_close() so that the pzErrmsg parameter may be passed NULL. check-in: c433672d user: dan tags: trunk
04:31
Fix the processing of double-negatives in WHERE clause constraints with STAT4. Ticket [cfa2c908f2182] check-in: 35b34bdf user: drh tags: trunk
2017-06-11
20:17
Fix an off-by-one error that messes up the display of loop codes in the ".wheretrace" debugging output for queries with more than 62 candidate loops when SQLITE_ENABLE_WHERETRACE is on. check-in: 0bbdaf28 user: drh tags: trunk
19:51
When reusing a materialized view, make sure the estimated number of output rows is correctly initialized to avoid confusing the query planner. check-in: 87aceb41 user: drh tags: trunk
19:40
Fix the sessiondiff test module so that it does not run if the session extension is not enabled. check-in: 8f92b7a6 user: drh tags: trunk
18:26
Fix a potential null-pointer deference following OOM introduced by check-in [e39795d7] (unreleased). check-in: a2f77285 user: drh tags: trunk
2017-06-09
15:14
Merge enhancements and fixes from trunk. check-in: 3fd050c3 user: drh tags: prepare_v3
11:43
Update the documentation to make it clear that the table name parameter to sqlite3_table_column_metadata() may not be NULL. check-in: 2881ab1e user: drh tags: trunk
02:27
Adjust the implementation of the ".selftest" feature of the shell to avoid using the deprecated sqlite3_get_table() interface. check-in: 3168e2c9 user: drh tags: trunk
2017-06-08
14:35
Add a testcase() to confirm that an OOM on sqlite3DbStrNDup() is handled correctly in trigger.c. check-in: 343e5599 user: drh tags: trunk
11:14
Ensure pointer map entries are always added when a row that does use overflow pages replaces one that does not in an auto-vacuum database. Fix for [fda22108]. check-in: b30dfba8 user: dan tags: trunk
2017-06-07
22:32
In SQLITE_DEBUG mode, attempt to log the page number of the database that contained the problem when SQLITE_CORRUPT errors are seen. check-in: e39795d7 user: drh tags: trunk
19:46
Fix another lsmtest build problem. Add the "-trans BOOLEAN" option to "lsmtest speed2". check-in: 61853bc1 user: dan tags: lsm-vtab
16:25
Merge in trunk enhancements. check-in: f8bbb608 user: drh tags: prepare_v3
2017-06-06
18:20
Add the SQLITE_DEFAULT_ROWEST compile-time option for changing the estimated number of rows in tables that lack sqlite_stat1 entries. check-in: 234ede26 user: drh tags: trunk
16:14
Fix a threading problem in lsm test code. check-in: 501238b9 user: dan tags: lsm-vtab
2017-06-05
19:20
Fix a subtle bug in the remember UDF of the kvtest.exe utility program. check-in: 9eea3670 user: drh tags: trunk
16:33
Fix a bug in test_fs.c that occurs when the first component of a path contains a GLOB or LIKE escape character. check-in: 73c70590 user: dan tags: trunk
13:28
For the kvtest utility, add the --vacuum option to "kvtest stat" and also run PRAGMA integrity_check with "kvtest stat". check-in: f3c25df4 user: drh tags: trunk
12:29
Fix the column width deduction logic in the command-line shell to account for multi-byte utf8 characters. check-in: ed0842c1 user: drh tags: trunk
10:31
Omit some of the fstree tests in vtabH if the PWD contains LIKE wildcards. check-in: ead29f9c user: drh tags: trunk
2017-06-03
20:09
Initialize a variable to zero to prevent an (incorrect) compiler warning of it potentially being uninitialized. check-in: 65182ce0 user: drh tags: trunk
19:16
Fix the SQLITE_PTR_TO_INT macro so that works on recent versions of LLVM on Macs. check-in: c4089ffb user: drh tags: trunk
18:27
Remove unused header file from kvtest. check-in: dd7e043f user: drh tags: trunk
17:24
In kvtest, add the ability to work with a hierarchy of files on disk, in addition to having all files in the same directory. check-in: f568f666 user: drh tags: trunk
15:17
Add the --nocheckpoint and --multitrans options to kvtest. check-in: 5828633c user: drh tags: trunk
2017-06-02
23:44
Merge all recent trunk enhancements. check-in: 1d23294d user: drh tags: lsm-vtab
23:32
Add the --fsync flag to kvtest, and document the --nosync flag. check-in: 7fdc78a6 user: drh tags: trunk
19:31
Work toward enhancing kvtest to measure write performance. check-in: fc73e7d2 user: drh tags: trunk
15:44
Change the name of the OP_Seek opcode into OP_DeferredSeek for better clarity of function. No functional code changes. check-in: ab33d299 user: drh tags: trunk