Debian Codegraph @

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

raw
1 select @@global.lock_order_debug_loop;
2 @@global.lock_order_debug_loop
3 0
4 select @@session.lock_order_debug_loop;
5 ERROR HY000: Variable 'lock_order_debug_loop' is a GLOBAL variable
6 show global variables like 'lock_order_debug_loop';
7 Variable_name Value
8 lock_order_debug_loop OFF
9 show session variables like 'lock_order_debug_loop';
10 Variable_name Value
11 lock_order_debug_loop OFF
12 select * from performance_schema.global_variables
13 where variable_name='lock_order_debug_loop';
14 VARIABLE_NAME VARIABLE_VALUE
15 lock_order_debug_loop OFF
16 select * from performance_schema.session_variables
17 where variable_name='lock_order_debug_loop';
18 VARIABLE_NAME VARIABLE_VALUE
19 lock_order_debug_loop OFF
20 set global lock_order_debug_loop=1;
21 ERROR HY000: Variable 'lock_order_debug_loop' is a read only variable
22 set session lock_order_debug_loop=1;
23 ERROR HY000: Variable 'lock_order_debug_loop' is a read only variable