Debian Codegraph @

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

raw
1 --source include/have_innodb.inc
2
3 SET @start_global_value = @@global.innodb_stats_modified_counter;
4 SELECT @start_global_value;
5
6 #
7 # exists as global only
8 #
9 --echo Valid values are one or above
10 select @@global.innodb_stats_modified_counter >=1;
11 select @@global.innodb_stats_modified_counter;
12 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
13 select @@session.innodb_stats_modified_counter;
14 show global variables like 'innodb_stats_modified_counter';
15 show session variables like 'innodb_stats_modified_counter';
16 select * from information_schema.global_variables where variable_name='innodb_stats_modified_counter';
17 select * from information_schema.session_variables where variable_name='innodb_stats_modified_counter';
18
19 #
20 # show that it's writable
21 #
22 set global innodb_stats_modified_counter=10;
23 select @@global.innodb_stats_modified_counter;
24 select * from information_schema.global_variables where variable_name='innodb_stats_modified_counter';
25 select * from information_schema.session_variables where variable_name='innodb_stats_modified_counter';
26 --error ER_GLOBAL_VARIABLE
27 set session innodb_stats_modified_counter=1;
28
29 #
30 # incorrect types
31 #
32 --error ER_WRONG_TYPE_FOR_VAR
33 set global innodb_stats_modified_counter=1.1;
34 --error ER_WRONG_TYPE_FOR_VAR
35 set global innodb_stats_modified_counter=1e1;
36 --error ER_WRONG_TYPE_FOR_VAR
37 set global innodb_stats_modified_counter="foo";
38
39 set global innodb_stats_modified_counter=-7;
40 select @@global.innodb_stats_modified_counter;
41 select * from information_schema.global_variables where variable_name='innodb_stats_modified_counter';
42
43 #
44 # cleanup
45 #
46 SET @@global.innodb_stats_modified_counter = @start_global_value;
47 SELECT @@global.innodb_stats_modified_counter;