Debian Codegraph @

mysql-test/suite/sys_vars/r/gtid_strict_mode_basic.result

raw
1 select @@global.gtid_strict_mode;
2 @@global.gtid_strict_mode
3 0
4 select @@session.gtid_strict_mode;
5 ERROR HY000: Variable 'gtid_strict_mode' is a GLOBAL variable
6 show global variables like 'gtid_strict_mode';
7 Variable_name Value
8 gtid_strict_mode OFF
9 show session variables like 'gtid_strict_mode';
10 Variable_name Value
11 gtid_strict_mode OFF
12 select * from information_schema.global_variables where variable_name='gtid_strict_mode';
13 VARIABLE_NAME VARIABLE_VALUE
14 GTID_STRICT_MODE OFF
15 select * from information_schema.session_variables where variable_name='gtid_strict_mode';
16 VARIABLE_NAME VARIABLE_VALUE
17 GTID_STRICT_MODE OFF
18 SET @old= @@GLOBAL.gtid_strict_mode;
19 set global gtid_strict_mode=1;
20 select @@global.gtid_strict_mode;
21 @@global.gtid_strict_mode
22 1
23 set global gtid_strict_mode=0;
24 select @@global.gtid_strict_mode;
25 @@global.gtid_strict_mode
26 0
27 set global gtid_strict_mode=@old;
28 set session gtid_strict_mode=1;
29 ERROR HY000: Variable 'gtid_strict_mode' is a GLOBAL variable and should be set with SET GLOBAL