some Beautifier bug (application hang up)

[Palkin Max]

Hello.
I cant use Beautifier - application hangup. My SQL text:

select 	2502	 old_id,	68	 new_id from dual union
select 	2802	 old_id,	68	 new_id from dual union
select 	68	 old_id,	68	 new_id from dual union
select 	1384	 old_id,	133	 new_id from dual union
select 	1644	 old_id,	133	 new_id from dual union
select   133   old_id,  133   new_id from dual union
select   1365   old_id,  372   new_id from dual union
select   1643   old_id,  372   new_id from dual union
select   372   old_id,  372   new_id from dual union
select   1682   old_id,  383   new_id from dual union
select   1367   old_id,  383   new_id from dual union
select   1642   old_id,  383   new_id from dual union
select   383   old_id,  383   new_id from dual union
select   67   old_id,  67   new_id from dual union
select   2902   old_id,  67   new_id from dual union
select   2402   old_id,  82   new_id from dual union
select   82   old_id,  82   new_id from dual union
select   1349   old_id,  83   new_id from dual union
select   83   old_id,  83   new_id from dual union
select   2002   old_id,  318   new_id from dual union
select   318   old_id,  318   new_id from dual union
select   1352   old_id,  108   new_id from dual union
select   108   old_id,  108   new_id from dual union
select   1366   old_id,  63   new_id from dual union
select   63   old_id,  63   new_id from dual union
select   1402   old_id,  167   new_id from dual union
select   167   old_id,  167   new_id from dual union
select   1373   old_id,  69   new_id from dual union
select   69   old_id,  69   new_id from dual union
select   1351   old_id,  65   new_id from dual union
select   65   old_id,  65   new_id from dual union
select   1340   old_id,  125   new_id from dual union
select   1662   old_id,  125   new_id from dual union
select   125   old_id,  125   new_id from dual union
select   1683   old_id,  171   new_id from dual union
select   171   old_id,  171   new_id from dual union
select   1585   old_id,  144   new_id from dual union
select   1646   old_id,  144   new_id from dual union
select   144   old_id,  144   new_id from dual union
select   1803   old_id,  178   new_id from dual union
select   178   old_id,  178   new_id from dual union
select   1590   old_id,  151   new_id from dual union
select   1364   old_id,  151   new_id from dual union
select   151   old_id,  151   new_id from dual union
select   1357   old_id,  151   new_id from dual union
select   1361   old_id,  151   new_id from dual union
select   2803   old_id,  1043   new_id from dual union
select   1043   old_id,  1043   new_id from dual union
select   1339   old_id,  390   new_id from dual union
select   390   old_id,  390   new_id from dual union
select   75   old_id,  75   new_id from dual union
select   2003   old_id,  75   new_id from dual

PL/SQL Developer Version 8.0.1.1502

tnx

 

[Marco Kalter]

Formatting this seems very slow. We'll check it out.

 

[jlcox]

Formatting statements with multiple unions is terribly slow, has been for many versions. (See recent post:http://www.allroundautomations.com/threads/ubbthreads.php?ubb=showflat&Number=37010#Post37010). The statement above will probably eventually beautify correctly, if one has the patience to wait for it.