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
Environment: Windows
Reporter: Rajesh Kartha
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
