Derby
  1. Derby
  2. DERBY-3635

Cannot build SELECT LIST expressions involving row_number()

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 10.6.1.0
    • Component/s: SQL
    • Labels:
      None
    • Urgency:
      Normal

      Description

      The row_number() windowing function does not behave like other expressions which appear in the SELECT LIST. With other SELECT LIST expressions, you can build up more complicated expressions. If we decide not to lift this limitation, we should probably at least mention it in the ROW_NUMBER section of the Derby Reference Manual.

      The following query works:

      select a + 1 as c, row_number() over () as row_number
      from t
      where a > 100 and a < 111
      ;

      The following query raises an error:

      select a, (row_number() over ()) + 1 as row_number
      from t
      where a > 100 and a < 111

      This is the error I see: "ERROR 42X01: Syntax error: Encountered "over" at line 2, column 25."

        Issue Links

          Activity

            People

            • Assignee:
              Dag H. Wanvik
              Reporter:
              Rick Hillegas
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development