Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.innodb_stats_method;
2 SELECT @start_global_value;
3 @start_global_value
4 nulls_equal
5 Valid values are 'nulls_equal', 'nulls_unequal', 'nulls_ignored'
6 SELECT @@global.innodb_stats_method in ('nulls_equal', 'nulls_unequal',
7 'nulls_ignored');
8 @@global.innodb_stats_method in ('nulls_equal', 'nulls_unequal',
9 'nulls_ignored')
10 1
11 SELECT @@global.innodb_stats_method;
12 @@global.innodb_stats_method
13 nulls_equal
14 SELECT @@session.innodb_stats_method;
15 ERROR HY000: Variable 'innodb_stats_method' is a GLOBAL variable
16 SHOW global variables LIKE 'innodb_stats_method';
17 Variable_name Value
18 innodb_stats_method nulls_equal
19 SHOW session variables LIKE 'innodb_stats_method';
20 Variable_name Value
21 innodb_stats_method nulls_equal
22 SELECT * FROM performance_schema.global_variables
23 WHERE variable_name='innodb_stats_method';
24 VARIABLE_NAME VARIABLE_VALUE
25 innodb_stats_method nulls_equal
26 SELECT * FROM performance_schema.session_variables
27 WHERE variable_name='innodb_stats_method';
28 VARIABLE_NAME VARIABLE_VALUE
29 innodb_stats_method nulls_equal
30 SET global innodb_stats_method='nulls_equal';
31 SELECT @@global.innodb_stats_method;
32 @@global.innodb_stats_method
33 nulls_equal
34 SELECT * FROM performance_schema.global_variables
35 WHERE variable_name='innodb_stats_method';
36 VARIABLE_NAME VARIABLE_VALUE
37 innodb_stats_method nulls_equal
38 SELECT * FROM performance_schema.session_variables
39 WHERE variable_name='innodb_stats_method';
40 VARIABLE_NAME VARIABLE_VALUE
41 innodb_stats_method nulls_equal
42 SET @@global.innodb_stats_method='nulls_unequal';
43 SELECT @@global.innodb_stats_method;
44 @@global.innodb_stats_method
45 nulls_unequal
46 SELECT * FROM performance_schema.global_variables
47 WHERE variable_name='innodb_stats_method';
48 VARIABLE_NAME VARIABLE_VALUE
49 innodb_stats_method nulls_unequal
50 SELECT * FROM performance_schema.session_variables
51 WHERE variable_name='innodb_stats_method';
52 VARIABLE_NAME VARIABLE_VALUE
53 innodb_stats_method nulls_unequal
54 SET global innodb_stats_method=2;
55 SELECT @@global.innodb_stats_method;
56 @@global.innodb_stats_method
57 nulls_ignored
58 SELECT * FROM performance_schema.global_variables
59 WHERE variable_name='innodb_stats_method';
60 VARIABLE_NAME VARIABLE_VALUE
61 innodb_stats_method nulls_ignored
62 SELECT * FROM performance_schema.session_variables
63 WHERE variable_name='innodb_stats_method';
64 VARIABLE_NAME VARIABLE_VALUE
65 innodb_stats_method nulls_ignored
66 SET session innodb_stats_method='nulls_equal';
67 ERROR HY000: Variable 'innodb_stats_method' is a GLOBAL variable and should be set with SET GLOBAL
68 SET @@session.innodb_stats_method='nulls_ignored';
69 ERROR HY000: Variable 'innodb_stats_method' is a GLOBAL variable and should be set with SET GLOBAL
70 SET global innodb_stats_method=1.1;
71 ERROR 42000: Incorrect argument type to variable 'innodb_stats_method'
72 SET global innodb_stats_method=4;
73 ERROR 42000: Variable 'innodb_stats_method' can't be set to the value of '4'
74 SET global innodb_stats_method=-2;
75 ERROR 42000: Variable 'innodb_stats_method' can't be set to the value of '-2'
76 SET global innodb_stats_method=1e1;
77 ERROR 42000: Incorrect argument type to variable 'innodb_stats_method'
78 SET global innodb_stats_method='some';
79 ERROR 42000: Variable 'innodb_stats_method' can't be set to the value of 'some'
80 SET @@global.innodb_stats_method = @start_global_value;
81 SELECT @@global.innodb_stats_method;
82 @@global.innodb_stats_method
83 nulls_equal