[DERBY-6576] A immediate Fk constraint blows up iff its referenced PK is deferred and we modify a duplicate key column - ASF JIRA

XML

Word

Printable

JSON

Details

Type: Bug
Status: Closed
Priority: Major
Resolution: Fixed
Affects Version/s: None
Fix Version/s: 10.11.1.1
Component/s: SQL
Labels:
- derby_backport_reject_10_10

Description

Similar to the issue in ~~DERBY-6559~~, except here we modify the key in the referenced table. This leads Derby to check for any referencing FK and throw, even if there are other (formerly) duplicate rows that satisfy the FK constraint.

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending

derby-6576.diff
13/May/14 20:15
14 kB
Dag H. Wanvik
derby-6576.status
13/May/14 20:17
0.8 kB
Dag H. Wanvik
derby-6576-2.diff
13/May/14 21:05
17 kB
Dag H. Wanvik
derby-6576-3.diff
15/May/14 11:11
36 kB
Dag H. Wanvik
derby-6576-3.status
15/May/14 11:11
1 kB
Dag H. Wanvik
derby-6576-cascade-setnull.diff
26/May/14 14:41
85 kB
Dag H. Wanvik
derby-6576-cascade-setnull.status
26/May/14 14:41
2 kB
Dag H. Wanvik
derby-6576-forbid-deferred+cascade-set-null-1.diff
02/Jun/14 13:06
55 kB
Dag H. Wanvik
derby-6576-forbid-deferred+cascade-set-null-1.status
02/Jun/14 13:06
2 kB
Dag H. Wanvik
derby-6576-repeatable-read.diff
05/Jun/14 21:53
2 kB
Dag H. Wanvik

Issue Links

breaks

DERBY-532 Support deferrable constraints

Closed

is related to

DERBY-6559 A immediate Fk constraint blows up iff its referenced PK is deferred and we delete a duplicate

Closed

relates to

DERBY-6759 Derby 10.10 backport issue (fall 2014)

Closed

Activity

People

Assignee:: Dag H. Wanvik

Reporter:: Dag H. Wanvik

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 13/May/14 18:54

Updated:: 09/Oct/14 16:04

Resolved:: 05/Jun/14 22:01