db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Igor Galchevsky (JIRA)" <derby-...@db.apache.org>
Subject [jira] Created: (DERBY-735) Need implementation for `ON UPDATE CASCADE`
Date Wed, 30 Nov 2005 19:10:30 GMT
Need implementation for `ON UPDATE CASCADE` 
--------------------------------------------

         Key: DERBY-735
         URL: http://issues.apache.org/jira/browse/DERBY-735
     Project: Derby
        Type: New Feature
  Components: SQL  
    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.
-
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


Mime
View raw message