Version 2020.2 cannot support != > < >= <= in presto "with" function

DB is : presto

cannot support != > < >= <=  for with function in presto sql, use those directly is ok

return back to last version (

Version 2020.1

) everything seems ok.

e.g. 

with ta as (select 1 != 2)
select * from ta

1 != 2 not work, 1 <> 2 is OK, (1 != 2) is ok

following is not work too
e.g.
at >= date(date_format(date_add('month', -1, current_date), '%Y-%m-01'))
at < date(date_format(current_date, '%Y-%m-01'))
0
2 comments

got anltr InputMismatchException, it throws by datagrip

0

Do you mean SQL is highlighted with red in console?

We've got feature request to support Presto https://youtrack.jetbrains.com/issue/DBE-4719 , follow issue to track progress.

0

Please sign in to leave a comment.