As denodo does not have collate functionality, i have written a custom function that delegates collate to snowflake server and I am trying to use like operator in denodo vdp client with collate as shown below,
SELECT * FROM <myview> where collate(<name>,'en-ci') like '<name>%';
As per my understanding, snowflake like works with these 2 cases collate(<name>,'en-ci') and collate(<name>,''), however i am getting the following error for the above query in the vdp client, Can anyone address this issue whats wrong or difference between snowflake excecuting the same query and denodo executing the same with collate being delegated to snowflake
QUERY [VIRTUAL] [ERROR]
QUERY [JDBC WRAPPER] [ERROR]
QUERY [JDBC ROUTE] [ERROR] Received exception with message 'SQL compilation error: error line 1 at position 5,340
Function LIKE does not support collation: 1.'