[DERBY-1226] test resultset.java fails with 10.2 derby client with zOS

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 10.2.1.6
• Component/s: Test
• Environment: zOS and ibm14 or ibm15
• Bug behavior facts: Regression Test Failure
• Assignee: Sunitha Kambhampati
• Reporter: Myrna van Lunteren
• Created: 18/Apr/06 06:56
• Updated: 29/Jun/09 22:58
• Resolved: 26/Apr/06 05:32

Description

The test jdbcapi/resultset.java fails with ibm14 and ibm15 with 10.2 Does not fail with ibm 10.1.2

The failure is that apparently there's a Data Conversion SQLException occurring. There is no stack in the resultset.tmp file, nor any useful details in the .log. A repro is needed, but I'm logging the failure first.

this is the diff:
-----------------------------
Framework: DerbyNetClient

• • • Start: resultset jdk1.4.2 DerbyNetClient 2006-04-17 19:40:07 ***
      1948 del
      < COL1(datatype : DATE, precision : 10, scale : 0)
      1949 del
      < ------------------------------------------------
      1950 del
      < {2000-01-01}
      1951 del
      < {null}
      1952 del
      < {null}
      1953 del
      < {2000-01-01}

      1953a1948
      > Data Conversion SQLException
      1956 del
      < COL1(datatype : TIME, precision : 8, scale : 0)
      1957 del
      < -----------------------------------------------
      1958 del
      <

      {15:30:20}

      1959 del
      <

      {null}
      1960 del
      < {null}

      1961 del
      <

      {null}
      1961a1951
      > Data Conversion SQLException
      1964 del
      < COL1(datatype : TIMESTAMP, precision : 26, scale : 6)
      1965 del
      < -----------------------------------------------------
      1966 del
      < {xxxxxxFILTERED-TIMESTAMPxxxxx}
      1967 del
      < {null}

      1968 del
      <

      {null}
      1969 del
      < {null}

      1969a1954
      > Data Conversion SQLException
      -------------------------------------------------------------

This does fail with both ibm14 and ibm15, it does not fail with jcc, it does not fail with 10.1.(current build).
I marked it as Regression, because it doesn't occur with 10.1, but I can't say whether this test ever passed since implementing the fix for DERBY-877.

Issue Links

• is duplicated by: DERBY-1127 client gives SqlException for test callable.java and parameterMapping.java on zOS