Debian Codegraph @

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

raw
1 #
2 # 2011-08-05 - Added
3 #
4
5
6 SET @start_global_value = @@global.innodb_stats_method;
7 SELECT @start_global_value;
8
9 #
10 # exists as global only
11 #
12 --echo Valid values are 'nulls_equal', 'nulls_unequal', 'nulls_ignored'
13 SELECT @@global.innodb_stats_method in ('nulls_equal', 'nulls_unequal',
14 'nulls_ignored');
15 SELECT @@global.innodb_stats_method;
16 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
17 SELECT @@session.innodb_stats_method;
18 SHOW global variables LIKE 'innodb_stats_method';
19 SHOW session variables LIKE 'innodb_stats_method';
20 --disable_warnings
21 SELECT * FROM performance_schema.global_variables
22 WHERE variable_name='innodb_stats_method';
23 SELECT * FROM performance_schema.session_variables
24 WHERE variable_name='innodb_stats_method';
25 --enable_warnings
26
27 #
28 # show that it's writable
29 #
30 SET global innodb_stats_method='nulls_equal';
31 SELECT @@global.innodb_stats_method;
32 --disable_warnings
33 SELECT * FROM performance_schema.global_variables
34 WHERE variable_name='innodb_stats_method';
35 SELECT * FROM performance_schema.session_variables
36 WHERE variable_name='innodb_stats_method';
37 --enable_warnings
38 SET @@global.innodb_stats_method='nulls_unequal';
39 SELECT @@global.innodb_stats_method;
40 --disable_warnings
41 SELECT * FROM performance_schema.global_variables
42 WHERE variable_name='innodb_stats_method';
43 SELECT * FROM performance_schema.session_variables
44 WHERE variable_name='innodb_stats_method';
45 --enable_warnings
46 SET global innodb_stats_method=2;
47 SELECT @@global.innodb_stats_method;
48 --disable_warnings
49 SELECT * FROM performance_schema.global_variables
50 WHERE variable_name='innodb_stats_method';
51 SELECT * FROM performance_schema.session_variables
52 WHERE variable_name='innodb_stats_method';
53 --enable_warnings
54
55 --error ER_GLOBAL_VARIABLE
56 SET session innodb_stats_method='nulls_equal';
57 --error ER_GLOBAL_VARIABLE
58 SET @@session.innodb_stats_method='nulls_ignored';
59
60 #
61 # incorrect types
62 #
63 --error ER_WRONG_TYPE_FOR_VAR
64 SET global innodb_stats_method=1.1;
65 --error ER_WRONG_VALUE_FOR_VAR
66 SET global innodb_stats_method=4;
67 --error ER_WRONG_VALUE_FOR_VAR
68 SET global innodb_stats_method=-2;
69 --error ER_WRONG_TYPE_FOR_VAR
70 SET global innodb_stats_method=1e1;
71 --error ER_WRONG_VALUE_FOR_VAR
72 SET global innodb_stats_method='some';
73
74 #
75 # Cleanup
76 #
77
78 SET @@global.innodb_stats_method = @start_global_value;
79 SELECT @@global.innodb_stats_method;