github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/function/func_json_quote.result (about) 1 select json_quote('a'); 2 json_quote(a) 3 "a" 4 select json_quote('a"'); 5 json_quote(a") 6 "a\"" 7 select json_quote('a"b'); 8 json_quote(a"b) 9 "a\"b" 10 select json_quote(null); 11 json_quote(null) 12 null 13 create table t1 (a varchar(10)); 14 insert into t1 values ('a'), ('a"'), ('a"b'), (null); 15 select json_quote(a) from t1; 16 json_quote(a) 17 "a" 18 "a\"" 19 "a\"b" 20 null 21 select json_quote('xax') from t1; 22 json_quote(xax) 23 "xax" 24 "xax" 25 "xax" 26 "xax" 27 select json_quote(null) from t1; 28 json_quote(null) 29 null 30 null 31 null 32 null