Debian Codegraph @

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

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