Debian Codegraph @

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

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