incompatible data type Lower in HSQL

[former_member645003]

I am getting below error when I am trying to search an item type paymnttrnsctentries . I am using HSQL db , when I tried to debug found LOWER is causing the issue in HSQL , the same SQL statement works fine in HANA db , any pointer how to resolve this?

INFO | jvm 1| main| 2021/03/05 05:25:32.120 | de.hybris.platform.servicelayer.search.exceptions.FlexibleSearchException: SQL search error - incompatible data type in operation in statement [SELECTitem_t0.PKFROM paymnttrnsctentries item_t0 WHERE (( (LOWER( item_t0.p_code ) LIKE ? OR LOWER( item_t0.p_requestid ) LIKE ? OR LOWER( item_t0.p_type ) LIKE ? ) )) AND (item_t0.TypePkString IN(?,?,?) ) order byitem_t0.createdTSDESC LIMIT ? OFFSET ?] query = 'SELECTitem_t0.PKFROM paymnttrnsctentries item_t0 WHERE (( (LOWER( item_t0.p_code ) LIKE ? OR LOWER( item_t0.p_requestid ) LIKE ? OR LOWER( item_t0.p_type ) LIKE ? ) )) AND (item_t0.TypePkString IN(?,?,?) ) order byitem_t0.createdTSDESC LIMIT ? OFFSET ?'

INFO | jvm 1| main| 2021/03/05 05:25:32.121 | ... 16 more

INFO | jvm 1| main| 2021/03/05 05:25:32.121 | Caused by: org.hsqldb.HsqlException: incompatible data type in operation