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'))
Please sign in to leave a comment.
got anltr InputMismatchException, it throws by datagrip
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.