snuyanzin commented on PR #24156:
URL: https://github.com/apache/flink/pull/24156#issuecomment-1938687661
>Is it mainly because of the definition of JSON_QUOTE that does not require
its input to be valid JSON, and JSON_UNQOTE that require its input to be a
valid JSON.
I'm not sure that this is the only reson
there is a more simple case, for instance '"key"` is a valid JSON and
`json_quote` produces also a valid json `"\"key\""`
however the combination also seems not working
```sql
SELECT json_unquote(json_quote('"key"'));
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
