Debian Codegraph @

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

raw
1 #
2 # Start of 10.4 tests
3 #
4 #
5 # MDEV-29481 mariadb-upgrade prints confusing statement
6 #
7 CREATE TABLE pet4 (
8 build_time double(18,7) DEFAULT NULL,
9 KEY idx1 (build_time)) ENGINE=InnoDB;
10 FLUSH TABLES;
11 SHOW CREATE TABLE pet4;
12 Table Create Table
13 pet4 CREATE TABLE `pet4` (
14 `build_time` double(18,7) DEFAULT NULL,
15 KEY `idx1` (`build_time`)
16 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci
17 CHECK TABLE pet4 FOR UPGRADE;
18 Table Op Msg_type Msg_text
19 test.pet4 check status OK
20 ALTER TABLE pet4 ADD i1 INTEGER, ALGORITHM=INSTANT;
21 DROP TABLE pet4;
22 CREATE TABLE pet4 (
23 build_time double(18,7) DEFAULT NULL,
24 KEY idx1 (build_time)) ENGINE=InnoDB;
25 FLUSH TABLES;
26 SHOW CREATE TABLE pet4;
27 Table Create Table
28 pet4 CREATE TABLE `pet4` (
29 `build_time` double(18,7) DEFAULT NULL,
30 KEY `idx1` (`build_time`)
31 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci
32 ALTER TABLE pet4 ADD i1 INTEGER, ALGORITHM=NOCOPY;
33 DROP TABLE pet4;
34 #
35 # End of 10.4 tests
36 #