[teiid-issues] [JBoss JIRA] (TEIID-5313) Oracle translator issue with mixing string types

[Steven Hawkins (JIRA)]

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

Steven Hawkins resolved TEIID-5313.
-----------------------------------
    Fix Version/s: 10.1.3
                   10.2.1
       Resolution: Done


Added handling of mixing unicode and non-unicode strings in union and case expressions.  Also turned on the unicode prefix for literals and updated the conversion to char - as oracle implicitly will treat as a char(n) ascii type otherwise.  The logic for detecting the unicode type does not yet assume all possible situations (it doesn't try to go deeply into expressions) so there are situations that could still error - but they should not an incorrect query.

> Oracle translator issue with mixing string types
> ------------------------------------------------
>
>                 Key: TEIID-5313
>                 URL: https://issues.jboss.org/browse/TEIID-5313
>             Project: Teiid
>          Issue Type: Bug
>          Components: JDBC Connector
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 10.3, 10.1.3, 10.2.1
>
>
> Oracle produces an exception when internationalized and regular character strings are mixed via a union or case statement, for example:
> case when val = 'x' then 'x' else N'y' end
> The translator only puts the N literal prefix when a non-ascii character is present though.



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