Toad World® Forums

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



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:


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:

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?



This is fixed for next beta.