Debian Codegraph @

mysql-test/suite/sys_vars/t/port_basic.test

raw
1 #
2 # only global
3 #
4 --replace_result $MASTER_MYPORT MASTER_MYPORT
5 select @@global.port;
6 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
7 select @@session.port;
8 --replace_result $MASTER_MYPORT MASTER_MYPORT
9 show global variables like 'port';
10 --replace_result $MASTER_MYPORT MASTER_MYPORT
11 show session variables like 'port';
12 --disable_warnings
13 --replace_result $MASTER_MYPORT MASTER_MYPORT
14 select * from performance_schema.global_variables where variable_name='port';
15 --replace_result $MASTER_MYPORT MASTER_MYPORT
16 select * from performance_schema.session_variables where variable_name='port';
17 --enable_warnings
18
19 #
20 # show that it's read-only
21 #
22 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
23 set global port=1;
24 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
25 set session port=1;