[teiid-designer-issues] [JBoss JIRA] Resolved: (TEIIDDES-894) Add implicit conversion of NULL to correct datatype in transformation validator
[
https://issues.jboss.org/browse/TEIIDDES-894?page=com.atlassian.jira.plug...
]
Steven Hawkins resolved TEIIDDES-894.
-------------------------------------
Assignee: Steven Hawkins
Fix Version/s: 7.4
Resolution: Done
consolidated and relaxed the type checking logic to allow null to match any type.
procedure transformations will not match null automatically as teiid will still convert
null literals in resultset queries to string.
Add implicit conversion of NULL to correct datatype in transformation
validator
-------------------------------------------------------------------------------
Key: TEIIDDES-894
URL: https://issues.jboss.org/browse/TEIIDDES-894
Project: Teiid Designer
Issue Type: Feature Request
Components: Validation
Affects Versions: 6.0.0
Reporter: Marc Shirley
Assignee: Steven Hawkins
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.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira