Saiku adhoc in DB2, error in SQL statment generated by saiku adhoc

[avillagra]

db2 error Parent exception: DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null

to create a report select the clumns and Saiku adhoc returns data correctly.

The problem is when I apply a filter on a char column. In this case the column is char (30) and select 3 or 4 values from filter list ​​and clic en "Save" button, then saiku adhoc return:

There is an error in the SQL statement that is generated when you apply a filter by selecting values ​​from the list of values.

When see in db2 the sql statment to run, db2 show this SQL statement sent to DB2 from Saiku adhoc:

SELECT DISTINCT BT_MGC002_MGC002.GRPDSC AS COL0
FROM BHVSGI.MGC002 BT_MGC002_MGC002
WHERE ( ( BT_MGC002_MGC002.GRPDSC IN ( ?, ?, ?, ? ) OR '' IN ( ?, ?, ?, ? ) ) )

There is an error in the WHERE, the next thing is wrong => OR '' IN ( ?, ?, ?, ? )

#175

Thanks.