Uploaded image for project: 'Apache Trafodion'
  1. Apache Trafodion
  2. TRAFODION-1224

LP Bug: 1451693 - T2 server return trunctated column size to T2 client

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.0-incubating
    • Component/s: client-jdbc-t2
    • Labels:
      None

      Description

      Defect Description:

      There is a table that columns charset as iso88591, when expect to return 20K column size, in fact it returns the length as 3392.

      Test Environment:

      sqws139.houston.hp.com, T2 driver.

      Test Steps:

      Step 1. Create a table as below,

      sql = "create table tblcolumnsize200kWithISO88591(c1 char(200000) character set iso88591 collate default null, c2 char(200000) character set iso88591 collate default null)";
      iRet = stmt.executeUpdate(sql);

      Step 2. Insert 20K column size into the above table.

      Step 3. Execute query as below,

      sql = "select left(rtrim(t.c1), 200000) as o1 from tblcolumnsize200kWithISO88591 as t";
      rs = stmt.executeQuery(sql);

      Step 4. Compare the first column o1 size returned from ResultSet object.

      assertEquals(200000, rs.getObject(1).toString().length());

      At the Step 4, it will throw an exception like 'Exception in thread "main" java.lang.AssertionError: expected: <200000> but was: <3392>'

        Attachments

          Activity

            People

            • Assignee:
              weiqxu Weiqing Xu
              Reporter:
              yubo YuBo
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: