Prepared Statements with setArray

["Kramer, Ulrich" <u....@sap.com.INVALID>]

Hi all,

we would like to use the IN operator with a single array/list argument. 

SELECT … WHERE COL IN(?)

Avatica supports setting array parameters using

ps.setArray(1, ps.getConnection().createArrayOf("VARCHAR", new Object[]{"VAL1", "VAL2"}))

Unfortunately calcite optimizes the query to (when the column COL is of type VARCHAR)

SELECT … WHERE COL = (CAST ? AS VARCHAR)

which evaluates to

SELECT … WHERE COL = '[VAL1,VAL2]'

which will obviously return nothing.

Is there a way to fix this?

Kind Regards
Ulrich