[teiid-designer-issues] [JBoss JIRA] (TEIIDDES-2269) Cannot set ROW_NUMBER() on Transformation Editor

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