SQLite
Timeline
Not logged in

50 most recent timeline items

2017-06-23
21:05
[53b14a38] Leaf: Merge all recent trunk enhancements into the apple-osx branch. (user: drh, tags: apple-osx)
19:38 • Ticket [b9f01010] Violation of the Query Planner Stability Guarantee status still Open with 6 other changes (user: drh) ... 1 similar event omitted.
15:47 • Edit [e4a022be4b069b08|e4a022be]: Mark "Closed". (user: dan)
15:47
[712267c9] 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: 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)
18:13 • Fixed ticket [892fc34f]: Incorrect query result when a LEFT JOIN subquery is flattened plus 5 other changes (user: drh)
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)
16:15 • New ticket [892fc34f] Incorrect query result when a LEFT JOIN subquery is flattened. (user: drh)
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)
12:14 • Edit [30c50f0e06084f3c|30c50f0e]: Move to branch branch-3.18. (user: drh)
12:09 • Edit [e3038fbfc2af8201|e3038fbf]: Move to branch mistake. Add propagating "hidden". Edit check-in comment. Cancel background color. (user: drh)
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] Leaf: Merge the latest changes from trunk. (user: drh, tags: lsm-vtab)
13:07
[9afd7a2f] Fix harmless compiler warnings in the shell.c file (user: drh, tags: trunk)
12:50
[c7f778b7] 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". (user: drh, tags: trunk)
12:21
[48e08628] In the command-line shell, enhance the ".schema" command show that it shows the schema for ATTACH-ed databases in addition to "main". (user: drh, tags: trunk)
07:47
[4be2eba8] Increase the version number to 3.18.1. (user: drh, tags: branch-3.18)
00:52
[43ad41ef] 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. (user: drh, tags: trunk)
2017-06-13
16:52
[c433672d] Fix sqlite3rbu_close() so that the pzErrmsg parameter may be passed NULL. (user: dan, tags: trunk)
04:31
[35b34bdf] Fix the processing of double-negatives in WHERE clause constraints with STAT4. Ticket [cfa2c908f2182] (user: drh, tags: trunk)
03:55 • New ticket [cfa2c908] Assertion fault in STAT4 on a double-negation. (user: drh)
2017-06-12
23:44
[30c50f0e] 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]. (user: drh, tags: branch-3.18)
2017-06-11
20:17
[0bbdaf28] 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. (user: drh, tags: trunk)
19:51
[87aceb41] When reusing a materialized view, make sure the estimated number of output rows is correctly initialized to avoid confusing the query planner. (user: drh, tags: trunk)
19:40
[8f92b7a6] Fix the sessiondiff test module so that it does not run if the session extension is not enabled. (user: drh, tags: trunk)
18:26
[a2f77285] Fix a potential null-pointer deference following OOM introduced by check-in [e39795d7] (unreleased). (user: drh, tags: trunk)
2017-06-10
17:23
[79544fc2] Leaf: Remove sqlite3_log() and abort() calls added to this branch to debug the pointer-map problem ([fda22108]). (user: dan, tags: begin-concurrent)
2017-06-09
15:14
[3fd050c3] Leaf: Merge enhancements and fixes from trunk. (user: drh, tags: prepare_v3)
11:43
[2881ab1e] Update the documentation to make it clear that the table name parameter to sqlite3_table_column_metadata() may not be NULL. (user: drh, tags: trunk)
02:27
[3168e2c9] Adjust the implementation of the ".selftest" feature of the shell to avoid using the deprecated sqlite3_get_table() interface. (user: drh, tags: trunk)
2017-06-08
16:23
[8e311a6d] Update the recent auto-vacuum fix so that it works for the in-memory pointer-map structure used by this branch. (user: dan, tags: begin-concurrent)
16:10
[e2d38d51] Merge 3.19.3 changes with this branch. (user: dan, tags: begin-concurrent)
15:54
[0f59bb94] Merge changes for version 3.19.0 with this branch. (user: dan, tags: begin-concurrent)