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
- blocks
-
MDEV-10393 Foreign keys SET DEFAULT action
- Open
-
MDEV-22880 Honor constraints on UPDATE CASCADE
- Open
- is blocked by
-
MDEV-30182 Optimize open_tables to take O(N) time
- In Review
- relates to
-
MDEV-22361 Cross-engine foreign keys support
- Open
-
MDEV-34151 Userstat does not count rows updated via FK cascade
- Open
- split from
-
MDEV-16329 Engine-independent online ALTER TABLE
- Closed