Collate function not recognized in DataGrip

已回答

创建于 2022年09月05日 20:50

Hi Everyone,

I downloaded and started using DataGrip last week, and I need help understanding something. I am running a query that uses 'collate' function in SQL workbench against Redshift and it works fine. When I try doing the same thing in DataGrip, it doesn't work and shows a syntax error.

However, when I comment out that first line, the query runs without showing an error. I am not sure what that syntax error is - it is the same exact script that runs fine in SQL workbench. Should it be modified somehow to run in Datagrip?

Version: DataGrip 2022.2.2

2 条评论

Niyer

创建于 2022年09月06日 02:00

Hi All,

I really don't know how or why but it works and produces correct results now when I don't put that COLLATE function on a separate line.

SELECT COLLATE (invoice_partner,'case_insensitive')  AS partner,
    sc.retail_store_desc,
    sc.retail_store_number,
   ....

Daniil

创建于 2022年09月06日 13:34

Hello,

Thanks for sharing.

It looks like the query is not executed together if it is on different lines with COLLATE function.

It is a known issue on our tracker: DBE-16333. Feel free to follow it.

请先登录再写评论。