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