Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
386 check-ins using file tool/lemon.c version d44ba4f0
|
2021-05-11
| ||
| 11:33 | Merge changes from branch-3.35. Specifically, fixes for a running RBU with a cksumvfs VFS. (Leaf check-in: ca62c36b user: dan tags: reuse-schema-3.35) | |
| 11:25 | Fixes for cksmvfs and rbu so that they work together. (Leaf check-in: ce8b589e user: dan tags: branch-3.35) | |
|
2021-04-19
| ||
| 19:07 | Merge in the 3.35.5 patches. (check-in: 35d1c9a5 user: drh tags: reuse-schema-3.35) | |
| 18:32 | Version 3.35.5 (check-in: 1b256d97 user: drh tags: release, branch-3.35, version-3.35.5) | |
| 12:05 | Update the version number to 3.35.5. (check-in: d917b70a user: drh tags: branch-3.35) | |
|
2021-04-18
| ||
| 15:45 | Create new branch named "auth-vac" (Leaf check-in: 5a7410ac user: larrybr tags: auth-vac) | |
| 06:03 | Ensure that all records are updated by setting the OPFLAG_SAVEPOSITION flag when updating records as part of ALTER TABLE DROP COLUMN. Fix for [c88f3036a2]. (check-in: 11c368f2 user: dan tags: branch-3.35) | |
| 05:52 | Modify the drop column code to handle WITHOUT ROWID tables for which a single column appears more than once in the primary key. (check-in: cfa8912a user: dan tags: branch-3.35) | |
|
2021-04-13
| ||
| 18:39 | Fix a problem with handling expressions like "(col IS NULL AND <expr1>) OR col == NULL" in WHERE clauses. Reported at https://sqlite.org/forum/forumpost/1c4f2fdcc4. (check-in: e8c7bd34 user: drh tags: branch-3.35) | |
|
2021-04-07
| ||
| 15:23 | Merge version 3.35.4 with this branch. (check-in: 4b4f8791 user: dan tags: reuse-schema-3.35) | |
| 15:13 | Update a broken assert() on this branch. (check-in: e69f2989 user: dan tags: reuse-schema) | |
|
2021-04-02
| ||
| 15:20 | Version 3.35.4 (check-in: 5d4c6577 user: dan tags: release, branch-3.35, version-3.35.4) | |
| 11:59 | Fix incorrect RETURNING test cases in wherelimit.test (check-in: 64b0eb7e user: drh tags: branch-3.35) | |
|
2021-04-01
| ||
| 11:30 | When resolving names in the RETURNING clause, do not accept trigger names even within subquires. (check-in: 8541c71b user: drh tags: branch-3.35) | |
|
2021-03-31
| ||
| 17:49 | When resolving column names in the RETURNING clause, do not ignore an incorrect table name qualifier. Raise an error instead. (check-in: 3b916924 user: drh tags: branch-3.35) | |
| 13:51 | Defer deletion of expressions that are optimized out by the AND optimizer in the sqlite3ExprAnd() routine until the corresponding Parse object is deleted. This avoids a dangling pointer in AggInfo if sqlite3ExprAnd() is invoked by the push-down optimization. The dangling pointer appears to be harmless in release builds, only showing up in debug builds. Problem found by dbsqlfuzz. (check-in: 77a30f3f user: drh tags: branch-3.35) | |
| 13:41 | Ensure that negative numbers may not be used in frame offset clauses even if they are initially text value. e.g. (RANGE BETWEEN '-1' PRECEDING ...). (check-in: 2d179f58 user: drh tags: branch-3.35) | |
|
2021-03-30
| ||
| 01:57 | Raise an error if a term of the form "TABLE.*" appears in the RETURNING clause, as SQLite does not (yet) know how to handle that. Ticket [132994c8b1063bfb]. (check-in: 257e16f7 user: drh tags: branch-3.35) | |
|
2021-03-29
| ||
| 21:59 | Increase the patch number to 3.35.4. (check-in: 4375cec2 user: drh tags: branch-3.35) | |
| 21:16 | Do not do the EXISTS-to-IN transformation if the sub-select has LIMIT clause. Ticket [de7db14784a08053] (check-in: 3bf8a357 user: dan tags: branch-3.35) | |
|
2021-03-27
| ||
| 20:45 | Performance improvement in the comparison opcodes by rewriting an array lookup using pointer arithmetic. This makes gcc 5.4.0 builds with -Os both faster and smaller. Though I suspect that in newer compilers with better optimizers in will probably make no difference at all in the generated machine code. Later: Even though the new code is perfectly valid, and generates correct machine code that is both smaller and faster, UBSAN complains about it in OSSFuzz. So we will take it out. So here was have an example of OSSFuzz coercing a widely used application to become bigger and slower. (Leaf check-in: 4a8805d9 user: drh tags: gcc-opt) | |
| 16:21 | For the sqlite3_bind_text16 TCL binding used for testing, ensure that there are at least 3 terminating zeros, so that there will always be a \u0000 character even if the original byte sequence is an odd number of bytes. (check-in: c23d092f user: drh tags: trunk) | |
|
2021-03-26
| ||
| 23:59 | In the sqlite3_bind_text and sqlite3_bind_text16 TCL commands of the test suite, ensure that the string is zero-terminated if the size argument is negative. (check-in: f472fd64 user: drh tags: trunk) | |
| 14:04 | Merge up all the 3.35.3 changes into the begin-concurrent-pnu-wal2 branch. (check-in: 4d425e64 user: drh tags: begin-concurrent-pnu-wal2) | |
| 13:58 | Merge the 3.35.3 enhancements into the wal2 branch. (check-in: a1b8d9d2 user: drh tags: wal2) | |
| 13:47 | Merge patch 3.35.3 into the begin-concurrent-report branch. (check-in: 4ba9fc34 user: drh tags: begin-concurrent-report) | |
| 13:38 | Merge version 3.35.3 changes into the begin-concurrent-pnu branch. (check-in: 7e4c48af user: drh tags: begin-concurrent-pnu) | |
| 13:31 | Merge from 3.35.3 into the begin-concurrent branch. (check-in: 988da36c user: drh tags: begin-concurrent) | |
| 13:16 | Merge in changes for 3.35.3 (check-in: 76f19f4b user: drh tags: reuse-schema) | |
| 12:12 | Version 3.35.3 (check-in: 4c5e6c20 user: drh tags: release, branch-3.35, version-3.35.3) | |
|
2021-03-24
| ||
| 23:30 | Remove old testcases() macros. Also remove surplus end-of-line whitespace. (check-in: 54b41915 user: drh tags: trunk) | |
| 19:57 | Add a comment to snapshotrevert.c warning of the undefined effects reverting to an old snapshot may have on newer readers. (Leaf check-in: 00af3bd2 user: dan tags: snapshot-revert) | |
| 19:54 | Add experimental extension "snapshotrevert". (check-in: 2d5ee3ba user: dan tags: snapshot-revert) | |
| 19:44 | Comment improvements to on the distinct-agg optimization. Show a line in the EQP output when using an ephemeral table to implement DISTINCT on an aggregate. (check-in: 037ca79e user: drh tags: trunk) | |
| 17:28 | Improvements to distinct aggregates such that they can sometimes avoid using an ephermeral table to test for duplicates if the column that is distinct is part of an index. (check-in: ef4ac0dd user: drh tags: trunk) | |
| 17:04 | Fix a harmless compiler warning. (check-in: 26b005a9 user: drh tags: trunk) | |
|
2021-03-23
| ||
| 22:15 | Fix a problem with renaming a column when there is a quoted string immediately following the column name somewhere in the schema. (check-in: 4719fae6 user: dan tags: trunk) | |
| 21:02 | Add an ALWAYS() on a branch that is always taken. (check-in: 0646d226 user: drh tags: trunk) | |
| 19:39 | Test result adjustments in test/misc7.test due to the EQP format change. (check-in: d3ade8c7 user: drh tags: trunk) | |
| 16:34 | When doing schema updates, try to convert (incorrect) double-quoted strings into (SQL-standard) single-quoted strings. (check-in: 07704704 user: drh tags: trunk) | |
| 15:39 | Tweaks to test/scanstatus.test to account for the new EQP format. (check-in: 2eb28afd user: drh tags: trunk) | |
| 15:07 | Changes to test/analyzeG.test to conform to the new EXPLAIN QUERY PLAN syntax. (check-in: d8afde1b user: drh tags: trunk) | |
| 14:33 | Fix a test case in bigmmap.test so that it works with the new EXPLAIN QUERY PLAN output format. (check-in: 9ac064fe user: drh tags: trunk) | |
| 14:27 | Add the ExprList.nAlloc column and use it to make the sqlite3ExprListAppend() routine much faster. (check-in: 1d3c4662 user: drh tags: trunk) | |
| 01:06 | Enhance the EXPLAIN QUERY PLAN output to use symbolic names to describe subqueries, where possible, instead of cryptic subquery index numbers. And in other ways, make the EQP output cleaner and easier to read. Little code is changed, but many of the test results had to be tweaked to align with the new output format. (check-in: f8e28308 user: drh tags: trunk) | |
|
2021-03-22
| ||
| 18:53 | Merge recent fixes from trunk. (Closed-Leaf check-in: 4a343698 user: drh tags: eqp-improvements) | |
| 16:50 | Increase the version number to 3.36.0 to begin the next development cycle. (check-in: 5cee689d user: drh tags: trunk) | |
| 16:47 | This branch for any further patches on 3.35. We anticipate 3.35.3 in a few days. Hopefully there will never be a need for 3.35.4. (check-in: 8de4cb98 user: drh tags: branch-3.35) | |
|
2021-03-21
| ||
| 18:23 | Fix an assert() that in preupdate-hook logic (not normally built) that can be false when running VACUUM on a corrupt database file under PRAGMA writable_schema=ON. (check-in: 6bb21340 user: drh tags: trunk, same-as-3.35.3) | |
| 17:52 | Add a better comment and an assert() on the code inside sqlite3CreateIndex() that REPLACE indexes come at the end of the index list. forum post ceb51d83f7 (check-in: 71e4da13 user: drh tags: trunk) | |
|
2021-03-20
| ||
| 23:15 | Fix the "box" output mode in the shell when statement returns zero-column rows (for example from "PRAGMA incremental_vacuum"). (check-in: 34439fe3 user: drh tags: trunk) | |
| 15:46 | Use the canonical name, not the AS name, when showing the MATERIALIZE or CO-ROUTINE lines for a CTE. (check-in: 1b83e232 user: drh tags: eqp-improvements) | |
| 15:11 | Revise tests cases to align with the new EXPLAIN QUERY PLAN output. (check-in: 50fbd532 user: drh tags: eqp-improvements) | |
| 01:00 | Fix a faulty assert() in the OP_SkipScan opcode. dbsqlfuzz a15a9b2ca82e812ad52f62c86cc93dca0dc72f01. Test cases in TH3. (check-in: 1805b9aa user: drh tags: trunk) | |
|
2021-03-19
| ||
| 19:44 | Further simplification of the EQP output. Only show "SUBQUERY n" if the subquery is anonymous. (check-in: 1fadd305 user: drh tags: eqp-improvements) | |
| 19:09 | Merge enhancements from trunk. (check-in: d192d737 user: drh tags: eqp-improvements) | |
| 17:54 | In the wholenumber virtual table, increase the cost penalty for running open-loop. This appears to fix the problem reported by forum post b52a020ce4. (check-in: f12b5404 user: drh tags: trunk) | |
| 16:29 | Dbsqlfuzz found a new way to make that branch in codeVectorCompare reachable. (check-in: 959272c2 user: drh tags: trunk) | |
| 15:02 | Fix tokenizer's classification of EBCDIC newline. (check-in: 8680f6a8 user: larrybr tags: trunk) | |
| 14:51 | Restore the NEVER() that was taken out by [f481636f1a0333c6] because that case is no longer reachable after the previous check-in. (check-in: e3a78b2a user: drh tags: trunk) | |
| 14:26 | Fix a crash that could occur when an INSERT has more than one ON CONFLICT clause, at least one of which contains an unresolvable symbol. (check-in: 74208386 user: dan tags: trunk) | |
| 13:53 | Correlated CTEs should not generate a materialization subroutine. If they need to be materialized, each use case must be materialized separately. dbsqlfuzz 01b8355086998f0a452cb31208e80b9d29ca739a. (check-in: d72d865d user: drh tags: trunk) | |
| 13:00 | Improved labeling of EXPLAIN QUERY PLAN output. Many test failures due to the different output format. (check-in: 6f8faec0 user: drh tags: eqp-improvements) | |
|
2021-03-18
| ||
| 20:04 | Add a NEVER() on a branch that was made unreachable by the "circular reference" fix. (check-in: 114d9780 user: drh tags: trunk) | |
| 18:27 | Disable a test case requiring generate_series when virtual tables are not available. (check-in: ee86e2f4 user: drh tags: trunk) | |
| 18:25 | Fix a problem causing spurious "<cte>: circular reference" errors to be reported when there is actually a different error in the SQL statement. (check-in: 99812236 user: dan tags: trunk) | |
| 16:52 | Increase the patch level to 3.35.3. (check-in: 259b7c3e user: drh tags: trunk) | |
| 16:47 | Fix the OP_OpenDup opcode so that it is able to duplicate a cursor that was itself opened by OP_OpenDup. Add additional verification of ephemeral tables. Fix for ticket [bb8a9fd4a9b7fce5]. (check-in: bcbe5308 user: drh tags: trunk) | |
| 16:36 | Remove unnecessary code from sqlite3BtreeClose() and add test cases. (Closed-Leaf check-in: edbfdcae user: drh tags: opendup-fix) | |
| 15:42 | Further sanity checking of the OpenDup cursors. (check-in: 0ec71cf1 user: drh tags: opendup-fix) | |
| 14:36 | Fix the dbsqlfuzz-derived authorizer in fuzzcheck to avoid creating junk files when running rogue tests. (check-in: eca21a62 user: drh tags: trunk) | |
| 14:31 | Automatically close ephemeral b-trees when their last cursor is closed. (check-in: 39b5af18 user: dan tags: opendup-fix) | |
| 13:55 | Fix a problem with the filename normalizer in unix, discovered by dbsqlfuzz. (check-in: ff1eca7f user: drh tags: trunk) | |
| 13:42 | Allow instruction OP_OpenDup to duplicate cursors created by OP_OpenDup, as well as by OP_OpenEphemeral. (check-in: b8de980b user: dan tags: opendup-fix) | |
| 13:19 | New assert statements associated with Ephemeral cursors in the bytecode engine. (check-in: a8ce73e2 user: drh tags: trunk) | |
| 12:36 | Change the name of the iDataVersion field of Btree to iBDataVersion to make it distinct from Pager.iDataVersion. (check-in: e4c44c0b user: drh tags: trunk) | |
|
2021-03-17
| ||
| 19:52 | Update to version 3.35.2 (check-in: 18bec0d2 user: drh tags: reuse-schema) | |
| 19:07 | Version 3.35.2 (check-in: ea80f300 user: drh tags: trunk, release, version-3.35.2) | |
| 19:05 | Fix a harmless compiler warning in the appendvfs.c extension. (check-in: 0ed7eb91 user: drh tags: trunk) | |
| 14:29 | If there are already 500 or more simple SELECTs in a query, do not add more by flattening UNION ALL sub-queries into parent join queries. (check-in: 9520bed2 user: dan tags: trunk) | |
| 11:25 | Fix a problem in sqldiff virtual table hanlding to do with tab and other non-space whitespace characters in the CREATE VIRTUAL TABLE statement. (check-in: 1737e4fd user: dan tags: trunk) | |
|
2021-03-16
| ||
| 18:41 | Date/time functions with no arguments (ex: date() or time()) should be non-deterministic. Fix for ticket [2c6c8689fb5f3d2f]. (check-in: 1734c332 user: drh tags: trunk) | |
| 18:24 | Add tests for sqlite_rename_quotefix(). Fix a memory leak in the same. (Closed-Leaf check-in: 53155005 user: dan tags: alter-quotefix) | |
| 16:14 | Have ALTER TABLE RENAME COLUMN and DROP COLUMN use sqlite_rename_quotefix() to convert any double-quoted strings in the database schema to their single-quoted equivalents. (check-in: 6446c096 user: dan tags: alter-quotefix) | |
| 14:43 | Increase the version number to 3.35.2. (check-in: 7a211b3f user: drh tags: trunk) | |
| 14:26 | Fix recent breakage of the appendvfs extension. (check-in: 7dbbe5b3 user: drh tags: trunk) | |
| 14:12 | Comment and stylistic changes to the appendvfs.c implementation. (Closed-Leaf check-in: 25c3186a user: drh tags: appendvfs_fix) | |
| 11:21 | Merge trunk changes into this branch. (check-in: f15d5105 user: dan tags: alter-quotefix) | |
| 11:11 | Fix a problem with ALTER TABLE RENAME COLUMN when used on a schema that features generated columns. Fix for [a753a856]. (check-in: 0e255b26 user: dan tags: trunk) | |
| 07:06 | Fix assert typo. (check-in: 3aedf818 user: larrybr tags: appendvfs_fix) | |
| 06:50 | Merge from trunk. (check-in: eae8236f user: larrybr tags: appendvfs_fix) | |
| 06:41 | Fix appendvfs bug exposed with bigger files, and add tests for such conditions. (check-in: 19b1f53a user: larrybr tags: appendvfs_fix) | |
| 04:03 | Create new branch named "appendvfs_fix" (check-in: 026edd60 user: larrybr tags: appendvfs_fix) | |
|
2021-03-15
| ||
| 20:22 | Add internal SQL function sqlite_rename_quotefix(). For converting double-quoted strings to their single-quoted counterparts in DDL statements. (check-in: d874b300 user: dan tags: alter-quotefix) | |
| 19:34 | Merge version 3.35.1 into the reuse-schema branch. (check-in: 0fe60a63 user: drh tags: reuse-schema) | |
| 16:53 | Version 3.35.1 (check-in: aea12399 user: drh tags: trunk, release, version-3.35.1) | |
| 15:12 | Improvements to the built-in ".dump" documentation in the CLI. (check-in: 0915f969 user: drh tags: trunk) | |
| 15:02 | Bump the version number to 3.35.1. (check-in: 184d5a35 user: drh tags: trunk) | |
| 14:58 | Improved detection of conflicting indexes when doing DROP COLUMN on a column whose name is quoted in the index definition. Fix for ticket [1c24a659e6d7f3a1]. (check-in: c450d0ad user: drh tags: trunk) | |
| 12:56 | Make shell's .help output for .dump more accurate as to what can be dumped. (Closed-Leaf check-in: f91d8c09 user: larrybr tags: cli-tweaks) | |
| 12:32 | Create new branch named "cli-tweaks" (check-in: 4cf056a5 user: larrybr tags: cli-tweaks) | |
|
2021-03-14
| ||
| 20:17 | An additional test case (Closed-Leaf check-in: 7e2d7ca1 user: drh tags: tkt-1c24a659-b) | |
| 19:55 | An alternative approach for fixing ticket [1c24a659e6d7f3a1]. (check-in: a2adae90 user: drh tags: tkt-1c24a659-b) | |
| 01:40 | Never allow a double-quoted identifier that appears by itself in the argument list of an index to be interpreted as a string literal. Proposed fix for ticket [1c24a659e6d7f3a1]. (Closed-Leaf check-in: 7c8aa381 user: drh tags: tkt-1c24a659) | |
|
2021-03-13
| ||
| 18:23 | Fix a memory leak in the new code on this branch. (Closed-Leaf check-in: 0817cf2e user: dan tags: distinct-agg-opt) | |
| 17:21 | Fix typos in comments and add test cases. (check-in: 01312a3d user: dan tags: distinct-agg-opt) | |
|
2021-03-12
| ||
| 23:15 | Update generated autoconf/Makefile.msc to reflect its source. (check-in: d9f8f488 user: larrybr tags: trunk) | |
| 21:59 | Add test for autoconf/Makefile.msc current with respect to its generator input. (Leaf check-in: 4dfd8716 user: larrybr tags: derived_tests) | |
| 21:09 | Fix a crash in new code on this branch. (check-in: c05ed2a8 user: dan tags: distinct-agg-opt) | |
| 20:29 | Merge v3.35.0 release to this branch. (check-in: 6733ed76 user: larrybr tags: derived_tests) | |
| 20:24 | Create new branch named "derived_tests" (check-in: 8dc765d3 user: larrybr tags: derived_tests) | |
| 18:33 | Merge latest trunk changes into this branch. (check-in: 198bc510 user: dan tags: distinct-agg-opt) | |
| 18:24 | Attempt to use an index for DISTINCT aggregate queries that have GROUP BY clauses. (check-in: 3bca003c user: dan tags: distinct-agg-opt) | |
| 17:26 | Merge the 3.35.0 release into the reuse-schema branch. (check-in: c8237a02 user: drh tags: reuse-schema) | |
| 17:18 | Merge the 3.35.0 release into the begin-concurrent-pnu-wal2 branch. (check-in: 939b9e75 user: drh tags: begin-concurrent-pnu-wal2) | |
| 17:08 | Merge the 3.35.0 release into the wal2 branch. (check-in: 03142e5f user: drh tags: wal2) | |
| 16:50 | Merge the 3.35.0 release into the begin-concurrent-report branch. (check-in: 27f8f56b user: drh tags: begin-concurrent-report) | |
| 16:24 | Merge the 3.35.0 release into the begin-concurrent-pnu branch. (check-in: a0a9dd52 user: drh tags: begin-concurrent-pnu) | |
| 16:18 | Merge version 3.35.0 changes into the begin-concurrent branch. (check-in: 7e38c889 user: drh tags: begin-concurrent) | |
| 15:10 | Version 3.35.0 (check-in: acd63062 user: drh tags: trunk, release, major-release, version-3.35.0) | |
| 13:49 | Fix broken requirement marks. (check-in: 98d67152 user: drh tags: trunk) | |
| 01:49 | Fix the ".read" command in the CLI so that SQLITE_OMIT_POPEN disables reading from a pipeline. (check-in: cea34f3c user: drh tags: trunk) | |
| 00:44 | Conform description of sqlite3changeset_op() arguments to implemented behavior, some reformatting. This is a comment-only change; no code is affected. (check-in: 9d6e544c user: larrybr tags: trunk) | |
|
2021-03-11
| ||
| 21:00 | Update this branch with latest fixes from trunk. (check-in: 12363f8e user: dan tags: reuse-schema) | |
| 20:07 | Merge latest wal2 changes into this branch. (check-in: 88c3c173 user: dan tags: begin-concurrent-pnu-wal2) | |
| 19:42 | Merge latest trunk changes into this branch. (check-in: 30f912d0 user: dan tags: wal2) | |
| 19:26 | Merge latest changes from begin-concurrent-pnu into this branch. (check-in: 6994a2d8 user: dan tags: begin-concurrent-report) | |
| 19:08 | Merge latest trunk changes with this branch. (check-in: eb310136 user: dan tags: begin-concurrent-pnu) | |
| 18:52 | Update this branch with latest changes from trunk. (check-in: 79d44ebd user: dan tags: begin-concurrent) | |
| 15:57 | Fix a Tcl object leak in test_session.c. (check-in: 07150cf1 user: dan tags: trunk) | |
| 13:43 | Bug fix in appendvfs.c: Adjust the size parameter for SQLITE_FCNTL_SIZE_HINT to account for the prefix. (check-in: 41df3bbe user: drh tags: trunk) | |
| 10:55 | Merge latest trunk changes into this branch. (check-in: ef8c6e06 user: dan tags: reuse-schema) | |
| 08:49 | Have the Tcl tests support environment variable SQLITE_TEST_PATTERN_LIST, so that if it is set it is interpreted as a list of patterns that are matched against tests file names. Only test files that match at least one pattern are run. (check-in: b7c92e1d user: dan tags: trunk) | |
|
2021-03-10
| ||
| 20:04 | Fix sanitizer complaint in fts3 code. (check-in: 424b39ea user: dan tags: trunk) | |
| 19:32 | Fix further sanitizer complaints in the fts5 code. (check-in: 4cb00b9d user: dan tags: trunk) | |
| 18:21 | Improved testcase() related the SQLITE_MAX_ATTACHED vs. SQLITE_MAX_DB problem. (check-in: 27d3c00e user: drh tags: trunk) | |
| 17:52 | Improvement to the ATTACH-abuse authorizer logic in fuzzcheck. (check-in: 88132f69 user: drh tags: trunk) | |
| 17:43 | Do not run avfs.test when testing SQLITE_OMIT_VIRTUALTABLE builds. (check-in: 2ab6957a user: dan tags: trunk) | |
| 16:35 | Do not confuse the constant SQLITE_MAX_ATTACHED with the maximum number of schemas. Add the new SQLITE_MAX_DB constant for the maximum number of schemas. Forum post a006d86f72. (check-in: 7b65fb9f user: drh tags: trunk) | |
| 15:10 | Fix test file avfs.test so that it works with SQLITE_DEFAULT_AUTOVACUUM builds. Do not run avfs.test under test permutation "journaltest". (check-in: 2c6078eb user: dan tags: trunk) | |
| 14:57 | Fix a few sanitizer complaints in fts5. (check-in: 4fe4fee0 user: dan tags: trunk) | |
| 10:43 | Fix a problem preventing wapptest from setting SQLITE_ENABLE_LOCKING_STYLE for OSX tests. Also modify the "Sanitize" configuration in releasetest_data.tcl to subsume test item 6g. (check-in: f762d7df user: dan tags: trunk) | |
| 06:06 | When shell has no .ar, fake its effect w.r.t. page_size and table creation/filling. (check-in: 959f5c65 user: larrybr tags: trunk) | |
|
2021-03-09
| ||
| 23:38 | Add appendvfs.c to the MSVC makefile. (check-in: a6681fbb user: drh tags: trunk) | |
| 21:20 | Update a comment in btree.h. (check-in: 9645fe1a user: dan tags: trunk) | |
| 20:58 | Fix a bad comment (copy-paste error) in the byte code engine. No code changes. (check-in: 1c017457 user: drh tags: trunk) | |
| 19:52 | Improved comments on the NOT NULL strength reduction optimization. (check-in: a85d7229 user: drh tags: trunk) | |
| 19:32 | Extra comments and testcase() macros associated with the new sqlite3ParserAddCleanup() mechanism. No changes to release builds. (check-in: c3c86911 user: drh tags: trunk) | |
| 17:09 | Add --enable-math to the amalgamation autoconf. On be default. Improved logging of the amalgamation autoconf. (check-in: 85d28b52 user: drh tags: trunk) | |
| 16:47 | Add missing comment to new routine in select.c. (check-in: ef2f0cf2 user: dan tags: distinct-agg-opt) | |
| 16:35 | Math functions are enabled by default in the main configure script. (check-in: b7456e07 user: drh tags: trunk) | |
| 16:06 | Experimental optimization for distinct aggregates (e.g. "SELECT count(DISTINCT <expr) FROM ..."). (check-in: eb919611 user: dan tags: distinct-agg-opt) | |
| 13:53 | Improvements to the configure script. Math functions are enabled by --enable-all. (check-in: c79c6d18 user: drh tags: trunk) | |
| 13:12 | Update the authorizer in fuzzcheck to align with dbsqlfuzz. (check-in: f86d8fae user: drh tags: trunk) | |
|
2021-03-08
| ||
| 20:13 | Add tests for too-tiny appended DBs, clarify align macro. (check-in: eb40a8de user: larrybr tags: trunk) | |
| 17:22 | Add test cases for ALTER TABLE. (check-in: 9c9ba36e user: dan tags: trunk) | |
| 17:17 | Fix a bad assert in RENAME COLUMN. dbsqlfuzz 3f0a7245b69cd08617d7d7781ebaedb0fe765a93. (check-in: f13e0d12 user: drh tags: trunk) | |
| 16:29 | Fix a harmless compiler warning in appendvfs.c (check-in: f538961a user: drh tags: trunk) | |
| 16:13 | Enable internal functions for fuzzcheck. (check-in: 79281603 user: drh tags: trunk) | |
| 14:32 | Added test/avfs.test (missing from branch merge for some reason.) (check-in: 08fa6705 user: larrybr tags: trunk) | |
| 14:26 | Merge appendvfs updates and testing. (check-in: 63fcf301 user: larrybr tags: trunk) | |
| 13:45 | Require that the appendvfs suffix mark indicate that the appended database begins at an offset that is a muliple of 512 and that the appended database contains at least 512 bytes. (Leaf check-in: aeb87cc7 user: drh tags: appendvfs_tighten) | |
| 13:30 | Correct the precendence order for rules that determine how a database is opened by appendvfs when a database is appended to another database. (check-in: 92989fc5 user: drh tags: appendvfs_tighten) | |
| 12:59 | Minor comment and formatting changes. (check-in: cf2add06 user: drh tags: appendvfs_tighten) | |
| 01:31 | Add tests for sqlite3 shell with -append flag. (check-in: d1790288 user: larrybr tags: appendvfs_tighten) | |
|
2021-03-07
| ||
| 18:55 | Add grow/shrink tests. Fix truncate bug. Make appendvfs.c easier to inspect. (check-in: c9521fa5 user: larrybr tags: appendvfs_tighten) | |
|
2021-03-06
| ||
| 23:49 | Merge from trunk. (check-in: 729117cd user: larrybr tags: appendvfs_tighten) | |
| 23:36 | Create initial tests for appendvfs, and make it available as a statically loaded extension. (check-in: 9f33d451 user: larrybr tags: appendvfs_tighten) | |
| 15:13 | Limit parenthesis nesting depth in FTS3 expressions to SQLITE_MAX_EXPR_DEPTH. (check-in: 5ddd8032 user: drh tags: trunk) | |
| 14:46 | Ensure the correct collation sequence is used for comparisons when delimiting a RANGE window. (check-in: 01eae68e user: dan tags: trunk) | |
| 13:28 | Fix a crash in fts3 that could occur when running a NEAR query on a corrupt database. (check-in: 609d9499 user: dan tags: trunk) | |
| 13:02 | Fix a possible NULL pointer dereference when applying a DROP COLUMN to a corrupt database schema. dbsqlfuzz 419aa525df93db6e463772c686ac6da27b46da9e (check-in: 349ccf58 user: drh tags: trunk) | |
|
2021-03-05
| ||
| 20:52 | Merge last day of trunk changes, reverify build. (check-in: 1d67ed1c user: larrybr tags: appendvfs_tighten) | |
| 20:46 | Fix appendvfs bug exposed by docsapp build (in docsrc), and tighten/revise published behavior. (check-in: 7f0f2eac user: larrybr tags: appendvfs_tighten) | |
| 18:33 | Modify the SQLITE_DBCONFIG_ENABLE_VIEW option so that it always permits TEMP views, just as SQLITE_DBCONFIG_ENABLE_TRIGGER always permits TEMP triggers. (check-in: 83dab8b3 user: drh tags: trunk) | |
| 15:42 | Fix problems with RETURNING clauses attached to UPDATEs on tables with virtual columns. (check-in: 6b41b136 user: dan tags: trunk) | |
| 15:29 | Fix another problem with RETURNING clauses in UPDATEs against tables with virtual columns. (Closed-Leaf check-in: f0ef5c76 user: dan tags: returning-fix) | |
| 15:10 | Fix an assert() failure that could be triggered by a correlated sub-query in a RETURNING clause. (check-in: 551260c8 user: dan tags: returning-fix) | |
| 14:08 | Fix the processing of implied LIMIT clauses when flattening a compound query. (check-in: 90c6b9fc user: drh tags: trunk) | |
| 09:42 | Create new branch named "appendvfs_tighten" (check-in: 48c968bf user: larrybr tags: appendvfs_tighten) | |
|
2021-03-04
| ||
| 19:44 | Mark the NotUsed parameter to the dropColumnFunc() function as unused, to avoid a harmless compiler warning. (check-in: 23459071 user: drh tags: trunk) | |
| 18:34 | Put ALWAYS() on a branch that is now always true because of changes in OOM behavior due to check-in [9adf6e2469d18bc3]. (check-in: 8a1bb9c3 user: drh tags: trunk) | |
| 18:31 | Update shell.c.in so that SQLITE_SHELL_IS_UTF8 is set to 0 if the -municode option is passed to gcc on windows. (check-in: 99e6a0f0 user: dan tags: trunk) | |
| 16:32 | Remove a branch made unreachable by check-in [e893f88750ea64d4]. (check-in: 20d7dc12 user: drh tags: trunk) | |
| 16:10 | Fix a segfault that could occur following an OOM condition. (check-in: 9adf6e24 user: dan tags: trunk) | |
| 16:03 | Earlier detection of a misplaced ORDER BY or LIMIT clause in a compound SELECT. This prevents problems in recursive CTEs with multiple recursive terms in which there is an ORDER BY or LIMIT clause on the last non-recursive term. (check-in: e893f887 user: drh tags: trunk) | |
| 14:18 | Fix a crash that could occur if a sub-select inside an EXISTS expression features an ORDER BY clause containing one or more window functions. (check-in: 9768e7db user: dan tags: trunk) | |
|
2021-03-03
| ||
| 19:54 | Merge recent trunk enhancements into the reuse-schema branch. (check-in: 73bf458e user: drh tags: reuse-schema) | |
| 19:41 | Merge in recent enhancements. (check-in: b0fc8ca1 user: drh tags: begin-concurrent-pnu-wal2) | |
| 19:36 | Fix a buffer overrun that could occur in fts5 when running a prefix query against a corrupt db. (check-in: 4da40620 user: dan tags: trunk) | |
| 19:32 | Merge recent trunk enhancements into the wal2 branch. (check-in: 0ae81039 user: drh tags: wal2) | |
| 19:25 | Merge recent trunk enhancemenets into the begin-concurrent-pnu branch. (check-in: 59d3ec29 user: drh tags: begin-concurrent-pnu) | |
| 19:17 | Merge recent trunk changes into the begin-concurrent branch. (check-in: acdafef8 user: drh tags: begin-concurrent) | |
| 16:46 | Remove the --timeout option from the valgrindfuzz Makefile target. (check-in: 3f520b8b user: dan tags: trunk) | |
| 16:00 | Fix a case where fts3 was erroneously reporting corruption. (check-in: e6c7683c user: dan tags: trunk) | |
| 14:07 | Fix a harmless assertion fault resulting from [6e6b3729e0549de0] that was discovered by dbsqlfuzz. Enhance .selecttrace output to show omitted ORDER BY clauses. New dbsqlfuzz test cases added. (check-in: 27a0388a user: drh tags: trunk) | |
| 11:00 | Fix a problem with using ALTER TABLE commands on database schemas that contain expressions of the form "<expr> NOT NULL" or "<expr> IS NULL" that can be evaluated at prepare time. (check-in: d2630ffa user: dan tags: trunk) | |
|
2021-03-02
| ||
| 21:07 | Cast a string size variable to 64-bit to avoid any possibility of integer overflow. (check-in: a5940294 user: drh tags: trunk) | |
| 16:27 | Limit the size of the exponent input in the second argument to the ieee754() SQL function, to avoid integer overflow. Ticket [22dea1cfdb9151e4]. (check-in: 99aab32d user: drh tags: trunk) | |
| 13:50 | Change the timeout for test case "valgrindfuzz" from 600 seconds to 1200. (check-in: 7c6aa6f3 user: dan tags: trunk) | |
| 13:36 | Do not run test file windowpushd.test as part of the "no_optimization" permutation. (check-in: 275a75aa user: dan tags: trunk) | |
| 00:42 | Add ALWAYS() to an always-true conditional. (check-in: fa3506db user: drh tags: trunk) | |
|
2021-03-01
| ||
| 21:43 | Add #ifndef macros so that the build works again with -DSQLITE_OMIT_AUTHORIZATION and -DSQLITE_OMIT_WINDOWFUNC. (check-in: 9400bdc6 user: drh tags: trunk) | |
| 16:16 | Fix a couple of memory-sanitizer complaints that could be triggered by a corrupt database. (check-in: 39c8686c user: dan tags: trunk) | |
| 16:15 | Fix another msan complain triggered by a corrupt database. (Closed-Leaf check-in: d235d406 user: dan tags: msan-fix) | |
|
2021-02-28
| ||
| 08:24 | Initialize extra field in PgHdr1 to fix an msan complaint. (check-in: 4cb2ea57 user: dan tags: msan-fix) | |
|
2021-02-27
| ||
| 15:32 | Add OOM test case associated with the fix in the previous commit. (check-in: a631c38d user: dan tags: trunk) | |
| 15:12 | Remove a NEVER() that might sometimes be tree following an OOM. (check-in: ccb8cf52 user: drh tags: trunk) | |
|
2021-02-26
| ||
| 21:39 | Fix a segfault that could occur when optimizing a NOT NULL constraint against an IPK column of a sub-query. (check-in: e4d1970e user: dan tags: trunk) | |
| 20:39 | Attempt to optimize "x IS NULL" and "x IS NOT NULL" expressions when x is a column with a NOT NULL constraint. This addresses the performance issue described by forum post a5fc33cf9d8f4ff5. (check-in: de9c86c9 user: dan tags: trunk) | |
| 20:14 | Attempt to optimize "x IS NULL" and "x IS NOT NULL" expressions when x is a column with a NOT NULL constraint. (Closed-Leaf check-in: 5ecd8425 user: dan tags: ifnull-opt) | |
| 15:20 | Minor simplification in resolve.c. (check-in: 310dac34 user: dan tags: trunk) | |
|
2021-02-25
| ||
| 18:28 | Fix test case in altercorrupt.test so that it works with SQLITE_ENABLE_OVERSIZE_CELL_CHECK builds. (check-in: 062b338f user: dan tags: trunk) | |
| 18:23 | Fix a problem with UPDATE and DELETE statements that use both INDEXED BY and LIMIT clauses in SQLITE_ENABLE_UPDATE_DELETE_LIMIT builds. (check-in: cc2b4b38 user: dan tags: trunk) | |
| 16:55 | Fix handling of INSERT on views with implicitly named hidden columns in SQLITE_ENABLE_HIDDEN_COLUMNS builds. (check-in: 15795a96 user: dan tags: trunk) | |
| 15:50 | Ensure that tests like "rbu.test" and "notify2.test" that are only run by specific configurations during release testing are run for both release and debug versions of the tests. (check-in: 911df43f user: dan tags: trunk) | |
|
2021-02-23
| ||
| 16:40 | When a sub-transaction is released, if no pages required by containing sub-transactions were journaled, truncate the statement journal. This prevents out of control statement journal growth in some cases. See forum thread e78ffd751185a67e for context. (check-in: 23ca2389 user: dan tags: trunk) | |
| 15:53 | Allow WHERE terms to be pushed down into sub-queries that contain window functions, provided that the WHERE term is made up of entirely of constants and copies of expressions found in the PARTITION BY clauses of all window functions in the sub-query. (check-in: 20689468 user: dan tags: trunk) | |
| 15:36 | Further tests for the push-down optimization with window functions. (Closed-Leaf check-in: 4b089f70 user: dan tags: window-functions-pushdown) | |
|
2021-02-22
| ||
| 20:56 | Allow WHERE terms to be pushed down into sub-queries that contain window functions, provided that the WHERE term is made up of entirely of constants and copies of expressions found in the PARTITION BY clauses of all window functions in the sub-query. (check-in: dac51f30 user: dan tags: window-functions-pushdown) | |
| 19:57 | Add a few simple test cases for MATERIALIZED and NOT MATERIALIZED. (check-in: 64878124 user: drh tags: trunk) | |
| 16:42 | Implement the MATERIALIZED and NOT MATERIALIZED hints on common table expressions. (check-in: b5a0778c user: drh tags: trunk) | |
| 15:44 | When a sub-transaction is released, if no pages required by containing sub-transactions were journaled, truncate the statement journal. This might prevent out-of-control statement journal growth in some cases. (Closed-Leaf check-in: e36327fb user: dan tags: stmt-jrnl-truncate) | |
| 14:25 | Add an ALWAYS() on a branch that is now unreachable. (Closed-Leaf check-in: ace54c5b user: drh tags: as-materialize-redux) | |
| 11:07 | Fix inverted logic regarding the materialization hint on the push-down optimization. (check-in: b66a4957 user: drh tags: as-materialize-redux) | |
| 03:04 | Add the AS MATERIALIZED and AS NOT MATERIALIZED syntax that works like it does in PostgreSQL. (check-in: a6bb272e user: drh tags: as-materialize-redux) | |
|
2021-02-21
| ||
| 23:44 | Materialize any CTE that is used more than once. (check-in: ba59159f user: drh tags: as-materialize-redux) | |
| 21:04 | Rename the "struct SrcList_item" object to the more succinct "SrcItem". This is a symbolic change only. The logic is unmodified. (check-in: bfd5bf2c user: drh tags: trunk) | |
| 01:19 | Simplified resolution of CTE names. Slightly faster and about 100 bytes of code smaller. (check-in: 0d2c992f user: drh tags: trunk) | |
|
2021-02-20
| ||
| 21:20 | Performance improvement in resolving the INDEXED BY index name for the common case where there is no INDEXED BY clause. (check-in: 554b286a user: drh tags: trunk) | |
| 19:22 | Fix a case where FTS3/4 could pass a NULL pointer to memcpy() when handling a corrupt db. (check-in: 68bb541a user: dan tags: trunk) | |
| 18:02 | Update sqlite3changeset_apply_v2() so that it handles no-op UPDATE changes (UPDATE changes that modify no columns). This fixes a regression introduced by [e4ccfac09b]. Also modify sqlite3rebaser_rebase() so that it does not output changesets containing such UPDATEs. (check-in: 0288a801 user: dan tags: trunk) | |
| 14:57 | Break out the Cte object from the With object. This will make it simpler to add new kinds of Cte objects (ex: DML statements) and/or MATERIALIZED keywords in the future. It brings trunk into closer alignment with the experimental as-materialize branch. (check-in: f03efe90 user: drh tags: trunk) | |
| 13:36 | Simplification to where.c manually cherrypicked from the as-materialize branch. (check-in: 03805a61 user: drh tags: trunk) | |
| 12:47 | Merge changes from trunk. (Later:) Abandon this line of development. See the as-materialize-redux branch. (Closed-Leaf check-in: 7a90571e user: drh tags: as-materialize) | |
|
2021-02-19
| ||
| 18:39 | Fix another problem handling corrupt database files in the ALTER TABLE DROP COLUMN code. (check-in: 9edf2ddc user: dan tags: trunk) | |
| 15:34 | Add tests for ALTER TABLE DROP COLUMN commands. (check-in: 05dbea9b user: dan tags: trunk) | |
| 14:32 | Add support for "ALTER TABLE ... DROP COLUMN ..." commands. (check-in: c844a331 user: dan tags: trunk) | |
| 14:13 | Fix a crash that could occur in ALTER TABLE DROP COLUMN if the sqlite_schema table was corrupt. (Closed-Leaf check-in: 126ee1ec user: dan tags: alter-table-drop-column) | |
| 09:46 | Omit an branch made unreachable by the improved error message from dropping the last column of a table. (check-in: c5719fc5 user: drh tags: alter-table-drop-column) | |
| 09:36 | The COLUMN keyword in ALTER TABLE DROP COLUMN is optional. (check-in: a22f87fb user: drh tags: alter-table-drop-column) | |
| 09:09 | Give a better error message on DROP COLUMN when attempting to drop the last column of a table. (check-in: 5e1f362b user: drh tags: alter-table-drop-column) | |
| 02:30 | Add a NEVER() to an unreachable branch in the DROP COLUMN logic. (check-in: 963f498a user: drh tags: alter-table-drop-column) | |
|
2021-02-18
| ||
| 23:53 | Add missing VdbeCoverage() macros. (check-in: 9bb720e6 user: drh tags: alter-table-drop-column) | |
| 23:03 | Enhance renameParseSql() to better handle OOMs. (check-in: 68bcde7a user: drh tags: alter-table-drop-column) | |
| 22:47 | Merge changes from trunk into the alter-table-drop-column branch. (check-in: 9ea64007 user: drh tags: alter-table-drop-column) | |
| 20:27 | Fix DROP COLUMN so that it works even if the user has registered an authorizer callback. (check-in: e5f14418 user: dan tags: alter-table-drop-column) | |
| 19:25 | Fix a problem with schema error detection when processing ALTER TABLE DROP COLUMN commands. (check-in: 565a6fd0 user: dan tags: alter-table-drop-column) | |
| 17:48 | Add test cases for ALTER TABLE DROP COLUMN. (check-in: 204ee5e2 user: dan tags: alter-table-drop-column) | |
| 15:59 | Avoid invoking the update or pre-update hooks during VACUUM operations. (check-in: 3c25cb4a user: dan tags: trunk) | |
| 15:45 | Improvement to the INSERT optimization of check-in [16ac213c57196361] so that it works with SQLITE_ENABLE_HIDDEN_COLUMN but is also easier to maintain and a little faster as well. (check-in: f985a78e user: drh tags: trunk) | |
| 14:27 | Disable the optimization of [16ac213c57196361] when the SQLITE_ENABLE_HIDDEN_COLUMN compile-time option is used, as the optimization does not work in that case. (check-in: 5168b06b user: drh tags: trunk) | |
| 12:18 | Ensure that the pre-update hook is invoked for INSERT operations on WITHOUT ROWID tables that use the xfer optimization. (check-in: 66bbad23 user: dan tags: trunk) | |
| 01:02 | Add missing VdbeCoverage() macros to some of the new RETURNING code. (check-in: 53a53909 user: drh tags: trunk) | |
| 00:59 | Performance optimization in the resolver. (check-in: 1aafb94d user: drh tags: trunk) | |
| 00:26 | Performance optimization in the code generator for INSERT for the common case where the target table has neither generated nor hidden columns. Also fix a redundant (and thus unreachable) branch in the resolver. (check-in: 16ac213c user: drh tags: trunk) | |
|
2021-02-17
| ||
| 21:13 | Use the sqlite3ParserAddCleanup() mechanism to ensure that the AggInfo structure associated with an aggregate query is deallocated, for a performance increase and size reduction. (check-in: 7a139967 user: drh tags: trunk) | |
| 20:46 | Fix a problem with OOM error handling in the new code on this branch. (check-in: ea999c9d user: dan tags: alter-table-drop-column) | |
| 20:19 | Merge trunk changes into this branch. (check-in: 0cd5e2f9 user: dan tags: alter-table-drop-column) | |
| 20:08 | Fix various issues with the changes on this branch. Add test cases for the same. (check-in: 10538ec6 user: dan tags: alter-table-drop-column) | |
| 13:19 | Enhance the ".once" and ".output" commands in the CLI so that if the filename argument begins with "|" the name becomes the concatenation of all subsequent arguments. Hence, commands like ".once | open -f" become possible without the need for quotes. (check-in: c46a94a6 user: drh tags: trunk) | |
|
2021-02-16
| ||
| 20:43 | Add experimental implementation of ALTER TABLE DROP COLUMN. Only some cases work so far. (check-in: f0217937 user: dan tags: alter-table-drop-column) | |
| 20:32 | Simplification to the resolveAlias() routine. (check-in: 00bead39 user: drh tags: trunk) | |
| 20:01 | New SELECTTRACE macros more clearly deliniate when the query planner is invoked in the middle of PRAGMA vdbe_addoptrace output. (check-in: 7c03ce49 user: drh tags: trunk) | |
| 19:29 | Remove unnecessarily complexity from sqlite3WithReleaseByParse(). Improved TreeView output for the enhanced CTE structures. This code still does not work 100%. I'm saving my place in order to (maybe) come back to it later. (check-in: 30bb18b4 user: drh tags: as-materialize) | |
| 16:32 | Trying to get the new AS MATERIALIZE syntax of CTEs to work. There are still performance and memory management issues. This is a WIP check-in. (check-in: bf0fd9b2 user: drh tags: as-materialize) | |
| 00:48 | Change the syntax from "GENERATED AS" to "AS MATERIALIZED" so as to match the syntax of PostgreSQL 12+. (Closed-Leaf check-in: 78dcddd9 user: drh tags: with-generated-as) | |
|
2021-02-15
| ||
| 17:51 | Merge the LIKE operator fix from trunk. (check-in: 8c861878 user: drh tags: with-generated-as) | |
| 17:02 | Fix an issue with the LIKE operator when it includes the "ESCAPE '_'" clause. Ticket [c0aeea67d58ae0fd]. (check-in: 27d41179 user: drh tags: trunk) | |
| 14:55 | Merge minor fixes from trunk. (check-in: d876b287 user: drh tags: with-generated-as) | |
| 14:32 | Add tests for sqlite3_column_count(). (check-in: 7cc65ae5 user: dan tags: trunk) | |
| 13:17 | Ensure that the ALTER TABLE statements return 0 for sqlite3_column_count(). (check-in: 29c1932a user: drh tags: trunk) | |
| 11:14 | Fix an error in the test case fix in [ecd71203]. (check-in: 5411bfa4 user: dan tags: trunk) | |
|
2021-02-13
| ||
| 23:46 | If the GENERATED keyword occurs before the AS keyword in a common table expression (CTE) definition, then that CTE becomes an "optimization barrier". For now, that means the CTE is always materialized. It also means that query flattener or pushdown optimizations that cross the CTE boundary are omitted. (check-in: 186ec18b user: drh tags: with-generated-as) | |
| 21:01 | Add a test-control that allows setting a LIKE pattern for common table expression names such that CTEs with matching names become an optimization barrier - They are not flattened and are implemented by materialization. (Closed-Leaf check-in: 15692ec0 user: drh tags: optbarrier-test-ctrl) | |
| 18:14 | Fix incorrect test name labels in the select1.test script. (check-in: 179c79ea user: drh tags: trunk) | |
| 16:39 | Avoid manifesting a CTE (or other view) multiple times when it is possible to reuse the first manifestation. (check-in: 9692f510 user: drh tags: trunk) | |
| 14:26 | Fix a problem in the unreleased union-all flattening enhancement (check-in: e4f8a79f user: dan tags: trunk) | |
|
2021-02-12
| ||
| 21:22 | Fix a test case to account for the fact that different versions of OpenBSD behave differently when a program tries to read() from a file-descriptor open on a directory. (check-in: ecd71203 user: dan tags: trunk) | |
| 21:07 | Parsing of DML statements in a WITH clause. But at this point, it just generates an error about "not yet supported". (Leaf check-in: 964ff68d user: drh tags: dml-in-cte) | |
| 11:37 | Ensure all RBU tests are run as part of release testing. (check-in: a18dc08b user: dan tags: trunk) | |
|
2021-02-10
| ||
| 20:20 | Merge latest trunk changes into this branch. (check-in: d29c41bd user: dan tags: reuse-schema) | |
| 20:00 | Fix a longstanding problem causing an RBU vacuum to omit releasing some locks before finishing. (check-in: 66c07a07 user: dan tags: trunk) | |
| 19:49 | Remove an assert() added by the previous commit that is sometimes false. (Closed-Leaf check-in: fb36ac4d user: dan tags: shm-lock-fix) | |
| 19:40 | Fix a longstanding problem causing an RBU vacuum to omit releasing some locks before finishing. (check-in: cb5bdf82 user: dan tags: shm-lock-fix) | |
| 17:31 | In RBU, avoid passing VFS xShmLock calls through to the underlying VFS in cases where xShmMap calls may not be. This fixes a bad interaction with ZipVFS. (check-in: bd1e9e0a user: dan tags: trunk) | |
|
2021-02-08
| ||
| 15:56 | Correctly detect correlated subqueries when resolving names in RETURNING clauses. (check-in: b43cfa04 user: drh tags: trunk) | |
| 13:41 | Improved name resolution for references to a table begin modified from within a subquery in the RETURNING clause. (check-in: 799d205b user: drh tags: trunk) | |
|
2021-02-07
| ||
| 23:28 | Do not allow RETURNING in the DML statements of a trigger. (check-in: 7a8fe646 user: drh tags: trunk) | |
| 12:59 | Fix harmless compiler warnings. (check-in: 5f8bf995 user: drh tags: trunk) | |
|
2021-02-06
| ||
| 14:56 | Remove an ALWAYS() and NEVER() in the authorizer that become reachable as of [078dbff04a95a001]. Test case for coverage in TH3. (check-in: b469327e user: drh tags: trunk) | |
| 14:37 | Fix the OSSFuzz-discovered shift problem from two days ago. This patch was omitted from [078dbff04a95a001] apparently because I made the edit to "sqlite3.c" rather than "resolve.c" where it belongs. (check-in: 864772ff user: drh tags: trunk) | |
|
2021-02-05
| ||
| 17:34 | Remove unreachable code. Fix a shift UB problem introduced yesterday and discovered by OSSFuzz. (check-in: 078dbff0 user: drh tags: trunk) | |
|
2021-02-04
| ||
| 23:20 | Change the RETURNING algorithm so that outputs accumulate in an ephemeral table until all modifications have been completed, and only then do results start being returned. This should help prevent problems with interleaved sqlite3_step() calls on two separate DML statements. It also seems to be closer to how PostgreSQL works, which might prevent compatibility problems. (check-in: c4615eb2 user: drh tags: trunk) | |
| 22:59 | Remove dead code. Fix RETURNING for INSERT into a virtual table. (Closed-Leaf check-in: dbfa3869 user: drh tags: returning-manifested) | |
| 21:19 | Initial commit (Leaf check-in: e73dbce8 user: shearer tags: selective-debug) | |
| 21:17 | Fix an issue with RETURNING from UPSERT. (check-in: 757b74ba user: drh tags: returning-manifested) | |
| 20:52 | Snapshot. New design appears to work on a simple test case. (check-in: 8a65fbee user: drh tags: returning-manifested) | |
| 17:29 | Preliminary changes for a new implementation of RETURNING that captures all results in a buffer and plays them all back after the DML statement completes. This avoids problems with interleaved DML statements. This particular check-in is a non-functional work in progress. (check-in: 04b77d63 user: drh tags: returning-manifested) | |
| 13:52 | Add NEVER() to a branch that check-in [5d54d9fd40638138] apparently made unreachable. (check-in: 5c8e6296 user: drh tags: trunk) | |
| 13:44 | Performance optimization in sqlite3FinishCoding(). (check-in: 0f34f241 user: drh tags: trunk) | |
| 11:14 | Work toward handling interleaved RETURNING statements. Trunk does not handle that case correctly. This branch is a partial implementation of ideas that might, however. (Closed-Leaf check-in: e1eb6213 user: drh tags: interleaved-returning) | |
|
2021-02-03
| ||
| 19:38 | Corrections to the 'filepath_normalize' test suite helper procedure. (check-in: 32f4d044 user: mistachkin tags: trunk) | |
| 18:32 | Change the name of Vdbe.magic to Vdbe.iVdbeMagic to disambiguate with sqlite3.magic. (check-in: 6b29e549 user: drh tags: trunk) | |
| 14:20 | Avoid doing any foreign-key constraint related processing for an UPDATE statement that does not modify any columns that are part of FK constraints, even if the table has a self-referencing FK. (check-in: 7f3b036e user: dan tags: trunk) | |
| 13:20 | Fix a harmless compiler warning. (check-in: 1eb69c64 user: drh tags: trunk) | |
| 13:08 | Add support for the RETURNING clause following PostgreSQL syntax. Also change the behavior of SQLITE_DBCONFIG_ENABLE_TRIGGER so that TEMP triggers are always allowed, regardless of the setting. (check-in: 416c898b user: drh tags: trunk) | |
| 12:35 | Fix an assert() that might be off-by-one in the case of a prior errors in the parse. (check-in: 06b15b17 user: drh tags: trunk) | |
| 00:55 | Modify the SQLITE_DBCONFIG_ENABLE_TRIGGER setting so that it only disables main-schema triggers and allows TEMP trigger to continue operating. This is safe, since only the application (not an attacker) can add TEMP triggers. It will also all us to disengage SQLITE_DBCONFIG_ENABLE_TRIGGER on Fossil databases since Fossil has no main-schema triggers but does use TEMP triggers. (Closed-Leaf check-in: a10c5a25 user: drh tags: returning) | |
| 00:05 | Load enhancements from trunk into the returning branch. (check-in: b84c7f60 user: drh tags: returning) | |
|
2021-02-02
| ||
| 20:46 | Do not allow aggregates in a RETURNING clause. Fix a memory leak that occurs when window functions are used in a RETURNING clause. (check-in: 2e9bd94b user: drh tags: returning) | |
| 20:41 | Modify the sessions extension to use more efficient SQL when applying a changeset or patchset. (check-in: e4ccfac0 user: dan tags: trunk) | |
| 12:01 | Report an error if RETURNING is used for DELETE or UPDATE of a virtual table. (check-in: bd5dee84 user: drh tags: returning) | |
| 00:16 | Allow the RETURNING trigger to exist for virtual tables. (check-in: 2f244ab4 user: drh tags: returning) | |
|
2021-02-01
| ||
| 21:26 | Add a few test cases for RETURNING together with UPDATE/DELETE LIMIT. (check-in: 7611c77d user: drh tags: returning) | |
| 12:39 | Improved corrupt database detection in balance_nonroot(). (check-in: 5d54d9fd user: drh tags: trunk) | |
| 01:57 | Modify RETURNING so that it does not return changes implemented by cascading foreign keys or by triggers. (check-in: 6e62470a user: drh tags: returning) | |
|
2021-01-31
| ||
| 16:45 | Mark an unreachable branch as ALWAYS(). (check-in: cb8b797a user: drh tags: returning) | |
| 15:50 | New opcode OP_ChngCntRow used to output the result of PRAGMA change_count. Only this new opcode, and not OP_ResultRow, checks for foreign key errors. Faster performance, and now also works with RETURNING. (check-in: 154fc2b1 user: drh tags: returning) | |
| 12:41 | When setting the number of result columns in a RETURNING trigger, be sure to set that value in the top-level bytecode program, not in the immediate caller of the trigger. (check-in: 1f1ce7ce user: drh tags: returning) | |
|
2021-01-30
| ||
| 21:55 | Improved comments on the new code. (check-in: a38f0c1d user: drh tags: returning) | |
| 16:16 | Add an ALWAYS() to an unreachable branch. (check-in: 6bb6de42 user: drh tags: returning) | |
| 14:17 | Change the OP_ResultRow opcode so that it does not cancel pending statement transactions. (check-in: fea91e3a user: drh tags: returning) | |
| 12:07 | Fix a obsolete assert() in the bytecode engine. Improved OOM detection in sqlite3AddReturning(). (check-in: 138b10d5 user: drh tags: returning) | |
| 03:06 | Fix handling of an OOM condition in sqlite3AddReturning(). (check-in: 52204cd7 user: drh tags: returning) | |
| 02:43 | Fix a memory deallocation problem that comes up when doing a RETURNING query on a corrupt database. I think I fixed this before, but it got unfixed with stale editor content. (check-in: 02b1415e user: drh tags: returning) | |
| 02:34 | Another attempt to get trigger selection correct for RETURNING triggers. (check-in: 1b8ed522 user: drh tags: returning) | |
| 02:22 | When running the RETURNING trigger, if it is tagged as a DELETE trigger, do not use it as INSERT or UPDATE. (check-in: 3c7a6e04 user: drh tags: returning) | |
| 01:30 | Test cases added. RETURNING works with UPSERT as does PG. (check-in: f5698f96 user: drh tags: returning) | |
|
2021-01-29
| ||
| 22:33 | Better handling of errors in RETURNING due to corrupt database files. (check-in: 6aa2a058 user: drh tags: returning) | |
| 21:31 | RETURNING works even if "PRAGMA count_changes=ON" is set. (check-in: a9122d97 user: drh tags: returning) | |
| 21:18 | Allow "*" wildcards in the RETURNING clause. (check-in: b0e3ae30 user: drh tags: returning) | |
| 19:32 | Working prototype. (check-in: b7ef4dc2 user: drh tags: returning) | |
| 16:20 | Fix possible division-by-zero in the new log() SQL functions. Problemm discovered by OSSFuzz. (check-in: 1ffd321a user: drh tags: trunk) | |
| 14:22 | Incorporate the sqlite3TriggerList() optimization from trunk. And move the pReturning field to the uninitialized area in the Parse object, to save memset() time. (check-in: 29fbaf0e user: drh tags: returning) | |
| 13:47 | Performance optimization (and size reduction) in sqlite3TriggerList() for the common case where there are no TEMP triggers. (check-in: 0defaf73 user: drh tags: trunk) | |
|
2021-01-27
| ||
| 20:35 | Merge recent enhancements from trunk. (check-in: 5fbcb208 user: drh tags: returning) | |
| 19:15 | Fix an issue with IN operator optimization introduced by check-in [4a43430fd23f8835] and described by ticket [ee51301f316c09e9]. (check-in: 9dc7fc9f user: drh tags: trunk) | |
| 17:15 | Ensure a cursor used by the SeekScan operator does not point to a valid row on the first iteration of the loop. Possible fix for [ee51301f316c09e]. (Closed-Leaf check-in: 390cf60a user: dan tags: fix-2d6e8400) | |
|
2021-01-25
| ||
| 21:24 | Add an extra log message in the case of an SQLITE_CORRUPT_INDEX error. (check-in: 0571c241 user: drh tags: trunk) | |
|
2021-01-22
| ||
| 21:23 | Enhance the query planner to enable it to use an index for IS NOT NULL constraints, even if STAT4 is not enabled. (check-in: 7b2a7c73 user: drh tags: trunk) | |
| 20:28 | Merge fixes from trunk. Omit a conditional in sqlite3IsLikeFunction() that was made unreachable by this enhancement. (Closed-Leaf check-in: 0b42f9eb user: drh tags: isnotnull-opt) | |
|
2021-01-21
| ||
| 21:36 | Do not allow VACUUM to resize the page_size to 512 if the reserve_byte value is 31 or greater. forum post e807885dc5. (check-in: d5ea75a0 user: drh tags: trunk) | |
| 20:42 | Performance optimizations in exprAnalyze() (check-in: 6d60cf54 user: drh tags: isnotnull-opt) | |
| 17:54 | Always enable the IS NOT NULL optimization, even if STAT4 is not enabled. (check-in: fc98218c user: drh tags: isnotnull-opt) | |
| 16:02 | Fix a problem caused by using an SQL variable in an OVER clause within a trigger program. Edit: The problem appears to have existed ever since window functions landed on trunk (check-in [17198a1206e2fbc9]) on 2018-06-30, version 3.25.0. (check-in: 02264ab6 user: dan tags: trunk) | |
| 15:40 | Fix a problem caused by using an SQL variable in an OVER clause within a trigger program. (Closed-Leaf check-in: 4f676466 user: dan tags: fix-over-trigger) | |
|
2021-01-20
| ||
| 23:01 | Improvements to the auxiliary "main.mk" makefile so that it works better with multi-threaded builds. (check-in: d1873054 user: drh tags: trunk) | |
| 10:59 | Add tests for sqlite3session_memory_used() interface. (check-in: 5596611f user: dan tags: trunk) | |
|
2021-01-18
| ||
| 19:28 | Fix harmless compiler warnings seen with MSVC. (check-in: dc7938d2 user: mistachkin tags: trunk) | |
| 19:27 | Update test helper procedure 'get_pwd' to handle the ComSpec environment variable being absent. (check-in: fe197955 user: mistachkin tags: trunk) | |
| 12:35 | Enhance the query planner so that it is able to code EXISTS operators in the WHERE clause as if they were IN operators, when appropriate. (check-in: c1862abb user: drh tags: trunk) | |
| 00:11 | More comments on the EXISTS-to-IN optimization logic. (Closed-Leaf check-in: 92cc2909 user: drh tags: exists-to-in) | |
|
2021-01-17
| ||
| 00:13 | Minor simplification of the EXISTS-to-IN logic. (check-in: cac90a9f user: drh tags: exists-to-in) | |
|
2021-01-16
| ||
| 20:22 | Improved handling of vector equalities in the EXISTS-to-IN translator. (check-in: ef49ee4a user: drh tags: exists-to-in) | |
| 18:55 | Give the EXISTS-to-IN optimization the ability to handle some cases that involve vector comparisons, instead of throwing a mysterious error in those cases. (check-in: 87e78a19 user: drh tags: exists-to-in) | |
| 18:22 | Add debugging output about the EXISTS-to-IN optimization when the ".wheretrace" flag has the 0x20 bit set. (check-in: 0dad5ce3 user: drh tags: exists-to-in) | |
| 12:15 | Fix a hyperlink in the Lemon documentation. (check-in: 2ffb2ffa user: drh tags: trunk) | |
|
2021-01-15
| ||
| 17:51 | Add OOM injection tests for new code on this branch. (check-in: 9a181dba user: dan tags: exists-to-in) | |
| 16:37 | Update header comments for routines added by this branch. (check-in: 950030d6 user: dan tags: exists-to-in) | |
| 15:32 | Ensure the EXISTS->IN transformation preserves the collation sequence of the comparison operation. (check-in: a373baae user: dan tags: exists-to-in) | |
| 15:21 | Fix a potential NULL pointer dereference following OOM. (check-in: 8ce3cb90 user: drh tags: exists-to-in) | |
| 15:17 | Add a new optimizer disabling bit to close off the exists-to-in optimization, for testing purposes. (check-in: a80c9a07 user: drh tags: exists-to-in) | |
| 14:25 | Small performance improvement in the EXISTS-to-IN translator for the common case where the EXISTS operator is not found in the WHERE clause. (check-in: dcb7772d user: drh tags: exists-to-in) | |
| 14:15 | Merge the latest trunk enhancements into the exists-to-in branch. (check-in: 13c4c908 user: drh tags: exists-to-in) | |
| 11:39 | Add simple tests (and a fix) for the change on this branch. (check-in: 897f3f40 user: dan tags: exists-to-in) | |
|
2021-01-14
| ||
| 20:57 | Improvements to the min/max optimization. Fix for a performance regression introduced at [b8ba2f17f938c035] reported by forum post 4050026ab8 (check-in: 249a71cc user: drh tags: trunk) | |
| 20:50 | Allow the planner to convert an EXISTS(SELECT...) expression in a WHERE clause to the equivalent IN(...) expression in situations where this is possible and advantageous. (check-in: 9f90a882 user: dan tags: exists-to-in) | |
| 00:53 | The early-out of the inner loop on the min/max optimization was overly aggressive for the cases where there is a join and outer loops contain IN operators. Fix this. Test case in TH3. (Closed-Leaf check-in: ccd3bae1 user: drh tags: minmax-opt-exp) | |
|
2021-01-13
| ||
| 21:05 | Fix a harmless compiler warning. (check-in: 83ec01e3 user: drh tags: minmax-opt-exp) | |
| 19:28 | Expand the number of optimization-disable bits from 16 to 32. Use one of the new bits to disable the min/max optimization, so that we can more easily verify that we get the same answer both with and within that optimization. (check-in: fd0c9a12 user: drh tags: minmax-opt-exp) | |
| 15:23 | Further enhancements to the min/max optimization of check-in b8ba2f17f938c035 to fix the performance regression identified by forum post 4050026ab8. (check-in: 188772a1 user: drh tags: minmax-opt-exp) | |
| 12:59 | cli: Omit surplus whitespace at the end of lines in .explain output. (check-in: 11e4eb09 user: drh tags: trunk) | |
| 11:44 | In the .selecttrace output, show the ORDER BY clause added by the Min/Max optimization. (check-in: db0ecfe6 user: drh tags: trunk) | |
|
2021-01-12
| ||
| 20:16 | Lexer and grammar rules for a RETURNING clause on DELETE/INSERT/UPDATE. Actually making this work, though, will involve a lot more code which will likely slow down processing for the common case where there is no RETURNING clause. Furthermore, RETURNING seems to be of limited usefulness and it is not standard SQL. So we abandon it here. These experimental changes are parked in a branch as an historical reference. If circumstances changes, we might take up the cause again some day. (check-in: abf8da81 user: drh tags: returning) | |
| 16:26 | Merge the ParseCleanup enhancement to trunk. (check-in: 35824c1b user: drh tags: trunk) | |
| 15:30 | Fix a potential use-after-free following an OOM in sqlite3ParserAddCleanup() and add a mechanism to detect situations where this might occur in the future. (Closed-Leaf check-in: 38ef8ab9 user: drh tags: parse-cleanup) | |
| 14:23 | Rerun autoconf. (check-in: 8f3ab5da user: drh tags: trunk) | |
| 14:19 | Fix for the top-level configure script so that it works with tcl 8.7. (check-in: 4810f814 user: dan tags: trunk) | |
|
2021-01-11
| ||
| 20:37 | Add a linked list of ParseCleanup objects to the end of a Parse object and use that list as a place to put other sub-objects that need to be deallocated. Have a single such list for infrequently used sub-objects is more efficient than doing an a separate check for each kind of sub-object. Edit: Now possible to have use-after-free following an OOM. (check-in: affa2b7b user: drh tags: parse-cleanup) | |
|
2021-01-09
| ||
| 19:10 | New CLI command: ".stats vmstep" enables the display of the virtual-machine step count only, after each command. Useful for optimization problems. (check-in: 49dfce46 user: drh tags: trunk) | |
| 18:24 | More detailed compile-time testing before attempting to use atomic load intrinsics. See forum post fc0237a39b30ac0a. (check-in: 5204c2c4 user: drh tags: trunk) | |
|
2021-01-08
| ||
| 19:53 | Fix an issue with sha3_query() when the first argument contains blank SQL statements. (check-in: 24baab9a user: drh tags: trunk) | |
|
2021-01-07
| ||
| 16:59 | Update cksumvfs to check that the xCurrentTimeGetInt64 method of the underlying VFS is not NULL before invoking it. (check-in: c71f6cad user: dan tags: trunk) | |
| 16:29 | Fix problems with some "crashsql" tests. (check-in: 0c8e2ede user: dan tags: trunk) | |
| 16:10 | Fix harmless typos in comments per forum post 7849e58dd5 (check-in: d1e22e2f user: drh tags: trunk) | |