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.