2 Replies Latest reply on Feb 5, 2019 9:26 AM by user2885917

    Parser can not parse the correct code:{ MEASURES (0 result, MAX(dummy) OVER (PARTITION BY dummy) mdum ) } Problem with parsing?

    user2885917

      The code below is compiled and executed in Oracle Database 18c (18.3), but the parser (18.4.0.376) cannot parse it.

      Is this some kind of problem with parsing?

       

      SELECT result, dummy, mdum

      FROM dual

      MODEL RETURN UPDATED ROWS

          DIMENSION BY (dummy)

          MEASURES (0 result, MAX(dummy) OVER (PARTITION BY dummy) mdum )

          RULES(

              result[5] = 1,

              result[6] = 2,

              result[7] = 3

          )

       

      parser_syntax_error_2019_02.png