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

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.19.0
• Component/s: core
• Labels: pull-request-available

Environment

Happened on both Windows and MacOS.

• Assignee: Unassigned
• Reporter: cui
• Created: 16/Sep/19 13:41
• Updated: 18/Aug/20 07:15

Description

Exception was thrown when connecting with mySQL to query Chinese. The following SQL was executed:

select * from \"test\".\"score_new\" where \"name\"= \'催\' limit 1

，if change "getDefaultCharset" in "RelDataTypeFactoryImpl" to

return Charset.forName("UTF8");

there will be also exception thrown as the following:

java.sql.SQLException: Error while executing SQL "select * from "test"."score_new" where "name"= '催' limit 1": While executing SQL [SELECT *java.sql.SQLException: Error while executing SQL "select * from "test"."score_new" where "name"= '催' limit 1": While executing SQL [SELECT *FROM `score_new`WHERE `name` = u&'\50ac'LIMIT 1] on JDBC sub-schema at org.apache.calcite.avatica.Helper.createException(Helper.java:56) at org.apache.calcite.avatica.Helper.createException(Helper.java:41) at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:163) at org.apache.calcite.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:227) at QueryMysql.main(QueryMysql.java:42)Caused by: java.lang.RuntimeException: While executing SQL [SELECT *FROM `score_new`WHERE `name` = u&'\50ac'

Issue Links

• links to: GitHub Pull Request #2106