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