polardbxengine/mysql-test/suite/sys_vars/r/lo_extra_dependencies_basic...

24 lines
1.2 KiB
Plaintext

select @@global.lock_order_extra_dependencies;
@@global.lock_order_extra_dependencies
/some/path/to/lock_order_extra_dependencies.txt
select @@session.lock_order_extra_dependencies;
ERROR HY000: Variable 'lock_order_extra_dependencies' is a GLOBAL variable
show global variables like 'lock_order_extra_dependencies';
Variable_name Value
lock_order_extra_dependencies /some/path/to/lock_order_extra_dependencies.txt
show session variables like 'lock_order_extra_dependencies';
Variable_name Value
lock_order_extra_dependencies /some/path/to/lock_order_extra_dependencies.txt
select * from performance_schema.global_variables
where variable_name='lock_order_extra_dependencies';
VARIABLE_NAME VARIABLE_VALUE
lock_order_extra_dependencies /some/path/to/lock_order_extra_dependencies.txt
select * from performance_schema.session_variables
where variable_name='lock_order_extra_dependencies';
VARIABLE_NAME VARIABLE_VALUE
lock_order_extra_dependencies /some/path/to/lock_order_extra_dependencies.txt
set global lock_order_extra_dependencies="foo";
ERROR HY000: Variable 'lock_order_extra_dependencies' is a read only variable
set session lock_order_extra_dependencies="foo";
ERROR HY000: Variable 'lock_order_extra_dependencies' is a read only variable