[
https://issues.apache.org/jira/browse/DERBY-160?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Myrna van Lunteren updated DERBY-160:
-------------------------------------
Issue & fix info: [Repro attached]
the repro is actually included in the description.
> Foreign key constraint failure closes the cursors in embedded mode but not in
> Network Server mode
> -------------------------------------------------------------------------------------------------
>
> Key: DERBY-160
> URL: https://issues.apache.org/jira/browse/DERBY-160
> Project: Derby
> Issue Type: Bug
> Components: Network Server
> Affects Versions: 10.0.2.1
> Reporter: Mamta A. Satoor
>
> When running embedded Derby in autocommit true mode(default), a foreign key
> violation closes the open cursors. But the cursors remain open after the
> foreign key violation when Derby is running in Network Server. Following code
> can be tried in ij for embedded and network server to see the behavior
> difference.
> create table tableWithPrimaryKey (c1 int not null, c2 int not null,
> constraint pk primary key(c1,c2));
> create table tableWithConstraint (c1 int, c2 int, constraint fk foreign
> key(c1,c2) references tableWithPrimaryKey);
> create table t1 (c11 int, c12 int);
> insert into t1 values (1,1), (2,2), (3,3);
> insert into tableWithPrimaryKey values (1, 1), (2, 2), (3, 3), (4, 4);
> insert into tableWithConstraint values (1, 1), (2, 2), (3, 3), (4, 4);
> get cursor c1 as 'select * from t1';
> next c1;
> -- In both embedded and Network server modes, delete below will throw
> exception "ERROR 23503: DELETE on
> -- table 'TABLEWITHPRIMARYKEY' caused a violation of foreign key constraint
> 'FK' for key (1,1).
> -- The statement has been rolled back."
> delete from tableWithPrimaryKey;
> -- In embedded mode, next on cursor below throws exception "ERROR XCL16:
> ResultSet not open, operation 'next' not
> -- permitted. Verify that autocommit is OFF." But in Network Server mode, the
> cursor is still open and
> -- next c1 spits out contents of next row.
> next c1;
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
