Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
236 events for the month beginning 2020-01-01
Following month ↑|
2020-01-31
| ||
| 14:52 | Fix a minor typo in a comment in the btreeinfo extension. (check-in: b5a66d10 user: drh tags: trunk) | |
|
2020-01-29
| ||
| 23:19 | • Closed ticket [1dc432db]: FTS4 integrity-check results in "database disk image is malformed" for UTF-16 encoding plus 4 other changes (artifact: 10166d7b user: drh) | |
| 15:03 | Fix a problem with the processing of IN(...) constraints handled by virtual table implementations that do not set the "omit" flag when the virtual table column contains at least one NULL value. (check-in: dcb48387 user: dan tags: trunk) | |
| 13:56 | Add a test case for commit [ffd8bb93]. (check-in: bcd5b37b user: dan tags: trunk) | |
| 13:50 | Remove a NEVER() that is in fact reachable. Test cases in dbsqlfuzz and TH3. (check-in: ffd8bb93 user: drh tags: trunk) | |
| 13:10 | Add new memory barriers during initialization. (check-in: a9b2adc5 user: drh tags: trunk) | |
| 12:37 | Modify a couple of FTS test cases so that they work on big-endian platforms. (check-in: b20503aa user: drh tags: trunk) | |
| 10:10 | • Ticket [1dc432db] FTS4 integrity-check results in "database disk image is malformed" for UTF-16 encoding status still Open with 3 other changes (artifact: 68d922e4 user: mrigger) | |
|
2020-01-28
| ||
| 20:27 | Faster decoding of 32-bit variable-length integers in cases were we do not need to know the number of bytes in the encoding. (check-in: 59a31b16 user: drh tags: trunk) | |
| 20:09 | Small performance improvement to the key-comparision routine for strings. (check-in: 41454499 user: drh tags: trunk) | |
| 18:09 | Reinstate the optimization of converting "a IN (C)" into "a=C" but only if C is a constant. If the RHS is a table column, the complications of managing affinity and collations become too involved to mess with. (check-in: 8ac26a23 user: drh tags: trunk) | |
| 16:55 | Fix a 4 byte OOB read in test_multiplex.c. (check-in: 91214891 user: dan tags: trunk) | |
| 15:02 | Minor change for compatibility with the s390 architecture. (check-in: 04885763 user: drh tags: trunk) | |
|
2020-01-27
| ||
| 19:55 | Version 3.31.1 (check-in: 3bfa9cc9 user: drh tags: trunk, release, version-3.31.1) | |
| 17:09 | Update the version number to 3.31.1. (check-in: 6fb9a8fb user: drh tags: trunk) | |
| 14:53 | • Edit [34ab760689fd493e|34ab7606]: Edit check-in comment. (artifact: 6f0275e3 user: drh) | |
| 14:40 | Revise the layout of filenames in the Pager object so that it is unchanged from prior versions. It turns out that some important 3rd-party software does questionable pointer manipulations on those filenames that depend on that legacy layout. Technically, this is a misuse of SQLite by the 3rd-party software, but we want to avoid unnecessary breakage. (check-in: 34ab7606 user: drh tags: trunk) | |
|
2020-01-23
| ||
| 15:00 | Fix typos in the sqlite3ext.h header file that prevent some newer APIs from being accessed from loadable extensions. (check-in: 14331989 user: drh tags: trunk) | |
| 00:08 | Fix variable declaration issue seen with MSVC. (check-in: 8a6fe306 user: mistachkin tags: trunk) | |
|
2020-01-22
| ||
| 23:13 | • Fixed ticket [b985f0bd]: Assertion `0' failed in sqlite3IsLikeFunction plus 6 other changes (artifact: 076ee1f8 user: drh) | |
| 23:08 | Fix a NEVER() macro that can be true if compiled with SQLITE_ENABLE_UNKNOWN_SQL_FUNCTION. Ticket [b985f0bd1636d9bc] (check-in: 9f0f5d59 user: drh tags: trunk) | |
| 21:49 | • New ticket [b985f0bd] Assertion `0' failed in sqlite3IsLikeFunction. (artifact: caa141c6 user: yongheng) | |
| 21:18 | Merge version 3.31.0 (check-in: 9c3f4638 user: drh tags: begin-concurrent-pnu-wal2) | |
| 21:12 | Merge version 3.31.0 (check-in: 3bb267de user: drh tags: wal2) | |
| 21:06 | Merge version 3.31.0 (check-in: e65e6c01 user: drh tags: begin-concurrent-pnu) | |
| 20:56 | Merge version 3.31.0 (check-in: bbbc2881 user: drh tags: begin-concurrent) | |
| 20:36 | Merge version 3.31.0 (check-in: 0eae87ad user: drh tags: apple-osx) | |
| 20:02 | Merge in version 3.31.0 (check-in: f418afa1 user: drh tags: reuse-schema) | |
| 18:38 | Version 3.31.0 (check-in: f6affdd4 user: drh tags: trunk, release, version-3.31.0) | |
|
2020-01-21
| ||
| 21:01 | Begin adding instrumentation to record and report on the set of key-ranges a concurrent transaction reads from the database. (check-in: c39e3c14 user: dan tags: begin-concurrent-report) | |
| 16:31 | Update test file exclusive.test so that it works with the "journaltest" permutation. (check-in: 4daf94d8 user: dan tags: trunk) | |
| 16:23 | Fix a problem with using views in SQLITE_OMIT_VIRTUAL_TABLE builds. Also some test case fixes required for the same builds. (check-in: 934ee8bd user: dan tags: trunk) | |
| 15:01 | Fix a case in fts3auto.test that fails for SQLITE_DISABLE_FTS4_DEFERRED builds. (check-in: d241055e user: dan tags: trunk) | |
| 14:42 | Fix an assert() that could fail in SQLITE_MUTATION_TEST builds following an error in a query that uses CTEs. (check-in: c7e29458 user: dan tags: trunk) | |
| 13:40 | Fix a problem in the userauth extension causing it to occasionally set "PRAGMA count_changes" (and some others) to true. (check-in: 3a62f642 user: dan tags: trunk) | |
| 12:29 | Fix the series.c and spellfix.c extensions to use SQLITE_VTAB_INNOCUOUS correctly. Fix the documentation on sqlite3_vtab_config() to take into account SQLITE_VTAB_INNOCUOUS and SQLITE_VTAB_DIRECTONLY. (check-in: 9265cb7f user: drh tags: trunk) | |
| 01:45 | Improvements to the autoconf TEA Makefile for MSVC. (check-in: cffcf12f user: mistachkin tags: trunk) | |
|
2020-01-20
| ||
| 15:32 | Merge recent fixes from trunk. (check-in: 9c920bba user: drh tags: reuse-schema) | |
| 14:42 | In the fuzzcheck test program, reduce the default expression depth limit from 1000 to 500 to avoid stack-overflow problems when running stress tests using clang ASAN. (check-in: 63d886f4 user: drh tags: trunk) | |
|
2020-01-19
| ||
| 20:37 | Enhancement to the CLI to allow the ".parameter init" command to work even if defensive mode is turned on. (check-in: 4d462550 user: drh tags: trunk) | |
|
2020-01-18
| ||
| 23:52 | Documentation improvements. (check-in: 535afe15 user: drh tags: trunk) | |
| 22:20 | In the TCL interface, add the ability to change the SQLITE_DBCONFIG_TRUSTED_SCHEMA setting using the "db config" method. (check-in: 1accfa8c user: drh tags: trunk) | |
| 21:35 | • Closed ticket [830277d9]: Non-deterministic date/time functions allowed in CHECK constraints plus 5 other changes (artifact: dfd3e472 user: drh) | |
| 21:34 | Allow non-deterministic function in CHECK constraints. It turns out that PostgreSQL, MySQL, and SQLServer all allow this. We should not be the the exception. Ticket [830277d9db6c3ba1] (check-in: 8c8ce526 user: drh tags: trunk) | |
| 19:58 | Fix a couple of test case issues on this branch. (check-in: 9830a44b user: dan tags: reuse-schema) | |
| 19:46 | Do not use memcpy() of zero bytes when initializing a pager. This avoids a warning. (check-in: cca43778 user: drh tags: trunk) | |
| 19:07 | Disable a redundant test case that uses a very large stack, and hence is unable to run with -fsanitize=undefined,address. (check-in: 3c63f68e user: drh tags: trunk) | |
| 19:02 | Fix harmless compiler warning seen with MSVC. (check-in: cd0437ba user: mistachkin tags: trunk) | |
| 18:59 | Have this branch call sqlite3LockAndPrepare() instead of sqlite3Prepare() when parsing SQL for new schema objects in order to ensure that schemas are released as soon as possible. (check-in: 7a4ec579 user: dan tags: reuse-schema) | |
| 14:50 | Add extra front margin to the fake empty filename returned by sqlite3PagerFilename() for an in-memory or TEMP database. (check-in: fee94567 user: drh tags: trunk) | |
| 13:53 | Fix the VDBE so that it correctly handles the sequence of operations OP_OpenEphemeral, OP_OpenDup, OP_OpenEphemeral, and OP_OpenDup in that order on the same cursor. (check-in: a1be6ee0 user: drh tags: trunk) | |
|
2020-01-17
| ||
| 23:27 | Fix a typo in a comment. No code changes. (check-in: 4363f69c user: drh tags: trunk) | |
| 21:12 | The compress() function should not be deterministic since the same input can have multiple possible compressed outputs. The uncompress() function, on the other hand, is deterministic. (check-in: 84f31490 user: drh tags: trunk) | |
| 19:14 | Fix #ifdefs so it compiles cleanly with all SQLITE_OMIT compile-time options. Update compile-time option testing. (check-in: 7584e4b6 user: drh tags: trunk) | |
| 16:47 | Improved rounding in the 'unixepoch' feature of the date and time functions. (check-in: c9abf1bd user: drh tags: trunk) | |
| 15:45 | Update test script instrfault.test to account for the fact that bound blob values cast to text values are now intepreted using the text encoding of the database, instead of always as utf-8. (check-in: 4d6cb288 user: dan tags: trunk) | |
| 15:33 | More restrictions on changes to shadow tables when in defensive mode. (check-in: b302b260 user: drh tags: branch-3.28) | |
| 15:24 | Validate the type, name, and tbl_name fields of the sqlite_master table when loading the schema, unless writable_schema is engaged. (check-in: 3d13fbf2 user: drh tags: branch-3.28) | |
| 14:56 | Do not allow shadow tables to be dropped in defensive mode. (check-in: ad1f760f user: drh tags: branch-3.28) | |
| 14:30 | Import the 3.31.0-beta FTS3/4 code directly into the 3.28 branch, thus providing 3.28 with all the latest 3.31 fixes. FTS3 has not been enhanced to use any core functionality that was not already available in 3.23, so no modifications were made to FTS3 sources for this import. (check-in: be4269c6 user: drh tags: branch-3.28) | |
| 14:18 | Import all FTS3/4 enhancements and fixes that exist on the latest trunk (3.31.0-beta) that do not require extensive change to the SQLite core into the 3.22 branch. Basically, the 3.31.0 FTS3 sources are copied into 3.22.0, with minor changes to work around core enhancements that are not available in 3.22.0. (Leaf check-in: cbcbb1e5 user: drh tags: branch-3.22) | |
| 11:18 | Fix a case in "fuzz.test" that could fail, as non-deterministic functions may no longer appear in CHECK constraints. (check-in: a370871e user: dan tags: trunk) | |
|
2020-01-16
| ||
| 17:53 | New testcase() macros in select.c, for coverage of the change from two check-ins ago. (check-in: 52206488 user: drh tags: trunk) | |
| 16:32 | Add the SQLITE_FCNTL_CKPT_DONE file-control for the use of custom VFSs. (check-in: 3cc39e50 user: dan tags: trunk) | |
| 16:12 | Do not allow the constant-propagation optimization to apple to ON/USING clause terms as it does not help and it might cause downstream problems. (check-in: 1bc783da user: drh tags: trunk) | |
| 13:02 | Very small performance improvement by ensuring that the argument to sqlite3VdbeFreeCursor() is non-NULL. Hold for the next sprint. (Leaf check-in: f8801ffd user: drh tags: close-cursor-faster) | |
| 12:25 | Fix an SQL syntax error in the comment on the omit-left-join optimization. No changes to code. (check-in: 86b5e5a2 user: drh tags: trunk) | |
| 11:51 | Clean up the definitions of the TERM_ constants in the code generator. Formatting only - no logic changes. (check-in: af06f80a user: drh tags: trunk) | |
|
2020-01-15
| ||
| 17:18 | Fix the assert_schema_state_ok() routine so that it correctly ignores ATTACH-ed database that failed to open due to an error. (check-in: 1194a42a user: drh tags: reuse-schema) | |
| 16:20 | • Fixed ticket [a08879a4]: Assertion `pKeyInfo->enc==ENC(db)' failed. plus 6 other changes (artifact: c6b7444e user: drh) | |
| 16:20 | Do not allow the "PRAGMA encoding" statement to change the database encoding if TEMP content exists, or content in any other attached database. Formerly, encoding changes were allowed if just the main database file was empty. Ticket [a08879a4a476eea9]. (check-in: 03b003c9 user: drh tags: trunk) | |
| 14:38 | • New ticket [a08879a4] Assertion `pKeyInfo->enc==ENC(db)' failed.. (artifact: 2c879cc9 user: yongheng) | |
| 14:26 | Merge all recent enhancements and fixes from trunk. (check-in: f7839178 user: drh tags: reuse-schema) | |
| 14:21 | Merge in the latest trunk changes via the begin-concurrent-pnu branch. (check-in: 350627f3 user: drh tags: begin-concurrent-pnu-wal2) | |
| 14:11 | Merge recent enhancements and fixes from trunk. (check-in: 35eae71a user: drh tags: wal2) | |
| 13:48 | Merge all recent enhancements and fixes from trunk. (check-in: 110a081f user: drh tags: begin-concurrent-pnu) | |
| 13:34 | Merge fixes and enhancements from trunk into begin-concurrent. (check-in: 95ba2f50 user: drh tags: begin-concurrent) | |
| 12:49 | Merge all recent enhancements and fixes from trunk into the apple-osx branch. (check-in: dadedf41 user: drh tags: apple-osx) | |
|
2020-01-14
| ||
| 16:50 | Fix the urifuncs.c extension (used for testing and debugging only) so that the sqlite3_filename_database() SQL function and its siblings correctly handle an invalid schema name passed in as the argument. (check-in: 3d7434a9 user: drh tags: trunk) | |
| 16:39 | Remove an ALWAYS on a branch for improved database corruption detection in btree.c:freeSpace(). Test case found by dbsqlfuzz. (check-in: 54bf0481 user: drh tags: trunk) | |
| 16:33 | Add the new noop_nd() debugging function to the noop.c extension. (check-in: 72911fb1 user: drh tags: trunk) | |
| 14:47 | • Edit [5b246b47aeadc25d|5b246b47]: Edit check-in comment. (artifact: 42fe000a user: drh) | |
| 13:24 | For the showdb utility program, more accurate detection of when the database is in autovacuum mode for the "pgidx" subcommand. (check-in: 9ce2192b user: drh tags: trunk) | |
| 13:13 | Fix a minor typo on a comment in the CLI implementation. (check-in: db4fb350 user: drh tags: trunk) | |
| 00:52 | Improvements to sqlite3_open_v2() documentation. (check-in: 4c4fd62a user: drh tags: trunk) | |
|
2020-01-13
| ||
| 15:25 | More documentation updates. No code changes. (check-in: a684d4ef user: drh tags: trunk) | |
| 13:33 | Documentation updates. No changes to code. (check-in: cc0e0aa3 user: drh tags: trunk) | |
|
2020-01-12
| ||
| 22:38 | Better than removing the incorrect assert() is to change it into a testcase() together with a comment indicating where an appropriate test case can be found, and the ticket that provoked the change. Ticket [614b25314c766238] (check-in: 3e3c60d8 user: drh tags: trunk) | |
| 22:25 | Change the zipfile virtual table so that the xBestIndex method gives a reasonable cost estimate even if no filename is specified. The missing filename error continues to be raised in the xFilter method. Meanwhile, the more reasonable cost estimate avoids unnecessary wierdness in the query planner. (check-in: 0e468aa6 user: drh tags: trunk) | |
| 22:20 | • Fixed ticket [614b2531]: Assertion (pTabItem0.fg.jointype & JT_LEFT)==0 || ExprHasProperty(pOrExpr, EP_FromJoin) failed plus 5 other changes (artifact: 6def3b44 user: drh) | |
| 22:20 | Remove an incorrect assert(). Fix for ticket [614b25314c766238] (check-in: 6a999c5a user: drh tags: trunk) | |
| 21:51 | • New ticket [614b2531] Assertion (pTabItem0.fg.jointype & JT_LEFT)==0 || ExprHasProperty(pOrExpr, EP_FromJoin) failed. (artifact: 5e992995 user: yongheng) | |
| 20:47 | • Edit [3d23a275ab5d7d50|3d23a275]: Edit check-in comment. (artifact: d4a65be1 user: drh) | |
|
2020-01-11
| ||
| 21:08 | New apis: sqlite3_filename_database(), sqlite3_filename_journal(), and sqlite3_filename_wal(). Also sqlite3_uri_key(). And the other sqlite3_uri functions now work using the journal or wal filename in addition to the database file. And the sqlite3_db_filename() result is guaranteed to work as an argument to the sqlite3_uri functions. (check-in: fd7bcc53 user: drh tags: trunk) | |
| 20:27 | Minor changes for consistency between sqlite3_filename_wal() and sqlite3_filename_journal(). (Closed-Leaf check-in: 9a70ff43 user: drh tags: enhanced-uri) | |
| 16:08 | Redesign for better legacy compatibility. Add the sqlite3_uri_key() interface. (check-in: bcb43d11 user: drh tags: enhanced-uri) | |
|
2020-01-10
| ||
| 18:05 | Rearchitect the way in which filenames are stored in the Pager object so that the sqlite3_uri_parameter() interface will work from journal and WAL filenames too. This check-in implements the central idea, and compile and runs somewhat, but crashes on an extended test. (check-in: 2ae77bd2 user: drh tags: enhanced-uri) | |
| 01:33 | • Ticket [5c5a16ec] Test ticket status still Closed with 3 other changes (artifact: 740a1560 user: yongheng) | |
| 01:32 | • Fixed ticket [a148d923]: Assertion `memIsValid(pCtx->argvi)' failed. plus 5 other changes (artifact: 702ee02f user: yongheng) ... 1 similar event omitted. | |
| 01:13 | • Closed ticket [c45762c8]: Second test ticket plus 5 other changes (artifact: 73c47a4b user: drh) ... 1 similar event omitted. | |
| 01:12 | • Closed ticket [5c5a16ec]: Test ticket plus 4 other changes (artifact: ee338488 user: drh) ... 2 similar events omitted. | |
| 01:05 | Fix to the register validity tracking logic in debug builds. No impact on release builds. (check-in: 0a500da6 user: drh tags: trunk) | |
| 00:20 | Begin making changes to turn off trusted schema in command-line tools that open SQLite databases. There are a lot of these, and a lot of places to change, which makes me wonder if trusted schema should be off by default. (Leaf check-in: 3d23a275 user: drh tags: default-untrusted-schema) | |
| 00:00 | Documentation updates on newer APIs. No changes to code. (check-in: 8845a8c2 user: drh tags: trunk) | |
|
2020-01-09
| ||
| 23:07 | Fix the fossildelta.c extension so that it will compile on mingw. (check-in: 20237d5d user: drh tags: trunk) | |
| 20:44 | Merge in the untrusted-schema enhancements. See doc/trusted-schema.md for details. (check-in: 5720924c user: drh tags: trunk) | |
| 20:33 | Only register the fts3_tokenizer() function using a single text encoding. (check-in: 966964af user: drh tags: trunk) | |
| 20:33 | Fix a harmless compiler warning. (check-in: edbf911f user: drh tags: trunk) | |
| 20:21 | • Fixed ticket [678ecf42]: Assertion `pWin==pMWin || sqlite3WindowCompare(pParse,pWin,pMWin,0)==0' failed plus 5 other changes (artifact: d900f336 user: drh) | |
| 20:21 | • Edit [83dc55679a91bf5d|83dc5567]: Edit check-in comment. (artifact: 504ff0a3 user: drh) | |
| 20:11 | Fix an assert() in window.c that could fail with some obscure SELECT statements that use window functions. Ticket [678ecf429f8d1a5f] (check-in: 83dc5567 user: dan tags: trunk) | |
| 17:44 | • New ticket [678ecf42] Assertion `pWin==pMWin || sqlite3WindowCompare(pParse,pWin,pMWin,0)==0' failed. (artifact: 4d0daf85 user: yongheng) | |
| 16:28 | Fix a problem in the encoding display in the updated PRAGMA function_list. (Closed-Leaf check-in: 318ff772 user: drh tags: new-security-options) | |
| 16:00 | Fix minor typos in the trusted-schema.md document. (check-in: 87aea3ab user: drh tags: new-security-options) | |
| 15:30 | • Changes to wiki page "branch/new-security-options" (artifact: 153cee48 user: drh) | |
| 15:18 | Minor formatting changes in the trusted-schema.md document. (check-in: 55553b5e user: drh tags: new-security-options) | |
| 14:58 | • Added wiki page "branch/new-security-options" (artifact: f0364230 user: drh) | |
| 14:51 | Design notes for the new-security-options branch. (check-in: af7c1ed4 user: drh tags: new-security-options) | |
| 13:08 | Simplified error message for the unsafe use of a virtual table. (check-in: d662129a user: drh tags: new-security-options) | |
| 01:20 | Fix a problem that restricted edgy functions in TEMP tables. New test cases added. (check-in: 8878c407 user: drh tags: new-security-options) | |
|
2020-01-08
| ||
| 22:22 | Block edgy functions used in DEFAULT constraints. (check-in: da434dc1 user: drh tags: new-security-options) | |
| 20:37 | Performance improvements and test cases added. Allow "PRAGMA trusted_schema=ON" (check-in: 30882ca8 user: drh tags: new-security-options) | |
| 17:28 | Check for whether or not it is safe to use non-innocuous functions as the function is being coded, not when its name is resolved. (check-in: 1da802d5 user: drh tags: new-security-options) | |
| 15:44 | Provide the -innocuous option to the "db func" method in the TCL interface. (check-in: 0138652b user: drh tags: new-security-options) | |
| 15:43 | Fix the rot13.c extension to be deterministic. Add the noop.c extension. (check-in: a679122c user: drh tags: new-security-options) | |
| 14:39 | In the TreeView debugging output, show a "DDL" mark on SrcList and Expr nodes that derive from a non-TEMP schema. (check-in: fe7472fd user: drh tags: new-security-options) | |
| 13:08 | Merge recent changes from trunk. (check-in: 5962921f user: drh tags: new-security-options) | |
| 12:17 | • Fixed ticket [9eda2697]: Incorrect result for COUNT(), UTF16be encoding and SUBSTR plus 5 other changes (artifact: e2b031bd user: drh) | |
| 12:17 | When doing a text-to-double conversion on a BLOB with an odd number of bytes and assuming a UTF16 encoding, ignore the last byte. Ticket [9eda2697f5cc1aba]. (check-in: 1c76f1d8 user: drh tags: trunk) | |
| 11:36 | Fix a minor formatting error in the display of BLOB values during VDBE tracing. (check-in: 29544288 user: drh tags: trunk) | |
| 10:57 | Improvements to the documentation of sqlite3_create_collation(). (check-in: fa866aec user: drh tags: trunk) | |
| 10:37 | • New ticket [9eda2697] Incorrect result for COUNT(), UTF16be encoding and SUBSTR. (artifact: d39be4d2 user: mrigger) | |
| 04:36 | Simplification of the logic in the constant-propagation optimization. (check-in: 1c3e5c20 user: drh tags: trunk) | |
| 01:44 | • Fixed ticket [82ac75ba]: Incorrect result for query with 0 >= t0.c0 AND t0.c0 = v0.c0 condition plus 6 other changes (artifact: fc968219 user: drh) | |
| 01:43 | Fix the constant propagation optimization so that it does not try to propagate constant expressions that have affinity. Ticket [82ac75ba0093e5dc] (check-in: 6db1c349 user: drh tags: trunk) | |
| 00:39 | Fix a misworded comment. No code changes. (check-in: ee0bc7ed user: drh tags: trunk) | |
|
2020-01-07
| ||
| 21:41 | • New ticket [82ac75ba] Incorrect result for query with 0 >= t0.c0 AND t0.c0 = v0.c0 condition. (artifact: f92e43ea user: mrigger) | |
| 19:45 | Create the "trusted_schema" pragma. Add sqlite3_vtab_config() calls to set the risk rank for many virtual tables. (check-in: 4c21373c user: drh tags: new-security-options) | |
| 18:10 | Enforce SQLITE_VTABRISK restrictions. (check-in: 3d87ff31 user: drh tags: new-security-options) | |
| 18:10 | Fix a performance regression caused by the previous check-in. (check-in: d7d98d3d user: drh tags: trunk) | |
| 16:09 | Invert the UNTRUSTED_SCHEMA setting to be TRUSTED_SCHEMA. (check-in: f5fcf1fb user: drh tags: new-security-options) | |
| 15:44 | Merge recent fixes from trunk. (check-in: 5dfa33a0 user: drh tags: new-security-options) | |
| 14:51 | Provide the ability to tag an application-defined function as "testonly". (Leaf check-in: e6f5c0e0 user: drh tags: testonly-functions) | |
| 13:32 | Add an "|| CORRUPT_DB" term to an assert() statement inside of btree. (check-in: 03c1d75d user: drh tags: trunk) | |
| 09:06 | Fix an instance of an undefined behaviour (a left-shift of a 64-bit unsigned integer by a value greater than 64) that could occur in fts3. (check-in: e1f12978 user: dan tags: trunk) | |
|
2020-01-06
| ||
| 22:48 | • Ticket [bbd55a97] Global heap over flow in sqlite3VdbeMemPrettyPrint status still Fixed with 3 other changes (artifact: c7a5e7e2 user: yongheng) ... 1 similar event omitted. | |
| 20:48 | In the typeof() optimization in OP_Column, expand the size of the bogus buffer provided for data so that it is big enough to cover the increased number of bytes displayed during register tracing from check-in [54553bf16fabd72d]. This is the correct fix for ticket [bbd55a97e66ff50d], though the earlier one does not hurt and is useful to retain. (check-in: e1154c39 user: drh tags: trunk) | |
| 20:11 | • Ticket [bbd55a97] Global heap over flow in sqlite3VdbeMemPrettyPrint status still Fixed with 3 other changes (artifact: 2cd74535 user: yongheng) ... 3 similar events omitted. | |
| 19:30 | Merge enhancements from trunk. (check-in: 9c50f6c2 user: drh tags: new-security-options) | |
| 19:25 | • Fixed ticket [bbd55a97]: Global heap over flow in sqlite3VdbeMemPrettyPrint plus 6 other changes (artifact: 03e0f8e9 user: drh) | |
| 19:23 | Rewrite the (debugging use only) sqlite3VdbeMemPrettyPrint() function to use the safer StrAccum interface rather than writing directly into a static string buffer. Perhaps this will address ticket [bbd55a97e66ff50d], which we are unable to reproduce. (check-in: 69f6a7e4 user: drh tags: trunk) | |
| 18:59 | Backout change [4d0b9109f7a5312d4e1] because the conditional it added is no longer reachable due to check-in [1409758f72c0206c]. (check-in: b3f26967 user: drh tags: trunk) | |
| 18:44 | Move variable declaration to start-of-block for MSVC. (check-in: 55c136ef user: mistachkin tags: trunk) | |
| 18:39 | • New ticket [bbd55a97] Global heap over flow in sqlite3VdbeMemPrettyPrint. (artifact: 34432422 user: yongheng) | |
| 17:47 | • Fixed ticket [9c944882]: Assertion `pSub->pGroupBy==0' failed. plus 3 other changes (artifact: 9489ee7b user: yongheng) ... 1 similar event omitted. | |
| 17:33 | • Fixed ticket [304017f5]: Assertion `j>=pLoop->u.btree.nEq || (pLoop->aLTermj==0)==(j<pLoop->nSkip)' failed. plus 6 other changes (artifact: 47939094 user: drh) | |
| 17:33 | Do not attempt to use the skip-scan optimization if prior terms of the index are already used for non-equality constraints. Ticket [304017f5f04a0035] (check-in: d7126a9c user: drh tags: trunk) | |
| 17:31 | • Ticket [9c944882] Assertion `pSub->pGroupBy==0' failed. status still Closed with 3 other changes (artifact: 03adca3b user: yongheng) ... 1 similar event omitted. | |
| 17:06 | Ensure the SF_Aggregate flag on a SELECT statement is set if a DISTINCT is transformed to a GROUP BY. Ticket [9c944882]. (check-in: 1409758f user: dan tags: trunk) | |
| 15:34 | • New ticket [9c944882] Assertion `pSub->pGroupBy==0' failed.. (artifact: 659941fa user: yongheng) | |
| 15:32 | • New ticket [304017f5] Assertion `j>=pLoop->u.btree.nEq || (pLoop->aLTermj==0)==(j<pLoop->nSkip)' failed.. (artifact: ae409a95 user: yongheng) | |
| 15:25 | Refactor names of flags for improved legibility. (check-in: 411e8ec2 user: drh tags: new-security-options) | |
|
2020-01-05
| ||
| 21:53 | Remove a NEVER in btree due to a new test case from dbsqlfuzz. (check-in: 46f8ef70 user: drh tags: trunk) | |
|
2020-01-04
| ||
| 20:58 | Refactor the names of the new controls for restricting what actions the schema can take behind the application's back. (check-in: 65d7d39a user: drh tags: new-security-options) | |
| 20:07 | • Ticket [a3713a5f] DBSTAT query computes incorrect result for stat.aggregate = 1 condition status still Closed with 3 other changes (artifact: c646048c user: mrigger) | |
| 19:58 | Enhance PRAGMA function_list to show internal functions if the direct use of internal functions is enabled via the SQLITE_TESTCTRL_INTERNAL_FUNCTIONS test control. (check-in: 7a8d7ca7 user: drh tags: new-security-options) | |
| 19:57 | • Closed ticket [a3713a5f]: DBSTAT query computes incorrect result for stat.aggregate = 1 condition plus 4 other changes (artifact: f38b95a7 user: drh) ... 1 similar event omitted. | |
| 19:19 | Merge all fixes and enhancements from trunk. (check-in: b878c30f user: drh tags: new-security-options) | |
| 19:15 | • Fixed ticket [a3713a5f]: DBSTAT query computes incorrect result for stat.aggregate = 1 condition plus 5 other changes (artifact: 39eec803 user: drh) | |
| 19:14 | Fix DBSTAT so that it returns no rows, rather than an error when the WHERE clause is "schema=NULL". (check-in: 5b246b47 user: drh tags: trunk) | |
| 19:12 | Fix harmless compiler warnings. (check-in: 8452fe03 user: drh tags: trunk) | |
| 18:53 | • Closed ticket [74a4c386]: DBSTAT query computes incorrect result for name column plus 5 other changes (artifact: 15c05092 user: dan) | |
| 18:51 | • New ticket [a3713a5f] DBSTAT query computes incorrect result for stat.aggregate = 1 condition. (artifact: 57f82aaf user: mrigger) | |
| 18:38 | Omit the omit flat from eq constraints on column "name" of dbstat virtual tables. Fix for [74a4c386]. (check-in: cfff5cb2 user: dan tags: trunk) | |
| 18:33 | Record when the OP_IfNotOpen branch is and is not taken. (check-in: 182a898b user: drh tags: trunk) | |
| 17:55 | Remove another NEVER added by check-in [7b62555e285f32d3]. Dbsqlfuzz found another test case. (check-in: 481f4956 user: drh tags: trunk) | |
| 17:42 | New test cases in test/in4.test require rtree, so disable those tests on builds that lack the rtree extension. (check-in: b5900914 user: drh tags: trunk) | |
| 16:55 | Fix a problem where the loop for the RHS of a LEFT JOIN uses values from an IN() clause as the second or subsequent field of an index. (check-in: 95ef6896 user: dan tags: trunk) | |
| 16:09 | • New ticket [74a4c386] DBSTAT query computes incorrect result for name column. (artifact: 9d42cfce user: mrigger) | |
| 15:37 | Merge the latest fixes from trunk. (check-in: 26ef709a user: drh tags: new-security-options) | |
| 15:23 | • Fixed ticket [727074e2]: DBSTAT query computes incorrect result for aggregate column plus 5 other changes (artifact: 5400437e user: drh) | |
| 15:21 | Fix a false-positive in the register validity tracking logic by moving the temporary register release call before the jump that uses that temporary register. (check-in: 9da48a5c user: drh tags: trunk) | |
| 14:57 | Improve a testcase in test/fuzzdata8.db to make it more resilient. (check-in: 139aefe6 user: drh tags: trunk) | |
| 14:50 | Back out another NEVER added by check-in [7b62555e285f32d3] - the test case was already in test/fuzzdata3.db, but it only occurs if compiled without SQLITE_ENABLE_PREUPDATE_HOOK. (check-in: 61f873b1 user: drh tags: trunk) | |
| 14:00 | Omit the omit flag from eq constraints on column "aggregate" of dbstat virtual tables. Fix for [727074e2]. (check-in: 74ef6f2b user: dan tags: trunk) | |
| 12:34 | Restore a NEVER and an assert in btree that was removed by check-in [7b62555e285f32d3]. Dbsqlfuzz found test cases. (check-in: 04a05c83 user: drh tags: trunk) | |
| 11:22 | • New ticket [727074e2] DBSTAT query computes incorrect result for aggregate column. (artifact: c7bce00a user: mrigger) | |
| 01:43 | Enhance PRAGMA function_list so that it shows all instances of each FuncDef, the number of arguments, the encoding, the type, and the flags. Use this capability to locate and fix incorrect function flags in the standard build. (check-in: 9ca906d2 user: drh tags: new-security-options) | |
|
2020-01-03
| ||
| 21:57 | Invert the SQLITE_FUNC_SAFE bit to be SQLITE_FUNC_UNSAFE. The external bit is still SQLITE_INNOCUOUS. It gets inverted as the appdef function is registered. (check-in: 1c266cb3 user: drh tags: new-security-options) | |
| 20:57 | When UNSAFE_IN_VIEW is disabled, only allow functions in views that are tagged with SQLITE_INNOCUOUS. (check-in: 9ee79b25 user: drh tags: new-security-options) | |
| 20:16 | In fts3, avoid making a very large memory allocation if the merge-hint record is corrupt. (check-in: 9add58fe user: dan tags: trunk) | |
| 17:40 | Add NEVER macros to error-detection branches that were made unreachable (as far as I can tell) by check-in [ceacc28b03580334]. (check-in: 7b62555e user: drh tags: trunk) | |
| 16:38 | Improvement to check-in [7405e98225761180] so that missing or null filenames given to the zipfile extension throw an immediate error. (check-in: 523e09bd user: drh tags: trunk) | |
| 15:51 | Improve a specific case of early database corruption dectecion in the b-tree layer. (check-in: ceacc28b user: dan tags: trunk) | |
| 15:22 | Merge fixes from trunk. (check-in: 002406df user: drh tags: new-security-options) | |
| 14:34 | Remove an over-zealous ALWAYS() macro and add a test case that shows that the conditional can sometimes be false. (check-in: 536e9a9d user: drh tags: trunk) | |
| 14:27 | Fix a possible NULL pointer dereference caused by using a "VALUES(...)" as a component of a compound SELECT with non-integer ORDER BY clause terms. (check-in: 9d791116 user: dan tags: trunk) | |
| 14:16 | Fix the OP_Copy-coalesce optimization so that if the previous row happens to end with OP_Copy but is not a candidate for the optimization due to jumps, then the optimization is correctly bypassed. (check-in: b36126c1 user: drh tags: trunk) | |
| 13:55 | Ensure that when a Select object is reset a new, empty, SrcList is allocated. (check-in: 4889cbf8 user: dan tags: trunk) | |
| 02:20 | When generating the name of a view (or common table expression) because the SQL does not specify a name, avoid the names "true" and "false" which might be confused for the boolean literals of the same name, leading to an inconsistent abstract syntax tree. (check-in: ff9492d3 user: drh tags: trunk) | |
| 00:28 | Fix a problem in sqlite3TreeViewBareExprList() in which the routine was not interpreting the new ExprList format correctly. (check-in: cd56872a user: drh tags: trunk) | |
|
2020-01-02
| ||
| 23:50 | Merge enhancements from trunk. (check-in: 091403a6 user: drh tags: new-security-options) | |
| 22:28 | Add the two-size lookaside memory allocator. Also, reduce the per-entry size of the ExprList object. (check-in: 51665bf0 user: drh tags: trunk) | |
| 22:23 | NEVER() and ALWAYS() macros tagging unreachable branches. (Closed-Leaf check-in: 34b87774 user: drh tags: two-size-lookaside) | |
| 21:41 | Merge the latest enhancements from trunk. (check-in: bd57e6d9 user: drh tags: two-size-lookaside) | |
| 21:36 | • Edit [b02fdc09c838f355|b02fdc09]: Move to branch two-size-lookaside. (artifact: 188beefd user: drh) | |
| 21:30 | Do not allow the zipfile virtual table to start a transaction if no filename has been specified. (check-in: 7405e982 user: drh tags: trunk) | |
| 19:50 | Fix some test logic in the OP_Delete opcode so that it works after a cursor-trip. (check-in: 28900e5c user: drh tags: trunk) | |
| 18:37 | Ifdef-out code that is only possible with the sessions extension. (check-in: 4fcf07f7 user: drh tags: trunk) | |
| 17:46 | Have the OP_ReleaseReg opcode also invalidate the registers if P5 is non-zero. (check-in: 937be221 user: drh tags: trunk) | |
| 16:24 | • Closed ticket [771fe617]: FTS5 integrity-check results in "database disk image is malformed" for UTF-16 encoding and SUBSTR plus 5 other changes (artifact: 0624b2ad user: dan) | |
| 16:24 | Handle blobs that are the return values of functions being cast to text in utf16 databases in the same way as blobs read directly from the database. Fix for [771fe617]. (check-in: e782096a user: dan tags: trunk) | |
| 15:02 | Fix the OP_Move opcode so that it correctly manages dependency tracking. This change impacts debugging builds only. (check-in: 5377add4 user: drh tags: trunk) | |
| 14:42 | Enhancements to aid testing and debugging: In PRAGMA vdbe_trace=on output, show pScopyFrom dependencies on register values. Add the sqlite3VdbeRegisterDump() procedure, callable from a debugger, that shows the values of all registers. Pass the VDBE pointer into test_trace_breakpoint() so that sqlite3VdbeRegisterDump() is callable from the breakpoint. (check-in: 9886cb4b user: drh tags: trunk) | |
| 13:26 | Add the test_trace_breakpoint() subroutine that is invoked after each instruction is printed while running PRAGMA vdbe_trace=on. Only works for SQLITE_DEBUG builds. Also add parameters "pc" and "pOp" to test_addop_breakpoint() to make it easier to set conditionals. (check-in: 49a6368c user: drh tags: trunk) | |
| 02:50 | Use OP_Copy instead of OP_SCopy to move the results of a scalar subquery. (check-in: 435c272d user: drh tags: trunk) | |
| 00:45 | The sqlite3WhereEnd() call now unwinds all Expr modifications made by the sqlite3WhereBegin(). (check-in: 7bfd42f1 user: drh tags: trunk) | |
|
2020-01-01
| ||
| 23:02 | Provide the -DSQLITE_ENABLE_INTERNAL_FUNCTIONS=1 compile-time option. Fix the ".testctrl internal_function" command in the CLI so that it does not signal an error on a valid input. (check-in: 8ee2ce92 user: drh tags: trunk) | |
| 22:29 | • New ticket [771fe617] FTS5 integrity-check results in "database disk image is malformed" for UTF-16 encoding and SUBSTR. (artifact: a3dd00c0 user: mrigger) | |
| 21:14 | When generating code for a subquery, make a copy of the Select object and generate the code out of the copy, in case the code generator makes modifications to expression and the Select object needs to be reused. (check-in: 4edddcc0 user: drh tags: trunk) | |
| 20:17 | Ensure that when code for a scalar SELECT featuring window functions is generated more than once by the planner, separate ephemeral tables are opened for each instance. (check-in: ce141732 user: dan tags: trunk) | |
| 16:43 | Fix the sqlite3ExprImpliesNonNullRow() routine so that it correctly handles a numeric comparison of two AND subexpressions. (check-in: 07e504d5 user: drh tags: trunk) | |
| 15:43 | New test-only SQL functions: implies_nonnull_row(), expr_compare(), and expr_implies_expr(). The SQLITE_TESTCTRL_INTERNAL_FUNCTIONS test-control is modified to toggle internal function access on and off for a single database connection. (check-in: 473892a8 user: drh tags: trunk) | |
| 13:55 | Factor out code generation for in-line SQL functions into a separate routine inside of expr.c. (check-in: 586a65a2 user: drh tags: trunk) | |
| 01:26 | Issue OP_ReleaseReg opcodes against the array of registers used to compute index records after the index record has been computed. (check-in: e3330861 user: drh tags: trunk) | |