[teiid-designer-issues] [JBoss JIRA] Updated: (TEIIDDES-210) Add implicit conversion of NULL to correct datatype in transformation validator

Add implicit conversion of NULL to correct datatype in transformation validator ------------------------------------------------------------------------------- Key: TEIIDDES-210 URL: https://jira.jboss.org/jira/browse/TEIIDDES-210 Project: Teiid Designer Issue Type: Feature Request Components: Transformations, Validation Affects Versions: 6.0.0, 6.1.0 Reporter: Marc Shirley Fix For: Future When using NULL value as a column (ie, NULL as columnName), it is only implicitly converted to a string. When trying to use the NULL as a column of type date, integer, float, etc., the validator throws a warning that the transformation is not valid. If you wrap the NULL in a convert to the correct column datatype (ie, "convert(NULL,date)"), the transformation can be validated successfully.