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

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-2850?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

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)