Debian Codegraph @

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

raw
1 ############################################################################################
2 # Bug#28869903 MISSING INFO ON PARTITIONED TABLES IN I_S.INNODB_COLUMNS AFTER UPGRADE TO 8.0
3 ############################################################################################
4
5 --source include/have_debug.inc
6 --source include/not_valgrind.inc
7 --source include/have_case_sensitive_file_system.inc
8
9 --echo #
10 --echo # This test upgrades a partitioned table from 5.7 to 8.0.x and
11 --echo # checks that INFORMATION_SCHEMA.INNODB_COLUMNS shows columns
12 --echo # for all the partitions
13 --echo #
14
15 --echo # Stop the running the server
16 --source include/shutdown_mysqld.inc
17
18 --echo ######################################################################
19 --echo # Unzip a 5.7 datadir with partitioned table, start the server using
20 --echo # this directory
21 --echo ######################################################################
22
23 --echo ######################################################################
24 --echo # Copy and unzip the datadir.
25 --echo ######################################################################
26 --copy_file $MYSQLTEST_VARDIR/std_data/data57_partition.zip $MYSQL_TMP_DIR/data57_partition.zip
27 --file_exists $MYSQL_TMP_DIR/data57_partition.zip
28 --exec unzip -qo $MYSQL_TMP_DIR/data57_partition.zip -d $MYSQL_TMP_DIR
29 let $BUGDATADIR = $MYSQL_TMP_DIR/data57_partition;
30
31 --echo # Restart the server against the unzipped datadir
32 --replace_result $BUGDATADIR BUGDATADIR
33 --let $restart_parameters = restart: --datadir=$BUGDATADIR --innodb_page_size=16k
34 --let $wait_counter=3000
35 --source include/start_mysqld.inc
36
37 --echo # Checks the contents of INFORMATION_SCHEMA.INNODB_COLUMNS
38 SELECT lower(t.name), lower(c.name) FROM
39 INFORMATION_SCHEMA.INNODB_COLUMNS c
40 JOIN INFORMATION_SCHEMA.INNODB_TABLES t
41 WHERE t.table_id=c.table_id AND t.name LIKE '%t1%'
42 ORDER BY t.name, c.name;
43
44 --echo # Cleanup
45 --echo # Shutdown server
46 --source include/shutdown_mysqld.inc
47
48 --echo # Remove copied files
49 --file_exists $MYSQL_TMP_DIR/data57_partition.zip
50 --force-rmdir $MYSQL_TMP_DIR/data57_partition
51 --remove_file $MYSQL_TMP_DIR/data57_partition.zip
52
53 --echo # Resart the server
54 let $restart_parameters =;
55 --source include/start_mysqld.inc