[
https://issues.jboss.org/browse/TEIID-2850?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-2850.
-----------------------------------
Resolution: Done
Added the ability to cast from object to known types for sql server. Beyond this if
needed we can look at inspected the select clause for variant columns and wrapping with a
cast to string.
Add options to support sql server variant type
----------------------------------------------
Key: TEIID-2850
URL:
https://issues.jboss.org/browse/TEIID-2850
Project: Teiid
Issue Type: Feature Request
Components: Misc. Connectors, Query Engine
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 8.10
Due to a SQL Server driver issue, a variant column cannot be directly retrieved (it needs
to be confirmed if this works with JTDS). A valid workaround is a native-query extension
with an appropriate cast.
Beyond that we could:
- add an option for the translator to automatically convert to a string value
- allow for converts from object to be pushed down.
--
This message was sent by Atlassian JIRA
(v6.3.8#6338)