[ https://issues.apache.org/jira/browse/DERBY-735?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12845790#action_12845790 ]
Sylvain Leroux commented on DERBY-735: -------------------------------------- It does seem to be a desirable feature. I don't have any idea how much work it is - nor where to start from. But with some help I could work on it. - Sylvain > Need implementation for `ON UPDATE CASCADE` > ------------------------------------------- > > Key: DERBY-735 > URL: https://issues.apache.org/jira/browse/DERBY-735 > Project: Derby > Issue Type: Improvement > Components: SQL > Affects Versions: 10.1.2.1 > Environment: Gentoo Linux, JDK 1.5.0_04 > Reporter: Igor Galchevsky > > 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 :( -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.