Debian Codegraph @

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

raw
1 ** Setup **
2
3 SET @session_sql_big_selects = @@SESSION.sql_big_selects;
4 SET @session_max_join_size = @@SESSION.max_join_size;
5 SET @global_max_join_size = @@GLOBAL.max_join_size;
6 SET MAX_JOIN_SIZE=21;
7 CREATE TEMPORARY TABLE t1(a varchar(20) not null, b varchar(20));
8 CREATE TEMPORARY TABLE t2(a varchar(20) null, b varchar(20));
9 INSERT INTO t1 VALUES('aa','bb');
10 INSERT INTO t1 VALUES('aa1','bb');
11 INSERT INTO t1 VALUES('aa2','bb');
12 INSERT INTO t1 VALUES('aa3','bb');
13 INSERT INTO t1 VALUES('aa4','bb');
14 INSERT INTO t2 VALUES('aa','bb');
15 INSERT INTO t2 VALUES('aa1','bb');
16 INSERT INTO t2 VALUES('aa2','bb');
17 INSERT INTO t2 VALUES('aa3','bb');
18 INSERT INTO t2 VALUES('aa4','bb');
19 '#--------------------FN_DYNVARS_154_01-------------------------#'
20 Expected error "Too big select"
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_154_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_BIG_SELECTS = 0;
35 DELETE FROM t2 WHERE a = 'aa4';
36 SELECT * FROM t1 INNER JOIN t2 ON t1.a = t2.a;
37 a b a b
38 aa bb aa bb
39 aa1 bb aa1 bb
40 aa2 bb aa2 bb
41 aa3 bb aa3 bb
42 This should work
43 '#--------------------FN_DYNVARS_154_03-------------------------#'
44 connect con_int1,localhost,root,,;
45 connection con_int1;
46 SELECT @@SESSION.sql_big_selects;
47 @@SESSION.sql_big_selects
48 1
49 1 Expected
50 SET SESSION sql_big_selects = 0;
51 connect con_int2,localhost,root,,;
52 connection con_int2;
53 SELECT @@SESSION.sql_big_selects;
54 @@SESSION.sql_big_selects
55 1
56 1 Expected
57 SET SESSION sql_big_selects = 1;
58 connection con_int1;
59 SELECT @@SESSION.sql_big_selects;
60 @@SESSION.sql_big_selects
61 0
62 0 Expected
63 connection con_int2;
64 SELECT @@SESSION.sql_big_selects;
65 @@SESSION.sql_big_selects
66 1
67 1 Expected
68 connection default;
69 disconnect con_int1;
70 disconnect con_int2;
71 SET @@SESSION.sql_big_selects = @session_sql_big_selects;
72 SET @@SESSION.max_join_size = @session_max_join_size;
73 SET @@GLOBAL.max_join_size = @global_max_join_size;
74 DROP TABLE t1;
75 DROP TABLE t2;