[ https://issues.jboss.org/browse/TEIIDDES-1515?page=com.atlassian.jira.plu... ] Rich Lucente commented on TEIIDDES-1515: ---------------------------------------- I'm running into this problem using Teiid Designer 8.5.0.Final-v20140616-1350-B2658 in JBoss Developer Studio 7.1.1. I'm importing the attached file as a flat file source and attempting to use the following transformation: {code} SELECT ROW_NUMBER() OVER (ORDER BY A.state) AS id, A.name, A.state, A.gender, A.birthyear, A.occurrences FROM (EXEC file_source.getTextFiles('VA.TXT')) AS f, TEXTTABLE(f.file COLUMNS state string, gender char, birthyear integer, name string, occurrences integer) AS A {code} When I save, "ROW_NUMBER()" is removed from the editor and a SQL parsing error occurs. -- This message was sent by Atlassian JIRA (v6.2.6#6264)