[
https://issues.apache.org/jira/browse/PHOENIX-1500?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14233618#comment-14233618
]
Mujtaba Chohan commented on PHOENIX-1500:
-----------------------------------------
FYI. Even MySQL errors out if you try to issue DDL with
statement.executeQuery(). For delete statement.executeUpdate() and
statement.execute() works fine.
> Delete using PhoenixPreparedStatement.executeQuery() fails
> ----------------------------------------------------------
>
> Key: PHOENIX-1500
> URL: https://issues.apache.org/jira/browse/PHOENIX-1500
> Project: Phoenix
> Issue Type: Bug
> Reporter: Samarth Jain
>
> {code}
> @Test
> public void deleteUsingPreparedStatement() throws Exception {
> Connection conn = DriverManager.getConnection(getUrl());
> initTableValues(conn);
> assertTableCount(conn, "IntIntKeyTest", NUMBER_OF_ROWS);
> String deleteStmt = "DELETE FROM IntIntKeyTest WHERE j = ?";
> PreparedStatement stmt = conn.prepareStatement(deleteStmt);
> stmt.setInt(1, 20);
> stmt.executeQuery();
> conn.commit();
> assertTableCount(conn, "IntIntKeyTest", NUMBER_OF_ROWS - 1);
> }
> java.lang.ClassCastException: org.apache.phoenix.compile.DeleteCompiler$3
> cannot be cast to org.apache.phoenix.compile.QueryPlan
> at
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:221)
> at
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:1)
> at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:216)
> at
> org.apache.phoenix.jdbc.PhoenixPreparedStatement.executeQuery(PhoenixPreparedStatement.java:183)
> at
> org.apache.phoenix.end2end.DeleteIT.deleteUsingPreparedStatement(DeleteIT.java:484)
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
