[
https://issues.jboss.org/browse/TEIIDDES-2061?page=com.atlassian.jira.plu...
]
Steven Hawkins commented on TEIIDDES-2061:
------------------------------------------
Can't the change be made to just read all the characters?
There's still a misunderstanding. A Teiid char is a Java Character - it can hold at
most a single character. So regardless of the value returned by the translator, the
engine will attempt to coerce the value to a Character using our normal conversion rules.
char is an unfortunate (and unintentional) mismatch in data type terminology from the
early days of MetaMatrix, where the runtime type model was initially assumed to be
primitive/common Java types.
char[n+] field is truncated by importer
---------------------------------------
Key: TEIIDDES-2061
URL:
https://issues.jboss.org/browse/TEIIDDES-2061
Project: Teiid Designer
Issue Type: Feature Request
Components: Import/Export
Affects Versions: 8.3.1
Reporter: Johnathon Lee
Attachments: testErrors.vdb
truncation of Char[>1] fields to one character.
reproduction with simple VDB (to be attached):
SELECT asChar,asVarChar,asInt FROM "TestErrors"."TruncateCHAR";
the "asChar" field only returns a "C" and the asVarChar returns
the complete value.
That is the expected behavior, per the Data Virtualization Reference Manual, char
datatype is a single Unicode character (java.lang.Character). However, the importer may
need to check for the occurrence of char[n+] and not assume char[1].
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see:
http://www.atlassian.com/software/jira