[DERBY-735] Need implementation for `ON UPDATE CASCADE`

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 10.1.2.1
• Component/s: SQL
• Labels: derby_triage10_11
• Environment: Gentoo Linux, JDK 1.5.0_04
• Urgency: Low
• Assignee: Lahiru Wijewardana
• Reporter: Igor Galchevsky
• Created: 01/Dec/05 04:10
• Updated: 27/Sep/17 16:41

Description

Ifound no chance to implement such statement in derby

CREATE TABLE A (
ax INTEGER NOT NULL,

PRIMARY KEY(ax)
);

CREATE TABLE B (

bx INTEGER NOT NULL,

FOREIGN KEY (bx) REFERENCES A (ax)
ON UPDATE CASCADE – can't make this work
ON DELETE CASCADE
);

Seems `ON UPDATE CASCADE` does not implemented in derby yet.

P.S. I found this working in HSQL, M$SQL, PostgreSQL... but not in
debry