Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
595 ancestors of trunk:202201112328 back to version-3.36.0
|
2022-01-11
| ||
| 23:28 | Merge the JSON interface into the core. Add -> and ->> operators for JSON that are compatible with by MySQL and PG. (check-in: 4cbb3e3e user: drh tags: trunk) | |
| 22:06 | Remove vestigial traces of json_ntype(). (Closed-Leaf check-in: 8da07c8b user: drh tags: json-in-core) | |
| 18:01 | Fix the PG-compatible -> and ->> path parsing. (check-in: 22d51383 user: drh tags: json-in-core) | |
|
2022-01-10
| ||
| 17:43 | Fix typo in the json-enhancements.md document. (check-in: feba24ef user: drh tags: json-in-core) | |
| 15:43 | Implement the new PG-compliant versions of the -> and ->> operators. (check-in: 39eff3b9 user: drh tags: json-in-core) | |
| 13:55 | New proposal for -> and ->> operators. (check-in: 1108e12a user: drh tags: json-in-core) | |
|
2022-01-09
| ||
| 20:51 | Typo fix in doc/json-enhancements.md. (check-in: c3b01d49 user: drh tags: json-in-core) | |
| 20:42 | Update the doc/json-enhancements.md document to better explain the features of this branch. (check-in: b8ac938f user: drh tags: json-in-core) | |
| 19:44 | Do not enclude ENABLE_JSON1 in the compile-time options. (check-in: 8bf41bc5 user: drh tags: json-in-core) | |
| 19:36 | Merge trunk enhancements into the json-in-core branch. (check-in: ea755771 user: drh tags: json-in-core) | |
| 16:54 | Add a new built-in subtype() function. (check-in: a25f4ce2 user: drh tags: json-in-core) | |
|
2022-01-08
| ||
| 21:50 | Add NEVER() macros to two branches that became unreachable due to [e199a851e316bd47]. (check-in: 71272caf user: drh tags: trunk) | |
| 21:00 | Add function format() as an alias for printf(), for compatibility with other systems. (check-in: 68bffc61 user: drh tags: trunk) | |
| 15:37 | Merge the JSON function enhancements from the json-enhancements branch into json-in-core. (check-in: e116501c user: drh tags: json-in-core) | |
| 15:05 | Improved commenting of changes in the json1.c extension. (check-in: 4d81425e user: drh tags: json-enhancements) | |
|
2022-01-07
| ||
| 18:09 | Notes on the JSON enhancement proposals. (check-in: 18160985 user: drh tags: json-enhancements) | |
| 17:26 | Reverse the meaningn of -> and ->>. ->> raises an error on invalid JSON but -> does not. This allows ->> to behave the same as PG and MySQL. (check-in: 85f81705 user: drh tags: json-enhancements) | |
| 17:14 | Change the -> operator to use json_extract(). The ->> operator continues to use json_nextract(). (check-in: b4c8a623 user: drh tags: json-enhancements) | |
| 17:08 | New json_nextract() function that works like json_extract() except that it returns NULL instead of raising an error if the first argument is not well-formed JSON. Or if the first argument is not well-formed JSON and the second argument is '$', then return the first argument quoted. The "->" and "->>" operators are converted to use json_nextract(). (check-in: dc00f528 user: drh tags: json-enhancements) | |
| 16:03 | Add the json_ntype() SQL function. Works like the 1-argument json_type() except that it returns NULL if the argument is not well-formed JSON, rather than raising an error. (check-in: ed9956f5 user: drh tags: json-enhancements) | |
| 15:47 | Accept abbreviated JSON Paths on the right-hand side of the -> and ->> operators. (check-in: d1541090 user: drh tags: json-enhancements) | |
| 14:58 | Add new binary operators "->" and "->>" to the parser that evaluate to 2-argument SQL functions by the same name. Add new "->" and "->>" functions to the JSON extension that are aliases for json_extract(). (check-in: c4e4e3a3 user: drh tags: json-enhancements) | |
|
2022-01-06
| ||
| 17:13 | Add the '-guard:cf' compiler option for Windows 10, per forum post 8d3b4ad694. (check-in: 2d6a16ca user: mistachkin tags: trunk) | |
| 01:40 | An attempt to integrate the JSON functions directly into the SQLite core, rather than holding them as an extension. (check-in: 583b47d8 user: drh tags: json-in-core) | |
|
2022-01-05
| ||
| 21:01 | Remove two NEVER() macros that can sometimes be true if the database is corrupt. dbsqlfuzz 0414d2c18290fc80fd5fb540def7d3e46c1ae9c6. (check-in: b6a82f3c user: drh tags: trunk) | |
| 15:54 | Fix an assert() failure that could follow an OOM when coding a RETURNING trigger. dbsqlfuzz case 5d3e2438f15dc32b473d9f29413157857efa1212. (check-in: 7ae596dd user: dan tags: trunk) | |
| 11:49 | Improved handling of OOM errors in sqlite3ExpandReturning(). dbsqlfuzz 1040b720f0bbc3bdcfe7336acffbf71517e3ef82. (check-in: 33c6b8e9 user: drh tags: trunk) | |
|
2022-01-03
| ||
| 19:33 | Test .mode quote blob output (check-in: ef4dcd10 user: larrybr tags: trunk) | |
| 01:43 | Small performance and size optimization to allocateCursor(). (check-in: 23f04266 user: drh tags: trunk) | |
|
2022-01-02
| ||
| 21:53 | Remove unnecessary assignment operations in the btree search algorithm, for a small size reduction and performance increase. (check-in: 01bd266e user: drh tags: trunk) | |
| 20:54 | In the CLI, fix ".mode quote" output for UTF16 BLOBs. Forum post b4bfe62fe6. (check-in: 728e9dcc user: drh tags: trunk) | |
| 19:32 | Do not open a rollback journal file when the journal_mode is OFF, even if such a file exists on disk. See [forum/forumpost/ec2a102440|forum post ec2a102440] for a description. I so far have been unable to find any harm to come of the problem, other than the assertion fault when in DEBUG mode. (check-in: fdf9ed66 user: drh tags: trunk) | |
| 19:10 | Improve formatting of an assert(). No functional changes. (check-in: 4bb78ce8 user: drh tags: trunk) | |
| 16:48 | Performance optimization in btreeParseCellPtr() by unrolling the loop that decodes the rowid. (check-in: fef72368 user: drh tags: trunk) | |
| 14:55 | Small performance optimization and size reduction in sqlite3BtreeDelete(). (check-in: da0af4dd user: drh tags: trunk) | |
| 12:01 | Clear the cache of triggers used to implement CASCADE foreign key constraints whenever the schema changes. Fix for the problem identified by forum post 2831335356. (check-in: 5232c977 user: drh tags: trunk) | |
| 11:25 | Earlier detection of corruption in sqlite3BtreeDelete(). Fix for the assertion fault reported by forum post 9d78389221. (check-in: 13e9ff9e user: drh tags: trunk) | |
|
2022-01-01
| ||
| 22:55 | Do not raise an SQLITE_SCHEMA error if in sqlite3Init(). Fix for PoC #2 in forum post d7338bf4901f1151. See TH3 for test cases. (check-in: e199a851 user: drh tags: trunk) | |
| 20:02 | Fix an assert() in pager.c to avoid the possibility of side-effects. (check-in: 1d1fe03c user: dan tags: trunk) | |
| 19:55 | Attempt to fix a harmless compiler warning in FTS5. (check-in: 8e619c21 user: drh tags: trunk) | |
| 19:29 | Fix an obscure problem with releasing savepoints stored in an in-memory journal that could cause subsequent savepoint rollback to fail. Problem reported by forum post d7338bf4901f1151, PoC #3. The problem appears to have been introduced at [23ca23894af352ea]. (check-in: 73c2b502 user: dan tags: trunk) | |
| 17:21 | Remove an obsolete assert() statement that no longer does anything useful and which is not always true. Fix for PoC #1 of forum post d7338bf4901f1151. (check-in: c76a4c0b user: drh tags: trunk) | |
| 12:26 | Fix a faulty assert() statement - adding a CORRUPT_DB term - based on a test case derived from [562805cf488a455c]. Also add a test case to that prior issue. (check-in: 0dd6b5fc user: drh tags: trunk) | |
|
2021-12-31
| ||
| 22:53 | Mark the REGEXP operator in the built-in extension as deterministic. (check-in: e654b57a user: drh tags: trunk) | |
| 19:20 | Simplify the sqlite3RunParser() routine by omitting the third parameter. Results in a binary that is about 100 bytes smaller and 1.4M cycles faster. (check-in: 6fb2a1bb user: drh tags: trunk) | |
| 19:08 | Fix harmless compiler warnings in the shell. (check-in: f3ea36d7 user: mistachkin tags: trunk) | |
| 18:26 | Fix harmless compiler warnings seen with MSVC. (check-in: a9bfb621 user: mistachkin tags: trunk) | |
| 17:54 | Performance optimization and size reduction in sqlite3RunParser(). (check-in: 41ee2bac user: drh tags: trunk) | |
| 16:37 | Move the pTriggerPrg and pCleanup elements of the Parse object up into the section of that object that is persisted across calls to sqlite3NestedParse(). This fixes a memory leak reported in forum post 24bd1fef7e9323ef. (check-in: 562805cf user: drh tags: trunk) | |
|
2021-12-30
| ||
| 17:46 | Remove unnecessary conditionals around the ORDER BY resolver calls in multiSelectOrderBy(). (check-in: f2887e01 user: drh tags: trunk) | |
| 17:36 | When constructing the sqlite3_index_info object for the xBestIndex method of a virtual table, omit constant trims from the ORDER BY clause, as they will always be in the correct order. (check-in: 524c2b87 user: drh tags: trunk) | |
| 02:38 | When a table has an INTEGER PRIMARY KEY ON CONFLICT REPLACE and some other uniqueness constraint, and it participates in an upsert on that other constraint, ensure that code that checks for conflicts on the INTEGER PRIMARY KEY is well-formed. Fix for the problem reported by forum post 06b16b8b29f8c8c3. (check-in: 2f09b51b user: drh tags: trunk) | |
| 00:37 | When implementing a multi-way compound SELECT using merge, try to balance the merge tree. (check-in: bb8522fe user: drh tags: trunk) | |
|
2021-12-29
| ||
| 13:32 | Minor changes to shell1.test test results to account for the new feature of the shell that points to the specific part of the input line where the error occurs. (check-in: d4870c08 user: drh tags: trunk) | |
| 04:31 | Ensure that the affinity of columns is honored in the RETURNING clause. See forum post e0c7574ab2 for the bug report. (check-in: 4711fb69 user: drh tags: trunk) | |
| 04:13 | Add the sqlite3_error_offset() interface. Use it to enhance error reporting in the CLI. (check-in: 416602a8 user: drh tags: trunk) | |
| 04:10 | Make .read's help tell of piped input (check-in: 155c3e9c user: drh tags: trunk) | |
| 04:10 | Change an assert() in FTS3 into assert_fts3_nc(), since it is a harmless condition that can occur when processing a corrupt database file. (check-in: e773d621 user: drh tags: trunk) | |
| 04:08 | Fix the build-breaker bug in test1.c introduced by check-in [7fa20ca4c09ab024]. (Closed-Leaf check-in: 5f804da1 user: drh tags: build-bug) | |
|
2021-12-28
| ||
| 05:08 | Make .read's help tell of piped input (check-in: e4ddcd8a user: larrybr tags: build-bug) | |
|
2021-12-25
| ||
| 23:59 | Change an assert() in FTS3 into assert_fts3_nc(), since it is a harmless condition that can occur when processing a corrupt database file. (check-in: c03205ae user: drh tags: build-bug) | |
| 00:26 | Add the sqlite3_error_offset() interface. Use it to enhance error reporting in the CLI. (Later:) There is a bug in src/test1.c that prevents the code from even building. How did this pass tests? Moving to a branch to prevent fugure bisect problems. (check-in: 7fa20ca4 user: drh tags: build-bug) | |
| 00:19 | One minor change for an exceptional case in sqlite3_error_offset(). (Closed-Leaf check-in: c93609a8 user: drh tags: improved-error-context) | |
|
2021-12-24
| ||
| 20:22 | Add the sqlite3_error_offset() interface. Use it in the CLI to provide better context for error messages. (check-in: b518ce77 user: drh tags: improved-error-context) | |
| 19:44 | Fix a minor problem in the CLI introduced by [d156123885abe6bf], apparently. (check-in: 37e6e10f user: drh tags: trunk) | |
| 13:30 | Raise an error if a schema name is attached to the table-alias name of a subquery or view. See forum post 021a33600b for the bug report. (check-in: 8af8c153 user: drh tags: trunk) | |
|
2021-12-23
| ||
| 00:16 | Reduce the size of the compiled binary by a couple of hundred bytes by using a thigher packing of a transformation table in date.c. Suggested by forum post 4f6efbb2a9. (check-in: c75ba4fa user: drh tags: trunk) | |
|
2021-12-21
| ||
| 16:59 | Update the README.md to instruct the user to remove the final comment line from the "manifest" file before using it to compute the check-in hash. (check-in: 7b4f9d95 user: drh tags: trunk) | |
|
2021-12-20
| ||
| 23:46 | In the json1 extension, which compiling it separately, ensure that either SQLITE_DEBUG macro or the NDEBUG macro is set prior to including assert.h. If neither macro is defined, then assert() statement do generate code but VVA() statements do not, and that is a deadly combination. forum post 858dee399e (check-in: d9f814a6 user: drh tags: trunk) | |
| 17:00 | Remove old script ext/fts3/mkfts3amal.tcl, as it doesn't work. (check-in: 9e33ee24 user: dan tags: trunk) | |
|
2021-12-17
| ||
| 23:56 | Improved documentation for the sqlite3_vtab_collation() interface. (check-in: 826f84a9 user: drh tags: trunk) | |
|
2021-12-16
| ||
| 19:50 | Fix windowC tests to specify little-endian or big-endian UTF16, for cross-platform portability. Forum post 559b84a5c6 (check-in: adf3a1e6 user: drh tags: trunk) | |
| 19:43 | Give the correct prefix to tests in the windowC.test module. (check-in: fb434563 user: drh tags: trunk) | |
| 17:57 | In the CLI, omit the ".oom" command (only available in debug builds) and disable the experimental ".expert" commmand in --safe mode. (check-in: 5cda1f7d user: drh tags: trunk) | |
| 17:35 | New defenses against OOM and corrupt database problems in the CLI. (check-in: 5c9fd7fd user: drh tags: trunk) | |
| 17:21 | Fix a typo in the result of one of the new test cases. (check-in: 4d02a129 user: drh tags: trunk) | |
| 15:29 | Fix fts3 and fts4 so that they can still be used even if the other is dropped by a call to sqlite3_drop_modules(). (check-in: a0a8d6c9 user: dan tags: trunk) | |
| 14:59 | Fix a memory leak in the CLI that occurs after an error in the ".open" command. (check-in: d1561238 user: drh tags: trunk) | |
| 14:36 | Fix harmless compiler warning in the new Bloom filter logic. (check-in: 9406d95d user: drh tags: trunk) | |
| 14:26 | Improved robustness against OOM in the expert extension. (check-in: e732c429 user: drh tags: trunk) | |
| 13:56 | Fix a potential NULL pointer dereference in the CLI logic for printing the schema of virtual tables. (check-in: fe44ebf6 user: drh tags: trunk) | |
| 13:29 | Add more tests for OOM conditions in the CLI. (check-in: b6fa402d user: drh tags: trunk) | |
|
2021-12-15
| ||
| 20:48 | Simplify the generation of the sqlite3_index_info object during query planning for virtual tables. (check-in: 241dc042 user: drh tags: trunk) | |
|
2021-12-14
| ||
| 20:13 | Enhance the virtual table query planner so that it is able to deal with ORDER BY terms that contain COLLATE clauses as long as the specified collation matches the virtual table. This is especially important for UNION ALL since a "COLLATE binary" is added to ORDER BY clauses if no COLLATE clause exists in the original SQL. (check-in: 5c3d398d user: drh tags: trunk) | |
| 18:11 | Minor fix to the ORDER BY elimination logic in generate_series(). (check-in: a2e50712 user: drh tags: trunk) | |
| 00:36 | Omit the return value from sqlite3VdbeSerialGet() for a size reduction and performance improvement. (check-in: 788e79f8 user: drh tags: trunk) | |
|
2021-12-13
| ||
| 19:59 | Small performance optimization and code size reduction in moveToRoot(). (check-in: cdcde00b user: drh tags: trunk) | |
| 18:53 | Add NEVER() on an unreachable branch in the Bloom filter pull-down logic. (check-in: 47107046 user: drh tags: trunk) | |
| 18:43 | Fix an off-by-one error in the Bloom filter pulldown logic, found by OSSFuzz. Also fix over-length source code lines in the immediate vicinity. (check-in: 02762652 user: drh tags: trunk) | |
| 00:02 | Remove unused code. (check-in: b98b24f2 user: drh tags: trunk) | |
|
2021-12-11
| ||
| 17:10 | Do not allow early evaluation of Bloom filters that use the IN operator as the machinery to deal with the IN operator is not available. dbsqlfuzz 5b51c247518278f79a45cea978702e86e86cd4f9. (check-in: 799db7cb user: drh tags: trunk) | |
|
2021-12-10
| ||
| 21:01 | Factor out the logic that does quoting for the SQL quote() function, so that it might be reused for other purposes. (check-in: 8e98ba1e user: drh tags: trunk) | |
| 17:36 | Rename the internal routine constructBloomFilter() to sqlite3ConstructBloomFilter(). OSSFuzz is reporting a crash with a garbled stack that we cannot reproduce. Perhaps the original "constructBloomFilter()" name is colliding with some internal name used by OSSFuzz. We'll see if this rename clears the problem. (check-in: 403e7312 user: drh tags: trunk) | |
|
2021-12-09
| ||
| 20:06 | Add support for Bloom-filters as a performance optimization for joins. (check-in: 633bfeee user: drh tags: trunk) | |
| 19:42 | Remove unused code and fix comments. Final cleanup before merging. (Closed-Leaf check-in: ce42039f user: drh tags: bloom-filter) | |
| 18:44 | Enable bloom filters for the right table of a LEFT JOIN. Fix unreachable branches. (check-in: d342ab72 user: drh tags: bloom-filter) | |
| 16:26 | Add ".mode off" and ".mode count" to the CLI. (check-in: 1eefd957 user: drh tags: trunk) | |
| 16:17 | Add ".mode off" and ".mode count" to the CLI. (check-in: b11f4d08 user: drh tags: bloom-filter) | |
| 14:15 | New test cases added to test/fuzzdata8.db (check-in: 70468770 user: drh tags: trunk) | |
| 14:09 | Do not attempt to reprepare a prepared statement that returns SQLITE_SCHEMA if there was an OOM. This enhancement supercedes check-in [fee469925231d074]. (check-in: 94fdbeff user: drh tags: trunk) | |
| 01:28 | Add SQLITE_TESTCTRL_LOGEST and enhance the LogEst utility program. Improvements to testability of bloom filters. (check-in: 88b43d79 user: drh tags: bloom-filter) | |
|
2021-12-08
| ||
| 20:36 | Clarity tweak for date.c (check-in: db58b2de user: larrybr tags: trunk) | |
| 19:50 | Improvements on the decision of whether or not to use a Bloom filter. (check-in: 0fb2a4e0 user: drh tags: bloom-filter) | |
| 18:50 | Enhance the sqlite3SrcListAppendFromTerm() routine so that it sets the Parser error on an OOM, causing an earlier unwind of the stack. (check-in: fee46992 user: drh tags: trunk) | |
| 16:15 | Merge the WhereClause fix from trunk (check-in: d3250256 user: drh tags: bloom-filter) | |
| 16:07 | In the WhereClause object, do not assume that all TERM_VIRTUAL terms appear at the end of the list, because that is no longer true. Instead, keep a separate nBase count that is the size of the list excluding the tail of virtual terms. Use nBase instead of nTerm when scanning terms that are not virtual. Add assert()s to validate correctness of WhereClause. (check-in: 6024682c user: drh tags: trunk) | |
|
2021-12-07
| ||
| 22:37 | Do not generate a Bloom filter if it cannot be used prior to the next seek, as that leads to a misleading EXPLAIN QUERY PLAN. (check-in: 2739ed51 user: drh tags: bloom-filter) | |
|
2021-12-06
| ||
| 23:07 | Improved EXPLAIN QUERY PLAN output for Bloom filters. (check-in: 00070e1f user: drh tags: bloom-filter) | |
| 21:45 | Add SQLITE_STMTSTATUS_FILTER_HIT and _MISS for tracking the effectiveness of Bloom filters. (check-in: 24ba535d user: drh tags: bloom-filter) | |
| 20:16 | Omit the OP_FilterInit opcode. Use OP_Blob to initialize each Bloom filter instead. Size the Bloom filter based on sqlite_stat1 size estimates rather than a run-time measurement for improved testability. (check-in: 8a9036ee user: drh tags: bloom-filter) | |
| 19:11 | Merge trunk fixes into the bloom-filter branch. (check-in: edacf803 user: drh tags: bloom-filter) | |
| 18:57 | Fix an OOB read that could occur in fts5 when processing corrupt records. (check-in: bb9b1a15 user: dan tags: trunk) | |
| 15:40 | Do not allow SQLITE_LIMIT_LENGTH to be set lower than 1 as an SQLITE_LIMIT_LENGTH of 0 causes lots of unnecessary problems for users of the sqlite3_str object. (check-in: 8fd5b8ec user: drh tags: trunk) | |
| 15:24 | Do not allow certain dangerous ".testctrl" commands in safe mode. (check-in: 080e72d1 user: drh tags: trunk) | |
| 15:08 | Fix SQLITE_TESTCTRL_IMPOSTER so that it is a harmless no-op if the schema parameter is invalid. (check-in: 2d9a45ab user: drh tags: trunk) | |
| 13:07 | Attempt to vary the size of Bloom filters based on an estimate of how many keys the filter will hold. (check-in: a7adcf69 user: drh tags: bloom-filter) | |
|
2021-12-05
| ||
| 20:19 | Run as many Bloom filters as possible before index lookups. (check-in: 06f6fefd user: drh tags: bloom-filter) | |
| 00:45 | Try to run all Bloom filters before any Seeks. This gives a small performance gain on the Star-Schema Benchmark. (check-in: 5be2470f user: drh tags: bloom-filter) | |
|
2021-12-04
| ||
| 21:11 | Miscellaneous cleanup of the new Bloom-filter code. (check-in: 201b6dd8 user: drh tags: bloom-filter) | |
| 18:45 | Add VdbeCoverage() macros. Adjust the Bloom-filter hash function so that it correctly deals with zero-blobs. (check-in: 629ee2e3 user: drh tags: bloom-filter) | |
| 14:24 | Apply the Bloom filter only on those terms of an index that have equality constraints. (check-in: a7042959 user: drh tags: bloom-filter) | |
| 13:52 | Add the "WITH BLOOM FILTER" clause to the EXPLAIN QUERY PLAN output for cases were a Bloom filter is used. (check-in: 8e078c0e user: drh tags: bloom-filter) | |
| 13:43 | First attempt to use Bloom filters to optimize star-schema queries. (check-in: 28161fba user: drh tags: bloom-filter) | |
|
2021-12-03
| ||
| 19:10 | Merge the sqlite3WhereBegin() simplification from trunk. (check-in: 41ba2dfd user: drh tags: bloom-filter) | |
| 18:53 | Factor the noop-join-elimination optimization out of the sqlite3WhereBegin() routine and into a separate "no-inline" subroutine, in order to reduce the complexity of sqlite3WhereBegin() and thereby encourage C compilers to inline sqlite3WhereCodeOneLoopStart(). (check-in: 6225e9ab user: drh tags: trunk) | |
| 16:02 | Merge recent trunk enhancements into the bloom-filter branch. (check-in: 11d97fb8 user: drh tags: bloom-filter) | |
| 15:48 | Fix exprAnalyze() after recent performance enhancements so that it is able to handle IF_NULL_ROW opcode correctly, again. (check-in: 8029e6ba user: drh tags: trunk) | |
| 14:57 | Fix unreachable branches resulting from prior optimizations. (check-in: f3d6853e user: drh tags: trunk) | |
| 14:43 | Fix an over-length source code line in build.c. No logic changes. (check-in: b9db5c5f user: drh tags: trunk) | |
| 13:42 | Performance optimization in the B-Tree cursor allocator btreeCursor(), making it about 800K CPU cycles faster in speedtest1, and reducing the executable size by about 100 bytes. (check-in: 9df93971 user: drh tags: trunk) | |
|
2021-12-02
| ||
| 18:15 | Optimizations to exprAnalyze() and sqlite3WhereExprUsage() save about 1.5 million CPU cycles for speedtest1, and result in a smaller binary. (check-in: 1f2252e6 user: drh tags: trunk) | |
| 14:28 | Move the TK_IS token so that it is adjacent to the TK_IN token, as this allows the C compiler to optimize better, resulting in a slightly smaller and faster executable. (check-in: 8832fa90 user: drh tags: trunk) | |
| 14:16 | In the shell tool, avoid modifying internal data structures until after the arguments to ".open" have been parsed. (check-in: fcc509d3 user: dan tags: trunk) | |
| 13:45 | Remove an unnecessary branch from exprAnalyze(), resulting in a small performance gain. (check-in: 3312be1d user: drh tags: trunk) | |
| 12:55 | Small performance optimization in sqlite3WhereClauseClear(). (check-in: 080b35e6 user: drh tags: trunk) | |
| 12:34 | More small performance optimizations for sqlite3WhereGetMask(). (check-in: 3de2c557 user: drh tags: trunk) | |
| 04:00 | Small performance optimization in sqlite3WhereGetMask(). (check-in: 7edec54a user: drh tags: trunk) | |
| 02:22 | Small performance enhancement for whereScanInit(). (check-in: ed84e124 user: drh tags: trunk) | |
| 01:30 | Performance improvement in query planning. (check-in: ca59533b user: drh tags: trunk) | |
|
2021-12-01
| ||
| 21:07 | Merge trunk fixes into the bloom-filter branch. (check-in: 0864bfbf user: drh tags: bloom-filter) | |
| 19:17 | Check for foreign key constraint errors prior to returning the results from a RETURNING clause. See forum post 793beaf322. (check-in: a818ba2e user: drh tags: trunk) | |
| 16:31 | Add a Bloom filter to the automatic-index mechanism. (check-in: 50ac4de1 user: drh tags: bloom-filter) | |
| 11:03 | Add the "static" qualifier to some internal functions in code for various SQLite extensions. (check-in: 8c986782 user: dan tags: trunk) | |
|
2021-11-30
| ||
| 14:07 | In the automatic index generator logic, be more precise about when a partial automatic index is allowed in order to capture more cases where it is legal to use a partial automatic index. (check-in: 664b461b user: drh tags: trunk) | |
|
2021-11-29
| ||
| 18:09 | Merge in the proposed date/time function enhancements: (1) Add the unixepoch() function, (2) the 'auto' modifier and (3) the 'julianday' modifier. (check-in: 19c51b46 user: drh tags: trunk) | |
| 17:55 | Bump the version number up to 3.38.0 in order to begin the next development cycle. (check-in: 8ad1fcaa user: drh tags: trunk) | |
| 17:23 | Add the unixepoch() function and the 'auto' and 'julianday' modifiers. (Closed-Leaf check-in: 559fdc0a user: drh tags: unixepoch) | |
|
2021-11-28
| ||
| 19:54 | Following a prior error, an ALWAYS() in sqlite3ExprCanBeNull() might be false. dbsqlfuzz 5dbec6678a20e7595a34dfdd869a3b9722b3ca43. (check-in: 4e207401 user: drh tags: trunk) | |
|
2021-11-27
| ||
| 14:13 | Version 3.37.0 (check-in: bd41822c user: drh tags: trunk, release, major-release, version-3.37.0) | |
| 12:03 | Fix a harmless comment typo. (check-in: 7c567338 user: drh tags: trunk) | |
|
2021-11-26
| ||
| 20:26 | Add platform "Darwin-arm64" to test/releasetest_data.tcl. (check-in: 1d5c9aac user: drh tags: trunk) | |
| 17:10 | Improved defenses against integer overflow when computing the size of a memory allocations. No bugs were fixed here. But perhaps future bugs will be prevented. (check-in: eb878c01 user: drh tags: trunk) | |
| 15:08 | Fixes to internal comments. No changes to code or documentation. (check-in: 1489b196 user: drh tags: trunk) | |
|
2021-11-24
| ||
| 21:16 | Avoid splitting Failure-Detection test cases in wapptest.tcl. (check-in: 654e6cf8 user: dan tags: trunk) | |
| 11:33 | Update Makefile.msc to support target "tcltest" in the same way as the autoconf build system. (check-in: 0f131b92 user: dan tags: trunk) | |
|
2021-11-23
| ||
| 22:28 | Changes a test pattern for RBU so that it works regardless of whether newer TCL versions are used. (check-in: 5a9921c9 user: drh tags: trunk) | |
| 12:59 | Fix a compiler warning in the dbserialize method of the TCL interface. (check-in: ba71d030 user: drh tags: trunk) | |
| 11:34 | Exclude two recently added tests in where.test from valgrind runs. They fail due to the subtly different handling of real numbers under valgrind. (check-in: e842d208 user: dan tags: trunk) | |
|
2021-11-22
| ||
| 16:50 | Omit wal mode tests in memdb1.test for builds and configurations that do not support wal mode. (check-in: 0f13c0d9 user: dan tags: trunk) | |
| 16:48 | Omit wal mode tests in vacuum-into.test for builds and configurations that do not support wal mode. (check-in: 65de1763 user: dan tags: trunk) | |
| 16:43 | Do not attempt to run the tests in alterfault.est with SQLITE_OMIT_ALTERTABLE builds. (check-in: 6f6f31c7 user: dan tags: trunk) | |
| 16:27 | Fix a typo in memdb1.test preventing tests from passing with -DSQLITE_DEFAULT_AUTOVACUUM=1 builds. (check-in: eff4187c user: dan tags: trunk) | |
| 16:06 | There are two possible error messages from stat-9.1, depending on compile-time options. Adjust the test case to accept either one. (check-in: 0f567b61 user: drh tags: trunk) | |
| 13:59 | In fuzzcheck, improve the defense against long delays due to rogue busy_timeout macros in fuzzer-generated scripts. (check-in: 3024d7ca user: drh tags: trunk) | |
| 13:35 | Fix the build for SQLITE_OMIT_CTE. (check-in: d7ef96ba user: drh tags: trunk) | |
| 12:59 | In the previous check-in, do not overwrite the SQLITE_CORRUPT signal with an SQLITE_OK before exiting fts3auxNextMethod(). (check-in: 396688ae user: drh tags: trunk) | |
| 08:12 | Fix a crash in the fts3aux code that could occur handling corrupt records. (check-in: cdcd65b8 user: dan tags: trunk) | |
|
2021-11-20
| ||
| 13:30 | New test cases for STRICT and NOT NULL in PRIMARY KEY. (check-in: 0eafbc2f user: drh tags: trunk) | |
|
2021-11-19
| ||
| 19:11 | Small performance increase and size reduction for sqlite3ExprCompare(). This change also handles some corner cases without the need for ALWAYS(). (check-in: d814ba6e user: drh tags: trunk) | |
| 14:02 | Fix a benign data race in os_unix.c that might trouble tsan and similar tools. (check-in: 95806ac1 user: dan tags: trunk) | |
|
2021-11-18
| ||
| 20:56 | Minor tweaks to the way auxiliary tools are built, to make it easier to customize the builds without having to alter the code. (check-in: 90b06b6f user: drh tags: trunk) | |
| 20:11 | Fix a performance regression in rtree introduced by the previous commit. (check-in: 7f42b8e1 user: dan tags: trunk) | |
| 19:15 | Fix a problem slowing down the handling of == constraints in the rtree module. (check-in: 509027e9 user: dan tags: trunk) | |
| 15:40 | Improve CSV quoting in the CLI using the strstr() function. (check-in: b7927bf9 user: drh tags: trunk) | |
| 13:25 | Fix an obscure problem associated with quoting of CSV output in the CLI. (check-in: 38a9b660 user: drh tags: trunk) | |
|
2021-11-16
| ||
| 13:36 | Fix a problem causing an OOM within an ALTER TABLE ADD COLUMN command that adds a column with a CHECK constraint to go unreported. (check-in: a33f5e93 user: dan tags: trunk) | |
|
2021-11-15
| ||
| 19:10 | Strengthen the sticky-CORRUPT idea of check-in [3feb0f1c3840904d] by automatically changing the first COMMIT after an SQLITE_CORRUPT error into a ROLLBACK. (check-in: bd66ab8a user: drh tags: trunk) | |
| 18:50 | Small performance optimization in sqlite3VdbeHalt(). (check-in: 9e1ecf43 user: drh tags: trunk) | |
| 14:11 | Fix a problem causing the count(*) optimization to be misapplied in some cases where an aggregate sub-query uses a count() expression that is aggregated against the outer query. (check-in: e3091727 user: dan tags: trunk) | |
| 13:22 | Improved context shown for the "ABORT-due-to-error" output line when using "PRAGMA vdbe_debug=on" in an SQLITE_DEBUG build. (check-in: c7776369 user: drh tags: trunk) | |
| 01:45 | Fix a faulty JSON assert() added 30 days ago by check-in [7b8ea2298927fd34]. dbsqlfuzz f30366e7b02562398a387ddcc681422fd4251190. (check-in: 0e0c23fc user: drh tags: trunk) | |
|
2021-11-12
| ||
| 14:39 | Improved handling of OOM while reallocating a column name to add type information. dbsqlfuzz 5a195b4233649e49e0aa34f1b743ca192d85b198 (check-in: 5995dd4d user: drh tags: trunk) | |
|
2021-11-11
| ||
| 23:52 | Make sure the rowid value returned by the VUpdate opcode is always initialized. (check-in: 150b5be5 user: drh tags: trunk) | |
| 16:26 | Remove a NEVER() that was add yesterday. The fuzzer found a new test case to make it happen. (check-in: 83e6ac71 user: drh tags: trunk) | |
| 11:23 | New assert() statements to help prove correct usage of VdbeCursor objects. (check-in: 7cee62f7 user: drh tags: trunk) | |
|
2021-11-10
| ||
| 15:23 | Load new test cases into test/fuzzdata8.db (check-in: 8b53ffe9 user: drh tags: trunk) | |
| 10:59 | Make SQLITE_CORRUPT sticky: If a CORRUPT error is returned, all subsequent write statements within the same transaction also fail early with SQLITE_CORRUPT. (check-in: 3feb0f1c user: drh tags: trunk) | |
|
2021-11-09
| ||
| 13:31 | Change test case error message text to match the current implementation. (check-in: de10795a user: drh tags: trunk) | |
| 01:48 | Fix lempar.c so that Lemon can compile with NDEBUG defined. Forum post f331adca0b (check-in: ba4fb518 user: drh tags: trunk) | |
|
2021-11-08
| ||
| 23:24 | Refactor the code that figures out which SELECT in a cascade of nested queries a particular aggregate function belongs to. This fixes the problem reported by forum post c7cc2aa3546e39c1. New test cases in dbsqlfuzz and th3. (check-in: 74aec5dd user: drh tags: trunk) | |
| 19:35 | Fix the zeroblob() function and related APIs so that they work with SQLITE_OMIT_INCRBLOB builds. (check-in: bc401a75 user: dan tags: trunk) | |
| 15:46 | Fix an assert() in memdbTruncate() that could fail when processing a corrupt database. (check-in: b1e29298 user: dan tags: trunk) | |
|
2021-11-07
| ||
| 23:33 | Ensure that the window function rewrite does not leave the parse tree in an invalid state that might cause problems downstream before the error is recognized and unwinds the stack. Also take steps such that an invalid parse tree does not cause problems even if it goes unrecognized. Forum post 398e9d5aa9. (check-in: 0f9fc6b6 user: drh tags: trunk) | |
|
2021-11-06
| ||
| 20:25 | Add ALWAYS() to a branch made unreachable by the previous check-in. (check-in: 0dc963f6 user: drh tags: trunk) | |
| 18:22 | Return an error if an attempt is made to drop an eponymous virtual table. (check-in: 889dea52 user: dan tags: trunk) | |
| 10:59 | Avoid accessing the sqlite3_module.xShadowName field if (sqlite3_module.iVersion<3). (check-in: a024764c user: drh tags: trunk) | |
| 07:08 | Avoid accessing the sqlite3_module.xShadowName field if (sqlite3_module.iVersion<3). (check-in: b1fc3de8 user: dan tags: reuse-schema) | |
|
2021-11-05
| ||
| 22:35 | Add the rbu_exclusive_checkpoint query parameter to RBU. (check-in: c2d33ea9 user: drh tags: trunk) | |
| 22:23 | New test cases for rbu_exclusive_checkpoint query parameter. (Closed-Leaf check-in: 00285ff1 user: drh tags: rbu_exclusive_checkpoint) | |
| 19:52 | Update an assert() statement to conform to the changes of the previous check-in. (check-in: b5c668ca user: drh tags: trunk) | |
| 19:36 | Add the SQLITE_OPEN_EXRESCODE flag for sqlite3_open_v2(). (check-in: ff9373f4 user: drh tags: trunk) | |
| 19:04 | If the target database URI passed to sqlite3rbu_open() is contains the option "rbu_exclusive_checkpoint=1", hold an exclusive lock for the duration of any incremental checkpoint operation. (check-in: 7cb77296 user: dan tags: rbu_exclusive_checkpoint) | |
| 14:13 | Update sqllimits1.test to account for recent changes to SQL function strftime(). (check-in: 7bba415f user: dan tags: trunk) | |
| 12:34 | Use the FTS_CORRUPT_VTAB macro rather than a direct call to sqlite3Fts3Corrupt() in [2fad2a89527757b3] so that the build works in all cases. (check-in: 029c59cd user: drh tags: trunk) | |
| 11:52 | Remove an incorrect NEVER() reported at forum post 5bbabfb7ce. Also use this opportunity to improve the isSimpleCount() function with better formatting, an expanded header comment, and some extra assert() and textcase() macros. (check-in: 2927185b user: drh tags: trunk) | |
| 11:26 | Fix vacuum3.test so that it works with SQLITE_OMIT_ALTERTABLE builds. (check-in: 07cca2fa user: dan tags: trunk) | |
| 11:18 | Update a test case in sqllimits1.test to account for the updated implementation of SQL function strftime() (check-in: f474ac37 user: dan tags: trunk) | |
| 10:43 | Fix a couple of problems with test scripts and SQLITE_OMIT_ALTERTABLE builds. (check-in: 3ab5414d user: dan tags: trunk) | |
|
2021-11-04
| ||
| 18:04 | Fix a crash that could occur in fts3 when processing a corrupt database. (check-in: 2fad2a89 user: dan tags: trunk) | |
| 16:25 | Fix corruptN.test so that it works with SQLITE_DEFAULT_AUTOVACUUM=1 builds. (check-in: f60e05bd user: dan tags: trunk) | |
| 16:15 | Update a test case in corruptN.test to account for the fact that if writable_schema=1 is set, no error is raised if a DELETE statement finds that an index entry is missing ([19e56291a7344c7a]). (check-in: a90c5f0b user: dan tags: trunk) | |
| 16:03 | Have wapptest.tcl avoid attempting to build fuzztest for SQLITE_OMIT_VIRTUALTABLE configurations. (check-in: 53ee208d user: dan tags: trunk) | |
| 15:17 | Fix typo in the sqlite3ext.h file. forum post 63802db4ce (check-in: d4a48ee0 user: drh tags: trunk) | |
| 14:04 | Show the preferred schema table names in the output of "PRAGMA table_list". (check-in: 9147390d user: drh tags: trunk) | |
| 11:34 | Change a branch made unreachable by the previous check-in into an assert(). (check-in: 685a987c user: drh tags: trunk) | |
| 00:51 | First the shadow table mechanism so that it works even if the shadow table comes before the virtual table in the sqlite_schema table, as can happen after a VACUUM. (check-in: 005a8642 user: drh tags: trunk) | |
|
2021-11-03
| ||
| 16:35 | Remove two incorrect assert() statements added by a check-in from earlier today. (check-in: 3206edff user: drh tags: trunk) | |
| 15:59 | Improved the error message that results when a schema parse fails after ALTER TABLE ADD COLUMN. (check-in: b007a39d user: drh tags: trunk) | |
| 14:02 | Fix INSERT into STRICT table with STATIC generated columns. (check-in: 24285d91 user: drh tags: trunk) | |
| 12:50 | Add the --strict option to speedtest1.c (check-in: a247b5d8 user: drh tags: trunk) | |
| 11:43 | Fix an issue in PRAGMA integrity_check associated reporting NULL values in a NOT NULL column of type ANY in a STRICT table. (check-in: 5dff1f66 user: drh tags: trunk) | |
|
2021-11-02
| ||
| 22:24 | Correctly handle SeekScan on an IN operator of the middle term of an index when the right-most term is a range constraint. Fix for ticket [5981a8c041a3c2f3]. (check-in: aa24660e user: drh tags: trunk) | |
| 20:52 | Proposed fix for a problem associated with OP_SeekScan that results in an incorrect answer. See ticket [5981a8c041a3c2f3]. (Closed-Leaf check-in: 266e9cba user: drh tags: seekscan-fix-20211102) | |
| 17:55 | Ensure that ALTER TABLE RENAME recognizes OOM errors while parsing dependent triggers and handles them appropriately. dbsqlfuzz 53e245eee15d3f19639d773048aa955c30708785. (check-in: 1d9004cd user: drh tags: trunk) | |
| 14:01 | Fix a minor memory leak in the shell tool. Omit running fuzztest as part of the Device-One release test configuration, as it is now incompatible with SQLITE_OMIT_VIRTUALTABLE. (check-in: 4d70f27b user: dan tags: trunk) | |
| 11:24 | Add the --remove and --glob options to the .archive command in the CLI. (check-in: ea7b12cd user: drh tags: trunk) | |
| 11:09 | Add #ifdef logic to os_unix.c so that it builds with SQLITE_OMIT_WAL defined. (check-in: 948c2cb2 user: dan tags: trunk) | |
| 10:54 | Fix a minor typo in a comment. (Closed-Leaf check-in: 06a5bf43 user: drh tags: archive_remove) | |
| 10:47 | Add recent dbsqlfuzz cases to test/fuzzdata8.db. (check-in: 8c3f2536 user: drh tags: trunk) | |
| 07:32 | Fix a broken assert() in fts5 that could fail if the snippet() function were used with a query phrase containing 0 tokens on a detail=none or detail=col table. (check-in: 0a5b94b9 user: dan tags: trunk) | |
| 00:18 | Add globbing option to shell's .archive command. (check-in: 13fb74ac user: larrybr tags: archive_remove) | |
|
2021-11-01
| ||
| 22:33 | zap trailing whitespace (check-in: f2a908e9 user: larrybr tags: archive_remove) | |
| 22:30 | Add a test for .ar -r and fix a use-of-uninitialized-variable bug (check-in: 978d5ed4 user: larrybr tags: archive_remove) | |
| 17:22 | Add --remove subcommand to shell's .archive command (check-in: 23525449 user: larrybr tags: archive_remove) | |
| 12:53 | The VVA() macro in json1.c must be active during SQLITE_COVERAGE_TEST because it affects the outcome of testcase() macros. (check-in: 92c3d253 user: drh tags: trunk) | |
|
2021-10-30
| ||
| 20:22 | Add the sqlite3_autovacuum_pages() interface. (check-in: ca2703c3 user: drh tags: trunk) | |
| 18:17 | Fix an incorrect assert() statement in sqlite3GenerateConstraintChecks(). dbsqlfuzz 4190cff310aeab359a55f354e560db95d3a6f47d (check-in: 623c0d08 user: drh tags: trunk) | |
| 17:58 | Fix a memory leak in test code on this branch. (Closed-Leaf check-in: 60cd9da9 user: dan tags: autovacuum-pages-callback) | |
| 17:30 | Merge trunk changes into this branch. (check-in: 638c1b0c user: dan tags: autovacuum-pages-callback) | |
|
2021-10-29
| ||
| 16:19 | Reorder a test add earlier today to OP_Transaction for easier testing. (check-in: 8ba73b3c user: drh tags: trunk) | |
| 13:10 | Allow "VACUUM INTO" to change the page_size of a database even if the original database is in WAL mode. Enhancement suggested by forum post 033f2c9d1f. (check-in: efc7e8c9 user: drh tags: trunk) | |
| 12:29 | Add pragmas "multiplex_enabled", "multiplex_chunksize", and "multiplex_filecount" to the multiplexer implementation. (check-in: 39c5e80d user: drh tags: trunk) | |
| 09:59 | Fix the OP_Transaction opcode so that if an error other than SQLITE_SCHEMA occurs first, the original error is not overwritten by SQLITE_SCHEMA. dbsqlfuzz 85bf7e262017c6c7bddb03ff6d8541511985d36c. (check-in: 5374226d user: drh tags: trunk) | |
|
2021-10-28
| ||
| 19:49 | Fix .import -skip issue reported at https://sqlite.org/forum/forumpost/4c0816c24fc9d16f?t=h (check-in: 3aadbe17 user: larrybr tags: trunk) | |
| 12:07 | Minor changes to make it easier for static analyzers to reason about the code. (check-in: ba4104aa user: drh tags: trunk) | |
| 00:09 | Ensure that the WAL code correctly handles all possible outcomes from the walIndexPage() routine. (check-in: 6979efbf user: drh tags: trunk) | |
|
2021-10-27
| ||
| 23:55 | Ensure that all possible outcomes for walIndexPage() are accounted for by callers. (Closed-Leaf check-in: 12715c6b user: drh tags: wal-tuneup) | |
| 20:23 | Avoid the 1-based indexing on the WalHashLoc.aPgno[] array. Make it 0-indexed instead. (check-in: 28f5f709 user: drh tags: wal-tuneup) | |
| 19:57 | Improve the comment on walIndexPage() to more accurately describe the post-conditions. (check-in: b619e936 user: drh tags: wal-tuneup) | |
| 19:05 | New assert()s to help prove correctness in sqlite3VdbeMemExpandBlob(). (check-in: 7238d580 user: drh tags: trunk) | |
| 17:15 | Fix the build for various the OMIT-everything compile-time option. No impact on regular builds. (check-in: 94780571 user: drh tags: trunk) | |
| 15:19 | Fix a harmless compiler warning in memdb.c. (check-in: 22fdc658 user: drh tags: trunk) | |
| 15:16 | Fix a harmless compiler warning in fuzzcheck. (check-in: 1cfb7e8a user: drh tags: trunk) | |
| 13:16 | Change fuzzcheck so that it accepts binary dbsql files. (check-in: c87a2426 user: drh tags: trunk) | |
| 12:05 | Add the --script option to fuzzcheck. (check-in: 5a9676bd user: drh tags: trunk) | |
|
2021-10-26
| ||
| 22:36 | Enhance fuzzcheck so that if an argument is an ordinary disk file (not a database) it is read in and processed as a script. (check-in: 978dc89d user: drh tags: trunk) | |
| 17:36 | Improved CLI error messages. (check-in: 8443a272 user: drh tags: trunk) | |
| 16:57 | Add phase and error number to CLI error messages. (Closed-Leaf check-in: 7f87a298 user: larrybr tags: detail_cli_errors) | |
| 09:53 | Fix the busy_timeout restriction on fuzzcheck so that it can deal with hexadecimal integer literals. (check-in: 4b41535b user: drh tags: trunk) | |
|
2021-10-25
| ||
| 18:51 | Remove a NEVER() in rebuildPage that is reachable, as is demonstrated by dbsqlfuzz case beac09b2756b5d285aa68f9737fdb06c972f159a. (check-in: ac3f6178 user: drh tags: trunk) | |
| 12:54 | Do not allow large busy_timeout pragmas in fuzzcheck, as they accomplish nothing other than making the tests unnecessarily slow. (check-in: fba441bf user: drh tags: trunk) | |
|
2021-10-23
| ||
| 22:14 | Improve the authorizer filter for ATTACH on fuzzcheck. (check-in: 87d49e80 user: drh tags: trunk) | |
| 22:11 | Provide an assert() to fire for applications that should never open or create a disk-based database file. (check-in: 5218ac78 user: drh tags: trunk) | |
| 20:32 | The pager now remembers when a VFS reports that a database file is SQLITE_OPEN_MEMORY and treats that database as an in-memory database. (check-in: 967b6562 user: drh tags: trunk) | |
| 17:46 | Fix the memdb VFS so that it does not allow mmap if it is resizable, and so that it never opens a disk file for any reason. (check-in: 5ee14715 user: drh tags: trunk) | |
| 11:30 | Update fuzzcheck so that it allows ATTACH statements with memdb filenames. (check-in: 31671237 user: drh tags: trunk) | |
|
2021-10-22
| ||
| 11:17 | Fix harmless compiler warnings. Improve the independence of some TCL tests. (check-in: 1a038242 user: drh tags: trunk) | |
|
2021-10-21
| ||
| 20:08 | Enable FTS5 for fuzzcheck. (check-in: 559ba38b user: drh tags: trunk) | |
| 19:48 | Fix the previous check-in so that it works with virtual tables that add new shadow tables the first time they are referenced. (check-in: f73b499e user: drh tags: trunk) | |
| 17:01 | Fix the new "table_list" pragma so that it shows the correct number of columns for views and virtual tables even when the object has not been previously used. (check-in: fb0ed8c5 user: drh tags: trunk) | |
|
2021-10-20
| ||
| 20:22 | Fix an incorrect JSON assert() that was added 5 days ago by check-in [7b8ea2298927fd34]. (check-in: e162da3a user: drh tags: trunk) | |
| 18:17 | Fix the finish_test proc in tester.tcl so that it works for Windows test builds. Fix for problem introduced yesterday by check-in [3658417bf300e004]. (check-in: f52b84e6 user: drh tags: trunk) | |
| 17:58 | Enabled the testcase() macros under SQLITE_DEBUG. (check-in: 0ae8dd13 user: drh tags: trunk) | |
| 13:48 | Fix a problem with the CARRAY extension when the SQLITE_TRANSIENT destructor is used for non-text arrays. Forum thread 48e525b266. (check-in: cac910c1 user: drh tags: trunk) | |
| 12:52 | Ensure that valid bytecode is generated for RETURNING clauses even if the schema is corrupt and PRAGMA writable_schema is set so that the schema parse returns no errors. dbsqlfuzz cb21825bdcd6fdb4b686ce4f6e2f45e781d2f220 (check-in: 69911715 user: drh tags: trunk) | |
| 11:40 | Fix a case in the fts3 offsets() function where a corrupt database record could lead to dereferencing an uninitialized pointer. (check-in: 7b7d31a6 user: dan tags: trunk) | |
|
2021-10-19
| ||
| 19:26 | Merge multi-module test logic improvements from trunk. (check-in: e00a44ac user: drh tags: autovacuum-pages-callback) | |
| 18:59 | Improved cleanup in finish_test so that specifying multiple test modules on the "./testfixture" command-line is more likely to work. (check-in: 3658417b user: drh tags: trunk) | |
| 18:53 | Fix permutations.test so that it can be called with a test file pattern that uses square brackets. (check-in: 55b62418 user: dan tags: trunk) | |
| 18:40 | Update test scripts to unregister the test devsim VFS after it is used. (check-in: bb0e18ae user: dan tags: trunk) | |
| 18:00 | Merge trunk enhancements into the autovacuum-pages-callback branch. (check-in: c26c9e50 user: drh tags: autovacuum-pages-callback) | |
|
2021-10-17
| ||
| 10:31 | Remove an incorrect assert() added 4 days ago by check-in [9e2f06b84f994277]. Replace it with a testcase() macro. (check-in: 03dff719 user: drh tags: trunk) | |
|
2021-10-16
| ||
| 19:50 | Fix a harmless scan-build warning in FTS5. (check-in: 0bf42bb5 user: drh tags: trunk) | |
| 18:53 | Add NEVER() macros on branches that become unreachable due to the previous check-in. (check-in: 5fa272cc user: drh tags: trunk) | |
| 17:09 | Have the btree layer detect when a "DELETE FROM tbl" statement is clearing a database page that is still in use (due to database corruption) and report SQLITE_CORRUPT. (check-in: a6fda39e user: dan tags: trunk) | |
| 13:59 | Fix an assert() in fts5 that could fail with a corrupt database. (check-in: e9997985 user: dan tags: trunk) | |
|
2021-10-15
| ||
| 23:02 | Demostrate a prototype sqlite3_autovacuum_pages() interface. (check-in: bb6f2b8b user: drh tags: autovacuum-pages-callback) | |
| 17:06 | Protect the WhereTerm.u union using nearby assert()s and/or branches. (check-in: 8a56de5b user: drh tags: trunk) | |
| 16:15 | Protect the JsonNode.u union using nearby assert()s and branches. (check-in: 7b8ea229 user: drh tags: trunk) | |
|
2021-10-14
| ||
| 21:13 | Fix a signed integer overflow in fts5 leading to a segfault that could occur when processing corrupt records. (check-in: 69a3ff0c user: dan tags: trunk) | |
| 19:28 | Protect access to the WhereLoop.u union using nearby assert()s and branches. (check-in: bdd84021 user: drh tags: trunk) | |
| 17:30 | Update requirement marks. No changes to code. (check-in: 3a6887a5 user: drh tags: trunk) | |
|
2021-10-13
| ||
| 20:29 | New tests added to test/fuzzdata8.db. (check-in: e944d717 user: drh tags: trunk) | |
| 20:11 | Convert an assert() into a corruption detection branch in sqlite3BtreePayload(). dbsqlfuzz 848171b5d58f6e4a62257466e0e7de16696d4f02. (check-in: f038d7f9 user: drh tags: trunk) | |
| 15:09 | Attempt to clarify the sqlite3_open_v2() documentation so that people do not come away with the idea that SQLITE_OPEN_EXCLUSIVE is an allowed bit value for the 3rd argument bitmask. (check-in: 1310a126 user: drh tags: trunk) | |
| 14:45 | Back out the SQLITE_OPEN_EXCLUSIVE changes because it does not work on Windows and it does not work always on unix. (check-in: d008ad79 user: drh tags: trunk) | |
| 14:01 | Remove a NEVER() macro in ALTER TABLE due to an obscure case of a nested CTE inside an UPDATE within a trigger. dbsqlfuzz e89174cbfad2d904f06b5e24df0a22510b6a1c1e (check-in: 9e2f06b8 user: drh tags: trunk) | |
| 13:00 | The sqlite3_result_text() routine (and similar) should record OOM errors in addition to SQLITE_TOOBIG errors. dbsqlfuzz (check-in: eca43436 user: drh tags: trunk) | |
|
2021-10-12
| ||
| 22:55 | Fix the group_concat() inverse function implementation so that it correctly handles BLOB inputs when database text encoding is UTF16. (check-in: 38a1326b user: drh tags: trunk) | |
| 18:05 | Fix an incorrect assert() in SQLITE_ENABLE_SORTER_REFERENCES logic - a new assert() introduced 5 days ago by [87e2f5eb436fc448]. (check-in: 7cfc839e user: drh tags: trunk) | |
| 11:30 | Fix a use-after-free in fts3 that could follow an optimize() in the middle of a SELECT statement when the hash table is non-empty. (check-in: 8124b2ce user: dan tags: trunk) | |
| 02:26 | Fix another harmless compiler warning for MSVC. (check-in: b54c0db0 user: mistachkin tags: trunk) | |
| 02:17 | Fix harmless compiler warnings in the debug build for MSVC. (check-in: 1ceb73f3 user: mistachkin tags: trunk) | |
|
2021-10-11
| ||
| 15:54 | Fail a schema parse if a virtual table or view has a positive integer rootpage. (check-in: 02656760 user: drh tags: trunk) | |
| 15:21 | Use the IsOrdinaryTable() macro, not a test of tnum, to distinguish tables from views and virtual tables. (check-in: 6189b780 user: drh tags: trunk) | |
| 09:48 | New test cases added to test/fuzzdata8.db (check-in: 2e475fec user: drh tags: trunk) | |
| 09:39 | Fix an over-zealous assert(). (check-in: e2bb82a4 user: drh tags: trunk) | |
|
2021-10-09
| ||
| 16:00 | Detect any attempt to use an INDEXED BY clause on a CTE and report an error. (check-in: 35a9de2c user: drh tags: trunk) | |
|
2021-10-08
| ||
| 18:15 | Further to the previous check-in, remove the "harmless()" macro definition as it is no longer used. (check-in: b8c9a546 user: drh tags: trunk) | |
| 18:12 | Remove a "harmless()" macro that is no longer relevant. (check-in: 87c357c6 user: drh tags: trunk) | |
| 16:39 | Add support for "PRAGMA writable_schema=RESET". (check-in: a51b305b user: drh tags: trunk) | |
| 16:15 | Improved detection of database corruption. (check-in: c7fae46c user: drh tags: trunk) | |
| 10:25 | Minor improvements to comments in the data structure definitions. No changes to code. (check-in: e77ac405 user: drh tags: trunk) | |
|
2021-10-07
| ||
| 23:04 | New assert() statements to protect the u1 and u2 unions of SrcList. (check-in: 9b91fbcf user: drh tags: trunk) | |
| 20:46 | Protect access to the Expr.y union using nearby assert()s and branches. (check-in: 87e2f5eb user: drh tags: trunk) | |
| 19:27 | Break the tcl release tests into smaller units to better take advantage of multi-processor systems. (check-in: 03cef1c3 user: dan tags: trunk) | |
| 17:43 | Protect all accesses to the Expr.x union using nearby assert()s and branches. (check-in: 8eaa1d4a user: drh tags: trunk) | |
| 14:19 | Fix an incorrect assert() on PRAGMA table_xinfo added by the previous check-in. (check-in: f85cb287 user: drh tags: trunk) | |
| 13:40 | Protect all accesses to the FuncDef.u and Expr.u unions using nearby assert()s or branches. (check-in: 9af863f0 user: drh tags: trunk) | |
| 12:11 | Protect every access to the Table.u union using a nearby assert() or branch. (check-in: 50e08338 user: drh tags: trunk) | |
|
2021-10-06
| ||
| 10:36 | Fix a macro typo introduced by [5da112c02f9e8d0b] that prevented coverage tests from working. (check-in: 566e6974 user: drh tags: trunk) | |
| 10:04 | One corner case for the fix at [8b24c177061c3836] was not quite right. Caught overnight by both OSSFuzz and dbsqlfuzz and repaired here. (check-in: 79e90a82 user: drh tags: trunk) | |
|
2021-10-05
| ||
| 22:51 | Fix a harmless typo in a comment. forum post 218c116fdf. (check-in: 8ca0c7d8 user: drh tags: trunk) | |
| 18:59 | Fix harmless compiler warnings, mostly caused by prior efforts to get static analyzers to run without warnings. (check-in: cddd3b38 user: drh tags: trunk) | |
| 18:33 | Fix more harmless static-analyzer warnings. As of this check-in, no warnings are generated by scan-build for clang-6 or clang-10. (check-in: a7835bea user: drh tags: trunk) | |
| 17:41 | Fixes for harmless static-analyzer warnings. This also makes the code easier for humans to understand. (check-in: 36177a62 user: drh tags: trunk) | |
| 15:30 | Fix separate compilation of json1.c, which was apparently broken by check-in [32f33f356931242b]. (check-in: 0c7ece67 user: drh tags: trunk) | |
| 13:00 | Small change to FTS5 to help static analyzers understand that it is not dereferencing a NULL pointer. (check-in: 0d853df1 user: drh tags: trunk) | |
| 12:34 | Ensure that geopoly does not invoke sqlite3_result_error_nomem() with a NULL pointer. (check-in: 2483310d user: drh tags: trunk) | |
| 11:11 | Simplifications to the preupdate_hook logic to make it easier to reason about, and reduce static analyzer warnings. (check-in: 91e3b98e user: drh tags: trunk) | |
|
2021-10-04
| ||
| 22:34 | Fix harmless static-analyzer warnings. (check-in: 32f33f35 user: drh tags: trunk) | |
| 18:59 | Merge static-analyzer warning fixes and the new SQLITE_OMIT_AUXILIARY_SAFETY_CHECKS macro. (check-in: 5da112c0 user: drh tags: trunk) | |
| 18:57 | Some #defines somehow failed to get set correctly in the previous check-in. Fixed here. (Closed-Leaf check-in: 15bbdf9a user: drh tags: fix-warnings) | |
| 18:21 | Fix harmless static analyzer warnings in sessions, rtree, fts3 and fts5. Add the -DSQLITE_OMIT_AUXILIARY_SAFETY_CHECKS compile-time option to cause ALWAYS() and NEVER() macros to be omitted from the build. (check-in: 1c67f957 user: drh tags: fix-warnings) | |
| 16:14 | Fix harmless static analyzer warnings in auxiliary build tools, mkkeywordhash.c and lemon.c. No changes to the SQLite core. (check-in: f2f279b2 user: drh tags: trunk) | |
| 15:08 | Fix harmless static analyzer warnings. (check-in: 1ebcde72 user: drh tags: trunk) | |
| 13:30 | The pragma_table_list virtual table should have only one "schema" column. (check-in: 886feffa user: drh tags: trunk) | |
| 13:18 | Fix harmless static analyzer warnings. (check-in: 6604a085 user: drh tags: trunk) | |
| 11:10 | Fix query plans created by whereShortCut() so that they always check transitive constraints that drive an index. The is analogous to the [f1f9b5de3c59489b] check-in, just for whereShortCut() rather than the full query planner. Fix for the issue described by forum post a65cacbf5e1c41ba. (check-in: 8b24c177 user: drh tags: trunk) | |
|
2021-10-03
| ||
| 22:03 | In CLI, ensure correct line-accumulation state whenever line(s) are dumped or processed. And test this. (check-in: be211a9c user: larrybr tags: trunk) | |
| 00:12 | Add the sqlite3ResultStrAccum() internal interface to simplify the the implementation of functions that return strings. (check-in: e548e929 user: drh tags: trunk) | |
|
2021-10-02
| ||
| 18:22 | Try to fix a harmless static-analyzer warning in sqlite3BtreeTransferRow(). (check-in: 5906a015 user: drh tags: trunk) | |
| 17:46 | Fix a harmless static-analyzer warning in sqlite3ExprCode(). (check-in: 918c22e8 user: drh tags: trunk) | |
| 17:34 | Remove an unnecessary static buffer from sqlite3VdbeExpandSql(). (check-in: 953a33b7 user: drh tags: trunk) | |
| 17:12 | Make the sqlite3_filename_xxxx() interfaces robust against NULL pointer arguments, even though the documentation says the behavior is undefined in that case. (check-in: dd64c60b user: drh tags: trunk) | |
| 16:39 | Fix harmless compiler warnings (check-in: bdb9dc8a user: drh tags: trunk) | |
| 15:34 | Fix CLI line processing. (back to start state after meta-command executes) (check-in: 928c2a34 user: larrybr tags: trunk) | |
|
2021-10-01
| ||
| 22:48 | Fix a problem with group_concat() when it is used as a window function with a sliding window, as described by forum thread ccf3b5673ba852cf. (check-in: f47f7f78 user: drh tags: trunk) | |
| 21:01 | Fix harmless compiler warnings. (check-in: 94b59691 user: drh tags: trunk) | |
| 20:39 | Change things so that SQLITE_OMIT_VIRTUALTABLE implies SQLITE_OMIT_ALTER_TABLE. (check-in: 2f7c946c user: dan tags: trunk) | |
| 17:06 | Fix a potential write outside of array bounds in the --hexdb decoder of the CLI when given corrupt input. (check-in: c7fdd775 user: drh tags: trunk) | |
| 15:05 | Fix a buffer overread in fts5 that could occur when processing an "ORDER BY rowid DESC" query against corrupt database records. (check-in: fe098a93 user: dan tags: trunk) | |
| 02:45 | Remove unreachable branches in the fixed group_concat() code. (Closed-Leaf check-in: 8bd721c2 user: drh tags: group_concat-fix-legacy) | |
| 02:16 | Merge updates from trunk (check-in: 35351371 user: drh tags: group_concat-fix-legacy) | |
| 00:25 | Fixes to the version of "varsep" group_concat so that (1) it builds under separate compilation and (2) omits tabs in source code and (3) runs faster than trunk. This variant of the group_concat_varsep branch might be preferred over the tip because it preserves (undocumented) legacy behavior about the position of separators relative to terms. (check-in: 04399cf9 user: drh tags: group_concat-fix-legacy) | |
|
2021-09-30
| ||
| 18:42 | Fix a problem with view handling in SQLITE_OMIT_VIRTUAL_TABLE builds. (check-in: 6e791a24 user: dan tags: trunk) | |
| 17:39 | Fix rtreedoc.test so that it works with SQLITE_DEFAULT_AUTOVACUUM=1 builds. (check-in: a300adc2 user: dan tags: trunk) | |
| 10:47 | Update a test case in rtreedoc.test to account for the fact that release builds generate fewer VM instructions than debug builds. (check-in: 7d16b302 user: dan tags: trunk) | |
|
2021-09-29
| ||
| 20:17 | Add NEVER() macros on branches that are not reachable since [a0df216f7c3f8963]. (check-in: 5d771f35 user: drh tags: trunk) | |
| 19:18 | Fix a typo in altertab3.test. (check-in: 18d38b13 user: dan tags: trunk) | |
| 19:15 | Have the dbstat module arrange things internally so that there are 256 addressable bytes following each page buffer. This way, small buffer overreads caused by corrupt database pages do not lead to undefined behaviour. (check-in: c4c705ab user: dan tags: trunk) | |
| 18:33 | Fix another problem with ALTER TABLE and vector UPDATE statements within triggers. (check-in: a0df216f user: dan tags: trunk) | |
| 16:38 | Add new test file rtreedoc3.test. (check-in: 54604869 user: dan tags: trunk) | |
| 16:35 | Sync w/trunk (check-in: a4c18b2f user: larrybr tags: group_concat_varsep) | |
| 14:14 | Add extra tests for the group_concat() fix on this branch. (check-in: 3d148615 user: dan tags: group_concat_varsep) | |
| 14:01 | Improved testability of changes from check-in [255b0eeed113d83b]. (check-in: bbfd083c user: drh tags: trunk) | |
| 13:36 | Fix an out-of-bounds read in fts5 that could occur when processing corrupt records. (check-in: 9bbc01fb user: dan tags: trunk) | |
| 00:32 | Get group_concat() to handle varying separator lengths when windowing (check-in: 98e0f2bf user: larrybr tags: group_concat_varsep) | |
|
2021-09-28
| ||
| 10:44 | Fix a potential ALTER TABLE problem with expressions like ( (<sub-select>) IN () ). (check-in: df0d7e36 user: dan tags: trunk) | |
|
2021-09-27
| ||
| 17:11 | Have the dbstat virtual table take a copy of each page buffer that it traverses instead of just a reference to the page-cache object. This avoids problems if an error causes transaction rollback while a dbstat cursor is open. dbsqlfuzz crash-417224040fee04f0f0e62b70265c518893b08769. (check-in: 6ab25f8b user: dan tags: trunk) | |
| 15:44 | Fix a problem in ALTER TABLE causing table or column references in sub-selects ton the RHS of a vector SET clause in an UPDATE within a trigger (i.e. "SET (a,b) = ( (SELECT...), <expr> )"). (check-in: 255b0eee user: dan tags: trunk) | |
|
2021-09-25
| ||
| 20:28 | Load recent dbsqlfuzz cases into test/fuzzdata8.db. (check-in: 7a8fcf6d user: drh tags: trunk) | |
| 20:19 | Fix a memory leak in rtree triggered by corrupt database records. dbsqlfuzz 397ad036a9013d7318da30ef84947d2baaaa6d6c. (check-in: 706322c2 user: dan tags: trunk) | |
| 18:21 | Fix a bad interaction between the pager cache and the dbstat module that could lead to a malfunction following an OOM. dbsqlfuzz 9ed3e4e3816219d3509d711636c38542bf3f40b1. (check-in: e03554a6 user: dan tags: trunk) | |
| 17:07 | Add const to parameters on various internal interfaces. (check-in: 70c221c5 user: drh tags: trunk) | |
|
2021-09-24
| ||
| 19:57 | Dbsqlfuzz (a097eaad43c3c845b236126df92fb49b25449b0c) found a way to reach the assert() that was added to sqlite3_declare_vtab() by [eb94f4a8174436b1]. This check-in fixes the problem. (check-in: 857d26a6 user: drh tags: trunk) | |
| 16:14 | Add lots of new "const" on internal function parameters. There is opportunity for many more - this is a work in progress. (check-in: a3c71a67 user: drh tags: trunk) | |
| 12:59 | Ensure that sqlite_stat1 and sqlite_stat4 are ordinary tables (not views or virtual tables) before trying to load them (dbsqlfuzz bc02a0cde82dee801a8d6f653d2831680f87dca1). This prevents sqlite3_declare_vtab() from running with db->init.busy turned on. Even so, enhance sqlite3_declare_vtab() to be able to deal with db->init.busy being on, in case there are undiscovered paths to that state. Each of these two changes are independently sufficient to prevent the problem fixed by the previous check-in [c7560c1329965ab5] but there is no harm in keeping that third layer of protection in place. (check-in: eb94f4a8 user: drh tags: trunk) | |
| 02:14 | Ensure that the db->init.azInit array is initialized at all times. dbsqlfuzz 0ad6d441f9bf3dfc32626a9900bc1700495b16f9 (check-in: c7560c13 user: drh tags: trunk) | |
|
2021-09-22
| ||
| 14:43 | Fix harmless compiler warnings. (check-in: d678ecca user: drh tags: trunk) | |
| 14:26 | For shell.c.in, define CHAR_BITS to 8 on platforms that do not have that value set by default. This fixes the build on older machines. (check-in: 96610cc8 user: drh tags: trunk) | |
| 13:43 | Fix harmless compiler warnings in shell.c.in, and a compiler warning in sqlite3expert.c which is a real error, though also harmless. (check-in: 56da0e9c user: drh tags: trunk) | |
| 13:07 | Fix an incorrect assert() in rtree that was added recently by [f7ad73c49507c943]. Change it to testcase(). (check-in: 3aa0bf3a user: drh tags: trunk) | |
| 10:57 | Enhance the TCL-based test harness so that it is possible to list multiple test modules on the "testfixture" command-line and have them all run. For example: "./testfixture test/shell*.test" (check-in: 45caf9b8 user: drh tags: trunk) | |
| 10:28 | Use sqlite3_snprintf() for the ".changes" output formatting in the shell because it now uses %lld, and some older C compilers do not understand that construct. (check-in: 53dadf80 user: drh tags: trunk) | |
|
2021-09-21
| ||
| 20:03 | Fix .expert name collision bug reported at https://sqlite.org/forum/forumpost/05e6f32984561f57?t=h (check-in: 4a3f98ad user: larrybr tags: trunk) | |
| 19:19 | Speed and (slightly) simplify shell's input line early processing. (check-in: a1c7f7f8 user: larrybr tags: trunk) | |
| 17:26 | Add the "PRAGMA table_list" command with its corresponding eponymous table-valued function: "pragma_table_list". (check-in: 2c0e7ae5 user: drh tags: trunk) | |
|
2021-09-20
| ||
| 21:42 | Accomplish fileio standalone for Win32 with less intervention. (check-in: af5dcc9c user: larrybr tags: trunk) | |
| 20:15 | Allow fileio extension to be a stand-alone DLL for Win32 (check-in: d1cc3105 user: larrybr tags: trunk) | |
|
2021-09-19
| ||
| 18:31 | Adjust shell tests for *Nix and Windows test platform anomaly (Leaf check-in: 577544c5 user: larrybr tags: speedy_cli) | |
|
2021-09-18
| ||
| 21:35 | Sync w/trunk, further streamline shell's resumable prescan. (check-in: 9e00f9f7 user: larrybr tags: speedy_cli) | |
| 16:15 | Further tests for legacy rtree geom callbacks. (check-in: 99d6bb22 user: dan tags: trunk) | |
|
2021-09-17
| ||
| 21:12 | Shell's .read pipe now works for Windows too. (check-in: 929bcc40 user: larrybr tags: trunk) | |
| 20:43 | Add tests for legacy geometry callbacks to rtreedoc2.test. (check-in: 6ad00e52 user: dan tags: trunk) | |
| 13:07 | Make the affinity() function available even if compiled without SQLITE_DEBUG. Surround the implementation of all test-only SQL functions with #ifndef SQLITE_UNTESTABLE. (check-in: b7e00ef8 user: drh tags: trunk) | |
|
2021-09-16
| ||
| 22:23 | The dbsqlfuzz fuzzer found a refutation for a recent ALWAYS() macro. (check-in: ebfc18aa user: drh tags: trunk) | |
| 20:16 | Minor changes to rtree.c so that we can get full branch coverage even when it is compiled without geopoly. (check-in: f05ae9b5 user: drh tags: trunk) | |
| 19:50 | Add tests to rtreedoc.test. (check-in: b18c6ec4 user: dan tags: trunk) | |
| 17:02 | Add a single new ALWAYS() to rtree.c, with justification. (check-in: 778e4499 user: drh tags: trunk) | |
| 16:41 | Add a tag comment in rtree.c. No changes to code. (check-in: 213410fa user: drh tags: trunk) | |
| 14:17 | Add a reference counter to a structure used internally by the Tcl interface so that it does not segfault if the database connection is closed from any of the various callback scripts that may be invoked. (check-in: e54a33ce user: dan tags: trunk) | |
| 14:07 | Mark an unreachable branch in rtree. (check-in: e6c4afd5 user: drh tags: trunk) | |
| 13:52 | Back out a couple of ALWAYS() macros from [4fab9089868bbb05]. Test case added to TH3. (check-in: d26963a5 user: drh tags: trunk) | |
| 13:20 | For ALTER TABLE RENAME COLUMN, do not try to filter virtual tables out of calls to sqlite_rename_column(). Let the function filter them itself. The WHERE clause can mistakenly let virtual tables through if the sqlite_schema table is corrupt. The sqlite_rename_column() function must deal with them. We might as well let it deal with them always. (check-in: 7c82b43b user: drh tags: trunk) | |
| 12:33 | Under SQLITE_DEBUG with PRAGMA vdbe_trace=ON, show an output line if the VDBE aborts for any reason. (check-in: 7e3d6810 user: drh tags: trunk) | |
| 07:32 | Simplify the routine that attempts to estimate the size of an rtree index by looking at the sqlite_stat1 entry for the %_rowid table. (check-in: 06c329c1 user: drh tags: trunk) | |
| 05:39 | Mark various unreachable branches in rtree.c with ALWAYS() or NEVER(). (check-in: 4fab9089 user: drh tags: trunk) | |
| 05:24 | New ALWAYS() and assert() to mark unreachable branches in rtree.c. (Closed-Leaf check-in: f7ad73c4 user: drh tags: tree-testing) | |
|
2021-09-15
| ||
| 19:53 | In rtree.c, remove an incorrect ALWAYS(). Add other ALWAYS() and NEVER(). (check-in: cbaac887 user: drh tags: tree-testing) | |
| 19:13 | Add more ALWAYS() macros on unreachable branches in rtree.c (check-in: fbba89da user: drh tags: tree-testing) | |
| 16:20 | Fix the xBestIndex method on rtree so that it correctly recognizes that rowid=? works the same as id=?. (check-in: c74c07cc user: drh tags: trunk) | |
| 15:56 | Add ALWAYS() macros on some unreachable branches in rtree. (check-in: 9123f680 user: drh tags: trunk) | |
| 15:53 | Further updates to rtreedoc.test. (check-in: e6672783 user: dan tags: trunk) | |
| 14:48 | Fix non-build for a test configuration (check-in: c9a4ab05 user: larrybr tags: trunk) | |
| 13:09 | Simplify some of the corrupt shadow-table detection logic in rtree. (check-in: 0c4f37aa user: drh tags: trunk) | |
| 11:15 | Squelch needless narrowing warning. (check-in: 5540e6ab user: larrybr tags: trunk) | |
| 10:49 | Ensure rtreedoc.test is not run for builds without the rtree extension. (check-in: 42dff223 user: dan tags: trunk) | |
|
2021-09-14
| ||
| 20:07 | Add test cases to rtreedoc.test. (check-in: afe0ec4d user: dan tags: trunk) | |
| 18:57 | Update requirements marks to reflect recent documentation changes. (check-in: 08cab892 user: drh tags: trunk) | |
| 14:16 | Add test cases to rtreedoc.test. (check-in: b62de126 user: dan tags: trunk) | |
| 11:27 | Minor updates to rtreedoc.test. (check-in: b22c75e4 user: dan tags: trunk) | |
|
2021-09-13
| ||
| 23:11 | Shell to .read any named character source file/device (again.) (check-in: c6fe4f8d user: larrybr tags: trunk) | |
| 18:32 | Add test cases to rtreedoc.test. (check-in: 4ee99d31 user: dan tags: trunk) | |
| 18:16 | Add assert() statements to refute forum post 9f4e7f58fbb66ddd. (check-in: 83a83475 user: drh tags: trunk) | |
| 16:36 | Add new test file rtreedoc.test. (check-in: 8c4b1482 user: dan tags: trunk) | |
| 13:53 | Fix an incorrect comment and possible integer overflow in pager resulting from check-in [23ca23894af352ea]. Problem reported by forum post e2ea1a3f61. Also change the datatype of Pager.pageSize to i64 even though page size never exceeds 65536, in order to help prevent future problems of this kind. (check-in: f4a552ed user: drh tags: trunk) | |
|
2021-09-11
| ||
| 02:42 | CLI prescanner made to match SQLite's rules for delimited identifiers. Tests begun. (check-in: 15b105c5 user: larrybr tags: speedy_cli) | |
|
2021-09-10
| ||
| 22:00 | Make replace.tcl useful with TCL 8.4 (check-in: 2dd61dd9 user: larrybr tags: trunk) | |
| 19:45 | Make CLI prescan handle goofy identifier delimiters too. Streamline code. (check-in: 968aed69 user: larrybr tags: speedy_cli) | |
| 18:35 | Fix (luckily harmless) typo in memdb.c per https://sqlite.org/forum/forumpost/15af8872d5999df1 (check-in: d577030c user: larrybr tags: trunk) | |
| 01:45 | When showHeader set at CLI invocation, do not auto-set it later. (check-in: 733b7d4f user: larrybr tags: trunk) | |
| 01:02 | Back out changes [00286ca5d998d802] and [6844ede29e1dac93] (replacing the associated branches with NEVER()) and add a single new test to btreeOverwriteCell() that detects when an overflow pages is also mapped into a b-tree page and raises and immediate SQLITE_CORRUPT error before making any changes. dbsqlfuzz 81791bd980fe6935ff2c7334ec8bef11c1c12b82 and others. (check-in: 32210fa4 user: drh tags: trunk) | |
| 00:58 | Speed-up CLI's processing for huge block comments, for any content (check-in: c4568f9f user: larrybr tags: speedy_cli) | |
|
2021-09-09
| ||
| 19:19 | Remove a NEVER() in btree that is sometimes reachable. dbsqlfuzz b9140023005430654c8fe544cf0a082ef8d561c1. (check-in: 6844ede2 user: drh tags: trunk) | |
| 18:06 | Avoid masking off an OOM fault in rtreecheck(). (check-in: 3ebfe712 user: drh tags: trunk) | |
| 14:03 | Improved database corruption detection in the editPage() subroutine of the btree rebalancer. dbsqlfuzz f035b1b5a100a5f0cffb95c958b6c67d7c5eaf1f. (check-in: 00286ca5 user: drh tags: trunk) | |
|
2021-09-08
| ||
| 21:49 | Speedup CLI's gulping of many huge block SQL comments. (check-in: 729620c5 user: larrybr tags: trunk) | |
| 19:25 | Fix PRAGMA integrity_check so that it does not try to enforce types on ANY columns in a STRICT table. (check-in: 57384fda user: drh tags: trunk) | |
|
2021-09-07
| ||
| 20:58 | For sqldiff, sqlite_schema comparisons must use compound (synthesized) PK. (check-in: 5bdd8466 user: larrybr tags: trunk) | |
| 19:23 | New test cases added to fuzzdata8.db. No code changes. (check-in: 51e5aada user: drh tags: trunk) | |
| 19:04 | Make sqldiff able to compare sqlite_schema tables (for detailed schema differences.) (check-in: 7ff92da9 user: larrybr tags: trunk) | |
| 16:05 | Fix a memory leak in fts5 that could occur when writing to an fts5 table that is being scanned by an fts5vocab cursor. (check-in: 1183552d user: dan tags: trunk) | |
| 15:41 | Fix a potential NULL pointer deference in the LIKE optimization. The problem was introduced by the addition of generated columns in check-in [b855acf1831943b3] (SQLite version 3.31.0, 2020-01-22). Reported by Wang Ke in [forum/forumpost/699b44b3ee|forum post 699b44b3ee]. (check-in: b9417d40 user: drh tags: trunk) | |
|
2021-09-06
| ||
| 16:15 | Fix a use-after-free error that could occur if an fts5 table is written while scanning it using an fts5vocab cursor. (check-in: e751c2ec user: dan tags: trunk) | |
| 15:59 | Fix an issue in the "shrink.test" test script reported by forum post 90a74bd618. (check-in: 6c3734ed user: drh tags: trunk) | |
| 11:44 | Restore the use of system isnan() that was removed by check-in [ea748edecb261f2b]. See forum thread d7c530ac587f59e6. (check-in: b3cfe23b user: drh tags: trunk) | |
|
2021-09-03
| ||
| 18:11 | Fix an assertion fault in pcache introduced by [4bc93658aa563f2f] and detected by OSSFuzz. Test case in TH3. (check-in: 2262a494 user: drh tags: trunk) | |
|
2021-08-31
| ||
| 15:53 | Have the planner ensure that if one scan uses a subset of the WHERE clause of another, that scan is estimated to cost less and return fewer rows. (check-in: c7b34930 user: dan tags: trunk) | |
|
2021-08-30
| ||
| 17:02 | Do not disable a rowid=? term used to drive an IPK index if it is a transitive constraint. Commit [f1f9b5de] made the same change for non-IPK indexes. (check-in: 46e28cbc user: dan tags: trunk) | |
|
2021-08-27
| ||
| 11:26 | Patch lemon to fix "error" token handling, according ot forum post e680f42f53090061. (check-in: 106b5e53 user: drh tags: trunk) | |
|
2021-08-26
| ||
| 18:31 | Add the --safe to the CLI. Also the --nonce option and the .nonce command. (check-in: c76870cb user: drh tags: trunk) | |
|
2021-08-24
| ||
| 17:07 | Correctly preserve the collating sequence for a column when changing its datatype. Fix for the problem reported by forum post 36be3d3a08da9d92. Test cases in TH3. (check-in: c7f0813c user: drh tags: trunk) | |
|
2021-08-23
| ||
| 15:56 | Fix a typo in a comment. No changes to code. (check-in: d953646a user: drh tags: trunk) | |
| 10:28 | Back out the change that allows typeless columns in strict tables. Replace that capability with an ANY type for strict tables that will accept any datatype with BLOB affinity. (check-in: d8fd1a2b user: drh tags: trunk) | |
|
2021-08-21
| ||
| 20:54 | Allow typeless columns in STRICT tables that are able to accept any data type. (check-in: 1e2dcc2d user: drh tags: trunk) | |
| 16:42 | Defer deleting subqueries in the compound-SELECT code generator until the end of code generation, in order to avoid deleting expressions out from under the aggregation function sanity checking assert()s that occur near the end of SELECT code generation. This fixes the assertion fault described by forum post cfcb4b461d. The problem goes back to check-in [6e6b3729e0549de0]. (check-in: 600f1991 user: drh tags: trunk) | |
|
2021-08-20
| ||
| 19:51 | Improvement to error handling in Lemon. No impact on SQLite. Forum post 2f468f43cbc48d7f (check-in: 18cc2f85 user: drh tags: trunk) | |
| 15:44 | Support for STRICT tables. A table with the STRICT option only allows a few core datatypes on columns and enforces those types rigidly. Also, PRIMARY KEY columns must be NOT NULL. (check-in: f9c1d344 user: drh tags: trunk) | |
| 08:05 | Improved error messages for the SQLITE_CONSTRAINT_DATATYPE error. (Closed-Leaf check-in: 39abca01 user: drh tags: strict-tables) | |
| 01:12 | Do not allow the xfer-optimization to move the content of an ordinary table into a strict table. (check-in: 1ed1b594 user: drh tags: strict-tables) | |
|
2021-08-19
| ||
| 16:29 | Improved comments. Fewer opcodes for integrity_check on strict tables. (check-in: 4ee57fb5 user: drh tags: strict-tables) | |
| 02:58 | Enhance PRAGMA integrity_check so that it verifies the datatype of all columns in STRICT tables. (check-in: 97c9248b user: drh tags: strict-tables) | |
| 00:24 | STRICT tables require all fields of the PRIMARY KEY to be NOT NULL. (check-in: 5efdf9ac user: drh tags: strict-tables) | |
|
2021-08-18
| ||
| 23:00 | Merge the WITHOUT ROWID, NOT NULL ON CONFLICT bug fix into the strict-tables branch. (check-in: 7ee01ee4 user: drh tags: strict-tables) | |
| 22:26 | Fix ON CONFLICT clause processing for NOT NULL constraints of PRIMARY KEY columns on WITHOUT ROWID tables. Ticket [f2be158c57aaa8c6] (check-in: 13abba09 user: drh tags: trunk) | |
| 19:22 | Trying to insert an incorrect datatype into a STRICT table raises an SQLITE_CONSTRAINT_DATATYPE error. Seems to work, though lots more testing is needed. (check-in: a19305e5 user: drh tags: strict-tables) | |
| 13:13 | What would it be like if you could add the keyword "STRICT" after a CREATE TABLE statement to cause the table to (1) allow only a few well-defined datatypes, (2) rigidly enforce those types, (3) require NOT NULL on PK columns, (4) always enforce foreign key constraint, and so forth? This branch seeks to explore that question. (check-in: 78732b9f user: drh tags: strict-tables) | |
| 12:05 | Rename the Column.eType field to Column.eCType - with an extra "C". (check-in: b9b0dcd5 user: drh tags: trunk) | |
|
2021-08-17
| ||
| 19:59 | Fix an off-by-one error in the error-handling logic of the Lemon parser-generator. This does not affect SQLite. Forum cff80737bf. (check-in: 7cca8080 user: drh tags: trunk) | |
|
2021-08-12
| ||
| 14:22 | By default, do not use memory mapping to access the temporary files used for external sorts. The old behaviour (to use memory mapping by default) may be restored by building with SQLITE_ENABLE_SORTER_MMAP defined. (check-in: 306694df user: dan tags: trunk) | |
|
2021-08-11
| ||
| 18:43 | During DELETE, if an index entry is missing, do not raise the SQLITE_CORRUPT_INDEX error (added by [f339f31f9e9a856b]) if in "PRAGMA writable_schema=ON" mode. (check-in: 19e56291 user: drh tags: trunk) | |
| 13:48 | Do not apply the push-down optimization to CTE subqueries that will be reused in other contexts in where the same optimization is unlikely to be valid. Fix for the bug reported by forum post d496c3d29bc93736. (check-in: a7ce29a6 user: drh tags: trunk) | |
| 13:19 | Improved comment on the OP_OpenDup used to get a new cursor for a reused materialized CTE. (check-in: b1926cc0 user: drh tags: trunk) | |
|
2021-08-09
| ||
| 19:54 | Fix a compiler warning in pcache1. Reduce the maximum size of a pcache1 cache to 2147418112 pages. (check-in: 4bc93658 user: drh tags: trunk) | |
| 18:13 | Further improvements to the eOpenState bit values. (check-in: d44f74f1 user: mistachkin tags: trunk) | |
| 18:07 | Ensure that the pcache1 cache size does not get so big that it overflows the integer that is keeping track of the cache size. (check-in: bf9d70fc user: drh tags: trunk) | |
| 17:45 | Fix harmless compiler warnings and improve the presentation for the new --threadsafe option to the CLI. (check-in: 7929dc2f user: drh tags: trunk) | |
| 17:37 | Undocumented "--threadsafe N" option added to the CLI for testing purposes. One of SQLITE_CONFIG_SINGLETHREAD, _MULTITHREAD, or _SERIALIZED is called depending on the value of the N integer. (check-in: 2d8f297c user: drh tags: trunk) | |
| 17:36 | Improved Hamming bit-distance between the SQLITE_STATE constants. (check-in: 5100b045 user: drh tags: trunk) | |
| 13:06 | Fix comments associated with sqlite3.eOpenState. No logic changes. (check-in: fd8f498f user: drh tags: trunk) | |
|
2021-08-07
| ||
| 23:16 | Refactor sqlite3.magic into sqlite3.eOpenState. (check-in: e5d6512a user: drh tags: trunk) | |
|
2021-08-06
| ||
| 20:17 | Fix an RBU problem with restarting an update after the *-oal file is already larger than 4GiB. (check-in: 087b8b41 user: dan tags: trunk) | |
| 19:38 | Attempt to fix the showwal.c utility program so that it works on WAL files larger than 4GiB. (check-in: 5c0f9ea9 user: drh tags: trunk) | |
| 15:26 | Fix harmless compiler warnings. Omit redundant copies of os_common.h and hwtime.h from the amalgamation. (check-in: 09142700 user: drh tags: trunk) | |
|
2021-08-05
| ||
| 15:27 | Store the collating sequence name for each column of a table as an extension to the column name, for an additional savings in the heap space needed to hold the schema. (check-in: 832ac4c1 user: drh tags: trunk) | |
|
2021-08-04
| ||
| 14:50 | Add NEVER() macros on recently introduced unreachable branches. (check-in: 806939eb user: drh tags: trunk) | |
| 13:42 | Always prefer built-in SQL functions over app-defined SQL functions within sqlite3NestedParse(). Formerly this was the case for a few calls to sqlite3NestedParse(), but not for all of them. (check-in: 164662ef user: drh tags: trunk) | |
| 11:29 | Avoid using LIKE with the target db in RBU. It is possible the user may issue "PRAGMA case_sensitive_like = 1" or override the like() user function, causing RBU to malfunction. (check-in: 7cbd8cd5 user: dan tags: trunk) | |
|
2021-08-03
| ||
| 23:23 | Fix the build for SQLITE_ENABLE_UPDATE_DELETE_LIMIT. (check-in: 5150d2da user: drh tags: trunk) | |
| 18:45 | Improved harmony with the reuse-schema branch. (check-in: cbc703f7 user: drh tags: trunk) | |
|
2021-08-02
| ||
| 18:03 | Refactor field names in the Column object, zCnName and zCnColl, to make them unique and thus easier to find amid all the other code. (check-in: 8b781dca user: drh tags: trunk) | |
| 16:41 | Refactor the Table object to reduce its memory footprint. (check-in: bbb6759b user: drh tags: trunk) | |
|
2021-07-31
| ||
| 20:30 | Refactor the way that DEFAULT expressions are stored on columns, in order to save memory in the common case where the column has no DEFAULT clause. (check-in: 8646547e user: drh tags: trunk) | |
|
2021-07-30
| ||
| 23:30 | Recognize certain standard datatypes ("INT", "INTEGER", "REAL", "TEXT", and "BLOB") and if a column has one of those datatypes, store the type part of the bit-field information in the Column structure to save space. (check-in: d2da62a9 user: drh tags: trunk) | |
| 20:09 | If a generated column uses the optional keywords GENERATE ALWAYS, try to avoid putting those keywords in the typename of the column. Forum post ff3ffe09251c105b (check-in: 3c954863 user: drh tags: trunk) | |
| 18:39 | Avoid clownfeet in the names columns when the column names are quoted in the original CREATE TABLE statement. (check-in: 980f7292 user: drh tags: trunk) | |
| 12:47 | Reduce clownfooting in the allocation of the Table.aCol array. This reduces the amount of heap space required to hold large schemas by about 11%. (check-in: 2941ded0 user: drh tags: trunk) | |
|
2021-07-29
| ||
| 18:34 | Enhance the wal.c source file with an ASCII-art schematic of the -shm file header. (check-in: a6c160e0 user: drh tags: trunk) | |
| 17:31 | Improvements to asserts to enforce magic numbers in the wal-index format. Also improve automatic configure and make builds on legacy PPC iBooks. (check-in: 87b8d478 user: drh tags: trunk) | |
| 17:23 | Complete warning-free build on old PPC iBook. (Closed-Leaf check-in: ef2a0850 user: drh tags: wal-asserts) | |
| 17:01 | Fix an error in one of the assert() statements added by [23b08fe9db24a953]. (check-in: ad24334b user: drh tags: wal-asserts) | |
| 16:49 | Minor tweaks to various TCL build scripts so that they work even for TCL 8.4, which is obsolete, but is also all that is available for some legacy platforms. (check-in: 2269ce64 user: drh tags: wal-asserts) | |
| 16:48 | Improve comments and add new assert() statements in WAL to help document how everything works. (check-in: 23b08fe9 user: drh tags: wal-asserts) | |
| 00:33 | Remove ALWAYS() macros that can be true if the internal test function implies_nonnull_row() is used in the result set of a query and contains comparison operator against a computed column. dbsqlfuzz 4c34db5bff6247f33ee49e341a1f3018e72be0a0. (check-in: 4d1dbfa3 user: drh tags: trunk) | |
|
2021-07-28
| ||
| 18:13 | Add test case to ensure that sessions works with DELETE statements that use the truncate optimization (i.e. a DELETE without a WHERE clause). (check-in: a2fc5311 user: dan tags: trunk) | |
| 02:04 | Fix a harmless uninitialized variable read that occurs after an error associated with a subquery that uses DISTINCT. Found by a fuzzer. (check-in: e9719f97 user: drh tags: trunk) | |
| 01:22 | Reduce the scope of a variable in order to fix a harmless compiler warning that occurs under -DSQLITE_OMIT_AUTOMATIC_INDEX. (check-in: 36d5dbbe user: drh tags: trunk) | |
|
2021-07-26
| ||
| 19:49 | Remove sqldiff --visible-controls option, make it always happen. Add test cases for controls made visible (check-in: ff74c0cc user: larrybr tags: trunk) | |
| 18:28 | Give sqldiff --visible-controls option to deal with non-graphic text content robustly across platforms (check-in: 68d2373f user: larrybr tags: trunk) | |
|
2021-07-23
| ||
| 18:43 | Enhance the CLI with the ".connection" command that can switch between up to five different database connections. Used for manual testing of multiple database connections in the same process. (check-in: 54eaf076 user: drh tags: trunk) | |
|
2021-07-22
| ||
| 21:11 | Set the checkSchema flag if a CREATE TABLE parse fails because the table already exists, to ensure that the table was not previously deleted by some other connection. (check-in: 91bcb962 user: drh tags: trunk) | |
| 18:22 | Fix ALTER TABLE DROP COLUMN so that it generates valid bytecode even when operating on a corrupt database and using PRAGMA writable_schema=ON. dbsqlfuzz 5f09e7bcc78b4954d06bf9f2400d7715f48d1fef (check-in: b65f4f76 user: drh tags: trunk) | |
| 16:07 | One of the optimizations of check-in [de9c86c9e4cdb34f] does not work for terms originating in the ON/USING clause, as demonstrated by forum post 6cf3bb457c3f4685. This check-in disables that optimization for ON/USING terms. Also improve the TreeView display for the resulting "true"/"false" nodes to show that they originate from the ON/USING clause. Add a testcase() to the other optimization to show that it can still be used for ON/USING terms. (check-in: 1f679604 user: drh tags: trunk) | |
|
2021-07-21
| ||
| 15:42 | Improved robustness of cursor renumbering in the UNION ALL flattener when operating on vector assignments of an UPDATE FROM. dbsqlfuzz 417d2b053b9b3c9edaf22dd515564f06999e029c (check-in: 60695359 user: drh tags: trunk) | |
|
2021-07-20
| ||
| 16:07 | Run a "PRAGMA quick_check", if necessary, on the modified table after an ALTER TABLE ADD COLUMN to verify that added NOT NULL or CHECK constraints are satisfied by existing rows. Abort the ADD COLUMN if not. Forum post c04814903d6ec4f7. (check-in: e3794997 user: drh tags: trunk) | |
| 14:57 | Avoid a malfunction that could occur if the same correlated column reference appears in both the GROUP BY and the HAVING clause of a sub-select. dbsqlfuzz a779227f721a834df95f4f42d0c31550a1f8b8a2. (check-in: 1e35cc6d user: dan tags: trunk) | |
| 08:23 | Fix issues in the new ADD COLUMN constraint checking. Add preliminary test cases. (Closed-Leaf check-in: 48434ad3 user: drh tags: add-column-constraint-check) | |
| 07:35 | Demonstration code to show how NOT NULL and CHECK constraints can be verified after an ALTER TABLE ADD COLUMN. (check-in: 039f5403 user: drh tags: add-column-constraint-check) | |
| 02:02 | It does not work to deserialized into TEMP, so do not allow it. The sqlite3_deserialize() routine now returns SQLITE_ERROR if you try. (check-in: 18068cc6 user: drh tags: trunk) | |
| 00:18 | Fix compilation of 'threadtest3' for some older versions of MSVC. (check-in: b5ede6a6 user: mistachkin tags: trunk) | |
|
2021-07-19
| ||
| 20:52 | More precision in comparing integers and floating point values while processing the integer primary key for OP_SeekGE and similar. Forum post 2bdb86a068. (check-in: f9c6426d user: drh tags: trunk) | |
| 16:49 | Updates so that "threadtest3[.exe]" can be built for windows with MSVC. (check-in: 4ce585fb user: dan tags: trunk) | |
| 14:00 | In defensive mode, allow statements that write to shadow tables to be prepared from with virtual-table xSync() calls. (check-in: c8601d83 user: dan tags: trunk) | |
| 03:38 | Fix minor spacing issues in the MSVC makefile. (check-in: d78c272b user: mistachkin tags: trunk) | |
|
2021-07-16
| ||
| 22:43 | Try to omit the ORDER BY clause in subqueries if doing so does not change the result in any way. See Forum post 2d76f2bcf65d256a for details and history. (check-in: 85ddaf1b user: drh tags: trunk) | |
| 20:16 | Minor comment improvements. (Closed-Leaf check-in: 6854b591 user: drh tags: omit-subquery-order-by) | |
| 17:11 | De-typo sqlite3_expanded_sql() doc (check-in: 56b0f541 user: larrybr tags: trunk) | |
| 17:04 | Modify the generate_series() table-valued functions so that its first argument (the START value) is required. Throw an error if that argument is not supplied. In this was the series.c loadable extension can be used as a demonstration of how to code an xBestIndex function to require certain parameters. Compile with -DZERO_ARGUMENT_GENERATE_SERIES to obtain the legacy behavior. (check-in: 459d85a2 user: drh tags: trunk) | |
| 15:30 | Fix the "main.mk" makefile so that "series.c" is a dependency of "shell.c". (check-in: ff959917 user: drh tags: trunk) | |
| 01:19 | Get the "omit ORDER BY in FROM-clause subqueries" optimization working for the core test cases. (check-in: e31c5888 user: drh tags: omit-subquery-order-by) | |
|
2021-07-15
| ||
| 23:34 | By default, do not emit #line directives in the amalgamation. (check-in: bacfa936 user: mistachkin tags: trunk) | |
| 19:29 | Attempt to omit ORDER BY clauses from FROM-clause subqueries if those ORDER BY clauses do not affect the output. See forum thread 2d76f2bcf65d256a for discussion. This can help the query flattener in some cases, resulting in faster query plans. The current implemention does not always work. (check-in: ef97c3e7 user: drh tags: omit-subquery-order-by) | |
| 16:39 | Change references to the schema table in sqlite3_analyzer to the new SQLITE_SCHEMA name. (check-in: 3beb77d6 user: drh tags: trunk) | |
|
2021-07-14
| ||
| 21:18 | Fix a use-after-free error in ioerr.test caused by an error in test code. (check-in: 1594056a user: dan tags: trunk) | |
|
2021-07-13
| ||
| 22:49 | Enhance comments pertaining to the interface linkage / calling convention macros. (check-in: c378e992 user: mistachkin tags: trunk) | |
| 21:59 | Further revisions to #line handling for amalgamation builds. (check-in: 9a843212 user: mistachkin tags: trunk) | |
| 20:55 | Get correct #line tags into amalgamation for other builds too. (check-in: 999eb800 user: larrybr tags: trunk) | |
| 11:59 | Get #line tags into amalgamation, subject to configure. (check-in: 5d81b598 user: larrybr tags: trunk) | |
| 11:55 | Merge from trunk, rename tool option for its effect (Leaf check-in: 9327f73c user: larrybr tags: line_tags) | |
| 11:30 | Do not attempt to run Tcl sessions tests unless both SQLITE_ENABLE_PREUPDATE_HOOK and SQLITE_ENABLE_SESSIONS are defined. (check-in: 385db794 user: dan tags: trunk) | |
| 01:45 | Amalgamation has #line directives by default. Minor mksqlite3c.tcl changes (check-in: ba3eff71 user: larrybr tags: line_tags) | |
|
2021-07-09
| ||
| 23:12 | Clarify comment on sqlite3.h's interface decaration macros. (check-in: 7cb09aef user: larrybr tags: trunk) | |
| 14:59 | Fix an assert() that might fail if sqlite3_create_function_v2() is invoked with NULL xStep and xFinal callbacks and a non-NULL xDestroy. (check-in: ab1550a6 user: dan tags: trunk) | |
| 13:52 | Enhance the sqlite3_create_function() interfaces to assume a value of SQLITE_UTF8 is presented with a nonsense value for the preferred encoding. This is undocumented behavior added for robustness. (check-in: c1bb5cff user: drh tags: trunk) | |
| 11:52 | Add the usual "#ifdef __cplusplus" magic to header file ext/misc/carray.h. Also update carray.h/carray.c to use SQLITE_API in the usual way. (check-in: 0f97c2a4 user: dan tags: trunk) | |
| 00:12 | Allow CLI shell build to #include same user-specified header as library build. (check-in: eb8af9a4 user: larrybr tags: trunk) | |
|
2021-07-08
| ||
| 23:35 | Rename optional SQLITE_CUSTOM_INC define to SQLITE_CUSTOM_INCLUDE. (check-in: 060aec37 user: mistachkin tags: trunk) | |
| 22:12 | Allow library build to #include a user-specified header. (check-in: 71e6490b user: larrybr tags: trunk) | |
| 18:29 | Preserve and return to the user any error message returned by a failed xConnect() call on an eponymous virtual table that prevents a query from being compiled. (check-in: bbbbeb59 user: dan tags: trunk) | |
| 12:12 | Fix an issue with the SQLite Expert extension when a column has no collating sequence. Forum post 78165fa250. (check-in: b1e0c22e user: drh tags: trunk) | |
|
2021-07-07
| ||
| 19:44 | Fix a harmless compiler warning in the "fuzzcheck" test program. (check-in: 8c432642 user: drh tags: trunk) | |
| 19:40 | Fix a harmless compiler warning - duplicate local variable named "pRHS". (check-in: 5bc05faf user: drh tags: trunk) | |
| 16:48 | Follow-up to [68db1ff9c44fa9c3]: The number of registers needed by PRAGMA foreign_key_check was increased too late for an assert() deep down inside of sqlite3ExprCode(). So move the size increase a little earlier. Forum post 79c9e4797d. (check-in: 7072404a user: drh tags: trunk) | |
| 15:52 | Fix a recently introduced segfault that might occur if a sub-select were used as a term on the RHS of an IN(...) operator for which the LHS is a row-value. (check-in: f586c06a user: dan tags: trunk) | |
| 13:53 | Improve the error message in cases where there is a row-value on the LHS of an IN() operator, the RHS is a list (not a sub-select) and at least one element of the list is not a row-value with the correct number of elements. (check-in: 6b22f4e7 user: dan tags: trunk) | |
| 11:51 | Instead of disallowing writes to fts5 tables if there are fts5vocab cursors open on them (commit [c49a6ed7]), abort any fts5vocab queries if the on-disk structure of the fts5 table changes. (check-in: 9dbdc900 user: dan tags: trunk) | |
|
2021-07-06
| ||
| 20:44 | Handle "<vector> IN (<vector>, <vector> ...)" in the same way as "<vector> IN (VALUES(<vector>, <vector>, ...)". (check-in: 981d230e user: dan tags: trunk) | |
|
2021-07-05
| ||
| 19:01 | Do not allow writes to an fts5 table if there are any open fts5vocab cursors. (check-in: c49a6ed7 user: dan tags: trunk) | |
| 18:37 | Add the ATOMIC_INTRINSICS compile-time output output. Move sqlite3Int.h in front of ctime.c so that default values that are not overridden are shown in PRAGMA compile-time option output. (check-in: e3069526 user: drh tags: trunk) | |
| 17:15 | Revert [5204c2c4a7b73a64], restoring the old pre-processor logic for determining the availability of the __atomic_store_n()/__atomic_load_n() primitives. (check-in: e690abb9 user: dan tags: trunk) | |
| 11:27 | Allow sub-queries in the FROM clause of an UPDATE...FROM statement to access the object being updated without using an alias, as is required in the parent query. (check-in: 740cb430 user: dan tags: trunk) | |
| 02:40 | Improved rebustness in sqlite3ExprListDup() when it contains a vector assignment from an UPDATE where the initial term is omitted. This can happen during a UNION ALL query flattening while processing a virtual table update in which the first term of the vector is repeated. Forum post 16ca0e9f32. (check-in: 2547cfe3 user: drh tags: trunk) | |
| 01:11 | Ensure that TK_SELECT_COLUMN Expr nodes always have their iTable field set to to the number of columns in the vector. This is not strictly necessary. It just simplifies the state description and make the code easier to reason about. (check-in: 026f08d4 user: drh tags: trunk) | |
| 00:07 | Fix an incorrect comment on testcase misc1-27.0. No changes to code. (check-in: 49829ae3 user: drh tags: trunk) | |
|
2021-07-04
| ||
| 22:33 | Enhance the treeview debugging mechanism so that it correctly deals with TK_ROW expression nodes. (check-in: e87fdb65 user: drh tags: trunk) | |
|
2021-07-03
| ||
| 18:57 | Fix a (harmless) typo in a comment. No code changes. (check-in: d2b9b8da user: drh tags: trunk) | |
| 02:55 | In the PRAGMA foreign_key_check, ensure that sufficient registers are allocated for the virtual machine, even if one or more foreign keys reuses the same column multiple times and has more columns than the table it is part of. Forum post a6b0c05277. (check-in: 68db1ff9 user: drh tags: trunk) | |
|
2021-07-02
| ||
| 12:25 | Put ALWAYS() on a branch that is always true due to [d4097364c511709b]. Fix a testcase precondition associated with the same check-in. (check-in: 55e2fbeb user: drh tags: trunk) | |
| 12:08 | Fix a harmless assertion fault discovered by OSSFuzz. The assertion fault is harmless because the assert() checks a condition that that is harmless if false and the assert() is disabled in production builds. (check-in: 79443aab user: drh tags: trunk) | |
|
2021-07-01
| ||
| 18:19 | Allow unqualified "rowid" references to be used in join queries, provided that only one of the source objects has a rowid. Forum post ab5b077c32636e49 (check-in: d4097364 user: dan tags: trunk) | |
| 16:57 | Import the updated nmakehlp.c file used by the TCL Extension Architecture (TEA) builds in the amalgamation tarballs. Forum post 5a5001f20a. (check-in: 595bf95b user: drh tags: trunk) | |
|
2021-06-30
| ||
| 14:04 | Fix a memory leak in fts5 that could occur when processing a query containing multiple classes of error. (check-in: 7c279670 user: dan tags: trunk) | |
| 12:11 | Fix an assert() in fts5 that might fail when dealing with corrupt records. (check-in: 9e760e25 user: dan tags: trunk) | |
| 11:53 | Do not enforce the SQLITE_LIMIT_FUNCTION_ARG limit for internally generated SQL. This prevents problems with statements like ALTER TABLE if the function argument limit is set too low. Forum post 17735aa21f3ddab2. (check-in: 763fdec5 user: drh tags: trunk) | |
|
2021-06-28
| ||
| 15:25 | When generating data for a RETURNING clause, avoid assuming cursor number 0 is available for use. (check-in: 4b2c59ac user: dan tags: trunk) | |
|
2021-06-25
| ||
| 14:48 | The OP_ReopenIdx opcode should clear the cursor if the cursor is being reused. This prevents leaving the cursor in an initialized state which could cause problems for a subsequent OP_SeekScan opcode. Fix for ticket [6dcbfd11cf666e21] and the OP_SeekScan optimization of check-in [4a43430fd23f8835]. (check-in: d4bf5243 user: drh tags: trunk) | |
| 11:21 | Remove a redundant "ANALYZE" line from the ".fullschema" output. (check-in: 7b47f420 user: drh tags: trunk) | |
| 11:14 | Fix a bug in the ".fullschema" dot-command of the CLI brought to light by check-in [a2ddb89b206c1387] - raising an error on at attempt to access the rowid of a subquery or view. (check-in: 36875827 user: drh tags: trunk) | |
| 00:25 | Document sqlite3_wal_hook() return. (check-in: 8acaf796 user: larrybr tags: trunk) | |
|
2021-06-24
| ||
| 18:23 | Allow the SQLITE_OPEN_EXCLUSIVE flag in sqlite3_open(). Return the SQLITE_CANTOPEN_EXISTS extended code to indicate that the open failed because the database already exists. (check-in: d091150f user: drh tags: trunk) | |
|
2021-06-23
| ||
| 17:41 | Make conditional nature of sqlite3_normalized_sql() better known. (check-in: 0e0ece71 user: larrybr tags: trunk) | |
| 16:07 | Fully incorporate *_changes64() API improvement. (check-in: 6699a2f6 user: larrybr tags: trunk) | |
| 11:39 | Show CROSS JOINs in the TreeView debuggingn output. (check-in: 72e09b6c user: drh tags: trunk) | |
| 11:12 | Fix a problem handling ORDER BY terms of the form "ORDER BY likely(<integer>)" within window frames. (check-in: 710f75b9 user: dan tags: trunk) | |
|
2021-06-22
| ||
| 23:24 | When an index is used by all branches of the WHERE_MULTI_OR optimization and becomes a covering index, make sure the index has been created prior to NULLing it in the OP_NullRow opcode of a LEFT JOIN. See forum post 0575376e07. The covering-index for WHERE_MULTI_OR optimization was added by [62678be3df35cdcb]. Test cases are in the orindex01.test module of TH3. (check-in: 787c76a8 user: drh tags: trunk) | |
| 18:32 | Add the sqlite3_changes64() and sqlite3_total_changes64() API functions. (check-in: 48fdec22 user: dan tags: trunk) | |
| 18:06 | Fix a problem causing sqlite3_changes() to return an incorrect value following a "DELETE FROM tbl" command on an intkey table (because internal b+tree cells were being included in the count). (check-in: f662ff47 user: dan tags: trunk) | |
| 14:59 | Ensure that the cell array used in balance_nonroot() is always large enough, even if the pages being balanced are corrupt. (check-in: 53f64e83 user: dan tags: trunk) | |
|
2021-06-20
| ||
| 22:52 | Load recent dbsqlfuzz cases into test/fuzzdata8.db. (check-in: a766bba0 user: drh tags: trunk) | |
| 22:49 | Remove a NEVER() that is reachable by a corrupt database. dbsqlfuzz 8456a0f88e39a49fb675d8f77394979ebb2a03c1. Test case in TH3. (check-in: 1c41e86f user: drh tags: trunk) | |
| 22:17 | Do not allow an SQLITE_CORRUPT error to mask a prior SQLITE_IOERR in balance_nonroot(). dbsqlfuzz 5e1c86e7f18023f2b9abe3429977d7ea726f50d8 (check-in: 50e81876 user: drh tags: trunk) | |
|
2021-06-19
| ||
| 20:20 | Remove unnecessary (redundant) variable initialization from sqlite3BtreeInsert() for a small size reduction and performance increase. (check-in: 70d18364 user: drh tags: trunk) | |
| 18:35 | The previous check-in is a significant change to btree, so go ahead and increment the version number for the next development cycle. (check-in: 2eb66970 user: drh tags: trunk) | |
| 18:32 | Split the sqlite3BtreeMovetoUnpacked() routine into two separate routines sqlite3BtreeTableMoveto() and sqlite3BtreeIndexMoveto(), since we usually know the type of btree in advance. This results in less branching and better performance. (check-in: 3b0d34e5 user: drh tags: trunk) | |
|
2021-06-18
| ||
| 18:36 | Version 3.36.0 (check-in: 5c9a6c06 user: drh tags: trunk, release, version-3.36.0) | |