anupamaggarwal commented on PR #24967: URL: https://github.com/apache/flink/pull/24967#issuecomment-2232553702
thanks @snuyanzin, fixed in [7546d9c](https://github.com/apache/flink/pull/24967/commits/7546d9ceb85b5650804d6868bb34797507076c16) Hmm, that's strange, when I tested >SELECT JSON_UNQUOTE('"\u0022\u005c\u005c\u0075\u0030\u0030\u0061\u0061\u0022"'); SELECT JSON_UNQUOTE(JSON_UNQUOTE('"\u0022\u005c\u005c\u0075\u0030\u0030\u0061\u0061\u0022"')); through sql-client I get the same result as MySql I didn't entirely understand why this would be unexpected though For example, if I test (using sql-client) with `select json_unquote('"\u00aa"');` I get `ยช` whereas `select json_unquote('"\\u00aa"');` returns `\u00aa` which seems ok to me, unless I missed something? Added some tests in `ScalarFunctionsTest` -- 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
