[teiid-issues] [JBoss JIRA] (TEIID-2850) Add options to support sql server variant type

[Steven Hawkins (JIRA)]

Steven Hawkins created TEIID-2850:
-------------------------------------

             Summary: 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


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 is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira