[teiid-designer-issues] [JBoss JIRA] (TEIIDDES-1515) Cannot set ROW_NUMBER() on Transformation Editor
[
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.
Cannot set ROW_NUMBER() on Transformation Editor
------------------------------------------------
Key: TEIIDDES-1515
URL: https://issues.jboss.org/browse/TEIIDDES-1515
Project: Teiid Designer
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Editors
Affects Versions: 7.7.1, 7.8, 7.7.4
Environment: JBDS 5.0.1
Reporter: Eiichi Nagai
Assignee: Johnathon Lee
Fix For: 8.2, 7.7.5
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....
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)