Re-implement expanded fast index creation in 8.0 DD
General
Escalation
General
Escalation
Description
Environment
None
is blocked by
is duplicated by
relates to
Activity
Satya Bodapati
February 5, 2019 at 12:11 PM
Fingers crossed
roel.vandepaar
February 5, 2019 at 10:56 AM
Testing latest commit (one from 6hrs ago) in https://perconadev.atlassian.net/browse/PS-5401#icft=PS-5401
Satya Bodapati
January 31, 2019 at 11:38 AM
New implementation at https://github.com/percona/percona-server/pull/2971
roel.vandepaar
December 21, 2018 at 1:02 PM
For the developer who implements this; after re-implementation please check this testcase does not fail on opt+dbg.
CREATE DATABASE test;
USE test;
SET expand_fast_index_creation=1;
CREATE TEMPORARY TABLE t1(id int auto_increment key,a int,index(a));
ALTER TABLE t1 MODIFY COLUMN a ENUM('','a6','a7','a8','a9','a10');
Laurynas Biveinis
December 20, 2018 at 9:49 AM
Revert https://perconadev.atlassian.net/browse/PS-5124#icft=PS-5124 and https://perconadev.atlassian.net/browse/PS-5195#icft=PS-5195 when this is worked on
Done
Created September 24, 2018 at 2:28 PM
Updated March 6, 2024 at 12:48 PM
Resolved February 5, 2019 at 4:55 AM
A straightforward port from 5.7 does not work due the need of having to pass valid dd::Table objects around, including for intermediate stages of ALTER TABLE. Thus, re-implement in proper 8.0 data dictionary way.