[ http://issues.apache.org/jira/browse/DERBY-1850?page=all ]
Myrna van Lunteren closed DERBY-1850. ------------------------------------- > Test jdbcapi/SURTest_ij.sql fails on IBM WCTME 5.7 Foundation (jdkJ2ME > Foundation Specification v1.0) > ------------------------------------------------------------------------------------------------------- > > Key: DERBY-1850 > URL: http://issues.apache.org/jira/browse/DERBY-1850 > Project: Derby > Issue Type: Test > Components: Test > Affects Versions: 10.3.0.0, 10.2.1.8 > Environment: Windows > Reporter: Rajesh Kartha > Assigned To: Myrna van Lunteren > Fix For: 10.3.0.0, 10.2.1.8 > > > The diff for the test is: > *** Start: SURTest_ij jdkJ2ME Foundation Specification v1.0 derbyall:jdbcapi > 2006-09-10 12:51:18 *** > 1 del > < CONNECTION0* - jdbc:derby:SURTest > 2 del > < * = current connection > 2a1 > > java.lang.reflect.InvocationTargetException: java.lang.NullPointerException > 4 del > < WARNING 01J01: Database 'SURTest' not created, connection made to existing > database instead. > 5 del > < ij(CONNECTION1)> autocommit off; > 6 del > < ij(CONNECTION1)> create table t1 (c1 int primary key, c2 int); > 6a3,4 > > ij> autocommit off; > > ij> create table t1 (c1 int primary key, c2 int); > 8 del > < ij(CONNECTION1)> insert into t1 values > 8a6 > > ij> insert into t1 values > 12 del > < ij(CONNECTION1)> get scroll insensitive cursor sc1 as 'SELECT * FROM t1 FOR > UPDATE'; > 13 del > < ij(CONNECTION1)> next sc1; > 13a10,11 > > ij> get scroll insensitive cursor sc1 as 'SELECT * FROM t1 FOR UPDATE'; > > ij> next sc1; > 17 del > < ij(CONNECTION1)> next sc1; > 17a15 > > ij> next sc1; > 21 del > < ij(CONNECTION1)> -- update row nr. 2 after positioning with next > 21a19 > > ij> -- update row nr. 2 after positioning with next > 24 del > < ij(CONNECTION1)> absolute 5 sc1; > 24a22 > > ij> absolute 5 sc1; > 28 del > < ij(CONNECTION1)> -- update row nr. 5 after positioning with absolute > 28a26 > > ij> -- update row nr. 5 after positioning with absolute > 31 del > < ij(CONNECTION1)> relative 2 sc1; > 31a29 > > ij> relative 2 sc1; > 35 del > < ij(CONNECTION1)> -- update row nr. 7 after positioning with relative > 35a33 > > ij> -- update row nr. 7 after positioning with relative > 38 del > < ij(CONNECTION1)> previous sc1; > 38a36 > > ij> previous sc1; > 42 del > < ij(CONNECTION1)> -- update row nr. 6 after positioning with previous > 42a40 > > ij> -- update row nr. 6 after positioning with previous > 45 del > < ij(CONNECTION1)> relative -1 sc1; > 45a43 > > ij> relative -1 sc1; > 49 del > < ij(CONNECTION1)> last sc1; > 49a47 > > ij> last sc1; > 53 del > < ij(CONNECTION1)> -- update row nr. 10 after positioning with last > 53a51 > > ij> -- update row nr. 10 after positioning with last > 56 del > < ij(CONNECTION1)> after last sc1; > 56a54 > > ij> after last sc1; > 58 del > < ij(CONNECTION1)> -- update when positioned after last should cause an error > 58a56 > > ij> -- update when positioned after last should cause an error > 61 del > < ij(CONNECTION1)> first sc1; > 61a59 > > ij> first sc1; > 65 del > < ij(CONNECTION1)> -- update row nr. 1 after positioning with first > 65a63 > > ij> -- update row nr. 1 after positioning with first > 68 del > < ij(CONNECTION1)> before first sc1; > 68a66 > > ij> before first sc1; > 70 del > < ij(CONNECTION1)> -- update when positioned before first should cause an > error > 70a68 > > ij> -- update when positioned before first should cause an error > 73 del > < ij(CONNECTION1)> close sc1; > 74 del > < ij(CONNECTION1)> commit; > 75 del > < ij(CONNECTION1)> -- check that row where correctly updated > 75a71,73 > > ij> close sc1; > > ij> commit; > > ij> -- check that row where correctly updated > 90 del > < ij(CONNECTION1)> get scroll insensitive cursor sc1 as 'SELECT * FROM t1 FOR > UPDATE'; > 91 del > < ij(CONNECTION1)> next sc1; > 91a88,89 > > ij> get scroll insensitive cursor sc1 as 'SELECT * FROM t1 FOR UPDATE'; > > ij> next sc1; > 95 del > < ij(CONNECTION1)> next sc1; > 95a93 > > ij> next sc1; > 99 del > < ij(CONNECTION1)> -- delete row nr. 2 after positioning with next > 99a97 > > ij> -- delete row nr. 2 after positioning with next > 102 del > < ij(CONNECTION1)> absolute 5 sc1; > 102a100 > > ij> absolute 5 sc1; > 106 del > < ij(CONNECTION1)> -- delete row nr. 5 after positioning with absolute > 106a104 > > ij> -- delete row nr. 5 after positioning with absolute > 109 del > < ij(CONNECTION1)> relative 2 sc1; > 109a107 > > ij> relative 2 sc1; > 113 del > < ij(CONNECTION1)> -- delete row nr. 7 after positioning with relative > 113a111 > > ij> -- delete row nr. 7 after positioning with relative > 116 del > < ij(CONNECTION1)> previous sc1; > 116a114 > > ij> previous sc1; > 120 del > < ij(CONNECTION1)> -- delete row nr. 6 after positioning with previous > 120a118 > > ij> -- delete row nr. 6 after positioning with previous > 123 del > < ij(CONNECTION1)> relative -1 sc1; > 123a121 > > ij> relative -1 sc1; > 127 del > < ij(CONNECTION1)> last sc1; > 127a125 > > ij> last sc1; > 131 del > < ij(CONNECTION1)> -- delete row nr. 10 after positioning with last > 131a129 > > ij> -- delete row nr. 10 after positioning with last > 134 del > < ij(CONNECTION1)> after last sc1; > 134a132 > > ij> after last sc1; > 136 del > < ij(CONNECTION1)> -- delete when positioned after last should cause an error > 136a134 > > ij> -- delete when positioned after last should cause an error > 139 del > < ij(CONNECTION1)> first sc1; > 139a137 > > ij> first sc1; > 143 del > < ij(CONNECTION1)> -- delete row nr. 1 after positioning with first > 143a141 > > ij> -- delete row nr. 1 after positioning with first > 146 del > < ij(CONNECTION1)> before first sc1; > 146a144 > > ij> before first sc1; > 148 del > < ij(CONNECTION1)> -- delete when positioned before first should cause an > error > 148a146 > > ij> -- delete when positioned before first should cause an error > 151 del > < ij(CONNECTION1)> close sc1; > 152 del > < ij(CONNECTION1)> commit; > 153 del > < ij(CONNECTION1)> -- check that row where correctly updated > 153a149,151 > > ij> close sc1; > > ij> commit; > > ij> -- check that row where correctly updated > 162 del > < ij(CONNECTION1)> > 162 add > > ij> > Test Failed. > *** End: SURTest_ij jdkJ2ME Foundation Specification v1.0 derbyall:jdbcapi > 2006-09-10 12:51:26 *** -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
