Debian Codegraph @

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

raw
1 SET @global_start_value = @@global.myisam_stats_method;
2 SELECT @global_start_value;
3 @global_start_value
4 NULLS_UNEQUAL
5 SET @session_start_value = @@session.myisam_stats_method;
6 SELECT @session_start_value;
7 @session_start_value
8 NULLS_UNEQUAL
9 '#--------------------FN_DYNVARS_097_01------------------------#'
10 SET @@global.myisam_stats_method = nulls_equal;
11 SET @@global.myisam_stats_method = DEFAULT;
12 SELECT @@global.myisam_stats_method;
13 @@global.myisam_stats_method
14 NULLS_UNEQUAL
15 SET @@session.myisam_stats_method = nulls_equal;
16 SET @@session.myisam_stats_method = DEFAULT;
17 SELECT @@session.myisam_stats_method;
18 @@session.myisam_stats_method
19 NULLS_UNEQUAL
20 '#---------------------FN_DYNVARS_097_02-------------------------#'
21 SET @@global.myisam_stats_method = NULL;
22 ERROR 42000: Variable 'myisam_stats_method' can't be set to the value of 'NULL'
23 SET @@global.myisam_stats_method = '';
24 ERROR 42000: Variable 'myisam_stats_method' can't be set to the value of ''
25 SET @@session.myisam_stats_method = NULL;
26 ERROR 42000: Variable 'myisam_stats_method' can't be set to the value of 'NULL'
27 SET @@session.myisam_stats_method = '';
28 ERROR 42000: Variable 'myisam_stats_method' can't be set to the value of ''
29 '#--------------------FN_DYNVARS_097_03------------------------#'
30 SET @@global.myisam_stats_method = 'nulls_equal';
31 SELECT @@global.myisam_stats_method;
32 @@global.myisam_stats_method
33 NULLS_EQUAL
34 SET @@global.myisam_stats_method = 'nulls_unequal';
35 SELECT @@global.myisam_stats_method;
36 @@global.myisam_stats_method
37 NULLS_UNEQUAL
38 SET @@global.myisam_stats_method = 'nulls_ignored';
39 SELECT @@global.myisam_stats_method;
40 @@global.myisam_stats_method
41 NULLS_IGNORED
42 'Bug: Value of nulls_ignored is not documented. Its ordinal value is 2'
43 SET @@session.myisam_stats_method = 'nulls_equal';
44 SELECT @@session.myisam_stats_method;
45 @@session.myisam_stats_method
46 NULLS_EQUAL
47 SET @@session.myisam_stats_method = 'nulls_unequal';
48 SELECT @@session.myisam_stats_method;
49 @@session.myisam_stats_method
50 NULLS_UNEQUAL
51 SET @@session.myisam_stats_method = 'nulls_ignored';
52 SELECT @@session.myisam_stats_method;
53 @@session.myisam_stats_method
54 NULLS_IGNORED
55 '#--------------------FN_DYNVARS_097_04-------------------------#'
56 SET @@global.myisam_stats_method = -1;
57 ERROR 42000: Variable 'myisam_stats_method' can't be set to the value of '-1'
58 SET @@global.myisam_stats_method = unequal;
59 ERROR 42000: Variable 'myisam_stats_method' can't be set to the value of 'unequal'
60 SET @@global.myisam_stats_method = ENABLED;
61 ERROR 42000: Variable 'myisam_stats_method' can't be set to the value of 'ENABLED'
62 SET @@global.myisam_stats_method = 'equal';
63 ERROR 42000: Variable 'myisam_stats_method' can't be set to the value of 'equal'
64 SET @@global.myisam_stats_method = 'null_equal';
65 ERROR 42000: Variable 'myisam_stats_method' can't be set to the value of 'null_equal'
66 SET @@global.myisam_stats_method = ' ';
67 ERROR 42000: Variable 'myisam_stats_method' can't be set to the value of ' '
68 '#-------------------FN_DYNVARS_097_05----------------------------#'
69 SELECT @@session.myisam_stats_method = VARIABLE_VALUE
70 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
71 WHERE VARIABLE_NAME='myisam_stats_method';
72 @@session.myisam_stats_method = VARIABLE_VALUE
73 1
74 '#----------------------FN_DYNVARS_097_06------------------------#'
75 SELECT @@global.myisam_stats_method = VARIABLE_VALUE
76 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
77 WHERE VARIABLE_NAME='myisam_stats_method';
78 @@global.myisam_stats_method = VARIABLE_VALUE
79 1
80 '#---------------------FN_DYNVARS_097_07-------------------------#'
81 SET @@global.myisam_stats_method = 0;
82 SELECT @@global.myisam_stats_method;
83 @@global.myisam_stats_method
84 NULLS_UNEQUAL
85 SET @@global.myisam_stats_method = 1;
86 SELECT @@global.myisam_stats_method;
87 @@global.myisam_stats_method
88 NULLS_EQUAL
89 SET @@global.myisam_stats_method = 2;
90 SELECT @@global.myisam_stats_method;
91 @@global.myisam_stats_method
92 NULLS_IGNORED
93 SET @@global.myisam_stats_method = 0.4;
94 ERROR 42000: Incorrect argument type to variable 'myisam_stats_method'
95 SET @@global.myisam_stats_method = 3;
96 ERROR 42000: Variable 'myisam_stats_method' can't be set to the value of '3'
97 '#---------------------FN_DYNVARS_097_08----------------------#'
98 SET @@global.myisam_stats_method = TRUE;
99 SELECT @@global.myisam_stats_method;
100 @@global.myisam_stats_method
101 NULLS_EQUAL
102 SET @@global.myisam_stats_method = FALSE;
103 SELECT @@global.myisam_stats_method;
104 @@global.myisam_stats_method
105 NULLS_UNEQUAL
106 '#---------------------FN_DYNVARS_097_09----------------------#'
107 SET myisam_stats_method = 'nulls_equal';
108 SET session myisam_stats_method = 'nulls_equal';
109 SELECT @@myisam_stats_method;
110 @@myisam_stats_method
111 NULLS_EQUAL
112 SET global myisam_stats_method = 'nulls_equal';
113 SELECT @@global.myisam_stats_method;
114 @@global.myisam_stats_method
115 NULLS_EQUAL
116 SET @@global.myisam_stats_method = @global_start_value;
117 SELECT @@global.myisam_stats_method;
118 @@global.myisam_stats_method
119 NULLS_UNEQUAL
120 SET @@session.myisam_stats_method = @session_start_value;
121 SELECT @@session.myisam_stats_method;
122 @@session.myisam_stats_method
123 NULLS_UNEQUAL