Collate function not recognized in DataGrip

Answered
Avatar
Niyer
Created

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

Votes

0

Share

2 comments
Avatar
Niyer
Created

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,
   ....
0
Avatar
Daniil
Created

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.

0

Please sign in to leave a comment.