HSQLDB version 2.2.9
JAVA version 1.6.0_30
Executing prepared statement including TRUNC function with timestamp parameter, HsqlException with "incompatible data types in combination" message is thown.
For example, this prepared statement doesn't work: SELECT COUNT(ID) AS TOTAL_ROWS FROM TABLE1 WHERE OPERATION_DATE = TRUNC(?)
Instead this prepared statement works: SELECT COUNT(ID) AS TOTAL_ROWS FROM TABLE1 WHERE OPERATION_DATE = TRUNC(TIMESTAMP'2012-11-01 01:00:00')
In attach junit test for both cases.