Derby
  1. Derby
  2. DERBY-735

Need implementation for `ON UPDATE CASCADE`

    Details

    • Type: Improvement Improvement
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: 10.1.2.1
    • Fix Version/s: None
    • Component/s: SQL
    • Environment:
      Gentoo Linux, JDK 1.5.0_04
    • Urgency:
      Low

      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

        Activity

          People

          • Assignee:
            Unassigned
            Reporter:
            Igor Galchevsky
          • Votes:
            7 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

            • Created:
              Updated:

              Development