Debian Codegraph @

mysql-test/suite/test_service_sql_api/r/test_sql_2_sessions.result

raw
1 # Creating tables
2 CREATE TABLE t_int (c1 TINYINT,
3 c2 SMALLINT,
4 c3 MEDIUMINT,
5 c4 INT,
6 c5 INTEGER,
7 c6 SMALLINT UNSIGNED,
8 c7 MEDIUMINT UNSIGNED,
9 c8 INT UNSIGNED,
10 c9 INTEGER);
11 CREATE TABLE t_bigint (c1 BIGINT,
12 c2 BIGINT UNSIGNED);
13 CREATE TABLE t_real (c1 REAL UNSIGNED,
14 c2 DOUBLE UNSIGNED,
15 c3 FLOAT UNSIGNED,
16 c4 DECIMAL UNSIGNED,
17 c5 NUMERIC UNSIGNED,
18 c6 DOUBLE,
19 c7 FLOAT,
20 c8 DECIMAL,
21 c9 NUMERIC);
22 Warnings:
23 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
24 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
25 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
26 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
27 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
28 CREATE TABLE t_date (c1 DATE,
29 c2 TIME,
30 c3 TIMESTAMP,
31 c4 DATETIME,
32 c5 YEAR);
33 CREATE TABLE t_char (c1 CHAR(32),
34 c2 VARCHAR(128) BINARY,
35 c3 VARCHAR(128),
36 c4 BINARY(128),
37 c5 VARBINARY(2048));
38 Warnings:
39 Warning 1287 'BINARY as attribute of a type' is deprecated and will be removed in a future release. Please use a CHARACTER SET clause with _bin collation instead
40 CREATE TABLE t_lob (c1 TINYBLOB,
41 c2 BLOB,
42 c3 MEDIUMBLOB,
43 c4 LONGBLOB,
44 c5 TINYTEXT,
45 c6 TEXT,
46 c7 MEDIUMTEXT,
47 c8 LONGTEXT,
48 c9 TINYTEXT BINARY,
49 c10 TEXT BINARY,
50 c11 MEDIUMTEXT BINARY,
51 c12 LONGTEXT BINARY);
52 Warnings:
53 Warning 1287 'BINARY as attribute of a type' is deprecated and will be removed in a future release. Please use a CHARACTER SET clause with _bin collation instead
54 Warning 1287 'BINARY as attribute of a type' is deprecated and will be removed in a future release. Please use a CHARACTER SET clause with _bin collation instead
55 Warning 1287 'BINARY as attribute of a type' is deprecated and will be removed in a future release. Please use a CHARACTER SET clause with _bin collation instead
56 Warning 1287 'BINARY as attribute of a type' is deprecated and will be removed in a future release. Please use a CHARACTER SET clause with _bin collation instead
57 CREATE TABLE t_spec (c1 BIT(16),
58 c2 ENUM('v1','v2','v3'),
59 c3 SET('v1','v2','v3'));
60 # Inserting values into the tables
61 INSERT INTO t_int VALUES (91,92,93,94,95,96,97,98,99),(81,82,83,84,85,86,87,88,89);
62 INSERT INTO t_bigint VALUES (91,92),(81,82);
63 INSERT INTO t_real VALUES (8.51,8.52,8.53,8.54,8.55,8.56,8.57,8.58,8.59);
64 Warnings:
65 Note 1265 Data truncated for column 'c4' at row 1
66 Note 1265 Data truncated for column 'c5' at row 1
67 Note 1265 Data truncated for column 'c8' at row 1
68 Note 1265 Data truncated for column 'c9' at row 1
69 INSERT INTO t_real VALUES (9.51,9.52,9.53,9.54,9.55,9.56,9.57,9.58,9.59);
70 Warnings:
71 Note 1265 Data truncated for column 'c4' at row 1
72 Note 1265 Data truncated for column 'c5' at row 1
73 Note 1265 Data truncated for column 'c8' at row 1
74 Note 1265 Data truncated for column 'c9' at row 1
75 INSERT INTO t_date VALUES ('2015-07-06','20:15','2015-12-31 14:59:48','2014-11-30 13:58:47','2015');
76 INSERT INTO t_date VALUES ('2015-07-07','20:17','2013-12-31 17:59:47','2012-10-31 15:57:47','2010');
77 INSERT INTO t_char VALUES ('char-text','varchar-binary-text\nnext line','varchar-text','binary-text\nnext line','varbinary-text\nline 1\nline 2');
78 INSERT INTO t_char VALUES ('2char-text','2varchar-binary-text\nnext line','2varchar-text','2binary-text\nnext line','2varbinary-text\nline 1\nline 2');
79 INSERT INTO t_lob VALUES ('tinyblob-text readable','blob-text readable','mediumblob-text readable',
80 'longblob-text readable','tinytext','text','mediumtext','longtext',
81 'tinytext-binary\nnext line','text-binary\nnext line',
82 'mediumtext-binary\nnext line','longtext-binary \nnext line');
83 INSERT INTO t_lob VALUES ('2tinyblob-text readable','2blob-text readable','2mediumblob-text readable',
84 '2longblob-text readable','2tinytext','2text','2mediumtext','2longtext',
85 '2tinytext-binary\nnext line','2text-binary\nnext line',
86 '2mediumtext-binary\nnext line','2longtext-binary \nnext line');
87 INSERT INTO t_spec VALUES ( b'111', 'v1', 'v1');
88 SELECT * FROM t_int ;
89 c1 c2 c3 c4 c5 c6 c7 c8 c9
90 91 92 93 94 95 96 97 98 99
91 81 82 83 84 85 86 87 88 89
92 SELECT * FROM t_bigint ;
93 c1 c2
94 91 92
95 81 82
96 SELECT * FROM t_real;
97 c1 c2 c3 c4 c5 c6 c7 c8 c9
98 8.51 8.52 8.53 9 9 8.56 8.57 9 9
99 9.51 9.52 9.53 10 10 9.56 9.57 10 10
100 SELECT * FROM t_date;
101 c1 c2 c3 c4 c5
102 2015-07-06 20:15:00 2015-12-31 14:59:48 2014-11-30 13:58:47 2015
103 2015-07-07 20:17:00 2013-12-31 17:59:47 2012-10-31 15:57:47 2010
104 SELECT c3 FROM t_char;
105 c3
106 varchar-text
107 2varchar-text
108 SELECT c5,c6,c7,c8 FROM t_lob ;
109 c5 c6 c7 c8
110 tinytext text mediumtext longtext
111 2tinytext 2text 2mediumtext 2longtext
112 SELECT * FROM t_spec;
113 c1 c2 c3
114  v1 v1
115 ##########################################
116 # Run plugin
117 ##########################################
118 INSTALL PLUGIN test_sql_2_sessions SONAME 'TEST_SQL_2_SESSIONS';
119 ##########################################
120 # Stop plugin
121 ##########################################
122 UNINSTALL PLUGIN test_sql_2_sessions;
123 ##########################################
124 # Plugin log
125 ##########################################
126 ========================================================================
127 Test in a server thread
128 Opening Session 1
129 ========================================================================
130 Session 1 :
131 ========================================================================
132 SELECT * FROM test.t_int
133 num_cols: 9
134 nb rows: 2
135 c1 c2 c3 c4 c5 c6 c7 c8 c9
136 TINY(1) SHORT(2) INT24(9) LONG(3) LONG(3) SHORT(2) INT24(9) LONG(3) LONG(3)
137 () () () () () (UNSIGNED ) (UNSIGNED ) (UNSIGNED ) ()
138 Write a string
139 91 92 93 94 95 96 97 98 99
140 81 82 83 84 85 86 87 88 89
141
142 affected rows : 0
143 server status : 34
144 warn count : 0
145
146 Opening Session 2
147 ========================================================================
148 Session 1 :
149 ========================================================================
150 SELECT * FROM test.t_bigint
151 num_cols: 2
152 nb rows: 2
153 c1 c2
154 LONGLONG(8) LONGLONG(8)
155 () (UNSIGNED )
156 Write a string
157 91 92
158 81 82
159
160 affected rows : 0
161 server status : 34
162 warn count : 0
163 ========================================================================
164 Session 2 :
165 ========================================================================
166 SELECT * FROM test.t_real
167 num_cols: 9
168 nb rows: 2
169 c1 c2 c3 c4 c5 c6 c7 c8 c9
170 DOUBLE(5) DOUBLE(5) FLOAT(4) NEWDECIMAL(246) NEWDECIMAL(246) DOUBLE(5) FLOAT(4) NEWDECIMAL(246) NEWDECIMAL(246)
171 (UNSIGNED ) (UNSIGNED ) (UNSIGNED ) (UNSIGNED ) (UNSIGNED ) () () () ()
172 Write a string
173 8.51 8.52 8.53 9 9 8.56 8.57 9 9
174 9.51 9.52 9.53 10 10 9.56 9.57 10 10
175
176 affected rows : 0
177 server status : 34
178 warn count : 0
179
180 Close Session 1
181 ========================================================================
182 Session 2 :
183 ========================================================================
184 SELECT * FROM test.t_date
185 num_cols: 5
186 nb rows: 2
187 c1 c2 c3 c4 c5
188 DATE(10) TIME(11) TIMESTAMP(7) DATETIME(12) YEAR(13)
189 (BINARY ) (BINARY ) (BINARY ) (BINARY ) (UNSIGNED ZEROFILL )
190 Write a string
191 2015-07-06 20:15:00 2015-12-31 14:59:48 2014-11-30 13:58:47 2015
192 2015-07-07 20:17:00 2013-12-31 17:59:47 2012-10-31 15:57:47 2010
193
194 affected rows : 0
195 server status : 34
196 warn count : 0
197 ========================================================================
198 Session 1 :
199 ========================================================================
200 SELECT * FROM test.t_date
201
202 Close Session 2
203 Follows threaded run
204 ========================================================================
205 init thread
206 Opening Session 1
207 ========================================================================
208 Session 1 :
209 ========================================================================
210 SELECT * FROM test.t_int
211 num_cols: 9
212 nb rows: 2
213 c1 c2 c3 c4 c5 c6 c7 c8 c9
214 TINY(1) SHORT(2) INT24(9) LONG(3) LONG(3) SHORT(2) INT24(9) LONG(3) LONG(3)
215 () () () () () (UNSIGNED ) (UNSIGNED ) (UNSIGNED ) ()
216 Write a string
217 91 92 93 94 95 96 97 98 99
218 81 82 83 84 85 86 87 88 89
219
220 affected rows : 0
221 server status : 34
222 warn count : 0
223
224 Opening Session 2
225 ========================================================================
226 Session 1 :
227 ========================================================================
228 SELECT * FROM test.t_bigint
229 num_cols: 2
230 nb rows: 2
231 c1 c2
232 LONGLONG(8) LONGLONG(8)
233 () (UNSIGNED )
234 Write a string
235 91 92
236 81 82
237
238 affected rows : 0
239 server status : 34
240 warn count : 0
241 ========================================================================
242 Session 2 :
243 ========================================================================
244 SELECT * FROM test.t_real
245 num_cols: 9
246 nb rows: 2
247 c1 c2 c3 c4 c5 c6 c7 c8 c9
248 DOUBLE(5) DOUBLE(5) FLOAT(4) NEWDECIMAL(246) NEWDECIMAL(246) DOUBLE(5) FLOAT(4) NEWDECIMAL(246) NEWDECIMAL(246)
249 (UNSIGNED ) (UNSIGNED ) (UNSIGNED ) (UNSIGNED ) (UNSIGNED ) () () () ()
250 Write a string
251 8.51 8.52 8.53 9 9 8.56 8.57 9 9
252 9.51 9.52 9.53 10 10 9.56 9.57 10 10
253
254 affected rows : 0
255 server status : 34
256 warn count : 0
257
258 Close Session 1
259 ========================================================================
260 Session 2 :
261 ========================================================================
262 SELECT * FROM test.t_date
263 num_cols: 5
264 nb rows: 2
265 c1 c2 c3 c4 c5
266 DATE(10) TIME(11) TIMESTAMP(7) DATETIME(12) YEAR(13)
267 (BINARY ) (BINARY ) (BINARY ) (BINARY ) (UNSIGNED ZEROFILL )
268 Write a string
269 2015-07-06 20:15:00 2015-12-31 14:59:48 2014-11-30 13:58:47 2015
270 2015-07-07 20:17:00 2013-12-31 17:59:47 2012-10-31 15:57:47 2010
271
272 affected rows : 0
273 server status : 34
274 warn count : 0
275 ========================================================================
276 Session 1 :
277 ========================================================================
278 SELECT * FROM test.t_date
279
280 Close Session 2
281 deinit thread
282 ##########################################
283 # Cleanup
284 ##########################################
285 # Dropping the created tables
286 DROP TABLE IF EXISTS t_int;
287 DROP TABLE IF EXISTS t_bigint;
288 DROP TABLE IF EXISTS t_real;
289 DROP TABLE IF EXISTS t_date;
290 DROP TABLE IF EXISTS t_char;
291 DROP TABLE IF EXISTS t_lob;
292 DROP TABLE IF EXISTS t_spec;