]
Mark Drilling resolved TEIIDDES-2269.
-------------------------------------
Resolution: Done
WindowFunction was not getting handled in DisplayNodeFactory since it did not implement
the IWindowFunction interface.
Pull request
Cannot set ROW_NUMBER() on Transformation Editor
------------------------------------------------
Key: TEIIDDES-2269
URL:
https://issues.jboss.org/browse/TEIIDDES-2269
Project: Teiid Designer
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Transformations
Affects Versions: 8.4
Environment: OpenJDK 1.7.0, Fedora 20, Teiid 8.8, Teiid Designer 8.5.0
Reporter: Rich Lucente
Assignee: Mark Drilling
Priority: Optional
Fix For: 8.6, 8.5.1
This actually affects Teiid Designer 8.5.0.Final-v20140616-1350-B2658
1. Create Teiid Model project using Teiid Designer.
2. Import Flat File (I used VA.TXT from
http://www.ssa.gov/oact/babynames/state/namesbystate.zip)
3. Edit transformation on View model to:
{code}
SELECT ROW_NUMBER() OVER (ORDER BY A.state) as id , A.name, A.state, A.gender,
A.birthyear, A.occurences FROM
(EXEC file_source.getTextFiles('VA.TXT')) AS f,
TEXTTABLE(f.file COLUMNS state string, gender char, birthyear integer, name
string, occurences integer) AS A;
{code}
4. Try to save. ROW_NUMBER() removed and ERROR: Parsing error: Encountered
"OVER" at line xxx