Print Thread
Beautifier Error - Case on Analytic Function
#63290 02/16/22 12:46 PM
Joined: Mar 2009
Posts: 32
M
mamv Offline OP
Member
OP Offline
Member
M
Joined: Mar 2009
Posts: 32
Hi,

This also happened on the previous version, but would love to see it fixed in version 15.

When you use a CASE inside an analytic funcion beautifier gives an error:

select dummy, ROW_NUMBER() OVER (ORDER BY CASE WHEN dummy = 'X' THEN 1 ELSE 0 END) rn from dual


Best,
Manuel

Re: Beautifier Error - Case on Analytic Function
mamv #63297 02/16/22 12:56 PM
Joined: Aug 1999
Posts: 22,172
Member
Offline
Member
Joined: Aug 1999
Posts: 22,172
Analytic functions are indeed not yet supported.


Marco Kalter
Allround Automations

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.031s Queries: 15 (0.012s) Memory: 2.4937 MB (Peak: 3.0377 MB) Data Comp: Off Server Time: 2024-03-28 08:22:52 UTC
Valid HTML 5 and Valid CSS