Toad World® Forums

Editor: Syntax error incorrectly reported for lag/lead analytic functions with ignore nulls inside the brackets


#1

Hi,

This has been an issue with Toad for a little while, and whilst it’s not a massive bug, I know it’s caused at least one person an issue. This picture demonstrates the issue:

toad_lag_issue.jpeg

Both queries are valid forms of LAG in 11.2 and above, and both run correctly; it’s just that Toad reports one as having a syntax issue. Oracle list both forms as acceptable: http://docs.oracle.com/cd/E11882_01/server.112/e41084/functions082.htm#i1327527

Is there any chance of correcting this so that both of the above forms of the LAG and LEAD analytic functions show as syntactically correct?

Thanks.


#2

This is fixed for next beta.