Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
63 check-ins for the month beginning 2020-02-01
Following month ↑|
2020-02-29
| ||
| 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 | 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) | |
|
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:34 | Fix a problem with ALTER TABLE for views that have a nested FROM clause. Ticket [f50af3e8a565776b]. (check-in: c431b3fd8f user: drh tags: trunk) | |
|
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: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) | |
|
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 | 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
| ||
| 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 | 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) | |
| 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:46 | Fix an incorrect assert() statement that was added yesterday. Tickets [41c1456a6e61c0e7] and [fb8c538a8f57ae2a]. (check-in: abfb043ebb user: drh tags: trunk) | |
|
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) | |
| 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) | |
|
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) | |
| 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
| ||
| 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) | |
| 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: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) | |