Oracle sql "case when"

[FoxXav]

Hi,

It seems that the sql syntax for Oracle case when is not implemented as I got error with query using this syntax (and not under sqldeveloper).
Is it possible to add it to the great dbeaver ?

See you

[Serge]

Similar problem was fixed a couple of version ago.
Do you use recent (3.6.2) version?
Can you post an example of problem query?

[FoxXav]

Hi,

yes I use the latest version of dbeaver here is a request just to show the problem (no meaning in this) that didn't work in dbeaver but work in sqldeveloper :

select SUM(case when (1=0) then 1 else 0 end), SUM(case when (1=1) then 1 else 0 end)
from dual;

It seems that it's due to the use of the "case when" inside an aggregation function.
Hope it will help

See you

[Serge]

Yep, it is a bug in DBeaver (it incorrectly determines query end). Will fix it in the next version (3.6.3).
Thanks for report.

As a workaround you can select your query and execute it with Ctrl+enter.

[FoxXav]

Just try the 3.6.3 seems to work so far

Great.

thank you.