Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
207 events for the month beginning 2023-10-01 by user drh
Following month ↑|
2023-10-31
| ||
| 17:40 | Fix harmless compiler warnings in test code. (check-in: d1895dd8 user: drh tags: trunk) | |
|
2023-10-30
| ||
| 23:05 | Merge the latest 3.44.0 release candidate changes into the reuse-schema branch. (check-in: 28f9a559 user: drh tags: reuse-schema) | |
| 22:57 | Merge the latest 3.44.0 release candidate patches into the bedrock branch. (check-in: 956b03a4 user: drh tags: bedrock) | |
| 21:46 | Merge the latest 3.44.0 changes into wal2 branch. (check-in: 4f65ae2d user: drh tags: wal2) | |
| 21:39 | Merge the latest trunk changes into the begin-concurrent branch. (check-in: 9fa405eb user: drh tags: begin-concurrent) | |
| 20:35 | Update the autoconf/Makefile.msc so that it aligns with Makefile.msc. (check-in: c4f724de user: drh tags: trunk) | |
| 19:03 | Add a cast to i64 for an integer in an sqlite3OsWrite() offset calculation. The cast is not strictly necessary, but it helps human readers see that the code is correct. (check-in: 7564ff1b user: drh tags: trunk) | |
| 18:48 | Fix another comment typo. No code changes. (check-in: 3203256c user: drh tags: trunk) | |
| 18:09 | Make the new sqlite3_get_clientdata() and sqlite3_set_clientdata() interfaces available to run-time loaded extensions. (check-in: 8fc9aa0f user: drh tags: trunk) | |
| 17:56 | Fix typo in a comment. No code changes. (check-in: 424ef955 user: drh tags: trunk) | |
| 12:09 | With SQLITE_ENABLE_BLOCK_ATOMIC_WRITE enabled, if a transaction is committing and there is a new freelist page at the end of the database file which would cause the database file size to grow, ensure that page is written and the file size grows before the block-atomic-write commits. Fix for the problem identified by forum post 3bd8d497b2 (check-in: c9fdd680 user: drh tags: trunk) | |
|
2023-10-28
| ||
| 16:19 | Limit the range of integer unix timestamps in date4.test, since some systems (RaspberryPI) cannot deal with timestamp values that exceed pow(2,31). (check-in: 76529066 user: drh tags: trunk) | |
| 11:53 | Update documentation for sqlite3_errmsg() to try to make it clear that if the schema of a database contains table names or similar with invalid UTF, then the error message generated by SQLite might also contain invalid UTF. No changes to code. (check-in: 33ba13c7 user: drh tags: trunk) | |
| 11:40 | Since SQLite considers NaN to be like NULL and NULL sorts before any integer, make sure the sqlite3IntFloatCompare() routine reports that the integer argument is larger if the floating-point argument is NaN. (check-in: de1cf31a user: drh tags: trunk) | |
|
2023-10-27
| ||
| 18:16 | Disable two rtree test cases for Linux-i686. We do not have that platform available for testing. The test cases work on all other 64-bit and 32-bit platforms that we have at hand. So there is no way for us to debug this problem. Better to disable the test. forum post ffcbf789b5386573. (check-in: fed4d6e9 user: drh tags: trunk) | |
| 17:40 | Add makefile targets for fuzzcheck-asan and fuzzcheck-ubsan. (check-in: 27fc1430 user: drh tags: trunk) | |
| 10:49 | Back out [2904fcbeebba9189], mostly. The page bitmap is needed even for a partial integrity_check in order to avoid an infinite loops while walking the database. (check-in: dd6e03b3 user: drh tags: trunk) | |
|
2023-10-26
| ||
| 17:30 | Enhance the "tool-zip" makefile target on Windows so that it uses more universally available commands to build the ZIP archive. Fix other minor issues with that makefile target at the same time. (check-in: d2f2f912 user: drh tags: trunk) | |
| 16:59 | Further enhancements to make sure the correct returnning trigger is run when there are nested INSERT RETURNING statements. (check-in: d83405e8 user: drh tags: trunk) | |
| 13:33 | • Edit [8aba78e4dbf5c196|8aba78e4]: Edit check-in comment. (artifact: 50433512 user: drh) | |
| 12:59 | Deal with the case of a reentrant INSERT on a virtual table where the outer INSERT has a RETURNING clause but the inner does not. dbsqlfuzz 3ac9a1e33f676254e02c0f297263b0a7aeb0c1a5. Fault injected by [a2449bcc2c71d0f4], first appearing in release 3.40.1. (check-in: 8aba78e4 user: drh tags: trunk) | |
|
2023-10-25
| ||
| 19:06 | Fix harmless compiler warnings. (check-in: cc8efe04 user: drh tags: trunk) | |
| 18:53 | Provide dummy parameter names in the prototype for the new xIntegrity method of the sqlite3_module object. (check-in: 131374d7 user: drh tags: trunk) | |
| 18:35 | Fix minor problems with the "showwal" utility program. Add a missing header to the zipfile.c extension. (check-in: 7b3f866e user: drh tags: trunk) | |
| 17:26 | Test module altermalloc3.test requires DQS_DDL to be turned on. (check-in: c4d02f4b user: drh tags: trunk) | |
| 15:30 | Add an ALWAYS on branch that was made always-true by the DISTINCT ORDER BY fix. (check-in: c29ebcb0 user: drh tags: trunk) | |
| 14:54 | When doing a DISTINCT aggregate that contains an ORDER BY, only the arguments to the aggregate need to be distinct, not the ORDER BY terms. (check-in: d2dbbdf7 user: drh tags: trunk) | |
| 12:58 | Fix the amalgamation generator so that when it is reporting the Fossil version number in the header comment of the amalgamation, it does not elide the first hex digit of the version hash. (check-in: cc66f526 user: drh tags: trunk) | |
| 10:37 | Enhance the new xIntegrity method of the sqlite3_module object with new parameters that provide the name of the table being checked and a flag to indicate a "quick_check". Based on feedback in forum post 965c0d02ea. (check-in: bc8afa3f user: drh tags: trunk) | |
|
2023-10-24
| ||
| 19:56 | Implement check-in [477577120b897bf1] differently, so as not to disrupt non-standard build configuration. See forum post c11523ca2df50293. (check-in: 50448fe4 user: drh tags: trunk) | |
| 19:46 | • Edit [477577120b897bf1|47757712]: Edit check-in comment. (artifact: d8cca5b3 user: drh) | |
| 17:45 | Test cases for COLLATE and NULLS FIRST/LAST in the ORDER BY for an aggregate function. (check-in: 641f928f user: drh tags: trunk) | |
| 16:16 | New #ifdefs to fix certain compile-time options. (check-in: 688c6279 user: drh tags: trunk) | |
| 11:06 | Fix various harmless scan-build warnings. (check-in: 54be9af4 user: drh tags: trunk) | |
| 09:57 | Fix a harmless compiler warning in the expert extension. (check-in: 0c4907dd user: drh tags: trunk) | |
|
2023-10-23
| ||
| 23:34 | Fix a minor typo in the previous. (check-in: 9d388267 user: drh tags: trunk) | |
| 23:34 | Add notes on how to build a statically linked version of sqlite3_analyzer.exe. (check-in: 99ce9939 user: drh tags: trunk) | |
| 19:51 | Add the sqlite3res file to the Windows build of sqldiff.exe so that the resulting binary shows the SQLite icon. (check-in: c696a496 user: drh tags: trunk) | |
| 19:27 | Merge the latest trunk enhancments into the reuse-schema branch. (check-in: 52262ac9 user: drh tags: reuse-schema) | |
| 15:23 | New test cases for PRAGMA integrity_check against FTS4 and FTS5 tables. (check-in: 3950d20c user: drh tags: trunk) | |
| 13:46 | Improved error messages for the xIntegrity method in FTS3/4 and FTS5. (check-in: df69abc0 user: drh tags: trunk) | |
| 12:16 | Fix sqlite3ExprDup() alignment assertions so that they work on 32-bit platforms. (check-in: 143f95ef user: drh tags: trunk) | |
| 11:41 | Temporarily disable the ext/expert/expert1-6.0 test, which does not work on my configurations. (check-in: a41b903d user: drh tags: trunk) | |
| 02:01 | Fix the shell1.test test so to align with the new behavior imposed by [bce807cd48763273] - that backslash escapes only work without quoted arguments in dot-commands of the CLI. (check-in: 0db82b42 user: drh tags: trunk) | |
|
2023-10-22
| ||
| 23:53 | • Edit [bce807cd48763273|bce807cd]: Edit check-in comment. (artifact: 826dce59 user: drh) | |
| 23:44 | Fix [f5c01676fd281e93] so that it always preserves 8-byte alignment for Expr objects. Add new assert() statement to verify this. (check-in: 678a9728 user: drh tags: trunk) | |
| 17:27 | Do not do backslash escape processing on any unquoted strings in dot-commands in the CLI - on Windows or on posix-like systems either one. This brings the processing into alignment with the documentation, allows backslash-delimited filenames on Windows (as long as they are unquoted), and causes the CLI to work the same with regard to backslash escapes on both Windows and posix. (check-in: bce807cd user: drh tags: trunk) | |
|
2023-10-21
| ||
| 22:31 | In the CLI, do not translate unquoted backslash escapes on dot-commands as that can damage filename arguments. (check-in: 4a0e2c6e user: drh tags: trunk) | |
| 20:34 | Remove a branch that cannot affect the outcome from FkNoAction processing in fkey.c. Replace it with an assert(). (check-in: 023a9dbe user: drh tags: trunk) | |
| 20:03 | Replace the patch at [5cb61c6788d7c017] with a better way to avoid failing PRAGMA integrity_check if a module implementation is not loaded, as the use of suppressErr can lead to problems. (check-in: be5737ee user: drh tags: trunk) | |
| 19:59 | • Edit [cbea52e9ef368f1b|cbea52e9]: Mark "Closed". (artifact: 55d6583b user: drh) | |
| 19:57 | • Edit [cbea52e9ef368f1b|cbea52e9]: Move to branch mistake. Edit check-in comment. (artifact: 6b971d3d user: drh) | |
| 19:51 | Check-in contains stray edit. (Closed-Leaf check-in: cbea52e9 user: drh tags: mistake) | |
| 16:33 | Add the SQLITE_TESTCTRL_FK_NO_ACTION test control. Make it available in the CLI. Fix a minor problems with SQLITE_CHANGESETAPPLY_FKNOACTION in sessions. (check-in: 91b64c6a user: drh tags: trunk) | |
| 16:25 | Extra comment on the implementation of SQLITE_TESTCTRL_FK_NO_ACTION, warning about the need to reset the schema in order for the setting change to take full effect. (Closed-Leaf check-in: a50a333a user: drh tags: fknoaction) | |
| 12:54 | Add SQLITE_TESTCTRL_FK_NO_ACTION. (check-in: 563cf5f7 user: drh tags: fknoaction) | |
| 11:43 | Adjust an EXPLAIN QUERY PLAN output in scanstatus2.test to account for a different loop order taken due to the removal of the view-scan optimization. (check-in: 9deb8b69 user: drh tags: trunk) | |
| 11:34 | Compress the content of the status line in testrunning.tcl so that all the same status information appears but with less punctuation and with "zero" values omitted, so that the status line will fit comfortably on an 80-column terminal window. (check-in: 96635131 user: drh tags: trunk) | |
| 11:13 | Create the new string_agg(X,Y) aggregate function which is an alias for the two-argument group_concat(X,Y) function, for compatibility with SQL-Server and PostgreSQL. (check-in: a3b3df8a user: drh tags: trunk) | |
| 11:06 | Avoid an unnecessary malloc() for the page usage bitmap when running a partial integrity_check. (check-in: 2904fcbe user: drh tags: trunk) | |
| 11:00 | Fix a test case broken by the previous check-in. (Leaf check-in: 1e61864c user: drh tags: string_agg) | |
| 11:00 | • Edit [b91c19bf2680f60d|b91c19bf]: Move to branch string_agg. (artifact: f1e202b1 user: drh) | |
|
2023-10-20
| ||
| 20:19 | Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibility with SQLServer and PG. (check-in: b91c19bf user: drh tags: string_agg) | |
| 19:06 | Fix PRAGMA integrity_check so that it does not raise an error if the schema contains a CREATE VIRTUAL TABLE that does not have its module loaded. (check-in: 5cb61c67 user: drh tags: trunk) | |
| 18:09 | Omit some redundant calls to strlen() used to find the size of Expr.u.zToken in sqliteExprDup(). This inefficiency was seen while working on the previous check-in, and I thought it best to fix it while it was fresh in mind. (check-in: b7a84eff user: drh tags: trunk) | |
| 17:15 | Improvements to the sqlite3ExprDup() logic for faster performance and better run-time error detection. This check-in fixes the 5x oversize memory allocation bug from [f371e4c0f8ea73ae] as well as all other known issues that result from handing the ORDER BY clause of an aggregate function off of the pLeft pointer of the Expr object. (check-in: f5c01676 user: drh tags: trunk) | |
| 15:47 | Simplifications and optimizations to the Expr object duplication logic. The 5x multiplier crutch from [f371e4c0f8ea73ae] is still present. More fixes are still needed. (check-in: 56142a78 user: drh tags: trunk) | |
| 15:45 | • Edit [f371e4c0f8ea73ae|f371e4c0]: Edit check-in comment. (artifact: 93cc1eb9 user: drh) | |
| 14:05 | Omit an unused constant from sessionfuzz.c to prevent a compiler warning. (check-in: a0cf7e24 user: drh tags: trunk) | |
| 10:18 | Use sqlite3ParserAddCleanup() instead of calling sqlite3ExprListDelete() directly when disposing of an unused ORDER BY in an aggregate function, to avoid disrupting ALTER TABLE data structures. (check-in: d083e420 user: drh tags: trunk) | |
|
2023-10-19
| ||
| 21:05 | Ensure that when an ephemeral cursor is reopened with a second invocation of to OP_OpenEphemeral, the sequence counter is reset and the cache marked as stale. Fix for [9cdc5c46]. (check-in: d4bfa8d2 user: drh tags: branch-3.28) | |
| 20:46 | Merge recent trunk enhancements into the jsonb branch. (check-in: f47a8d0a user: drh tags: jsonb) | |
| 20:17 | Increase the size of some variables associated with the PMA sorter in order to avoid any possibility of a signed integer overflow. (check-in: 72597cee user: drh tags: branch-3.43) | |
| 20:06 | Remove a faulty assert() that was added just a few check-ins ago by [8b6fffb552c30f9c]. (check-in: 18e7c826 user: drh tags: trunk) | |
| 19:57 | For TK_ORDER expression nodes to always be full-size. (check-in: a5c73b46 user: drh tags: trunk) | |
| 19:19 | Fix an adverse interaction between the new aggregate ORDER BY logic and the expression compressor. Update 2023-10-20: Memory allocations were multiplied by a factor of 5 on line 1575 of expr.c. This was a debugging change that I neglected to remove prior to checking it. That change masks deeper problems that will be solved in later check-ins. (check-in: f371e4c0 user: drh tags: trunk) | |
| 19:08 | In the TreeView logic (used for debugging only) do not show unnecessary fields of the Window object when a function has a FILTER. (check-in: d2c6b82c user: drh tags: trunk) | |
| 18:07 | Simplify the Expr compression logic slightly by adding the new EP_FullSize property to expressions that are exceptions to the rule and should not be compressed. (check-in: d5ae82ec user: drh tags: trunk) | |
| 13:35 | Simplification to sqlite3GetVarint32() to avoid confusing gcov. (check-in: 89862c51 user: drh tags: trunk) | |
| 13:00 | Fix an error in a debugging routine used inside of testcase(). Does not appear in production. Problem discovered by scan-build. (check-in: c6c9d7ed user: drh tags: trunk) | |
| 12:36 | New assert() statements to help verify correctness of the ORDER BY aggregate code. (check-in: 8b6fffb5 user: drh tags: trunk) | |
| 12:12 | Fix the sqlite3ReferencesSrcList() routine so that it recognizes columns in the ORDER BY clause of an aggregate. Fixes a problem with [634286828dad873d] discoverd by dbsqlfuzz. (check-in: 3d26f1aa user: drh tags: trunk) | |
| 01:26 | Add support for ORDER BY on the argument list of aggregate functions. (check-in: 63428682 user: drh tags: trunk) | |
| 01:09 | Merge the latest changes from trunk. (Closed-Leaf check-in: d18bc400 user: drh tags: agg-orderby) | |
| 00:25 | Fix a false-positive in run-time error checking. (check-in: cd63eec0 user: drh tags: trunk) | |
|
2023-10-18
| ||
| 23:48 | Changes for test coverage. (check-in: ddfa09c6 user: drh tags: agg-orderby) | |
| 22:53 | Test case for alter column that is used in the ORDER BY of an aggregate. (check-in: 648ddb3a user: drh tags: agg-orderby) | |
| 22:27 | Deal with an OOM condition while processing aggregate ORDER BYs. (check-in: b6d44427 user: drh tags: agg-orderby) | |
| 22:03 | Make sure all terms of the ORDER BY within an aggregate go through aggregate analysis. Do not attach an aggregate ORDER BY to a window function. (check-in: 16f38055 user: drh tags: agg-orderby) | |
| 19:44 | Basic test cases. (check-in: 6cccf86c user: drh tags: agg-orderby) | |
| 19:07 | Fix one minor error in order to get all legacy tests to pass. (check-in: 5a885139 user: drh tags: agg-orderby) | |
| 18:11 | ORDER BY on aggregates seem to work, at least for simple smoke tests. Lots more testing is needed though. Surely there are many bugs. (check-in: 64c12a83 user: drh tags: agg-orderby) | |
| 13:58 | Basic error checking. Resolve symbols in the aggregate ORDER BY expressions. (check-in: c83a53a5 user: drh tags: agg-orderby) | |
| 13:18 | Enhance the parser so that it can accept an ORDER BY clause on a function invocation. For this incremental check-in, the ORDER BY clause is currently ignored. (check-in: 3a98ff24 user: drh tags: agg-orderby) | |
|
2023-10-17
| ||
| 19:33 | Fix a harmless compiler warning about variant types for a pointer function. (check-in: 37ff0d8e user: drh tags: trunk) | |
| 18:59 | Make a new branch in the SqlExec opcode reachable by tests. (check-in: 023ad470 user: drh tags: trunk) | |
| 18:28 | Omit an unreachable branch when SQLITE_ENABLE_API_ARMOR is not defined. (check-in: 5f8b807b user: drh tags: trunk) | |
| 17:53 | Changes to sqlite3IntFloatCompare() in an attempt to better measure branch coverage in the face of aggressive compiler optimization. (check-in: 5781d043 user: drh tags: trunk) | |
| 13:47 | Fix a JSON bug introduced in 3.43.0. The problem occurs when doing a JSON_EXTRACT() on an array element that was added by JSON_SET() without first reparsing. (check-in: 3161c2cd user: drh tags: branch-3.43) | |
| 13:41 | Fix a JSON bug introduced by the optimization of [df099ad713011b67] and first appearing in 3.43.0. The problem occurs when doing a JSON_EXTRACT() on an array element that was added by JSON_SET() without first reparsing. Reported by forum post fc0e3f1e2a. (check-in: e5099c54 user: drh tags: trunk) | |
| 11:57 | Enhance the documentation of sqlite3_deserialize() to make it clear that the input database may not be in WAL mode. Forum post a7e272cee9ac469f (check-in: e7547899 user: drh tags: trunk) | |
| 10:47 | When an I/O or similar error occurs during a transaction with journal_mode=MEMORY, attempt to rollback before closing the journal, as all rollback information is forgotten when a memory rollback journal is closed. (check-in: 1d67f75d user: drh tags: trunk) | |
|
2023-10-14
| ||
| 20:24 | Do not allow an ALTER TABLE ADD COLUMN on a STRICT table if the added column contains a DEFAULT clause that would violate the type of the added column. (check-in: 75b07586 user: drh tags: trunk) | |
| 17:34 | Merge the version-3.43.2 changes into the begin-concurrent-3.43 branch. (Leaf check-in: f3fb30af user: drh tags: begin-concurrent-3.43) | |
| 17:14 | The rtreecheck() SQL function should not invoke BEGIN or COMMIT as this causes issues for statement transactions. (check-in: b7b2e30b user: drh tags: trunk) | |
| 10:54 | Bug fix in sqlite3_analyzer: for databases larger than 1GiB, take into account the lock-byte page when calculating the number of freelist pages. (check-in: 26a909cd user: drh tags: trunk) | |
|
2023-10-13
| ||
| 22:19 | Earlier detection of a host of errors in CREATE TABLE, such the CREATE TABLE statement itself fails, rather than generating an error on the first attempted use of the created table. (check-in: 348fa7aa user: drh tags: trunk) | |
| 19:41 | Apply the correct affinity to DEFAULT values that are TRUE or FALSE. (check-in: 4958db70 user: drh tags: trunk) | |
| 18:29 | Do not allow triggers on shadow tables under defensive mode. (check-in: 44b932ff user: drh tags: trunk) | |
| 13:49 | Immediately fail a CREATE TABLE statement that attempts to create a table that has a generated column loop. Legacy allows the table to be created but the table would not be usable for anything. (check-in: 3237bf96 user: drh tags: trunk) | |
| 12:57 | Actually prevent PRAGMA writable_schema=ON from being set in defensive mode, rather than just preventing it from functioning. (check-in: 2b574d9e user: drh tags: trunk) | |
|
2023-10-12
| ||
| 20:51 | Make sure virtual tables have been connected before trying to invoke the xIntegrity method during PRAGMA integrity_check. (check-in: 4a4eccb6 user: drh tags: trunk) | |
| 19:11 | • Edit [c8ef3b787419ccb7|c8ef3b78]: Edit check-in comment. (artifact: cd47c235 user: drh) | |
| 18:46 | Enable SQLITE_VTAB_INNOCUOUS for FTS3, FTS5, and RTREE. (check-in: f34c533b user: drh tags: trunk) | |
| 17:47 | Merge fixes from trunk into the jsonb branch. (check-in: a760bd7b user: drh tags: jsonb) | |
| 17:41 | Make sure the journal file is closed when transitioning into MEMORY journal mode, to avoid an assertion fault in the new sqlite3_randomness() avoidance code added by [c84e4483cb44f827]. (check-in: 29937081 user: drh tags: trunk) | |
|
2023-10-11
| ||
| 17:34 | Fix the use of an uninitialized value that occurs when doing a json_insert() of a string value that contains embedded U+0000 characters. (check-in: 7dcd9cfe user: drh tags: branch-3.43) | |
| 17:24 | Fix the use of an uninitialized value that occurs when doing a json_insert() of a string value that contains embedded U+0000 characters. (check-in: d3c0cbb9 user: drh tags: trunk) | |
| 17:21 | Fix the use of an uninitialized value that occurs when doing a json_insert() of a string value that contains embedded U+0000 characters. (check-in: fc5ee9e5 user: drh tags: jsonb) | |
| 13:34 | Simplification to sqlite3ApiExit(). Generates identical machine code, but easier for humans to read. (check-in: 793bbfa5 user: drh tags: trunk) | |
| 13:19 | Fix a missing zero-terminator on a string when processing JSON aggregates into JSONB. (check-in: fb81d570 user: drh tags: jsonb) | |
| 12:44 | Fix an issue that can arise when processing corrupt JSONB. (check-in: e50045c2 user: drh tags: jsonb) | |
| 12:21 | Improved robustness against corrupt JSONB. (check-in: 0fbda92b user: drh tags: jsonb) | |
| 11:42 | Fix an assertion fault in json_patch() that can occur if the patch JSON is malformed JSONB. Report the malformed JSONB instead. (check-in: a72d5464 user: drh tags: jsonb) | |
|
2023-10-10
| ||
| 23:02 | Improved robustness in the decoding of JSON5 text escape sequences found in malformed JSONB. (check-in: 35e0108a user: drh tags: jsonb) | |
| 18:55 | Fix an off-by-one error in the changes from the previous check-in on the jsonb branch. (check-in: 216191b1 user: drh tags: jsonb) | |
| 18:42 | Improved robustness when translating corrupt JSONB into JSON text. (check-in: 0caa320d user: drh tags: jsonb) | |
| 18:32 | Fix a potential buffer overrun due to corrupt JSONB. (check-in: 5cbb861f user: drh tags: jsonb) | |
| 18:04 | Fix bugs uncovered by the fuzzer. (check-in: c96eb7fb user: drh tags: jsonb) | |
| 17:34 | Merge the latest trunk enhancements into the jsonb branch. (check-in: f93f16c9 user: drh tags: jsonb) | |
| 15:34 | Fix a bug in the mkautoconfamal.sh script so that the "snapshot-tarball" and "amalgamation-tarball" makefile targets work again when run from outside of the source tree. (check-in: 3a79cf25 user: drh tags: branch-3.43) | |
| 15:33 | Fix a bug in the mkautoconfamal.sh script, introduced by check-in [3308fdda4b81c110] so that the "snapshot-tarball" and "amalgamation-tarball" makefile targets work again when run from outside of the source tree. (check-in: 65ccf5fe user: drh tags: trunk) | |
| 13:55 | Merge the 3.43.2 release changed into the reuse-schema-3.43 branch. (Leaf check-in: 5fefa147 user: drh tags: reuse-schema-3.43) | |
| 12:14 | Version 3.43.2 (check-in: 4310099c user: drh tags: release, branch-3.43, version-3.43.2) | |
|
2023-10-09
| ||
| 22:50 | Use snprintf() in place of sprintf() in a debugging function in the CLI. (check-in: 88a11890 user: drh tags: branch-3.43) | |
| 22:45 | Use snprintf() in place of sprintf() in a debugging function in the CLI. (check-in: 5e5e4d2b user: drh tags: trunk) | |
| 18:33 | Systematize the names of some of the translation function in the JSON implementation. (check-in: db44bd1d user: drh tags: jsonb) | |
| 14:59 | Add a TCL script that does various verification checks on the source tree to make sure that generated code has been updated correctly. (check-in: dc8681c4 user: drh tags: branch-3.43) | |
| 14:56 | Add a TCL script that does various verification checks on the source tree to make sure that generated code has been updated correctly. (check-in: 1f1a358a user: drh tags: trunk) | |
| 14:47 | Fix a compiler warning caused by the previous check-in. (check-in: 7e8768bf user: drh tags: trunk) | |
| 14:12 | Change the TEA version number to 3.43.2 also. (check-in: 170ab8d1 user: drh tags: branch-3.43) | |
| 14:10 | Update the version number to 3.43.2. (check-in: 0bd1199b user: drh tags: branch-3.43) | |
| 14:05 | Turn on SEH by default when building using MSVC. (check-in: f57e8275 user: drh tags: trunk) | |
| 12:57 | Merge the latest trunk fixes and enhancements into the jsonb branch, and especially the JSON cache spill UAF fix. (check-in: 9422c24f user: drh tags: jsonb) | |
| 12:51 | Fix a potential UAF caused by JSON parser cache spill. (check-in: 5b09212a user: drh tags: branch-3.43) | |
| 12:46 | Fix a potential UAF caused by JSON parser cache spill. Forum post b25edc1d46. (check-in: a163fecc user: drh tags: trunk) | |
| 12:39 | Fix harmless compiler warning in the test module for sessions. (check-in: 3d5ec993 user: drh tags: trunk) | |
| 12:35 | • Edit [53d5c50462c82d22|53d5c504]: Move to branch mistake. Mark "Closed". (artifact: 6c0e75c3 user: drh) | |
| 12:10 | In the VDBE trace output (available under -DSQLITE_DEBUG only), identify register values that hold a refernce-counted string. (Closed-Leaf check-in: 53d5c504 user: drh tags: mistake) | |
|
2023-10-07
| ||
| 23:35 | Remove some unnecessary code. Report errors for invalid JSONB input on an extract. (check-in: cbea16c2 user: drh tags: jsonb) | |
| 19:46 | The return from sqlite3_value_blob() in jsonFuncArgMightBeBinary() might be a NULL pointer. Check for that case. (check-in: 7b52b266 user: drh tags: jsonb) | |
| 19:40 | Improved detection of malformed JSONB when parsing it into a JsonNode array. (check-in: ed99a788 user: drh tags: jsonb) | |
| 19:05 | Fix the jsonbChangePayloadSize() routine so that it shifts the payload in order to always render the most compact encoding of the payload size. This is necessary as sometimes (as discovered by dbsqlfuzz) the payload size can grow significantly due to json_insert() or json_replace(). (check-in: 8d6d04ca user: drh tags: jsonb) | |
| 17:50 | Improvements to error messages returned when the ->> operator fails. (check-in: 2f3388f1 user: drh tags: jsonb) | |
| 11:37 | Merge the memory leak fix from trunk. (check-in: 358de1b0 user: drh tags: jsonb) | |
| 11:36 | Improved error messages from search on JSONB. (check-in: 96cfdc31 user: drh tags: jsonb) | |
| 09:13 | Report unknown JSONB element type when parsing JSONB into JsonNode. (check-in: 1f4d3268 user: drh tags: jsonb) | |
| 08:15 | Add a test case to prevent a regression of the leak fixed in the previous trunk check-in. (check-in: f99ff655 user: drh tags: trunk) | |
| 08:11 | Fix a resource leak: sqlite3_blob_reopen() was failing to invoke the xDel() distructor on a register when it sets that register to the new rowid. (check-in: 83846af5 user: drh tags: branch-3.43) | |
| 08:00 | Fix a resource leak: sqlite3_blob_reopen() was failing to invoke the xDel() distructor on a register when it sets that register to the new rowid. This was never a problem prior to the large-column cache of [771fe35074b50b8d] as that destructor was always a no-op. dbsqlfuzz cd96368deaece480fb94d42427dde053737a650e. (check-in: 545edd5e user: drh tags: trunk) | |
|
2023-10-06
| ||
| 23:02 | Correct handling of "raw" strings in JSON. This requires three test-case changes in TH3 to add double-quotes to the path outputs from json_tree(). The new behavior is correct, I believe. (check-in: ab2bf3e3 user: drh tags: jsonb) | |
| 22:16 | Improved error detection for JSONB inputs. (check-in: 6945e11a user: drh tags: jsonb) | |
| 18:21 | Incremental improvements to the JSONB logic. (check-in: fe326829 user: drh tags: jsonb) | |
| 15:35 | Fixes to rendering JSON5 extensions encoded as JSONB. (check-in: 5a17e447 user: drh tags: jsonb) | |
| 14:59 | Fix compiler warnings. (check-in: 5227add3 user: drh tags: jsonb) | |
| 14:52 | Improvements to error handling. (check-in: b41dd237 user: drh tags: jsonb) | |
| 13:05 | Merge compiler warning fixes from trunk into the jsonb branch. (check-in: 6409d307 user: drh tags: jsonb) | |
| 12:55 | Remove an unused parameter from the recomputeColumnsNotIndexed() routine in order to squash a harmless compiler warning. (check-in: 9bf4bfd6 user: drh tags: trunk) | |
| 12:51 | Ensure that all fields of static sqlite3_module objects are explicitly initialized, in order to hush-up nuisance compiler warnings. (check-in: f3b3d712 user: drh tags: trunk) | |
| 12:22 | Remove an unused static variable from shell.c.in in order to silence a harmless compiler warning. (check-in: 47757712 user: drh tags: trunk) | |
| 12:15 | Increase the size of some variables associated with the PMA sorter in order to avoid any possibility of a signed integer overflow. Chromium fuzzer issue 1489025. (check-in: dc3be3af user: drh tags: trunk) | |
| 00:06 | Improvements to coping with malformed JSONB. (check-in: 563cde40 user: drh tags: jsonb) | |
|
2023-10-05
| ||
| 23:05 | Better error detection when doing a lookup on a JSONB. (check-in: 6e8e0eed user: drh tags: jsonb) | |
| 22:52 | Improvements to comments. No changes to code. (check-in: ac74d787 user: drh tags: jsonb) | |
| 20:17 | Turn an unreachable branch into an assert(). (check-in: 0f751991 user: drh tags: jsonb) | |
| 18:33 | Fix the parsing of non-standard "Infinity" and "NaN" values from text into JSONB. (check-in: df1fbbeb user: drh tags: jsonb) | |
| 18:09 | Change the json_valid(X) routine to return true whenever X is a blob that could plausibly be a valid JSONB. (check-in: 425f0b85 user: drh tags: jsonb) | |
| 17:52 | Fix the text-to-JSONB parser so that it handles some JSON5 floating point literals correctly. (check-in: 564edb3b user: drh tags: jsonb) | |
| 16:33 | Slightly stricter testing for when a BLOB is valid JSONB: If the element is a null, true, or false, its payload size must be zero. (check-in: 487781be user: drh tags: jsonb) | |
| 15:05 | Fix a memory leak following a syntax error in jsonb(). (check-in: bf4b36ed user: drh tags: jsonb) | |
| 15:02 | Allow the PG-style syntax for the PATH operand on the right-hand side of the ->> and -> operators. (check-in: bae5071b user: drh tags: jsonb) | |
| 11:22 | Merge trunk enhancements into the jsonb branch. (check-in: be5907b6 user: drh tags: jsonb) | |
| 11:09 | Improved detection of corrupt databases in balance_nonroot(). dbsqlfuzz d1cf013c50a620b68c2a5bd240d29afd65e5f58e. (check-in: f4aa1bfc user: drh tags: branch-3.43) | |
| 11:06 | Improved detection of corrupt databases in balance_nonroot(). dbsqlfuzz d1cf013c50a620b68c2a5bd240d29afd65e5f58e. (check-in: a2464bbb user: drh tags: trunk) | |
| 10:35 | Remove a stray blank line from the beginning of btree.c. No functional code changes. (check-in: c89983dc user: drh tags: trunk) | |
|
2023-10-04
| ||
| 22:42 | • Edit [562e8e7b08c696ed|562e8e7b]: Mark "Closed". (artifact: f894644f user: drh) | |
| 12:49 | The Makefile distinguishes between tcl8.4 and tcl8.5. Some makefile targets require tcl8.5, but others (ex: "sqlite3.c", "shell.c", and "sqlite3") require only tcl8.4. (check-in: 770308db user: drh tags: trunk) | |
| 11:52 | Modify the main makefile so that it fails with an error if the tclsh found by ./configure is not tclsh 8.5 or later. Forum post 4380363682708ece. (check-in: 1765f3b5 user: drh tags: trunk) | |
| 11:25 | • Edit [9f6402831b8add6f|9f640283]: Move to branch error-no-tclsh. Mark "Closed". (artifact: 04a29df8 user: drh) | |
| 11:04 | Hard fail the ./configure script if it is unable to find a working tclsh. Forum post 4380363682708ece. (Closed-Leaf check-in: 9f640283 user: drh tags: error-no-tclsh) | |
|
2023-10-03
| ||
| 22:40 | Fix a memory leak in JSON group-aggregates when the output is JSONB. (check-in: 08e7db13 user: drh tags: jsonb) | |
| 21:54 | Fix a bug in the jsonReturnFromBlob() function that causes a positive result for a negative value for when a JSON integer is too large and needs to be converted into double. (check-in: dca684da user: drh tags: jsonb) | |
| 20:58 | Fix problems in the "json" output column of the json_tree() virtual table for the case when the input is JSONB. (check-in: fefa4475 user: drh tags: jsonb) | |
| 20:01 | Augment the jsonBlobChangePayloadSize() routine so that it tries to shift content in order to render the payload size in its minimal form. (Closed-Leaf check-in: 562e8e7b user: drh tags: jsonb-opt1) | |
| 19:37 | Improved handling of OOM while translating the JsonNode representing into the BLOB representation. (check-in: ef595671 user: drh tags: jsonb) | |
| 11:36 | Merge the latest trunk enhancements into the jsonb branch. (check-in: e6406a98 user: drh tags: jsonb) | |
| 10:59 | Fix a problem in the JSONB parser that comes up following an OOM. (check-in: 355acfb1 user: drh tags: jsonb) | |
| 10:43 | Fix an issue with the use of jsonb_group_array() and jsonb_group_object() when used by window functions. (check-in: 808bd349 user: drh tags: jsonb) | |
|
2023-10-02
| ||
| 23:56 | New test cases for JSONB. (check-in: 6d4aeff5 user: drh tags: jsonb) | |
| 20:16 | Fix jsonb_insert() so that it does not behave like jsonb_set(). New test cases added. (check-in: 54197149 user: drh tags: jsonb) | |
| 17:06 | Fix the length of the string in the new concat() and concat_ws() functions. (check-in: 32524322 user: drh tags: trunk) | |
| 15:56 | Remove an ALWAYS() from a branch that can in fact be false following an OOM fault. (check-in: 3a1feb1c user: drh tags: trunk) | |
| 14:51 | New test cases for JSONB. (check-in: d624c31e user: drh tags: jsonb) | |
| 13:35 | Allow json_replace() to accept JSONB arguments as the new value. (check-in: 95eb7b37 user: drh tags: jsonb) | |
| 13:20 | Improvements to error handling for BLOB inputs on JSON. (check-in: 14f20ecb user: drh tags: jsonb) | |
| 12:40 | Gather forward references into a single place for the JSON code. Allow JSONB arguments to json_array() and json_object() and similar. (check-in: c352201b user: drh tags: jsonb) | |
|
2023-10-01
| ||
| 18:59 | Fix problems following OOM in JSONB parsing. (check-in: 0d8cd6b5 user: drh tags: jsonb) | |