Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-22361

Cross-engine foreign keys support

    XMLWordPrintable

    Details

      Description

      Implement cross-engine foreign keys check at SQL layer.

      TODO:

      • Referenced/foreign key lookup procedure
      • Recursive table open (new FK structure for TABLE optimized for DML, FKs in TABLE point to parent TABLEs)
      • Recursive prelocking: write-locking for CASCADE actions
      • DML changes:
        UPDATE, Multi-UPDATE
        DELETE, Multi-DELETE
        REPLACE
        INSERT ODKU
        IGNORE clause
        Ignore ‘DELAYED’
      • DDL changes:
        DROP TABLE (DATABASE)

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              midenok Aleksey Midenkov
              Reporter:
              midenok Aleksey Midenkov
              Votes:
              4 Vote for this issue
              Watchers:
              7 Start watching this issue

                Dates

                Created:
                Updated:

                  Git Integration