sepuri sai krishna created FLINK-41322:
------------------------------------------
Summary: 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
{{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)
