calcite icon indicating copy to clipboard operation
calcite copied to clipboard

[CALCITE-3351] [WIP]In JDBC adapter, when generating SQL for MYSQL, MySQLSyntaxErrorException throws when there is non-ascii literal

Open angelzouxin opened this issue 5 years ago • 2 comments

@julianhyde
hi, julian, https://github.com/apache/calcite/blob/37b8cdbb381369e773229a81ae69ab5c1df34f3e/core/src/main/java/org/apache/calcite/rel/rel2sql/SqlImplementor.java#L712 discard literal charset,I think you did it on purpose. To resolve this bug, if we only need to rewrite the quoteStringLiteralUnicode of MysqlSqlDialect.

angelzouxin avatar Aug 12 '20 10:08 angelzouxin

The title is not clear. Could you change it?

chunweilei avatar Aug 13 '20 03:08 chunweilei

The title is not clear. Could you change it?

title has been changed. See: https://dev.mysql.com/worklog/task/?id=3529. This bug which causes MySQLSyntaxErrorException(Unknown column u) is still open.

angelzouxin avatar Aug 14 '20 11:08 angelzouxin