Ambiguous beautifier behavior.

[dbms_photoshop]

Beautifier could not parse text while case statement followed after over or keep keywords.

Examples:

SELECT MAX(dummy) keep(dense_rank FIRST ORDER BY case when (1 = 1) then 1 else 0 end) result
FROM dual;

select row_number() over (ORDER BY case when 1 = 1 then 1 else 0 end) rn
from dual;

Should it be fixed?

Version 8.0.0.1480

PS
I get the same result (filtered only by first keyword) while searching this forum for:
+beautifier
+beautifier +keep
+beautifier +over

 

[Marco Kalter]

There is no explicit support for analytical functions at the moment. This is on the list of enhancement requests.

 

[dbms_photoshop]

Another one "could not parse text":

SELECT CASE WHEN decode(1,1,
            CASE WHEN 1 = 1 THEN 1 ELSE 0 END) = 1
            THEN 1 END
FROM dual;

But more important bugs relative to beautifier is:
1. Beautify all procedures
2. model clause

Do you have a plan for when this will be fixed?

Thanks for any response!

 

[Marco Kalter]

This works fine for me. Are you using version 8.0.4?