[teiid-issues] [JBoss JIRA] Resolved: (TEIID-1487) CLONE - Add implicit conversion of NULL to correct datatype in transformation validator
[
https://issues.jboss.org/browse/TEIID-1487?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-1487.
-----------------------------------
Fix Version/s: 7.4
Resolution: Done
changed the resolving logic to only resolve null literals to string for user queries and
stored procedures
it would probably be good in the future to just add full handling for a null datatype.
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.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira