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)
I reproduced it in PostgreSQL too.