Debian Codegraph @

mysql-test/suite/information_schema/t/upgrade_cs.test

raw
1 --echo ########################################################################
2 --echo # This test scripts covers meta data related aspects of upgrade
3 --echo # after 8.0.
4 --echo ########################################################################
5
6 --source include/have_case_sensitive_file_system.inc
7 --source include/not_valgrind.inc
8
9 --echo #-----------------------------------------------------------------------
10 --echo # WL#10895: INFORMATION_SCHEMA views for Roles
11 --echo # Test case to verify that new I_S tables introduced by this WL
12 --echo # are present after upgrade.
13 --echo #-----------------------------------------------------------------------
14
15 --let $MYSQLD_LOG= $MYSQLTEST_VARDIR/log/save_dd_upgrade_1.log
16
17 --echo # Copy the remote tablespace & DB zip files from suite location to working location.
18 --copy_file $MYSQLTEST_VARDIR/std_data/upgrade/data_80014.zip $MYSQL_TMP_DIR/data_80014.zip
19
20 --echo # Check that the file exists in the working folder.
21 --file_exists $MYSQL_TMP_DIR/data_80014.zip
22 --exec unzip -qo $MYSQL_TMP_DIR/data_80014.zip -d $MYSQL_TMP_DIR
23
24 --echo # Set different paths for --datadir
25 --let $MYSQLD_DATADIR1 = $MYSQL_TMP_DIR/data_80014/
26
27 --echo # Check that the file exits after unzip
28 --file_exists $MYSQL_TMP_DIR/data_80014
29
30 --echo # Stop / restart DB server which was created by MTR default
31 --let $shutdown_server_timeout= 300
32 --let $wait_counter= 10000
33 --let $restart_parameters= restart: --datadir=$MYSQLD_DATADIR1 --log-error=$MYSQLD_LOG
34 --replace_result $MYSQLD_DATADIR1 MYSQLD_DATADIR1 $MYSQLD_LOG MYSQLD_LOG
35 --source include/restart_mysqld.inc
36
37 SELECT COUNT(*) < 0 FROM INFORMATION_SCHEMA.APPLICABLE_ROLES;
38 SELECT COUNT(*) < 0 FROM INFORMATION_SCHEMA.ADMINISTRABLE_ROLE_AUTHORIZATIONS;
39 SELECT COUNT(*) < 0 FROM INFORMATION_SCHEMA.ENABLED_ROLES;
40 SELECT COUNT(*) < 0 FROM INFORMATION_SCHEMA.ROLE_TABLE_GRANTS;
41 SELECT COUNT(*) < 0 FROM INFORMATION_SCHEMA.ROLE_COLUMN_GRANTS;
42 SELECT COUNT(*) < 0 FROM INFORMATION_SCHEMA.ROLE_ROUTINE_GRANTS;
43
44 --echo # Stop the server and do cleanup
45 --source include/shutdown_mysqld.inc
46 --echo # Remove copied files
47 --remove_file $MYSQL_TMP_DIR/data_80014.zip
48 --force-rmdir $MYSQL_TMP_DIR/data_80014
49 --echo # Restart the server with default options.
50 --let $restart_parameters= restart:
51 --source include/start_mysqld.inc
52
53 --echo #
54 --echo # WL#10895 Upgrade from 5.7->8.0 should show I_S tables.
55 --echo #
56 --echo #
57
58 let $MYSQLD_LOG= $MYSQLTEST_VARDIR/log/save_dd_upgrade_4.log;
59
60 --echo # Copy zip files from suite location to working location.
61 --copy_file $MYSQLTEST_VARDIR/std_data/upgrade/data_57022.zip $MYSQL_TMP_DIR/data_57022.zip
62
63 --echo # Check that the file exists in the working folder.
64 --file_exists $MYSQL_TMP_DIR/data_57022.zip
65
66 --echo # Unzip the zip file.
67 --exec unzip -qo $MYSQL_TMP_DIR/data_57022.zip -d $MYSQL_TMP_DIR
68
69 --echo # Set different paths for --datadir
70 let $MYSQLD_DATADIR3 = $MYSQL_TMP_DIR/data_57022;
71
72 --echo # Stop DB server which was created by MTR default
73 --exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
74 --shutdown_server
75 --source include/wait_until_disconnected.inc
76
77 --echo # Start the DB server to do upgrade.
78 --exec echo "restart: --datadir=$MYSQLD_DATADIR3 --log-error=$MYSQLD_LOG" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
79 --enable_reconnect
80 --let $wait_counter= 3000
81 --source include/wait_until_connected_again.inc
82
83 SELECT COUNT(*) < 0 FROM INFORMATION_SCHEMA.APPLICABLE_ROLES;
84 SELECT COUNT(*) < 0 FROM INFORMATION_SCHEMA.ADMINISTRABLE_ROLE_AUTHORIZATIONS;
85 SELECT COUNT(*) < 0 FROM INFORMATION_SCHEMA.ENABLED_ROLES;
86 SELECT COUNT(*) < 0 FROM INFORMATION_SCHEMA.ROLE_TABLE_GRANTS;
87 SELECT COUNT(*) < 0 FROM INFORMATION_SCHEMA.ROLE_COLUMN_GRANTS;
88 SELECT COUNT(*) < 0 FROM INFORMATION_SCHEMA.ROLE_ROUTINE_GRANTS;
89
90 --echo # Stop the server
91 --source include/shutdown_mysqld.inc
92 --echo # Remove copied files
93 --remove_file $MYSQL_TMP_DIR/data_57022.zip
94 --force-rmdir $MYSQLD_DATADIR3
95 --echo # Restart the server with default options.
96 --source include/start_mysqld.inc
97