Closed
Description
What happens?
The SQL to/from JSON docs describe the json_deserialize_sql function as
Deserialize one or many json serialized statements back to an equivalent SQL string.
When deserializing many json serialized statements a ParserException is raised. Given the description in the documentation I was expecting one or many statements to be deserialized back into the equivalent SQL string.
To Reproduce
SELECT json_deserialize_sql(json_serialize_sql('SELECT 1;SELECT 2'));
Parser Error:
Error parsing json: more than one statement
OS:
Darwin 23.5.0 arm64
DuckDB Version:
v1.3.0 (Ossivalis) 71c5c07 clang-16.0.0
DuckDB Client:
CLI
Hardware:
No response
Full Name:
Evan Duncan
Affiliation:
Greenhouse Software
What is the latest build you tested with? If possible, we recommend testing with the latest nightly build.
I have tested with a stable release
Did you include all relevant data sets for reproducing the issue?
Not applicable - the reproduction does not require a data set
Did you include all code required to reproduce the issue?
- Yes, I have
Did you include all relevant configuration (e.g., CPU architecture, Python version, Linux distribution) to reproduce the issue?
- Yes, I have