diff options
| author | stephan <stephan@noemail.net> | 2022-09-06 09:59:06 +0000 |
|---|---|---|
| committer | stephan <stephan@noemail.net> | 2022-09-06 09:59:06 +0000 |
| commit | ae1ed83831d9cb6026a15d30d43a309bf3fd758f (patch) | |
| tree | a8a255cd018524d40505172732ae7f0a8a92f930 /test/json101.test | |
| parent | 49cb8d7314f201bcc264ab3c38c01ae48822a7a4 (diff) | |
| parent | 2e440a0801ad366d48532890b506853c0e34030e (diff) | |
| download | sqlite-ae1ed83831d9cb6026a15d30d43a309bf3fd758f.tar.gz sqlite-ae1ed83831d9cb6026a15d30d43a309bf3fd758f.zip | |
Merge trunk into fiddle-opfs branch.
FossilOrigin-Name: 7f76eaec793720db87415a476ddf539bc4dea3e74c8e5406d6739206aebdacc2
Diffstat (limited to 'test/json101.test')
| -rw-r--r-- | test/json101.test | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/test/json101.test b/test/json101.test index b84846d88..135c988e9 100644 --- a/test/json101.test +++ b/test/json101.test @@ -867,4 +867,22 @@ do_catchsql_test json-18.5 { SELECT json_extract('{"":8}', '$.'); } {1 {JSON path error near ''}} +# 2022-08-29 https://sqlite.org/forum/forumpost/9b9e4716c0d7bbd1 +# This is not a problem specifically with JSON functions. It is +# a problem with transaction control. But the json() function makes +# the problem more easily accessible, so it is tested here. +# +do_execsql_test json-19.1 { + DROP TABLE IF EXISTS t1; + CREATE TABLE t1(x); +} {} +do_catchsql_test json-19.2 { + BEGIN; + INSERT INTO t1 VALUES(0), (json('not-valid-json')); +} {1 {malformed JSON}} +do_execsql_test json-19.3 { + COMMIT; + SELECT * FROM t1; +} {} + finish_test |