Debian Codegraph @

mysql-test/suite/sys_vars/r/innodb_stats_modified_counter_basic.result

raw
1 SET @start_global_value = @@global.innodb_stats_modified_counter;
2 SELECT @start_global_value;
3 @start_global_value
4 0
5 Valid values are one or above
6 select @@global.innodb_stats_modified_counter >=1;
7 @@global.innodb_stats_modified_counter >=1
8 0
9 select @@global.innodb_stats_modified_counter;
10 @@global.innodb_stats_modified_counter
11 0
12 select @@session.innodb_stats_modified_counter;
13 ERROR HY000: Variable 'innodb_stats_modified_counter' is a GLOBAL variable
14 show global variables like 'innodb_stats_modified_counter';
15 Variable_name Value
16 innodb_stats_modified_counter 0
17 show session variables like 'innodb_stats_modified_counter';
18 Variable_name Value
19 innodb_stats_modified_counter 0
20 select * from information_schema.global_variables where variable_name='innodb_stats_modified_counter';
21 VARIABLE_NAME VARIABLE_VALUE
22 INNODB_STATS_MODIFIED_COUNTER 0
23 select * from information_schema.session_variables where variable_name='innodb_stats_modified_counter';
24 VARIABLE_NAME VARIABLE_VALUE
25 INNODB_STATS_MODIFIED_COUNTER 0
26 set global innodb_stats_modified_counter=10;
27 select @@global.innodb_stats_modified_counter;
28 @@global.innodb_stats_modified_counter
29 10
30 select * from information_schema.global_variables where variable_name='innodb_stats_modified_counter';
31 VARIABLE_NAME VARIABLE_VALUE
32 INNODB_STATS_MODIFIED_COUNTER 10
33 select * from information_schema.session_variables where variable_name='innodb_stats_modified_counter';
34 VARIABLE_NAME VARIABLE_VALUE
35 INNODB_STATS_MODIFIED_COUNTER 10
36 set session innodb_stats_modified_counter=1;
37 ERROR HY000: Variable 'innodb_stats_modified_counter' is a GLOBAL variable and should be set with SET GLOBAL
38 set global innodb_stats_modified_counter=1.1;
39 ERROR 42000: Incorrect argument type to variable 'innodb_stats_modified_counter'
40 set global innodb_stats_modified_counter=1e1;
41 ERROR 42000: Incorrect argument type to variable 'innodb_stats_modified_counter'
42 set global innodb_stats_modified_counter="foo";
43 ERROR 42000: Incorrect argument type to variable 'innodb_stats_modified_counter'
44 set global innodb_stats_modified_counter=-7;
45 Warnings:
46 Warning 1292 Truncated incorrect innodb_stats_modified_counter value: '-7'
47 select @@global.innodb_stats_modified_counter;
48 @@global.innodb_stats_modified_counter
49 0
50 select * from information_schema.global_variables where variable_name='innodb_stats_modified_counter';
51 VARIABLE_NAME VARIABLE_VALUE
52 INNODB_STATS_MODIFIED_COUNTER 0
53 SET @@global.innodb_stats_modified_counter = @start_global_value;
54 SELECT @@global.innodb_stats_modified_counter;
55 @@global.innodb_stats_modified_counter
56 0