Debian Codegraph @

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

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