Debian Codegraph @

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

raw
1 ** Setup **
2 SET @session_max_join_size = @@SESSION.sql_max_join_size;
3 SET @global_max_join_size = @@GLOBAL.sql_max_join_size;
4 SET @session_sql_big_selects = @@SESSION.sql_big_selects;
5 CREATE TEMPORARY TABLE t1(a varchar(20) not null, b varchar(20));
6 CREATE TEMPORARY TABLE t2(a varchar(20) null, b varchar(20));
7 INSERT INTO t1 VALUES('aa','bb');
8 INSERT INTO t1 VALUES('aa1','bb');
9 INSERT INTO t1 VALUES('aa2','bb');
10 INSERT INTO t1 VALUES('aa3','bb');
11 INSERT INTO t1 VALUES('aa4','bb');
12 INSERT INTO t2 VALUES('aa','bb');
13 INSERT INTO t2 VALUES('aa1','bb');
14 INSERT INTO t2 VALUES('aa2','bb');
15 INSERT INTO t2 VALUES('aa3','bb');
16 INSERT INTO t2 VALUES('aa4','bb');
17 '#--------------------FN_DYNVARS_161_01-------------------------#'
18 SET SESSION sql_max_join_size=9;
19 Warnings:
20 Warning 1287 '@@sql_max_join_size' is deprecated and will be removed in a future release. Please use '@@max_join_size' instead
21 SELECT * FROM t1 INNER JOIN t2 ON t1.a = t2.a;
22 ERROR 42000: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay
23 Expected error The SELECT would examine more than MAX_JOIN_SIZE rows.
24 '#--------------------FN_DYNVARS_161_02-------------------------#'
25 SET SESSION SQL_BIG_SELECTS = 1;
26 SELECT * FROM t1 INNER JOIN t2 ON t1.a = t2.a;
27 a b a b
28 aa bb aa bb
29 aa1 bb aa1 bb
30 aa2 bb aa2 bb
31 aa3 bb aa3 bb
32 aa4 bb aa4 bb
33 This should work
34 SET SESSION sql_max_join_size=DEFAULT;
35 Warnings:
36 Warning 1287 '@@sql_max_join_size' is deprecated and will be removed in a future release. Please use '@@max_join_size' instead
37 DELETE FROM t2 WHERE a = 'aa4';
38 SELECT * FROM t1 INNER JOIN t2 ON t1.a = t2.a;
39 a b a b
40 aa bb aa bb
41 aa1 bb aa1 bb
42 aa2 bb aa2 bb
43 aa3 bb aa3 bb
44 This should work
45 '#----------------------------FN_DYNVARS_136_05-------------------------#'
46 SET GLOBAL sql_max_join_size = 4;
47 Warnings:
48 Warning 1287 '@@sql_max_join_size' is deprecated and will be removed in a future release. Please use '@@max_join_size' instead
49 ** Connecting con_int1 using root **
50 ** Connection con_int1 **
51 SELECT @@SESSION.sql_max_join_size;
52 @@SESSION.sql_max_join_size
53 4
54 4 Expected
55 SET SESSION sql_max_join_size = 2;
56 Warnings:
57 Warning 1287 '@@sql_max_join_size' is deprecated and will be removed in a future release. Please use '@@max_join_size' instead
58 ** Connecting con_int2 using root **
59 ** Connection con_int2 **
60 SELECT @@SESSION.sql_max_join_size;
61 @@SESSION.sql_max_join_size
62 4
63 4 Expected
64 SET SESSION sql_max_join_size = 10;
65 Warnings:
66 Warning 1287 '@@sql_max_join_size' is deprecated and will be removed in a future release. Please use '@@max_join_size' instead
67 ** Connection con_int2 **
68 SELECT @@SESSION.sql_max_join_size;
69 @@SESSION.sql_max_join_size
70 10
71 10 Expected
72 ** Connection con_int1 **
73 SELECT @@SESSION.sql_max_join_size;
74 @@SESSION.sql_max_join_size
75 2
76 2 Expected
77 SELECT @@GLOBAL.sql_max_join_size;
78 @@GLOBAL.sql_max_join_size
79 4
80 4 Expected
81 ** Connection default **
82 Disconnecting Connections con_int1, con_int2
83 SET @@SESSION.sql_max_join_size = @session_max_join_size;
84 Warnings:
85 Warning 1287 '@@sql_max_join_size' is deprecated and will be removed in a future release. Please use '@@max_join_size' instead
86 SET @@GLOBAL.sql_max_join_size = @global_max_join_size ;
87 Warnings:
88 Warning 1287 '@@sql_max_join_size' is deprecated and will be removed in a future release. Please use '@@max_join_size' instead
89 SET @@SESSION.sql_big_selects = @session_sql_big_selects;
90 DROP TABLE t1;
91 DROP TABLE t2;