Transformation SQL: One alias necessary, the rest are superfluous ----------------------------------------------------------------- Key: TEIIDDES-53 URL: https://jira.jboss.org/jira/browse/TEIIDDES-53 Project: Teiid Designer Issue Type: Task Components: Transformations Affects Versions: 6.0.0 Environment: Linux Reporter: Paul Nittel Assignee: Dan Florian Priority: Blocker Fix For: 6.0.0 I added a column to a relational view model's table and bound it to an expressions, so an alias (foo AS bar) was created. Turns out all the other columns were treated the same way. for example: SELECT AUTHOR_ID AS AUTHOR_ID, FIRSTNAME AS FIRSTNAME, LASTNAME AS LASTNAME, MIDDLEINIT AS MIDDLEINIT, CONVERT((RAND() * 10), string) AS MidThing FROM Books_Oracle_9i.BOOKS.AUTHORS Really only need one "AS" in the SQL. If I cleverly remove all the excess AS-es, they come back when I save/validate the SQL.