Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
200 check-ins occurring around b30dfba811cb531b.
|
2017-06-29
| ||
| 15:13 | Further corrections to the Win32 interface for lsm1. (check-in: 4df6e2476c user: mistachkin tags: trunk) | |
| 14:33 | Rename the "stmts" virtual table to just "stmt" without the final "s". (check-in: adfdb80105 user: drh tags: trunk) | |
| 14:17 | A couple fixes for the Win32 interface for lsm1. (check-in: ebbd98e941 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: 60c628293a user: drh tags: trunk) | |
| 13:35 | Compilation fix for lsm1 using MSVC. (check-in: b7794cc5d5 user: mistachkin tags: trunk) | |
| 13:19 | Add the LSM1 extension. (check-in: 824e83274c 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: 88976ae31c 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: c322bfa27e user: drh tags: trunk) | |
| 12:54 | Implement xUnlink, xShmMap, and xShmUnmap for lsm1 on Win32. (Closed-Leaf check-in: 680cc064c9 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: b0b0c8f8d5 user: drh tags: stmts-vtab) | |
| 01:23 | Fix the exprCompareVariable() routine so that it works for non-UTF8 text. (Closed-Leaf check-in: 25acd9658b user: drh tags: partial-index-variables) | |
| 00:20 | Implement xRemap for lsm1 on Win32. Also, zero file handle when closing it. (check-in: 93c9aa7d9a user: mistachkin tags: lsm-vtab) | |
|
2017-06-28
| ||
| 21:47 | Alternative implementation of exprCompareVariable(). (check-in: b959c6297c user: drh tags: partial-index-variables) | |
| 21:36 | Implement xLock and xTestLock for lsm1 on Win32. (check-in: 9112117dad user: mistachkin tags: lsm-vtab) | |
| 20:21 | Merge tserver fixes with this branch. (check-in: 58a0aab8fd user: dan tags: server-process-edition) | |
| 20:12 | Fix bugs in test program tserver.c. (Leaf check-in: 093b9108ea user: dan tags: server-edition) | |
| 18:25 | Make the query planners use of partial indexes based on bound variables responsive to the SQLITE_DBCONFIG_ENABLE_QPSG setting. (check-in: a934dd14ac user: drh tags: partial-index-variables) | |
| 18:07 | Merge the in the latest enhancements from trunk. (check-in: 8f63c58632 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: 942c3ef8cd user: drh tags: dbconfig-prepare-flags) | |
| 15:56 | Incorporate recent trunk changes. (Closed-Leaf check-in: 62b8269ba2 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: 0ff057d86e user: drh tags: stmts-vtab) | |
| 15:17 | Fix harmless compiler warnings in the CSV extension. (check-in: f02a54599d user: drh tags: trunk) | |
| 15:01 | Faster parser stack overflow detection. (check-in: 36e54cd8b1 user: drh tags: trunk) | |
| 14:26 | Minor tweak to the SQL grammar to make the parser tables a few bytes smaller. (check-in: cc4810b23e 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: b362f0d8ed 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: c46d94a8cd user: drh tags: trunk) | |
| 01:21 | Simplify error handling logic in sqlite3_exec() to save about 40 bytes. (check-in: 6480916c72 user: drh tags: trunk) | |
| 01:12 | Minor code simplification in the ALTER TABLE logic. (check-in: bfc4e7f30e user: drh tags: trunk) | |
| 00:55 | Avoid an unnecessary call to sqlite3XPrintf() in the code generator, for a performance improvement. (check-in: 29d6ceb383 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: b82efd2a24 user: drh tags: trunk) | |
| 22:33 | Improve a local variable name. (check-in: d0f6973d93 user: mistachkin tags: lsm-vtab) | |
| 22:27 | Initial work on porting lsmtest to Win32. (check-in: 7e669d9bfa user: mistachkin tags: lsm-vtab) | |
| 20:23 | Support clients within a single process only. (check-in: dfa9a4d53e user: dan tags: server-process-edition) | |
| 18:15 | Implement xFullpath for lsm1 on Win32. (check-in: dbe9c8aa8d user: mistachkin tags: lsm-vtab) | |
| 16:48 | Merge latest trunk changes with this branch. (check-in: 2b0954060f 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: 87b3816633 user: dan tags: trunk) | |
| 06:28 | Minor corrections to the previous check-in. (check-in: e1cf8a78a0 user: mistachkin tags: lsm-vtab) | |
| 05:59 | Work in progress porting lsm1 to Win32. (check-in: 2017636e93 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: 18f0616e15 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: 7c15d762d9 user: drh tags: trunk) | |
| 16:13 | Add the "-unsetnull 1" option to the "sqlite3" command in the TCL interface. (Closed-Leaf check-in: cbe441b231 user: drh tags: unsetnull-option) | |
| 14:46 | Make sure sqlite3VdbeSetVarmask() is never invoked when QPSG is enabled. (Closed-Leaf check-in: ebcfa73e1c 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: 7076e8283e user: drh tags: enable-QPSG) | |
| 11:46 | Remove an invalid assert() from lsm test code. (check-in: ca8a7e995c user: dan tags: lsm-vtab) | |
| 08:24 | Fix another problem with multi-threaded mode in the LSM test code. (check-in: 461ced77d9 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: d7015475f1 user: dan tags: lsm-vtab) | |
| 06:53 | Fix some compiler warnings in lsm_file.c. (check-in: 23f16382ed 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: c8186874b3 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: 7b59c353b8 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: c2ea62937e 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: f0ec36d479 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: 0583b84ab4 user: drh tags: trunk) | |
|
2017-06-23
| ||
| 21:05 | Merge all recent trunk enhancements into the apple-osx branch. (check-in: 53b14a3888 user: drh tags: apple-osx) | |
| 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: 712267c9c0 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: e4a022be4b 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: 118f7bb33a 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: d8568aacf0 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: 94e420ecfb 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: 483462682d user: dan tags: trunk) | |
|
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: f1682f0faf 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: c21628e9c1 user: drh tags: subquery-limit-opt) | |
| 18:49 | Fix a missing comma in the previous check-in. (check-in: f3db02f490 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: 9a443397a6 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: 95141c6426 user: dan tags: ctime-refactor) | |
| 16:39 | Add extra test cases for sqlite3changeset_apply() and ALTER TABLE ADD COLUMN. (check-in: 603838fc9a user: dan tags: trunk) | |
| 09:59 | Version 3.18.2 (check-in: 036ebf729e 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: e1b7102908 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: bc1951d699 user: dan tags: ctime-refactor) | |
| 18:31 | Minor refactoring change to clarify how ATTACH works. No functional changes. (check-in: 3944a32e1d 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: 1169384934 user: drh tags: trunk) | |
| 13:41 | Version 3.18.1 (check-in: 77bb46233d 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: 20e5ffb1ce user: drh tags: branch-3.18) | |
|
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: 254617a1cc 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: ca1ff70780 user: drh tags: trunk) | |
| 15:06 | Merge the latest changes from trunk. (check-in: 60105c2253 user: drh tags: lsm-vtab) | |
| 13:07 | Fix harmless compiler warnings in the shell.c file (check-in: 9afd7a2ffd 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: c7f778b7ce 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: 48e086284a user: drh tags: trunk) | |
| 07:47 | Increase the version number to 3.18.1. (check-in: 4be2eba8c1 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: 43ad41efa9 user: drh tags: trunk) | |
|
2017-06-13
| ||
| 16:52 | Fix sqlite3rbu_close() so that the pzErrmsg parameter may be passed NULL. (check-in: c433672dd8 user: dan tags: trunk) | |
| 04:31 | Fix the processing of double-negatives in WHERE clause constraints with STAT4. Ticket [cfa2c908f2182] (check-in: 35b34bdf08 user: drh tags: trunk) | |
|
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: 30c50f0e06 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: 0bbdaf2801 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: 87aceb417a 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: 8f92b7a622 user: drh tags: trunk) | |
| 18:26 | Fix a potential null-pointer deference following OOM introduced by check-in [e39795d7] (unreleased). (check-in: a2f77285fa 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: 79544fc285 user: dan tags: begin-concurrent) | |
|
2017-06-09
| ||
| 15:14 | Merge enhancements and fixes from trunk. (check-in: 3fd050c343 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: 2881ab1ed2 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: 3168e2c92a 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: 8e311a6dba user: dan tags: begin-concurrent) | |
| 16:10 | Merge 3.19.3 changes with this branch. (check-in: e2d38d51a9 user: dan tags: begin-concurrent) | |
| 15:54 | Merge changes for version 3.19.0 with this branch. (check-in: 0f59bb94d5 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: 93f32dd2dd 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: 343e55992f user: drh tags: trunk) | |
| 14:26 | Version 3.19.3 (check-in: 0ee482a1e0 user: drh tags: release, version-3.19.3, branch-3.19) | |
| 11:32 | Fix an issue with OPT_FEATURE_FLAGS in configure.ac. (check-in: 97b5c4a53d user: drh tags: branch-3.19) | |
| 11:27 | Increase the version number to 3.19.3. (check-in: 903fff53b3 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: 9478106ca9 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: b30dfba811 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: e39795d7d7 user: drh tags: trunk) | |
| 19:46 | Fix another lsmtest build problem. Add the "-trans BOOLEAN" option to "lsmtest speed2". (check-in: 61853bc171 user: dan tags: lsm-vtab) | |
| 16:25 | Merge in trunk enhancements. (check-in: f8bbb608cb user: drh tags: prepare_v3) | |
| 15:55 | Add too/tserver.c - the implementation of a simple multi-threaded server designed for interactive testing of concurrency between connections used by different threads of the same process. (check-in: 05b4fc4340 user: dan tags: server-edition) | |
| 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: c81f260c2d 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: 802b82f342 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: 234ede26e3 user: drh tags: trunk) | |
| 16:14 | Fix a threading problem in lsm test code. (check-in: 501238b9fb 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: 9eea3670e7 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: 73c70590d7 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: f3c25df456 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: ed0842c156 user: drh tags: trunk) | |
| 10:31 | Omit some of the fstree tests in vtabH if the PWD contains LIKE wildcards. (check-in: ead29f9cb7 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: 65182ce041 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: c4089ffbdb user: drh tags: trunk) | |
| 18:27 | Remove unused header file from kvtest. (check-in: dd7e043f7c 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: f568f666c8 user: drh tags: trunk) | |
| 15:17 | Add the --nocheckpoint and --multitrans options to kvtest. (check-in: 5828633c23 user: drh tags: trunk) | |
|
2017-06-02
| ||
| 23:44 | Merge all recent trunk enhancements. (check-in: 1d23294d88 user: drh tags: lsm-vtab) | |
| 23:32 | Add the --fsync flag to kvtest, and document the --nosync flag. (check-in: 7fdc78a672 user: drh tags: trunk) | |
| 19:31 | Work toward enhancing kvtest to measure write performance. (check-in: fc73e7d2f1 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: ab33d299c7 user: drh tags: trunk) | |
| 13:16 | Fix a typo in the header comment of the "series.c" virtual table extension. (check-in: d637feb4e3 user: drh tags: trunk) | |
| 09:31 | Extend even further the logging designed to find problems in the pointer-map structure. Call abort() to dump a core as soon as such a problem is seen. (check-in: f131677dcb user: dan tags: begin-concurrent) | |
|
2017-06-01
| ||
| 16:13 | Add test code for LSM to the ext/lsm1/lsm-test directory. (check-in: bb7436e84a user: dan tags: lsm-vtab) | |
| 01:53 | Add a comment to the Lemon documentation regarding the security of the lemon.exe command-line tool. (check-in: 4c2458c190 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: 4a25c58833 user: drh tags: prepare_v3) | |
|
2017-05-31
| ||
| 17:30 | Add the SQLITE_STMTSTATUS_MEMUSED opcode to sqlite3_stmt_status() for finding the heap memory usage by a single prepared statement. (check-in: c26cf978ee user: drh tags: trunk) | |
| 17:06 | Generate extra log messages in response to irregularites in the pointer-map used by "BEGIN CONCURRENT" transactions. (check-in: f7e3e2bc88 user: dan tags: begin-concurrent) | |
| 16:21 | Add the SQLITE_STMTSTATUS_MEMUSED option for sqlite3_stmt_status() that reports the amount of heap memory used for a single prepared statement. (Closed-Leaf check-in: b57d510465 user: drh tags: stmtstatus-memused) | |
| 16:09 | Add the experimental "stmts" virtual table for introspection of prepared statements. (check-in: cb4c5c66ab user: drh tags: trunk) | |
| 13:45 | Avoid allocating excess memory to the KeyInfo objects. (check-in: df78594351 user: drh tags: trunk) | |
| 13:27 | Remove a completely unnecessary memset() from the INSERT code generator. (check-in: 7d58836b9d user: drh tags: trunk) | |
| 11:24 | Very small performance increase in sqlite3VdbeSetNumCols(). (check-in: 8885b44610 user: drh tags: trunk) | |
| 03:20 | Reorder fields in the PgHdr object for a performance increase. (check-in: 326e63d71e user: drh tags: trunk) | |
| 02:58 | Avoid unnecessary memory zeroing during expression list allocation. (check-in: de28e6514a user: drh tags: trunk) | |
| 00:49 | Size and performance optimizations to sqlite3ResolveExprNames(). (check-in: af8c0fed93 user: drh tags: trunk) | |
|
2017-05-30
| ||
| 18:34 | Change sqlite3BtreeNext() and sqlite3BtreePrevious() so that they return SQLITE_DONE if they have already reached the end (or beginning) of the table. This gives a performance increase and size reduction. (check-in: e972a38608 user: drh tags: trunk) | |
| 18:14 | Omit a test of codepoint 0x202F (non-break narrow space) from the fts3 ICU tests. Different versions of ICU apparently handle this obscure codepoint slightly differently. (check-in: 69ae688982 user: dan tags: trunk) | |
|
2017-05-29
| ||
| 22:44 | More efficient error handling and reset in the binding mechanism. (check-in: 9a3e3b34ba user: drh tags: trunk) | |
| 19:23 | Instead of a root page number, log the object (table or index) name if a page level locking conflict is detected. (check-in: 9ad846e57b user: dan tags: begin-concurrent) | |
| 17:59 | Omit unnecessary fstat() calls for determining the database file size, resulting in smaller and faster code. (check-in: dd61c73677 user: drh tags: trunk) | |
| 17:43 | Fix an issue with OPT_FEATURE_FLAGS in configure.ac. (check-in: 43ce3bd3a4 user: drh tags: trunk) | |
| 16:45 | Avoid unnecessary fstat() calls to determine the database size when transitioning into a read transaction on a rollback-mode database. (Closed-Leaf check-in: 6c3476b513 user: drh tags: io-opt) | |
| 14:57 | Avoid unnecessary calls to fstat() to determine the database file size. (check-in: c733a1dea3 user: drh tags: io-opt) | |
| 14:30 | Fix a typo in a comment. No code changes. (check-in: cb29b83888 user: drh tags: trunk) | |
| 14:27 | Enhance the log messages emitted when a page conflict is detected. (check-in: 92618492b0 user: dan tags: begin-concurrent) | |
| 14:26 | Optimizations to the Walker object and its methods to make the code a little smaller and to help it run a little faster. (check-in: 6854a34ed7 user: drh tags: trunk) | |
| 13:09 | Correctly initialize the iSelectId of FROM clause terms that are a self join of a reused materialized subquery. Without this, the EXPLAIN QUERY PLAN output for the query will identify the subquery using the uninitialized (and arbitrary) iSelectId. (check-in: 43c9ae371f user: drh tags: trunk) | |
| 03:48 | Improve shell help text for the '.open' command. (check-in: 7cc940a97e user: mistachkin tags: trunk) | |
|
2017-05-27
| ||
| 22:42 | Smaller and faster vdbeSorterCompareText(). (check-in: 542dc4c5eb user: drh tags: trunk) | |
| 18:05 | Add debugging functions btreePageOriginFile() and btreePageOriginOffset(). (Leaf check-in: 214d238a47 user: dan tags: btree-debug) | |
|
2017-05-26
| ||
| 18:18 | Adjust the bitvec related sqlite3_log messages added by [9527089b]. (check-in: a7e0e7a483 user: dan tags: begin-concurrent) | |
| 16:51 | Add extra test cases for deferred page allocation. (check-in: 9df0195780 user: dan tags: begin-concurrent) | |
| 16:15 | Fix a problem with deferred page allocation in transactions that revert page allocations by savepoint rollbacks. (check-in: a4a3bbe646 user: dan tags: begin-concurrent) | |
|
2017-05-25
| ||
| 21:35 | Small performance increase and size decrease in the btreeInitPage() routine. (check-in: 6f415833e0 user: drh tags: trunk) | |
| 21:02 | Fix a problem with the deferred page allocation on this branch that could occur when the database file is just slightly smaller than the PENDING_BYTE page offset. (check-in: 47a7dd9235 user: dan tags: begin-concurrent) | |
| 17:36 | Merge all fixes from the 3.19.2 release. (check-in: 12964240f1 user: drh tags: apple-osx) | |
| 17:27 | Merge the LEFT JOIN query flattener fixes from 3.19.2. (check-in: 6513e4a121 user: drh tags: trunk) | |
| 16:50 | Version 3.19.2 (check-in: edb4e819b0 user: drh tags: release, version-3.19.2, branch-3.19) | |
| 11:39 | The SQLITE_EXTRA_IFNULLROW compile-time option causes OP_IfNullRow opcodes to be issued for references to the right-hand side table of *any* flattened join, not just LEFT JOINs. This puts extra stress on the OP_IfNUllRow opcodes for testing purposes. (check-in: 1a074c8a2b user: drh tags: branch-3.19) | |
| 00:28 | The TK_IF_NULL_ROW expression node must be treated as a variable that references the table Expr.iTable. Proposed fix for ticket [7fde638e94287d2c]. (check-in: b30a364a12 user: drh tags: branch-3.19) | |
| 00:12 | Increase the version number to 3.19.2 since ticket [7fde638e94287d2] is going to necessitate another patch release. (check-in: c315727acd user: drh tags: branch-3.19) | |
| 00:08 | The TK_IF_NULL_ROW expression node must be treated as a variable that references the table Expr.iTable. Proposed fix for ticket [7fde638e94287d2c]. (check-in: 77fc23013c user: drh tags: trunk) | |
|
2017-05-24
| ||
| 15:32 | Fix harmless compiler warnings in FTS5. (check-in: 57a60e959c user: mistachkin tags: trunk) | |
| 13:08 | Version 3.19.1 (check-in: f6d7b988f4 user: drh tags: release, version-3.19.1, branch-3.19) | |
| 04:32 | Fix a problem in STAT4 equality estimation for multi-column indexes introduced by check-in [3e0590dee0e68cc1599]. (check-in: 19dad0a720 user: drh tags: branch-3.8.9) | |
| 04:18 | Fix a problem in STAT4 equality estimation for multi-column indexes introduced by check-in [3e0590dee0e68cc1599]. (check-in: cfb0d9e020 user: drh tags: trunk) | |
|
2017-05-23
| ||
| 20:00 | Remove the msvc.h header file from the autoconf tarball. (check-in: 84996aef68 user: drh tags: trunk) | |
| 19:35 | Do not use strcpy() in the (obsolete) amatch extension. In releasetest.tcl, run Apple tests using -Os instead of -O1 (check-in: 4440e42031 user: drh tags: trunk) | |
| 19:23 | Add experimental new API sqlite3_wal_info(). (check-in: 5b9d498f6e user: dan tags: begin-concurrent) | |
| 15:33 | Disable the LEFT JOIN flattening optimization for aggregate queries, as it does not currently work. Further fix for ticket [cad1ab4cb7b0fc344]. (check-in: 05ada74155 user: drh tags: branch-3.19) | |
| 15:21 | Disable the LEFT JOIN flattening optimization for aggregate queries, as it does not currently work. Further fix for ticket [cad1ab4cb7b0fc344]. (check-in: 44b21e35c9 user: drh tags: trunk) | |
| 12:44 | Ensure that the expression rewriter inside the query flattener decends into the substructure of the TK_IF_NULL_ROW operator. This is a continuation of the fix for ticket [cad1ab4cb7b0fc344]. (check-in: 28d2902d8f user: drh tags: branch-3.19) | |
| 12:36 | Ensure that the expression rewriter inside the query flattener decends into the substructure of the TK_IF_NULL_ROW operator. This is a continuation of the fix for ticket [cad1ab4cb7b0fc344]. (check-in: 941d8142b7 user: drh tags: trunk) | |
| 01:35 | Change the version number to 3.19.1. (check-in: 16656b8ff5 user: drh tags: branch-3.19) | |
| 01:30 | Remove a surplus semicolon, which was harmless on gcc and clang but caused compile-time errors on msvc. This only comes up using the encryption extension. (check-in: 4510d55d1e user: drh tags: branch-3.19) | |
| 01:29 | When flattening a query, make sure iTable attribute of TK_IF_NULL_ROW operators (that result from a prior flattening of a LEFT JOIN) are updated correctly. Fix for ticket [cad1ab4cb7b0fc344]. (check-in: 919d36e6ea user: drh tags: branch-3.19) | |
| 01:21 | When flattening a query, make sure iTable attribute of TK_IF_NULL_ROW operators (that result from a prior flattening of a LEFT JOIN) are updated correctly. Fix for ticket [cad1ab4cb7b0fc344]. (check-in: 92c178507d user: drh tags: trunk) | |
| 00:32 | Remove a surplus semicolon, which was harmless on gcc and clang but caused compile-time errors on msvc. This only comes up using the encryption extension. (check-in: 987a2b5537 user: drh tags: trunk) | |
|
2017-05-22
| ||
| 19:24 | Pull in all changes from the 3.19.0 release. (check-in: bbd2d0e140 user: drh tags: apple-osx) | |
| 18:09 | Fix incompatibilities between the "sqldiff --changeset" command and the sessions module. Specifically, allow sessions to process changesets containing tables with zero operations on them and have sqldiff output the expected output for tables with multi-column primary keys. (check-in: 0bb23c4806 user: dan tags: trunk) | |
| 18:00 | Add the ".cd" command to the command-line shell. (check-in: 5fe28e15b1 user: drh tags: trunk) | |
| 17:39 | Increase the version number to 3.20 for the next release cycle. (check-in: ab471f61ef user: drh tags: trunk) | |
| 14:04 | Merge the last-minute 3.19.0 changes into trunk. (check-in: e6ba2a93a8 user: drh tags: trunk) | |
| 13:58 | Version 3.19.0 (check-in: 28a94eb282 user: drh tags: release, version-3.19.0, branch-3.19) | |
| 13:06 | Include the "msvc.h" header file in the amalgamation tarball. (check-in: 3dd6fe53c7 user: drh tags: branch-3.19) | |
| 08:04 | Fix a case where NULL was being passed to memcmp() following an OOM. This is probably not a real problem, as the number-of-bytes parameter was passed 0 in this case, but it was causing a santizer complaint. (check-in: 3ea2bad27e user: dan tags: trunk) | |
| 08:01 | Add code to this branch to emit a log message after each cumulative second that the WRITER lock has been held. (check-in: a726d98122 user: dan tags: server-edition) | |
| 00:45 | When planning a query using sorting, resolve ties in the solver by selecting loop plans with the smaller unsorted cost. (check-in: f261678c90 user: drh tags: trunk) | |
| 00:27 | When planning a query using sorting, resolve ties in the solver by selecting loop plans with the smaller unsorted cost. (check-in: 962531e7c1 user: drh tags: branch-3.8.9) | |
|
2017-05-19
| ||
| 23:04 | Prevent a possible NULL pointer dereference in the OP_Found opcode that can follow an OOM error. Problem found by OSS-Fuzz. (check-in: 50ad60ded5 user: drh tags: branch-3.19) | |
| 22:51 | Prevent a possible NULL pointer dereference in the OP_Found opcode that can follow an OOM error. Problem found by OSS-Fuzz. (check-in: c2de178fe7 user: drh tags: trunk) | |
| 20:55 | Improved comments on one routine in the query planner. Improved diagnostic output for ".wheretrace". No production code changes. (check-in: 946b87a528 user: drh tags: trunk) | |
| 20:47 | Fix a documentation typo. No changes to code. (check-in: 68942a4fee user: drh tags: trunk) | |
| 20:46 | Branch for the 3.19 release. (check-in: f2b829ec52 user: drh tags: branch-3.19) | |
| 19:57 | Invoke sqlite3_log() in response to irregularities surrounding the Pager.pAllRead bit-vector. (check-in: 9527089b7a user: dan tags: begin-concurrent) | |
| 12:32 | Fix some problems in fts5 code detected by -fsanitize=undefined. (check-in: 35f721045d user: dan tags: trunk) | |
|
2017-05-18
| ||
| 20:47 | Fix a problem on this branch causing some page-level read-locks to be omitted. (check-in: 0eed152162 user: dan tags: begin-concurrent) | |