-
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
-
External issue URL:
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>'