Toad World® Forums

Syntax error for "all rows per match with unmatched rows" for match_recognize sql statement

Statement executes fine (version 14.2), but there is a red circle ! mark (syntax error) in the editor gutter on the WITH keyword for the following statement:

SELECT *
FROM Running_Log MATCH_RECOGNIZE
(
ORDER BY Run_Date
MEASURES FIRST (Run_Date) AS Start_Date
,COUNT () AS Days_So_Far
,FINAL COUNT (
) AS Total_Days
,CLASSIFIER () AS Variable
ALL ROWS PER MATCH WITH UNMATCHED ROWS
PATTERN (Init Consecutive{2})
DEFINE Consecutive AS Run_Date = (PREV (Run_Date) + 1)
);