Beautifier fails to parse code section

[Arky]

Hello

The Beautifier fails to parse the following piece of code:

SELECT d.dlr_id,
d.x_shop_cd,
row_number() over(PARTITION BY d.x_shop_cd
ORDER BY CASE WHEN dc.dlr_id IS NULL THEN 1 ELSE 2 END, d.dlr_id) rn
FROM dealers d

A workaround for this is to add brackets:

SELECT d.dlr_id,
d.x_shop_cd,
row_number() over(PARTITION BY d.x_shop_cd
ORDER BY (CASE WHEN dc.dlr_id IS NULL THEN 1 ELSE 2 END), d.dlr_id) rn
FROM dealers d

Can you please add it to the bug's list? I use 32-bit version (until PasteOptions for 64-bit arrives :grin: ) , Version 11.0.5.1775

Thanks!

 

[Marco Kalter]

We'll fix it.

 

[William Robertson]

Funny that you have to add brackets to help the beautifier. In this example you have to remove them:

select x from y join z on (a = b and c = d and e = f)

I know they are redundant and I never put them there, but for some reason a lot of developers insist on adding them, and it messes up the beautifier.

 

[Arky]

Hello Marco

Any news on this? In version 12.0.3 the problem still occurs

Thanks

 

[Marco Kalter]

It's still on the to-do list.