Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.myisam_repair_threads;
2 SELECT @start_global_value;
3 @start_global_value
4 1
5 SET @start_session_value = @@session.myisam_repair_threads;
6 SELECT @start_session_value;
7 @start_session_value
8 1
9 '#--------------------FN_DYNVARS_005_01-------------------------#'
10 SET @@global.myisam_repair_threads = 100;
11 SET @@global.myisam_repair_threads = DEFAULT;
12 SELECT @@global.myisam_repair_threads ;
13 @@global.myisam_repair_threads
14 1
15 SET @@session.myisam_repair_threads = 200;
16 SET @@session.myisam_repair_threads = DEFAULT;
17 SELECT @@session.myisam_repair_threads ;
18 @@session.myisam_repair_threads
19 1
20 '#--------------------FN_DYNVARS_005_02-------------------------#'
21 SET @@global.myisam_repair_threads = DEFAULT;
22 SELECT @@global.myisam_repair_threads = 1;
23 @@global.myisam_repair_threads = 1
24 1
25 SET @@session.myisam_repair_threads = DEFAULT;
26 SELECT @@session.myisam_repair_threads = 1;
27 @@session.myisam_repair_threads = 1
28 1
29 '#--------------------FN_DYNVARS_005_03-------------------------#'
30 SET @@global.myisam_repair_threads = 1;
31 SELECT @@global.myisam_repair_threads ;
32 @@global.myisam_repair_threads
33 1
34 SET @@global.myisam_repair_threads = 4294967295;
35 SELECT @@global.myisam_repair_threads ;
36 @@global.myisam_repair_threads
37 4294967295
38 SET @@global.myisam_repair_threads = 655354;
39 SELECT @@global.myisam_repair_threads ;
40 @@global.myisam_repair_threads
41 655354
42 '#--------------------FN_DYNVARS_005_04-------------------------#'
43 SET @@session.myisam_repair_threads = 1;
44 SELECT @@session.myisam_repair_threads ;
45 @@session.myisam_repair_threads
46 1
47 SET @@session.myisam_repair_threads = 4294967295;
48 SELECT @@session.myisam_repair_threads ;
49 @@session.myisam_repair_threads
50 4294967295
51 SET @@session.myisam_repair_threads = 655345;
52 SELECT @@session.myisam_repair_threads ;
53 @@session.myisam_repair_threads
54 655345
55 '#------------------FN_DYNVARS_005_05-----------------------#'
56 SET @@global.myisam_repair_threads = 0;
57 Warnings:
58 Warning 1292 Truncated incorrect myisam_repair_threads value: '0'
59 SELECT @@global.myisam_repair_threads ;
60 @@global.myisam_repair_threads
61 1
62 SET @@global.myisam_repair_threads = -1024;
63 Warnings:
64 Warning 1292 Truncated incorrect myisam_repair_threads value: '-1024'
65 SELECT @@global.myisam_repair_threads ;
66 @@global.myisam_repair_threads
67 1
68 SET @@global.myisam_repair_threads = 429496729533;
69 SELECT @@global.myisam_repair_threads ;
70 @@global.myisam_repair_threads
71 4294967295
72 SET @@global.myisam_repair_threads = 65530.34;
73 ERROR 42000: Incorrect argument type to variable 'myisam_repair_threads'
74 SELECT @@global.myisam_repair_threads ;
75 @@global.myisam_repair_threads
76 4294967295
77 SET @@global.myisam_repair_threads = test;
78 ERROR 42000: Incorrect argument type to variable 'myisam_repair_threads'
79 SELECT @@global.myisam_repair_threads ;
80 @@global.myisam_repair_threads
81 4294967295
82 SET @@global.myisam_repair_threads = "test";
83 ERROR 42000: Incorrect argument type to variable 'myisam_repair_threads'
84 SELECT @@global.myisam_repair_threads ;
85 @@global.myisam_repair_threads
86 4294967295
87 SET @@global.myisam_repair_threads = 'test';
88 ERROR 42000: Incorrect argument type to variable 'myisam_repair_threads'
89 SELECT @@global.myisam_repair_threads ;
90 @@global.myisam_repair_threads
91 4294967295
92 SET @@global.myisam_repair_threads = ON;
93 ERROR 42000: Incorrect argument type to variable 'myisam_repair_threads'
94 SELECT @@global.myisam_repair_threads ;
95 @@global.myisam_repair_threads
96 4294967295
97 SET @@session.myisam_repair_threads = 0;
98 Warnings:
99 Warning 1292 Truncated incorrect myisam_repair_threads value: '0'
100 SELECT @@session.myisam_repair_threads ;
101 @@session.myisam_repair_threads
102 1
103 SET @@session.myisam_repair_threads = -2;
104 Warnings:
105 Warning 1292 Truncated incorrect myisam_repair_threads value: '-2'
106 SELECT @@session.myisam_repair_threads ;
107 @@session.myisam_repair_threads
108 1
109 SET @@session.myisam_repair_threads = 65530.34;
110 ERROR 42000: Incorrect argument type to variable 'myisam_repair_threads'
111 SELECT @@session.myisam_repair_threads ;
112 @@session.myisam_repair_threads
113 1
114 SET @@session.myisam_repair_threads = test;
115 ERROR 42000: Incorrect argument type to variable 'myisam_repair_threads'
116 SELECT @@session.myisam_repair_threads ;
117 @@session.myisam_repair_threads
118 1
119 SET @@session.myisam_repair_threads = "test";
120 ERROR 42000: Incorrect argument type to variable 'myisam_repair_threads'
121 SELECT @@session.myisam_repair_threads ;
122 @@session.myisam_repair_threads
123 1
124 '#------------------FN_DYNVARS_005_06-----------------------#'
125 SELECT @@global.myisam_repair_threads = VARIABLE_VALUE
126 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
127 WHERE VARIABLE_NAME='myisam_repair_threads ';
128 @@global.myisam_repair_threads = VARIABLE_VALUE
129 1
130 '#------------------FN_DYNVARS_005_07-----------------------#'
131 SELECT @@session.myisam_repair_threads = VARIABLE_VALUE
132 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
133 WHERE VARIABLE_NAME='myisam_repair_threads ';
134 @@session.myisam_repair_threads = VARIABLE_VALUE
135 1
136 '#------------------FN_DYNVARS_005_08-----------------------#'
137 SET @@global.myisam_repair_threads = TRUE;
138 SELECT @@global.myisam_repair_threads ;
139 @@global.myisam_repair_threads
140 1
141 SET @@global.myisam_repair_threads = FALSE;
142 Warnings:
143 Warning 1292 Truncated incorrect myisam_repair_threads value: '0'
144 SELECT @@global.myisam_repair_threads ;
145 @@global.myisam_repair_threads
146 1
147 '#---------------------FN_DYNVARS_001_09----------------------#'
148 SET @@global.myisam_repair_threads = 10;
149 SELECT @@myisam_repair_threads = @@global.myisam_repair_threads ;
150 @@myisam_repair_threads = @@global.myisam_repair_threads
151 0
152 '#---------------------FN_DYNVARS_001_10----------------------#'
153 SET @@myisam_repair_threads = 100;
154 SELECT @@myisam_repair_threads = @@local.myisam_repair_threads ;
155 @@myisam_repair_threads = @@local.myisam_repair_threads
156 1
157 SELECT @@local.myisam_repair_threads = @@session.myisam_repair_threads ;
158 @@local.myisam_repair_threads = @@session.myisam_repair_threads
159 1
160 '#---------------------FN_DYNVARS_001_11----------------------#'
161 SET myisam_repair_threads = 1;
162 SELECT @@myisam_repair_threads ;
163 @@myisam_repair_threads
164 1
165 SELECT local.myisam_repair_threads ;
166 ERROR 42S02: Unknown table 'local' in SELECT
167 SELECT session.myisam_repair_threads ;
168 ERROR 42S02: Unknown table 'session' in SELECT
169 SELECT myisam_repair_threads = @@session.myisam_repair_threads ;
170 ERROR 42S22: Unknown column 'myisam_repair_threads' in 'SELECT'
171 SET @@global.myisam_repair_threads = @start_global_value;
172 SELECT @@global.myisam_repair_threads ;
173 @@global.myisam_repair_threads
174 1
175 SET @@session.myisam_repair_threads = @start_session_value;
176 SELECT @@session.myisam_repair_threads ;
177 @@session.myisam_repair_threads
178 1