Details
-
Task
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
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
- includes
-
MDEV-10393 Foreign keys SET DEFAULT action
-
- Open
-
-
MDEV-19191 FK support for CURRENT partition of versioned tables
-
- Stalled
-
- is blocked by
-
MDEV-16417 Store Foreign Key metadata outside of InnoDB
-
- In Review
-
- relates to
-
MDEV-17598 InnoDB index option for per-record transaction ID
-
- Open
-
-
MDEV-20777 Foreign keys without indexes
-
- Open
-
-
MDEV-26554 Table-rebuilding DDL on parent table causes crash for INSERT into child table
-
- Closed
-
-
MDEV-12483 Add foreign keys support for partitioned tables
-
- Stalled
-
-
MDEV-13538 better error reporting when FOREIGN KEY CONSTRAINT fails
-
- Closed
-
-
MDEV-22363 Reimplement the InnoDB virtual column code
-
- Open
-
-
MDEV-23716 FK validate data but in select join tables parent and child don't search data
-
- Closed
-
-
MDEV-26097 Constraints: support deferred constraints
-
- Open
-
- links to