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

        Hide
        Kristian Waagan added a comment -

        Unassigning due to inactivity.

        Sylvain, if you still want to work on this feel free to reassign it you yourself.

        Show
        Kristian Waagan added a comment - Unassigning due to inactivity. Sylvain, if you still want to work on this feel free to reassign it you yourself.
        Hide
        Sylvain Leroux added a comment -

        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
        Show
        Sylvain Leroux added a comment - 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
        Hide
        Gabriele Kahlout added a comment - - edited

        Supported by SQLite and MySQL.

        Show
        Gabriele Kahlout added a comment - - edited Supported by SQLite and MySQL.

          People

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

            Dates

            • Created:
              Updated:

              Development