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

Reply via email to