[PHOENIX-1500] Disallow mutations and queries using PhoenixPreparedStatement.executeQuery() and executeUpdate() respectively.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.3.0, 3.3.0, 3.2.2, 4.2.2
• Assignee: Samarth Jain
• Reporter: Samarth Jain
• Created: 03/Dec/14 22:29
• Updated: 21/Nov/15 02:16
• Resolved: 04/Dec/14 01:44

Description

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