Debian Codegraph @

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

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