[DERBY-2663] derbyall/derbytools/ij2 fails in derbyall run in the J2ME environment

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.3.1.4
• Fix Version/s: 10.3.1.4
• Component/s: Test

Environment

Generating report for RunSuite derbyall j9_foundation11 j9 null null true
------------------ Java Information ------------------
Java Version: J2ME Foundation Specification v1.1
Java Vendor: IBM Corporation
Java home: c:\jartest\weme6.1
Java classpath: c:/jartest/classes/derby.jar;c:/jartest/classes/derbyLocale_zh_TW.jar;c:/jartest/classes/derbyLocale_zh_CN.jar;c:/jartest/classes/derbyLocale_ru.jar;c:/jartest/classes/derbyLocale_pt_BR.jar;c:/jartest/classes/derbyLocale_pl.jar;c:/jartest/classes/derbyLocale_ko_KR.jar;c:/jartest/classes/derbyLocale_ja_JP.jar;c:/jartest/classes/derbyLocale_it.jar;c:/jartest/classes/derbyLocale_hu.jar;c:/jartest/classes/derbyLocale_fr.jar;c:/jartest/classes/derbyLocale_es.jar;c:/jartest/classes/derbyLocale_de_DE.jar;c:/jartest/classes/derbyLocale_cs.jar;c:/jartest/tools/java/junit.jar;c:/jartest/classes/derbytools.jar;c:/jartest/classes/derbyrun.jar;c:/jartest/classes/derbyTesting.jar;c:/jartest/classes/functionTests.jar
OS name: Windows XP
OS architecture: x86
OS version: 5.1 build 2600 Service Pack 2
Java user name: cloudtest
Java user home: C:\Documents and Settings\cloudtest
Java user dir: C:\jartest\JarResults.2007-05-16\weme6.1_derbyall
java.specification.name: J2ME Foundation Specification
java.specification.version: 1.1
--------- Derby Information --------
JRE - JDBC: J2ME - JDBC for CDC/FP 1.0
[C:\jartest\classes\derby.jar] 10.3.0.0 alpha - (538785)
[C:\jartest\classes\derbytools.jar] 10.3.0.0 alpha - (538785)
[C:\jartest\classes\derbynet.jar] 10.3.0.0 alpha - (538785)
[C:\jartest\classes\derbyclient.jar] 10.3.0.0 alpha - (538785)
------------------------------------------------------
----------------- Locale Information -----------------
Current Locale : [English/United States [en_US]]
Found support for locale: [cs]
version: 10.3.0.0 alpha - (538785)
Found support for locale: [de_DE]
version: 10.3.0.0 alpha - (538785)
Found support for locale: [es]
version: 10.3.0.0 alpha - (538785)
Found support for locale: [fr]
version: 10.3.0.0 alpha - (538785)
Found support for locale: [hu]
version: 10.3.0.0 alpha - (538785)
Found support for locale: [it]
version: 10.3.0.0 alpha - (538785)
Found support for locale: [ja_JP]
version: 10.3.0.0 alpha - (538785)
Found support for locale: [ko_KR]
version: 10.3.0.0 alpha - (538785)
Found support for locale: [pl]
version: 10.3.0.0 alpha - (538785)
Found support for locale: [pt_BR]
version: 10.3.0.0 alpha - (538785)
Found support for locale: [ru]
version: 10.3.0.0 alpha - (538785)
Found support for locale: [zh_CN]
version: 10.3.0.0 alpha - (538785)
Found support for locale: [zh_TW]
version: 10.3.0.0 alpha - (538785)
------------------------------------------------------
Test environment information:
COMMAND LINE STYLE: jdk13
TEST CANONS: product_master
------------------------------------------------------
------------------------------------------------------

• Bug behavior facts: Regression Test Failure
• Assignee: Nirmal Fernando
• Reporter: Mike Matrigali
• Created: 17/May/07 18:28
• Updated: 05/May/10 11:11
• Resolved: 18/May/07 18:58

Description

derby all failed on a trunk build at level: 538785

Test passed on previous day's run. Checkin's included in this test run include the following:

SUBVERSION LOG FROM 538396 TO 538785:

Subversion changes 538413 to 538770 by bpendleton, dag, kahatlen, Mamta, Myrna

• • • Start: ij2 jdkJ2ME Foundation Specification v1.1 derbyall:derbytools 2007-05-17 04:54:25 ***
      93a94,112
      > ij> – DERBY-2558: Verify that we get a reasonable message when the 'dimension'
      > – of the 'using-set' does not match the 'dimension' of the prepared statement:
      > create table t2558 (i int);
      > 0 rows inserted/updated/deleted
      > ij> insert into t2558 values (3), (4);
      > 2 rows inserted/updated/deleted
      > ij> – First two statements below should fail. Third one should work.
      > execute 'select * from t2558 where i = ?' using 'values (3,4)';
      > IJ WARNING: Autocommit may close using result set
      > ERROR XCL13: The parameter position '2' is out of range. The number of parameters for this prepared statement is '1'.
      > ij> execute 'select * from t2558 where i in (?,?,?)' using 'values (3,4)';
      > IJ WARNING: Autocommit may close using result set
      > ERROR 07000: At least one parameter to the current statement is uninitialized.
      > ij> execute 'select * from t2558 where i = ? or i = ?' using 'values (3,4)';
      > IJ WARNING: Autocommit may close using result set
      > I
      > -----------
      > 3
      > 4
      Test Failed.