Debian Codegraph @

mysql-test/suite/rpl/t/rpl_report.test

raw
1 # Verify that mysqld init time --report-{host,port,user,password} parameters
2 # are SHOW-able and SELECT-able FROM performance_schema.global_variables
3
4 --source include/not_group_replication_plugin.inc
5 source include/master-slave.inc;
6
7 connection slave;
8 --disable_warnings
9 select * from performance_schema.global_variables where variable_name like 'report_host';
10 select * from performance_schema.global_variables where variable_name like 'report_port';
11 select * from performance_schema.global_variables where variable_name like 'report_user';
12 select * from performance_schema.global_variables where variable_name like 'report_password';
13 --enable_warnings
14 query_vertical show global variables like 'report_host';
15 query_vertical show global variables like 'report_port';
16 query_vertical show global variables like 'report_user';
17 query_vertical show global variables like 'report_password';
18
19 # to demonstrate that report global variables are read-only
20 error ER_INCORRECT_GLOBAL_LOCAL_VAR;
21 set @@global.report_host='my.new.address.net';
22
23
24 --echo end of tests
25 --source include/rpl_end.inc