Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
154 events for the month beginning 2023-04-01 by user drh
Following month ↑|
2023-04-30
| ||
| 23:52 | Fix a problem with json_patch() when one side or the other is JSON5. dbsqlfuzz bc10593a4ba8e7a7862593532285be31f00f8e41 (check-in: e18c0899cc user: drh tags: json5) | |
| 20:37 | Accept the full ECMAScript 5.1 IdentifyName syntax for keys in objects. (check-in: 9be2c87518 user: drh tags: json5) | |
| 19:45 | All JSON to understand floating point literals "Inf" and "QNaN" and "SNaN" in any case, without the SQLITE_EXTENDED_NAN_INF compile-time option. This extension is always available. (check-in: fb551145e0 user: drh tags: json5) | |
| 19:34 | Omit the json_valid() function. Change the name of json_error() to json_error_position(). Use "NOT json_error_position(X)" as a substitute for "json_valid5(X)". (check-in: 34c4e900a9 user: drh tags: json5) | |
|
2023-04-29
| ||
| 18:40 | Merge all the latest trunk enhancements into the JSON5 branch to facilitate testing of the JSON5 branch. (check-in: 30d12edeba user: drh tags: json5) | |
| 17:35 | More ALWAYS() macros. (check-in: 770b09f7a7 user: drh tags: json5) | |
| 17:13 | Add ALWAYS macros on unreachable branches in the new JSON5 logic. (check-in: 91e15ed9d9 user: drh tags: json5) | |
| 16:31 | Simplification of the logic that normalizes JSON5 integer literals into canonical JSON integer literals. Improved reporting of OOM. (check-in: 01ee613c07 user: drh tags: json5) | |
| 16:00 | Do not allow leading zeros on non-zero numeric literals in JSON. (check-in: 3e91494390 user: drh tags: json5) | |
| 12:13 | Minor fixes to to the JSON% parser. (check-in: 2fe684cdcd user: drh tags: json5) | |
| 00:59 | Correctly recognize an isolated U+feff as a space character in JSON5. (check-in: 4473dc8e3a user: drh tags: json5) | |
|
2023-04-28
| ||
| 23:38 | Bug fixes in the logic to skip over JSON5 comments. (check-in: c736b77a2f user: drh tags: json5) | |
| 23:19 | Bug fix in the offset computation for json_error(). (check-in: 8f7ab5d921 user: drh tags: json5) | |
| 17:38 | Improvements to the accuracy of json_error(). Add the extension SQL functions random_json(SEED) and random_json5(SEED). (check-in: 8d09dc1c45 user: drh tags: json5) | |
| 14:48 | Add the json_error(X) function that returns the 1-based character offset to the first syntax error in JSON5 string X, or 0 if there are no errors. (check-in: 901ad995d5 user: drh tags: json5) | |
| 13:25 | Fix indentation and omit trailing whitespace in the random JSON generator script. (check-in: 629db09fce user: drh tags: json5) | |
| 11:02 | Fix json_tree() so that it is able to deal with the JNODE_RAW labels of a JSON5 object. (check-in: f56528d413 user: drh tags: json5) | |
| 10:23 | Merge all the latest trunk fixes and enhancements into the json5 branch. (check-in: b5ca15cfc1 user: drh tags: json5) | |
| 10:10 | Do not assert() a bad string representation in an sqlite3_value after an OOM. dbsqlfuzz c822a17a23c524a0ac7cfb203c7198209da15de8. (check-in: 91fee79a01 user: drh tags: trunk) | |
| 00:19 | In the CLI, early out from the output_quoted_string() routine if the input string is NULL. forum post 8a22c0bfa7. (check-in: 2881978d7b user: drh tags: trunk) | |
|
2023-04-27
| ||
| 23:59 | Use a new technique to detect fresh OOM faults in columnName() that does not rely on there being no OOMs prior to entry into columnName(), as [forum/forumpost/fb6811c2f9|forum post fb6811c2f9] demonstrates a technique which could cause an OOM prior to entry into columnName(). (check-in: a63346d6a0 user: drh tags: trunk) | |
| 23:44 | Remove a faulty assert() from the CLI. Forum post 726c4f7db0. (check-in: 4bbebb6bfb user: drh tags: trunk) | |
| 23:40 | Remove an ALWAYS() macro that can in fact sometimes be false. Forum post f0e872fcee. (check-in: d85880e4ed user: drh tags: trunk) | |
| 23:29 | Test cases added, and some bugs fixed. (check-in: bc84a82e4d user: drh tags: json5) | |
| 19:30 | Further optimizations to the JSON parser. (check-in: bb8f1c16f2 user: drh tags: json5) | |
| 19:13 | Faster implementation of numberic literal parsing in JSON. (check-in: 58398292e8 user: drh tags: json5) | |
| 18:28 | Add support for hexadecimal integer literals in JSON. (check-in: 85e00c9e68 user: drh tags: json5) | |
| 17:32 | All floating point literals "NaN" and "Infinity". Additional variants of these literals are available if compiled with SQLITE_EXTENDED_NAN_INF. (check-in: c13346afbe user: drh tags: json5) | |
| 16:57 | Fix handling of reverse solidus in string literals. Allow decimal points in floating point literals to occurs and the beginning or end of the mantissa. (check-in: d92a6ab287 user: drh tags: json5) | |
| 16:24 | Fix the handling of escape solidus in the JSON routines. (check-in: 676877aca2 user: drh tags: json5) | |
| 15:48 | JSON string literals may span multiple lines by escaping new line characters. (check-in: 66da4bd4a3 user: drh tags: json5) | |
| 15:11 | Allow the labels on JSON objects to be unquoted identifier names. (check-in: fb428db3f6 user: drh tags: json5) | |
| 14:38 | Performance optimization in the JSON parser. (check-in: 5a88ba743f user: drh tags: json5) | |
| 13:44 | Permit JSON5 whitespace in all contexts of objects and arrays. (check-in: 93f3ab26b5 user: drh tags: json5) | |
| 12:24 | Translate JSON5-only string literal escape sequences into the JSON equivalents. (check-in: 14e82f36ee user: drh tags: json5) | |
| 11:52 | • Edit [b35cb7458fe16390|b35cb7458f]: Edit check-in comment. (artifact: 24b8e44b97 user: drh) | |
|
2023-04-26
| ||
| 20:26 | Implement some of the JSON5 enhancements to string and numeric literals. This is an incremental check-in of work in progress. (check-in: 9508efa9d6 user: drh tags: json5) | |
| 18:23 | When changing a large integer into a floating point value, cancel the string representation. Fix for forum post 5c74a3bc4a. (check-in: 3e2da8a7e3 user: drh tags: trunk) | |
| 17:30 | Partial implementation of JSON5 numeric literal extensions. Use a switch() statement in the parser for better performance. (check-in: 78404dc370 user: drh tags: json5) | |
| 15:58 | Improvement to the way the JSON performance measure scripts work → keep the test database in the directory of the test, not in the source tree. (check-in: ac411dbdcb user: drh tags: json5) | |
| 15:19 | Work toward implementing JSON5 whitespace. Untested and incomplete. (check-in: d262c05945 user: drh tags: json5) | |
| 13:52 | Fix to the json-speed-check.sh script. (check-in: d839c9544d user: drh tags: json5) | |
| 13:25 | Add scripts for JSON performance testing. (check-in: 3051d6a7c1 user: drh tags: json5) | |
|
2023-04-25
| ||
| 21:24 | The json_valid() function only returns true for pure JSON. JSON5 (or at least that subset of JSON5 that has been so far implemented) is accepted by all routines, but json_valid() still returns false for JSON5 inputs. The new json_valid5(X) routine returns true or false if X is or is not valid JSON5. All of this is experimental and subject to change. (check-in: 5d33ab7780 user: drh tags: json5) | |
| 15:12 | If an ON clause to the left of a RIGHT JOIN is false, that does not imply that the query returns no rows. (Leaf check-in: 4011b9d340 user: drh tags: branch-3.41) | |
| 11:52 | Fixes to SQL extension functions base64() and base85(). (check-in: ab3331f41e user: drh tags: branch-3.41) | |
|
2023-04-24
| ||
| 23:14 | Allow trailing commas in objects and arrays of JSON. (check-in: 4031b231c2 user: drh tags: json5) | |
| 21:08 |
Hold the RTREE node cache open and defer writes until the very end of the
INSERT statement, | |
| 19:23 | Update the compile-time detection of architecture byte-order in the RTREE extension so that it is aligned with the latest enhancements in the core. (check-in: 122431d3a7 user: drh tags: trunk) | |
| 19:22 | • Edit [491bd51da5e20690|491bd51da5]: Move to branch mistake. Mark "Closed". Edit check-in comment. (artifact: 073696a574 user: drh) | |
| 19:14 | Mistake → branched off of the wrong branch. (Closed-Leaf check-in: 491bd51da5 user: drh tags: mistake) | |
|
2023-04-22
| ||
| 23:43 | Import fixes from trunk into the branch-3.41. (check-in: 58a1d94c59 user: drh tags: branch-3.41) | |
| 22:32 | The sqlite_stat4.idx field is case insensitive. It should work even if some entries use a different case than others. Fix for forum post 6c118daad0f1f5ef. (check-in: f097ca70b5 user: drh tags: trunk) | |
| 20:22 | Enhance the ".tables" command in the CLI so that it is able to deal gracefully with an OOM situation. (check-in: 5157fd1cf7 user: drh tags: trunk) | |
| 20:07 | The assertion-fault fix in [53a61f7423a7f057] was not quite complete. This additional change enhances it to deal with WITHOUT ROWID tables. No changes to deliverable code. (check-in: 4d5af42c65 user: drh tags: trunk) | |
| 18:58 | • Edit [f28256a96af4263c|f28256a96a]: Edit check-in comment. (artifact: aed597f4f6 user: drh) | |
| 17:41 | Add the --unsafe-testing command-line option to the CLI. Without this option, features of the CLI that are intended for testing and that might result in incorrect answers, assertion faults, and/or corrupt database files if misused are disabled. Fix for the unfounded concerns raised by 13 separate forum posts last night. (check-in: f28256a96a user: drh tags: trunk) | |
| 12:47 | Fix an incorrect assert() statement in btree.c as found by forum post d03345d572713fe6. (check-in: cd485b302c user: drh tags: trunk) | |
| 12:37 | Fix a incorrect assert() statement in the pre-update hook logic. No changes to production code. Fix for the problem reported by forum post 19b217bfe709a072. (check-in: 53a61f7423 user: drh tags: trunk) | |
| 12:11 | Fix harmless compiler warning in [1489e7f53a4863b3]. (check-in: da907dbc60 user: drh tags: trunk) | |
| 11:29 | Early out from sqlite3Prepare() following an OOM to avoid possible problems further along in the parse. Fix for the NULL pointer dereference reported by forum post 2e5131839365682a. (check-in: f35ce7c122 user: drh tags: trunk) | |
|
2023-04-21
| ||
| 15:30 | Add a new modifier to date/time functions: "subsecond". May be abbreviated as just "subsec". This modifier causes functions to try to show fractional seconds if they do not already. (check-in: 03f2a15e87 user: drh tags: subsec-modifier) | |
|
2023-04-20
| ||
| 10:40 | Fix a function declaration so that it correctly appears as private in the amalgamation. Forum post ec8c77516c. (check-in: 1864569bb9 user: drh tags: trunk) | |
|
2023-04-19
| ||
| 18:36 | Improved rebustness of the pcache tracing logic. (check-in: 0a43235b83 user: drh tags: trunk) | |
| 18:32 | Remove unreachable legacy code. (check-in: e3e7fb87d9 user: drh tags: trunk) | |
| 17:13 | Fix a segfault that could occur if a non-empty in-memory database was the destination of a backup operation from a database with a smaller page size. (check-in: d37241585c user: drh tags: branch-3.41) | |
| 17:12 | • Edit [020968f857d7b90b|020968f857]: Edit check-in comment. (artifact: 822d2b6425 user: drh) | |
| 15:39 | Do not remove pages from the cache of an in-memory database due to a failure to acquire the page due to it being larger than the maximum page size. (check-in: 551b9dacd0 user: drh tags: branch-3.41) | |
| 15:35 | Do not remove pages from the cache of an in-memory database due to a failure to acquire the page due to it being larger than the maximum page size. Fix for forum post a19bb49140. (check-in: 982b35563d user: drh tags: trunk) | |
| 14:26 | Fix ambiguity in the header comment to the sqlite3PagerUnrefNotNull() routine. No code changes. (check-in: d419e65eef user: drh tags: trunk) | |
| 13:56 | Fix a debugging printf() in pcache.c. This only comes up on custom builds. (check-in: f2d6756731 user: drh tags: trunk) | |
| 13:30 | Add pager debug tracing of truncate operations. (check-in: 0daadf3622 user: drh tags: trunk) | |
| 12:08 | Attempt to suppress harmless compiler warnings reported by forum post fc98845c06. (check-in: f6e6c5f94c user: drh tags: trunk) | |
|
2023-04-18
| ||
| 20:02 | Make use of F_BARRIERFSYNC as an alternative to F_FULLFSYNC when it is available. (Leaf check-in: 3c517ba5dc user: drh tags: barrier-fsync) | |
| 16:47 | • Edit [8b0fe63f87366103|8b0fe63f87]: Edit check-in comment. (artifact: 6a599ff230 user: drh) | |
| 16:44 | Ensure that the VACUUM command is not confused by alternative encodings when it is the first command run on new database connection. (check-in: 441f4e4a42 user: drh tags: branch-3.41) | |
| 15:21 | Ensure that the VACUUM command is not confused by alternative encodings when it is the first command run on new database connection. Forum post 09503b4d33. Problem introduced by check-in [a02da71f3a80dd8e]. (check-in: 8b0fe63f87 user: drh tags: trunk) | |
| 14:17 | Another fix to the indexed expressions in aggregate queries with GROUP BY enhancement of ticket 99378177930f87bd and implemented by check-in b9190d3da70c4171 to address a problem described by forum post f34e32d120. (check-in: c37e76104b user: drh tags: branch-3.41) | |
| 14:13 | Another fix to the indexed expressions in aggregate queries with GROUP BY enhancement of ticket [99378177930f87bd] and implemented by check-in [b9190d3da70c4171] to address a problem described by forum post f34e32d120, (check-in: 5acc3ef83e user: drh tags: trunk) | |
| 11:35 | Add the --fullsync option to speedtest1. (check-in: 960fe54c82 user: drh tags: trunk) | |
|
2023-04-14
| ||
| 17:34 | • Edit [898bfa1afd8260ea|898bfa1afd]: Edit check-in comment. (artifact: ce31d4a851 user: drh) | |
| 15:42 | Fix a typo in the aggfault.test test script. (check-in: e915bff7ad user: drh tags: branch-3.41) | |
| 10:46 | When setting the column types on a subquery, ensure that the COLFLAG_HASCOLL flag is cleared from column names from when the collating sequence name has been removed. (check-in: de61bdc9b9 user: drh tags: branch-3.41) | |
| 10:40 | When setting the column types on a subquery, ensure that the COLFLAG_HASCOLL flag is cleared from column names from when the collating sequence name has been removed. Forum post 6916dacf83. (check-in: 8d9dcd7cfd user: drh tags: trunk) | |
| 10:35 | Fix a cosmetic indentation issue. (check-in: 90deb84486 user: drh tags: trunk) | |
| 00:28 | • Edit [bb2b5ab172f0751c|bb2b5ab172]: Edit check-in comment. (artifact: bb14f0ced8 user: drh) | |
| 00:23 | Avoid double de-quoting of table names when processing RESTRICT actions in foreign key constraints. (check-in: 5af7abffe7 user: drh tags: branch-3.41) | |
| 00:20 | Avoid double de-quoting of table names when processing RESTRICT actions in foreign key constraints. Chromium 1405220. Problem introduced by [9e503e2d0428c9e8] 2009-09-28 for version 3.6.19. (check-in: bb2b5ab172 user: drh tags: trunk) | |
|
2023-04-13
| ||
| 18:49 | Fix an obscure issue with ALTER TABLE RENAME that comes up with triggers that have UPDATE statements that contain errors. (check-in: cf651dee12 user: drh tags: branch-3.41) | |
| 18:44 | Fix an obscure issue with ALTER TABLE RENAME that comes up with triggers that have UPDATE statements that contain errors. Forum post ff3840145a. (check-in: c4845a7c5f user: drh tags: trunk) | |
| 15:11 | Remove an ALWAYS() that can sometimes be false. And fix a code-generator issue associated with very unusual use of window functions. (check-in: fc12743763 user: drh tags: branch-3.41) | |
| 14:50 | Fix a code-generator issue associated with very unusual use of window functions. Both the expr.c or the window.c changes will each independently fix the problem. They are both included in this patch for defense in depth. Forum post 0d48347967. (check-in: 1ba22631a7 user: drh tags: trunk) | |
|
2023-04-12
| ||
| 20:23 | Unwrap the loop in the WAL hash function. (check-in: eb94ae1320 user: drh tags: trunk) | |
| 19:40 | Automatically set HAVE_PREAD and HAVE_PWRITE on linux, as has been done in MacOS for a long time now. (check-in: 2f7a36d2c3 user: drh tags: trunk) | |
| 18:57 | Small performance enhancement to integer-to-text conversion. (check-in: cfb3dba9b0 user: drh tags: trunk) | |
|
2023-04-11
| ||
| 19:38 | New #ifdef to enable building with -DSQLITE_OMIT_WINDOWFUNC. (check-in: e1ff83fa25 user: drh tags: trunk) | |
| 15:07 | • Edit [c8fb143d64d8e823|c8fb143d64]: Edit check-in comment. (artifact: 399295b253 user: drh) | |
| 15:06 | Remove an ALWAYS() that can sometimes be false. Add a test case that makes the test false. Forum post 6c5678e3da. (check-in: c8fb143d64 user: drh tags: trunk) | |
| 02:10 | Better handling of OOM errors in the cursor-hint logic. dbsqlfuzz 60cd5fff91974af91c2c3692beb4a2d7fdafef46 (check-in: 68fcfb58df user: drh tags: trunk) | |
|
2023-04-10
| ||
| 18:44 | New assert() statements to validate the parameters to sqlite3BtreeCursorHint(). Fix a problem with the construction of those parameters discovered by forum post 0b53708c95. (check-in: 4c5a3c5fb3 user: drh tags: trunk) | |
| 13:20 | Sync the vt02.c test virtual table with TH3, in order to pull in the fix for long delays when there are huge OFFSET values. (check-in: 49ba030080 user: drh tags: trunk) | |
|
2023-04-09
| ||
| 20:48 | Fix an assertion fault that can occur when compiling with both SQLITE_ENABLE_UNKNOWN_SQL_FUNCTIONS and SQLITE_ENABLE_STAT4. (check-in: 2b02862de6 user: drh tags: branch-3.41) | |
| 20:44 | Fix an assertion fault that can occur when compiling with both SQLITE_ENABLE_UNKNOWN_SQL_FUNCTIONS and SQLITE_ENABLE_STAT4. (check-in: 9ff69e5998 user: drh tags: trunk) | |
| 10:23 | Fix a faulty assert() in whereRangeScanEst() that should only apply if there are not prior errors. (check-in: 450d8ad85c user: drh tags: branch-3.41) | |
| 10:09 | Fix a faulty assert() in whereRangeScanEst() that should only apply if there are not prior errors. dbsqlfuzz 567ad91132879cbab8172b38c6a68ad40fa8d650. (check-in: 8ba9b08bd9 user: drh tags: trunk) | |
|
2023-04-08
| ||
| 20:07 | • Closed ticket [667014c20b]: Missed optimization when LHS of IN is an expression plus 6 other changes (artifact: 2fec6f5975 user: drh) | |
| 19:23 | Fix a typo in [83e84531b46814ae] that changed the value of SQLITE_DBCONFIG_STMT_SCANSTATUS. (check-in: b717765391 user: drh tags: trunk) | |
| 16:51 | Faster implementation of keywordCode() - the routine that determines if an identifier is really a keyword and if so, which keyword. (check-in: 0ff3d3d537 user: drh tags: trunk) | |
| 13:31 | Fix a harmless compiler warning. (check-in: c9559ba621 user: drh tags: trunk) | |
| 13:01 | Optimizations to btree.c save about 4.5 million CPU cycles: (1) Clone insertCell() into a separate insertCellFast() routine for use by sqlite3BtreeInsert(). (2) Mark allocateSpace() as always-inline. (3) Improved coalesence of adjacent free blocks in pageFreeArray(). (check-in: 5c12c400fe user: drh tags: trunk) | |
|
2023-04-07
| ||
| 18:27 | Guard against oversized cells in the newly enhanced pageFreeArray(). (Closed-Leaf check-in: 2dcdbb5035 user: drh tags: btree-freespace-opt) | |
| 16:30 | Add NEVER on an unreachable branch. (check-in: 9b3febbd98 user: drh tags: btree-freespace-opt) | |
| 15:57 | • Edit [5d7e833f25051000|5d7e833f25]: Mark "Closed". (artifact: 6715481ae7 user: drh) | |
| 15:49 | Fix an assert(). (check-in: 7eff46ba97 user: drh tags: btree-freespace-opt) | |
| 15:07 | Tweaks to the new insertCellFast(). (check-in: 203a581a91 user: drh tags: btree-freespace-opt) | |
| 14:33 | Clone insertCell() into insertCellFast() for use by sqlite3BtreeInsert() for a substantial performance increase. (check-in: f225afd90c user: drh tags: btree-freespace-opt) | |
| 13:21 | Small performance improvement in freeSpace(). (check-in: 8dc5292ee5 user: drh tags: btree-freespace-opt) | |
| 11:55 | Try to use a heap to make coalescence of adjacent free slots faster when freeing space on a btree page. Turns out that the overhead of managing the heap overwhelms any performance gain and the result is slower. (Closed-Leaf check-in: 5d7e833f25 user: drh tags: deadend) | |
|
2023-04-06
| ||
| 20:14 | Increase the size of the cache of free blocks inside of pageFreeArray() to reduce the number of calls to freeSpace(). (check-in: 27c59f1ea7 user: drh tags: btree-freespace-opt) | |
| 17:41 | Work around a harmless assertion fault associated with sqlite3VdbeMemAboutToChange() such that the detection of stale values in registers is preserved in debugging builds, but we avoid a false-positive assertion fault in cases involving a virtual table with a LIMIT clause in an IN-operator loop. (check-in: 9511d17e2a user: drh tags: branch-3.41) | |
| 17:29 | Work around a harmless assertion fault associated with sqlite3VdbeMemAboutToChange() such that the detection of stale values in registers is preserved in debugging builds, but we avoid a false-positive assertion fault in cases involving a virtual table with a LIMIT clause in an IN-operator loop. dbsqlfuzz 3fd70d4ab4950acf1deb8f610a7a7c67cd38713b (check-in: 56ea2c2fe6 user: drh tags: trunk) | |
| 15:32 | A prepared statement that aborts due to SQLITE_SCHEMA should not invalidate cursors in other prepared statements that are already running. (check-in: 4eee8401c9 user: drh tags: branch-3.41) | |
| 13:35 | A prepared statement that aborts due to SQLITE_SCHEMA should not invalidate cursors in other prepared statements that are already running. See forum post cae4367d9b for the original trouble report. (check-in: 857d0f5e16 user: drh tags: trunk) | |
| 02:26 | In the CLI, during error processing while looking for a word boundary, avoid being deceived by malformed input that has a very long sequence of 0x80 characters. Also fix a problem in the zipfile extension for when a corrupt zipfile has a zero-length filename. (check-in: 5323ee77d7 user: drh tags: branch-3.41) | |
| 01:05 | In the CLI, during error processing while looking for a word boundary, avoid being deceived by malformed input that has a very long sequence of 0x80 characters. forum post ab93a23ba1. (check-in: 82609d5a2d user: drh tags: trunk) | |
| 00:59 | In the zipfile extension, defend against corrupt ZIP files that contain a zero-length filename. Forum post b15f5e3ad8. (check-in: 46db2e42a5 user: drh tags: trunk) | |
| 00:18 | In the new .scanstatus command in the CLI, make sure the database is opened before invoking sqlite3_db_config(). Forum post 6e26dcf544. (check-in: 1cd993c45c user: drh tags: trunk) | |
|
2023-04-05
| ||
| 03:00 | Remove an ALWAYS() that can now be false due to the prior check-in. (check-in: 3bfdb4103d user: drh tags: branch-3.41) | |
| 02:55 | Add a test case for the ALWAYS() macro removed by the previous check-in. (check-in: 68a1a83749 user: drh tags: trunk) | |
| 02:50 | Remove an ALWAYS() that might now be false due to the prior check-in. (check-in: fc68993501 user: drh tags: trunk) | |
| 02:25 | Fix the function that determines the collating function for an expression tree to handle new cases that arise as a result of the recently added ability to use indexed expressions in aggregate queries. (check-in: b29dea0dae user: drh tags: branch-3.41) | |
| 02:21 | Fix the function that determines the collating function for an expression tree to handle new cases that arise as a result of the recently added ability to use indexed expressions in aggregate queries. [forum/forumpost/0713a16a44|Forum post 0713a16a44]. (check-in: cc5041f3f0 user: drh tags: trunk) | |
|
2023-04-04
| ||
| 18:59 | Fix an incorrect entry in the array that maps sqlite3_value values into actual datatype numbers. (check-in: 80d518fb82 user: drh tags: branch-3.41) | |
| 18:55 | Fix an incorrect entry in the array that maps sqlite3_value values into actual datatype numbers. dbsqlfuzz f660c659bcec48577a43d3bab37f46baaa22f59e (check-in: fa8537dc90 user: drh tags: trunk) | |
| 18:48 | Remove an assert() statement that is no longer valid due to enhancements to query planner for improved use of indexes. (check-in: 93fb8c66c5 user: drh tags: branch-3.41) | |
| 18:10 | Remove an assert() statement that is no longer valid due to enhancements to query planner for improved use of indexes. Forum post dc16ec63d3. (check-in: 2b23dd249d user: drh tags: trunk) | |
|
2023-04-03
| ||
| 23:55 | When translating arguments of aggregate functions into references to expression indexes, make sure to only translate them for the current aggregate when there are nested aggregates. (check-in: 7ea98aba78 user: drh tags: branch-3.41) | |
| 23:49 | When translating arguments of aggregate functions into references to expression indexes, make sure to only translate them for the current aggregate when there are nested aggregates. Forum post 409ebc7368. (check-in: 898bfa1afd user: drh tags: trunk) | |
| 20:11 | Improved diagnostic output from PRAGMA vdbe_addoptrace. (check-in: 050958c182 user: drh tags: trunk) | |
| 18:00 | When changing a COLLATE expression node into TK_AGG_COLUMN because the nodes value is contained in an indexed expression, be sure to clear the EP_Collate property from the expression node. (check-in: af0f55cfcb user: drh tags: branch-3.41) | |
| 17:46 | When changing a COLLATE expression node into TK_AGG_COLUMN because the nodes value is contained in an indexed expression, be sure to clear the EP_Collate property from the expression node. Fix for the assertion faults reported by forum post e45108732c and forum post 44270909bb. (check-in: cf6454ce26 user: drh tags: trunk) | |
| 15:01 | Add the SQLITE_VTAB_USES_ALL_SCHEMAS option to sqlite3_vtab_config(). Update the sqlite_dbpage, sqlite_dbdata, and sqlite_dbptr virtual tables to make use of that interface. This was formerly handled by the internal sqlite3VtabUsesAllSchemas() routine that was called directly from sqlite_dbpage. But since sqlite_dbdata and sqlite_dbptr are an extension, an external interface to that functionality had to be provided. dbsqlfuzz 1a29c245175a63393b6a78c5b8cab5199939d6a8 (check-in: bcd51abee0 user: drh tags: trunk) | |
| 12:48 | Make the sqlite_dbdata and sqlite3_dbptr virtual tables accessible to the CLI. (check-in: c0eff02854 user: drh tags: trunk) | |
| 12:45 | Stronger constraint checking in allocateSpace(). (check-in: 0f9e65b6c1 user: drh tags: branch-3.41) | |
| 12:33 | Stronger constraint checking in allocateSpace(). dbsqlfuzz 93d4c9ff5ef7cd29f16e767af1ee71c29ec5a4c0 (check-in: 9e968f4fbc user: drh tags: trunk) | |
|
2023-04-02
| ||
| 20:56 | With the -DSQLITE_ENABLE_JSON_NAN_INF compile-time option, non-standard JSON numeric values "Inf", "Infinity", "-Inf", "-Infinity", "NaN", "QNaN", and "SNaN" are all accepted. SQLite should never generate these values, but it will accept that with the appropriate compile-time option. (check-in: 0a050e9013 user: drh tags: trunk) | |
| 20:46 | More off-by-one errors in the new JSON parsing. (Closed-Leaf check-in: dbc9966208 user: drh tags: json-nan-inf) | |
| 20:27 | Fix an off-by-one error in the recognition of -Infinity. (check-in: f7ebf3e628 user: drh tags: json-nan-inf) | |
| 18:49 | Earlier detection of corruption in sqlite3BtreeDelete(). dbsqlfuzz a4c48c291d6e40157a1b749a05eaa7c7faf5a625. (check-in: 728633c0bd user: drh tags: branch-3.41) | |
| 16:43 | Earlier detection of corruption in sqlite3BtreeDelete(). dbsqlfuzz a4c48c291d6e40157a1b749a05eaa7c7faf5a625. (check-in: 978dc71c38 user: drh tags: trunk) | |
|
2023-04-01
| ||
| 23:29 | Allow special floating-point value names in JSON: "inf", "-inf", "infinity", "-infinity", "nan", "qnan", and "snan". All are converted into valid JSON values: 9e999, -9e999, or null. Requires the SQLITE_ENABLE_JSON_NAN_INF compile-time option to operate. (check-in: fc8793e5ac user: drh tags: json-nan-inf) | |
| 15:51 | Fix harmless compiler warnings. (check-in: a4fb2864fe user: drh tags: trunk) | |
| 13:14 | Improved error messages from PRAGMA integrity_check. Identify the root of the tree when a problem is found in a b-tree, making it easier to track the problem to a specific table or index. (check-in: a1cb152e69 user: drh tags: trunk) | |
| 12:22 | In the b-tree module use %u instead of %d to print unsigned quantities such as page numbers and offsets. (check-in: 33ac62d8ee user: drh tags: trunk) | |