dbeaver: Long "case when" query freeze dbeaver CE forever

Executing CREATE OR REPLACE VIEW

  • Operating system (distribution) and version : Windows 10 build 18363

  • DBeaver version : 7.3.0 CE

  • Java version: 1.8

  • Database name and version : Vertica 9.2.1

  • Driver name :

  • Do you use tunnels or proxies (SSH, SOCKS, etc)?

Apps that only with long case when query, like the following, the dbeaver CE freeze forever

create or replace view v_name as
select f1,   f2, 
case when f3 <5   then 5    else 
case when f3 <=10 then 10 else
case when f3 <=15 then 15 else
case when f3 <=20 then 20 else
case when f3 <=25 then 25 else
case when f3 <=30 then 30 else
case when f3<=35 then 35 else
case when f3<=40 then 40 else
case when f3<=50 then 50 else
case when f3<=60 then 60 else
case when f3<=70 then 70 else
case when f3<=80 then 80 else
case when f3<=90 then 90 else
case when f3<=100 then 100 else
case when f3<=120 then 120 else
case when f3<=150 then 150 else
case when f3>150  then 999 end 
end end end end end end end end end end end end end end end end as ff, 
max(year(current_timestamp)) yy,
group by 1,2;

Grazie, Massimo

About this issue

  • Original URL
  • State: closed
  • Created 4 years ago
  • Comments: 20 (8 by maintainers)

Most upvoted comments

I reproduced it in PostgreSQL too.