1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
|
** Setup **
SET @session_sql_select_limit = @@SESSION.sql_select_limit;
SET @global_sql_select_limit = @@GLOBAL.sql_select_limit;
CREATE TEMPORARY TABLE t1(a int PRIMARY KEY, b varchar(20));
CREATE TEMPORARY TABLE t2(a int PRIMARY KEY, b varchar(20));
CREATE TEMPORARY TABLE t3(a int PRIMARY KEY, b varchar(20));
INSERT INTO t1 VALUES(1, 'val1');
INSERT INTO t1 VALUES(2, 'val2');
INSERT INTO t1 VALUES(3, 'val3');
INSERT INTO t1 VALUES(4, 'val4');
INSERT INTO t1 VALUES(5, 'val5');
INSERT INTO t1 VALUES(6, 'val6');
INSERT INTO t1 VALUES(7, 'val7');
INSERT INTO t1 VALUES(8, 'val8');
INSERT INTO t1 VALUES(9, 'val9');
INSERT INTO t2 VALUES(5, 'val5');
INSERT INTO t2 VALUES(6, 'val6');
INSERT INTO t2 VALUES(7, 'val7');
INSERT INTO t2 VALUES(8, 'val8');
INSERT INTO t2 VALUES(9, 'val9');
'#-----------------------------FN_DYNVARS_165_01-----------------#'
Value DEFAULT
SET SESSION sql_select_limit = DEFAULT;
affected rows: 0
SELECT * FROM t1;
a b
1 val1
2 val2
3 val3
4 val4
5 val5
6 val6
7 val7
8 val8
9 val9
affected rows: 9
Expecting affected rows: 9
SELECT * FROM t1 INNER JOIN t2 ON t1.a = t2.a;
a b a b
5 val5 5 val5
6 val6 6 val6
7 val7 7 val7
8 val8 8 val8
9 val9 9 val9
affected rows: 5
Expecting affected rows: 5
'#-----------------------------FN_DYNVARS_165_02---------------#'
SET SESSION sql_select_limit = 2;
affected rows: 0
SELECT * FROM t1;
a b
1 val1
2 val2
affected rows: 2
Expecting affected rows: 2
SELECT * FROM t1 INNER JOIN t2 ON t1.a = t2.a;
a b a b
5 val5 5 val5
6 val6 6 val6
affected rows: 2
Expecting affected rows: 2
'#-----------------------------FN_DYNVARS_165_03---------------#'
SET SESSION sql_select_limit = 2;
affected rows: 0
SELECT * FROM t1 LIMIT 4;
a b
1 val1
2 val2
3 val3
4 val4
affected rows: 4
Expecting affected rows: 4
SELECT * FROM t1 INNER JOIN t2 ON t1.a = t2.a LIMIT 3;
a b a b
5 val5 5 val5
6 val6 6 val6
7 val7 7 val7
affected rows: 3
Expecting affected rows: 3
'#-----------------------------FN_DYNVARS_165_04----------------#'
SET SESSION sql_select_limit = 2;
affected rows: 0
CREATE PROCEDURE TestProc()
BEGIN
SELECT * FROM t1;
END|
affected rows: 0
call TestProc();
a b
1 val1
2 val2
3 val3
4 val4
5 val5
6 val6
7 val7
8 val8
9 val9
affected rows: 9
affected rows: 0
Expecting affected rows: 9
DROP PROCEDURE TestProc;
affected rows: 0
CREATE PROCEDURE TestProc()
BEGIN
SELECT * FROM t1 INNER JOIN t2 ON t1.a = t2.a;
END|
affected rows: 0
call TestProc();
a b a b
5 val5 5 val5
6 val6 6 val6
7 val7 7 val7
8 val8 8 val8
9 val9 9 val9
affected rows: 5
affected rows: 0
Expecting affected rows: 5
DROP PROCEDURE TestProc;
affected rows: 0
'#-----------------------------FN_DYNVARS_165_05-----------------#'
SET SESSION sql_select_limit = 2;
affected rows: 0
CREATE TEMPORARY TABLE t4(a int PRIMARY KEY, b varchar(20)) SELECT * FROM t2;
affected rows: 5
info: Records: 5 Duplicates: 0 Warnings: 0
Expecting Records: 5
INSERT INTO t3 SELECT * FROM t1;
affected rows: 9
info: Records: 9 Duplicates: 0 Warnings: 0
Expecting Records: 9
'#-----------------------------FN_DYNVARS_165_06---------------------#'
SET GLOBAL sql_select_limit = 2;
** Connecting con_int2 using root **
** Connection con_int1 **
SELECT @@SESSION.sql_select_limit;
@@SESSION.sql_select_limit
2
2 Expected
SET SESSION sql_select_limit = 10;
** Connecting con_int2 using root **
** Connection con_int2 **
SELECT @@SESSION.sql_select_limit;
@@SESSION.sql_select_limit
2
2 Expected
SET SESSION sql_select_limit = 12;
** Connection con_int2 **
SELECT @@SESSION.sql_select_limit;
@@SESSION.sql_select_limit
12
12 Expected
** Connection con_int1 **
SELECT @@SESSION.sql_select_limit;
@@SESSION.sql_select_limit
10
10 Expected
SELECT @@GLOBAL.sql_select_limit;
@@GLOBAL.sql_select_limit
2
2 Expected
** Connection default **
Disconnecting Connections con_int1, con_int2
SET @@SESSION.sql_select_limit = @session_sql_select_limit;
SET @@GLOBAL.sql_select_limit = @global_sql_select_limit;
DROP TABLE t1;
DROP TABLE t2;
DROP TABLE t3;
DROP TABLE t4;
|
