Debian Codegraph @

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

raw
1 #
2 # innodb_stats_persistent
3 #
4
5
6 # show the default value
7 SELECT @@innodb_stats_persistent;
8
9 # check that it is writeable
10 SET GLOBAL innodb_stats_persistent=ON;
11 SELECT @@innodb_stats_persistent;
12
13 SET GLOBAL innodb_stats_persistent=OFF;
14 SELECT @@innodb_stats_persistent;
15
16 SET GLOBAL innodb_stats_persistent=1;
17 SELECT @@innodb_stats_persistent;
18
19 SET GLOBAL innodb_stats_persistent=0;
20 SELECT @@innodb_stats_persistent;
21
22 # should be a boolean
23 -- error ER_WRONG_VALUE_FOR_VAR
24 SET GLOBAL innodb_stats_persistent=123;
25
26 -- error ER_WRONG_VALUE_FOR_VAR
27 SET GLOBAL innodb_stats_persistent='foo';
28
29 # restore the environment
30 SET GLOBAL innodb_stats_persistent=default;