[teiid-issues] [JBoss JIRA] (TEIID-4520) Support for Exasol Connector

[Rafal Korytkowski (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-4520?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13572709#comment-13572709 ] 

Rafal Korytkowski edited comment on TEIID-4520 at 5/8/18 7:52 AM:
------------------------------------------------------------------

Thanks [~rareddy]! My other question is how do we handle differences between jdbc data sources?

E.g. SELECT ASIN(1/ -24); returns -0.0416787324225779 in MySQL, but 0.0 in Exasol. It's because 1 is automatically converted to double in MySQ, whereas in Exasol it needs to be explicit with ASIN(1.0/ -24); (this is actually not the case, just an example).

Does developing a translator mean we need to eliminate such differences to have same results or just make sure that queries coming out of TEIID are valid for that particular data source?


was (Author: rkorytkowski):
Thanks [~rareddy]! My other question is how do we handle differences between jdbc data sources?

E.g. SELECT ASIN(1/ -24); returns -0.0416787324225779 in MySQL, but 0.0 in Exasol. It's because 1 is automatically converted to double in MySQ, whereas in Exasol it needs to be explicit with ASIN(1.0/ -24);

Does developing a translator mean we need to eliminate such differences to have same results or just make sure that queries coming out of TEIID are valid for that particular data source?

> Support for Exasol Connector
> ----------------------------
>
>                 Key: TEIID-4520
>                 URL: https://issues.jboss.org/browse/TEIID-4520
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Misc. Connectors
>    Affects Versions: 9.x
>            Reporter: Van Halbert
>            Assignee: Andrej Šmigala
>             Fix For: 10.x, Open To Community
>
>
> Requesting support for Exasol Connector



--
This message was sent by Atlassian JIRA
(v7.5.0#75005)