SQLite

All files named ”test/json102.test”
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

History for test/json102.test

2024-11-26
23:30
[9b2e5ada10] part of check-in [f1cb1a815a] New test cases. (check-in: [f1cb1a815a] user: drh branch: two-argument-iif, size: 28922)
2024-05-21
11:11
[4b3a0f9453] part of check-in [de8182cf17] Fix the -> and ->> operators so that when the RHS is a string that looks like a number, it is still treated as a string, because that is what PG does. Forum post 9e52cdfe15c3926e. (check-in: [de8182cf17] user: drh branch: trunk, size: 27881)
2023-10-02
23:56
[557a46e16d] part of check-in [6d4aeff575] New test cases for JSONB. (check-in: [6d4aeff575] user: drh branch: jsonb, size: 27012)
20:16
[d89476e2fb] part of check-in [54197149b8] Fix jsonb_insert() so that it does not behave like jsonb_set(). New test cases added. (check-in: [54197149b8] user: drh branch: jsonb, size: 18916)
2023-08-30
18:19
[4c69694773] part of check-in [69a635958a] Fix a bug in json_array_length() introduced in version 3.43.0 by check-in [df099ad713011b67]. If the JSON input comes from json_remove(), the removed array entries are still counted as part of the array length. Bug report in forum post 0560d5e482. (check-in: [69a635958a] user: drh branch: trunk, size: 14063)
2023-08-04
13:19
[24f6f204f9] part of check-in [ba7a66db13] Fix a bug in the jsonLookup() routine used to search JSON. Bug was introduced by the recent (unreleased) JSON caching enhancements check-in [a4c1af616e672a0d] merged into trunk at [df099ad713011b67]. (check-in: [ba7a66db13] user: drh branch: trunk, size: 13962)
2023-04-30
19:34
[13dc9e7b7f] 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: 13331)
2023-04-29
16:00
[3bdf097757] part of check-in [3e91494390] Do not allow leading zeros on non-zero numeric literals in JSON. (check-in: [3e91494390] user: drh branch: json5, size: 13319)
2023-04-26
17:30
[1f61f469d7] part of check-in [78404dc370] Partial implementation of JSON5 numeric literal extensions. Use a switch() statement in the parser for better performance. (check-in: [78404dc370] user: drh branch: json5, size: 13319)
2022-01-30
11:44
[327e77275f] part of check-in [8c9f350182] Always enable all JSON tests, now that JSON is included by default. (check-in: [8c9f350182] user: drh branch: trunk, size: 13612)
2022-01-10
15:43
[86edc7d283] part of check-in [39eff3b9bf] Implement the new PG-compliant versions of the -> and ->> operators. (check-in: [39eff3b9bf] user: drh branch: json-in-core, size: 13657)
2022-01-07
17:26
[a44a20b7df] part of check-in [85f8170555] Reverse the meaningn of -> and ->>. ->> raises an error on invalid JSON but -> does not. This allows ->> to behave the same as PG and MySQL. (check-in: [85f8170555] user: drh branch: json-enhancements, size: 13212)
17:14
[94a91c6ba5] part of check-in [b4c8a62381] Change the -> operator to use json_extract(). The ->> operator continues to use json_nextract(). (check-in: [b4c8a62381] user: drh branch: json-enhancements, size: 13212)
17:08
[40a408ffbb] part of check-in [dc00f5286d] New json_nextract() function that works like json_extract() except that it returns NULL instead of raising an error if the first argument is not well-formed JSON. Or if the first argument is not well-formed JSON and the second argument is '$', then return the first argument quoted. The "->" and "->>" operators are converted to use json_nextract(). (check-in: [dc00f5286d] user: drh branch: json-enhancements, size: 13130)
16:03
[c0c45152f5] part of check-in [ed9956f5dd] Add the json_ntype() SQL function. Works like the 1-argument json_type() except that it returns NULL if the argument is not well-formed JSON, rather than raising an error. (check-in: [ed9956f5dd] user: drh branch: json-enhancements, size: 12572)
15:47
[8ee925a282] part of check-in [d15410900d] Accept abbreviated JSON Paths on the right-hand side of the -> and ->> operators. (check-in: [d15410900d] user: drh branch: json-enhancements, size: 12316)
2017-04-10
12:31
[eeb54efa22] part of check-in [6ee12221fa] Add a new JSON test case to verify that all control characters are escaped in the json_quote() function. (check-in: [6ee12221fa] user: drh branch: trunk, size: 11470)
12:25
[0eacdde669] part of check-in [475d8f82ec] Change the JSON extension so that it disallows control characters inside of strings. Fix for ticket [6c9b5514077fed34551f98e64c09a10dc2fc8e16]. (check-in: [475d8f82ec] user: drh branch: trunk, size: 11239)
2017-04-08
18:18
[de1728e8ff] part of check-in [204e72f008] Disallow leading zeros on numeric constants in JSON. Fix for ticket [b93be8729a895a528e2] (check-in: [204e72f008] user: drh branch: trunk, size: 10774)
2015-10-08
23:37
[bf3fe7a706] 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: 9655)
2015-09-19
11:57
[796b1c5989] part of check-in [d2a027372a] Fix an off-by-one error (really off-by-2 in this case) in the buffer resize logic of json1. (check-in: [d2a027372a] user: drh branch: trunk, size: 9640)
2015-09-17
17:21
[b6282433ac] part of check-in [6713e35b8a] Avoid passing (signed char) values directly to isspace(), isalnum() or isdigit() in json1.c. Cast the value to (unsigned char) first. (check-in: [6713e35b8a] user: dan branch: trunk, size: 9378)
2015-09-11
15:32
[4e1403cb06] part of check-in [f599a42e19] More test cases in test/json102.test corresponding to new examples in the json1 documentation. (check-in: [f599a42e19] user: drh branch: trunk, size: 9055)
01:22
[b5da30aef2] part of check-in [d6cadbe9fe] Updates to the sqlite3_value_subtype() and sqlite3_result_subtype() documentation and to test cases for json1 dealing with those interfaces. (check-in: [d6cadbe9fe] user: drh branch: trunk, size: 8368)
2015-09-10
15:22
[12ef6d7d7c] part of check-in [bb8ee3b140] Disable tests for json_each() and json_tree() on builds where virtual tables are not supported (check-in: [bb8ee3b140] user: drh branch: trunk, size: 7545)
03:29
Added: [ab2ea59639] part of check-in [6adc7de76a] Fix the json_tree() scan for the case when a path is supplied. Add new json1 test cases. (check-in: [6adc7de76a] user: drh branch: trunk, size: 7505)