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: issues-unsubscr...@flink.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org