[KYLIN-1685] error happens while execute a sql contains '?' using Statement

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: v1.2, v1.5.1
• Fix Version/s: v1.3.1, v1.5.2
• Component/s: Driver - JDBC
• Assignee: fengYu
• Reporter: fengYu
• Created: 12/May/16 09:38
• Updated: 26/May/16 09:16
• Resolved: 12/May/16 13:33

Description

Exception happen :
java.sql.SQLException: Error while executing SQL "select * from test_table where url not in ('http://a.b.com/?a=b')": org.apache.kylin.jdbc.KylinStatement cannot be cast to org.apache.kylin.jdbc.KylinPreparedStatement
at org.apache.kylin.jdbc.KylinResultSet.execute(KylinResultSet.java:54)
at org.apache.calcite.avatica.AvaticaConnection$1.execute(AvaticaConnection.java:566)
at org.apache.kylin.jdbc.KylinMeta.prepareAndExecute(KylinMeta.java:79)
at org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:571)
at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:135)
at org.apache.calcite.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:186)
at org.apache.kylin.jdbc.DriverTest.testStatementWithQuestionMask(DriverTest.java:79)

This caused by kylin jdbc will take a sql contain '?' as PreparedStatement and cast as it.