Debian Codegraph @

mysql-test/suite/x/r/insert_table_bad_numcolumns.result

raw
1 create schema xtest default charset='utf8mb4';
2 RUN use xtest
3
4 0 rows affected
5 RUN create table mytable (i int NOT NULL, ui int unsigned, vc varchar(100), f float, d double, dt datetime, ts timestamp(5), j json)
6
7 0 rows affected
8 send Mysqlx.Crud.Insert {
9 collection {
10 name: "mytable"
11 schema: "xtest"
12 }
13 data_model: TABLE
14 projection {
15 name: "i"
16 }
17 projection {
18 name: "ui"
19 }
20 projection {
21 name: "vc"
22 }
23 projection {
24 name: "f"
25 }
26 projection {
27 name: "d"
28 }
29 projection {
30 name: "dt"
31 }
32 projection {
33 name: "ts"
34 }
35 projection {
36 name: "j"
37 }
38 row {
39 field {
40 type: LITERAL
41 literal {
42 type: V_SINT
43 v_signed_int: -100
44 }
45 }
46 field {
47 type: LITERAL
48 literal {
49 type: V_UINT
50 v_unsigned_int: 100
51 }
52 }
53 field {
54 type: LITERAL
55 literal {
56 type: V_STRING
57 v_string {
58 value: ""
59 }
60 }
61 }
62 field {
63 type: LITERAL
64 literal {
65 type: V_FLOAT
66 v_float: 0.333333
67 }
68 }
69 field {
70 type: LITERAL
71 literal {
72 type: V_DOUBLE
73 v_double: 0.333333333333
74 }
75 }
76 field {
77 type: LITERAL
78 literal {
79 type: V_STRING
80 v_string {
81 value: "2015-05-05 1:20:30"
82 }
83 }
84 }
85 field {
86 type: LITERAL
87 literal {
88 type: V_STRING
89 v_string {
90 value: "2015-06-06 03:10:20.12345"
91 }
92 }
93 }
94 field {
95 type: LITERAL
96 literal {
97 type: V_STRING
98 v_string {
99 value: "{\"name\":\"Me\"}"
100 }
101 }
102 }
103 field {
104 type: LITERAL
105 literal {
106 type: V_SINT
107 v_signed_int: 1234
108 }
109 }
110 }
111 }
112
113 Mysqlx.Error {
114 severity: ERROR
115 code: 5014
116 msg: "Wrong number of fields in row being inserted"
117 sql_state: "HY000"
118 }
119
120 send Mysqlx.Crud.Insert {
121 collection {
122 name: "mytable"
123 schema: "xtest"
124 }
125 data_model: TABLE
126 projection {
127 name: "ui"
128 }
129 projection {
130 name: "vc"
131 }
132 projection {
133 name: "f"
134 }
135 projection {
136 name: "d"
137 }
138 projection {
139 name: "dt"
140 }
141 projection {
142 name: "ts"
143 }
144 projection {
145 name: "j"
146 }
147 row {
148 field {
149 type: LITERAL
150 literal {
151 type: V_SINT
152 v_signed_int: -100
153 }
154 }
155 field {
156 type: LITERAL
157 literal {
158 type: V_UINT
159 v_unsigned_int: 100
160 }
161 }
162 field {
163 type: LITERAL
164 literal {
165 type: V_STRING
166 v_string {
167 value: ""
168 }
169 }
170 }
171 field {
172 type: LITERAL
173 literal {
174 type: V_FLOAT
175 v_float: 0.333333
176 }
177 }
178 field {
179 type: LITERAL
180 literal {
181 type: V_DOUBLE
182 v_double: 0.333333333333
183 }
184 }
185 field {
186 type: LITERAL
187 literal {
188 type: V_STRING
189 v_string {
190 value: "2015-05-05 1:20:30"
191 }
192 }
193 }
194 field {
195 type: LITERAL
196 literal {
197 type: V_STRING
198 v_string {
199 value: "2015-06-06 03:10:20.12345"
200 }
201 }
202 }
203 field {
204 type: LITERAL
205 literal {
206 type: V_STRING
207 v_string {
208 value: "{\"name\":\"Me\"}"
209 }
210 }
211 }
212 }
213 }
214
215 Mysqlx.Error {
216 severity: ERROR
217 code: 5014
218 msg: "Wrong number of fields in row being inserted"
219 sql_state: "HY000"
220 }
221
222 send Mysqlx.Crud.Insert {
223 collection {
224 name: "mytable"
225 schema: "xtest"
226 }
227 data_model: TABLE
228 projection {
229 name: "i"
230 }
231 projection {
232 name: "ui"
233 }
234 projection {
235 name: "vc"
236 }
237 projection {
238 name: "f"
239 }
240 projection {
241 name: "d"
242 }
243 projection {
244 name: "dt"
245 }
246 projection {
247 name: "ts"
248 }
249 projection {
250 name: "j"
251 }
252 row {
253 field {
254 type: LITERAL
255 literal {
256 type: V_UINT
257 v_unsigned_int: 100
258 }
259 }
260 field {
261 type: LITERAL
262 literal {
263 type: V_STRING
264 v_string {
265 value: ""
266 }
267 }
268 }
269 field {
270 type: LITERAL
271 literal {
272 type: V_FLOAT
273 v_float: 0.333333
274 }
275 }
276 field {
277 type: LITERAL
278 literal {
279 type: V_DOUBLE
280 v_double: 0.333333333333
281 }
282 }
283 field {
284 type: LITERAL
285 literal {
286 type: V_STRING
287 v_string {
288 value: "2015-05-05 1:20:30"
289 }
290 }
291 }
292 field {
293 type: LITERAL
294 literal {
295 type: V_STRING
296 v_string {
297 value: "2015-06-06 03:10:20.12345"
298 }
299 }
300 }
301 field {
302 type: LITERAL
303 literal {
304 type: V_STRING
305 v_string {
306 value: "{\"name\":\"Me\"}"
307 }
308 }
309 }
310 }
311 }
312
313 Mysqlx.Error {
314 severity: ERROR
315 code: 5014
316 msg: "Wrong number of fields in row being inserted"
317 sql_state: "HY000"
318 }
319
320 send Mysqlx.Sql.StmtExecute {
321 stmt: "select count(*) from xtest.mytable"
322 }
323
324 Mysqlx.Resultset.ColumnMetaData {
325 type: SINT
326 name: "count(*)"
327 original_name: ""
328 table: ""
329 original_table: ""
330 schema: ""
331 catalog: "def"
332 length: 21
333 flags: 16
334 }
335
336 Mysqlx.Resultset.Row {
337 field: "\000"
338 }
339
340 Mysqlx.Resultset.FetchDone {
341 }
342
343 Mysqlx.Notice.Frame {
344 type: 3
345 scope: LOCAL
346 payload: "Mysqlx.Notice.SessionStateChanged { param: ROWS_AFFECTED\nvalue {\n type: V_UINT\n v_unsigned_int: 0\n}\n }"
347 }
348
349 Mysqlx.Sql.StmtExecuteOk {
350 }
351
352 Mysqlx.Ok {
353 msg: "bye!"
354 }
355 ok