Hi,
Consider the following SQL - it's just something I knocked up to quickly demonstrate the issue :
SELECT LEVEL,
dense_RANK() OVER(PARTITION BY NULL ORDER BY CASE WHEN 1 = 1 THEN 1 ELSE 2 end, MOD(LEVEL, 2)) rnk,
COUNT(*) OVER(PARTITION BY NULL ORDER BY CASE WHEN 1 = 1 THEN 1 ELSE 2 end, MOD(LEVEL, 2)) cnt
FROM dual
CONNECT BY LEVEL <= 100
This won't beautify.
RANKs and COUNTs (and other aggregated window functions) do beautify on the whole, but the addition of the case statement within it topples it over this time.
Is this something you could look into fixing? It's not a major issue, just more of an annoyance when trying to beautify large chunks of code and then having to figure out which bit won't.
Using Version 12.0.5.1828 (32 bit) on Windows 10 (64-bit) Build 15063
Thanks
Matt.