Debian Codegraph @

mysql-test/suite/perfschema/t/init_pfs_from_dd.test

raw
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