Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
200 events occurring around cc65ca541265bd70.
|
2020-03-03
| ||
| 19:42 | • New ticket [d165ad781b] Assertion `(mFlags&(MEM_Str|MEM_Blob))==0 || (pMem->n==pX->n && pMem->z==pX->z)' failed.. (artifact: c714956cba user: yongheng) | |
| 19:04 | • New ticket [c4c56482ce] Assertion `(p->flags & ~(MEM_Null|MEM_Term|MEM_Subtype|MEM_FromBind |MEM_Dyn|MEM_Ephem|MEM_Static))==0' failed.. (artifact: 636e77d7f1 user: yongheng) | |
| 11:56 | • Edit [85a9b6a92fd5805d|85a9b6a92f]: Edit check-in comment. (artifact: 87ff2af74d user: drh) | |
| 01:16 | Improved detection of corruption in the interior nodes of a segment btree in FTS3/4. (check-in: cc99447ac9 user: drh tags: trunk) | |
|
2020-03-02
| ||
| 21:00 | Fix reporting for some range scan cases. (check-in: ad961aee15 user: dan tags: begin-concurrent-report) | |
| 16:31 | Enhance the fuzzcheck test program so that it is able to simulate OOM errors in the same way that dbsqlfuzz does. (check-in: a65c8d4e26 user: drh tags: trunk) | |
| 15:05 | Merge latest begin-concurrent-pnu changes with this branch. (check-in: b1880b1899 user: dan tags: begin-concurrent-report) | |
| 01:51 | • Fixed ticket [da5a09be6d]: UAF in sqlite3BlobCompare plus 6 other changes (artifact: d1264e41dd user: drh) | |
| 01:50 | Fix a faulty assert() statement in the stale-register detection logic. Ticket [da5a09be6dabbf42]. (check-in: 219c296cc8 user: drh tags: trunk) | |
| 01:30 | • Ticket [e12a0ae526] Assertion `memIsValid(&aMempOp->p1)' failed status still Fixed with 3 other changes (artifact: 87fc6c958c user: drh) ... 1 similar event omitted. | |
| 01:16 | Ensure that the NULL-scan pass counter is initialized when a ORDER BY NULLS LAST is used on the right table of a LEFT JOIN. Ticket [e12a0ae526bb51c7]. (check-in: 704bb9a39a user: drh tags: trunk) | |
|
2020-02-29
| ||
| 21:41 | • New ticket [da5a09be6d] UAF in sqlite3BlobCompare. (artifact: 806f997729 user: yongheng) | |
| 21:39 | • New ticket [e12a0ae526] Assertion `memIsValid(&aMempOp->p1)' failed. (artifact: 72a8701aa3 user: yongheng) | |
| 17:19 | Fix a problem with window functions occuring within sub-selects that are part of an OR term in a WHERE clause of the outer SELECT. (check-in: 1e174ed0d2 user: dan tags: trunk) | |
| 15:53 | In the CLI, add the ".oom" command for debugging builds. (check-in: 9c3136a722 user: drh tags: trunk) | |
|
2020-02-28
| ||
| 16:04 | • Fixed ticket [e63b4d1a65]: Query on rtree unexpectedly yields 0 rather than 0.0 plus 5 other changes (artifact: 7861527daa user: drh) | |
| 16:04 | The RTREE extension behaves as if data columns have type REAL, so we should actually declare them as REAL so that automatic indexes handle them correctly. Ticket [e63b4d1a65546532] (check-in: 85a9b6a92f user: drh tags: trunk) | |
| 14:49 | • New ticket [e63b4d1a65] Query on rtree unexpectedly yields 0 rather than 0.0. (artifact: 5e3591cf8a user: mrigger) | |
|
2020-02-27
| ||
| 17:16 | In sqlite3changeset_apply(), ensure that DELETE and UPDATE changes are always executed on main database tables, not similarly named temp tables, as documented. INSERT statements are already being handled correctly. (check-in: f71a13d072 user: dan tags: trunk) | |
| 16:21 | Fix harmless compiler warnings from MSVC. (check-in: 951b39ca74 user: drh tags: trunk) | |
| 15:20 | Merge latest trunk changes into this branch. (check-in: 3f5650aae6 user: dan tags: reuse-schema) | |
| 15:07 | Optimization for "SELECT min(x) FROM tbl" where "x" is indexed and NOT NULL. This also allows similar queries on NOT NULL virtual table columns to be optimized. (check-in: 5972677793 user: dan tags: trunk) | |
| 13:54 | Extra zero terminators on the end of the blank filename returned by sqlite3PagerFilename() for an in-memory database. This helps the result work better with sqlite3_filename_journal() and similar functions. (check-in: 63e533d28e user: drh tags: trunk) | |
| 12:33 | Backport the change that allows the filename passed into the xFullPathname to be used as an argument to sqlite3_uri_parameter(). (check-in: 9c77bfe41e user: drh tags: branch-3.31) | |
| 11:32 | Ensure that the filename passed into the xFullPathname method of the VFS is acceptable as an argument to sqlite3_uri_parameter(). The interface spec does not guarantee this, but it has been so historically and some applications have come to depends on it. (check-in: bfb09371d4 user: drh tags: trunk) | |
|
2020-02-25
| ||
| 20:05 | Update the fuzzcheck test module so that it avoids inserting text values that contain embedded NULs in the XSQL table. Fix some legacy entries in the test/fuzzdata8.db that had embedded NULs. Add in new dbsqlfuzz cases that have accumulated over on the dbsqlfuzz project for a while. (check-in: 47d4240c4a user: drh tags: trunk) | |
|
2020-02-24
| ||
| 17:05 | If STAT4 determines that a WHERE clause term that is not used by an index has very high probability of being true, then do not use that term to reduce the estimated output row count. (check-in: 40739c793b user: drh tags: trunk) | |
| 16:46 | Rework this changes so that instead of setting the WhereTerm.truthProb when a term is seen to be of low selectivity, it merely sets a new flag (the TERM_HIGHTRUTH flag) which causes whereLoopOutputAdjust() to ignore that term. (Closed-Leaf check-in: 4558163b6a user: drh tags: stat4-truthprob) | |
| 13:35 | Disable the new analyzeG.test module if not building with STAT4. (check-in: 4a9d300576 user: drh tags: stat4-truthprob) | |
| 13:26 | Merge bugfix from trunk. (check-in: b542dee9de user: drh tags: stat4-truthprob) | |
|
2020-02-23
| ||
| 17:38 | • Fixed ticket [f50af3e8a5]: OOB memory access on a table rename plus 5 other changes (artifact: 929fcf1da9 user: drh) | |
| 17:34 | Fix a problem with ALTER TABLE for views that have a nested FROM clause. Ticket [f50af3e8a565776b]. (check-in: c431b3fd8f user: drh tags: trunk) | |
| 16:16 | • Ticket [f50af3e8a5] OOB memory access on a table rename status still Open with 6 other changes (artifact: 569133e78e user: drh) ... 1 similar event omitted. | |
|
2020-02-22
| ||
| 18:27 | Do not activate the truthProb adjustment mechanism if the truth probability is less than the heuristic value, as there could be correlations unknown to stat4. Also add additional tracing output to make truthProb adjustments more visible. (check-in: c535fea147 user: drh tags: stat4-truthprob) | |
| 17:32 | Add new test file analyzeG.test, containing a test for the change on this branch. (check-in: 243ab1852a user: dan tags: stat4-truthprob) | |
| 16:58 | When stat4 information is available, try to use it to improve the truth probability of WHERE clause terms that do not participate in the index. (check-in: 1babd6ec5d user: drh tags: stat4-truthprob) | |
| 13:07 | • Fixed ticket [aa43786930]: sqlite3.c:87338: int sqlite3VdbeExec(Vdbe *): Assertion `sqlite3BtreeCursorIsValid(pCrsr)' failed. plus 6 other changes (artifact: 9fee20675e user: drh) | |
| 13:01 | In the OP_Column opcode, if the cursor is marked NullRow (due to being the right table of a LEFT JOIN that does not match) and the cursor is the table cursor for an OR-optimization with a covering index, then do not substitute the covering index cursor, since the covering index cursor does not have the NullRow flag set. Ticket [aa4378693018aa99] (check-in: f02030b340 user: drh tags: trunk) | |
| 04:18 | • New ticket [aa43786930] sqlite3.c:87338: int sqlite3VdbeExec(Vdbe *): Assertion `sqlite3BtreeCursorIsValid(pCrsr)' failed.. (artifact: ba0b33c0f8 user: yongheng) | |
|
2020-02-21
| ||
| 11:52 | • Edit [a67cf5b7d37d5b14|a67cf5b7d3]: Edit check-in comment. (artifact: d222ca4669 user: drh) | |
|
2020-02-20
| ||
| 14:11 | Add test case for previous commit. (check-in: 14d14eb537 user: dan tags: trunk) | |
| 14:08 | Early-out on the INTERSECT query processing following an out-of-memory error. This fixes a potential null pointer dereference found by sakura(@eternalsakura13) of Alpha Team, Qihoo 360. (check-in: a67cf5b7d3 user: drh tags: trunk) | |
|
2020-02-19
| ||
| 15:39 | Fix a potential NULL pointer dereference following OOM. Problem discovered by dbsqlfuzz. Test case in TH3. (check-in: 5aeb5a2d29 user: drh tags: trunk) | |
|
2020-02-18
| ||
| 23:58 | Remove a NEVER() macro and add a test case to cause its argument to be true. (check-in: ee034fe916 user: drh tags: trunk) | |
| 19:49 | Add the new sqlite3_create_filename() and sqlite3_free_filename() interfaces for use by Shims. Use these interfaces inside the multiplexor. (check-in: 9469f36ac8 user: drh tags: trunk) | |
|
2020-02-17
| ||
| 23:08 | Convert invalid surrogates to 0xfffd when translating UTF. (check-in: 7fab1393c2 user: drh tags: trunk) | |
| 19:25 | A better (smaller and faster) solution to ticket [4374860b29383380]. (check-in: abc473fb8f user: drh tags: trunk) | |
| 00:12 | • Fixed ticket [4374860b29]: Segmentation fault in isAuxiliaryVtabOperator plus 5 other changes (artifact: 971c60ab36 user: drh) | |
| 00:12 | Take care when checking the table of a TK_COLUMN expression node to see if the table is a virtual table to first ensure that the Expr.y.pTab pointer is not null due to generated column optimizations. Ticket [4374860b29383380]. (check-in: 9d0d4ab95d user: drh tags: trunk) | |
|
2020-02-16
| ||
| 20:37 | • New ticket [4374860b29] Segmentation fault in isAuxiliaryVtabOperator. (artifact: 35dadd9276 user: yongheng) | |
| 17:40 | Avoid an infinite recursion on an illegal recursive definition of an fts5vocab table. (check-in: 109ee07433 user: drh tags: trunk) | |
|
2020-02-13
| ||
| 22:12 | • Fixed ticket [1dcb4d4496]: Incorrect query result when redundant terms appears in WHERE clause plus 5 other changes (artifact: 1a3d605b90 user: drh) | |
| 22:12 | Fix problems in the constant propagation optimization that were introduced by check-in [1c3e5c20a9e6f501]. Fix for ticket [1dcb4d44964846ad] (check-in: c9a8defcef user: drh tags: trunk) | |
| 20:37 | • New ticket [1dcb4d4496] Incorrect query result when redundant terms appears in WHERE clause. (artifact: 2274c85b7a user: drh) | |
| 14:51 | Disallow the skip-scan optimization in the absence of sqlite_stat1 data. (check-in: e0c6b8bdb7 user: drh tags: trunk) | |
| 13:45 | Omit O_NOFOLLOW from the open() call when opening /dev/null, since /dev/null is a symlink on Solaris, we are told. (check-in: 0c683c43a6 user: drh tags: trunk) | |
| 11:47 | • Fixed ticket [41c1456a6e]: Assertion `pColl1 && (pParse->nErr || pColl2)' failed. plus 6 other changes (artifact: c72a159dcf user: drh) | |
| 11:46 | Fix an incorrect assert() statement that was added yesterday. Tickets [41c1456a6e61c0e7] and [fb8c538a8f57ae2a]. (check-in: abfb043ebb user: drh tags: trunk) | |
| 02:13 | • New ticket [41c1456a6e] Assertion `pColl1 && (pParse->nErr || pColl2)' failed.. (artifact: 9c16e62231 user: yongheng) | |
|
2020-02-12
| ||
| 20:50 | Increase the default upper bound on the number of parameters in a single SQL statement to 32766 (from 999). (check-in: 2def75693a user: drh tags: trunk) | |
| 13:02 | • Fixed ticket [fb8c538a8f]: Incorrect sorting when a column uses BINARY collation in the ORDER BY, but is constrained by an == with a different collation in the WHERE clause plus 3 other changes (artifact: 96f91c7db6 user: drh) | |
| 11:57 | When determining whether an == or IS constraint in a WHERE clause makes an ORDER BY term redundant, consider the collation sequence used by the == or IS comparison, not the collation sequence of the comparison expression itself. Possible fix for [fb8c538a8f]. (check-in: 16aed5d0c6 user: dan tags: trunk) | |
| 11:18 | • Ticket [fb8c538a8f] Incorrect sorting when a column uses BINARY collation in the ORDER BY, but is constrained by an == with a different collation in the WHERE clause status still Open with 6 other changes (artifact: 19ffc8588b user: drh) ... 1 similar event omitted. | |
|
2020-02-10
| ||
| 19:37 | Fix a typo in the in-tree begin-concurrent documentation (check-in: b13dae1cb3 user: drh tags: begin-concurrent) | |
| 19:24 | Mark the sha1() extension function as SQLITE_DETERMINISTIC. (check-in: 7d8dcfb95c user: drh tags: trunk) | |
| 13:29 | Fix the build for when SQLITE_VDBE_COVERAGE is used. (check-in: 084381649e user: drh tags: trunk) | |
|
2020-02-07
| ||
| 19:44 | During byte-code generation, strive to avoid jumps that merely jump to the following instruction. (check-in: bcf876e67e user: drh tags: trunk) | |
| 01:12 | Simplify the code by removing the unsupported and undocumented SQLITE_HAS_CODEC compile-time option (check-in: 5a877221ce user: drh tags: trunk) | |
|
2020-02-06
| ||
| 20:46 | There is no need to keep track of the number of changed rows or of the last-insert-rowid while running VACUUM. (check-in: a8a7c05b16 user: drh tags: trunk) | |
| 15:38 | Unroll the comparison loop inside keywordCode() for to avoid unnecessary comparisions and thus help that routine run faster. (check-in: cec5f920f5 user: drh tags: trunk) | |
| 13:57 | Separate OP_IdxInsert and OP_SorterInsert into completely separate opcodes, helping each one to run a little faster. (check-in: 447d71f086 user: drh tags: trunk) | |
| 13:09 | Remove dead code from the sqlite3_filename_database() function. (check-in: 1b6185550f user: drh tags: trunk) | |
| 11:08 | Merge changes on 3.31 branch into reuse-schema. (check-in: 6dbb8cb0e3 user: dan tags: reuse-schema-3.31) | |
| 11:02 | Fix a 4 byte OOB read in test_multiplex.c. (check-in: 6279f69f0f user: dan tags: branch-3.31) | |
| 10:55 | Fix some fts3 problems found by usan. (check-in: fb7ccf61be user: dan tags: trunk) | |
|
2020-02-05
| ||
| 18:28 | Small size reduction and performance improvement in the sqlite3VdbeMemFromBtree() interface used to pull content out of the b-tree and into an sqlite3_value object. (check-in: ae6dd8d3e9 user: drh tags: trunk) | |
|
2020-02-04
| ||
| 20:22 | Merge latest trunk/wal2 changes, including the SQLITE_ENABLE_CORRUPT_PGNO patch, with this branch. (check-in: 76668b5589 user: dan tags: begin-concurrent-pnu-wal2) | |
| 20:11 | Merge latest trunk changes into this branch. (check-in: 6ad4d6b7ff user: dan tags: wal2) | |
| 20:09 | Merge latest trunk changes, including the SQLITE_ENABLE_CORRUPT_PGNO patch, into this branch. (check-in: 23bc80cc86 user: dan tags: begin-concurrent-pnu) | |
| 20:08 | Merge latest trunk changes, including the SQLITE_ENABLE_CORRUPT_PGNO patch, into this branch. (check-in: f253618ac6 user: dan tags: begin-concurrent) | |
| 20:01 | Enable more detailed log messages in SQLITE_ENABLE_CORRUPT_PGNO builds if database corruption is encountered. (check-in: 57c36a293e user: dan tags: trunk) | |
| 03:01 | • Fixed ticket [f07d71bb49]: Assertion `pOp->p4type==P4_FUNCCTX' failed. plus 6 other changes (artifact: ed88e6592e user: drh) ... 1 similar event omitted. | |
| 01:50 | • Fixed ticket [86ba67afaf]: Incorrect affinity for CHECK constraints plus 5 other changes (artifact: 36a81307ca user: drh) | |
| 01:49 | • Fixed ticket [9d3666754a]: int sqlite3VdbeExec(Vdbe *): Assertion `memIsValid(pCtx->argvi)' failed. plus 5 other changes (artifact: bfde5dc28a user: drh) | |
| 01:41 | Extend the OP_Copy-coalesce optimization fix of check-in [b36126c1889e323c] so that it is also correctly disabled by the CASE operator. Ticket [9d3666754ac37d5a]. (check-in: 29a969d6b1 user: drh tags: trunk) | |
| 00:55 | Fix a problem with the byte-code decompiler that was inserted by the enhancements at [4248980a356f659b] (check-in: af63e95dcd user: drh tags: trunk) | |
|
2020-02-03
| ||
| 22:45 | • New ticket [9d3666754a] int sqlite3VdbeExec(Vdbe *): Assertion `memIsValid(pCtx->argvi)' failed.. (artifact: 2c85b4bc16 user: yongheng) | |
| 19:56 | Cosmetic change to the xfer-optimization to put the OP_RowData opcode closer to the corresponding OP_Insert opcode. This makes it slightly easier to read and understand the code. (check-in: 0ea2dbfc90 user: drh tags: trunk) | |
| 16:07 | • Ticket [86ba67afaf] Incorrect affinity for CHECK constraints status still Open with 6 other changes (artifact: 625d7cb6b4 user: drh) | |
| 12:25 | Increase the version number to 3.32.0. (check-in: 8130bbb421 user: drh tags: trunk) | |
|
2020-02-01
| ||
| 21:03 | On an INSERT or UPDATE, perform affinity conversions on new data prior to running CHECK constraints. Ticket [86ba67afafded936]. (check-in: 1d4f86201d user: drh tags: trunk) | |
| 17:38 | Fix the comment display for the OP_Function opcode. And at the same time, improve the comment generating logic to make use of the newer sqlite3_str_appendf() interface. (check-in: 4248980a35 user: drh tags: trunk) | |
| 14:30 | • New ticket [86ba67afaf] Incorrect affinity for CHECK constraints. (artifact: 605ae30539 user: drh) | |
| 14:29 | Fix a problem in sqlite3CodecQueryParameters() that was introduced by the query parameter encoding changes for the 3.31.1 release. (check-in: 1240ee4f6f user: drh tags: apple-osx) | |
| 14:20 | Merge the sqlite3CodecQueryParameters() fix into trunk. (check-in: a812f53369 user: drh tags: trunk) | |
| 13:30 | Fix a problem in sqlite3CodecQueryParameters() that was introduced by the query parameter encoding changes for the 3.31.1 release. (check-in: cc65ca5412 user: drh tags: branch-3.31) | |
| 00:08 | Merge version 3.31.1 (check-in: d250d085fa user: numist tags: apple-osx) | |
|
2020-01-31
| ||
| 14:52 | Fix a minor typo in a comment in the btreeinfo extension. (check-in: b5a66d10f4 user: drh tags: trunk) | |
|
2020-01-29
| ||
| 23:19 | • Closed ticket [1dc432db3b]: FTS4 integrity-check results in "database disk image is malformed" for UTF-16 encoding plus 4 other changes (artifact: 10166d7b08 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: dcb4838757 user: dan tags: trunk) | |
| 13:56 | Add a test case for commit [ffd8bb93]. (check-in: bcd5b37b8e user: dan tags: trunk) | |
| 13:50 | Remove a NEVER() that is in fact reachable. Test cases in dbsqlfuzz and TH3. (check-in: ffd8bb9351 user: drh tags: trunk) | |
| 13:10 | Add new memory barriers during initialization. (check-in: a9b2adc5d6 user: drh tags: trunk) | |
| 12:37 | Modify a couple of FTS test cases so that they work on big-endian platforms. (check-in: b20503aaf5 user: drh tags: trunk) | |
| 10:10 | • Ticket [1dc432db3b] FTS4 integrity-check results in "database disk image is malformed" for UTF-16 encoding status still Open with 3 other changes (artifact: 68d922e497 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: 59a31b16b5 user: drh tags: trunk) | |
| 20:09 | Small performance improvement to the key-comparision routine for strings. (check-in: 41454499a2 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: 8ac26a23d7 user: drh tags: trunk) | |
| 16:55 | Fix a 4 byte OOB read in test_multiplex.c. (check-in: 912148913c user: dan tags: trunk) | |
| 15:02 | Minor change for compatibility with the s390 architecture. (check-in: 04885763c4 user: drh tags: trunk) | |
|
2020-01-27
| ||
| 19:55 | Version 3.31.1 (check-in: 3bfa9cc97d user: drh tags: trunk, release, version-3.31.1) | |
| 17:09 | Update the version number to 3.31.1. (check-in: 6fb9a8fb85 user: drh tags: trunk) | |
| 14:53 | • Edit [34ab760689fd493e|34ab760689]: Edit check-in comment. (artifact: 6f0275e33f 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: 34ab760689 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: 14331989fc user: drh tags: trunk) | |
| 00:08 | Fix variable declaration issue seen with MSVC. (check-in: 8a6fe3066c user: mistachkin tags: trunk) | |
|
2020-01-22
| ||
| 23:13 | • Fixed ticket [b985f0bd16]: Assertion `0' failed in sqlite3IsLikeFunction plus 6 other changes (artifact: 076ee1f865 user: drh) | |
| 23:08 | Fix a NEVER() macro that can be true if compiled with SQLITE_ENABLE_UNKNOWN_SQL_FUNCTION. Ticket [b985f0bd1636d9bc] (check-in: 9f0f5d593a user: drh tags: trunk) | |
| 21:49 | • New ticket [b985f0bd16] Assertion `0' failed in sqlite3IsLikeFunction. (artifact: caa141c601 user: yongheng) | |
| 21:18 | Merge version 3.31.0 (check-in: 9c3f46384d user: drh tags: begin-concurrent-pnu-wal2) | |
| 21:12 | Merge version 3.31.0 (check-in: 3bb267deb1 user: drh tags: wal2) | |
| 21:06 | Merge version 3.31.0 (check-in: e65e6c01d6 user: drh tags: begin-concurrent-pnu) | |
| 20:56 | Merge version 3.31.0 (check-in: bbbc2881b9 user: drh tags: begin-concurrent) | |
| 20:36 | Merge version 3.31.0 (check-in: 0eae87ad11 user: drh tags: apple-osx) | |
| 20:02 | Merge in version 3.31.0 (check-in: f418afa1bf user: drh tags: reuse-schema) | |
| 18:38 | Version 3.31.0 (check-in: f6affdd416 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: c39e3c14a9 user: dan tags: begin-concurrent-report) | |
| 16:31 | Update test file exclusive.test so that it works with the "journaltest" permutation. (check-in: 4daf94d833 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: 934ee8bdb4 user: dan tags: trunk) | |
| 15:01 | Fix a case in fts3auto.test that fails for SQLITE_DISABLE_FTS4_DEFERRED builds. (check-in: d241055ead 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: c7e29458a7 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: 3a62f64222 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: 9265cb7f02 user: drh tags: trunk) | |
| 01:45 | Improvements to the autoconf TEA Makefile for MSVC. (check-in: cffcf12f03 user: mistachkin tags: trunk) | |
|
2020-01-20
| ||
| 15:32 | Merge recent fixes from trunk. (check-in: 9c920bbad3 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: 63d886f4ce 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: 4d46255096 user: drh tags: trunk) | |
|
2020-01-18
| ||
| 23:52 | Documentation improvements. (check-in: 535afe1509 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: 1accfa8cf0 user: drh tags: trunk) | |
| 21:35 | • Closed ticket [830277d9db]: Non-deterministic date/time functions allowed in CHECK constraints plus 5 other changes (artifact: dfd3e472d1 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: 8c8ce526ad user: drh tags: trunk) | |
| 19:58 | Fix a couple of test case issues on this branch. (check-in: 9830a44bc6 user: dan tags: reuse-schema) | |
| 19:46 | Do not use memcpy() of zero bytes when initializing a pager. This avoids a warning. (check-in: cca437788e 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: 3c63f68e12 user: drh tags: trunk) | |
| 19:02 | Fix harmless compiler warning seen with MSVC. (check-in: cd0437ba5b 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: 7a4ec57985 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: fee945671a 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: a1be6ee018 user: drh tags: trunk) | |
|
2020-01-17
| ||
| 23:27 | Fix a typo in a comment. No code changes. (check-in: 4363f69c3a 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: 84f314902c 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: 7584e4b649 user: drh tags: trunk) | |
| 16:47 | Improved rounding in the 'unixepoch' feature of the date and time functions. (check-in: c9abf1bd2d 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: 4d6cb28811 user: dan tags: trunk) | |
| 15:33 | More restrictions on changes to shadow tables when in defensive mode. (check-in: b302b260ca 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: 3d13fbf248 user: drh tags: branch-3.28) | |
| 14:56 | Do not allow shadow tables to be dropped in defensive mode. (check-in: ad1f760f16 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: be4269c624 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: cbcbb1e5a9 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: a370871e21 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: 52206488f3 user: drh tags: trunk) | |
| 16:32 | Add the SQLITE_FCNTL_CKPT_DONE file-control for the use of custom VFSs. (check-in: 3cc39e5069 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: 1bc783da63 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: f8801ffd94 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: 86b5e5a20e 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: af06f80a59 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: 1194a42add user: drh tags: reuse-schema) | |
| 16:20 | • Fixed ticket [a08879a4a4]: Assertion `pKeyInfo->enc==ENC(db)' failed. plus 6 other changes (artifact: c6b7444e68 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: 03b003c988 user: drh tags: trunk) | |
| 14:38 | • New ticket [a08879a4a4] Assertion `pKeyInfo->enc==ENC(db)' failed.. (artifact: 2c879cc963 user: yongheng) | |
| 14:26 | Merge all recent enhancements and fixes from trunk. (check-in: f783917800 user: drh tags: reuse-schema) | |
| 14:21 | Merge in the latest trunk changes via the begin-concurrent-pnu branch. (check-in: 350627f3b1 user: drh tags: begin-concurrent-pnu-wal2) | |
| 14:11 | Merge recent enhancements and fixes from trunk. (check-in: 35eae71a4d user: drh tags: wal2) | |
| 13:48 | Merge all recent enhancements and fixes from trunk. (check-in: 110a081f12 user: drh tags: begin-concurrent-pnu) | |
| 13:34 | Merge fixes and enhancements from trunk into begin-concurrent. (check-in: 95ba2f50fd user: drh tags: begin-concurrent) | |
| 12:49 | Merge all recent enhancements and fixes from trunk into the apple-osx branch. (check-in: dadedf41c7 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: 3d7434a9d8 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: 54bf048119 user: drh tags: trunk) | |
| 16:33 | Add the new noop_nd() debugging function to the noop.c extension. (check-in: 72911fb1b0 user: drh tags: trunk) | |
| 14:47 | • Edit [5b246b47aeadc25d|5b246b47ae]: Edit check-in comment. (artifact: 42fe000a4e 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: 9ce2192b81 user: drh tags: trunk) | |
| 13:13 | Fix a minor typo on a comment in the CLI implementation. (check-in: db4fb3503c user: drh tags: trunk) | |
| 00:52 | Improvements to sqlite3_open_v2() documentation. (check-in: 4c4fd62a09 user: drh tags: trunk) | |
|
2020-01-13
| ||
| 15:25 | More documentation updates. No code changes. (check-in: a684d4ef08 user: drh tags: trunk) | |
| 13:33 | Documentation updates. No changes to code. (check-in: cc0e0aa3a7 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: 3e3c60d812 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: 0e468aa6de user: drh tags: trunk) | |
| 22:20 | • Fixed ticket [614b25314c]: Assertion (pTabItem0.fg.jointype & JT_LEFT)==0 || ExprHasProperty(pOrExpr, EP_FromJoin) failed plus 5 other changes (artifact: 6def3b4465 user: drh) | |
| 22:20 | Remove an incorrect assert(). Fix for ticket [614b25314c766238] (check-in: 6a999c5aa0 user: drh tags: trunk) | |
| 21:51 | • New ticket [614b25314c] Assertion (pTabItem0.fg.jointype & JT_LEFT)==0 || ExprHasProperty(pOrExpr, EP_FromJoin) failed. (artifact: 5e9929959e user: yongheng) | |
| 20:47 | • Edit [3d23a275ab5d7d50|3d23a275ab]: Edit check-in comment. (artifact: d4a65be118 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: fd7bcc5352 user: drh tags: trunk) | |
| 20:27 | Minor changes for consistency between sqlite3_filename_wal() and sqlite3_filename_journal(). (Closed-Leaf check-in: 9a70ff43a7 user: drh tags: enhanced-uri) | |
| 16:08 | Redesign for better legacy compatibility. Add the sqlite3_uri_key() interface. (check-in: bcb43d11c4 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: 2ae77bd233 user: drh tags: enhanced-uri) | |
| 01:33 | • Ticket [5c5a16ec29] Test ticket status still Closed with 3 other changes (artifact: 740a156071 user: yongheng) | |
| 01:32 | • Fixed ticket [a148d923bf]: Assertion `memIsValid(pCtx->argvi)' failed. plus 5 other changes (artifact: 702ee02fc3 user: yongheng) | |