1
by brian
clean slate |
1 |
drop table if exists t1,t2; |
2 |
set @my_max_connect_errors =@@global.max_connect_errors; |
|
3 |
set @my_max_heap_table_size =@@global.max_heap_table_size; |
|
4 |
set @my_max_join_size =@@global.max_join_size; |
|
1305.1.1
by Eric Day
Switched to using the MySQL protocol by default. |
5 |
set @my_mysql_protocol_buffer_length =@@global.mysql_protocol_buffer_length; |
1
by brian
clean slate |
6 |
set @my_server_id =@@global.server_id; |
7 |
set @my_storage_engine =@@global.storage_engine; |
|
1119.4.7
by Stewart Smith
make variables test not leave state of server in a modified state. i.e. fully |
8 |
set @my_myisam_sort_buffer_size =@@global.myisam_sort_buffer_size; |
1487.1.1
by Brian Aker
There is room for improvement around this. We should be using rows as well |
9 |
set @my_tx_isolation =@@global.tx_isolation; |
1
by brian
clean slate |
10 |
set @`test`=1; |
11 |
select @test, @`test`, @TEST, @`TEST`, @"teSt"; |
|
12 |
@test @`test` @TEST @`TEST` @"teSt" |
|
13 |
1 1 1 1 1 |
|
14 |
set @TEST=2; |
|
15 |
select @test, @`test`, @TEST, @`TEST`, @"teSt"; |
|
16 |
@test @`test` @TEST @`TEST` @"teSt" |
|
17 |
2 2 2 2 2 |
|
18 |
set @"tEST"=3; |
|
19 |
select @test, @`test`, @TEST, @`TEST`, @"teSt"; |
|
20 |
@test @`test` @TEST @`TEST` @"teSt" |
|
21 |
3 3 3 3 3 |
|
22 |
set @`TeST`=4; |
|
23 |
select @test, @`test`, @TEST, @`TEST`, @"teSt"; |
|
24 |
@test @`test` @TEST @`TEST` @"teSt" |
|
25 |
4 4 4 4 4 |
|
26 |
select @`teST`:=5; |
|
27 |
@`teST`:=5 |
|
28 |
5
|
|
29 |
select @test, @`test`, @TEST, @`TEST`, @"teSt"; |
|
30 |
@test @`test` @TEST @`TEST` @"teSt" |
|
31 |
5 5 5 5 5 |
|
32 |
set @select=2,@t5=1.23456; |
|
33 |
select @`select`,@not_used; |
|
34 |
@`select` @not_used |
|
35 |
2 NULL |
|
36 |
set @test_int=10,@test_double=1e-10,@test_string="abcdeghi",@test_string2="abcdefghij",@select=NULL; |
|
37 |
select @test_int,@test_double,@test_string,@test_string2,@select; |
|
38 |
@test_int @test_double @test_string @test_string2 @select |
|
39 |
10 0.0000000001 abcdeghi abcdefghij NULL |
|
40 |
set @test_int="hello",@test_double="hello",@test_string="hello",@test_string2="hello"; |
|
41 |
select @test_int,@test_double,@test_string,@test_string2; |
|
42 |
@test_int @test_double @test_string @test_string2 |
|
43 |
hello hello hello hello |
|
44 |
set @test_int="hellohello",@test_double="hellohello",@test_string="hellohello",@test_string2="hellohello"; |
|
45 |
select @test_int,@test_double,@test_string,@test_string2; |
|
46 |
@test_int @test_double @test_string @test_string2 |
|
47 |
hellohello hellohello hellohello hellohello |
|
48 |
set @test_int=null,@test_double=null,@test_string=null,@test_string2=null; |
|
49 |
select @test_int,@test_double,@test_string,@test_string2; |
|
50 |
@test_int @test_double @test_string @test_string2 |
|
51 |
NULL NULL NULL NULL |
|
52 |
select @t1:=(@t2:=1)+@t3:=4,@t1,@t2,@t3; |
|
53 |
@t1:=(@t2:=1)+@t3:=4 @t1 @t2 @t3 |
|
54 |
5 5 1 4 |
|
55 |
explain extended select @t1:=(@t2:=1)+@t3:=4,@t1,@t2,@t3; |
|
56 |
id select_type table type possible_keys key key_len ref rows filtered Extra |
|
57 |
1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL No tables used |
|
58 |
Warnings: |
|
59 |
Note 1003 select (@t1:=((@t2:=1) + (@t3:=4))) AS `@t1:=(@t2:=1)+@t3:=4`,(@t1) AS `@t1`,(@t2) AS `@t2`,(@t3) AS `@t3` |
|
60 |
select @t5; |
|
61 |
@t5 |
|
62 |
1.23456
|
|
642.1.53
by Lee
enable subselect_not, subselect_no_mat and variables tests, some other misc clean up on other tests |
63 |
CREATE TABLE t1 (c_id INT NOT NULL, c_name VARCHAR(250), c_country VARCHAR(250), PRIMARY KEY(c_id)); |
1
by brian
clean slate |
64 |
INSERT INTO t1 VALUES (1,'Bozo','USA'),(2,'Ronald','USA'),(3,'Kinko','IRE'),(4,'Mr. Floppy','GB'); |
65 |
SELECT @min_cid:=min(c_id), @max_cid:=max(c_id) from t1; |
|
66 |
@min_cid:=min(c_id) @max_cid:=max(c_id) |
|
67 |
1 4 |
|
68 |
SELECT * FROM t1 WHERE c_id=@min_cid OR c_id=@max_cid; |
|
69 |
c_id c_name c_country |
|
70 |
1 Bozo USA |
|
71 |
4 Mr. Floppy GB |
|
72 |
SELECT * FROM t1 WHERE c_id=@min_cid OR c_id=@max_cid OR c_id=666; |
|
73 |
c_id c_name c_country |
|
74 |
1 Bozo USA |
|
75 |
4 Mr. Floppy GB |
|
76 |
ALTER TABLE t1 DROP PRIMARY KEY; |
|
77 |
select * from t1 where c_id=@min_cid OR c_id=@max_cid; |
|
78 |
c_id c_name c_country |
|
79 |
1 Bozo USA |
|
80 |
4 Mr. Floppy GB |
|
81 |
drop table t1; |
|
82 |
set GLOBAL max_join_size=10; |
|
83 |
set max_join_size=100; |
|
84 |
show variables like 'max_join_size'; |
|
85 |
Variable_name Value |
|
86 |
max_join_size 100 |
|
1273.13.32
by Brian Aker
Big ole patch. This covers moving information_schema to old_* table names |
87 |
select * from data_dictionary.session_variables where variable_name like 'max_join_size'; |
1
by brian
clean slate |
88 |
VARIABLE_NAME VARIABLE_VALUE |
1280.1.1
by Brian Aker
Remove option where variable case is changed. |
89 |
max_join_size 100 |
1
by brian
clean slate |
90 |
show global variables like 'max_join_size'; |
91 |
Variable_name Value |
|
92 |
max_join_size 10 |
|
1273.13.32
by Brian Aker
Big ole patch. This covers moving information_schema to old_* table names |
93 |
select * from data_dictionary.global_variables where variable_name like 'max_join_size'; |
1
by brian
clean slate |
94 |
VARIABLE_NAME VARIABLE_VALUE |
1280.1.1
by Brian Aker
Remove option where variable case is changed. |
95 |
max_join_size 10 |
1
by brian
clean slate |
96 |
set GLOBAL max_join_size=2000; |
97 |
show global variables like 'max_join_size'; |
|
98 |
Variable_name Value |
|
99 |
max_join_size 2000 |
|
1273.13.32
by Brian Aker
Big ole patch. This covers moving information_schema to old_* table names |
100 |
select * from data_dictionary.global_variables where variable_name like 'max_join_size'; |
1
by brian
clean slate |
101 |
VARIABLE_NAME VARIABLE_VALUE |
1280.1.1
by Brian Aker
Remove option where variable case is changed. |
102 |
max_join_size 2000 |
1
by brian
clean slate |
103 |
set max_join_size=DEFAULT; |
104 |
show variables like 'max_join_size'; |
|
105 |
Variable_name Value |
|
106 |
max_join_size 2000 |
|
1273.13.32
by Brian Aker
Big ole patch. This covers moving information_schema to old_* table names |
107 |
select * from data_dictionary.session_variables where variable_name like 'max_join_size'; |
1
by brian
clean slate |
108 |
VARIABLE_NAME VARIABLE_VALUE |
1280.1.1
by Brian Aker
Remove option where variable case is changed. |
109 |
max_join_size 2000 |
1
by brian
clean slate |
110 |
set GLOBAL max_join_size=DEFAULT; |
111 |
show global variables like 'max_join_size'; |
|
112 |
Variable_name Value |
|
642.1.53
by Lee
enable subselect_not, subselect_no_mat and variables tests, some other misc clean up on other tests |
113 |
max_join_size 2147483647 |
1273.13.32
by Brian Aker
Big ole patch. This covers moving information_schema to old_* table names |
114 |
select * from data_dictionary.global_variables where variable_name like 'max_join_size'; |
1
by brian
clean slate |
115 |
VARIABLE_NAME VARIABLE_VALUE |
1280.1.1
by Brian Aker
Remove option where variable case is changed. |
116 |
max_join_size 2147483647 |
1
by brian
clean slate |
117 |
set @@max_join_size=1000, @@global.max_join_size=2000; |
118 |
select @@local.max_join_size, @@global.max_join_size; |
|
119 |
@@local.max_join_size @@global.max_join_size |
|
120 |
1000 2000 |
|
121 |
select @@identity, length(@@version)>0; |
|
122 |
@@identity length(@@version)>0 |
|
123 |
0 1 |
|
124 |
select @@VERSION=version(); |
|
125 |
@@VERSION=version() |
|
126 |
1
|
|
127 |
select last_insert_id(345); |
|
128 |
last_insert_id(345) |
|
129 |
345
|
|
130 |
explain extended select last_insert_id(345); |
|
131 |
id select_type table type possible_keys key key_len ref rows filtered Extra |
|
132 |
1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL No tables used |
|
133 |
Warnings: |
|
134 |
Note 1003 select last_insert_id(345) AS `last_insert_id(345)` |
|
135 |
select @@IDENTITY,last_insert_id(), @@identity; |
|
136 |
@@IDENTITY last_insert_id() @@identity |
|
137 |
345 345 345 |
|
138 |
explain extended select @@IDENTITY,last_insert_id(), @@identity; |
|
139 |
id select_type table type possible_keys key key_len ref rows filtered Extra |
|
140 |
1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL No tables used |
|
141 |
Warnings: |
|
142 |
Note 1003 select 345 AS `@@IDENTITY`,last_insert_id() AS `last_insert_id()`,345 AS `@@identity` |
|
143 |
set global timed_mutexes=ON; |
|
144 |
show variables like 'timed_mutexes'; |
|
145 |
Variable_name Value |
|
146 |
timed_mutexes ON |
|
1273.13.32
by Brian Aker
Big ole patch. This covers moving information_schema to old_* table names |
147 |
select * from data_dictionary.session_variables where variable_name like 'timed_mutexes'; |
1
by brian
clean slate |
148 |
VARIABLE_NAME VARIABLE_VALUE |
1280.1.1
by Brian Aker
Remove option where variable case is changed. |
149 |
timed_mutexes ON |
1
by brian
clean slate |
150 |
set global timed_mutexes=0; |
151 |
show variables like 'timed_mutexes'; |
|
152 |
Variable_name Value |
|
153 |
timed_mutexes OFF |
|
1273.13.32
by Brian Aker
Big ole patch. This covers moving information_schema to old_* table names |
154 |
select * from data_dictionary.session_variables where variable_name like 'timed_mutexes'; |
1
by brian
clean slate |
155 |
VARIABLE_NAME VARIABLE_VALUE |
1280.1.1
by Brian Aker
Remove option where variable case is changed. |
156 |
timed_mutexes OFF |
1233.2.1
by Monty Taylor
Renamed instances of HEAP engine to MEMORY. Removed the alias. |
157 |
set storage_engine=MYISAM, storage_engine="MEMORY"; |
1
by brian
clean slate |
158 |
show local variables like 'storage_engine'; |
159 |
Variable_name Value |
|
160 |
storage_engine MEMORY |
|
1273.13.32
by Brian Aker
Big ole patch. This covers moving information_schema to old_* table names |
161 |
select * from data_dictionary.session_variables where variable_name like 'storage_engine'; |
1
by brian
clean slate |
162 |
VARIABLE_NAME VARIABLE_VALUE |
1280.1.1
by Brian Aker
Remove option where variable case is changed. |
163 |
storage_engine MEMORY |
1
by brian
clean slate |
164 |
show global variables like 'storage_engine'; |
165 |
Variable_name Value |
|
642.1.53
by Lee
enable subselect_not, subselect_no_mat and variables tests, some other misc clean up on other tests |
166 |
storage_engine InnoDB |
1273.13.32
by Brian Aker
Big ole patch. This covers moving information_schema to old_* table names |
167 |
select * from data_dictionary.global_variables where variable_name like 'storage_engine'; |
1
by brian
clean slate |
168 |
VARIABLE_NAME VARIABLE_VALUE |
1280.1.1
by Brian Aker
Remove option where variable case is changed. |
169 |
storage_engine InnoDB |
1
by brian
clean slate |
170 |
set GLOBAL myisam_max_sort_file_size=2000000; |
171 |
show global variables like 'myisam_max_sort_file_size'; |
|
172 |
Variable_name Value |
|
788
by Brian Aker
Move MyISAM bits to myisam plugin |
173 |
myisam_max_sort_file_size 2000000 |
1273.13.32
by Brian Aker
Big ole patch. This covers moving information_schema to old_* table names |
174 |
select * from data_dictionary.global_variables where variable_name like 'myisam_max_sort_file_size'; |
1
by brian
clean slate |
175 |
VARIABLE_NAME VARIABLE_VALUE |
1280.1.1
by Brian Aker
Remove option where variable case is changed. |
176 |
myisam_max_sort_file_size 2000000 |
1
by brian
clean slate |
177 |
set GLOBAL myisam_max_sort_file_size=default; |
178 |
show global variables like 'myisam_max_sort_file_size'; |
|
179 |
Variable_name Value |
|
788
by Brian Aker
Move MyISAM bits to myisam plugin |
180 |
myisam_max_sort_file_size 2147483647 |
1273.13.32
by Brian Aker
Big ole patch. This covers moving information_schema to old_* table names |
181 |
select * from data_dictionary.global_variables where variable_name like 'myisam_max_sort_file_size'; |
1
by brian
clean slate |
182 |
VARIABLE_NAME VARIABLE_VALUE |
1280.1.1
by Brian Aker
Remove option where variable case is changed. |
183 |
myisam_max_sort_file_size 2147483647 |
1305.1.1
by Eric Day
Switched to using the MySQL protocol by default. |
184 |
set global mysql_protocol_buffer_length=1024; |
185 |
show global variables like 'mysql_protocol_buffer_%'; |
|
186 |
Variable_name Value |
|
187 |
mysql_protocol_buffer_length 1024 |
|
188 |
select * from data_dictionary.global_variables where variable_name like 'mysql_protocol_buffer_%'; |
|
189 |
VARIABLE_NAME VARIABLE_VALUE |
|
190 |
mysql_protocol_buffer_length 1024 |
|
191 |
show global variables like 'mysql_protocol_buffer_%'; |
|
192 |
Variable_name Value |
|
193 |
mysql_protocol_buffer_length 1024 |
|
194 |
select * from data_dictionary.global_variables where variable_name like 'mysql_protocol_buffer_%'; |
|
195 |
VARIABLE_NAME VARIABLE_VALUE |
|
196 |
mysql_protocol_buffer_length 1024 |
|
197 |
set global mysql_protocol_buffer_length=1; |
|
971.7.3
by Eric Day
Added net_buffer_length tests back in as oldlibdrizzle_buffer_length tests. |
198 |
Warnings: |
199 |
Error 1292 Truncated incorrect buffer_length value: '1' |
|
1305.1.1
by Eric Day
Switched to using the MySQL protocol by default. |
200 |
show variables like 'mysql_protocol_buffer_length'; |
971.7.3
by Eric Day
Added net_buffer_length tests back in as oldlibdrizzle_buffer_length tests. |
201 |
Variable_name Value |
1305.1.1
by Eric Day
Switched to using the MySQL protocol by default. |
202 |
mysql_protocol_buffer_length 1024 |
203 |
set global mysql_protocol_buffer_length=2000000000; |
|
971.7.3
by Eric Day
Added net_buffer_length tests back in as oldlibdrizzle_buffer_length tests. |
204 |
Warnings: |
205 |
Error 1292 Truncated incorrect buffer_length value: '2000000000' |
|
1305.1.1
by Eric Day
Switched to using the MySQL protocol by default. |
206 |
show variables like 'mysql_protocol_buffer_length'; |
971.7.3
by Eric Day
Added net_buffer_length tests back in as oldlibdrizzle_buffer_length tests. |
207 |
Variable_name Value |
1305.1.1
by Eric Day
Switched to using the MySQL protocol by default. |
208 |
mysql_protocol_buffer_length 1048576 |
1
by brian
clean slate |
209 |
show variables like '%alloc%'; |
210 |
Variable_name Value |
|
933.1.2
by Monty Taylor
Fixed merge weirdness errors. |
211 |
innodb_use_sys_malloc ON |
1
by brian
clean slate |
212 |
query_alloc_block_size 8192 |
213 |
query_prealloc_size 8192 |
|
1273.13.72
by Brian Aker
1) Reduced the size of VARIABLE_VALUE. |
214 |
range_alloc_block_size 4096 |
1273.13.32
by Brian Aker
Big ole patch. This covers moving information_schema to old_* table names |
215 |
select * from data_dictionary.session_variables where variable_name like '%alloc%'; |
1
by brian
clean slate |
216 |
VARIABLE_NAME VARIABLE_VALUE |
1280.1.1
by Brian Aker
Remove option where variable case is changed. |
217 |
innodb_use_sys_malloc ON |
218 |
query_alloc_block_size 8192 |
|
219 |
query_prealloc_size 8192 |
|
1273.13.72
by Brian Aker
1) Reduced the size of VARIABLE_VALUE. |
220 |
range_alloc_block_size 4096 |
1
by brian
clean slate |
221 |
set @@range_alloc_block_size=1024*16; |
222 |
set @@query_alloc_block_size=1024*17+2; |
|
223 |
set @@query_prealloc_size=1024*18; |
|
224 |
select @@query_alloc_block_size; |
|
225 |
@@query_alloc_block_size |
|
226 |
17408
|
|
227 |
show variables like '%alloc%'; |
|
228 |
Variable_name Value |
|
933.1.2
by Monty Taylor
Fixed merge weirdness errors. |
229 |
innodb_use_sys_malloc ON |
1
by brian
clean slate |
230 |
query_alloc_block_size 17408 |
231 |
query_prealloc_size 18432 |
|
1273.13.72
by Brian Aker
1) Reduced the size of VARIABLE_VALUE. |
232 |
range_alloc_block_size 16384 |
1273.13.32
by Brian Aker
Big ole patch. This covers moving information_schema to old_* table names |
233 |
select * from data_dictionary.session_variables where variable_name like '%alloc%'; |
1
by brian
clean slate |
234 |
VARIABLE_NAME VARIABLE_VALUE |
1280.1.1
by Brian Aker
Remove option where variable case is changed. |
235 |
innodb_use_sys_malloc ON |
236 |
query_alloc_block_size 17408 |
|
237 |
query_prealloc_size 18432 |
|
1273.13.72
by Brian Aker
1) Reduced the size of VARIABLE_VALUE. |
238 |
range_alloc_block_size 16384 |
1
by brian
clean slate |
239 |
set @@range_alloc_block_size=default; |
240 |
set @@query_alloc_block_size=default, @@query_prealloc_size=default; |
|
241 |
show variables like '%alloc%'; |
|
242 |
Variable_name Value |
|
933.1.2
by Monty Taylor
Fixed merge weirdness errors. |
243 |
innodb_use_sys_malloc ON |
1
by brian
clean slate |
244 |
query_alloc_block_size 8192 |
245 |
query_prealloc_size 8192 |
|
1273.13.72
by Brian Aker
1) Reduced the size of VARIABLE_VALUE. |
246 |
range_alloc_block_size 4096 |
1273.13.32
by Brian Aker
Big ole patch. This covers moving information_schema to old_* table names |
247 |
select * from data_dictionary.session_variables where variable_name like '%alloc%'; |
1
by brian
clean slate |
248 |
VARIABLE_NAME VARIABLE_VALUE |
1280.1.1
by Brian Aker
Remove option where variable case is changed. |
249 |
innodb_use_sys_malloc ON |
250 |
query_alloc_block_size 8192 |
|
251 |
query_prealloc_size 8192 |
|
1273.13.72
by Brian Aker
1) Reduced the size of VARIABLE_VALUE. |
252 |
range_alloc_block_size 4096 |
1
by brian
clean slate |
253 |
SELECT @@version LIKE 'non-existent'; |
254 |
@@version LIKE 'non-existent' |
|
255 |
0
|
|
256 |
SELECT @@version_compile_os LIKE 'non-existent'; |
|
257 |
@@version_compile_os LIKE 'non-existent' |
|
258 |
0
|
|
259 |
set unknown_variable=1; |
|
260 |
ERROR HY000: Unknown system variable 'unknown_variable' |
|
261 |
set max_join_size="hello"; |
|
262 |
ERROR 42000: Incorrect argument type to variable 'max_join_size' |
|
263 |
set storage_engine=UNKNOWN_TABLE_TYPE; |
|
264 |
ERROR 42000: Unknown table engine 'UNKNOWN_TABLE_TYPE' |
|
265 |
set GLOBAL storage_engine=DEFAULT; |
|
266 |
ERROR 42000: Variable 'storage_engine' doesn't have a default value |
|
267 |
set global autocommit=1; |
|
268 |
ERROR HY000: Variable 'autocommit' is a SESSION variable and can't be used with SET GLOBAL |
|
269 |
select @@global.timestamp; |
|
270 |
ERROR HY000: Variable 'timestamp' is a SESSION variable |
|
271 |
set @@version=''; |
|
272 |
ERROR HY000: Variable 'version' is a read only variable |
|
273 |
set myisam_max_sort_file_size=100; |
|
274 |
ERROR HY000: Variable 'myisam_max_sort_file_size' is a GLOBAL variable and should be set with SET GLOBAL |
|
275 |
set @@SQL_WARNINGS=NULL; |
|
276 |
ERROR 42000: Variable 'sql_warnings' can't be set to the value of 'NULL' |
|
277 |
set autocommit=1; |
|
642.1.53
by Lee
enable subselect_not, subselect_no_mat and variables tests, some other misc clean up on other tests |
278 |
select @@autocommit; |
279 |
@@autocommit |
|
280 |
1
|
|
1
by brian
clean slate |
281 |
set bulk_insert_buffer_size=100; |
282 |
set join_buffer_size=100; |
|
283 |
Warnings: |
|
910.4.10
by Stewart Smith
fix system variables for correct endian architectures. |
284 |
Error 1292 Truncated incorrect join_buffer_size value: '100' |
1
by brian
clean slate |
285 |
set last_insert_id=1; |
286 |
set max_allowed_packet=100; |
|
287 |
Warnings: |
|
910.4.10
by Stewart Smith
fix system variables for correct endian architectures. |
288 |
Error 1292 Truncated incorrect max_allowed_packet value: '100' |
1
by brian
clean slate |
289 |
set global max_connect_errors=100; |
290 |
set max_heap_table_size=100; |
|
291 |
Warnings: |
|
910.4.10
by Stewart Smith
fix system variables for correct endian architectures. |
292 |
Error 1292 Truncated incorrect max_heap_table_size value: '100' |
1
by brian
clean slate |
293 |
set max_join_size=100; |
294 |
set max_sort_length=100; |
|
295 |
set global max_write_lock_count=100; |
|
789
by Brian Aker
MyISAM fix. |
296 |
set global myisam_sort_buffer_size=100; |
297 |
Warnings: |
|
910.4.10
by Stewart Smith
fix system variables for correct endian architectures. |
298 |
Error 1292 Truncated incorrect sort_buffer_size value: '100' |
1305.1.1
by Eric Day
Switched to using the MySQL protocol by default. |
299 |
set global mysql_protocol_buffer_length=100; |
971.7.3
by Eric Day
Added net_buffer_length tests back in as oldlibdrizzle_buffer_length tests. |
300 |
Warnings: |
301 |
Error 1292 Truncated incorrect buffer_length value: '100' |
|
1
by brian
clean slate |
302 |
set read_buffer_size=100; |
303 |
Warnings: |
|
910.4.10
by Stewart Smith
fix system variables for correct endian architectures. |
304 |
Error 1292 Truncated incorrect read_buffer_size value: '100' |
1
by brian
clean slate |
305 |
set read_rnd_buffer_size=100; |
306 |
set global server_id=100; |
|
307 |
set sort_buffer_size=100; |
|
308 |
Warnings: |
|
910.4.10
by Stewart Smith
fix system variables for correct endian architectures. |
309 |
Error 1292 Truncated incorrect sort_buffer_size value: '100' |
1
by brian
clean slate |
310 |
set sql_big_selects=1; |
311 |
set sql_buffer_result=1; |
|
312 |
set sql_select_limit=1; |
|
313 |
set sql_select_limit=default; |
|
314 |
set sql_warnings=1; |
|
315 |
set global table_open_cache=100; |
|
316 |
set storage_engine=myisam; |
|
317 |
set timestamp=1, timestamp=default; |
|
318 |
set tmp_table_size=100; |
|
319 |
Warnings: |
|
910.4.10
by Stewart Smith
fix system variables for correct endian architectures. |
320 |
Error 1292 Truncated incorrect tmp_table_size value: '100' |
1
by brian
clean slate |
321 |
set tx_isolation="READ-COMMITTED"; |
322 |
set global myisam_max_sort_file_size=4294967296; |
|
323 |
show global variables like 'myisam_max_sort_file_size'; |
|
324 |
Variable_name Value |
|
325 |
myisam_max_sort_file_size MAX_FILE_SIZE |
|
1273.13.32
by Brian Aker
Big ole patch. This covers moving information_schema to old_* table names |
326 |
select * from data_dictionary.global_variables where variable_name like 'myisam_max_sort_file_size'; |
1
by brian
clean slate |
327 |
VARIABLE_NAME VARIABLE_VALUE |
1280.1.1
by Brian Aker
Remove option where variable case is changed. |
328 |
myisam_max_sort_file_size MAX_FILE_SIZE |
1
by brian
clean slate |
329 |
set global myisam_max_sort_file_size=default; |
1063.9.46
by Stewart Smith
variables.test for MyISAM as temp only. |
330 |
create temporary table t1 ( |
642.1.53
by Lee
enable subselect_not, subselect_no_mat and variables tests, some other misc clean up on other tests |
331 |
c1 int, |
332 |
c2 int, |
|
333 |
c3 int, |
|
1
by brian
clean slate |
334 |
c4 int, |
335 |
c5 bigint); |
|
336 |
show create table t1; |
|
337 |
Table Create Table |
|
1063.9.46
by Stewart Smith
variables.test for MyISAM as temp only. |
338 |
t1 CREATE TEMPORARY TABLE `t1` ( |
1743.5.2
by LinuxJedi
Alter many test cases for the new SHOW CREATE TABLE output |
339 |
`c1` INT DEFAULT NULL, |
340 |
`c2` INT DEFAULT NULL, |
|
341 |
`c3` INT DEFAULT NULL, |
|
342 |
`c4` INT DEFAULT NULL, |
|
343 |
`c5` BIGINT DEFAULT NULL |
|
1638.10.82
by Stewart Smith
fix some tests for explicit COLLATE in CREATE TABLE |
344 |
) ENGINE=MyISAM COLLATE = utf8_general_ci |
1
by brian
clean slate |
345 |
drop table t1; |
346 |
set @arg00= 8, @arg01= 8.8, @arg02= 'a string', @arg03= 0.2e0; |
|
1063.9.46
by Stewart Smith
variables.test for MyISAM as temp only. |
347 |
create temporary table t1 as select @arg00 as c1, @arg01 as c2, @arg02 as c3, @arg03 as c4; |
1
by brian
clean slate |
348 |
show create table t1; |
349 |
Table Create Table |
|
1063.9.46
by Stewart Smith
variables.test for MyISAM as temp only. |
350 |
t1 CREATE TEMPORARY TABLE `t1` ( |
1743.5.2
by LinuxJedi
Alter many test cases for the new SHOW CREATE TABLE output |
351 |
`c1` BIGINT DEFAULT NULL, |
352 |
`c2` DECIMAL(65,30) DEFAULT NULL, |
|
353 |
`c3` TEXT COLLATE utf8_general_ci, |
|
354 |
`c4` DOUBLE DEFAULT NULL |
|
1638.10.82
by Stewart Smith
fix some tests for explicit COLLATE in CREATE TABLE |
355 |
) ENGINE=MyISAM COLLATE = utf8_general_ci |
1
by brian
clean slate |
356 |
drop table t1; |
357 |
SET GLOBAL table_open_cache=-1; |
|
358 |
Warnings: |
|
910.4.10
by Stewart Smith
fix system variables for correct endian architectures. |
359 |
Error 1292 Truncated incorrect table_open_cache value: '18446744073709551615' |
1
by brian
clean slate |
360 |
SHOW VARIABLES LIKE 'table_open_cache'; |
361 |
Variable_name Value |
|
910.4.10
by Stewart Smith
fix system variables for correct endian architectures. |
362 |
table_open_cache 100 |
1273.13.32
by Brian Aker
Big ole patch. This covers moving information_schema to old_* table names |
363 |
SELECT * FROM DATA_DICTIONARY.SESSION_VARIABLES WHERE VARIABLE_NAME LIKE 'table_open_cache'; |
971.2.1
by Eric Day
Fix for bug #311025. This was due to code that was removed during ulong cleanup (r576). |
364 |
VARIABLE_NAME VARIABLE_VALUE |
1280.1.1
by Brian Aker
Remove option where variable case is changed. |
365 |
table_open_cache 100 |
1
by brian
clean slate |
366 |
SET GLOBAL table_open_cache=DEFAULT; |
367 |
*** Various tests with LC_TIME_NAMES |
|
368 |
*** LC_TIME_NAMES: testing case insensitivity |
|
369 |
set @@lc_time_names='ru_ru'; |
|
370 |
select @@lc_time_names; |
|
371 |
@@lc_time_names |
|
372 |
ru_RU
|
|
373 |
*** LC_TIME_NAMES: testing with a user variable |
|
374 |
set @lc='JA_JP'; |
|
375 |
set @@lc_time_names=@lc; |
|
376 |
select @@lc_time_names; |
|
377 |
@@lc_time_names |
|
378 |
ja_JP
|
|
379 |
*** LC_TIME_NAMES: testing with string expressions |
|
380 |
set lc_time_names=concat('de','_','DE'); |
|
381 |
select @@lc_time_names; |
|
382 |
@@lc_time_names |
|
383 |
de_DE
|
|
384 |
set lc_time_names=concat('de','+','DE'); |
|
385 |
ERROR HY000: Unknown locale: 'de+DE' |
|
386 |
select @@lc_time_names; |
|
387 |
@@lc_time_names |
|
388 |
de_DE
|
|
389 |
LC_TIME_NAMES: testing with numeric expressions |
|
390 |
set @@lc_time_names=1+2; |
|
391 |
select @@lc_time_names; |
|
392 |
@@lc_time_names |
|
393 |
sv_SE
|
|
394 |
set @@lc_time_names=1/0; |
|
395 |
ERROR 42000: Incorrect argument type to variable 'lc_time_names' |
|
396 |
select @@lc_time_names; |
|
397 |
@@lc_time_names |
|
398 |
sv_SE
|
|
399 |
set lc_time_names=en_US; |
|
400 |
LC_TIME_NAMES: testing NULL and a negative number: |
|
401 |
set lc_time_names=NULL; |
|
402 |
ERROR 42000: Variable 'lc_time_names' can't be set to the value of 'NULL' |
|
403 |
set lc_time_names=-1; |
|
404 |
ERROR HY000: Unknown locale: '-1' |
|
405 |
select @@lc_time_names; |
|
406 |
@@lc_time_names |
|
407 |
en_US
|
|
408 |
LC_TIME_NAMES: testing locale with the last ID: |
|
409 |
set lc_time_names=108; |
|
410 |
select @@lc_time_names; |
|
411 |
@@lc_time_names |
|
412 |
zh_HK
|
|
413 |
LC_TIME_NAMES: testing a number beyond the valid ID range: |
|
414 |
set lc_time_names=109; |
|
415 |
ERROR HY000: Unknown locale: '109' |
|
416 |
select @@lc_time_names; |
|
417 |
@@lc_time_names |
|
418 |
zh_HK
|
|
419 |
LC_TIME_NAMES: testing that 0 is en_US: |
|
420 |
set lc_time_names=0; |
|
421 |
select @@lc_time_names; |
|
422 |
@@lc_time_names |
|
423 |
en_US
|
|
424 |
select @@global.lc_time_names, @@lc_time_names; |
|
425 |
@@global.lc_time_names @@lc_time_names |
|
426 |
en_US en_US |
|
427 |
set @@global.lc_time_names=fr_FR; |
|
428 |
select @@global.lc_time_names, @@lc_time_names; |
|
429 |
@@global.lc_time_names @@lc_time_names |
|
430 |
fr_FR en_US |
|
431 |
New connection |
|
432 |
select @@global.lc_time_names, @@lc_time_names; |
|
433 |
@@global.lc_time_names @@lc_time_names |
|
434 |
fr_FR fr_FR |
|
435 |
set @@lc_time_names=ru_RU; |
|
436 |
select @@global.lc_time_names, @@lc_time_names; |
|
437 |
@@global.lc_time_names @@lc_time_names |
|
438 |
fr_FR ru_RU |
|
439 |
Returnung to default connection |
|
440 |
select @@global.lc_time_names, @@lc_time_names; |
|
441 |
@@global.lc_time_names @@lc_time_names |
|
442 |
fr_FR en_US |
|
443 |
set lc_time_names=default; |
|
444 |
select @@global.lc_time_names, @@lc_time_names; |
|
445 |
@@global.lc_time_names @@lc_time_names |
|
446 |
fr_FR fr_FR |
|
447 |
set @@global.lc_time_names=default; |
|
448 |
select @@global.lc_time_names, @@lc_time_names; |
|
449 |
@@global.lc_time_names @@lc_time_names |
|
450 |
en_US fr_FR |
|
451 |
set @@lc_time_names=default; |
|
452 |
select @@global.lc_time_names, @@lc_time_names; |
|
453 |
@@global.lc_time_names @@lc_time_names |
|
454 |
en_US en_US |
|
455 |
set @test = @@query_prealloc_size; |
|
456 |
set @@query_prealloc_size = @test; |
|
457 |
select @@query_prealloc_size = @test; |
|
458 |
@@query_prealloc_size = @test |
|
459 |
1
|
|
460 |
End of 4.1 tests |
|
1063.9.46
by Stewart Smith
variables.test for MyISAM as temp only. |
461 |
create temporary table t1 (a int); |
1
by brian
clean slate |
462 |
select a into @x from t1; |
463 |
Warnings: |
|
464 |
Warning 1329 No data - zero rows fetched, selected, or processed |
|
465 |
show warnings; |
|
466 |
Level Code Message |
|
467 |
Warning 1329 No data - zero rows fetched, selected, or processed |
|
468 |
drop table t1; |
|
469 |
set @@warning_count=1; |
|
470 |
ERROR HY000: Variable 'warning_count' is a read only variable |
|
471 |
set @@global.error_count=1; |
|
472 |
ERROR HY000: Variable 'error_count' is a read only variable |
|
473 |
select @@character_set_system; |
|
642.1.53
by Lee
enable subselect_not, subselect_no_mat and variables tests, some other misc clean up on other tests |
474 |
ERROR HY000: Unknown system variable 'character_set_system' |
475 |
set global character_set_system = utf8; |
|
476 |
ERROR HY000: Unknown system variable 'character_set_system' |
|
1
by brian
clean slate |
477 |
set @@global.version_compile_os='234'; |
478 |
ERROR HY000: Variable 'version_compile_os' is a read only variable |
|
642.1.53
by Lee
enable subselect_not, subselect_no_mat and variables tests, some other misc clean up on other tests |
479 |
set @@global.character_set_filesystem=utf8; |
480 |
ERROR HY000: Unknown system variable 'character_set_filesystem' |
|
481 |
set character_set_filesystem=utf8; |
|
482 |
ERROR HY000: Unknown system variable 'character_set_filesystem' |
|
1273.13.32
by Brian Aker
Big ole patch. This covers moving information_schema to old_* table names |
483 |
set @sql_big_selects = @@sql_big_selects; |
1
by brian
clean slate |
484 |
set @@sql_big_selects = 1; |
485 |
show variables like 'sql_big_selects'; |
|
486 |
Variable_name Value |
|
487 |
sql_big_selects ON |
|
1273.13.32
by Brian Aker
Big ole patch. This covers moving information_schema to old_* table names |
488 |
set @@sql_big_selects = @sql_big_selects; |
1
by brian
clean slate |
489 |
set @@sql_notes = 0, @@sql_warnings = 0; |
490 |
show variables like 'sql_notes'; |
|
491 |
Variable_name Value |
|
492 |
sql_notes OFF |
|
493 |
show variables like 'sql_warnings'; |
|
494 |
Variable_name Value |
|
495 |
sql_warnings OFF |
|
496 |
set @@sql_notes = 1, @@sql_warnings = 1; |
|
497 |
show variables like 'sql_notes'; |
|
498 |
Variable_name Value |
|
499 |
sql_notes ON |
|
500 |
show variables like 'sql_warnings'; |
|
501 |
Variable_name Value |
|
502 |
sql_warnings ON |
|
503 |
select @@version, @@version_comment, @@version_compile_machine, |
|
504 |
@@version_compile_os; |
|
505 |
@@version @@version_comment @@version_compile_machine @@version_compile_os |
|
506 |
# # # #
|
|
507 |
select @@basedir, @@datadir, @@tmpdir; |
|
508 |
@@basedir @@datadir @@tmpdir |
|
509 |
# # #
|
|
510 |
show variables like 'basedir'; |
|
511 |
Variable_name Value |
|
512 |
basedir # |
|
513 |
show variables like 'datadir'; |
|
514 |
Variable_name Value |
|
515 |
datadir # |
|
516 |
show variables like 'tmpdir'; |
|
517 |
Variable_name Value |
|
518 |
tmpdir # |
|
519 |
select @@""; |
|
642.1.53
by Lee
enable subselect_not, subselect_no_mat and variables tests, some other misc clean up on other tests |
520 |
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near '""' at line 1 |
1
by brian
clean slate |
521 |
select @@&; |
642.1.53
by Lee
enable subselect_not, subselect_no_mat and variables tests, some other misc clean up on other tests |
522 |
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near '&' at line 1 |
1
by brian
clean slate |
523 |
select @@@; |
642.1.53
by Lee
enable subselect_not, subselect_no_mat and variables tests, some other misc clean up on other tests |
524 |
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near '@' at line 1 |
1
by brian
clean slate |
525 |
select @@hostname; |
526 |
@@hostname |
|
527 |
#
|
|
528 |
set @@hostname= "anothername"; |
|
529 |
ERROR HY000: Variable 'hostname' is a read only variable |
|
530 |
show variables like 'hostname'; |
|
531 |
Variable_name Value |
|
532 |
hostname # |
|
533 |
End of 5.0 tests |
|
534 |
set global flush_time =@my_flush_time; |
|
642.1.53
by Lee
enable subselect_not, subselect_no_mat and variables tests, some other misc clean up on other tests |
535 |
ERROR HY000: Unknown system variable 'flush_time' |
1
by brian
clean slate |
536 |
set global max_connect_errors =@my_max_connect_errors; |
537 |
set global max_heap_table_size =@my_max_heap_table_size; |
|
538 |
set global max_join_size =@my_max_join_size; |
|
539 |
set global max_write_lock_count =default; |
|
1305.1.1
by Eric Day
Switched to using the MySQL protocol by default. |
540 |
set global mysql_protocol_buffer_length= @my_mysql_protocol_buffer_length; |
1
by brian
clean slate |
541 |
set global server_id =@my_server_id; |
542 |
set global storage_engine =@my_storage_engine; |
|
543 |
set global thread_cache_size =@my_thread_cache_size; |
|
642.1.53
by Lee
enable subselect_not, subselect_no_mat and variables tests, some other misc clean up on other tests |
544 |
ERROR HY000: Unknown system variable 'thread_cache_size' |
1119.4.14
by Stewart Smith
slightly out of order variables result from fixing up server state |
545 |
set global myisam_sort_buffer_size =@my_myisam_sort_buffer_size; |
1487.1.1
by Brian Aker
There is room for improvement around this. We should be using rows as well |
546 |
SHOW GLOBAL VARIABLES LIKE 'max_join_size'; |
547 |
Variable_name Value |
|
548 |
max_join_size 2147483647 |
|
549 |
SHOW LOCAL VARIABLES LIKE 'max_join_size'; |
|
550 |
Variable_name Value |
|
551 |
max_join_size 100 |
|
552 |
set GLOBAL bulk_insert_buffer_size=DEFAULT; |
|
553 |
set GLOBAL join_buffer_size=DEFAULT; |
|
554 |
set GLOBAL max_allowed_packet=DEFAULT; |
|
555 |
set GLOBAL max_connect_errors=DEFAULT; |
|
556 |
set GLOBAL max_heap_table_size=DEFAULT; |
|
557 |
set GLOBAL max_join_size=DEFAULT; |
|
558 |
set GLOBAL max_sort_length=DEFAULT; |
|
559 |
set GLOBAL max_write_lock_count=DEFAULT; |
|
560 |
set GLOBAL myisam_sort_buffer_size=DEFAULT; |
|
561 |
set GLOBAL mysql_protocol_buffer_length=DEFAULT; |
|
562 |
set GLOBAL read_buffer_size=DEFAULT; |
|
563 |
set GLOBAL read_rnd_buffer_size=DEFAULT; |
|
564 |
set GLOBAL server_id=DEFAULT; |
|
565 |
set GLOBAL sort_buffer_size=DEFAULT; |
|
566 |
set GLOBAL table_open_cache=DEFAULT; |
|
567 |
set GLOBAL storage_engine= @my_storage_engine; |
|
568 |
set GLOBAL tmp_table_size=DEFAULT; |
|
569 |
set GLOBAL tx_isolation= @my_tx_isolation; |
|
570 |
set SESSION bulk_insert_buffer_size=DEFAULT; |
|
571 |
set SESSION join_buffer_size=DEFAULT; |
|
572 |
set SESSION max_allowed_packet=DEFAULT; |
|
573 |
set SESSION max_heap_table_size=DEFAULT; |
|
574 |
set SESSION max_join_size=DEFAULT; |
|
575 |
set SESSION max_sort_length=DEFAULT; |
|
576 |
set SESSION read_buffer_size=DEFAULT; |
|
577 |
set SESSION read_rnd_buffer_size=DEFAULT; |
|
578 |
set SESSION sort_buffer_size=DEFAULT; |
|
579 |
set SESSION sql_big_selects=DEFAULT; |
|
580 |
set SESSION sql_buffer_result=DEFAULT; |
|
581 |
set SESSION sql_select_limit=DEFAULT; |
|
582 |
set SESSION sql_warnings=DEFAULT; |
|
583 |
set SESSION storage_engine= @my_storage_engine; |
|
584 |
set SESSION tmp_table_size=DEFAULT; |
|
585 |
set SESSION tx_isolation= @my_tx_isolation; |
|
1055.1.2
by Padraig O'Sullivan
Updated test case based on bug fix. |
586 |
show global variables where variable_name='table_definition_cache' or Variable_name='table_lock_wait_timeout'; |
587 |
Variable_name Value |
|
588 |
table_definition_cache # |
|
589 |
table_lock_wait_timeout # |