[ https://issues.apache.org/jira/browse/CALCITE-6046?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17775779#comment-17775779 ]
LakeShen commented on CALCITE-6046: ----------------------------------- Hi [~zhoujira86] ,is this problem duplicate as CALCITE-6051 ? I find the problem's behavior is same as CALCITE-6051 > SQL parser failed when parsing a comment string start with '&u' > --------------------------------------------------------------- > > Key: CALCITE-6046 > URL: https://issues.apache.org/jira/browse/CALCITE-6046 > Project: Calcite > Issue Type: Improvement > Components: core > Affects Versions: 1.35.0 > Reporter: xiaogang zhou > Priority: Major > Fix For: 1.36.0 > > > quoteStringLiteralUnicode returns unparsed string with u&' prefix, which will > cause the SqlLiteral > > for example with a SQL > > {code:java} > // code placeholder > CREATE TABLE source ( > a BIGINT > ) comment '测试test' > WITH ( > 'connector' = 'test' > ); {code} > with a parsed Sqlnode, the toString will create a SQL like below, which is > not parsable again. > > {code:java} > // code placeholder > CREATE TABLE `source` ( > `a` BIGINT > ) > COMMENT u&'\5218\51eftest' WITH ( > 'connector' = 'test' > ) {code} > I think this is caused by > {code:java} > // code placeholder > public void quoteStringLiteralUnicode(StringBuilder buf, String val) { > buf.append("u&'"); {code} > not sure if I misconfigured something. Is it possiable to remove the > buf.append("u&'"); ? -- This message was sent by Atlassian Jira (v8.20.10#820010)