[jira] [Closed] (CALCITE-6046) SQL parser failed when parsing a comment string start with '&u'

["Benchao Li (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CALCITE-6046?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Benchao Li closed CALCITE-6046.
-------------------------------

> 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
>
> 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)