Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 events occurring around 483462682d3a57fb.
2017-06-28
| ||
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) | |
17:29 | Instead of the new sqlite3_prepare_v3() interface, provide the SQLITE_DBCONFIG_PREPARE_FLAGS interface which sets the flags on the single next call to sqlite3_prepare_v2() or its cousins. (Closed-Leaf check-in: 942c3ef8 user: drh tags: dbconfig-prepare-flags) | |
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 | • Fixed ticket [b9f01010]: Violation of the Query Planner Stability Guarantee plus 3 other changes (artifact: 29856781 user: drh) | |
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) | |
20:23 | Support clients within a single process only. (check-in: dfa9a4d5 user: dan tags: server-process-edition) | |
18:15 | Implement xFullpath for lsm1 on Win32. (check-in: dbe9c8aa user: mistachkin tags: lsm-vtab) | |
16:48 | Merge latest trunk changes with this branch. (check-in: 2b095406 user: dan tags: apple-osx) | |
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
| ||
23:38 | • Edit [cbe441b231397a9b|cbe441b2]: Mark "Closed". (artifact: f8b8455e user: drh) | |
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) | |
16:49 | • Edit [cbe441b231397a9b|cbe441b2]: Move to branch unsetnull-option. (artifact: adb60249 user: drh) | |
16:13 | Add the "-unsetnull 1" option to the "sqlite3" command in the TCL interface. (Closed-Leaf check-in: cbe441b2 user: drh tags: unsetnull-option) | |
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
| ||
21:05 | Merge all recent trunk enhancements into the apple-osx branch. (check-in: 53b14a38 user: drh tags: apple-osx) | |
19:38 | • Ticket [b9f01010] Violation of the Query Planner Stability Guarantee status still Open with 6 other changes (artifact: ecf53365 user: drh) ... 1 similar event omitted. | |
15:47 | • Edit [e4a022be4b069b08|e4a022be]: Mark "Closed". (artifact: 85d116ac user: dan) | |
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
| ||
19:20 | Ensure that test tool "tserver" finalizes all statements before attempting to close a database handle. (check-in: d8568aac user: dan tags: server-edition) | |
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) | |
18:13 | • Fixed ticket [892fc34f]: Incorrect query result when a LEFT JOIN subquery is flattened plus 5 other changes (artifact: 879fcac8 user: drh) | |
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) | |
16:15 | • New ticket [892fc34f] Incorrect query result when a LEFT JOIN subquery is flattened. (artifact: d28d6544 user: drh) | |
2017-06-19
| ||
11:44 | Experimental "PRAGMA secure_delete=FAST" pragma. The intent is to overwrite deleted content with zeros without increasing the amount of disk I/O. (Closed-Leaf check-in: f1682f0f user: drh tags: fast-secure-delete) | |
2017-06-17
| ||
19:06 | 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. (Leaf check-in: c21628e9 user: drh tags: subquery-limit-opt) | |
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) | |
09:59 | Version 3.18.2 (check-in: 036ebf72 user: drh tags: release, branch-3.18, version-3.18.2) | |
00:39 | 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. (check-in: e1b71029 user: drh tags: branch-3.18) | |
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) | |
13:41 | Version 3.18.1 (check-in: 77bb4623 user: drh tags: release, branch-3.18, version-3.18.1) | |
12:15 | 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. (check-in: 20e5ffb1 user: drh tags: branch-3.18) | |
12:14 | • Edit [30c50f0e06084f3c|30c50f0e]: Move to branch branch-3.18. (artifact: c6d9d8e3 user: drh) | |
12:09 | • Edit [e3038fbfc2af8201|e3038fbf]: Move to branch mistake. Add propagating "hidden". Edit check-in comment. Cancel background color. (artifact: 26430557 user: drh) | |
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) | |
07:47 | Increase the version number to 3.18.1. (check-in: 4be2eba8 user: drh tags: branch-3.18) | |
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) | |
03:55 | • New ticket [cfa2c908] Assertion fault in STAT4 on a double-negation. (artifact: bea44233 user: drh) | |
2017-06-12
| ||
23:44 | 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: 30c50f0e user: drh tags: branch-3.18) | |
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-10
| ||
17:23 | Remove sqlite3_log() and abort() calls added to this branch to debug the pointer-map problem ([fda22108]). (check-in: 79544fc2 user: dan tags: begin-concurrent) | |
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
| ||
16:23 | Update the recent auto-vacuum fix so that it works for the in-memory pointer-map structure used by this branch. (check-in: 8e311a6d user: dan tags: begin-concurrent) | |
16:10 | Merge 3.19.3 changes with this branch. (check-in: e2d38d51 user: dan tags: begin-concurrent) | |
15:54 | Merge changes for version 3.19.0 with this branch. (check-in: 0f59bb94 user: dan tags: begin-concurrent) | |
14:41 | Merge the auto_vacuum bug fix and all other changes from the 3.19.3 release. (check-in: 93f32dd2 user: drh tags: apple-osx) | |
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) | |
14:26 | Version 3.19.3 (check-in: 0ee482a1 user: drh tags: release, version-3.19.3, branch-3.19) | |
13:10 | • Fixed ticket [fda22108]: Corruption due to REPLACE in an auto-vacuumed database plus 3 other changes (artifact: eee8ce59 user: drh) | |
11:32 | Fix an issue with OPT_FEATURE_FLAGS in configure.ac. (check-in: 97b5c4a5 user: drh tags: branch-3.19) | |
11:27 | Increase the version number to 3.19.3. (check-in: 903fff53 user: drh tags: branch-3.19) | |
11:26 | 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: 9478106c user: drh tags: branch-3.19) | |
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) | |
11:08 | • Ticket [fda22108] Corruption due to REPLACE in an auto-vacuumed database status still Open with 6 other changes (artifact: 7b1cb0c7 user: drh) ... 1 similar event omitted. | |
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) | |