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 SET @start_global_value = @@global.max_join_size;
9 SELECT @start_global_value;
10
11 #
12 # exists as global and session
13 #
14 select @@global.max_join_size;
15 select @@session.max_join_size;
16 show global variables like 'max_join_size';
17 show session variables like 'max_join_size';
18 --disable_warnings
19 select * from performance_schema.global_variables where variable_name='max_join_size';
20 select * from performance_schema.session_variables where variable_name='max_join_size';
21 --enable_warnings
22
23 #
24 # show that it's writable
25 #
26 set global max_join_size=10;
27 set session max_join_size=20;
28 select @@global.max_join_size;
29 select @@session.max_join_size;
30 # Using SQL_BIG_SELECT to ignore MAX_JOIN_SIZE.
31 SET SQL_BIG_SELECTS=1;
32 show global variables like 'max_join_size';
33 show session variables like 'max_join_size';
34 --disable_warnings
35 # Using SQL_BIG_SELECT to ignore MAX_JOIN_SIZE.
36 SET SQL_BIG_SELECTS=1;
37 select * from performance_schema.global_variables where variable_name='max_join_size';
38 select * from performance_schema.session_variables where variable_name='max_join_size';
39 --enable_warnings
40
41 #
42 # display default value of max_join_size
43 #
44 SET @@global.max_join_size = 1000;
45 SET @@global.max_join_size = DEFAULT;
46 SELECT @@global.max_join_size;
47
48 SET @@session.max_join_size = 1000;
49 SET @@session.max_join_size = DEFAULT;
50 SELECT @@session.max_join_size;
51
52 #
53 # verify the default value of max_join_size
54 #
55 SET @@global.max_join_size = DEFAULT;
56 SELECT @@global.max_join_size = 4294967295;
57
58 SET @@session.max_join_size = DEFAULT;
59 SELECT @@session.max_join_size = 4294967295;
60
61 #
62 # valid values
63 #
64
65 SET @@global.max_join_size = 1;
66 SELECT @@global.max_join_size;
67 SET @@global.max_join_size = 4294967295;
68 SELECT @@global.max_join_size;
69
70 SET @@session.max_join_size = 1;
71 SELECT @@session.max_join_size;
72 SET @@session.max_join_size = 4294967295;
73 SELECT @@session.max_join_size;
74
75 #
76 # out-of-bound values
77 #
78
79 SET @@global.max_join_size = 0;
80 SELECT @@global.max_join_size;
81 SET @@global.max_join_size = -1024;
82 SELECT @@global.max_join_size;
83 SET @@global.max_join_size = 114294967295;
84 SELECT @@global.max_join_size;
85 --Error ER_WRONG_TYPE_FOR_VAR
86 SET @@global.max_join_size = ' ';
87 SELECT @@global.max_join_size;
88
89 SET @@session.max_join_size = 0;
90 SELECT @@session.max_join_size;
91 SET @@session.max_join_size = -1024;
92 SELECT @@session.max_join_size;
93 SET @@session.max_join_size = 114294967295;
94 SELECT @@session.max_join_size;
95 --Error ER_WRONG_TYPE_FOR_VAR
96 SET @@session.max_join_size = ' ';
97 SELECT @@session.max_join_size;
98
99 #
100 # incorrect types
101 #
102 --error ER_WRONG_TYPE_FOR_VAR
103 set global max_join_size=1.1;
104 --error ER_WRONG_TYPE_FOR_VAR
105 set global max_join_size=1e1;
106 --error ER_WRONG_TYPE_FOR_VAR
107 set global max_join_size="foo";
108
109 #
110 # affects OPTION_BIG_SELECTS
111 #
112 select @@sql_big_selects;
113 set max_join_size=cast(-1 as unsigned int);
114 select @@sql_big_selects;
115 set max_join_size=100;
116 select @@sql_big_selects;
117
118 SET @@global.max_join_size = @start_global_value;
119 SELECT @@global.max_join_size;