Debian Codegraph @

mysql-test/suite/sys_vars/t/persisted_globals_load_basic.test

raw
1
2 --echo #
3 --echo # Variable name : persisted_globals_load
4 --echo # Scope : Global Read only
5 --echo #
6
7 --echo # Global - default
8 SELECT @@global.persisted_globals_load;
9
10 --echo # via performance_schema.global_variables
11 --disable_warnings
12 SELECT * FROM performance_schema.global_variables WHERE VARIABLE_NAME
13 LIKE 'persisted_globals_load';
14 --enable_warnings
15
16 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
17 SELECT @@local.persisted_globals_load;
18
19 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
20 SELECT @@session.persisted_globals_load;
21
22 --Error ER_BAD_FIELD_ERROR
23 SELECT persisted_globals_load;
24
25 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
26 SET GLOBAL persisted_globals_load= 1;
27
28 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
29 SET PERSIST persisted_globals_load= 1;
30
31 --echo # End of tests.
32