Column Datatype Missing Generating Virtual Table From SELECT Clause Containing A Function And Alias

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.