[
https://issues.apache.org/jira/browse/FLINK-41322?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18137315#comment-18137315
]
sepuri sai krishna commented on FLINK-41322:
--------------------------------------------
I have a fix and tests for this locally. Please assign it to me and I will open
a PR.
> JSON_QUOTE does not round-trip a character outside the BMP through
> JSON_UNQUOTE
> -------------------------------------------------------------------------------
>
> Key: FLINK-41322
> URL: https://issues.apache.org/jira/browse/FLINK-41322
> Project: Flink
> Issue Type: Bug
> Components: Table SQL / Runtime
> Affects Versions: 2.4.0
> Reporter: sepuri sai krishna
> Priority: Major
>
> {{JSON_QUOTE}} followed by {{JSON_UNQUOTE}} does not return the input when
> the input holds a
> character outside the BMP.
> {code:sql}
> -- s is a STRING column holding '𝕏', one character outside the BMP
> SELECT JSON_UNQUOTE(JSON_QUOTE(s)) = s FROM t; -- FALSE
> {code}
> The one input character comes back as three, one of them a literal question
> mark that was not in the
> input. Characters inside the BMP round-trip correctly. {{IS JSON}} returns
> TRUE for the quoted value,
> so nothing downstream reports a problem.
--
This message was sent by Atlassian Jira
(v10.3.26#10030026)
