Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for test/json101.test
2025-07-02
| ||
20:46 | [cf53254f0f] part of check-in [1c1aef2b7f] Merge in the exists-to-join optimization that has been modified to relax the requirement of having an indexed join constraint. (check-in: [1c1aef2b7f] user: drh branch: empty-table-optimizations, size: 36604) | |
2025-05-24
| ||
20:20 | [8237a484c2] part of check-in [28215d131c] Change json_group_object() so that it ignores entries where the label is NULL. Forum post e5bd251fb5. (check-in: [28215d131c] user: drh branch: trunk, size: 36580) | |
2025-04-10
| ||
10:18 | [11024e20fe] part of check-in [20acd630b9] Remove unnecessary "www." prefixes on domain names in URLs. (check-in: [20acd630b9] user: drh branch: trunk, size: 36589) | |
2024-02-16
| ||
21:30 | [30db5b055b] part of check-in [1c33c5db2e] Fix the subtype on the value column from json_each/json_tree for cases when the value is an array or object. Fix for the bug reported by forum post ecb94cd210. (check-in: [1c33c5db2e] user: drh branch: trunk, size: 36601) | |
2023-11-30
| ||
16:17 | [70587d7d35] part of check-in [04c0d56443] Simplification of the new JSON insert/set test cases. (check-in: [04c0d56443] user: drh branch: jsonb-insert, size: 36081) | |
16:16 | [4d8faf6a77] part of check-in [6802b6459d] New JSON test cases showing insert or set with missing substructure. (check-in: [6802b6459d] user: drh branch: trunk, size: 31525) | |
12:04 | [861a5d75c2] part of check-in [146c717c51] New test cases for insert/set/replace with paths that indicate substructure that does not yet exist. (check-in: [146c717c51] user: drh branch: jsonb-insert, size: 36157) | |
2023-11-28
| ||
20:25 | [8f5d1a3350] part of check-in [8c324af1ec] Attempt to get json_extract() working with pure JSONB only, and without the use of JsonNode. Mostly working, but there are some differences from legacy in corner cases. (check-in: [8c324af1ec] user: drh branch: jsonb-extract, size: 34872) | |
2023-11-27
| ||
15:57 | [643936557d] part of check-in [a4e19ad43d] Give the json_valid() function an optional second argument that determines what is meant by "valid". (check-in: [a4e19ad43d] user: drh branch: jsonb, size: 34876) | |
12:30 | [19f9abc77c] part of check-in [b5a5660ca2] All tests passing. (check-in: [b5a5660ca2] user: drh branch: jsonb-tree, size: 34874) | |
2023-10-19
| ||
20:46 | [2420fbed1d] part of check-in [f47a8d0a20] Merge recent trunk enhancements into the jsonb branch. (check-in: [f47a8d0a20] user: drh branch: jsonb, size: 34874) | |
2023-10-17
| ||
13:41 | [bc05d2476f] part of check-in [e5099c549a] 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: [e5099c549a] user: drh branch: trunk, size: 30317) | |
2023-10-11
| ||
17:24 | [1ad070e561] part of check-in [d3c0cbb909] 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: [d3c0cbb909] user: drh branch: trunk, size: 29930) | |
17:21 | [8e7ee64714] part of check-in [fc5ee9e51a] 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: [fc5ee9e51a] user: drh branch: jsonb, size: 34488) | |
2023-10-09
| ||
12:57 | [abb5a0cfde] part of check-in [9422c24f4a] Merge the latest trunk fixes and enhancements into the jsonb branch, and especially the JSON cache spill UAF fix. (check-in: [9422c24f4a] user: drh branch: jsonb, size: 34364) | |
12:46 | [4d78048b18] part of check-in [a163fecca9] Fix a potential UAF caused by JSON parser cache spill. Forum post b25edc1d46. (check-in: [a163fecca9] user: drh branch: trunk, size: 29806) | |
2023-10-02
| ||
14:51 | [e8ccd09f96] part of check-in [d624c31e5c] New test cases for JSONB. (check-in: [d624c31e5c] user: drh branch: jsonb, size: 33804) | |
13:35 | [54b27bd681] part of check-in [95eb7b37fa] Allow json_replace() to accept JSONB arguments as the new value. (check-in: [95eb7b37fa] user: drh branch: jsonb, size: 31516) | |
13:20 | [da33cc6d11] part of check-in [14f20ecbfa] Improvements to error handling for BLOB inputs on JSON. (check-in: [14f20ecbfa] user: drh branch: jsonb, size: 31274) | |
12:40 | [728d90ecd6] part of check-in [c352201b8c] Gather forward references into a single place for the JSON code. Allow JSONB arguments to json_array() and json_object() and similar. (check-in: [c352201b8c] user: drh branch: jsonb, size: 31140) | |
2023-08-17
| ||
15:14 | [dc9d5a2a5b] part of check-in [af56d7b6b9] Have all test names in json101.test start with "json101". (check-in: [af56d7b6b9] user: dan branch: trunk, size: 29249) | |
2023-08-11
| ||
11:24 | [243b0a2650] part of check-in [c5daae8861] Fix bug in the test case for the previous check-in. (check-in: [c5daae8861] user: drh branch: legacy-json-valid, size: 28658) | |
11:12 | [c98eca791d] part of check-in [15c2eadbff] Up until version 3.42.0, there was a bug in json_valid() such that it would return False (0) for a NULL input. That bug is fixed in 3.42.0. This check-in adds a compile-time option -DSQLITE_LEGACY_JSON_VALID that restores the old buggy behavior for applications that depend on it. (check-in: [15c2eadbff] user: drh branch: legacy-json-valid, size: 28657) | |
2023-05-05
| ||
15:52 | [94126d4291] part of check-in [c7697a0d45] Reduce the maximum depth of nesting in json objects to 1000. (check-in: [c7697a0d45] user: dan branch: trunk, size: 28454) | |
2023-05-02
| ||
11:12 | [ff8024cbb8] part of check-in [ab78e6946b] Improved handling of NULL arguments to json_valid() and json_error_position(). Forum post 06c6334412. (check-in: [ab78e6946b] user: drh branch: trunk, size: 28454) | |
2023-04-30
| ||
19:34 | [211d756387] part of check-in [34c4e900a9] 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 branch: json5, size: 26192) | |
2023-04-26
| ||
15:19 | [de9c93169b] part of check-in [d262c05945] Work toward implementing JSON5 whitespace. Untested and incomplete. (check-in: [d262c05945] user: drh branch: json5, size: 26142) | |
2023-04-24
| ||
23:14 | [7241ab038c] part of check-in [4031b231c2] Allow trailing commas in objects and arrays of JSON. (check-in: [4031b231c2] user: drh branch: json5, size: 25908) | |
2023-03-17
| ||
20:31 | [c7707ee623] part of check-in [efce4690a5] Fix json rendering so that it shows positive and negative infinity as 9.0e+999 and -9.0e+999 respectively. (check-in: [efce4690a5] user: drh branch: numeric-only-json, size: 25602) | |
2022-08-30
| ||
00:11 | [9f6337e742] part of check-in [5c95ae6c9b] Any function call can abort. Take this into account when deciding if a DML statement needs a statement journal. See forum thread 9b9e4716c0d7bbd1 for more information. (check-in: [5c95ae6c9b] user: drh branch: trunk, size: 25275) | |
2022-04-04
| ||
14:24 | [9d46b8e254] part of check-in [84fe95d2a5] Fix the JSON Path parser so that it will accept zero-length object labels. Forum thread c082aeab43. (check-in: [84fe95d2a5] user: drh branch: trunk, size: 24753) | |
2022-01-30
| ||
11:42 | [d7c84854ac] part of check-in [d4e402458d] Remove a faulty NEVER(). Fix for dbsqlfuzz 4678cf825d27f87c9b8343720121e12cf944b71a (check-in: [d4e402458d] user: drh branch: trunk, size: 24222) | |
2020-07-29
| ||
16:18 | [663daf9a6a] part of check-in [a80ae2c98b] Dozens and dozens of typo fixes in comments. This change adds no value to the end product and is disruptive, so it is questionable whether or not it will ever land on trunk. (check-in: [a80ae2c98b] user: drh branch: typos, size: 23994) | |
2019-11-10
| ||
11:09 | [bb71538005] part of check-in [51027f08c0] Proper surrogate pair decoding added to JSON functions. See the mailing list bug report and https://bugs.python.org/issue38749. More test cases needed here, but it seems to work so far. (check-in: [51027f08c0] user: drh branch: trunk, size: 23995) | |
2018-12-03
| ||
01:47 | [8f8977b00b] part of check-in [58a51123d1] Fix a parser bug in the use of parentheses around table-valued functions. (check-in: [58a51123d1] user: drh branch: trunk, size: 23630) | |
2018-05-16
| ||
12:19 | [b40a9f5395] part of check-in [b45b18850c] Correct output for the fullkey column of json_each() when the total JSON input is a simple value, not an array or object. (check-in: [b45b18850c] user: drh branch: trunk, size: 22890) | |
2018-01-26
| ||
22:41 | [24e97954e3] part of check-in [7daa687340] Fix the query planner so that it takes into account dependencies in the arguments to table-valued functions in subexpressions in the WHERE clause. Fix for ticket [80177f0c226ff54f6dd]. (check-in: [7daa687340] user: drh branch: trunk, size: 22156) | |
2017-10-27
| ||
12:27 | [d7cdf3e673] part of check-in [8d3cc928a8] Additional test case demonstrating the ability to access structure elements using quoted names in the JSON1 extension. (check-in: [8d3cc928a8] user: drh branch: trunk, size: 21084) | |
2017-04-13
| ||
00:12 | [2bd3703a85] part of check-in [8e7b611863] Fix a regression caused by the fix for ticket [6c9b5514077fed34551f98e64c09a1] - control characters allowed in JSON. (check-in: [8e7b611863] user: drh branch: trunk, size: 19629) | |
2017-04-11
| ||
18:55 | [9e68ac5c7c] part of check-in [1f68c18459] Limit the depth of recursion for valid JSON in the JSON1 extension in order to avoid using excess stack space in the recursive descent parser. Fix for ticket [981329adeef51011052667a9]. (check-in: [1f68c18459] user: drh branch: trunk, size: 19391) | |
2016-11-07
| ||
13:37 | [c0897616f3] part of check-in [7a63539169] Fix the JSON1 extension so that the JSON validator correctly rejects malformed backslash escapes within string literals. (check-in: [7a63539169] user: drh branch: trunk, size: 18584) | |
2016-06-17
| ||
13:01 | [865776ed85] part of check-in [2c3714aebf] Add the json_quote() function to the JSON1 extension. (check-in: [2c3714aebf] user: drh branch: json_quote, size: 11839) | |
2016-02-04
| ||
10:28 | [ef42283f0b] part of check-in [4f1b5229a3] Escape control characters in JSON. Fix for ticket [ad2559db380abf8]. (check-in: [4f1b5229a3] user: drh branch: trunk, size: 11044) | |
2015-10-16
| ||
15:16 | [f0178422b3] part of check-in [28957d6359] Form-feed is not valid whitespace for json. Fix for ticket [57eec374ae1d0a1d] (check-in: [28957d6359] user: drh branch: trunk, size: 10384) | |
2015-10-08
| ||
23:37 | [83e6ebfb3c] part of check-in [2928f8e87d] Json1 tests are working. Builds without FTS5 enabled. Still some problems building with FTS5. (check-in: [2928f8e87d] user: drh branch: amalg-json1-fts5, size: 9887) | |
2015-09-24
| ||
11:06 | [e8b50fbcdb] part of check-in [a4444c0f66] Fix a JSON1 test case so that it works on builds that omit virtual tables. (check-in: [a4444c0f66] user: drh branch: trunk, size: 9872) | |
2015-09-23
| ||
01:10 | [07f0d847d9] part of check-in [7c7a3f3e9b] Do not allow a comma at the end of a JSON array or object. (check-in: [7c7a3f3e9b] user: drh branch: trunk, size: 9805) | |
2015-09-22
| ||
00:21 | [bfc81e4bdb] part of check-in [0f16041647] Fix json_set() so that it can overwrite a value that was previously overwritten during the same call. (check-in: [0f16041647] user: drh branch: trunk, size: 9511) | |
2015-09-19
| ||
18:54 | [b33f388827] part of check-in [394b81b11f] Fix a memory leak in json1.c that could occur after misuse of json_object(). (check-in: [394b81b11f] user: drh branch: trunk, size: 9378) | |
2015-09-11
| ||
00:06 | [e20d2421c5] part of check-in [8a80d6459e] Take out the goofy '$$' path syntax. Instead, use subtypes to communicate when a string is JSON. Add the json() function that validates and minifies the JSON and sets the appropriate subtype. (check-in: [8a80d6459e] user: drh branch: subtypes, size: 9318) | |
2015-08-29
| ||
18:30 | [11535d8986] part of check-in [daff4832af] New test cases for the json1 extension. (check-in: [daff4832af] user: drh branch: trunk, size: 8729) | |
16:02 | [ef8fb3ac6a] part of check-in [fd19ff029f] Do not consider an empty string to be valid JSON. Add some additional JSON test cases. (check-in: [fd19ff029f] user: drh branch: trunk, size: 4281) | |
2015-08-28
| ||
03:48 | [420fe3917c] part of check-in [64abb65d4d] Add the json_check() function, which returns its argument if the argument is well-formed JSON or which throws an error otherwise. (check-in: [64abb65d4d] user: drh branch: trunk, size: 2904) | |
03:33 | [5dfb181790] part of check-in [44f103d886] Enhance the json_insert(), json_replace(), and json_set() functions with the ability to add JSON instead of text if the argument is text and if the PATH begins with '$$' instead of just '$'. (check-in: [44f103d886] user: drh branch: trunk, size: 2733) | |
2015-08-21
| ||
20:37 | Renamed test/json1.test → test/json101.test. [950ed4e8de] part of check-in [9ff6ccde5f] Fixes for compiler warnings and errors in the makefiles. Rename the one test script to json101.test. (check-in: [9ff6ccde5f] user: drh branch: json, size: 2283) | |