Debian Codegraph @

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

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