Loading...

XML

Word

Printable

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 References:
https://bugzilla.redhat.com/show_bug.cgi?id=1023823

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