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 performance_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 performance_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 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'session.myisam_stats_method = 'nulls_equal'' at line 1
110 SET global.myisam_stats_method = 'nulls_equal';
111 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'global.myisam_stats_method = 'nulls_equal'' at line 1
112 SET session myisam_stats_method = 'nulls_equal';
113 SELECT @@myisam_stats_method;
114 @@myisam_stats_method
115 nulls_equal
116 SET global myisam_stats_method = 'nulls_equal';
117 SELECT @@global.myisam_stats_method;
118 @@global.myisam_stats_method
119 nulls_equal
120 SET @@global.myisam_stats_method = @global_start_value;
121 SELECT @@global.myisam_stats_method;
122 @@global.myisam_stats_method
123 nulls_unequal
124 SET @@session.myisam_stats_method = @session_start_value;
125 SELECT @@session.myisam_stats_method;
126 @@session.myisam_stats_method
127 nulls_unequal