[teiid-designer-issues] [JBoss JIRA] (TEIIDDES-2502) Incorrect transformation reconciliation

Incorrect transformation reconciliation --------------------------------------- Key: TEIIDDES-2502 URL: https://issues.jboss.org/browse/TEIIDDES-2502 Project: Teiid Designer Issue Type: Bug Components: Transformations Affects Versions: 9.0.1 Environment: 9.0.1.Final-v20150211-1407-B643 JBDS / Designer on Windows Reporter: Tom Johnston SELECT proj.*, act.*, cm.Field_Num, cm.Identity_Token, f.Plant_Num FROM ((Table1 AS act LEFT OUTER JOIN Table2 AS proj ON proj.Field_ID = act.Field_ID) LEFT OUTER JOIN Table3 AS f ON f.Field_ID = act.Field_ID) INNER JOIN Table4 AS cm ON cm.Contract_ID = f.Contract_ID ORDER BY act.Crop_Year "resolves" to: SELECT Table2 AS proj.*, Table1 AS act.*, cm.Field_Num, cm.Identity_Token, f.Plant_Num FROM ((Table1 AS act LEFT OUTER JOIN Table2 AS proj ON proj.Field_ID = act.Field_ID) LEFT OUTER JOIN Table3 AS f ON f.Field_ID = act.Field_ID) INNER JOIN Table4 AS cm ON cm.Contract_ID = f.Contract_ID ORDER BY act.Crop_Year with error: ERROR: Error in parsing of sql - Encountered " <ALL_IN_GROUP> "proj.* "" at line 2, column 54. Was expecting one of: "instead" ... "enabled" ... "disabled" ... "view" ... "key" ... "serial" ... "textagg" ... "count" ... "row_number" ... "rank" ... "dense_rank" ... "sum" ... "avg" ... "min" ... "max" ... "every" ... "stddev_pop" ... "stddev_samp" ... "var_samp" ... "var_pop" ... "document" ... "content" ... "trim" ... "empty" ... "ordinality" ... "path" ... "first" ... "last" ... "next" ... "substring" ... "extract" ... "to_chars" ... "to_bytes" ... "timestampadd" ... "timestampdiff" ... "querystring" ... "namespace" ... "result" ... "index" ... "accesspattern" ... "auto_increment" ... "wellformed" ... "sql_tsi_frac_second" ... "sql_tsi_second" ... "sql_tsi_minute" ... "sql_tsi_hour" ... "sql_tsi_day" ... "sql_tsi_week" ... "sql_tsi_month" ... "sql_tsi_quarter" ... "sql_tsi_year" ... "texttable" ... "arraytable" ... "selector" ... "skip" ... "width" ... "passing" ... "name" ... "encoding" ... "columns" ... "delimiter" ... "quote" ... "header" ... "nulls" ... "objecttable" ... "version" ... "including" ... "excluding" ... "xmldeclaration" ... "variadic" ... "exception" ... "raise" ... "chain" ... "jsonarray_agg" ... "jsonobject" ... <ID> ...