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=9;
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 ANALYZE TABLE t1, t2;
20 Table Op Msg_type Msg_text
21 test.t1 analyze status OK
22 test.t2 analyze status OK
23 '#--------------------FN_DYNVARS_154_01-------------------------#'
24 Expected error "Too big select"
25 SELECT * FROM t1 INNER JOIN t2 ON t1.a = t2.a;
26 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
27 Expected error The SELECT would examine more than MAX_JOIN_SIZE rows.
28 '#--------------------FN_DYNVARS_154_02-------------------------#'
29 SET SESSION SQL_BIG_SELECTS = 1;
30 SELECT * FROM t1 INNER JOIN t2 ON t1.a = t2.a;
31 a b a b
32 aa bb aa bb
33 aa1 bb aa1 bb
34 aa2 bb aa2 bb
35 aa3 bb aa3 bb
36 aa4 bb aa4 bb
37 This should work
38 SET SESSION SQL_BIG_SELECTS = 0;
39 DELETE FROM t2 WHERE a = 'aa4';
40 ANALYZE TABLE t1, t2;
41 Table Op Msg_type Msg_text
42 test.t1 analyze status Table is already up to date
43 test.t2 analyze status Table is already up to date
44 SELECT * FROM t1 INNER JOIN t2 ON t1.a = t2.a;
45 a b a b
46 aa bb aa bb
47 aa1 bb aa1 bb
48 aa2 bb aa2 bb
49 aa3 bb aa3 bb
50 This should work
51 '#--------------------FN_DYNVARS_154_03-------------------------#'
52 ** Connecting con_int1 using root **
53 ** Connection con_int1 **
54 SELECT @@SESSION.sql_big_selects;
55 @@SESSION.sql_big_selects
56 1
57 1 Expected
58 SET SESSION sql_big_selects = 0;
59 ** Connecting con_int2 using root **
60 ** Connection con_int2 **
61 SELECT @@SESSION.sql_big_selects;
62 @@SESSION.sql_big_selects
63 1
64 1 Expected
65 SET SESSION sql_big_selects = 1;
66 ** Connection con_int1 **
67 SELECT @@SESSION.sql_big_selects;
68 @@SESSION.sql_big_selects
69 0
70 0 Expected
71 ** Connection con_int2 **
72 SELECT @@SESSION.sql_big_selects;
73 @@SESSION.sql_big_selects
74 1
75 1 Expected
76 ** Connection default **
77 Disconnecting Connections con_int1, con_int2
78 SET @@SESSION.sql_big_selects = @session_sql_big_selects;
79 SET @@SESSION.max_join_size = @session_max_join_size;
80 SET @@GLOBAL.max_join_size = @global_max_join_size;
81 DROP TABLE t1;
82 DROP TABLE t2;