jeyhunkarimov commented on PR #24156:
URL: https://github.com/apache/flink/pull/24156#issuecomment-1938645548
Thanks for the comment @snuyanzin . I think we need more investigation about
the clear definition and behavior of these functions, since the ones adopted
from MySQL are a bit ambiguous.
> Based on current description if I understand it correctly (please correct
me if I'm wrong): I assume that if my input is correct and quoted then I would
also assume that after applying of `JSON_UNQUOTE` I can receive the initial
string
>
> However
>
> ```sql
> SELECT json_unquote(json_quote('"key": "value"'));
> ```
>
> returns `"\"key\": \"value\""` I think this should be fixed to be able to
get again `'"key": "value"'` ? Or did I miss anything?
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.
As I mentioned, we need a clearer definition (maybe not from MySQL
references)
--
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]
