Print Thread
Beautifier fails to parse nested joins with brackets
#55844 02/14/17 04:02 PM
Joined: Jan 2003
Posts: 88
A
andyh Offline OP
Member
OP Offline
Member
A
Joined: Jan 2003
Posts: 88
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


Andy
Re: Beautifier fails to parse nested joins with brackets
andyh #55845 02/14/17 04:23 PM
Joined: Aug 1999
Posts: 22,206
Member
Offline
Member
Joined: Aug 1999
Posts: 22,206
We'll enhance this.


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.094s Queries: 15 (0.043s) Memory: 2.4950 MB (Peak: 3.0380 MB) Data Comp: Off Server Time: 2024-05-01 06:42:50 UTC
Valid HTML 5 and Valid CSS