Details
-
Task
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
Description
Add support for WITH VALIDATE | WITHOUT VALIDATE to
ALTER TABLE ... EXCHANGE PARTITION ... WITH TABLE
MySQL has had this since 5.7.5 and it's important when adding big tables to a partitioned table to avoid the expensive row-by-row check.
When WITHOUT VALIDATION is specified, there is no check that all rows in the added table fulfills the partition restrictions. If there is inconsistencies, it will result in rows later not being found in SELECT, UPDATE or DELETE.
WITH VALIDATION should be the default behavior.
Should also cover CONVERT {TABLE|PARTITION} TO
Attachments
Issue Links
- is part of
-
MDEV-22162 Make partitions more flexible to use
-
- Open
-
- relates to
-
MDEV-22165 CONVERT TABLE: move in partition from existing table
-
- Closed
-
-
MDEV-22166 CONVERT PARTITION: move out partition into a table
-
- Closed
-
-
MDEV-28298 Add Foreign key to a table instantly without checking existing data
-
- Open
-