Beautifier fails to parse nested joins with brackets - 02/14/17 04:02 PM
The following cannot be parsed by beautifier:
with d as (select 1 as n from dual)
,d1 as (select 1 as n from dual),
d2 as (select 2 as n from dual)
select d.n, d1.n from d
left join (d1 join d2 on d1.n = d2.n) on d1.n = d.n
The failure appears to be related to the use of brackets around the d1/d2 join.
PSD 11.0.6 and 12.0.0
with d as (select 1 as n from dual)
,d1 as (select 1 as n from dual),
d2 as (select 2 as n from dual)
select d.n, d1.n from d
left join (d1 join d2 on d1.n = d2.n) on d1.n = d.n
The failure appears to be related to the use of brackets around the d1/d2 join.
PSD 11.0.6 and 12.0.0