[DERBY-972] tests derbynet/csPrepStmt and prepStmt use mechanisms that are not portable over encodings

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 10.1.2.1
• Fix Version/s: 10.1.3.1, 10.2.1.6
• Component/s: Test
• Environment: z/OS , ibm142 ('Classic', 32 bit jvm)
• Assignee: Sunitha Kambhampati
• Reporter: Myrna van Lunteren
• Created: 14/Feb/06 06:42
• Updated: 12/Jul/06 01:40
• Resolved: 26/Apr/06 06:31

Description

With zOS, with the classic 32 bit jvm, the tests derbynet/csPrepStmt and prepStmt.java fail because the insert with setAsciiStream of a byte array obtained from a new String.getBytes() (and/or the retrieval of that inserted value) is not ok. No error is returned, but the select shows no value.

This is the section in the test csPrepStmt:
-----------------
ps.setString(10, "column11string");
byte[] c11ba = new String("column11vcstring").getBytes();
int len = c11ba.length;
ps.setAsciiStream(11, new ByteArrayInputStream(c11ba),
len);
and the value is retrieved using an ResultSet.getString(#)
--------------------------
28 del
< got row: 1 2 3 4 5.0 6.0 7.0 88.88 99.100 column11string
column11vcstring column12lvcstring
0123456789abcdef10111213202020 0123456789abcdef10111213
0123456789abcdef10111213 xxxxxxFILTERED-TIMESTAMPxxxxx-04-12
11:44:30.0
28a28
> got row: 1 2 3 4 5.0 6.0 7.0 88.88 99.100 column11string
column12lvcstring 0123456789abcdef10111213202020
0123456789abcdef10111213 0123456789abcdef10111213
xxxxxxFILTERED-TIMESTAMPxxxxx-04-12 11:44:30.0
--------------------
(i.e. the string "column11vcstring" is not in the database)

This needs to be replaced by a encoding-neutral (eg. fixed encoding) mechanism and the tests derbynet/prepStmt.java and csPrepStmt.java need to be checked for other non-portable
code.

Issue Links

• relates to: DERBY-658 test harness improvements required for running on non-ASCII systems