Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
313 check-ins using file src/alter.c version f48a4423
|
2020-04-02
| ||
| 19:58 | Fix a minor problem with EXPLAIN QUERY PLAN for triggers. (check-in: 6e11c03f user: drh tags: bytecode-function) | |
| 17:21 | Minor changes for better test coverage. (check-in: ae3ac297 user: drh tags: bytecode-function) | |
| 13:21 | Fix an obsolete comment in the parameter binding logic of the CLI. No changes to code. (check-in: c9c735e2 user: drh tags: trunk) | |
| 13:08 | Fix another harmless compiler warning. (check-in: 949eec25 user: drh tags: bytecode-function) | |
| 12:53 | Add a missing #ifdef to avoid a harmless compiler warning. (check-in: cc54de35 user: drh tags: bytecode-function) | |
| 12:24 | Merge enhancements from trunk. (check-in: d1731385 user: drh tags: bytecode-function) | |
|
2020-04-01
| ||
| 17:10 | Add support for the "ANALYZE WITH LIMIT=N" syntax. (Leaf check-in: 7e666b60 user: drh tags: analyze-with-limit) | |
| 01:15 | Simple fixes to PRAGMA analysis_limit. (check-in: c20d4fde user: drh tags: approximate-analyze) | |
|
2020-03-31
| ||
| 20:57 | Add "PRAGMA analysis_limit=N;" to limit the number of rows visited by ANALYZE when N is positive. Positive N also disables collecting stat4. (check-in: a279b151 user: drh tags: approximate-analyze) | |
| 18:41 | Merge recent enhancements from trunk. (check-in: c705ce26 user: drh tags: approximate-analyze) | |
|
2020-03-30
| ||
| 19:38 | Minor bug fix in NATSORT collating function. (check-in: a61be109 user: drh tags: natsort) | |
| 15:39 | Add the NATSORT collating sequence. No test cases yet. (check-in: 79fcaa8e user: drh tags: natsort) | |
| 13:35 | Use __atomic_load_n() and __atomic_store_n() for a few more things where they are available. (check-in: a49f8ec5 user: dan tags: trunk) | |
| 11:17 | Fix "GCC_VESRION" typo in wal.c. (check-in: fbd93787 user: dan tags: trunk) | |
|
2020-03-28
| ||
| 19:02 | Enhancements to the SQLITE_ENABLE_SETLK_TIMEOUT compile-time option to avoid rare deadlocks on recovery. (check-in: 06885e9a user: drh tags: trunk) | |
| 12:01 | MSVC does not allow constant expressions as initializers for constants with /fp:strict. (check-in: 076658e5 user: drh tags: trunk) | |
|
2020-03-27
| ||
| 17:23 | Modifications to the way blocking locks are used in SQLITE_ENABLE_SETLK_TIMEOUT builds so that multiple processes or threads may not deadlock when operating on a single database. (Closed-Leaf check-in: c516027d user: dan tags: setlk-deadlock-fix) | |
|
2020-03-26
| ||
| 16:48 | Add the tables_used() table-valued function as a variation on bytecode(). (check-in: 6283c677 user: drh tags: bytecode-function) | |
| 15:28 | Merge updates from trunk. (check-in: d7db0910 user: drh tags: bytecode-function) | |
| 00:29 | Reinstate the optimization that converts "x IN (y)" into "x==y". (check-in: 27936e68 user: drh tags: trunk) | |
|
2020-03-25
| ||
| 20:31 | For the LIKE pattern in the .dump command of the CLI, accept backslash as an escape character. (check-in: 029ceea6 user: drh tags: trunk) | |
| 12:50 | Enhance the ".dump" command in the CLI so that it accepts multiple LIKE pattern arguments and shows the union of all matching tables. (check-in: 45fba3d7 user: drh tags: trunk) | |
|
2020-03-24
| ||
| 18:41 | Optimize the "subprog IS NULL" constraint. (check-in: ca8c5f02 user: drh tags: bytecode-function) | |
| 17:52 | Fix a memory leak. (check-in: c9f3405e user: drh tags: bytecode-function) | |
| 13:27 | Provide content for the bytecode.subprog column. (check-in: df893364 user: drh tags: bytecode-function) | |
|
2020-03-23
| ||
| 23:17 | Fix the build so that it works even without SQLITE_ENABLE_EXPLAIN_COMMENTS. (check-in: 5896cbf4 user: drh tags: bytecode-function) | |
| 20:58 | The bytecode() function now runs and sometimes works, but it untested and there are known problems. (check-in: 6819b86e user: drh tags: bytecode-function) | |
| 19:14 | Further simplification and modularization of the EXPLAIN logic. (check-in: aee1c12f user: drh tags: bytecode-function) | |
| 17:24 | Begin breaking appear the sqlite3VdbeList() routine into subroutines that can be reused by the bytecode() table. (check-in: 2c4dd79f user: drh tags: bytecode-function) | |
| 15:49 | Infrastructure for the bytecode() table-valued function. The function itself is not yet implemented. (check-in: 2795f0d6 user: drh tags: bytecode-function) | |
|
2020-03-21
| ||
| 23:10 | Fix to the recomputation of the colUsed field added by check-in [a9bb71ba708ba722]. This fixes ticket [5829597ac43811e3]. (check-in: 5d14a1c4 user: drh tags: trunk) | |
| 22:03 | Enhance the treeview system to show the SrcList_item.colUsed field for FROM clause elements. (check-in: 8a5c539b user: drh tags: trunk) | |
| 20:58 | Simplify some of the code modified by the previous commit. (check-in: 04abadb5 user: dan tags: trunk) | |
| 15:41 | Ensure that "main" can always be used to refer to the main database, even if it has been renamed using SQLITE_DBCONFIG_MAINDBNAME. (check-in: 682b426f user: dan tags: trunk) | |
| 15:10 | Consolidate some code on this branch. (Closed-Leaf check-in: a85c63da user: dan tags: main-alias-fix) | |
| 15:07 | Change a bitfield in sqlite3_stmt into an unsigned character, for slightly smaller code and better performance. (check-in: 0d4d3c64 user: drh tags: trunk) | |
| 14:22 | Performance optimization in sqlite3VdbeMakeReady(). (check-in: aa92f9b9 user: drh tags: trunk) | |
| 14:05 | Merge updates from trunk. (Leaf check-in: 2383aa2c user: drh tags: explain-improvements) | |
| 03:40 | Back out the sqlite3_stmt_mode() and EXPLAIN TABLES enhancements, but keep the other miscellaneous improvements to EXPLAIN that were implemented while adding the above: Turn magic numbers into symbolic constants. Add the sqlite3MemPrint() interface accessible to the debugger. Improve the performance and reduce the code size. (check-in: 62aece66 user: drh tags: explain-improvements) | |
| 00:05 | Recompute the set of columns used for each table when the table is involved in query flattening. (check-in: a9bb71ba user: drh tags: trunk) | |
|
2020-03-20
| ||
| 20:54 | Allow "main" to be used to refer to the main database even after SQLITE_DBCONFIG_MAINDBNAME has been used to assign another alias. (check-in: 75c85ca3 user: dan tags: main-alias-fix) | |
| 20:18 | Avoid an undefined integer overflow in fts3 by detecting data structure corruption earlier. (check-in: 86e98ddc user: dan tags: trunk) | |
| 20:00 | Add the EXPLAIN TABLES syntax that uses SQLITE_STMTMODE_TABLELIST. Seems to work, but not well-tested. (Leaf check-in: e7343ce7 user: drh tags: sqlite3_stmt_mode) | |
| 17:49 | Further simplification of the EXPLAIN logic. Fix the test errors from the previous check-in. (check-in: 5eaba9af user: drh tags: sqlite3_stmt_mode) | |
| 16:13 | Revamp the EXPLAIN infrastructure to facilitate sqlite3_stmt_mode(). The currently code mostly works, but there are test failures. This is an incremental check-in. (check-in: e9e17e21 user: drh tags: sqlite3_stmt_mode) | |
|
2020-03-19
| ||
| 21:17 | Initial code for a proposed new sqlite3_stmt_mode() API. This is an incomplete snapshot of a work-in-progress. (check-in: 3cf7537b user: drh tags: sqlite3_stmt_mode) | |
| 18:13 | Change the ESCAPE clause on the LIKE operator to override wildcard characters, in order to match the behavior of PosgreSQL. (check-in: 11e0844f user: drh tags: trunk) | |
| 17:27 | Fix an integer overflow problem with the dbstat virtual table that comes up when trying to analyze a corrupt database. (check-in: 1d64f4a8 user: drh tags: trunk) | |
| 15:57 | Fix a typo in a comment. No changes to code. (check-in: 3a51919a user: drh tags: trunk) | |
|
2020-03-18
| ||
| 15:58 | Fix the build for when SQLITE_ENABLE_STAT4 is defined. (check-in: 8f0a8c2a user: drh tags: approximate-analyze) | |
| 14:43 | Add the SQLITE_ANALYZE_LIMIT compile-time option (expected to be temporary) that sets a threshold at which ANALYZE starts to use approximations during the analysis process. (check-in: a773fd46 user: drh tags: approximate-analyze) | |
|
2020-03-17
| ||
| 17:11 | Provide an estimated row count to stat_init() for STAT1 analysis. (check-in: 714419fe user: drh tags: approximate-analyze) | |
| 13:41 | Remove the SQLITE_OMIT_BTREECOUNT option. Btree count is required. (check-in: a9bfa47a user: drh tags: approximate-analyze) | |
| 13:07 | Improved bytecode comments for the ANALYZE command. (check-in: c38ea413 user: drh tags: approximate-analyze) | |
| 12:37 | Merge changes from trunk. (check-in: 93d71026 user: drh tags: approximate-analyze) | |
|
2020-03-16
| ||
| 18:52 | Fix handling of window functions in aggregate queries that have no GROUP BY clause. Also remove a faulty assert causing the error reported in [618156e3]. (check-in: 38e3dd38 user: dan tags: trunk) | |
| 03:07 | At the end of the right-hand table loop of a LEFT JOIN that uses an IN operator in the ON clause, put the OP_IfNoHope operator after the OP_IfNotOpen operator, not before, to avoid a (harmless) uninitialized register reference. Ticket [82b588d342d515d1] (check-in: 8b437b47 user: drh tags: trunk) | |
|
2020-03-13
| ||
| 07:28 | Merge SQLITE_NOOP_UPDATE fix into this branch. (check-in: e2cc655e user: dan tags: begin-concurrent-report) | |
| 07:23 | Fix a typo causing SQLITE_NOOP_UPDATE builds to fail. (check-in: 1e2109fd user: dan tags: begin-concurrent-pnu) | |
|
2020-03-12
| ||
| 19:37 | Add link from begin_concurrent_report.md back to branch timeline. (check-in: 61869f8b user: dan tags: begin-concurrent-report) | |
| 17:54 | Remove stray comment characters at the end of an #ifdef that were accidently left in the previous check-in. (check-in: ea914bec user: drh tags: trunk) | |
| 17:28 | Fix comments and strengthen assert() statements associated with the OPFLAG_SEEKEQ and BTREE_SEEK_EQ flags. (check-in: 23174921 user: drh tags: trunk) | |
|
2020-03-11
| ||
| 20:03 | Merge enhancements from trunk. (check-in: 4945a662 user: drh tags: approximate-analyze) | |
| 19:56 | Do not factor out constant functions into the initialization section of a prepared statement, because even though they are constant, they can still throw exceptions. Instead, put such functions in an OP_Once block. This fixes ticket [3c9eadd2a6ba0aa5] and causes COALESCE() and CASE...END to be short-circuit. (check-in: c5f96a08 user: drh tags: trunk) | |
| 19:41 | Rename sqlite3ExprCodeAtInit() to sqlite3ExprCodeRunJustOnce(). Other changes to make the new code cleaner. Test cases added. (Closed-Leaf check-in: d7f18489 user: drh tags: do-not-factor-functions) | |
| 19:30 | Add documentation notes and fix outstanding issues on this branch. (check-in: b288bbd1 user: dan tags: begin-concurrent-report) | |
| 17:58 | Do not factor out constant functions into the initialization section at the end of the prepared statement, be cause if they throw an exception, it will abort the statement even if the function is never called. Better to put constant functions in an OP_Once block. (check-in: 97a18a5c user: drh tags: do-not-factor-functions) | |
| 16:46 | Support reporting of blob fields. (check-in: 724a4a84 user: dan tags: begin-concurrent-report) | |
| 02:04 | This variant to the fix for ticket [e0c2ad1aa8a9c691] uses fewer CPU cycles. (check-in: fb5a8a9e user: drh tags: trunk) | |
|
2020-03-10
| ||
| 22:55 | Merge updates from trunk. (check-in: e05f743f user: drh tags: approximate-analyze) | |
| 21:14 | Fix test and other problems with reporting pages read and written. (check-in: 9ae970fd user: dan tags: begin-concurrent-report) | |
| 19:55 | Fix problem in test script concreport.test. (check-in: 32d1b721 user: dan tags: begin-concurrent-report) | |
| 19:24 | Enhanced detection logic for preventing the use of static schema expressions by code generating routines. (check-in: 5f60b527 user: drh tags: trunk) | |
| 19:23 | Prevent the read-only expressions held in the schema from being passed down into code generating subroutines where they might be changed. Pass a copy of the expression instead. (check-in: 2b750b0f user: drh tags: branch-3.31) | |
| 18:55 | Further changes to ensure that expressions held in table and index definitions do not get passed down into code generator logic where they might be modified. (check-in: f45f5de0 user: drh tags: trunk) | |
| 13:35 | Make a copy of the expression that defines a value of a generated column before sending it to the code generator routines. (check-in: 03d201c0 user: drh tags: trunk) | |
| 11:50 | Apply the correct affinity transformations when pulling values off of the sorter index used for GROUP BY. Ticket [e0c2ad1aa8a9c691] (check-in: 101f7dea user: drh tags: trunk) | |
| 02:57 | The sqlite3ExprCodeFactorable() routine should make a copy of non-factorable expressions, as they might be coming from a DEFAULT or generated column in a table constraint. (check-in: a2d6f108 user: drh tags: trunk) | |
| 01:24 | Background work for experiments trying to enhance ANALYZE so that it runs off of samples of the entire index and does not need to read the entire index. (check-in: 29d1cc5c user: drh tags: approximate-analyze) | |
|
2020-03-09
| ||
| 21:00 | Report on pages, as well as keys, read and written by BEGIN CONCURRENT transactions. (check-in: b661ccc8 user: dan tags: begin-concurrent-report) | |
| 18:26 | Cleaner separation of the STAT4-specific logic in the implementation of ANALYZE. (check-in: 3df07e5a user: drh tags: trunk) | |
| 15:39 | Enhancements to the ".import" command of the CLI. (check-in: cab1834c user: drh tags: trunk) | |
| 03:21 | Fix typos in RowSet. (check-in: 86465c08 user: pdr tags: trunk) | |
| 01:02 | Fix typos in the Lemon documentation. (check-in: 35f1f151 user: drh tags: trunk) | |
|
2020-03-08
| ||
| 13:33 | Avoid a redundant NULL check (check-in: 25dc53f6 user: pdr tags: trunk) | |
|
2020-03-07
| ||
| 16:51 | Fix reporting cases related to UPDATE. And of WITHOUT ROWID tables. (check-in: d28d1739 user: dan tags: begin-concurrent-report) | |
|
2020-03-06
| ||
| 20:51 | Enhancement to log logical writes as well as reads. (check-in: 1c1f180e user: dan tags: begin-concurrent-report) | |
|
2020-03-05
| ||
| 20:59 | Fix reporting for indexed range scans that extend past the end of the data. (check-in: ab458a31 user: dan tags: begin-concurrent-report) | |
| 18:04 | Report an error if the main, or any other, database encoding is modified by an external process (perhaps using the backup API) after the db has been opened. (check-in: 895bd20b user: dan tags: trunk) | |
| 16:13 | Change the sqlite3.pDfltColl (the default collating sequence for the database connection) so that it is the collating sequence appropriate for the database encoding, not the UTF8 collating sequence. This helps to ensure that the database encoding collation is always used, even for expressions that do not have an defined collating sequence. Ticket [1b8d7264567eb6fc]. (check-in: 4a585189 user: drh tags: trunk) | |
| 14:19 | When printing the OP_CollSeq opcode for EXPLAIN listings, include the text encoding with the name of the collating sequence. (check-in: eb5c1b77 user: drh tags: trunk) | |
|
2020-03-04
| ||
| 19:17 | Fix cases to do with index scans. (check-in: 6ec5a899 user: dan tags: begin-concurrent-report) | |
|
2020-03-03
| ||
| 21:01 | Extend begin_concurrent_report() so that it reports on accesses to non-intkey tables as well. (check-in: 427e2c9d user: dan tags: begin-concurrent-report) | |
| 20:48 | Fix a false-positive in the debugging logic that attempts to detect the use of uninitialized registers inside triggers. Ticket [c4c56482ced89d90] (check-in: 0463576b user: drh tags: trunk) | |
| 20:04 | Remove an invalid assert() on the debugging logic that checks to ensure that register values are not used after they go stale. Ticket [d165ad781b39d574]. (check-in: bd94d7d0 user: drh tags: trunk) | |
| 01:16 | Improved detection of corruption in the interior nodes of a segment btree in FTS3/4. (check-in: cc99447a user: drh tags: trunk) | |
|
2020-03-02
| ||
| 21:00 | Fix reporting for some range scan cases. (check-in: ad961aee 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: a65c8d4e user: drh tags: trunk) | |
| 15:05 | Merge latest begin-concurrent-pnu changes with this branch. (check-in: b1880b18 user: dan tags: begin-concurrent-report) | |
| 01:50 | Fix a faulty assert() statement in the stale-register detection logic. Ticket [da5a09be6dabbf42]. (check-in: 219c296c user: drh tags: trunk) | |
| 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: 704bb9a3 user: drh tags: trunk) | |
|
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: 1e174ed0 user: dan tags: trunk) | |
| 15:53 | In the CLI, add the ".oom" command for debugging builds. (check-in: 9c3136a7 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: 85a9b6a9 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: f71a13d0 user: dan tags: trunk) | |
| 16:21 | Fix harmless compiler warnings from MSVC. (check-in: 951b39ca user: drh tags: trunk) | |
| 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: 59726777 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: 63e533d2 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: 9c77bfe4 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: bfb09371 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: 47d4240c 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: 40739c79 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: 4558163b user: drh tags: stat4-truthprob) | |
| 13:35 | Disable the new analyzeG.test module if not building with STAT4. (check-in: 4a9d3005 user: drh tags: stat4-truthprob) | |
| 13:26 | Merge bugfix from trunk. (check-in: b542dee9 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: c431b3fd 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: c535fea1 user: drh tags: stat4-truthprob) | |
| 17:32 | Add new test file analyzeG.test, containing a test for the change on this branch. (check-in: 243ab185 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: 1babd6ec 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: f02030b3 user: drh tags: trunk) | |
|
2020-02-20
| ||
| 14:11 | Add test case for previous commit. (check-in: 14d14eb5 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: a67cf5b7 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: 5aeb5a2d 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: ee034fe9 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: 9469f36a user: drh tags: trunk) | |
|
2020-02-17
| ||
| 23:08 | Convert invalid surrogates to 0xfffd when translating UTF. (check-in: 7fab1393 user: drh tags: trunk) | |
| 19:25 | A better (smaller and faster) solution to ticket [4374860b29383380]. (check-in: abc473fb 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: 9d0d4ab9 user: drh tags: trunk) | |
|
2020-02-16
| ||
| 17:40 | Avoid an infinite recursion on an illegal recursive definition of an fts5vocab table. (check-in: 109ee074 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: c9a8defc user: drh tags: trunk) | |
| 14:51 | Disallow the skip-scan optimization in the absence of sqlite_stat1 data. (check-in: e0c6b8bd 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: 0c683c43 user: drh tags: trunk) | |
| 11:46 | Fix an incorrect assert() statement that was added yesterday. Tickets [41c1456a6e61c0e7] and [fb8c538a8f57ae2a]. (check-in: abfb043e 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: 2def7569 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: 16aed5d0 user: dan tags: trunk) | |
|
2020-02-10
| ||
| 19:37 | Fix a typo in the in-tree begin-concurrent documentation (check-in: b13dae1c user: drh tags: begin-concurrent) | |
| 19:24 | Mark the sha1() extension function as SQLITE_DETERMINISTIC. (check-in: 7d8dcfb9 user: drh tags: trunk) | |
| 13:29 | Fix the build for when SQLITE_VDBE_COVERAGE is used. (check-in: 08438164 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: bcf876e6 user: drh tags: trunk) | |
| 01:12 | Simplify the code by removing the unsupported and undocumented SQLITE_HAS_CODEC compile-time option (check-in: 5a877221 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: a8a7c05b 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: cec5f920 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: 447d71f0 user: drh tags: trunk) | |
| 13:09 | Remove dead code from the sqlite3_filename_database() function. (check-in: 1b618555 user: drh tags: trunk) | |
| 11:02 | Fix a 4 byte OOB read in test_multiplex.c. (check-in: 6279f69f user: dan tags: branch-3.31) | |
| 10:55 | Fix some fts3 problems found by usan. (check-in: fb7ccf61 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: ae6dd8d3 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: 76668b55 user: dan tags: begin-concurrent-pnu-wal2) | |
| 20:11 | Merge latest trunk changes into this branch. (check-in: 6ad4d6b7 user: dan tags: wal2) | |
| 20:09 | Merge latest trunk changes, including the SQLITE_ENABLE_CORRUPT_PGNO patch, into this branch. (check-in: 23bc80cc user: dan tags: begin-concurrent-pnu) | |
| 20:08 | Merge latest trunk changes, including the SQLITE_ENABLE_CORRUPT_PGNO patch, into this branch. (check-in: f253618a 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: 57c36a29 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: 29a969d6 user: drh tags: trunk) | |
| 00:55 | Fix a problem with the byte-code decompiler that was inserted by the enhancements at [4248980a356f659b] (check-in: af63e95d 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: 0ea2dbfc user: drh tags: trunk) | |
| 12:25 | Increase the version number to 3.32.0. (check-in: 8130bbb4 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: 1d4f8620 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: 4248980a 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: 1240ee4f user: drh tags: apple-osx) | |
| 14:20 | Merge the sqlite3CodecQueryParameters() fix into trunk. (check-in: a812f533 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: cc65ca54 user: drh tags: branch-3.31) | |
| 00:08 | Merge version 3.31.1 (check-in: d250d085 user: numist tags: apple-osx) | |
|
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
| ||
| 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) | |
|
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: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: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: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) | |
| 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
| ||
| 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: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: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) | |
| 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) | |
| 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
| ||
| 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: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) | |
| 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 | Remove an incorrect assert(). Fix for ticket [614b25314c766238] (check-in: 6a999c5a user: drh tags: trunk) | |
|
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: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: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) | |
| 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:18 | Minor formatting changes in the trusted-schema.md document. (check-in: 55553b5e user: drh tags: new-security-options) | |
| 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 | 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) | |
| 04:36 | Simplification of the logic in the constant-propagation optimization. (check-in: 1c3e5c20 user: drh tags: trunk) | |
| 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
| ||
| 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
| ||
| 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) | |
| 19:30 | Merge enhancements from trunk. (check-in: 9c50f6c2 user: drh tags: new-security-options) | |
| 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) | |
| 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: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: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) | |
| 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:19 | Merge all fixes and enhancements from trunk. (check-in: b878c30f user: drh tags: new-security-options) | |
| 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: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) | |
| 15:37 | Merge the latest fixes from trunk. (check-in: 26ef709a user: drh tags: new-security-options) | |
| 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) | |
| 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) | |