Debian Codegraph @

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

raw
1 --source include/not_embedded.inc
2 #
3 # only global
4 #
5 select @@global.gtid_strict_mode;
6 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
7 select @@session.gtid_strict_mode;
8 show global variables like 'gtid_strict_mode';
9 show session variables like 'gtid_strict_mode';
10 select * from information_schema.global_variables where variable_name='gtid_strict_mode';
11 select * from information_schema.session_variables where variable_name='gtid_strict_mode';
12
13 SET @old= @@GLOBAL.gtid_strict_mode;
14 set global gtid_strict_mode=1;
15 select @@global.gtid_strict_mode;
16 set global gtid_strict_mode=0;
17 select @@global.gtid_strict_mode;
18 set global gtid_strict_mode=@old;
19
20 --error ER_GLOBAL_VARIABLE
21 set session gtid_strict_mode=1;