Debian Codegraph @

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

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