SQLite
Timeline
Not logged in

50 most recent check-ins

2017-06-28
11:56
[c46d94a8] Leaf: In the lemon-generated parser, automatically promote SHIFTREDUCE actions on nonterminal systems to pure REDUCE actions, for a performance enhancement. (user: drh, tags: trunk)
01:21
[6480916c] Simplify error handling logic in sqlite3_exec() to save about 40 bytes. (user: drh, tags: trunk)
01:12
[bfc4e7f3] Minor code simplification in the ALTER TABLE logic. (user: drh, tags: trunk)
00:55
[29d6ceb3] Avoid an unnecessary call to sqlite3XPrintf() in the code generator, for a performance improvement. (user: drh, tags: trunk)
2017-06-27
23:36
[b82efd2a] Add SQLITE_DBCONFIG_ENABLE_QPSG that forces the query planner stability guarantee. This is the fix for ticket [b9f010107724c] (user: drh, tags: trunk)
22:33
[d0f6973d] Leaf: Improve a local variable name. (user: mistachkin, tags: lsm-vtab)
22:27
[7e669d9b] Initial work on porting lsmtest to Win32. (user: mistachkin, tags: lsm-vtab)
20:23
[dfa9a4d5] Leaf: Support clients within a single process only. (user: dan, tags: server-process-edition)
18:15
[dbe9c8aa] Implement xFullpath for Win32. (user: mistachkin, tags: lsm-vtab)
16:48
[2b095406] Leaf: Merge latest trunk changes with this branch. (user: dan, tags: apple-osx)
16:39
[87b38166] 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. (user: dan, tags: trunk)
06:28
[e1cf8a78] Minor corrections to the previous check-in. (user: mistachkin, tags: lsm-vtab)
05:59
[2017636e] Work in progress porting lsm1 to Win32. (user: mistachkin, tags: lsm-vtab)
2017-06-26
21:08
[18f0616e] Add the -withoutnulls option to the "db eval" method in the TCL interface. (user: drh, tags: trunk)
18:42
[7c15d762] 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. (user: drh, tags: trunk)
16:13
[cbe441b2] Closed-Leaf: Add the "-unsetnull 1" option to the "sqlite3" command in the TCL interface. (user: drh, tags: unsetnull-option)
14:46
[ebcfa73e] Closed-Leaf: Make sure sqlite3VdbeSetVarmask() is never invoked when QPSG is enabled. (user: drh, tags: enable-QPSG)
13:57
[7076e828] 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. (user: drh, tags: enable-QPSG)
11:46
[ca8a7e99] Remove an invalid assert() from lsm test code. (user: dan, tags: lsm-vtab)
08:24
[461ced77] Fix another problem with multi-threaded mode in the LSM test code. (user: dan, tags: lsm-vtab)
07:31
[d7015475] Update a test case to reflect the fact that the lsm blocksize is configured in KiB. And defaults to 1024, not 2048. (user: dan, tags: lsm-vtab)
06:53
[23f16382] Fix some compiler warnings in lsm_file.c. (user: dan, tags: lsm-vtab)
2017-06-24
19:21
[c8186874] Disable shell tests for the .schema command if virtual tables are not available. (user: drh, tags: trunk)
18:10
[7b59c353] Leaf: Consider the values bound to SQL variables when determining whether or not a partial index may be used. (user: dan, tags: partial-index-variables)
16:35
[c2ea6293] Make sure the config.h header is included by ctime.c, if that header exists. (user: drh, tags: trunk)
16:03
[f0ec36d4] Query planner tuning: When deciding between two plans with the same cost, bias the selection toward the one that does not use the sorter. (user: drh, tags: trunk)
13:31
[0583b84a] Make sure enough memory is allocated for pathological quoting cases when computing a quoted table name in the command-line shell. (user: drh, tags: trunk)
2017-06-23
21:05
[53b14a38] Merge all recent trunk enhancements into the apple-osx branch. (user: drh, tags: apple-osx)
15:47
[712267c9] 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. (user: dan, tags: trunk)
2017-06-22
16:51
[e4a022be] Closed-Leaf: 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. (user: dan, tags: or-optimization)
2017-06-21
01:36
[118f7bb3] Enable pragma virtual tables for the integrity_check, quick_check, and foreign_key_check pragmas. (user: drh, tags: trunk)
2017-06-20
19:20
[d8568aac] Leaf: Ensure that test tool "tserver" finalizes all statements before attempting to close a database handle. (user: dan, tags: server-edition)
18:19
[94e420ec] Rename the azCompileOpt global constant to avoid a harmless compiler warning about a name conflict with a local variable. (user: drh, tags: trunk)
17:43
[48346268] 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]. (user: dan, tags: trunk)
2017-06-19
11:44
[f1682f0f] Leaf: Experimental "PRAGMA secure_delete=FAST" pragma. The intent is to overwrite deleted content with zeros without increasing the amount of disk I/O. (user: drh, tags: fast-secure-delete)
2017-06-17
19:06
[c21628e9] Leaf: Avoid adding an artifical "LIMIT 1" on scalar subqueries that do not need it. This seems like a pointless optimization as it makes minimal run-time difference but does increase code complexity. Parked on a branch for historical reference. (user: drh, tags: subquery-limit-opt)
18:49
[f3db02f4] Fix a missing comma in the previous check-in. (user: drh, tags: trunk)
17:55
[9a443397] 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. (user: dan, tags: trunk)
17:29
[95141c64] Leaf: Ensure that the value of the THREADSAFE symbol is always included when reporting compile time options, even if it was not explicitly configured. (user: dan, tags: ctime-refactor)
16:39
[603838fc] Add extra test cases for sqlite3changeset_apply() and ALTER TABLE ADD COLUMN. (user: dan, tags: trunk)
09:59
[036ebf72] Leaf: Version 3.18.2 (user: drh, tags: release, branch-3.18, version-3.18.2)
00:39
[e1b71029] When building an ephemeral table of integers, do not assume that the table does not already contain N if the insert cursor points to N-1. Fix for ticket [61fe9745]. Also increase the version number to 3.18.2. This is the release candidate. (user: drh, tags: branch-3.18)
2017-06-16
19:51
[bc1951d6] 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. (user: dan, tags: ctime-refactor)
18:31
[3944a32e] Minor refactoring change to clarify how ATTACH works. No functional changes. (user: drh, tags: trunk)
13:43
[11693849] Prevent pagesize changes on VACUUM in encrypted databases even when running the VACUUM on an attached database. (user: drh, tags: trunk)
13:41
[77bb4623] Version 3.18.1 (user: drh, tags: release, branch-3.18, version-3.18.1)
12:15
[20e5ffb1] An unintentional fork was created due to a typo when creating branch-3.18. This check-in resolves the fork and is the 3.18.1 release candidate. (user: drh, tags: branch-3.18)
2017-06-15
16:56
[254617a1] 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. (user: drh, tags: trunk)
16:45
[ca1ff707] Fix typo and improve the wording of the description of "Metadata" in the output of the sqlite3_analyzer tool. (user: drh, tags: trunk)
15:06
[60105c22] Merge the latest changes from trunk. (user: drh, tags: lsm-vtab)