Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-1515

Cannot set ROW_NUMBER() on Transformation Editor

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: 7.7.1, 7.8, 7.7.4
    • Fix Version/s: 8.2, 8.3
    • Component/s: Editors
    • Labels:
      None
    • Environment:

      JBDS 5.0.1

    • Steps to Reproduce:
      Hide

      1. Create Teiid Model project using Teiid Designer.
      2. Create a new View Model and a View.
      3. Open the Transformation Editor in a View.
      4. Set and save anything query using ROW_NUMBER().
      EX) SELECT ROW_NUMBER() OVER (ORDER BY ID) AS ID FROM TEST
      5. You can confirm the ROW_NUMBER function cannot set in the Transformation Editor.
      Output error) ERROR: Parsing error: Encountered "OVER" at line xxx

      Show
      1. Create Teiid Model project using Teiid Designer. 2. Create a new View Model and a View. 3. Open the Transformation Editor in a View. 4. Set and save anything query using ROW_NUMBER(). EX) SELECT ROW_NUMBER() OVER (ORDER BY ID) AS ID FROM TEST 5. You can confirm the ROW_NUMBER function cannot set in the Transformation Editor. Output error) ERROR: Parsing error: Encountered "OVER" at line xxx
    • Bugzilla Update:
      Perform

      Description

      ROW_NUMBER is supported by Teiid[1]. However, it cannot set the ROW_NUMBER function using the Transformation Editor.

      [1] http://docs.jboss.org/teiid/7.7.0.Final/reference/en-US/html/sql_support.html#window_functions

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                jolee Johnathon Lee
                Reporter:
                enagai Eiichi Nagai
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: