[teiid-issues] [JBoss JIRA] (TEIID-5313) Oracle translator issue with mixing string types
[
https://issues.jboss.org/browse/TEIID-5313?page=com.atlassian.jira.plugin...
]
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)