Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
72 events for the month beginning 2022-08-01 by user drh
Following month ↑|
2022-08-31
| ||
| 15:04 | Enhance the b-tree page sorting code to ensure that sqlite3PagerRekey() never overloads a page number and uses only the PENDING_BYTE page for temporary storage. (check-in: 50077428 user: drh tags: trunk) | |
| 14:43 | • Edit [984a07d7f171e03a|984a07d7]: Move to branch mistake. Mark "Closed". Edit check-in comment. (artifact: 838cf12a user: drh) | |
| 14:40 | Do not attempt the OP_Count optimization on queries with HAVING clauses. This fixes a problem exposed by [2cf373b10c9bc4cb]. (check-in: 5f93239a user: drh tags: branch-3.39) | |
| 00:44 | Checked in the wrong change by mistake. (Closed-Leaf check-in: 984a07d7 user: drh tags: mistake) | |
|
2022-08-30
| ||
| 16:54 | Improved comments in pcache1.c. No changes to code. (check-in: dd017bb1 user: drh tags: trunk) | |
| 14:13 | Any function call can abort. Take this into account when deciding if a DML statement needs a statement journal. See forum thread 9b9e4716c0d7bbd1 for more information. (check-in: 5bf4c5fd user: drh tags: branch-3.39) | |
| 13:16 | • Edit [f22f95b838873f1d|f22f95b8]: Edit check-in comment. (artifact: 37bfd2a3 user: drh) | |
| 13:14 | • Edit [e1f1cfe7f4387b60|e1f1cfe7]: Edit check-in comment. (artifact: 44ece0ef user: drh) | |
| 00:11 | Any function call can abort. Take this into account when deciding if a DML statement needs a statement journal. See forum thread 9b9e4716c0d7bbd1 for more information. (check-in: 5c95ae6c user: drh tags: trunk) | |
|
2022-08-27
| ||
| 16:11 | More assert() statements in the page cache. (check-in: 7c96a56c user: drh tags: trunk) | |
| 14:43 | Ensure that every pcache page always has either the PGHDR_DIRTY or the PGHDR_CLEAN bit set, even during transient page reshuffling during btree balancing. (check-in: e67f03c1 user: drh tags: trunk) | |
|
2022-08-26
| ||
| 13:53 | • Edit [b7b7bde9b7a03665|b7b7bde9]: Edit check-in comment. (artifact: 45901d86 user: drh) | |
|
2022-08-25
| ||
| 19:29 | Ensure that sqlite3_prepare() inputs always have a semicolon terminator in speedtest1. (check-in: c72756b0 user: drh tags: trunk) | |
| 19:19 | Add the --script option to speedtest1. (check-in: 1c87d7c5 user: drh tags: trunk) | |
| 18:29 | Fix the bytecode engine so that it is able to handle an incoming SQLITE_TOOBIG error, which is now possible using the statement cache. (check-in: 7763b98b user: drh tags: stmt-cache) | |
| 17:12 | Do not attempt to cache DDL statement. (check-in: 8f6a1f77 user: drh tags: stmt-cache) | |
| 15:09 | Improved documentation of new features. Minor speed enhancements. (check-in: da9aa547 user: drh tags: stmt-cache) | |
| 14:31 | Merge changes from trunk into the stmt-cache branch. (check-in: bc988ce7 user: drh tags: stmt-cache) | |
| 13:09 | If a perpared statement runs the Expire opcode, then disqualify it from being cached. (check-in: f27d919f user: drh tags: stmt-cache) | |
|
2022-08-24
| ||
| 23:50 | Change sqlite3_prepare_v3() to require SQLITE_PREPARE_CACHE in order for a statement to be a cache candidate. But any statement can pull from the cache. Also add statement cache control to the CLI. (check-in: c9dc536d user: drh tags: stmt-cache) | |
| 17:59 | Add a mutex to the sqlite3_db_config() interface so that it is threadsafe when two or more threads call it on the same database connection at the same time. (check-in: 459ad884 user: drh tags: trunk) | |
| 17:55 | First attempt at adding a built-in prepared statement cache. This is mostly working, but still has a few obscure faults. (check-in: c217b763 user: drh tags: stmt-cache) | |
|
2022-08-23
| ||
| 20:11 | Change the names of the Vdbe.pVNext and Vdbe.ppVPrev fields to make them unique. Change to ppVPrev to save a few bytes and a few CPU cycles. (check-in: 34b8ea31 user: drh tags: trunk) | |
| 17:51 | Enhance assert() statements to enforce tighter bounds on the P5 operand of the OP_Next and OP_Prev opcodes. (check-in: 4e0a07fc user: drh tags: trunk) | |
|
2022-08-22
| ||
| 16:30 | Merge recent trunk enhancements into the reuse-schema branch. (check-in: 9c05a48e user: drh tags: reuse-schema) | |
| 16:08 | Merge all recent trunk changes into the begin-concurrent-pnu-wal2 branch. (check-in: dde76e91 user: drh tags: begin-concurrent-pnu-wal2) | |
| 15:57 | Merge all recent trunk enhancements into the wal2 branch. (check-in: 0b7578bf user: drh tags: wal2) | |
| 15:48 | Merge all recent trunk enhancements into the begin-concurrent-report branch. (check-in: 2ec6e9e1 user: drh tags: begin-concurrent-report) | |
| 15:42 | Merge all recent trunk enhancements into the begin-concurrent branch. (check-in: 7eac6136 user: drh tags: begin-concurrent) | |
| 15:18 | Performance enhancement for sqlite3DbFree(). (check-in: c296a9d9 user: drh tags: trunk) | |
| 02:00 | Add the new internal interface sqlite3DbNNFreeNN(db,ptr) where both the db and ptr parameters are guaranteed to be non-NULL. Use this where appropriate to save more than 2 million CPU cycles on the standard performance test. (check-in: e5eaa80e user: drh tags: trunk) | |
|
2022-08-20
| ||
| 19:45 | Merge the test case for dbsqlfuzz 18fe4e257be7fa3ecfb0424ab7427e41e97ef9e3 assertion fault, which is fixed with the previous check-in. (check-in: 2d13ec08 user: drh tags: trunk) | |
| 19:33 | Enhance the enforcement of SQLITE_VTAB_DIRECTONLY so that it applies to DML statements within triggers. Do not allow DML stratements against virtual tables within triggers unless either the virtual table is SQLITE_VTAB_INNOCUOUS or PRAGMA trusted_schema is ON. (check-in: 9433ea40 user: drh tags: trunk) | |
|
2022-08-18
| ||
| 15:53 | Add notes to ext/wasm/README.md explaining how to run tests on a remote machine. (check-in: 7a3c444f user: drh tags: fiddle-opfs) | |
|
2022-08-17
| ||
| 20:18 | In the ".dump" command of the CLI, if a schema statement ends with an unterminated comment, try to terminate that comment prior to appending the ";" at the end. Forum post d7be961c5c. (check-in: 96e112da user: drh tags: trunk) | |
| 18:07 | Enhance the "PRAGMA integrity_check" statement so that it verifies the rows of a WITHOUT ROWID table are in the correct order. (check-in: 62f934bf user: drh tags: trunk) | |
| 17:14 | Minor code simplification in the code generator for PRAGMA integrity check. (check-in: a3b9c7a6 user: drh tags: trunk) | |
|
2022-08-16
| ||
| 17:18 | Change the legacy RC4-based PRNG to use the RFC-7539 chacha20 algorithm. (check-in: a0f80115 user: drh tags: trunk) | |
| 16:57 | Fix obsolete comments. Add new comments. Fix non-standard spacing. (Closed-Leaf check-in: a0d224c6 user: drh tags: chacha20-prng) | |
| 16:40 | Fix an off-by-one error in the ChaCha20 initialization code. (check-in: 72e220ee user: drh tags: chacha20-prng) | |
| 14:09 | Omit an unnecessary test case from corruptN.test that does not work with the new RFC-7539 PRNG. (check-in: d9e8c65e user: drh tags: chacha20-prng) | |
| 00:25 | • Edit [084d8776fa95c754|084d8776]: Edit check-in comment. (artifact: 223facc2 user: drh) | |
| 00:04 | Replace the RC4-based PRNG with one based on ChaCha20 (RFC 7539). 3x faster. (check-in: 084d8776 user: drh tags: chacha20-prng) | |
|
2022-08-15
| ||
| 18:36 | The new --script option to dbtotxt.c looks for an SQL script at the head of the file and generates a CLI script that will construct the database then run the SQL. (check-in: 6170e638 user: drh tags: trunk) | |
| 12:26 | In the documentation emphasize that the use of shared cache is discouraged. Fix test cases so that they all work with shared cache disabled. (check-in: 52c3ae06 user: drh tags: trunk) | |
| 10:38 | • Edit [26db4fc22fe66658|26db4fc2]: Edit check-in comment. (artifact: 0ab23d04 user: drh) | |
| 10:37 | • Edit [aab790a16e1bdff7|aab790a1]: Edit check-in comment. (artifact: 7082cadf user: drh) | |
|
2022-08-12
| ||
| 18:46 | Add the (undocumented) SQLITE_DEFAULT_UNIX_VFS compile-time option. (check-in: 49828bde user: drh tags: trunk) | |
|
2022-08-10
| ||
| 18:40 | Fix another harmless comment typo that causes a typo in the documentation. (check-in: bb084adb user: drh tags: trunk) | |
| 18:33 | Remove (harmless) duplicate words in comments used to generate parts of the documentation. forum post 54abbe9ccd (check-in: b5e4f0db user: drh tags: trunk) | |
| 17:03 | Merge the branch-3.28a fixes into branch-3.28. (check-in: ba6bf331 user: drh tags: branch-3.28) | |
|
2022-08-09
| ||
| 20:22 | Fix a rounding error caused by scalar->logarithm->scalar conversion when using stat4 data to estimate some range scans. (check-in: 68d86f2b user: drh tags: branch-3.28) | |
| 16:13 | Allow the name of an index to collide with a table in a different schema. (check-in: f963c252 user: drh tags: trunk) | |
| 14:28 | Omit the (undocumented) SQLITE_PCACHE_SEPARATE_HEADER compile-time option. (check-in: 60947da6 user: drh tags: trunk) | |
|
2022-08-08
| ||
| 16:25 | Avoid trying to cast an over-sized floating point value into an integer. (check-in: 3518cd7c user: drh tags: trunk) | |
| 13:04 | Remove an unreachable branch in the numericType() helper routine. (check-in: a99cc008 user: drh tags: trunk) | |
| 12:19 | Do not attempt to convert an oversized floating point value into an integer. (check-in: 6c4fc838 user: drh tags: trunk) | |
|
2022-08-05
| ||
| 19:37 | Avoid having fts3 read uninitialized values when processing deferred tokens. (check-in: 8e2bfe58 user: drh tags: branch-3.39) | |
|
2022-08-04
| ||
| 17:24 | • Edit [5e1db87cfa262deb|5e1db87c]: Edit check-in comment. (artifact: 6ad69ed0 user: drh) | |
| 17:17 | Fix a problem with the query optimizer for LIMIT/OFFSET queries when underlying query is a UNION ALL and both arms of the UNION ALL are subqueries with an ORDER BY clause. (check-in: 5e1db87c user: drh tags: branch-3.39) | |
| 17:15 | Fix a problem with the query optimizer for LIMIT/OFFSET queries when underlying query is a UNION ALL and both arms of the UNION ALL are subqueries with an ORDER BY clause. This bug was reported at forum post 6b5e9188f0657616. The problem was introduced in 2015 (SQLite version 3.9.0) by check-in [4b631364354068af]. See also ticket [b65cb2c8d91f6685]. (check-in: 6c806f64 user: drh tags: trunk) | |
| 14:02 | Fix a typo on a comment used to generate bytecode documentation. (check-in: 64348d0b user: drh tags: trunk) | |
|
2022-08-03
| ||
| 19:53 | Performance optimization to the math opcodes of the bytecode engine. (check-in: 597347d9 user: drh tags: trunk) | |
| 19:37 | Small performance increase on the binding interfaces. (check-in: aab24c37 user: drh tags: trunk) | |
| 17:27 | Improvement on the previous check-in. (check-in: 0d0c3111 user: drh tags: branch-3.39) | |
| 17:26 | Improvement on the previous check-in. (check-in: c1ab0ea2 user: drh tags: trunk) | |
| 16:04 | For an IN operator used with a RIGHT JOIN, use the number of terms in the vector, not the number of equality terms, to size the column map. dbsqlfuzz 14cfdad6ca45e607163f54049ddf5065183dc657. (check-in: 003e4eee user: drh tags: branch-3.39) | |
| 15:58 | For an IN operator used with a RIGHT JOIN, use the number of terms in the vector, not the number of equality terms, to size the column map. dbsqlfuzz 14cfdad6ca45e607163f54049ddf5065183dc657, CVE-2022-3195. This problem was injected by [a193749730d6cfba] which was part of the RIGHT JOIN enhancement for version 3.39.0. (check-in: b184c8d9 user: drh tags: trunk) | |
|
2022-08-01
| ||
| 13:22 | • Edit [a04dd475c2c8afdd|a04dd475]: Edit check-in comment. (artifact: 93477a2e user: drh) | |
| 13:17 | Bump the version number up to 3.39.3. (check-in: d0f7f22a user: drh tags: branch-3.39) | |
| 13:15 | In the xUpdate method of the GeoPoly virtual table, make sure that the number of updated columns does not exceed the underlying implementation, even if the virtual table object records an excess number of column in the nAux field due to table constraints in the table definition. Fix for the problem reported by forum post a096ab7d96bb057a. (check-in: a8ae7216 user: drh tags: branch-3.39) | |
| 13:14 | In the xUpdate method of the GeoPoly virtual table, make sure that the number of updated columns does not exceed the underlying implementation, even if the virtual table object records an excess number of column in the nAux field due to table constraints in the table definition. Fix for the problem reported by forum post a096ab7d96bb057a. A test case for this problem is in dbsqlfuzz. (check-in: a04dd475 user: drh tags: trunk) | |