PreparedStatement DELETE fails for HASH_TYPE

Detail name	Value
Changelog Number	9907
Type	Bug
Status	Resolved
Affected Versions	Exasol 7.0.alpha1
Fix Versions	Exasol 7.0.0
Resolution Date	2020-09-11

Description

DELETE FROM TABLE in prepared statement fails when the filter is of type HASHTYPE.

Example

stmt.execute("CREATE OR REPLACE TABLE TEST.DUMMY(COL1 HASHTYPE(20 BYTE))");
PreparedStatement prepStmt = con.prepareStatement("DELETE FROM TEST.DUMMY WHERE COL1 = ?");
prepStmt.setString(1, "46ae873ec3799ae76ebcf8919de43a57fa5efeff");
prepStmt.execute();

results in the following exception:

java.sql.SQLException: Feature not supported: Incomparable Types: HASHTYPE(20 BYTE) and VARCHAR(40) UTF8!

Expected Behavior

The prepared statement should raise no exception.

Changed behavior