| 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 |
|