[ https://issues.jboss.org/browse/TEIIDDES-2306?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-2306: ---------------------------------------- I set up a virtual table with a ROW_ID column of type *int* Verified in the T-Editor that *'12345' AS ROW_ID* is valid as is *12345 AS ROW_ID* as is *12345.999 AS ROW_ID* In the first instance, the ROW_ID would be expected to be a *string*, in the second, ROW_ID datatype is an *integer*, and the third the runtime datatype is *bigdecimal*. In the first and third instances, the SQL validation resulted in unresolved/mismatched datatypes. So it appears that the Expression builder isn't accounting for that flexibility. Not sure what other datatypes would be supported by SQL. Is it just *integer, bigdecimal and string*? Not sure how we address this.... -- This message was sent by Atlassian JIRA (v6.3.1#6329)