Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
111 events for the month beginning 2017-06-01 by user drh
Following month ↑|
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) | |
|
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) | |
| 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) | |
| 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:23 | • Edit [95141c642697dc03|95141c64]: Mark "Closed". (artifact: 61e8e392 user: drh) | |
| 15:22 | • Edit [942c3ef8cdb172f4|942c3ef8]: Mark "Closed". (artifact: 6f07f9aa user: drh) | |
| 14:33 | Rename the "stmts" virtual table to just "stmt" without the final "s". (check-in: adfdb801 user: drh 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: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: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) | |
|
2017-06-28
| ||
| 22:25 | • Edit [b959c6297c151150|b959c629]: Move to branch partial-index-variables. Edit check-in comment. (artifact: 343898d5 user: drh) | |
| 21:47 | Alternative implementation of exprCompareVariable(). (check-in: b959c629 user: drh tags: partial-index-variables) | |
| 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) | |
|
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) | |
|
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) | |
| 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. | |
|
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) | |
| 18:13 | • Fixed ticket [892fc34f]: Incorrect query result when a LEFT JOIN subquery is flattened plus 5 other changes (artifact: 879fcac8 user: drh) ... 1 similar event omitted. | |
|
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) | |
| 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
| ||
| 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
| ||
| 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-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: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: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) | |
| 16:25 | Merge in trunk enhancements. (check-in: f8bbb608 user: drh tags: prepare_v3) | |
| 10:55 | Cause the ANALYZE command to build sqlite_stat1 table entries for empty tables with the assumption that such tables really contain 10 elements. This gives better query plans for tables that are truely empty, but is likely to cause problems in legacy systems, so the change is kept off trunk. Some TCL tests fail on this check-in due to the new stat1 entries. (Leaf check-in: c81f260c user: drh tags: analyze-empty-tables) | |
|
2017-06-06
| ||
| 18:22 | Add the SQLITE_DEFAULT_ROWEST compile-time option for changing the estimated number of rows in tables that lack sqlite_stat1 entries. (check-in: 802b82f3 user: drh tags: branch-3.8.9) | |
| 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) | |
|
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) | |
| 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) | |
| 13:16 | Fix a typo in the header comment of the "series.c" virtual table extension. (check-in: d637feb4 user: drh tags: trunk) | |
|
2017-06-01
| ||
| 01:53 | Add a comment to the Lemon documentation regarding the security of the lemon.exe command-line tool. (check-in: 4c2458c1 user: drh tags: trunk) | |
| 00:54 | 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. (check-in: 4a25c588 user: drh tags: prepare_v3) | |