Union all and beautifier

[jlcox]

Consider:

select 1 from dual where 1 = 0
union all
select 1 from dual where 1 = 0
union all
select 1 from dual where 1 = 0
union all
select 1 from dual where 1 = 0
union all
select 1 from dual where 1 = 0
union all
select 1 from dual where 1 = 0
union all
select 1 from dual where 1 = 0
union all
select 1 from dual where 1 = 0
union all
select 1 from dual where 1 = 0
union all
select 1 from dual where 1 = 0
union all
select 1 from dual where 1 = 0
union all
select 1 from dual where 1 = 0
union all
select 1 from dual where 1 = 0
union all
select 1 from dual where 1 = 0
union all
select 1 from dual where 1 = 0
union all
select 1 from dual where 1 = 0
union all
select 1 from dual where 1 = 0
union all
select 1 from dual where 1 = 0

Beautifying this brings PL/SQL Developer to its knees for about a minute (with my configuration). A real-world statement of a similar form hung up the application for a good 5 minutes, but actually did complete and beautify properly.

 

[Marco Kalter]

That can't be right. We'll fix it.