[teiid-issues] [JBoss JIRA] Closed: (TEIID-1487) CLONE - Add implicit conversion of NULL to correct datatype in transformation validator

CLONE - Add implicit conversion of NULL to correct datatype in transformation validator --------------------------------------------------------------------------------------- Key: TEIID-1487 URL: https://issues.jboss.org/browse/TEIID-1487 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 6.0.0 Reporter: Marc Shirley Fix For: 7.4 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.