Using 3.29 and a 3.30 snapshot:
When using json_group_array() as a window function, it loses the tagging of
its argument as being JSON, treating JSON objects etc. as strings instead
when creating arrays.
Sample table:
CREATE TABLE testjson(id INTEGER PRIMARY KEY, j TEXT);
INSERT INTO testjson VALUES(1, '{"a":1}');
INSERT INTO testjson VALUES(2, '{"b":2}');
This query
SELECT json_group_array(json(j)) OVER (ORDER BY id) FROM testjson;
produces
["{\"a\":1}"]
["{\"a\":1}","{\"b\":2}"]
instead of
[{"a":1}]
[{"a":1},{"b":2}]
while the plain aggregate
SELECT json_group_array(json(j)) FROM testjson;
produces the expected
[{"a":1},{"b":2}]
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
