/ Timeline
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

200 most recent check-ins using file src/os.h version 4838882169

2020-04-07
15:07
Limit LIKE/GLOB pattern length to 100 bytes (default is 50K) when running dbsql cases in the fuzzcheck utility. Leaf check-in: 10306118e8 user: drh tags: trunk
13:08
Add the --spinner option to the fuzzcheck test program. check-in: b1eae2686f user: drh tags: trunk
01:18
The ALTER TABLE fix of check-in [7e5ad8e0ab7ee91a] is no longer needed due to the changes at check-in [4cf8721f5ceb1fda]. But, we keep the defense in place as an assert() for extra safety. check-in: 230556e859 user: drh tags: trunk
00:54
Remove dead code that was added during initial development of RENAME COLUMN but never actually served a purpose. check-in: c95c4cda46 user: drh tags: trunk
2020-04-06
20:35
Performance improvement in sqlite3ResolveExprNameList(). check-in: 7e170e67f2 user: drh tags: trunk
18:16
Performance improvement for column name lookup. check-in: 1e4b6a9398 user: drh tags: trunk
16:37
When running ALTER TABLE, avoid adding some internally generated tokens to the token map to improve performance on schemas with nested views. check-in: 4cf8721f5c user: dan tags: trunk
2020-04-04
11:58
Remove a NEVER() that could be true in sqlite3MatchEName(). check-in: 921448f0e2 user: drh tags: trunk
00:29
In the push-down optimization, do not substitute columns that have previously been identified as being constant by the propagate-constants optimization. Fix for ticket [51166be0159fd2ce]. Also, avoid factoring out constant expressions on the LHS of an IN(...) operator, as the IN(...) operation may affect the affinity of these values. Fix for [fd1bda016d1]. Leaf check-in: 43612157f8 user: drh tags: branch-3.31
00:15
In the push-down optimization, do not substitute columns that have previously been identified as being constant by the propagate-constants optimization. Fix for ticket [51166be0159fd2ce] check-in: 70c44811d1 user: drh tags: trunk
2020-04-03
20:14
Restore an #if block inadvertently removed via check-in [9c77bfe41e]. check-in: bf6bcfc16e user: mistachkin tags: branch-3.31
19:37
Avoid factoring out constant expressions on the LHS of an IN(...) operator, as the IN(...) operation may affect the affinity of these values. Fix for [fd1bda016d1]. check-in: 98d56b4a34 user: dan tags: trunk
16:11
Add a test case to fuzzdata8.db for the recent Henry Liu bugs. check-in: 42b02454b1 user: drh tags: trunk
15:48
Merge updates from trunk. Leaf check-in: 348c40136c user: drh tags: bytecode-function
13:39
Do not suppress errors when resolving references in an ORDER BY clause belonging to a compound SELECT within a view or trigger within ALTER TABLE. Fix for ticket [a10a14e9b4ba2]. Also, in the event of a semantic error in an aggregate query, early-out the resetAccumulator() function to prevent problems due to incomplete or incorrect initialization of the AggInfo object. Fix for ticket [af4556bb5c285c08]. check-in: b64674919f user: drh tags: branch-3.31
13:29
Fix a case when a pointer might be used after being freed in the ALTER TABLE code. Fix for [4722bdab08cb1]. check-in: 52f800fa93 user: drh tags: branch-3.31
13:19
In the event of a semantic error in an aggregate query, early-out the resetAccumulator() function to prevent problems due to incomplete or incorrect initialization of the AggInfo object. Fix for ticket [af4556bb5c285c08]. check-in: 4a302b42c7 user: drh tags: trunk
11:52
Do not suppress errors when resolving references in an ORDER BY clause belonging to a compound SELECT within a view or trigger within ALTER TABLE. Fix for ticket [a10a14e9b4ba2]. check-in: 684293882c user: dan tags: trunk
11:20
Fix a case when a pointer might be used after being freed in the ALTER TABLE code. Fix for [4722bdab08cb1]. check-in: d09f8c3621 user: dan tags: trunk
2020-04-02
19:58
Fix a minor problem with EXPLAIN QUERY PLAN for triggers. check-in: 6e11c03f84 user: drh tags: bytecode-function
17:21
Minor changes for better test coverage. check-in: ae3ac297d2 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: c9c735e201 user: drh tags: trunk
13:08
Fix another harmless compiler warning. check-in: 949eec2530 user: drh tags: bytecode-function
12:53
Add a missing #ifdef to avoid a harmless compiler warning. check-in: cc54de3543 user: drh tags: bytecode-function
12:24
Merge enhancements from trunk. check-in: d1731385c0 user: drh tags: bytecode-function
2020-04-01
17:10
Add support for the "ANALYZE WITH LIMIT=N" syntax. Leaf check-in: 7e666b6022 user: drh tags: analyze-with-limit
01:15
Simple fixes to PRAGMA analysis_limit. Leaf check-in: c20d4fdee2 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: a279b151c1 user: drh tags: approximate-analyze
18:41
Merge recent enhancements from trunk. check-in: c705ce266a user: drh tags: approximate-analyze
2020-03-30
19:38
Minor bug fix in NATSORT collating function. Leaf check-in: a61be10927 user: drh tags: natsort
15:39
Add the NATSORT collating sequence. No test cases yet. check-in: 79fcaa8e07 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: a49f8ec552 user: dan tags: trunk
11:17
Fix "GCC_VESRION" typo in wal.c. check-in: fbd9378727 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: 06885e9aa4 user: drh tags: trunk
12:01
MSVC does not allow constant expressions as initializers for constants with /fp:strict. check-in: 076658e5d2 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: c516027d5f 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: 6283c677d5 user: drh tags: bytecode-function
15:28
Merge updates from trunk. check-in: d7db091018 user: drh tags: bytecode-function
00:29
Reinstate the optimization that converts "x IN (y)" into "x==y". check-in: 27936e6884 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: 029ceea612 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: 45fba3d705 user: drh tags: trunk
2020-03-24
18:41
Optimize the "subprog IS NULL" constraint. check-in: ca8c5f028b user: drh tags: bytecode-function
17:52
Fix a memory leak. check-in: c9f3405eea user: drh tags: bytecode-function
13:27
Provide content for the bytecode.subprog column. check-in: df893364b7 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: 5896cbf4d0 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: 6819b86eb2 user: drh tags: bytecode-function
19:14
Further simplification and modularization of the EXPLAIN logic. check-in: aee1c12f42 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: 2c4dd79fbd user: drh tags: bytecode-function
15:49
Infrastructure for the bytecode() table-valued function. The function itself is not yet implemented. check-in: 2795f0d633 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: 5d14a1c4f2 user: drh tags: trunk
22:03
Enhance the treeview system to show the SrcList_item.colUsed field for FROM clause elements. check-in: 8a5c539b77 user: drh tags: trunk
20:58
Simplify some of the code modified by the previous commit. check-in: 04abadb545 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: 682b426f56 user: dan tags: trunk
15:10
Consolidate some code on this branch. Closed-Leaf check-in: a85c63daa6 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: 0d4d3c6424 user: drh tags: trunk
14:22
Performance optimization in sqlite3VdbeMakeReady(). check-in: aa92f9b95f user: drh tags: trunk
14:05
Merge updates from trunk. Leaf check-in: 2383aa2cb8 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: 62aece6677 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: a9bb71ba70 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: 75c85ca32f user: dan tags: main-alias-fix
20:18
Avoid an undefined integer overflow in fts3 by detecting data structure corruption earlier. check-in: 86e98ddc19 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: e7343ce751 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: 5eaba9af1c 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: e9e17e2125 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: 3cf7537b5e 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: 11e0844f71 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: 1d64f4a8af user: drh tags: trunk
15:57
Fix a typo in a comment. No changes to code. check-in: 3a51919ac2 user: drh tags: trunk
2020-03-18
15:58
Fix the build for when SQLITE_ENABLE_STAT4 is defined. check-in: 8f0a8c2aa4 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: a773fd4698 user: drh tags: approximate-analyze
2020-03-17
17:11
Provide an estimated row count to stat_init() for STAT1 analysis. check-in: 714419fe85 user: drh tags: approximate-analyze
13:41
Remove the SQLITE_OMIT_BTREECOUNT option. Btree count is required. check-in: a9bfa47aee user: drh tags: approximate-analyze
13:07
Improved bytecode comments for the ANALYZE command. check-in: c38ea4139d user: drh tags: approximate-analyze
12:37
Merge changes from trunk. check-in: 93d710262e 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: 38e3dd389d 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: 8b437b4726 user: drh tags: trunk
2020-03-13
07:28
Merge SQLITE_NOOP_UPDATE fix into this branch. Leaf check-in: e2cc655e0d user: dan tags: begin-concurrent-report
07:23
Fix a typo causing SQLITE_NOOP_UPDATE builds to fail. Leaf check-in: 1e2109fd33 user: dan tags: begin-concurrent-pnu
2020-03-12
19:37
Add link from begin_concurrent_report.md back to branch timeline. check-in: 61869f8b48 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: ea914bec81 user: drh tags: trunk
17:28
Fix comments and strengthen assert() statements associated with the OPFLAG_SEEKEQ and BTREE_SEEK_EQ flags. check-in: 2317492138 user: drh tags: trunk
2020-03-11
20:03
Merge enhancements from trunk. check-in: 4945a66237 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: c5f96a085d 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: d7f1848997 user: drh tags: do-not-factor-functions
19:30
Add documentation notes and fix outstanding issues on this branch. check-in: b288bbd1df 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: 97a18a5cd7 user: drh tags: do-not-factor-functions
16:46
Support reporting of blob fields. check-in: 724a4a844d user: dan tags: begin-concurrent-report
02:04
This variant to the fix for ticket [e0c2ad1aa8a9c691] uses fewer CPU cycles. check-in: fb5a8a9edd user: drh tags: trunk
2020-03-10
22:55
Merge updates from trunk. check-in: e05f743f61 user: drh tags: approximate-analyze
21:14
Fix test and other problems with reporting pages read and written. check-in: 9ae970fdc1 user: dan tags: begin-concurrent-report
19:55
Fix problem in test script concreport.test. check-in: 32d1b7210a 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: 5f60b527b9 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: 2b750b0f74 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: f45f5de000 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: 03d201c041 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: 101f7dea75 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: a2d6f108c5 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: 29d1cc5c36 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: b661ccc88f user: dan tags: begin-concurrent-report
18:26
Cleaner separation of the STAT4-specific logic in the implementation of ANALYZE. check-in: 3df07e5a9a user: drh tags: trunk
15:39
Enhancements to the ".import" command of the CLI. check-in: cab1834cfc user: drh tags: trunk
03:21
Fix typos in RowSet. check-in: 86465c08f4 user: pdr tags: trunk
01:02
Fix typos in the Lemon documentation. check-in: 35f1f151ac user: drh tags: trunk
2020-03-08
13:33
Avoid a redundant NULL check check-in: 25dc53f660 user: pdr tags: trunk
2020-03-07
16:51
Fix reporting cases related to UPDATE. And of WITHOUT ROWID tables. check-in: d28d1739a6 user: dan tags: begin-concurrent-report
2020-03-06
20:51
Enhancement to log logical writes as well as reads. check-in: 1c1f180eb6 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: ab458a319f 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: 895bd20b29 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: 4a5851893c 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: eb5c1b77d1 user: drh tags: trunk
2020-03-04
19:17
Fix cases to do with index scans. check-in: 6ec5a8995f 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: 427e2c9d95 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: 0463576b5d 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: bd94d7d052 user: drh tags: trunk
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:50
Fix a faulty assert() statement in the stale-register detection logic. Ticket [da5a09be6dabbf42]. check-in: 219c296cc8 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: 704bb9a39a 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: 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. Leaf 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 Leaf 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. Leaf 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. Leaf check-in: 76668b5589 user: dan tags: begin-concurrent-pnu-wal2
20:11
Merge latest trunk changes into this branch. Leaf 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. Leaf 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
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
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: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: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