[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=13574276#comment-13574276 ] 

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

I've got one more intriguing issue. Executing:
{code:sql}
SELECT BQT1.SmallA.IntKey, BQT1.SmallB.BigDecimalValue FROM BQT1.SmallA, BQT1.SmallB WHERE BQT1.SmallA.IntKey = BQT1.SmallB.BigDecimalValue ORDER BY BQT1.SmallA.IntKey
{code}
results in:
{noformat}
Error: TEIID31202 Detected that an already sorted set of values was not in the expected order (typically UTF-16 / UCS-2).  Please check the translator settings to ensure character columns used for joining are sorted as expected.
SQLState:  38000
ErrorCode: 0
{noformat}
The same query runs just fine when I execute it against Exasol and not TEIID. If I remove ORDER BY it runs fine as well.

A similar query by with merge on BigIntegerValue instead of BigDecimalValue:
{code:sql}
SELECT BQT1.SmallA.IntKey, BQT1.SmallB.BigDecimalValue FROM BQT1.SmallA, BQT1.SmallB WHERE BQT1.SmallA.IntKey = BQT1.SmallB.BigIntegerValue ORDER BY BQT1.SmallA.IntKey
{code}
runs just fine in TEIID.

It seems to have something to do with handling of the BigDecimal type in the WHERE clause. I'll continue investigating, but please let me know, if you have any clues. My current state of work is at https://github.com/teiid/teiid/compare/master...rkorytkowski:TEIID-4520


was (Author: rkorytkowski):
I've got one more intriguing issue. Executing:
{code:sql}
SELECT BQT1.SmallA.IntKey, BQT1.SmallB.BigDecimalValue FROM BQT1.SmallA, BQT1.SmallB WHERE BQT1.SmallA.IntKey = BQT1.SmallB.BigDecimalValue ORDER BY BQT1.SmallA.IntKey
{code}
results in:
{noformat}
Error: TEIID31202 Detected that an already sorted set of values was not in the expected order (typically UTF-16 / UCS-2).  Please check the translator settings to ensure character columns used for joining are sorted as expected.
SQLState:  38000
ErrorCode: 0
{noformat}
The same query runs just fine when I execute it against Exasol and not TEIID.

A similar query:
{code:sql}
SELECT BQT1.SmallA.IntKey, BQT1.SmallB.BigDecimalValue FROM BQT1.SmallA, BQT1.SmallB WHERE BQT1.SmallA.IntKey = BQT1.SmallB.BigIntegerValue ORDER BY BQT1.SmallA.IntKey
{code}
runs just fine in TEIID.

It seems to have something to do with handling of the BigDecimal type in the WHERE clause. I'll continue investigating, but please let me know, if you have any clues. My current state of work is at https://github.com/teiid/teiid/compare/master...rkorytkowski:TEIID-4520

> 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)