Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-2061

char[n+] field is truncated by importer

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 8.4, 8.3.2
    • 8.3.1
    • Import/Export
    • None

      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].

        1. char-length-property-change-warning.png
          19 kB
          Barry LaFond
        2. testErrors.vdb
          13 kB
          Johnathon Lee

              blafond Barry LaFond
              rhn-support-jolee Johnathon Lee
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

                Created:
                Updated:
                Resolved: