Debian Codegraph @

mysql-test/suite/innodb/t/alter_table_upgrade.test

raw
1 --source include/have_innodb.inc
2
3 let $datadir=`select @@datadir`;
4
5 --echo #
6 --echo # Start of 10.4 tests
7 --echo #
8
9 --echo #
10 --echo # MDEV-29481 mariadb-upgrade prints confusing statement
11 --echo #
12
13 CREATE TABLE pet4 (
14 build_time double(18,7) DEFAULT NULL,
15 KEY idx1 (build_time)) ENGINE=InnoDB;
16 FLUSH TABLES;
17 remove_file $datadir/test/pet4.frm;
18 copy_file std_data/mysql_upgrade/mdev29481_100104_innodb.frm $datadir/test/pet4.frm;
19 SHOW CREATE TABLE pet4;
20 CHECK TABLE pet4 FOR UPGRADE;
21 ALTER TABLE pet4 ADD i1 INTEGER, ALGORITHM=INSTANT;
22 DROP TABLE pet4;
23
24 CREATE TABLE pet4 (
25 build_time double(18,7) DEFAULT NULL,
26 KEY idx1 (build_time)) ENGINE=InnoDB;
27 FLUSH TABLES;
28 remove_file $datadir/test/pet4.frm;
29 copy_file std_data/mysql_upgrade/mdev29481_100104_innodb.frm $datadir/test/pet4.frm;
30 SHOW CREATE TABLE pet4;
31 ALTER TABLE pet4 ADD i1 INTEGER, ALGORITHM=NOCOPY;
32 DROP TABLE pet4;
33
34 --echo #
35 --echo # End of 10.4 tests
36 --echo #