[teiid-designer-issues] [JBoss JIRA] (TEIIDDES-1669) Column Datatype Missing Generating Virtual Table From SELECT Clause Containing A Function And Alias

Column Datatype Missing Generating Virtual Table From SELECT Clause Containing A Function And Alias --------------------------------------------------------------------------------------------------- Key: TEIIDDES-1669 URL: https://issues.jboss.org/browse/TEIIDDES-1669 Project: Teiid Designer Issue Type: Bug Components: Modeling Affects Versions: 8.1 Environment: JBDS 6.0.1.GA, Teiid 8.2, OSX 10.8.3 Reporter: Dan Florian Assignee: Mark Drilling Fix For: 8.2 Create a source model (SourceModel) with one table (SourceTable) that has one column (sourceColumn) of type int. Created a virtual model (VirtualModel) with one table (ViewTable). Opened the transformation editor and entered: SELECT SUM(SourceModel.SourceTable.sourceColumn) AS viewColumn FROM SourceModel.SourceTable The "viewColumn" column was generated without a data type. Because we know the return type of the function, and the datatype resolver knows how to resolve, the data type should've been determined.