| 1 |
SET SESSION debug= '+d,skip_dd_table_access_check'; |
| 2 |
CREATE TABLE t1 (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, a char(10)); |
| 3 |
INSERT INTO t1 VALUES(1, 'aa'); |
| 4 |
INSERT INTO t1 VALUES(2, 'bb'); |
| 5 |
SELECT options FROM mysql.tables WHERE name LIKE "%t1%"; |
| 6 |
options |
| 7 |
avg_row_length=0;encrypt_type=N;key_block_size=0;keys_disabled=0;pack_record=0;stats_auto_recalc=0;stats_sample_pages=0; |
| 8 |
ALTER TABLE t1 ADD b VARCHAR(20), ALGORITHM=INSTANT; |
| 9 |
SELECT options FROM mysql.tables WHERE name LIKE "%t1%"; |
| 10 |
options |
| 11 |
avg_row_length=0;encrypt_type=N;key_block_size=0;keys_disabled=0;pack_record=1;stats_auto_recalc=0;stats_sample_pages=0; |
| 12 |
DROP TABLE t1; |
| 13 |
CREATE TABLE t1 (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, a char(10)); |
| 14 |
INSERT INTO t1 VALUES(1, 'aa'); |
| 15 |
INSERT INTO t1 VALUES(2, 'bb'); |
| 16 |
SELECT options FROM mysql.tables WHERE name LIKE "%t1%"; |
| 17 |
options |
| 18 |
avg_row_length=0;encrypt_type=N;key_block_size=0;keys_disabled=0;pack_record=0;stats_auto_recalc=0;stats_sample_pages=0; |
| 19 |
ALTER TABLE t1 ADD b VARCHAR(20), ALGORITHM=COPY; |
| 20 |
SELECT options FROM mysql.tables WHERE name LIKE "%t1%"; |
| 21 |
options |
| 22 |
avg_row_length=0;encrypt_type=N;key_block_size=0;keys_disabled=0;pack_record=1;stats_auto_recalc=0;stats_sample_pages=0; |
| 23 |
DROP TABLE t1; |
| 24 |
CREATE TABLE t1 (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, a char(10)); |
| 25 |
INSERT INTO t1 VALUES(1, 'aa'); |
| 26 |
INSERT INTO t1 VALUES(2, 'bb'); |
| 27 |
SELECT options FROM mysql.tables WHERE name LIKE "%t1%"; |
| 28 |
options |
| 29 |
avg_row_length=0;encrypt_type=N;key_block_size=0;keys_disabled=0;pack_record=0;stats_auto_recalc=0;stats_sample_pages=0; |
| 30 |
ALTER TABLE t1 ADD b VARCHAR(20), ALGORITHM=INPLACE; |
| 31 |
SELECT options FROM mysql.tables WHERE name LIKE "%t1%"; |
| 32 |
options |
| 33 |
avg_row_length=0;encrypt_type=N;key_block_size=0;keys_disabled=0;pack_record=1;stats_auto_recalc=0;stats_sample_pages=0; |
| 34 |
DROP TABLE t1; |