Debian Codegraph @

mysql-test/suite/innodb/r/table_options.result

raw
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;