Debian Codegraph @

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

raw
1
2
3 #
4 # 2010-01-20 - OBN - Added check for variable value sameas I_S table
5 # after variable value change
6 #
7
8
9 SET @start_global_value = @@global.max_join_size;
10 SELECT @start_global_value;
11
12 #
13 # exists as global and session
14 #
15 select @@global.max_join_size;
16 select @@session.max_join_size;
17 show global variables like 'max_join_size';
18 show session variables like 'max_join_size';
19 select * from information_schema.global_variables where variable_name='max_join_size';
20 select * from information_schema.session_variables where variable_name='max_join_size';
21
22 #
23 # show that it's writable
24 #
25 set global max_join_size=10;
26 set session max_join_size=100;
27 select @@global.max_join_size;
28 select @@session.max_join_size;
29 show global variables like 'max_join_size';
30 show session variables like 'max_join_size';
31 select * from information_schema.global_variables where variable_name='max_join_size';
32 select * from information_schema.session_variables where variable_name='max_join_size';
33
34 #
35 # incorrect types
36 #
37 --error ER_WRONG_TYPE_FOR_VAR
38 set global max_join_size=1.1;
39 --error ER_WRONG_TYPE_FOR_VAR
40 set global max_join_size=1e1;
41 --error ER_WRONG_TYPE_FOR_VAR
42 set global max_join_size="foo";
43
44 #
45 # affects OPTION_BIG_SELECTS
46 #
47 select @@sql_big_selects;
48 set max_join_size=cast(-1 as unsigned int);
49 select @@sql_big_selects;
50 set max_join_size=100;
51 select @@sql_big_selects;
52
53 SET @@global.max_join_size = @start_global_value;
54 SELECT @@global.max_join_size;