Debian Codegraph @

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

raw
1 #
2 # Variable name : persisted_globals_load
3 # Scope : Global Read only
4 #
5 # Global - default
6 SELECT @@global.persisted_globals_load;
7 @@global.persisted_globals_load
8 1
9 # via performance_schema.global_variables
10 SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME
11 LIKE 'persisted_globals_load';
12 VARIABLE_NAME VARIABLE_VALUE
13 persisted_globals_load ON
14 SELECT @@local.persisted_globals_load;
15 ERROR HY000: Variable 'persisted_globals_load' is a GLOBAL variable
16 SELECT @@session.persisted_globals_load;
17 ERROR HY000: Variable 'persisted_globals_load' is a GLOBAL variable
18 SELECT persisted_globals_load;
19 ERROR 42S22: Unknown column 'persisted_globals_load' in 'field list'
20 SET GLOBAL persisted_globals_load= 1;
21 ERROR HY000: Variable 'persisted_globals_load' is a read only variable
22 SET PERSIST persisted_globals_load= 1;
23 ERROR HY000: Variable 'persisted_globals_load' is a read only variable
24 # End of tests.