| 1 |
--echo # |
| 2 |
--echo # WL7900 -- New DD: Support flexible creation and versioning of |
| 3 |
--echo # virtual P_S tables |
| 4 |
--echo # |
| 5 |
|
| 6 |
--source include/not_valgrind.inc |
| 7 |
--source include/have_debug.inc |
| 8 |
|
| 9 |
CALL mtr.add_suppression("Native table .* has the wrong structure"); |
| 10 |
|
| 11 |
--echo # Case 1: |
| 12 |
--echo # Restart server with the actual P_S version number differed |
| 13 |
--echo # from the expected version number. |
| 14 |
--echo # - Using a debug flag for testing. |
| 15 |
--echo # - Check if abandoned P_S table is removed, in case server version is |
| 16 |
--echo # changed. The test case expects P_S.cond_instances to be missed. |
| 17 |
|
| 18 |
--echo # check that in normal mode the table P_S.cond_instances exists. |
| 19 |
--replace_column 1 # |
| 20 |
SELECT COUNT(*) FROM performance_schema.cond_instances; |
| 21 |
|
| 22 |
--let $restart_parameters=restart:--debug=+d,test_p_s_metadata_version |
| 23 |
--source include/restart_mysqld.inc |
| 24 |
|
| 25 |
--replace_column 1 # |
| 26 |
--error ER_NO_SUCH_TABLE |
| 27 |
SELECT COUNT(*) FROM performance_schema.cond_instances; |
| 28 |
|
| 29 |
--echo # Case 2: |
| 30 |
--echo # Restart server should fail if P_S version is changed |
| 31 |
--echo # and --innodb-read-only mode is ON. |
| 32 |
|
| 33 |
--disable_warnings |
| 34 |
--let $MYSQLD_DATADIR=`SELECT @@datadir` |
| 35 |
--let $INNODB_LOG_CAPACITY=`SELECT @@innodb_redo_log_capacity` |
| 36 |
--source include/shutdown_mysqld.inc |
| 37 |
|
| 38 |
--let LOG_FILE = $MYSQLTEST_VARDIR/tmp/bootstrap.err |
| 39 |
--let CMD = $MYSQLD --no-defaults --innodb_dedicated_server=OFF --innodb-redo-log-capacity=$INNODB_LOG_CAPACITY --debug=+d,test_p_s_metadata_version --innodb-read-only --basedir=$MYSQLD_BASEDIR --datadir=$MYSQLD_DATADIR --log-error=$LOG_FILE --secure-file-priv="" 2>&1 |
| 40 |
--replace_regex /.*component_reference_cache.*/Can't open shared library component_reference_cache/g |
| 41 |
--error 1 |
| 42 |
--exec $CMD |
| 43 |
--enable_warnings |
| 44 |
|
| 45 |
# Clean up |
| 46 |
--let $restart_parameters=restart:--debug=-d,test_p_s_metadata_version |
| 47 |
--source include/start_mysqld.inc |
| 48 |
--remove_file $LOG_FILE |