Details
-
Task
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
Description
Currently, ALGORITHM=COPY, LOCK=NONE is disabled for tables with cascade foreign keys (including SET NULL/SET DEFAULT).
The preliminary patch, 4b758fdc73, was done yet in scope of MDEV-29068 bugfix.
As it was noted by Marko Mäkelä, the implementation would be unaffordably slow. Using table->vc_templ->mysql_table for a backward access to sql-layer table, as noted further, is broken by design. This should be fixed by MDEV-29181.
Additionally, MDEV-30182 should provide an affordably fast (O(1)) FK-prelocked table lookup, which should be made per updated record.
Attachments
Issue Links
- is blocked by
-
MDEV-29181 Potential corruption on Foreign key update on a table with vcol index
- Stalled
- relates to
-
MDEV-22361 Cross-engine foreign keys support
- Open
- split from
-
MDEV-16329 Engine-independent online ALTER TABLE
- Closed