Debian Codegraph @

mysql-test/suite/vcol/t/upgrade.test

raw
1 #
2 # MDEV-12936 upgrade to 10.2.6 failed upon tables with virtual columns
3 #
4 let $datadir=`select @@datadir`;
5 copy_file std_data/vcol_autoinc.frm $datadir/test/vcol_autoinc.frm;
6 copy_file std_data/vcol_autoinc.MYD $datadir/test/vcol_autoinc.MYD;
7 copy_file std_data/vcol_autoinc.MYI $datadir/test/vcol_autoinc.MYI;
8 check table vcol_autoinc for upgrade;
9 show create table vcol_autoinc;
10 select * from vcol_autoinc;
11 insert vcol_autoinc (pk) values (1);
12 select * from vcol_autoinc;
13 drop table vcol_autoinc;
14
15 #
16 # MDEV-17909 Problem by MariaDB Update 10.1.32 -> 10.2.19 (Incorrect information in file: .frm)
17 #
18 source include/have_partition.inc;
19 copy_file std_data/mdev17909#P#p20181029.MYD $datadir/test/t1#P#p20181029.MYD;
20 copy_file std_data/mdev17909#P#p20181029.MYI $datadir/test/t1#P#p20181029.MYI;
21 copy_file std_data/mdev17909#P#p20181128.MYD $datadir/test/t1#P#p20181128.MYD;
22 copy_file std_data/mdev17909#P#p20181128.MYI $datadir/test/t1#P#p20181128.MYI;
23 copy_file std_data/mdev17909.frm $datadir/test/t1.frm;
24 copy_file std_data/mdev17909.par $datadir/test/t1.par;
25 check table t1 for upgrade;
26 flush tables;
27 show create table t1;
28 drop table t1;