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: e18c0899 user: drh tags: json5) | |
| 20:37 | Accept the full ECMAScript 5.1 IdentifyName syntax for keys in objects. (check-in: 9be2c875 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: fb551145 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: 34c4e900 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: 30d12ede user: drh tags: json5) | |
| 17:35 | More ALWAYS() macros. (check-in: 770b09f7 user: drh tags: json5) | |
| 17:13 | Add ALWAYS macros on unreachable branches in the new JSON5 logic. (check-in: 91e15ed9 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: 01ee613c user: drh tags: json5) | |
| 16:00 | Do not allow leading zeros on non-zero numeric literals in JSON. (check-in: 3e914943 user: drh tags: json5) | |
| 12:13 | Minor fixes to to the JSON% parser. (check-in: 2fe684cd user: drh tags: json5) | |
| 00:59 | Correctly recognize an isolated U+feff as a space character in JSON5. (check-in: 4473dc8e user: drh tags: json5) | |
|
2023-04-28
| ||
| 23:38 | Bug fixes in the logic to skip over JSON5 comments. (check-in: c736b77a user: drh tags: json5) | |
| 23:19 | Bug fix in the offset computation for json_error(). (check-in: 8f7ab5d9 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: 8d09dc1c 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: 901ad995 user: drh tags: json5) | |
| 13:25 | Fix indentation and omit trailing whitespace in the random JSON generator script. (check-in: 629db09f 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: f56528d4 user: drh tags: json5) | |
| 10:23 | Merge all the latest trunk fixes and enhancements into the json5 branch. (check-in: b5ca15cf user: drh tags: json5) | |
| 10:10 | Do not assert() a bad string representation in an sqlite3_value after an OOM. dbsqlfuzz c822a17a23c524a0ac7cfb203c7198209da15de8. (check-in: 91fee79a 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: 2881978d 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: a63346d6 user: drh tags: trunk) | |
| 23:44 | Remove a faulty assert() from the CLI. Forum post 726c4f7db0. (check-in: 4bbebb6b user: drh tags: trunk) | |
| 23:40 | Remove an ALWAYS() macro that can in fact sometimes be false. Forum post f0e872fcee. (check-in: d85880e4 user: drh tags: trunk) | |
| 23:29 | Test cases added, and some bugs fixed. (check-in: bc84a82e user: drh tags: json5) | |
| 19:30 | Further optimizations to the JSON parser. (check-in: bb8f1c16 user: drh tags: json5) | |
| 19:13 | Faster implementation of numberic literal parsing in JSON. (check-in: 58398292 user: drh tags: json5) | |
| 18:28 | Add support for hexadecimal integer literals in JSON. (check-in: 85e00c9e 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: c13346af 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: d92a6ab2 user: drh tags: json5) | |
| 16:24 | Fix the handling of escape solidus in the JSON routines. (check-in: 676877ac user: drh tags: json5) | |
| 15:48 | JSON string literals may span multiple lines by escaping new line characters. (check-in: 66da4bd4 user: drh tags: json5) | |
| 15:11 | Allow the labels on JSON objects to be unquoted identifier names. (check-in: fb428db3 user: drh tags: json5) | |
| 14:38 | Performance optimization in the JSON parser. (check-in: 5a88ba74 user: drh tags: json5) | |
| 13:44 | Permit JSON5 whitespace in all contexts of objects and arrays. (check-in: 93f3ab26 user: drh tags: json5) | |
| 12:24 | Translate JSON5-only string literal escape sequences into the JSON equivalents. (check-in: 14e82f36 user: drh tags: json5) | |
| 11:52 | • Edit [b35cb7458fe16390|b35cb745]: Edit check-in comment. (artifact: 24b8e44b 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: 9508efa9 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: 3e2da8a7 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: 78404dc3 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: ac411dbd user: drh tags: json5) | |
| 15:19 | Work toward implementing JSON5 whitespace. Untested and incomplete. (check-in: d262c059 user: drh tags: json5) | |
| 13:52 | Fix to the json-speed-check.sh script. (check-in: d839c954 user: drh tags: json5) | |
| 13:25 | Add scripts for JSON performance testing. (check-in: 3051d6a7 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: 5d33ab77 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: 4011b9d3 user: drh tags: branch-3.41) | |
| 11:52 | Fixes to SQL extension functions base64() and base85(). (check-in: ab3331f4 user: drh tags: branch-3.41) | |
|
2023-04-24
| ||
| 23:14 | Allow trailing commas in objects and arrays of JSON. (check-in: 4031b231 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: 122431d3 user: drh tags: trunk) | |
| 19:22 | • Edit [491bd51da5e20690|491bd51d]: Move to branch mistake. Mark "Closed". Edit check-in comment. (artifact: 073696a5 user: drh) | |
| 19:14 | Mistake → branched off of the wrong branch. (Closed-Leaf check-in: 491bd51d user: drh tags: mistake) | |
|
2023-04-22
| ||
| 23:43 | Import fixes from trunk into the branch-3.41. (check-in: 58a1d94c 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: f097ca70 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: 5157fd1c 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: 4d5af42c user: drh tags: trunk) | |
| 18:58 | • Edit [f28256a96af4263c|f28256a9]: Edit check-in comment. (artifact: aed597f4 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: f28256a9 user: drh tags: trunk) | |
| 12:47 | Fix an incorrect assert() statement in btree.c as found by forum post d03345d572713fe6. (check-in: cd485b30 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: 53a61f74 user: drh tags: trunk) | |
| 12:11 | Fix harmless compiler warning in [1489e7f53a4863b3]. (check-in: da907dbc 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: f35ce7c1 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: 03f2a15e 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: 1864569b user: drh tags: trunk) | |
|
2023-04-19
| ||
| 18:36 | Improved rebustness of the pcache tracing logic. (check-in: 0a43235b user: drh tags: trunk) | |
| 18:32 | Remove unreachable legacy code. (check-in: e3e7fb87 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: d3724158 user: drh tags: branch-3.41) | |
| 17:12 | • Edit [020968f857d7b90b|020968f8]: Edit check-in comment. (artifact: 822d2b64 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: 551b9dac 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: 982b3556 user: drh tags: trunk) | |
| 14:26 | Fix ambiguity in the header comment to the sqlite3PagerUnrefNotNull() routine. No code changes. (check-in: d419e65e user: drh tags: trunk) | |
| 13:56 | Fix a debugging printf() in pcache.c. This only comes up on custom builds. (check-in: f2d67567 user: drh tags: trunk) | |
| 13:30 | Add pager debug tracing of truncate operations. (check-in: 0daadf36 user: drh tags: trunk) | |
| 12:08 | Attempt to suppress harmless compiler warnings reported by forum post fc98845c06. (check-in: f6e6c5f9 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: 3c517ba5 user: drh tags: barrier-fsync) | |
| 16:47 | • Edit [8b0fe63f87366103|8b0fe63f]: Edit check-in comment. (artifact: 6a599ff2 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: 441f4e4a 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: 8b0fe63f 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: c37e7610 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: 5acc3ef8 user: drh tags: trunk) | |
| 11:35 | Add the --fullsync option to speedtest1. (check-in: 960fe54c user: drh tags: trunk) | |
|
2023-04-14
| ||
| 17:34 | • Edit [898bfa1afd8260ea|898bfa1a]: Edit check-in comment. (artifact: ce31d4a8 user: drh) | |
| 15:42 | Fix a typo in the aggfault.test test script. (check-in: e915bff7 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: de61bdc9 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: 8d9dcd7c user: drh tags: trunk) | |
| 10:35 | Fix a cosmetic indentation issue. (check-in: 90deb844 user: drh tags: trunk) | |
| 00:28 | • Edit [bb2b5ab172f0751c|bb2b5ab1]: Edit check-in comment. (artifact: bb14f0ce user: drh) | |
| 00:23 | Avoid double de-quoting of table names when processing RESTRICT actions in foreign key constraints. (check-in: 5af7abff 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: bb2b5ab1 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: cf651dee 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: c4845a7c 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: fc127437 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: 1ba22631 user: drh tags: trunk) | |
|
2023-04-12
| ||
| 20:23 | Unwrap the loop in the WAL hash function. (check-in: eb94ae13 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: 2f7a36d2 user: drh tags: trunk) | |
| 18:57 | Small performance enhancement to integer-to-text conversion. (check-in: cfb3dba9 user: drh tags: trunk) | |
|
2023-04-11
| ||
| 19:38 | New #ifdef to enable building with -DSQLITE_OMIT_WINDOWFUNC. (check-in: e1ff83fa user: drh tags: trunk) | |
| 15:07 | • Edit [c8fb143d64d8e823|c8fb143d]: Edit check-in comment. (artifact: 399295b2 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: c8fb143d user: drh tags: trunk) | |
| 02:10 | Better handling of OOM errors in the cursor-hint logic. dbsqlfuzz 60cd5fff91974af91c2c3692beb4a2d7fdafef46 (check-in: 68fcfb58 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: 4c5a3c5f 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: 49ba0300 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: 2b02862d 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: 9ff69e59 user: drh tags: trunk) | |
| 10:23 | Fix a faulty assert() in whereRangeScanEst() that should only apply if there are not prior errors. (check-in: 450d8ad8 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: 8ba9b08b user: drh tags: trunk) | |
|
2023-04-08
| ||
| 20:07 | • Closed ticket [667014c2]: Missed optimization when LHS of IN is an expression plus 6 other changes (artifact: 2fec6f59 user: drh) | |
| 19:23 | Fix a typo in [83e84531b46814ae] that changed the value of SQLITE_DBCONFIG_STMT_SCANSTATUS. (check-in: b7177653 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: 0ff3d3d5 user: drh tags: trunk) | |
| 13:31 | Fix a harmless compiler warning. (check-in: c9559ba6 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: 5c12c400 user: drh tags: trunk) | |
|
2023-04-07
| ||
| 18:27 | Guard against oversized cells in the newly enhanced pageFreeArray(). (Closed-Leaf check-in: 2dcdbb50 user: drh tags: btree-freespace-opt) | |
| 16:30 | Add NEVER on an unreachable branch. (check-in: 9b3febbd user: drh tags: btree-freespace-opt) | |
| 15:57 | • Edit [5d7e833f25051000|5d7e833f]: Mark "Closed". (artifact: 6715481a user: drh) | |
| 15:49 | Fix an assert(). (check-in: 7eff46ba user: drh tags: btree-freespace-opt) | |
| 15:07 | Tweaks to the new insertCellFast(). (check-in: 203a581a user: drh tags: btree-freespace-opt) | |
| 14:33 | Clone insertCell() into insertCellFast() for use by sqlite3BtreeInsert() for a substantial performance increase. (check-in: f225afd9 user: drh tags: btree-freespace-opt) | |
| 13:21 | Small performance improvement in freeSpace(). (check-in: 8dc5292e 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: 5d7e833f 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: 27c59f1e 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: 9511d17e 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: 56ea2c2f 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: 4eee8401 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: 857d0f5e 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: 5323ee77 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: 82609d5a 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: 46db2e42 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: 1cd993c4 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: 3bfdb410 user: drh tags: branch-3.41) | |
| 02:55 | Add a test case for the ALWAYS() macro removed by the previous check-in. (check-in: 68a1a837 user: drh tags: trunk) | |
| 02:50 | Remove an ALWAYS() that might now be false due to the prior check-in. (check-in: fc689935 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: b29dea0d 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: cc5041f3 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: 80d518fb 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: fa8537dc 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: 93fb8c66 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: 2b23dd24 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: 7ea98aba 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: 898bfa1a user: drh tags: trunk) | |
| 20:11 | Improved diagnostic output from PRAGMA vdbe_addoptrace. (check-in: 050958c1 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: af0f55cf 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: cf6454ce 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: bcd51abe user: drh tags: trunk) | |
| 12:48 | Make the sqlite_dbdata and sqlite3_dbptr virtual tables accessible to the CLI. (check-in: c0eff028 user: drh tags: trunk) | |
| 12:45 | Stronger constraint checking in allocateSpace(). (check-in: 0f9e65b6 user: drh tags: branch-3.41) | |
| 12:33 | Stronger constraint checking in allocateSpace(). dbsqlfuzz 93d4c9ff5ef7cd29f16e767af1ee71c29ec5a4c0 (check-in: 9e968f4f 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: 0a050e90 user: drh tags: trunk) | |
| 20:46 | More off-by-one errors in the new JSON parsing. (Closed-Leaf check-in: dbc99662 user: drh tags: json-nan-inf) | |
| 20:27 | Fix an off-by-one error in the recognition of -Infinity. (check-in: f7ebf3e6 user: drh tags: json-nan-inf) | |
| 18:49 | Earlier detection of corruption in sqlite3BtreeDelete(). dbsqlfuzz a4c48c291d6e40157a1b749a05eaa7c7faf5a625. (check-in: 728633c0 user: drh tags: branch-3.41) | |
| 16:43 | Earlier detection of corruption in sqlite3BtreeDelete(). dbsqlfuzz a4c48c291d6e40157a1b749a05eaa7c7faf5a625. (check-in: 978dc71c 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: fc8793e5 user: drh tags: json-nan-inf) | |
| 15:51 | Fix harmless compiler warnings. (check-in: a4fb2864 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: a1cb152e 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: 33ac62d8 user: drh tags: trunk) | |