Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
126 check-ins for the month beginning 2020-05-01
Following month ↑|
2020-05-30
| ||
| 15:34 | Draw the dashes below the headers in "explain" mode in the CLI. (check-in: c6b7833ac7 user: drh tags: trunk) | |
| 00:30 | Improved VDBE comments on the ANALYZE code generator. This change also fixes a harmless use of an uninitialized integer variable as an input to the %d format on a VDBE comment. (check-in: 1cb248a3fc user: drh tags: trunk) | |
|
2020-05-29
| ||
| 21:06 | Enhancements to the incremental build support for MSVC. (check-in: 2e25d915bc user: mistachkin tags: trunk) | |
| 20:16 | Remove a stray "&" character in the CLI, detected by a clang warning. (check-in: 5865d2f2d0 user: drh tags: trunk) | |
| 19:45 | Add the "shelltest" target to the MSVC makefile as well. (check-in: 9924c0456b user: drh tags: trunk) | |
| 19:39 | Fix the ".import" command of the CLI to clean up better after errors. Add the new "shelltest" makefile target on unix platforms. (check-in: 50d4ddf133 user: drh tags: trunk) | |
| 19:17 | Improvements to help text for the CLI. (check-in: 6a01e4c444 user: drh tags: trunk) | |
| 19:03 | Fix a memory leak in the CLI when an unknown or unrecognized argument is given to the ".dump" command. (check-in: 71bfbbcc1a user: drh tags: trunk) | |
| 16:15 | Improvements to columnar output in the CLI. Columns automatically expand to contain the largest row. (check-in: 4e1db8e9a9 user: drh tags: trunk) | |
| 14:38 | Space to hold the ".width" of columns in the CLI is now obtained from malloc() and hence is not limited in the number of columns supported. (check-in: 445ed5dab2 user: drh tags: trunk) | |
| 12:31 | Incremental improvements to tabular output modes in the CLI. The "markdown" and "table" modes no have headers turned on by default. (check-in: af28bff91a user: drh tags: trunk) | |
| 11:07 | Expand upon a comment in os_unix.c. No changes to code. (check-in: 77933dc4db user: dan tags: trunk) | |
| 00:21 | In the json output mode of the CLI, do correct quoting of escape characters. Also, show BLOBs as JSON strings, possibly with embedded \u0000 bytes. (check-in: 0278147a7d user: drh tags: trunk) | |
|
2020-05-28
| ||
| 23:49 | Progress toward adding new output modes to the CLI: json, table, and markdown. (check-in: 14f55fafec user: drh tags: trunk) | |
| 20:37 | Enhance the ".quote" mode in the shell so that it honors .separator. (check-in: b5e33ed537 user: drh tags: trunk) | |
| 00:45 | When the sqlite_stat1 data is missing for some indexes of a table but is present for the table itself or for other indexes in the same table, then do not let the estimated number of rows in that table get too small, as doing so can deceive the query planner into ignoring a perfectly good index. (check-in: 98d4262018 user: drh tags: trunk) | |
|
2020-05-27
| ||
| 12:44 | Small performance improvement and size reduction in the expression code generator. (check-in: eeb53e2195 user: drh tags: trunk) | |
| 00:02 | Change a datatype from i16 to int to appease Converity and help eliminate a false-positive. (check-in: 5b560ec490 user: drh tags: trunk) | |
|
2020-05-26
| ||
| 20:33 | Fix the cksumvfs extension so that it will not register itself more than once. (check-in: d5cdd57150 user: drh tags: trunk) | |
| 20:31 | Performance optimization in the transfer of error messages from statements to connections. (check-in: 0e898f4fed user: drh tags: trunk) | |
| 11:23 | Increase the version number to 3.33.0 to begin the next release cycle. (check-in: 790badb390 user: drh tags: trunk) | |
| 11:10 | Changes to sqlite3SelectNew() to work around a false-positive warning from GCC-10. The code is very slightly larger and slower as a result. (check-in: 04e1edd8e5 user: drh tags: trunk) | |
| 10:54 | Innocuous changes to help Coverity avoid false-positives. (check-in: 4ec8a5a203 user: drh tags: trunk) | |
|
2020-05-25
| ||
| 18:18 | Merge version 3.32.1 into the begin-concurrent-pnu-wal2 branch. (check-in: 0f9464c509 user: drh tags: begin-concurrent-pnu-wal2) | |
| 18:09 | Merge version 3.32.1 into the wal2 branch. (check-in: 5c18375725 user: drh tags: wal2) | |
| 18:03 | Merge versoin 3.32.1 into the begin-concurrent-pnu branch. (check-in: e8d79d2bae user: drh tags: begin-concurrent-pnu) | |
| 17:27 | Merge version 3.32.1 into the begin-concurrent branch. (check-in: 5e08e36067 user: drh tags: begin-concurrent) | |
| 16:34 | Update the reuse-schema branch to version 3.32.1 (check-in: ecf8dece03 user: drh tags: reuse-schema) | |
| 16:19 | Version 3.32.1 (check-in: 0c1fcf4711 user: drh tags: trunk, release, version-3.32.1) | |
| 15:41 | Extra assert() statements in the printf() logic. (check-in: b1b182be2a user: drh tags: trunk) | |
| 15:19 | Defensive code that tries to prevent a recurrence of problems like the one described in ticket [7a5279a25c57adf1] (check-in: 572105de1d user: drh tags: trunk) | |
| 12:49 | Fix minor compile issues with optional extensions. (check-in: 3261ee9ec2 user: drh tags: trunk) | |
| 12:02 | Make sure variable declarations are at start of scope even when SQLITE_ENABLE_SNAPSHOT is used. (check-in: a77ceaf6ba user: drh tags: trunk) | |
| 01:31 | Attempt to work around a false-positive warning in the CGo compiler. (Closed-Leaf check-in: d4bf60f464 user: drh tags: cgo-warning-workaround) | |
|
2020-05-24
| ||
| 12:36 | Version number to 3.32.1. (check-in: 56e5063c32 user: drh tags: trunk) | |
| 03:38 | When rewriting a query for window functions, if the rewrite changes the depth of TK_AGG_FUNCTION nodes, be sure to adjust the Expr.op2 field appropriately. Fix for ticket [7a5279a25c57adf1] (check-in: ad7bb70af9 user: drh tags: trunk) | |
| 03:01 | Move some utility Walker callbacks into the walker.c source file, as they seem to belong there better. (check-in: dac438236f user: drh tags: trunk) | |
| 02:05 | Improvements to parse-tree tracing logic. No changes in deliverable code. (check-in: f7e5a68a7e user: drh tags: trunk) | |
| 00:30 | Minor fix to a comment. No code changes. (check-in: efdbb2b499 user: drh tags: trunk) | |
|
2020-05-23
| ||
| 19:58 | Limit the "precision" of floating-point to text conversions in the printf() function to 100,000,000. Fix for ticket [23439ea582241138]. (check-in: d08d340587 user: drh tags: trunk) | |
| 17:56 | Improved bytecode comment. (check-in: 9224f1543b user: drh tags: trunk) | |
|
2020-05-22
| ||
| 18:41 | Merge version 3.32.0 into the reuse-schema branch. (check-in: 31706878c3 user: drh tags: reuse-schema) | |
| 18:35 | Merge version 3.32.0 into the begin-concurrent-pnu-wal2 branch. (check-in: 3cb296065a user: drh tags: begin-concurrent-pnu-wal2) | |
| 18:28 | Merge version 3.32.0 into the wal2 branch. (check-in: 1cb46a7431 user: drh tags: wal2) | |
| 18:17 | Merge the 3.32.0 release into the begin-concurrent-pnu branch. (check-in: 79663e6612 user: drh tags: begin-concurrent-pnu) | |
| 18:09 | Merge the 3.32.0 release into the begin-concurrent branch. (check-in: 79ad4ea2c8 user: drh tags: begin-concurrent) | |
| 17:46 | Version 3.32.0 (check-in: 5998789c9c user: drh tags: trunk, release, version-3.32.0) | |
|
2020-05-21
| ||
| 20:38 | Change a NEVER macro into a NO_TEST comment, as the conditional is reachable, but only when compiling for Windows 32-bit. (check-in: ce36b6d133 user: drh tags: trunk) | |
| 19:13 | Avoid another potential OOB read in sqlite3expert.c. (check-in: 0ccea80092 user: dan tags: trunk) | |
|
2020-05-20
| ||
| 15:02 | Back out the change from [7fab1393c2b22b1f] that tries to convert invalid surrogate characters in UTF16 into the replacement character 0xfffd, as we find that this breaks some software. (check-in: 4218c7b71f user: drh tags: trunk) | |
|
2020-05-19
| ||
| 15:51 | Add compiler hints to disable TSAN for the routines that access the -shm file header in WAL mode using a double-read with memory barrier. (check-in: 3117c1b5a9 user: drh tags: trunk) | |
| 15:40 | In os_win.c, avoid calling sqlite3_uri_boolean() on anything other than a main-db filename. (check-in: cb0a18e64f user: dan tags: trunk) | |
| 12:29 | User-suggested improvement to the README.txt for the ICU extension. (check-in: 1d1293c25a user: drh tags: trunk) | |
| 12:27 | In wal.c, improved comments on concurrency issues. More use of AtomicLoad() and AtomicStore(). (check-in: 4bf566feca user: drh tags: trunk) | |
|
2020-05-18
| ||
| 19:55 | Merge latest trunk changes into this branch. (check-in: 5dc355ccf6 user: dan tags: begin-concurrent-pnu-wal2) | |
| 19:11 | Bring the reuse-schema branch up to date with the latest trunk changes. (check-in: d8ea0cb69d user: drh tags: reuse-schema) | |
| 18:02 | Add vdbevtab.lo to build of libsqlite3.lib in Makefile.msc. (check-in: f64d054b79 user: dan tags: trunk) | |
| 17:18 | Merge latest trunk changes into this branch. (check-in: 16b1eca922 user: dan tags: wal2) | |
| 16:19 | Merge recent changes from trunk. (check-in: c69f030b1e user: drh tags: begin-concurrent-pnu) | |
| 15:41 | Merge latest trunk changes into this branch. (check-in: 9e4a7b3ed8 user: dan tags: begin-concurrent) | |
|
2020-05-17
| ||
| 13:47 | Avoid harmless UB in memcpy() in the JSON extension. (check-in: 69e149f768 user: drh tags: trunk) | |
| 00:26 | Use the sqlite3Realloc() interface internally, rather than the public sqlite3_realloc64() equivalent, to avoid unnecessary calls to sqlite3_initialize(). (check-in: 1313557b51 user: drh tags: trunk) | |
|
2020-05-16
| ||
| 21:01 | Performance optimization for the sqlite3FindTable() subroutine. (check-in: 55910b9a72 user: drh tags: trunk) | |
| 19:00 | Merge trunk enhancements in the reuse-schema branch. (Actual date of this check-in is 2020-05-18.) (check-in: 5af4abe98c user: drh tags: reuse-schema) | |
| 18:01 | The OP_RealAffinity opcode is not necessary after reading values from a virtual table (such as rtree). It is harmless, but it does use CPU cycles. Might as well leave it off. (check-in: dc18d89354 user: drh tags: trunk) | |
| 17:26 | Fix a use-after-free bug in the fts3 snippet() function. (check-in: 0d69f76f08 user: dan tags: trunk) | |
| 16:23 | Extra memory barrier during initialization. (check-in: 043a7e142d user: drh tags: trunk) | |
| 15:18 | Add sqlite3BeginBenignMalloc() and EndBenignMalloc() calls to debugging function sqlite3VdbePrintOp(). (check-in: 6f857d0e9e user: dan tags: trunk) | |
|
2020-05-15
| ||
| 18:48 | Update code in sqlite3expert.c to account for the fact that "-- TRIGGER xyz" VM comments are now omitted for some builds. (check-in: 7cf93dc55c user: dan tags: trunk) | |
| 16:19 | Fix another build problem for SQLITE_OMIT_VIRTUALTABLE builds. (check-in: 5e1eb0fa3a user: dan tags: trunk) | |
| 16:05 | Fix a documentation typo. No changes to code. (check-in: 758353c726 user: drh tags: trunk) | |
| 15:03 | Adjust some requirement marks. No changes to code. (check-in: 7285ae2ce8 user: drh tags: trunk) | |
| 13:52 | Update test file e_fkey.test to account for the fact that new columns with REFERENCE clauses and non-NULL default values may now be added using ALTER TABLE if the table is empty. (check-in: 4087fce972 user: dan tags: trunk) | |
| 11:36 | Fix SQLITE_OMIT_VIRTUALTABLE testfixture builds. (check-in: 3d9780c5f6 user: dan tags: trunk) | |
| 11:26 | Test script changes to account for the fact that the "p5" column in the EXPLAIN output is now an integer, not a text values containing a 2-digit hex value. (check-in: 102126d808 user: dan tags: trunk) | |
| 01:18 | Enhancements to long-path support in the Win32 VFS. (check-in: 0119d96dec user: mistachkin tags: trunk) | |
| 01:13 | Move some new test cases from fts3snippet.test into fts3snippet2.test. (check-in: fa20399994 user: drh tags: trunk) | |
| 01:02 | Add the SQLITE_ENABLE_FTS3_PARENTHESIS option to fuzzcheck. Add a new test case that uses that option. (check-in: c49a33db95 user: drh tags: trunk) | |
|
2020-05-14
| ||
| 23:59 | Fix a null pointer deference that can occur on a strange matchinfo() query. (check-in: a4dd148928 user: drh tags: trunk) | |
| 21:16 | Do not allow a virtual table to be renamed into the name of one of its shadows. (check-in: eca0ba2cf4 user: drh tags: trunk) | |
|
2020-05-13
| ||
| 18:03 | Implement the IIF(x,y,z) SQL function that is short-hand for "CASE WHEN x THEN y ELSE z END". For compatibility with SQL Server. (check-in: fce173cd21 user: drh tags: trunk) | |
| 17:26 | Remove unused constant SQLITE_FUNC_COALESCE. (check-in: a116b20f86 user: drh tags: trunk) | |
| 13:33 | Use AtomicStore() and AtomicLoad() in a few more places to avoid a theoretically undefined behaviour. This is not actually problem on any known hardware. (check-in: fda57d4d2f user: dan tags: trunk) | |
|
2020-05-11
| ||
| 11:11 | New test case in test/fuzzdata8.db. (check-in: fa11230135 user: drh tags: trunk) | |
| 10:55 | Fix a problem handling constant integer expressions with collation sequences in PARTITION BY clauses. (check-in: 155e6649ef user: dan tags: trunk) | |
|
2020-05-08
| ||
| 19:02 | Release some restrictions on columns added by ALTER TABLE so that they only apply if the table contains one or more rows. (check-in: 3a16c0ce4d user: drh tags: trunk) | |
| 18:22 | Fix the count-optimization so that it honors the NOT INDEXED clause. (check-in: 0d23a0b209 user: drh tags: trunk) | |
| 15:28 | New test cases added to test/fuzzdata8.db. (check-in: 3fce9711a4 user: drh tags: trunk) | |
| 10:44 | Do not retry on a failed realloc() unless SQLITE_ENABLE_MEMORY_MANAGEMENT is available, meaning that the retry has some possibility of success. (check-in: e9a8f910b5 user: drh tags: trunk) | |
|
2020-05-07
| ||
| 19:55 | Fix a failing assert() in fts3 triggered by a corrupt database. (check-in: cb299a090c user: dan tags: trunk) | |
| 14:39 | Changes to avoid deadlock in SQLITE_ENABLE_SETLK_TIMEOUT builds. (check-in: 652e4b23ff user: dan tags: trunk) | |
| 14:26 | Fix an error that could occur if the first transaction executed by a connection configured to use blocking locks is a write-transaction for which the WRITER lock cannot be obtained. (Closed-Leaf check-in: 49e4dc72f7 user: dan tags: setlk-deadlock-changes) | |
| 14:05 | Merge trunk changes into this branch. (check-in: ac4ee69664 user: dan tags: setlk-deadlock-changes) | |
| 01:56 | Fix the handling of reserve-bytes so that the maximum value of 255 can be used. (check-in: 99749d4fd4 user: drh tags: trunk) | |
|
2020-05-06
| ||
| 21:25 | Avoid leaking a file-handle in test file walsetlk.test. (check-in: 3cfc675e2e user: dan tags: setlk-deadlock-changes) | |
| 21:24 | Fix an assert() failure that could follow an IO error. (check-in: e89c864299 user: dan tags: setlk-deadlock-changes) | |
| 20:55 | Fix harmless compiler warnings. (check-in: 92dc59132f user: drh tags: setlk-deadlock-changes) | |
| 20:45 | Fix a problem preventing building without SQLITE_ENABLE_SETLK_TIMEOUT defined. (check-in: 98eb54c6d8 user: dan tags: setlk-deadlock-changes) | |
| 20:27 | Add error code SQLITE_BUSY_TIMEOUT, used internally by the OS layer to indicate that a call to xShmLock() has failed due to timeout of a blocking lock. (check-in: f3ef9c7c2b user: dan tags: setlk-deadlock-changes) | |
| 19:22 | Fix compiler warnings in non-SQLITE_ENABLE_SETLK_TIMEOUT builds. (check-in: 22de99ef41 user: dan tags: setlk-deadlock-changes) | |
| 19:14 | Block on the WRITER lock when attempting to run recovery. (check-in: 105d6c9bbc user: dan tags: setlk-deadlock-changes) | |
| 18:46 | Provide the SQLITE_DEFAULT_LEGACY_ALTER_TABLE compile-time option. (check-in: b2325a6e1c user: drh tags: branch-3.28) | |
| 18:43 | Provide the SQLITE_DEFAULT_LEGACY_ALTER_TABLE compile-time option. (check-in: 63e659d9a7 user: drh tags: trunk) | |
| 17:18 | Add tests for running recovery when opening a write transaction or performing a checkpoint with blocking locks enabled. Fix some failing assert() statements. (check-in: d096ea3fe2 user: dan tags: setlk-deadlock-changes) | |
| 15:07 | Merge latest trunk changes into this branch. (check-in: a3727dba10 user: dan tags: setlk-deadlock-changes) | |
|
2020-05-05
| ||
| 20:30 | Unless upgrading an existing read transaction, have ENABLE_SETLK_TIMEOUT builds attempt to use a blocking lock when opening a write transaction on a wal mode database. (check-in: d6f819a9e6 user: dan tags: setlk-deadlock-changes) | |
| 19:54 | The only known path to a corruption detection branch was cut off by the previous commit implementing earlier index corruption. So make the branch NEVER. Maybe a fuzzer will find a new path. (check-in: 9a84d8eb44 user: drh tags: trunk) | |
| 18:42 | Earlier detection of index corruption caused by missing index entries. (check-in: f339f31f9e user: drh tags: trunk) | |
| 13:41 | Fix a compiler warning in cksumvfs.c. (check-in: 68033bcade user: drh tags: trunk) | |
|
2020-05-04
| ||
| 19:52 | Fix harmless compiler warnings. (check-in: 8eee591d3c user: drh tags: trunk) | |
| 19:42 | Changes to avoid deadlock in SQLITE_ENABLE_SETLK_TIMEOUT builds. (check-in: 553423c231 user: dan tags: setlk-deadlock-changes) | |
| 19:04 | Minor change to the sqlite_stmt virtual table, for test coverage. (check-in: 838987b209 user: drh tags: trunk) | |
| 17:15 | Simplify the initialization of built-in extensions. (check-in: 729f239735 user: drh tags: trunk) | |
| 11:47 | Ensure that the master-journal name is in a form suitable to be passed into sqlite3_uri_parameter(). (check-in: d1ba026d88 user: drh tags: trunk) | |
|
2020-05-02
| ||
| 04:08 | Add the SQLITE_FCNTL_CKPT_START file-control and use it to optimize the cksumvfs extension. (check-in: efdecb1309 user: drh tags: trunk) | |
| 03:46 | Add support for PRAGMA analyze_limit and approximate analysis. (check-in: 812547525d user: drh tags: trunk) | |
| 03:29 | Add a missing VdbeCoverage() macro. (Closed-Leaf check-in: 77a55c394d user: drh tags: approximate-analyze) | |
| 00:31 | Merge the bytecode and tables_used table-valued functions. Requires -DSQLITE_ENABLE_BYTECODE_VTAB at compile-time. (check-in: d09bcce37f user: drh tags: trunk) | |
| 00:01 | Corner-case changes to the bytecode virtual table for testability and correctness. (Closed-Leaf check-in: baa720e4a8 user: drh tags: bytecode-function) | |
|
2020-05-01
| ||
| 18:58 | Merge recent enhancements from trunk. (check-in: 96dfc71ea5 user: drh tags: bytecode-function) | |
| 18:43 | Fix problems with UPDATE...FROM statements that modify rowid or primary-key values. (check-in: 623ab585d1 user: dan tags: update-from) | |
| 18:37 | Add the SQLITE_FCNTL_CKPT_START file-control. Use it to optimize the cksumvfs extension. (Closed-Leaf check-in: b40f5aa344 user: drh tags: ckpt-start-fcntl) | |
| 15:04 | Merge recent trunk enhancements. (check-in: 2100b2c8f3 user: drh tags: approximate-analyze) | |
| 13:45 | Clarification to the sqlite3_uri() family of interfaces. Documentation enhancement only - no changes to code. (check-in: 853703cd6d user: drh tags: trunk) | |
| 13:32 | Update documentation for sqlite3_close_v2() for clarity. No functional changes. (check-in: 80498b69ea user: drh tags: trunk) | |
| 11:31 | Add the new SQLITE_IOERR_DATA result code and use it in cksumvfs. Also enhance cksumvfs to emit an sqlite3_log() message whenever it finds an invalid checksum. (check-in: a094e8bfde user: drh tags: trunk) | |