Closed
Description
What happens?
Seems thatjson_deserialize_sql skips the quotes on columns in JOIN USING () clause.
To Reproduce
SELECT json_deserialize_sql(json_serialize_sql('SELECT * FROM t1 JOIN t2 USING("$id")'));
Will produce
┌───────────────────────────────────────────────────────────────────────────────────┐
│ json_deserialize_sql(json_serialize_sql('SELECT * FROM t1 JOIN t2 USING("$id")')) │
│ varchar │
├───────────────────────────────────────────────────────────────────────────────────┤
│ SELECT * FROM t1 INNER JOIN t2 USING ($id) │
└───────────────────────────────────────────────────────────────────────────────────┘
OS:
MacOS 15.5
DuckDB Version:
1.3.0
DuckDB Client:
CLI
Hardware:
No response
Full Name:
Andrey Koshchiy
Affiliation:
MY.GAMES
What is the latest build you tested with? If possible, we recommend testing with the latest nightly build.
I have tested with a source build
Did you include all relevant data sets for reproducing the issue?
No - Other reason (please specify in the issue body)
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