Debian Codegraph @

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

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