# ------------------------------------------------------------ # Start server with old datadir with # Table t1 and t2 # having c1, c2, c3 normal columns # +------+------+------+ # | c1 | c2 | c3 | # +------+------+------+ # | r1c1 | r1c2 | r1c3 | # +------+------+------+ # # Table t3 # having c1, c2 normal columns # having c3 INSTANT ADD column with NULL default value # having c4 INSTANT ADD column with default value # +------+------+------+--------+ # | c1 | c2 | c3 | c4 | # +------+------+------+--------+ # | r1c1 | r1c2 | NULL | c4_def | # +------+------+------+--------+ # ------------------------------------------------------------ # Stop the running the server # Copy and unzip the datadir. # Restart the server against the unzipped datadir # restart: --datadir=DATADIR --innodb-page-size=16k # ------------------------------------------------------------ # TEST 1 : Old version tables have no INSTANT ADD Columns # ------------------------------------------------------------ # ------------------------------------------------------------ # Check metadat of upgraded table t1 [c1, c2, c3] # Expectation : New INSTANT METADATA is not present. # ------------------------------------------------------------ # Metadata from INFORMATION_SCHEMA.TABLES NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS test/t1 6 0 0 3 3 3 # Metadata from INFORMATION_SCHEMA.COLUMNS NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED c1 0 13 16711934 0 0 0 c2 1 13 16711934 0 0 0 c3 2 13 16711934 0 0 0 # DD Metadata of table NAME SE_PRIVATE_DATA t1 NULL # DD Metadata of columns in table NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA c1 1 MYSQL_TYPE_STRING 0 Visible table_id=TABLE_ID; c2 2 MYSQL_TYPE_STRING 0 Visible table_id=TABLE_ID; c3 3 MYSQL_TYPE_STRING 0 Visible table_id=TABLE_ID; DB_ROW_ID 4 MYSQL_TYPE_INT24 0 SE table_id=TABLE_ID; DB_TRX_ID 5 MYSQL_TYPE_INT24 0 SE table_id=TABLE_ID; DB_ROLL_PTR 6 MYSQL_TYPE_LONGLONG 0 SE table_id=TABLE_ID; # ------------------------------------------------------------ # INSTANT DROP a column and check metadata t1 [c1, c3, -c2] # Expectation : New INSTANT METADATA is populated. # ------------------------------------------------------------ ALTER TABLE t1 DROP COLUMN c2, ALGORITHM=INSTANT; # Metadata from INFORMATION_SCHEMA.TABLES NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS test/t1 5 0 1 3 2 3 # Metadata from INFORMATION_SCHEMA.COLUMNS NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED c1 0 13 16711934 0 0 0 c3 1 13 16711934 0 0 0 !hidden!_dropped_v1_p4_c2 5 13 16711934 0 0 1 # DD Metadata of table NAME SE_PRIVATE_DATA t1 NULL # DD Metadata of columns in table NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA c1 1 MYSQL_TYPE_STRING 0 Visible physical_pos=3;table_id=TABLE_ID; c3 2 MYSQL_TYPE_STRING 0 Visible physical_pos=5;table_id=TABLE_ID; DB_ROW_ID 3 MYSQL_TYPE_INT24 0 SE physical_pos=0;table_id=TABLE_ID; DB_TRX_ID 4 MYSQL_TYPE_INT24 0 SE physical_pos=1;table_id=TABLE_ID; DB_ROLL_PTR 5 MYSQL_TYPE_LONGLONG 0 SE physical_pos=2;table_id=TABLE_ID; !hidden!_dropped_v1_p4_c2 6 MYSQL_TYPE_STRING 0 SE physical_pos=4;version_dropped=1; # ------------------------------------------------------------ # Check metadat of upgraded table t2 [c1, c2, c3] # Expectation : New INSTANT METADATA is not present. # ------------------------------------------------------------ # Metadata from INFORMATION_SCHEMA.TABLES NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS test/t2 6 0 0 3 3 3 # Metadata from INFORMATION_SCHEMA.COLUMNS NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED c1 0 13 16711934 0 0 0 c2 1 13 16711934 0 0 0 c3 2 13 16711934 0 0 0 # DD Metadata of table NAME SE_PRIVATE_DATA t2 NULL # DD Metadata of columns in table NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA c1 1 MYSQL_TYPE_STRING 0 Visible table_id=TABLE_ID; c2 2 MYSQL_TYPE_STRING 0 Visible table_id=TABLE_ID; c3 3 MYSQL_TYPE_STRING 0 Visible table_id=TABLE_ID; DB_ROW_ID 4 MYSQL_TYPE_INT24 0 SE table_id=TABLE_ID; DB_TRX_ID 5 MYSQL_TYPE_INT24 0 SE table_id=TABLE_ID; DB_ROLL_PTR 6 MYSQL_TYPE_LONGLONG 0 SE table_id=TABLE_ID; # ------------------------------------------------------------ # INSTANT ADD a column and check metadata t2 [c1, c2, c3, +c4] # Expectation : New INSTANT METADATA is populated. # ------------------------------------------------------------ ALTER TABLE t2 ADD COLUMN c4 CHAR(10) DEFAULT "c4_def", ALGORITHM=INSTANT; # Metadata from INFORMATION_SCHEMA.TABLES NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS test/t2 7 0 1 3 4 4 # Metadata from INFORMATION_SCHEMA.COLUMNS NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED c1 0 13 16711934 0 0 0 c2 1 13 16711934 0 0 0 c3 2 13 16711934 0 0 0 c4 3 13 16711934 1 1 0 # DD Metadata of table NAME SE_PRIVATE_DATA t2 NULL # DD Metadata of columns in table NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA c1 1 MYSQL_TYPE_STRING 0 Visible physical_pos=3;table_id=TABLE_ID; c2 2 MYSQL_TYPE_STRING 0 Visible physical_pos=4;table_id=TABLE_ID; c3 3 MYSQL_TYPE_STRING 0 Visible physical_pos=5;table_id=TABLE_ID; c4 4 MYSQL_TYPE_STRING 0 Visible default=63345f64656620202020;physical_pos=6;table_id=TABLE_ID;version_added=1; DB_ROW_ID 5 MYSQL_TYPE_INT24 0 SE physical_pos=0;table_id=TABLE_ID; DB_TRX_ID 6 MYSQL_TYPE_INT24 0 SE physical_pos=1;table_id=TABLE_ID; DB_ROLL_PTR 7 MYSQL_TYPE_LONGLONG 0 SE physical_pos=2;table_id=TABLE_ID; # ------------------------------------------------------------ # INSTANT DROP a column and check metadata t2 [c1, c2, -c3, c4] # Expectation : New INSTANT METADATA is updated. # ------------------------------------------------------------ ALTER TABLE t2 DROP COLUMN c3, ALGORITHM=INSTANT; # Metadata from INFORMATION_SCHEMA.TABLES NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS test/t2 6 0 2 3 3 4 # Metadata from INFORMATION_SCHEMA.COLUMNS NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED c1 0 13 16711934 0 0 0 c2 1 13 16711934 0 0 0 c4 2 13 16711934 1 1 0 !hidden!_dropped_v2_p5_c3 6 13 16711934 0 0 2 # DD Metadata of table NAME SE_PRIVATE_DATA t2 NULL # DD Metadata of columns in table NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA c1 1 MYSQL_TYPE_STRING 0 Visible physical_pos=3;table_id=TABLE_ID; c2 2 MYSQL_TYPE_STRING 0 Visible physical_pos=4;table_id=TABLE_ID; c4 3 MYSQL_TYPE_STRING 0 Visible default=63345f64656620202020;physical_pos=6;table_id=TABLE_ID;version_added=1; DB_ROW_ID 4 MYSQL_TYPE_INT24 0 SE physical_pos=0;table_id=TABLE_ID; DB_TRX_ID 5 MYSQL_TYPE_INT24 0 SE physical_pos=1;table_id=TABLE_ID; DB_ROLL_PTR 6 MYSQL_TYPE_LONGLONG 0 SE physical_pos=2;table_id=TABLE_ID; !hidden!_dropped_v2_p5_c3 7 MYSQL_TYPE_STRING 0 SE physical_pos=5;version_dropped=2; DROP TABLE t1; DROP TABLE t2; # ------------------------------------------------------------ # TEST 2 : Old version tables have INSTANT ADD Columns # ------------------------------------------------------------ # ------------------------------------------------------------ # Check metadat of upgraded table t3 [c1, c2, c3, c4] # Expectation : Old INSTANT METADATA is present # New INSTANT METADATA is not present. # ------------------------------------------------------------ # Metadata from INFORMATION_SCHEMA.TABLES NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS test/t3 7 2 0 4 4 4 # Metadata from INFORMATION_SCHEMA.COLUMNS NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED c1 0 13 16711934 0 0 0 c2 1 13 16711934 0 0 0 c3 2 13 16711934 1 0 0 c4 3 13 16711934 1 0 0 # DD Metadata of table NAME SE_PRIVATE_DATA t3 instant_col=2; # DD Metadata of columns in table NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA c1 1 MYSQL_TYPE_STRING 0 Visible table_id=TABLE_ID; c2 2 MYSQL_TYPE_STRING 0 Visible table_id=TABLE_ID; c3 3 MYSQL_TYPE_STRING 0 Visible default_null=1;table_id=TABLE_ID; c4 4 MYSQL_TYPE_STRING 0 Visible default=63345f64656620202020;table_id=TABLE_ID; DB_ROW_ID 5 MYSQL_TYPE_INT24 0 SE table_id=TABLE_ID; DB_TRX_ID 6 MYSQL_TYPE_INT24 0 SE table_id=TABLE_ID; DB_ROLL_PTR 7 MYSQL_TYPE_LONGLONG 0 SE table_id=TABLE_ID; # -------------------------------------------------------------------- # INSTANT DROP a normal column and check metadata t3 [c1, -c2, c3, c4] # Expectation : Old INSTANT METADATA stays same. # New INSTANT METADATA is populated. # --------------------------------------------------------------------- ALTER TABLE t3 DROP COLUMN c2, ALGORITHM=INSTANT; # Metadata from INFORMATION_SCHEMA.TABLES NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS test/t3 6 2 1 4 3 4 # Metadata from INFORMATION_SCHEMA.COLUMNS NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED c1 0 13 16711934 0 0 0 c3 1 13 16711934 1 0 0 c4 2 13 16711934 1 0 0 !hidden!_dropped_v1_p4_c2 6 13 16711934 0 0 1 # DD Metadata of table NAME SE_PRIVATE_DATA t3 instant_col=2; # DD Metadata of columns in table NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA c1 1 MYSQL_TYPE_STRING 0 Visible physical_pos=3;table_id=TABLE_ID; c3 2 MYSQL_TYPE_STRING 0 Visible default_null=1;physical_pos=5;table_id=TABLE_ID; c4 3 MYSQL_TYPE_STRING 0 Visible default=63345f64656620202020;physical_pos=6;table_id=TABLE_ID; DB_ROW_ID 4 MYSQL_TYPE_INT24 0 SE physical_pos=0;table_id=TABLE_ID; DB_TRX_ID 5 MYSQL_TYPE_INT24 0 SE physical_pos=1;table_id=TABLE_ID; DB_ROLL_PTR 6 MYSQL_TYPE_LONGLONG 0 SE physical_pos=2;table_id=TABLE_ID; !hidden!_dropped_v1_p4_c2 7 MYSQL_TYPE_STRING 0 SE physical_pos=4;version_dropped=1; # ----------------------------------------------------------------------- # INSTANT DROP an INSTANT column and check metadata t3 [c1, ~c2, -c3, c4] # Expectation : Old INSTANT METADATA stays same. # New INSTANT METADATA is updated. # ----------------------------------------------------------------------- ALTER TABLE t3 DROP COLUMN c3, ALGORITHM=INSTANT; # Metadata from INFORMATION_SCHEMA.TABLES NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS test/t3 5 2 2 4 2 4 # Metadata from INFORMATION_SCHEMA.COLUMNS NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED c1 0 13 16711934 0 0 0 c4 1 13 16711934 1 0 0 !hidden!_dropped_v1_p4_c2 5 13 16711934 0 0 1 !hidden!_dropped_v2_p5_c3 6 13 16711934 0 0 2 # DD Metadata of table NAME SE_PRIVATE_DATA t3 instant_col=2; # DD Metadata of columns in table NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA c1 1 MYSQL_TYPE_STRING 0 Visible physical_pos=3;table_id=TABLE_ID; c4 2 MYSQL_TYPE_STRING 0 Visible default=63345f64656620202020;physical_pos=6;table_id=TABLE_ID; DB_ROW_ID 3 MYSQL_TYPE_INT24 0 SE physical_pos=0;table_id=TABLE_ID; DB_TRX_ID 4 MYSQL_TYPE_INT24 0 SE physical_pos=1;table_id=TABLE_ID; DB_ROLL_PTR 5 MYSQL_TYPE_LONGLONG 0 SE physical_pos=2;table_id=TABLE_ID; !hidden!_dropped_v1_p4_c2 6 MYSQL_TYPE_STRING 0 SE physical_pos=4;version_dropped=1; !hidden!_dropped_v2_p5_c3 7 MYSQL_TYPE_STRING 0 SE physical_pos=5;version_dropped=2; # ----------------------------------------------------------------------- # INSTANT ADD a new column and check metadata t3 [c1, ~c2, ~c3, c4, +c5] # Expectation : Old INSTANT METADATA stays same. # New INSTANT METADATA is updated. # ----------------------------------------------------------------------- ALTER TABLE t3 ADD COLUMN c5 CHAR(10) DEFAULT "c5_def", ALGORITHM=INSTANT; # Metadata from INFORMATION_SCHEMA.TABLES NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS test/t3 6 2 3 4 3 5 # Metadata from INFORMATION_SCHEMA.COLUMNS NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED c1 0 13 16711934 0 0 0 c4 1 13 16711934 1 0 0 c5 2 13 16711934 1 3 0 !hidden!_dropped_v1_p4_c2 6 13 16711934 0 0 1 !hidden!_dropped_v2_p5_c3 7 13 16711934 0 0 2 # DD Metadata of table NAME SE_PRIVATE_DATA t3 instant_col=2; # DD Metadata of columns in table NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA c1 1 MYSQL_TYPE_STRING 0 Visible physical_pos=3;table_id=TABLE_ID; c4 2 MYSQL_TYPE_STRING 0 Visible default=63345f64656620202020;physical_pos=6;table_id=TABLE_ID; c5 3 MYSQL_TYPE_STRING 0 Visible default=63355f64656620202020;physical_pos=7;table_id=TABLE_ID;version_added=3; DB_ROW_ID 4 MYSQL_TYPE_INT24 0 SE physical_pos=0;table_id=TABLE_ID; DB_TRX_ID 5 MYSQL_TYPE_INT24 0 SE physical_pos=1;table_id=TABLE_ID; DB_ROLL_PTR 6 MYSQL_TYPE_LONGLONG 0 SE physical_pos=2;table_id=TABLE_ID; !hidden!_dropped_v1_p4_c2 7 MYSQL_TYPE_STRING 0 SE physical_pos=4;version_dropped=1; !hidden!_dropped_v2_p5_c3 8 MYSQL_TYPE_STRING 0 SE physical_pos=5;version_dropped=2; # ----------------------------------------------------------------------------- # INSTANT DROP newly added column and check metadata t3 [c1, ~c2, ~c3, c4, -c5] # Expectation : Old INSTANT METADATA stays same. # New INSTANT METADATA is updated. # ----------------------------------------------------------------------------- ALTER TABLE t3 DROP COLUMN c5, ALGORITHM=INSTANT; # Metadata from INFORMATION_SCHEMA.TABLES NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS test/t3 5 2 4 4 2 5 # Metadata from INFORMATION_SCHEMA.COLUMNS NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED c1 0 13 16711934 0 0 0 c4 1 13 16711934 1 0 0 !hidden!_dropped_v1_p4_c2 5 13 16711934 0 0 1 !hidden!_dropped_v2_p5_c3 6 13 16711934 0 0 2 !hidden!_dropped_v4_p7_c5 7 13 16711934 0 3 4 # DD Metadata of table NAME SE_PRIVATE_DATA t3 instant_col=2; # DD Metadata of columns in table NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA c1 1 MYSQL_TYPE_STRING 0 Visible physical_pos=3;table_id=TABLE_ID; c4 2 MYSQL_TYPE_STRING 0 Visible default=63345f64656620202020;physical_pos=6;table_id=TABLE_ID; DB_ROW_ID 3 MYSQL_TYPE_INT24 0 SE physical_pos=0;table_id=TABLE_ID; DB_TRX_ID 4 MYSQL_TYPE_INT24 0 SE physical_pos=1;table_id=TABLE_ID; DB_ROLL_PTR 5 MYSQL_TYPE_LONGLONG 0 SE physical_pos=2;table_id=TABLE_ID; !hidden!_dropped_v1_p4_c2 6 MYSQL_TYPE_STRING 0 SE physical_pos=4;version_dropped=1; !hidden!_dropped_v2_p5_c3 7 MYSQL_TYPE_STRING 0 SE physical_pos=5;version_dropped=2; !hidden!_dropped_v4_p7_c5 8 MYSQL_TYPE_STRING 0 SE physical_pos=7;version_added=3;version_dropped=4; DROP TABLE t3; # ------------------------------------------------- # TEST 3 : New tables with INSTANT ADD/DROP Columns # ------------------------------------------------- CREATE TABLE t1 (c1 char(10), c2 char(10), c3 char(10)); # ------------------------------------------------------------ # Check metadat of table t1 [c1, c2, c3] # Expectation : Old INSTANT METADATA is not present # New INSTANT METADATA is not present. # ------------------------------------------------------------ # Metadata from INFORMATION_SCHEMA.TABLES NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS test/t1 6 0 0 3 3 3 # Metadata from INFORMATION_SCHEMA.COLUMNS NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED c1 0 13 16711934 0 0 0 c2 1 13 16711934 0 0 0 c3 2 13 16711934 0 0 0 # DD Metadata of table NAME SE_PRIVATE_DATA t1 NULL # DD Metadata of columns in table NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA c1 1 MYSQL_TYPE_STRING 0 Visible table_id=TABLE_ID; c2 2 MYSQL_TYPE_STRING 0 Visible table_id=TABLE_ID; c3 3 MYSQL_TYPE_STRING 0 Visible table_id=TABLE_ID; DB_ROW_ID 4 MYSQL_TYPE_INT24 0 SE table_id=TABLE_ID; DB_TRX_ID 5 MYSQL_TYPE_INT24 0 SE table_id=TABLE_ID; DB_ROLL_PTR 6 MYSQL_TYPE_LONGLONG 0 SE table_id=TABLE_ID; # ----------------------------------------------------------------------- # INSTANT DROP a column and check metadata t1 [c1, -c2, c3] # Expectation : Old INSTANT METADATA is not present. # New INSTANT METADATA is populated. # ----------------------------------------------------------------------- ALTER TABLE t1 DROP COLUMN c2, ALGORITHM=INSTANT; # Metadata from INFORMATION_SCHEMA.TABLES NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS test/t1 5 0 1 3 2 3 # Metadata from INFORMATION_SCHEMA.COLUMNS NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED c1 0 13 16711934 0 0 0 c3 1 13 16711934 0 0 0 !hidden!_dropped_v1_p4_c2 5 13 16711934 0 0 1 # DD Metadata of table NAME SE_PRIVATE_DATA t1 NULL # DD Metadata of columns in table NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA c1 1 MYSQL_TYPE_STRING 0 Visible physical_pos=3;table_id=TABLE_ID; c3 2 MYSQL_TYPE_STRING 0 Visible physical_pos=5;table_id=TABLE_ID; DB_ROW_ID 3 MYSQL_TYPE_INT24 0 SE physical_pos=0;table_id=TABLE_ID; DB_TRX_ID 4 MYSQL_TYPE_INT24 0 SE physical_pos=1;table_id=TABLE_ID; DB_ROLL_PTR 5 MYSQL_TYPE_LONGLONG 0 SE physical_pos=2;table_id=TABLE_ID; !hidden!_dropped_v1_p4_c2 6 MYSQL_TYPE_STRING 0 SE physical_pos=4;version_dropped=1; # ----------------------------------------------------------------------- # INSTANT ADD a column and check metadata t1 [+c0, c1, ~c2, c3] # Expectation : Old INSTANT METADATA not present. # New INSTANT METADATA is updated. # ----------------------------------------------------------------------- ALTER TABLE t1 ADD COLUMN c0 CHAR(10) DEFAULT "c0_def" FIRST, ALGORITHM=INSTANT; # Metadata from INFORMATION_SCHEMA.TABLES NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS test/t1 6 0 2 3 3 4 # Metadata from INFORMATION_SCHEMA.COLUMNS NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED c0 0 13 16711934 1 2 0 c1 1 13 16711934 0 0 0 c3 2 13 16711934 0 0 0 !hidden!_dropped_v1_p4_c2 6 13 16711934 0 0 1 # DD Metadata of table NAME SE_PRIVATE_DATA t1 NULL # DD Metadata of columns in table NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA c0 1 MYSQL_TYPE_STRING 0 Visible default=63305f64656620202020;physical_pos=6;table_id=TABLE_ID;version_added=2; c1 2 MYSQL_TYPE_STRING 0 Visible physical_pos=3;table_id=TABLE_ID; c3 3 MYSQL_TYPE_STRING 0 Visible physical_pos=5;table_id=TABLE_ID; DB_ROW_ID 4 MYSQL_TYPE_INT24 0 SE physical_pos=0;table_id=TABLE_ID; DB_TRX_ID 5 MYSQL_TYPE_INT24 0 SE physical_pos=1;table_id=TABLE_ID; DB_ROLL_PTR 6 MYSQL_TYPE_LONGLONG 0 SE physical_pos=2;table_id=TABLE_ID; !hidden!_dropped_v1_p4_c2 7 MYSQL_TYPE_STRING 0 SE physical_pos=4;version_dropped=1; # ---------------------------------------------------------------------------- # INSTANT DROP the INSTANT ADD column and check metadata t1 [-c0, c1, ~c2, c3] # Expectation : Old INSTANT METADATA is not present. # New INSTANT METADATA is updated. # ---------------------------------------------------------------------------- ALTER TABLE t1 DROP COLUMN c0, ALGORITHM=INSTANT; # Metadata from INFORMATION_SCHEMA.TABLES NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS test/t1 5 0 3 3 2 4 # Metadata from INFORMATION_SCHEMA.COLUMNS NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED c1 0 13 16711934 0 0 0 c3 1 13 16711934 0 0 0 !hidden!_dropped_v1_p4_c2 5 13 16711934 0 0 1 !hidden!_dropped_v3_p6_c0 6 13 16711934 0 2 3 # DD Metadata of table NAME SE_PRIVATE_DATA t1 NULL # DD Metadata of columns in table NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA c1 1 MYSQL_TYPE_STRING 0 Visible physical_pos=3;table_id=TABLE_ID; c3 2 MYSQL_TYPE_STRING 0 Visible physical_pos=5;table_id=TABLE_ID; DB_ROW_ID 3 MYSQL_TYPE_INT24 0 SE physical_pos=0;table_id=TABLE_ID; DB_TRX_ID 4 MYSQL_TYPE_INT24 0 SE physical_pos=1;table_id=TABLE_ID; DB_ROLL_PTR 5 MYSQL_TYPE_LONGLONG 0 SE physical_pos=2;table_id=TABLE_ID; !hidden!_dropped_v1_p4_c2 6 MYSQL_TYPE_STRING 0 SE physical_pos=4;version_dropped=1; !hidden!_dropped_v3_p6_c0 7 MYSQL_TYPE_STRING 0 SE physical_pos=6;version_added=2;version_dropped=3; DROP TABLE t1; ########### # CLEANUP # ########### # Shutdown server # Remove copied files # Restarting server to restore server state # restart