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."); 4call mtr.add_suppression("Error parsing message of type 12: args"); 5call mtr.add_suppression("Error handling message: args"); 6call mtr.add_suppression("InnoDB: Compute virtual column values failed"); 7RUN DROP DATABASE IF EXISTS xplugintest 8 90 rows affected 10RUN DROP DATABASE IF EXISTS xplugintest_1 11 120 rows affected 13RUN CREATE DATABASE xplugintest 14 151 rows affected 16RUN CREATE DATABASE xplugintest_1 17 181 rows affected 19RUN USE xplugintest 20 210 rows affected 22RUN CREATE TABLE table1 ( _id INT , doc JSON ) 23 240 rows affected 25send Mysqlx.Sql.StmtExecute { 26 stmt: "create_collection" 27 args { 28 type: SCALAR 29 scalar { 30 type: V_STRING 31 v_string { 32 value: "xplugintest" 33 } 34 } 35 } 36 args { 37 type: SCALAR 38 scalar { 39 type: V_STRING 40 v_string { 41 value: "table2" 42 } 43 } 44 } 45 namespace: "xplugin" 46} 47 48 49command ok 50Namespace 'xplugin' is deprecated, please use 'mysqlx' instead 51send Mysqlx.Sql.StmtExecute { 52 stmt: "create_collection_index" 53 args { 54 type: SCALAR 55 scalar { 56 type: V_STRING 57 v_string { 58 value: "xplugintest" 59 } 60 } 61 } 62 args { 63 type: SCALAR 64 scalar { 65 type: V_STRING 66 v_string { 67 value: "table2" 68 } 69 } 70 } 71 args { 72 type: SCALAR 73 scalar { 74 type: V_STRING 75 v_string { 76 value: "col1_index" 77 } 78 } 79 } 80 args { 81 type: SCALAR 82 scalar { 83 type: V_BOOL 84 v_bool: true 85 } 86 } 87 args { 88 type: SCALAR 89 scalar { 90 type: V_STRING 91 v_string { 92 value: "$.col1" 93 } 94 } 95 } 96 args { 97 type: SCALAR 98 scalar { 99 type: V_STRING 100 v_string { 101 value: "TEXT(13)" 102 } 103 } 104 } 105 args { 106 type: SCALAR 107 scalar { 108 type: V_BOOL 109 v_bool: true 110 } 111 } 112 namespace: "xplugin" 113} 114 115Mysqlx.Sql.StmtExecuteOk { 116} 117 118RUN INSERT INTO xplugintest.table2(doc) VALUES('{"col1":"01234567890123456789","_id":0}') 119 1201 rows affected 121send Mysqlx.Sql.StmtExecute { 122 stmt: "create_collection_index" 123 args { 124 type: SCALAR 125 scalar { 126 type: V_STRING 127 v_string { 128 value: "xplugintest" 129 } 130 } 131 } 132 args { 133 type: SCALAR 134 scalar { 135 type: V_STRING 136 v_string { 137 value: "table2" 138 } 139 } 140 } 141 args { 142 type: SCALAR 143 scalar { 144 type: V_STRING 145 v_string { 146 value: "col2_index" 147 } 148 } 149 } 150 args { 151 type: SCALAR 152 scalar { 153 type: V_BOOL 154 v_bool: false 155 } 156 } 157 args { 158 type: SCALAR 159 scalar { 160 type: V_STRING 161 v_string { 162 value: "$.col2" 163 } 164 } 165 } 166 args { 167 type: SCALAR 168 scalar { 169 type: V_STRING 170 v_string { 171 value: "INT" 172 } 173 } 174 } 175 args { 176 type: SCALAR 177 scalar { 178 type: V_BOOL 179 v_bool: false 180 } 181 } 182 namespace: "xplugin" 183} 184 185Mysqlx.Sql.StmtExecuteOk { 186} 187 188RUN SHOW CREATE TABLE xplugintest.table2 189Table Create Table 190table2 CREATE TABLE `table2` ( 191 `doc` json DEFAULT NULL, 192 `_id` varchar(32) GENERATED ALWAYS AS (json_unquote(json_extract(`doc`,'$._id'))) STORED NOT NULL, 193 `$ix_t13_r_5E11219941D8F091BF6F252A48E0EEAA9D734FF9` text GENERATED ALWAYS AS (json_unquote(json_extract(`doc`,'$.col1'))) VIRTUAL NOT NULL, 194 `$ix_i_1C70785A292B9A2762EFA186DFCFB4F03C660E7F` int(11) GENERATED ALWAYS AS (json_extract(`doc`,'$.col2')) VIRTUAL, 195 PRIMARY KEY (`_id`), 196 UNIQUE KEY `col1_index` (`$ix_t13_r_5E11219941D8F091BF6F252A48E0EEAA9D734FF9`(13)), 197 KEY `col2_index` (`$ix_i_1C70785A292B9A2762EFA186DFCFB4F03C660E7F`) 198) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 1990 rows affected 200RUN INSERT INTO xplugintest.table2(doc) VALUES('{"col1":"val1","col2":101,"_id":1}') 201 2021 rows affected 203RUN INSERT INTO xplugintest.table2(doc) VALUES('{"col1":"val1","col2":102,"_id":2}') 204While executing INSERT INTO xplugintest.table2(doc) VALUES('{"col1":"val1","col2":102,"_id":2}'): 205Got expected error: Duplicate entry 'val1' for key 'col1_index' (code 1062) 206RUN INSERT INTO xplugintest.table2(doc) VALUES('{"col2":103,"_id":3}') 207While executing INSERT INTO xplugintest.table2(doc) VALUES('{"col2":103,"_id":3}'): 208Got expected error: Column '$ix_t13_r_5E11219941D8F091BF6F252A48E0EEAA9D734FF9' cannot be null (code 1048) 209RUN SELECT * FROM xplugintest.table2 210doc _id $ix_t13_r_5E11219941D8F091BF6F252A48E0EEAA9D734FF9 $ix_i_1C70785A292B9A2762EFA186DFCFB4F03C660E7F 211{"_id": 0, "col1": "01234567890123456789"} 0 01234567890123456789 null 212{"_id": 1, "col1": "val1", "col2": 101} 1 val1 101 2130 rows affected 214RUN INSERT INTO xplugintest.table2(doc) VALUES('{"col1":"val4","col2":102,"_id":4}') 215 2161 rows affected 217RUN INSERT INTO xplugintest.table2(doc) VALUES('{"col1":"val5","_id":5}') 218 2191 rows affected 220RUN SELECT * FROM xplugintest.table2 221doc _id $ix_t13_r_5E11219941D8F091BF6F252A48E0EEAA9D734FF9 $ix_i_1C70785A292B9A2762EFA186DFCFB4F03C660E7F 222{"_id": 0, "col1": "01234567890123456789"} 0 01234567890123456789 null 223{"_id": 1, "col1": "val1", "col2": 101} 1 val1 101 224{"_id": 4, "col1": "val4", "col2": 102} 4 val4 102 225{"_id": 5, "col1": "val5"} 5 val5 null 2260 rows affected 227RUN SELECT _id,doc, CONCAT("Prefix",$ix_t13_r_5E11219941D8F091BF6F252A48E0EEAA9D734FF9) , $ix_i_1C70785A292B9A2762EFA186DFCFB4F03C660E7F 228 FROM xplugintest.table2 229_id doc CONCAT("Prefix",$ix_t13_r_5E11219941D8F091BF6F252A48E0EEAA9D734FF9) $ix_i_1C70785A292B9A2762EFA186DFCFB4F03C660E7F 2300 {"_id": 0, "col1": "01234567890123456789"} Prefix01234567890123456789 null 2311 {"_id": 1, "col1": "val1", "col2": 101} Prefixval1 101 2324 {"_id": 4, "col1": "val4", "col2": 102} Prefixval4 102 2335 {"_id": 5, "col1": "val5"} Prefixval5 null 2340 rows affected 235RUN INSERT INTO xplugintest.table2(doc) VALUES('{"col1":"val6","col2":"non_int_val","_id":6}') 236While executing INSERT INTO xplugintest.table2(doc) VALUES('{"col1":"val6","col2":"non_int_val","_id":6}'): 237Got expected error: Invalid JSON value for CAST to INTEGER from column json_extract at row 1 (code 3156) 238send Mysqlx.Sql.StmtExecute { 239 stmt: "create_collection_index" 240 args { 241 type: SCALAR 242 scalar { 243 type: V_STRING 244 v_string { 245 value: "xplugintest" 246 } 247 } 248 } 249 args { 250 type: SCALAR 251 scalar { 252 type: V_STRING 253 v_string { 254 value: "table2" 255 } 256 } 257 } 258 args { 259 type: SCALAR 260 scalar { 261 type: V_STRING 262 v_string { 263 value: "col2_index" 264 } 265 } 266 } 267 args { 268 type: SCALAR 269 scalar { 270 type: V_BOOL 271 v_bool: false 272 } 273 } 274 args { 275 type: SCALAR 276 scalar { 277 type: V_STRING 278 v_string { 279 value: "$.col3" 280 } 281 } 282 } 283 args { 284 type: SCALAR 285 scalar { 286 type: V_STRING 287 v_string { 288 value: "INT" 289 } 290 } 291 } 292 args { 293 type: SCALAR 294 scalar { 295 type: V_BOOL 296 v_bool: false 297 } 298 } 299 namespace: "xplugin" 300} 301 302Mysqlx.Error { 303 severity: ERROR 304 code: 1061 305 msg: "Duplicate key name \'col2_index\'" 306 sql_state: "42000" 307} 308 309RUN ALTER TABLE xplugintest.table2 ADD COLUMN $ix_t13_bf29f74d5ecec695774cb5b3f1ff979e7643bf36 TEXT 310 3110 rows affected 312Records: 0 Duplicates: 0 Warnings: 0 313send Mysqlx.Sql.StmtExecute { 314 stmt: "create_collection_index" 315 args { 316 type: SCALAR 317 scalar { 318 type: V_STRING 319 v_string { 320 value: "xplugintest" 321 } 322 } 323 } 324 args { 325 type: SCALAR 326 scalar { 327 type: V_STRING 328 v_string { 329 value: "table2" 330 } 331 } 332 } 333 args { 334 type: SCALAR 335 scalar { 336 type: V_STRING 337 v_string { 338 value: "col3_index" 339 } 340 } 341 } 342 args { 343 type: SCALAR 344 scalar { 345 type: V_BOOL 346 v_bool: false 347 } 348 } 349 args { 350 type: SCALAR 351 scalar { 352 type: V_STRING 353 v_string { 354 value: "$.col3" 355 } 356 } 357 } 358 args { 359 type: SCALAR 360 scalar { 361 type: V_STRING 362 v_string { 363 value: "TEXT(13)" 364 } 365 } 366 } 367 args { 368 type: SCALAR 369 scalar { 370 type: V_BOOL 371 v_bool: false 372 } 373 } 374 namespace: "xplugin" 375} 376 377Mysqlx.Sql.StmtExecuteOk { 378} 379 380send Mysqlx.Sql.StmtExecute { 381 stmt: "create_collection_index" 382 args { 383 type: SCALAR 384 scalar { 385 type: V_STRING 386 v_string { 387 value: "xplugintest" 388 } 389 } 390 } 391 args { 392 type: SCALAR 393 scalar { 394 type: V_STRING 395 v_string { 396 value: "table2" 397 } 398 } 399 } 400 args { 401 type: SCALAR 402 scalar { 403 type: V_STRING 404 v_string { 405 value: "_id_index" 406 } 407 } 408 } 409 args { 410 type: SCALAR 411 scalar { 412 type: V_BOOL 413 v_bool: false 414 } 415 } 416 args { 417 type: SCALAR 418 scalar { 419 type: V_STRING 420 v_string { 421 value: "$._id" 422 } 423 } 424 } 425 args { 426 type: SCALAR 427 scalar { 428 type: V_STRING 429 v_string { 430 value: "INT" 431 } 432 } 433 } 434 args { 435 type: SCALAR 436 scalar { 437 type: V_BOOL 438 v_bool: false 439 } 440 } 441 namespace: "xplugin" 442} 443 444Mysqlx.Sql.StmtExecuteOk { 445} 446 447send Mysqlx.Sql.StmtExecute { 448 stmt: "create_collection_index" 449 args { 450 type: SCALAR 451 scalar { 452 type: V_STRING 453 v_string { 454 value: "xplugintest" 455 } 456 } 457 } 458 args { 459 type: SCALAR 460 scalar { 461 type: V_STRING 462 v_string { 463 value: "table2" 464 } 465 } 466 } 467 args { 468 type: SCALAR 469 scalar { 470 type: V_STRING 471 v_string { 472 value: "col5_index" 473 } 474 } 475 } 476 args { 477 type: SCALAR 478 scalar { 479 type: V_BOOL 480 v_bool: false 481 } 482 } 483 args { 484 type: SCALAR 485 scalar { 486 type: V_STRING 487 v_string { 488 value: "$.....col5" 489 } 490 } 491 } 492 args { 493 type: SCALAR 494 scalar { 495 type: V_STRING 496 v_string { 497 value: "INT" 498 } 499 } 500 } 501 args { 502 type: SCALAR 503 scalar { 504 type: V_BOOL 505 v_bool: false 506 } 507 } 508 namespace: "xplugin" 509} 510 511Mysqlx.Error { 512 severity: ERROR 513 code: 3143 514 msg: "Invalid JSON path expression. The error is around character position 2." 515 sql_state: "42000" 516} 517 518RUN SHOW CREATE TABLE xplugintest.table2 519Table Create Table 520table2 CREATE TABLE `table2` ( 521 `doc` json DEFAULT NULL, 522 `_id` varchar(32) GENERATED ALWAYS AS (json_unquote(json_extract(`doc`,'$._id'))) STORED NOT NULL, 523 `$ix_t13_r_5E11219941D8F091BF6F252A48E0EEAA9D734FF9` text GENERATED ALWAYS AS (json_unquote(json_extract(`doc`,'$.col1'))) VIRTUAL NOT NULL, 524 `$ix_i_1C70785A292B9A2762EFA186DFCFB4F03C660E7F` int(11) GENERATED ALWAYS AS (json_extract(`doc`,'$.col2')) VIRTUAL, 525 `$ix_t13_bf29f74d5ecec695774cb5b3f1ff979e7643bf36` text, 526 `$ix_t13_8B49C928244561F5DACBE63B030ADA2983C76BFF` text GENERATED ALWAYS AS (json_unquote(json_extract(`doc`,'$.col3'))) VIRTUAL, 527 `$ix_i_ED8EA5BF0D44065A674B92033FC24920B41C5F42` int(11) GENERATED ALWAYS AS (json_extract(`doc`,'$._id')) VIRTUAL, 528 PRIMARY KEY (`_id`), 529 UNIQUE KEY `col1_index` (`$ix_t13_r_5E11219941D8F091BF6F252A48E0EEAA9D734FF9`(13)), 530 KEY `col2_index` (`$ix_i_1C70785A292B9A2762EFA186DFCFB4F03C660E7F`), 531 KEY `col3_index` (`$ix_t13_8B49C928244561F5DACBE63B030ADA2983C76BFF`(13)), 532 KEY `_id_index` (`$ix_i_ED8EA5BF0D44065A674B92033FC24920B41C5F42`) 533) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 5340 rows affected 535RUN ALTER TABLE xplugintest.table2 DROP INDEX `col1_index` 536 5370 rows affected 538Records: 0 Duplicates: 0 Warnings: 0 539RUN ALTER TABLE xplugintest.table2 DROP COLUMN `$ix_t13_r_5E11219941D8F091BF6F252A48E0EEAA9D734FF9` 540 5410 rows affected 542Records: 0 Duplicates: 0 Warnings: 0 543RUN SHOW CREATE TABLE xplugintest.table2 544Table Create Table 545table2 CREATE TABLE `table2` ( 546 `doc` json DEFAULT NULL, 547 `_id` varchar(32) GENERATED ALWAYS AS (json_unquote(json_extract(`doc`,'$._id'))) STORED NOT NULL, 548 `$ix_i_1C70785A292B9A2762EFA186DFCFB4F03C660E7F` int(11) GENERATED ALWAYS AS (json_extract(`doc`,'$.col2')) VIRTUAL, 549 `$ix_t13_bf29f74d5ecec695774cb5b3f1ff979e7643bf36` text, 550 `$ix_t13_8B49C928244561F5DACBE63B030ADA2983C76BFF` text GENERATED ALWAYS AS (json_unquote(json_extract(`doc`,'$.col3'))) VIRTUAL, 551 `$ix_i_ED8EA5BF0D44065A674B92033FC24920B41C5F42` int(11) GENERATED ALWAYS AS (json_extract(`doc`,'$._id')) VIRTUAL, 552 PRIMARY KEY (`_id`), 553 KEY `col2_index` (`$ix_i_1C70785A292B9A2762EFA186DFCFB4F03C660E7F`), 554 KEY `col3_index` (`$ix_t13_8B49C928244561F5DACBE63B030ADA2983C76BFF`(13)), 555 KEY `_id_index` (`$ix_i_ED8EA5BF0D44065A674B92033FC24920B41C5F42`) 556) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 5570 rows affected 558RUN SELECT * FROM xplugintest.table2 559doc _id $ix_i_1C70785A292B9A2762EFA186DFCFB4F03C660E7F $ix_t13_bf29f74d5ecec695774cb5b3f1ff979e7643bf36 $ix_t13_8B49C928244561F5DACBE63B030ADA2983C76BFF $ix_i_ED8EA5BF0D44065A674B92033FC24920B41C5F42 560{"_id": 0, "col1": "01234567890123456789"} 0 null null null 0 561{"_id": 1, "col1": "val1", "col2": 101} 1 101 null null 1 562{"_id": 4, "col1": "val4", "col2": 102} 4 102 null null 4 563{"_id": 5, "col1": "val5"} 5 null null null 5 5640 rows affected 565RUN ALTER TABLE xplugintest.table2 ADD COLUMN `$col1_ix_t13` text 566 GENERATED ALWAYS AS (LEFT(JSON_UNQUOTE(JSON_EXTRACT(doc, '$.col1')), 13)) STORED 567 5684 rows affected 569Records: 4 Duplicates: 0 Warnings: 0 570RUN SHOW CREATE TABLE xplugintest.table2 571Table Create Table 572table2 CREATE TABLE `table2` ( 573 `doc` json DEFAULT NULL, 574 `_id` varchar(32) GENERATED ALWAYS AS (json_unquote(json_extract(`doc`,'$._id'))) STORED NOT NULL, 575 `$ix_i_1C70785A292B9A2762EFA186DFCFB4F03C660E7F` int(11) GENERATED ALWAYS AS (json_extract(`doc`,'$.col2')) VIRTUAL, 576 `$ix_t13_bf29f74d5ecec695774cb5b3f1ff979e7643bf36` text, 577 `$ix_t13_8B49C928244561F5DACBE63B030ADA2983C76BFF` text GENERATED ALWAYS AS (json_unquote(json_extract(`doc`,'$.col3'))) VIRTUAL, 578 `$ix_i_ED8EA5BF0D44065A674B92033FC24920B41C5F42` int(11) GENERATED ALWAYS AS (json_extract(`doc`,'$._id')) VIRTUAL, 579 `$col1_ix_t13` text GENERATED ALWAYS AS (left(json_unquote(json_extract(`doc`,'$.col1')),13)) STORED, 580 PRIMARY KEY (`_id`), 581 KEY `col2_index` (`$ix_i_1C70785A292B9A2762EFA186DFCFB4F03C660E7F`), 582 KEY `col3_index` (`$ix_t13_8B49C928244561F5DACBE63B030ADA2983C76BFF`(13)), 583 KEY `_id_index` (`$ix_i_ED8EA5BF0D44065A674B92033FC24920B41C5F42`) 584) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 5850 rows affected 586RUN SELECT * FROM xplugintest.table2 587doc _id $ix_i_1C70785A292B9A2762EFA186DFCFB4F03C660E7F $ix_t13_bf29f74d5ecec695774cb5b3f1ff979e7643bf36 $ix_t13_8B49C928244561F5DACBE63B030ADA2983C76BFF $ix_i_ED8EA5BF0D44065A674B92033FC24920B41C5F42 $col1_ix_t13 588{"_id": 0, "col1": "01234567890123456789"} 0 null null null 0 0123456789012 589{"_id": 1, "col1": "val1", "col2": 101} 1 101 null null 1 val1 590{"_id": 4, "col1": "val4", "col2": 102} 4 102 null null 4 val4 591{"_id": 5, "col1": "val5"} 5 null null null 5 val5 5920 rows affected 593send Mysqlx.Sql.StmtExecute { 594 stmt: "create_collection_index" 595 args { 596 type: SCALAR 597 scalar { 598 type: V_STRING 599 v_string { 600 value: "xplugintest" 601 } 602 } 603 } 604 args { 605 type: SCALAR 606 scalar { 607 type: V_STRING 608 v_string { 609 value: "table2" 610 } 611 } 612 } 613 args { 614 type: SCALAR 615 scalar { 616 type: V_STRING 617 v_string { 618 value: "_id" 619 } 620 } 621 } 622 args { 623 type: SCALAR 624 scalar { 625 type: V_BOOL 626 v_bool: false 627 } 628 } 629 args { 630 type: SCALAR 631 scalar { 632 type: V_STRING 633 v_string { 634 value: "$.col9" 635 } 636 } 637 } 638 args { 639 type: SCALAR 640 scalar { 641 type: V_STRING 642 v_string { 643 value: "INT" 644 } 645 } 646 } 647 args { 648 type: SCALAR 649 scalar { 650 type: V_BOOL 651 v_bool: false 652 } 653 } 654 namespace: "xplugin" 655} 656 657Mysqlx.Sql.StmtExecuteOk { 658} 659 660RUN SHOW CREATE TABLE xplugintest.table2 661Table Create Table 662table2 CREATE TABLE `table2` ( 663 `doc` json DEFAULT NULL, 664 `_id` varchar(32) GENERATED ALWAYS AS (json_unquote(json_extract(`doc`,'$._id'))) STORED NOT NULL, 665 `$ix_i_1C70785A292B9A2762EFA186DFCFB4F03C660E7F` int(11) GENERATED ALWAYS AS (json_extract(`doc`,'$.col2')) VIRTUAL, 666 `$ix_t13_bf29f74d5ecec695774cb5b3f1ff979e7643bf36` text, 667 `$ix_t13_8B49C928244561F5DACBE63B030ADA2983C76BFF` text GENERATED ALWAYS AS (json_unquote(json_extract(`doc`,'$.col3'))) VIRTUAL, 668 `$ix_i_ED8EA5BF0D44065A674B92033FC24920B41C5F42` int(11) GENERATED ALWAYS AS (json_extract(`doc`,'$._id')) VIRTUAL, 669 `$col1_ix_t13` text GENERATED ALWAYS AS (left(json_unquote(json_extract(`doc`,'$.col1')),13)) STORED, 670 `$ix_i_19A716031E8396A7049831D1FFB53409FB4689A6` int(11) GENERATED ALWAYS AS (json_extract(`doc`,'$.col9')) VIRTUAL, 671 PRIMARY KEY (`_id`), 672 KEY `col2_index` (`$ix_i_1C70785A292B9A2762EFA186DFCFB4F03C660E7F`), 673 KEY `col3_index` (`$ix_t13_8B49C928244561F5DACBE63B030ADA2983C76BFF`(13)), 674 KEY `_id_index` (`$ix_i_ED8EA5BF0D44065A674B92033FC24920B41C5F42`), 675 KEY `_id` (`$ix_i_19A716031E8396A7049831D1FFB53409FB4689A6`) 676) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 6770 rows affected 678send Mysqlx.Sql.StmtExecute { 679 stmt: "create_collection_index" 680 args { 681 type: SCALAR 682 scalar { 683 type: V_STRING 684 v_string { 685 value: "xplugintest" 686 } 687 } 688 } 689 args { 690 type: SCALAR 691 scalar { 692 type: V_STRING 693 v_string { 694 value: "table2" 695 } 696 } 697 } 698 args { 699 type: SCALAR 700 scalar { 701 type: V_BOOL 702 v_bool: false 703 } 704 } 705 args { 706 type: SCALAR 707 scalar { 708 type: V_STRING 709 v_string { 710 value: "$.col5" 711 } 712 } 713 } 714 args { 715 type: SCALAR 716 scalar { 717 type: V_STRING 718 v_string { 719 value: "INT" 720 } 721 } 722 } 723 args { 724 type: SCALAR 725 scalar { 726 type: V_BOOL 727 v_bool: false 728 } 729 } 730 namespace: "xplugin" 731} 732 733Mysqlx.Error { 734 severity: ERROR 735 code: 5016 736 msg: "Invalid type for argument \'name\' at #3 (should be string)" 737 sql_state: "HY000" 738} 739 740RUN TRUNCATE xplugintest.table2 741 7420 rows affected 743RUN INSERT INTO xplugintest.table2(doc) VALUES('{"F1":1, "F2":"abcd", "F3":1000, "_id":0}') 744 7451 rows affected 746send Mysqlx.Sql.StmtExecute { 747 stmt: "create_collection_index" 748 args { 749 type: SCALAR 750 scalar { 751 type: V_STRING 752 v_string { 753 value: "xplugintest" 754 } 755 } 756 } 757 args { 758 type: SCALAR 759 scalar { 760 type: V_STRING 761 v_string { 762 value: "table2" 763 } 764 } 765 } 766 args { 767 type: SCALAR 768 scalar { 769 type: V_STRING 770 v_string { 771 value: "iX1" 772 } 773 } 774 } 775 args { 776 type: SCALAR 777 scalar { 778 type: V_BOOL 779 v_bool: false 780 } 781 } 782 args { 783 type: SCALAR 784 scalar { 785 type: V_STRING 786 v_string { 787 value: "$.F2" 788 } 789 } 790 } 791 args { 792 type: SCALAR 793 scalar { 794 type: V_STRING 795 v_string { 796 value: "BLOB(767)" 797 } 798 } 799 } 800 args { 801 type: SCALAR 802 scalar { 803 type: V_BOOL 804 v_bool: false 805 } 806 } 807 namespace: "xplugin" 808} 809 810Mysqlx.Sql.StmtExecuteOk { 811} 812 813Create index on two fields 814send Mysqlx.Sql.StmtExecute { 815 stmt: "create_collection_index" 816 args { 817 type: SCALAR 818 scalar { 819 type: V_STRING 820 v_string { 821 value: "xplugintest" 822 } 823 } 824 } 825 args { 826 type: SCALAR 827 scalar { 828 type: V_STRING 829 v_string { 830 value: "table2" 831 } 832 } 833 } 834 args { 835 type: SCALAR 836 scalar { 837 type: V_STRING 838 v_string { 839 value: "iX3" 840 } 841 } 842 } 843 args { 844 type: SCALAR 845 scalar { 846 type: V_BOOL 847 v_bool: true 848 } 849 } 850 args { 851 type: SCALAR 852 scalar { 853 type: V_STRING 854 v_string { 855 value: "$.F3" 856 } 857 } 858 } 859 args { 860 type: SCALAR 861 scalar { 862 type: V_STRING 863 v_string { 864 value: "BIGINT" 865 } 866 } 867 } 868 args { 869 type: SCALAR 870 scalar { 871 type: V_BOOL 872 v_bool: true 873 } 874 } 875 args { 876 type: SCALAR 877 scalar { 878 type: V_STRING 879 v_string { 880 value: "$.F2" 881 } 882 } 883 } 884 args { 885 type: SCALAR 886 scalar { 887 type: V_STRING 888 v_string { 889 value: "BLOB(767)" 890 } 891 } 892 } 893 args { 894 type: SCALAR 895 scalar { 896 type: V_BOOL 897 v_bool: true 898 } 899 } 900 namespace: "xplugin" 901} 902 903Mysqlx.Sql.StmtExecuteOk { 904} 905 906RUN TRUNCATE xplugintest.table2 907 9080 rows affected 909RUN INSERT INTO xplugintest.table2(doc) VALUES('{"F2":"REQUIRED", "F3":"1", "KeyName_VeryLongKeyNameWithKeyNameLength_FiFtyFourAndEvenABitLonger": "abcdefgh", "_id":1}') 910 9111 rows affected 912send Mysqlx.Sql.StmtExecute { 913 stmt: "create_collection_index" 914 args { 915 type: SCALAR 916 scalar { 917 type: V_STRING 918 v_string { 919 value: "xplugintest" 920 } 921 } 922 } 923 args { 924 type: SCALAR 925 scalar { 926 type: V_STRING 927 v_string { 928 value: "table2" 929 } 930 } 931 } 932 args { 933 type: SCALAR 934 scalar { 935 type: V_STRING 936 v_string { 937 value: "iXLong" 938 } 939 } 940 } 941 args { 942 type: SCALAR 943 scalar { 944 type: V_BOOL 945 v_bool: false 946 } 947 } 948 args { 949 type: SCALAR 950 scalar { 951 type: V_STRING 952 v_string { 953 value: "$.KeyName_VeryLongKeyNameWithKeyNameLength_FiFtyFourAndEvenABitLonger" 954 } 955 } 956 } 957 args { 958 type: SCALAR 959 scalar { 960 type: V_STRING 961 v_string { 962 value: "BLOB(3000)" 963 } 964 } 965 } 966 args { 967 type: SCALAR 968 scalar { 969 type: V_BOOL 970 v_bool: false 971 } 972 } 973 namespace: "xplugin" 974} 975 976Mysqlx.Sql.StmtExecuteOk { 977} 978 979RUN SHOW CREATE TABLE xplugintest.table2 980Table Create Table 981table2 CREATE TABLE `table2` ( 982 `doc` json DEFAULT NULL, 983 `_id` varchar(32) GENERATED ALWAYS AS (json_unquote(json_extract(`doc`,'$._id'))) STORED NOT NULL, 984 `$ix_i_1C70785A292B9A2762EFA186DFCFB4F03C660E7F` int(11) GENERATED ALWAYS AS (json_extract(`doc`,'$.col2')) VIRTUAL, 985 `$ix_t13_bf29f74d5ecec695774cb5b3f1ff979e7643bf36` text, 986 `$ix_t13_8B49C928244561F5DACBE63B030ADA2983C76BFF` text GENERATED ALWAYS AS (json_unquote(json_extract(`doc`,'$.col3'))) VIRTUAL, 987 `$ix_i_ED8EA5BF0D44065A674B92033FC24920B41C5F42` int(11) GENERATED ALWAYS AS (json_extract(`doc`,'$._id')) VIRTUAL, 988 `$col1_ix_t13` text GENERATED ALWAYS AS (left(json_unquote(json_extract(`doc`,'$.col1')),13)) STORED, 989 `$ix_i_19A716031E8396A7049831D1FFB53409FB4689A6` int(11) GENERATED ALWAYS AS (json_extract(`doc`,'$.col9')) VIRTUAL, 990 `$ix_bt767_8870EF04DBC5C827B87C34BF582F39442A78BBD9` blob GENERATED ALWAYS AS (json_unquote(json_extract(`doc`,'$.F2'))) VIRTUAL, 991 `$ix_ib_r_755774C7760C6184F154B25E88F81712F65BC712` bigint(20) GENERATED ALWAYS AS (json_extract(`doc`,'$.F3')) VIRTUAL NOT NULL, 992 `$ix_bt767_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9` blob GENERATED ALWAYS AS (json_unquote(json_extract(`doc`,'$.F2'))) VIRTUAL NOT NULL, 993 `$ix_bt3000_EED9F4FDE93464D65631C14643D3B9F9E401EA43` blob GENERATED ALWAYS AS (json_unquote(json_extract(`doc`,'$.KeyName_VeryLongKeyNameWithKeyNameLength_FiFtyFourAndEvenABitLonger'))) VIRTUAL, 994 PRIMARY KEY (`_id`), 995 UNIQUE KEY `iX3` (`$ix_ib_r_755774C7760C6184F154B25E88F81712F65BC712`,`$ix_bt767_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9`(767)), 996 KEY `col2_index` (`$ix_i_1C70785A292B9A2762EFA186DFCFB4F03C660E7F`), 997 KEY `col3_index` (`$ix_t13_8B49C928244561F5DACBE63B030ADA2983C76BFF`(13)), 998 KEY `_id_index` (`$ix_i_ED8EA5BF0D44065A674B92033FC24920B41C5F42`), 999 KEY `_id` (`$ix_i_19A716031E8396A7049831D1FFB53409FB4689A6`), 1000 KEY `iX1` (`$ix_bt767_8870EF04DBC5C827B87C34BF582F39442A78BBD9`(767)), 1001 KEY `iXLong` (`$ix_bt3000_EED9F4FDE93464D65631C14643D3B9F9E401EA43`(3000)) 1002) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 10030 rows affected 1004RUN SELECT * FROM xplugintest.table2 1005doc _id $ix_i_1C70785A292B9A2762EFA186DFCFB4F03C660E7F $ix_t13_bf29f74d5ecec695774cb5b3f1ff979e7643bf36 $ix_t13_8B49C928244561F5DACBE63B030ADA2983C76BFF $ix_i_ED8EA5BF0D44065A674B92033FC24920B41C5F42 $col1_ix_t13 $ix_i_19A716031E8396A7049831D1FFB53409FB4689A6 $ix_bt767_8870EF04DBC5C827B87C34BF582F39442A78BBD9 $ix_ib_r_755774C7760C6184F154B25E88F81712F65BC712 $ix_bt767_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 $ix_bt3000_EED9F4FDE93464D65631C14643D3B9F9E401EA43 1006{"F2": "REQUIRED", "F3": "1", "_id": 1, "KeyName_VeryLongKeyNameWithKeyNameLength_FiFtyFourAndEvenABitLonger": "abcdefgh"} 1 null null null 1 null null REQUIRED 1 REQUIRED abcdefgh 10070 rows affected 1008send Mysqlx.Sql.StmtExecute { 1009 stmt: "create_collection" 1010 args { 1011 type: SCALAR 1012 scalar { 1013 type: V_STRING 1014 v_string { 1015 value: "xplugintest" 1016 } 1017 } 1018 } 1019 args { 1020 type: SCALAR 1021 scalar { 1022 type: V_STRING 1023 v_string { 1024 value: "table3" 1025 } 1026 } 1027 } 1028 namespace: "xplugin" 1029} 1030 1031Mysqlx.Sql.StmtExecuteOk { 1032} 1033 1034send Mysqlx.Sql.StmtExecute { 1035 stmt: "create_collection_index" 1036 args { 1037 type: SCALAR 1038 scalar { 1039 type: V_STRING 1040 v_string { 1041 value: "xplugintest" 1042 } 1043 } 1044 } 1045 args { 1046 type: SCALAR 1047 scalar { 1048 type: V_STRING 1049 v_string { 1050 value: "table3" 1051 } 1052 } 1053 } 1054 args { 1055 type: SCALAR 1056 scalar { 1057 type: V_STRING 1058 v_string { 1059 value: "IX" 1060 } 1061 } 1062 } 1063 args { 1064 type: SCALAR 1065 scalar { 1066 type: V_BOOL 1067 v_bool: true 1068 } 1069 } 1070 args { 1071 type: SCALAR 1072 scalar { 1073 type: V_STRING 1074 v_string { 1075 value: "" 1076 } 1077 } 1078 } 1079 args { 1080 type: SCALAR 1081 scalar { 1082 type: V_STRING 1083 v_string { 1084 value: "INT" 1085 } 1086 } 1087 } 1088 args { 1089 type: SCALAR 1090 scalar { 1091 type: V_BOOL 1092 v_bool: true 1093 } 1094 } 1095 namespace: "xplugin" 1096} 1097 1098Mysqlx.Error { 1099 severity: ERROR 1100 code: 5017 1101 msg: "Invalid document path value for argument member" 1102 sql_state: "HY000" 1103} 1104 1105send Mysqlx.Sql.StmtExecute { 1106 stmt: "create_collection_index" 1107 args { 1108 type: SCALAR 1109 scalar { 1110 type: V_STRING 1111 v_string { 1112 value: "xplugintest" 1113 } 1114 } 1115 } 1116 args { 1117 type: SCALAR 1118 scalar { 1119 type: V_STRING 1120 v_string { 1121 value: "table3" 1122 } 1123 } 1124 } 1125 args { 1126 type: SCALAR 1127 scalar { 1128 type: V_STRING 1129 v_string { 1130 value: "IX0" 1131 } 1132 } 1133 } 1134 args { 1135 type: SCALAR 1136 scalar { 1137 type: V_BOOL 1138 v_bool: true 1139 } 1140 } 1141 args { 1142 type: SCALAR 1143 scalar { 1144 type: V_STRING 1145 v_string { 1146 value: "$" 1147 } 1148 } 1149 } 1150 args { 1151 type: SCALAR 1152 scalar { 1153 type: V_STRING 1154 v_string { 1155 value: "INT" 1156 } 1157 } 1158 } 1159 args { 1160 type: SCALAR 1161 scalar { 1162 type: V_BOOL 1163 v_bool: true 1164 } 1165 } 1166 namespace: "xplugin" 1167} 1168 1169Mysqlx.Error { 1170 severity: ERROR 1171 code: 5017 1172 msg: "Invalid document path value for argument member" 1173 sql_state: "HY000" 1174} 1175 1176send Mysqlx.Sql.StmtExecute { 1177 stmt: "create_collection_index" 1178 args { 1179 type: SCALAR 1180 scalar { 1181 type: V_STRING 1182 v_string { 1183 value: "xplugintest" 1184 } 1185 } 1186 } 1187 args { 1188 type: SCALAR 1189 scalar { 1190 type: V_STRING 1191 v_string { 1192 value: "table3" 1193 } 1194 } 1195 } 1196 args { 1197 type: SCALAR 1198 scalar { 1199 type: V_STRING 1200 v_string { 1201 value: "IX1" 1202 } 1203 } 1204 } 1205 args { 1206 type: SCALAR 1207 scalar { 1208 type: V_BOOL 1209 v_bool: true 1210 } 1211 } 1212 args { 1213 type: SCALAR 1214 scalar { 1215 type: V_STRING 1216 v_string { 1217 value: "$.`a#1`" 1218 } 1219 } 1220 } 1221 args { 1222 type: SCALAR 1223 scalar { 1224 type: V_STRING 1225 v_string { 1226 value: "INT" 1227 } 1228 } 1229 } 1230 args { 1231 type: SCALAR 1232 scalar { 1233 type: V_BOOL 1234 v_bool: true 1235 } 1236 } 1237 namespace: "xplugin" 1238} 1239 1240Mysqlx.Sql.StmtExecuteOk { 1241} 1242 1243send Mysqlx.Sql.StmtExecute { 1244 stmt: "create_collection_index" 1245 args { 1246 type: SCALAR 1247 scalar { 1248 type: V_STRING 1249 v_string { 1250 value: "xplugintest" 1251 } 1252 } 1253 } 1254 args { 1255 type: SCALAR 1256 scalar { 1257 type: V_STRING 1258 v_string { 1259 value: "table3" 1260 } 1261 } 1262 } 1263 args { 1264 type: SCALAR 1265 scalar { 1266 type: V_STRING 1267 v_string { 1268 value: "IX2" 1269 } 1270 } 1271 } 1272 args { 1273 type: SCALAR 1274 scalar { 1275 type: V_BOOL 1276 v_bool: true 1277 } 1278 } 1279 args { 1280 type: SCALAR 1281 scalar { 1282 type: V_STRING 1283 v_string { 1284 value: "$.a\'; drop datavase xplugintest; \'" 1285 } 1286 } 1287 } 1288 args { 1289 type: SCALAR 1290 scalar { 1291 type: V_STRING 1292 v_string { 1293 value: "INT" 1294 } 1295 } 1296 } 1297 args { 1298 type: SCALAR 1299 scalar { 1300 type: V_BOOL 1301 v_bool: true 1302 } 1303 } 1304 namespace: "xplugin" 1305} 1306 1307Mysqlx.Sql.StmtExecuteOk { 1308} 1309 1310send Mysqlx.Sql.StmtExecute { 1311 stmt: "create_collection_index" 1312 args { 1313 type: SCALAR 1314 scalar { 1315 type: V_STRING 1316 v_string { 1317 value: "xplugintest" 1318 } 1319 } 1320 } 1321 args { 1322 type: SCALAR 1323 scalar { 1324 type: V_STRING 1325 v_string { 1326 value: "table3" 1327 } 1328 } 1329 } 1330 args { 1331 type: SCALAR 1332 scalar { 1333 type: V_STRING 1334 v_string { 1335 value: "IX3" 1336 } 1337 } 1338 } 1339 args { 1340 type: SCALAR 1341 scalar { 1342 type: V_BOOL 1343 v_bool: true 1344 } 1345 } 1346 args { 1347 type: SCALAR 1348 scalar { 1349 type: V_STRING 1350 v_string { 1351 value: "$.`a\'1`" 1352 } 1353 } 1354 } 1355 args { 1356 type: SCALAR 1357 scalar { 1358 type: V_STRING 1359 v_string { 1360 value: "INT" 1361 } 1362 } 1363 } 1364 args { 1365 type: SCALAR 1366 scalar { 1367 type: V_BOOL 1368 v_bool: true 1369 } 1370 } 1371 namespace: "xplugin" 1372} 1373 1374Mysqlx.Sql.StmtExecuteOk { 1375} 1376 1377send Mysqlx.Sql.StmtExecute { 1378 stmt: "create_collection_index" 1379 args { 1380 type: SCALAR 1381 scalar { 1382 type: V_STRING 1383 v_string { 1384 value: "xplugintest" 1385 } 1386 } 1387 } 1388 args { 1389 type: SCALAR 1390 scalar { 1391 type: V_STRING 1392 v_string { 1393 value: "table3" 1394 } 1395 } 1396 } 1397 args { 1398 type: SCALAR 1399 scalar { 1400 type: V_STRING 1401 v_string { 1402 value: "IX4" 1403 } 1404 } 1405 } 1406 args { 1407 type: SCALAR 1408 scalar { 1409 type: V_BOOL 1410 v_bool: true 1411 } 1412 } 1413 args { 1414 type: SCALAR 1415 scalar { 1416 type: V_STRING 1417 v_string { 1418 value: "$.`a\'1`" 1419 } 1420 } 1421 } 1422 args { 1423 type: SCALAR 1424 scalar { 1425 type: V_STRING 1426 v_string { 1427 value: "INT" 1428 } 1429 } 1430 } 1431 args { 1432 type: SCALAR 1433 scalar { 1434 type: V_BOOL 1435 v_bool: true 1436 } 1437 } 1438 namespace: "xplugin" 1439} 1440 1441Mysqlx.Sql.StmtExecuteOk { 1442} 1443 1444send Mysqlx.Sql.StmtExecute { 1445 stmt: "create_collection_index" 1446 args { 1447 type: SCALAR 1448 scalar { 1449 type: V_STRING 1450 v_string { 1451 value: "xplugintest" 1452 } 1453 } 1454 } 1455 args { 1456 type: SCALAR 1457 scalar { 1458 type: V_STRING 1459 v_string { 1460 value: "table3" 1461 } 1462 } 1463 } 1464 args { 1465 type: SCALAR 1466 scalar { 1467 type: V_STRING 1468 v_string { 1469 value: "IX5" 1470 } 1471 } 1472 } 1473 args { 1474 type: SCALAR 1475 scalar { 1476 type: V_BOOL 1477 v_bool: true 1478 } 1479 } 1480 args { 1481 type: SCALAR 1482 scalar { 1483 type: V_STRING 1484 v_string { 1485 value: "$.`a\\\'1`" 1486 } 1487 } 1488 } 1489 args { 1490 type: SCALAR 1491 scalar { 1492 type: V_STRING 1493 v_string { 1494 value: "INT" 1495 } 1496 } 1497 } 1498 args { 1499 type: SCALAR 1500 scalar { 1501 type: V_BOOL 1502 v_bool: true 1503 } 1504 } 1505 namespace: "xplugin" 1506} 1507 1508Mysqlx.Sql.StmtExecuteOk { 1509} 1510 1511send Mysqlx.Sql.StmtExecute { 1512 stmt: "create_collection_index" 1513 args { 1514 type: SCALAR 1515 scalar { 1516 type: V_STRING 1517 v_string { 1518 value: "xplugintest" 1519 } 1520 } 1521 } 1522 args { 1523 type: SCALAR 1524 scalar { 1525 type: V_STRING 1526 v_string { 1527 value: "table3" 1528 } 1529 } 1530 } 1531 args { 1532 type: SCALAR 1533 scalar { 1534 type: V_STRING 1535 v_string { 1536 value: "IX6" 1537 } 1538 } 1539 } 1540 args { 1541 type: SCALAR 1542 scalar { 1543 type: V_BOOL 1544 v_bool: true 1545 } 1546 } 1547 args { 1548 type: SCALAR 1549 scalar { 1550 type: V_STRING 1551 v_string { 1552 value: "$.a\' drop database xplugintest; \'" 1553 } 1554 } 1555 } 1556 args { 1557 type: SCALAR 1558 scalar { 1559 type: V_STRING 1560 v_string { 1561 value: "INT" 1562 } 1563 } 1564 } 1565 args { 1566 type: SCALAR 1567 scalar { 1568 type: V_BOOL 1569 v_bool: true 1570 } 1571 } 1572 namespace: "xplugin" 1573} 1574 1575Mysqlx.Sql.StmtExecuteOk { 1576} 1577 1578send Mysqlx.Sql.StmtExecute { 1579 stmt: "create_collection_index" 1580 args { 1581 type: SCALAR 1582 scalar { 1583 type: V_STRING 1584 v_string { 1585 value: "xplugintest" 1586 } 1587 } 1588 } 1589 args { 1590 type: SCALAR 1591 scalar { 1592 type: V_STRING 1593 v_string { 1594 value: "table3" 1595 } 1596 } 1597 } 1598 args { 1599 type: SCALAR 1600 scalar { 1601 type: V_STRING 1602 v_string { 1603 value: "IX7" 1604 } 1605 } 1606 } 1607 args { 1608 type: SCALAR 1609 scalar { 1610 type: V_BOOL 1611 v_bool: true 1612 } 1613 } 1614 args { 1615 type: SCALAR 1616 scalar { 1617 type: V_STRING 1618 v_string { 1619 value: "$.b)) virtual not null; drop database xplugintest; alter table table3 add column x int GENERATED ALWAYS AS (JSON_EXTRACT(doc, $.c" 1620 } 1621 } 1622 } 1623 args { 1624 type: SCALAR 1625 scalar { 1626 type: V_STRING 1627 v_string { 1628 value: "INT" 1629 } 1630 } 1631 } 1632 args { 1633 type: SCALAR 1634 scalar { 1635 type: V_BOOL 1636 v_bool: true 1637 } 1638 } 1639 namespace: "xplugin" 1640} 1641 1642Mysqlx.Sql.StmtExecuteOk { 1643} 1644 1645send Mysqlx.Sql.StmtExecute { 1646 stmt: "create_collection_index" 1647 args { 1648 type: SCALAR 1649 scalar { 1650 type: V_STRING 1651 v_string { 1652 value: "xplugintest" 1653 } 1654 } 1655 } 1656 args { 1657 type: SCALAR 1658 scalar { 1659 type: V_STRING 1660 v_string { 1661 value: "table3" 1662 } 1663 } 1664 } 1665 args { 1666 type: SCALAR 1667 scalar { 1668 type: V_STRING 1669 v_string { 1670 value: "IX8" 1671 } 1672 } 1673 } 1674 args { 1675 type: SCALAR 1676 scalar { 1677 type: V_BOOL 1678 v_bool: true 1679 } 1680 } 1681 args { 1682 type: SCALAR 1683 scalar { 1684 type: V_STRING 1685 v_string { 1686 value: "$.b\')) virtual not null; drop database xplugintest; alter table table3 add column x int GENERATED ALWAYS AS (JSON_EXTRACT(doc, \'$.c" 1687 } 1688 } 1689 } 1690 args { 1691 type: SCALAR 1692 scalar { 1693 type: V_STRING 1694 v_string { 1695 value: "INT" 1696 } 1697 } 1698 } 1699 args { 1700 type: SCALAR 1701 scalar { 1702 type: V_BOOL 1703 v_bool: true 1704 } 1705 } 1706 namespace: "xplugin" 1707} 1708 1709Mysqlx.Sql.StmtExecuteOk { 1710} 1711 1712send Mysqlx.Sql.StmtExecute { 1713 stmt: "create_collection_index" 1714 args { 1715 type: SCALAR 1716 scalar { 1717 type: V_STRING 1718 v_string { 1719 value: "xplugintest" 1720 } 1721 } 1722 } 1723 args { 1724 type: SCALAR 1725 scalar { 1726 type: V_STRING 1727 v_string { 1728 value: "table3" 1729 } 1730 } 1731 } 1732 args { 1733 type: SCALAR 1734 scalar { 1735 type: V_STRING 1736 v_string { 1737 value: "IX9" 1738 } 1739 } 1740 } 1741 args { 1742 type: SCALAR 1743 scalar { 1744 type: V_BOOL 1745 v_bool: true 1746 } 1747 } 1748 args { 1749 type: SCALAR 1750 scalar { 1751 type: V_STRING 1752 v_string { 1753 value: "$.b\')) virtual not null; drop database xplugintest; alter table table3 add column x int GENERATED ALWAYS AS (JSON_EXTRACT(doc, \'$.c" 1754 } 1755 } 1756 } 1757 args { 1758 type: SCALAR 1759 scalar { 1760 type: V_STRING 1761 v_string { 1762 value: "INT" 1763 } 1764 } 1765 } 1766 args { 1767 type: SCALAR 1768 scalar { 1769 type: V_BOOL 1770 v_bool: true 1771 } 1772 } 1773 namespace: "xplugin" 1774} 1775 1776Mysqlx.Sql.StmtExecuteOk { 1777} 1778 1779send Mysqlx.Sql.StmtExecute { 1780 stmt: "create_collection_index" 1781 args { 1782 type: SCALAR 1783 scalar { 1784 type: V_STRING 1785 v_string { 1786 value: "xplugintest" 1787 } 1788 } 1789 } 1790 args { 1791 type: SCALAR 1792 scalar { 1793 type: V_STRING 1794 v_string { 1795 value: "table3" 1796 } 1797 } 1798 } 1799 args { 1800 type: SCALAR 1801 scalar { 1802 type: V_STRING 1803 v_string { 1804 value: "IX10" 1805 } 1806 } 1807 } 1808 args { 1809 type: SCALAR 1810 scalar { 1811 type: V_BOOL 1812 v_bool: true 1813 } 1814 } 1815 args { 1816 type: SCALAR 1817 scalar { 1818 type: V_STRING 1819 v_string { 1820 value: "$.b\\\')) virtual not null; drop database xplugintest; alter table table3 add column x int GENERATED ALWAYS AS (JSON_EXTRACT(doc, \\\'$.c" 1821 } 1822 } 1823 } 1824 args { 1825 type: SCALAR 1826 scalar { 1827 type: V_STRING 1828 v_string { 1829 value: "INT" 1830 } 1831 } 1832 } 1833 args { 1834 type: SCALAR 1835 scalar { 1836 type: V_BOOL 1837 v_bool: true 1838 } 1839 } 1840 namespace: "xplugin" 1841} 1842 1843Mysqlx.Sql.StmtExecuteOk { 1844} 1845 1846send Mysqlx.Sql.StmtExecute { 1847 stmt: "create_collection_index" 1848 args { 1849 type: SCALAR 1850 scalar { 1851 type: V_STRING 1852 v_string { 1853 value: "xplugintest" 1854 } 1855 } 1856 } 1857 args { 1858 type: SCALAR 1859 scalar { 1860 type: V_STRING 1861 v_string { 1862 value: "table3" 1863 } 1864 } 1865 } 1866 args { 1867 type: SCALAR 1868 scalar { 1869 type: V_STRING 1870 v_string { 1871 value: "IX11" 1872 } 1873 } 1874 } 1875 args { 1876 type: SCALAR 1877 scalar { 1878 type: V_BOOL 1879 v_bool: true 1880 } 1881 } 1882 args { 1883 type: SCALAR 1884 scalar { 1885 type: V_STRING 1886 v_string { 1887 value: "$.`b))` virtual not null; drop database xplugintest; alter table table3 add column x int GENERATED ALWAYS AS (JSON_EXTRACT(doc, $.`c`" 1888 } 1889 } 1890 } 1891 args { 1892 type: SCALAR 1893 scalar { 1894 type: V_STRING 1895 v_string { 1896 value: "INT" 1897 } 1898 } 1899 } 1900 args { 1901 type: SCALAR 1902 scalar { 1903 type: V_BOOL 1904 v_bool: true 1905 } 1906 } 1907 namespace: "xplugin" 1908} 1909 1910Mysqlx.Sql.StmtExecuteOk { 1911} 1912 1913Document path 2k long 1914send Mysqlx.Sql.StmtExecute { 1915 stmt: "create_collection_index" 1916 args { 1917 type: SCALAR 1918 scalar { 1919 type: V_STRING 1920 v_string { 1921 value: "xplugintest" 1922 } 1923 } 1924 } 1925 args { 1926 type: SCALAR 1927 scalar { 1928 type: V_STRING 1929 v_string { 1930 value: "table3" 1931 } 1932 } 1933 } 1934 args { 1935 type: SCALAR 1936 scalar { 1937 type: V_STRING 1938 v_string { 1939 value: "IXLong1" 1940 } 1941 } 1942 } 1943 args { 1944 type: SCALAR 1945 scalar { 1946 type: V_BOOL 1947 v_bool: true 1948 } 1949 } 1950 args { 1951 type: SCALAR 1952 scalar { 1953 type: V_STRING 1954 v_string { 1955 value: "$.a0123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678" 1956 } 1957 } 1958 } 1959 args { 1960 type: SCALAR 1961 scalar { 1962 type: V_STRING 1963 v_string { 1964 value: "INT" 1965 } 1966 } 1967 } 1968 args { 1969 type: SCALAR 1970 scalar { 1971 type: V_BOOL 1972 v_bool: true 1973 } 1974 } 1975 namespace: "xplugin" 1976} 1977 1978Mysqlx.Sql.StmtExecuteOk { 1979} 1980 1981RUN SHOW CREATE TABLE xplugintest.table3 1982Table Create Table 1983table3 CREATE TABLE `table3` ( 1984 `doc` json DEFAULT NULL, 1985 `_id` varchar(32) GENERATED ALWAYS AS (json_unquote(json_extract(`doc`,'$._id'))) STORED NOT NULL, 1986 `$ix_i_r_DB5D40CADB1AF49035A1BEE0FFF0C8B4CA357CC2` int(11) GENERATED ALWAYS AS (json_extract(`doc`,'$.`a#1`')) VIRTUAL NOT NULL, 1987 `$ix_i_r_AD49E2F7B0384744AD4EE41937A47E44B2E0DDC8` int(11) GENERATED ALWAYS AS (json_extract(`doc`,'$.a\'; drop datavase xplugintest; \'')) VIRTUAL NOT NULL, 1988 `$ix_i_r_C30BDD20F69BA78166A26D8620EDA8C634E8BDBD` int(11) GENERATED ALWAYS AS (json_extract(`doc`,'$.`a\'1`')) VIRTUAL NOT NULL, 1989 `$ix_i_r_7C10F13A9677599586BF002593F6406D5258416F` int(11) GENERATED ALWAYS AS (json_extract(`doc`,'$.`a\\\'1`')) VIRTUAL NOT NULL, 1990 `$ix_i_r_EA84D56047FAB9EC36481B419931E508D77D0C30` int(11) GENERATED ALWAYS AS (json_extract(`doc`,'$.a\' drop database xplugintest; \'')) VIRTUAL NOT NULL, 1991 `$ix_i_r_55BC2C2CAF9700E3D4EF9E1BBC7E21E14788A16B` int(11) GENERATED ALWAYS AS (json_extract(`doc`,'$.b)) virtual not null; drop database xplugintest; alter table table3 add column x int GENERATED ALWAYS AS (JSON_EXTRACT(doc, $.c')) VIRTUAL NOT NULL, 1992 `$ix_i_r_4FDF930A8FF7114E54244CA377E03F7500AD9E96` int(11) GENERATED ALWAYS AS (json_extract(`doc`,'$.b\')) virtual not null; drop database xplugintest; alter table table3 add column x int GENERATED ALWAYS AS (JSON_EXTRACT(doc, \'$.c')) VIRTUAL NOT NULL, 1993 `$ix_i_r_94DA72EC77AD3D19CB6B9CB6383069C810932E29` int(11) GENERATED ALWAYS AS (json_extract(`doc`,'$.b\\\')) virtual not null; drop database xplugintest; alter table table3 add column x int GENERATED ALWAYS AS (JSON_EXTRACT(doc, \\\'$.c')) VIRTUAL NOT NULL, 1994 `$ix_i_r_0B6D1F04DD08A4AB089A8F9D3B079ECFDFBBD179` int(11) GENERATED ALWAYS AS (json_extract(`doc`,'$.`b))` virtual not null; drop database xplugintest; alter table table3 add column x int GENERATED ALWAYS AS (JSON_EXTRACT(doc, $.`c`')) VIRTUAL NOT NULL, 1995 `$ix_i_r_9BC5A3EB89CA6B17C3272000A817E7A813E3986B` int(11) GENERATED ALWAYS AS (json_extract(`doc`,'$.a0123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678')) VIRTUAL NOT NULL, 1996 PRIMARY KEY (`_id`), 1997 UNIQUE KEY `IX1` (`$ix_i_r_DB5D40CADB1AF49035A1BEE0FFF0C8B4CA357CC2`), 1998 UNIQUE KEY `IX2` (`$ix_i_r_AD49E2F7B0384744AD4EE41937A47E44B2E0DDC8`), 1999 UNIQUE KEY `IX3` (`$ix_i_r_C30BDD20F69BA78166A26D8620EDA8C634E8BDBD`), 2000 UNIQUE KEY `IX4` (`$ix_i_r_C30BDD20F69BA78166A26D8620EDA8C634E8BDBD`), 2001 UNIQUE KEY `IX5` (`$ix_i_r_7C10F13A9677599586BF002593F6406D5258416F`), 2002 UNIQUE KEY `IX6` (`$ix_i_r_EA84D56047FAB9EC36481B419931E508D77D0C30`), 2003 UNIQUE KEY `IX7` (`$ix_i_r_55BC2C2CAF9700E3D4EF9E1BBC7E21E14788A16B`), 2004 UNIQUE KEY `IX8` (`$ix_i_r_4FDF930A8FF7114E54244CA377E03F7500AD9E96`), 2005 UNIQUE KEY `IX9` (`$ix_i_r_4FDF930A8FF7114E54244CA377E03F7500AD9E96`), 2006 UNIQUE KEY `IX10` (`$ix_i_r_94DA72EC77AD3D19CB6B9CB6383069C810932E29`), 2007 UNIQUE KEY `IX11` (`$ix_i_r_0B6D1F04DD08A4AB089A8F9D3B079ECFDFBBD179`), 2008 UNIQUE KEY `IXLong1` (`$ix_i_r_9BC5A3EB89CA6B17C3272000A817E7A813E3986B`) 2009) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 20100 rows affected 2011RUN CREATE TABLE col_myp337 ( _id INT , doc JSON ) 2012 20130 rows affected 2014Mysqlx.Sql.StmtExecuteOk { 2015} 2016 2017Mysqlx.Sql.StmtExecuteOk { 2018} 2019 2020Mysqlx.Sql.StmtExecuteOk { 2021} 2022 2023Mysqlx.Sql.StmtExecuteOk { 2024} 2025 2026Mysqlx.Sql.StmtExecuteOk { 2027} 2028 2029Mysqlx.Sql.StmtExecuteOk { 2030} 2031 2032Mysqlx.Sql.StmtExecuteOk { 2033} 2034 2035Mysqlx.Sql.StmtExecuteOk { 2036} 2037 2038Mysqlx.Sql.StmtExecuteOk { 2039} 2040 2041Mysqlx.Sql.StmtExecuteOk { 2042} 2043 2044Mysqlx.Sql.StmtExecuteOk { 2045} 2046 2047Mysqlx.Sql.StmtExecuteOk { 2048} 2049 2050Mysqlx.Sql.StmtExecuteOk { 2051} 2052 2053Mysqlx.Sql.StmtExecuteOk { 2054} 2055 2056Mysqlx.Sql.StmtExecuteOk { 2057} 2058 2059Mysqlx.Sql.StmtExecuteOk { 2060} 2061 2062Mysqlx.Sql.StmtExecuteOk { 2063} 2064 2065Mysqlx.Sql.StmtExecuteOk { 2066} 2067 2068Mysqlx.Sql.StmtExecuteOk { 2069} 2070 2071Mysqlx.Sql.StmtExecuteOk { 2072} 2073 2074Mysqlx.Sql.StmtExecuteOk { 2075} 2076 2077Mysqlx.Sql.StmtExecuteOk { 2078} 2079 2080Mysqlx.Sql.StmtExecuteOk { 2081} 2082 2083Mysqlx.Sql.StmtExecuteOk { 2084} 2085 2086Mysqlx.Sql.StmtExecuteOk { 2087} 2088 2089Mysqlx.Sql.StmtExecuteOk { 2090} 2091 2092Mysqlx.Sql.StmtExecuteOk { 2093} 2094 2095Mysqlx.Sql.StmtExecuteOk { 2096} 2097 2098Mysqlx.Sql.StmtExecuteOk { 2099} 2100 2101Mysqlx.Sql.StmtExecuteOk { 2102} 2103 2104RUN SHOW INDEX from xplugintest.col_myp337 where Key_name rlike '^index_[12][0-9]*' 2105Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment 2106col_myp337 0 index_11 1 $ix_t11_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 11 null BTREE 2107col_myp337 0 index_11 2 $ix_t11_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 11 null YES BTREE 2108col_myp337 0 index_11 3 $ix_i11_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE 2109col_myp337 0 index_11 4 $ix_i11_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE 2110col_myp337 0 index_11 5 $ix_bt11_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 11 null BTREE 2111col_myp337 0 index_11 6 $ix_bt11_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 11 null YES BTREE 2112col_myp337 0 index_12 1 $ix_t12_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 12 null BTREE 2113col_myp337 0 index_12 2 $ix_t12_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 12 null YES BTREE 2114col_myp337 0 index_12 3 $ix_i12_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE 2115col_myp337 0 index_12 4 $ix_i12_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE 2116col_myp337 0 index_12 5 $ix_bt12_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 12 null BTREE 2117col_myp337 0 index_12 6 $ix_bt12_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 12 null YES BTREE 2118col_myp337 0 index_13 1 $ix_t13_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 13 null BTREE 2119col_myp337 0 index_13 2 $ix_t13_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 13 null YES BTREE 2120col_myp337 0 index_13 3 $ix_i13_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE 2121col_myp337 0 index_13 4 $ix_i13_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE 2122col_myp337 0 index_13 5 $ix_bt13_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 13 null BTREE 2123col_myp337 0 index_13 6 $ix_bt13_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 13 null YES BTREE 2124col_myp337 0 index_14 1 $ix_t14_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 14 null BTREE 2125col_myp337 0 index_14 2 $ix_t14_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 14 null YES BTREE 2126col_myp337 0 index_14 3 $ix_i14_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE 2127col_myp337 0 index_14 4 $ix_i14_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE 2128col_myp337 0 index_14 5 $ix_bt14_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 14 null BTREE 2129col_myp337 0 index_14 6 $ix_bt14_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 14 null YES BTREE 2130col_myp337 0 index_15 1 $ix_t15_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 15 null BTREE 2131col_myp337 0 index_15 2 $ix_t15_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 15 null YES BTREE 2132col_myp337 0 index_15 3 $ix_i15_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE 2133col_myp337 0 index_15 4 $ix_i15_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE 2134col_myp337 0 index_15 5 $ix_bt15_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 15 null BTREE 2135col_myp337 0 index_15 6 $ix_bt15_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 15 null YES BTREE 2136col_myp337 0 index_16 1 $ix_t16_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 16 null BTREE 2137col_myp337 0 index_16 2 $ix_t16_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 16 null YES BTREE 2138col_myp337 0 index_16 3 $ix_i16_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE 2139col_myp337 0 index_16 4 $ix_i16_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE 2140col_myp337 0 index_16 5 $ix_bt16_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 16 null BTREE 2141col_myp337 0 index_16 6 $ix_bt16_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 16 null YES BTREE 2142col_myp337 0 index_17 1 $ix_t17_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 17 null BTREE 2143col_myp337 0 index_17 2 $ix_t17_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 17 null YES BTREE 2144col_myp337 0 index_17 3 $ix_i17_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE 2145col_myp337 0 index_17 4 $ix_i17_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE 2146col_myp337 0 index_17 5 $ix_bt17_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 17 null BTREE 2147col_myp337 0 index_17 6 $ix_bt17_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 17 null YES BTREE 2148col_myp337 0 index_18 1 $ix_t18_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 18 null BTREE 2149col_myp337 0 index_18 2 $ix_t18_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 18 null YES BTREE 2150col_myp337 0 index_18 3 $ix_i18_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE 2151col_myp337 0 index_18 4 $ix_i18_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE 2152col_myp337 0 index_18 5 $ix_bt18_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 18 null BTREE 2153col_myp337 0 index_18 6 $ix_bt18_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 18 null YES BTREE 2154col_myp337 0 index_19 1 $ix_t19_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 19 null BTREE 2155col_myp337 0 index_19 2 $ix_t19_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 19 null YES BTREE 2156col_myp337 0 index_19 3 $ix_i19_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE 2157col_myp337 0 index_19 4 $ix_i19_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE 2158col_myp337 0 index_19 5 $ix_bt19_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 19 null BTREE 2159col_myp337 0 index_19 6 $ix_bt19_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 19 null YES BTREE 2160col_myp337 0 index_20 1 $ix_t20_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 20 null BTREE 2161col_myp337 0 index_20 2 $ix_t20_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 20 null YES BTREE 2162col_myp337 0 index_20 3 $ix_i20_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE 2163col_myp337 0 index_20 4 $ix_i20_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE 2164col_myp337 0 index_20 5 $ix_bt20_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 20 null BTREE 2165col_myp337 0 index_20 6 $ix_bt20_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 20 null YES BTREE 2166col_myp337 0 index_21 1 $ix_t21_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 21 null BTREE 2167col_myp337 0 index_21 2 $ix_t21_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 21 null YES BTREE 2168col_myp337 0 index_21 3 $ix_i21_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE 2169col_myp337 0 index_21 4 $ix_i21_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE 2170col_myp337 0 index_21 5 $ix_bt21_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 21 null BTREE 2171col_myp337 0 index_21 6 $ix_bt21_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 21 null YES BTREE 2172col_myp337 0 index_22 1 $ix_t22_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 22 null BTREE 2173col_myp337 0 index_22 2 $ix_t22_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 22 null YES BTREE 2174col_myp337 0 index_22 3 $ix_i22_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE 2175col_myp337 0 index_22 4 $ix_i22_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE 2176col_myp337 0 index_22 5 $ix_bt22_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 22 null BTREE 2177col_myp337 0 index_22 6 $ix_bt22_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 22 null YES BTREE 2178col_myp337 0 index_23 1 $ix_t23_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 23 null BTREE 2179col_myp337 0 index_23 2 $ix_t23_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 23 null YES BTREE 2180col_myp337 0 index_23 3 $ix_i23_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE 2181col_myp337 0 index_23 4 $ix_i23_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE 2182col_myp337 0 index_23 5 $ix_bt23_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 23 null BTREE 2183col_myp337 0 index_23 6 $ix_bt23_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 23 null YES BTREE 2184col_myp337 0 index_24 1 $ix_t24_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 24 null BTREE 2185col_myp337 0 index_24 2 $ix_t24_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 24 null YES BTREE 2186col_myp337 0 index_24 3 $ix_i24_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE 2187col_myp337 0 index_24 4 $ix_i24_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE 2188col_myp337 0 index_24 5 $ix_bt24_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 24 null BTREE 2189col_myp337 0 index_24 6 $ix_bt24_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 24 null YES BTREE 2190col_myp337 0 index_25 1 $ix_t25_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 25 null BTREE 2191col_myp337 0 index_25 2 $ix_t25_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 25 null YES BTREE 2192col_myp337 0 index_25 3 $ix_i25_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE 2193col_myp337 0 index_25 4 $ix_i25_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE 2194col_myp337 0 index_25 5 $ix_bt25_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 25 null BTREE 2195col_myp337 0 index_25 6 $ix_bt25_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 25 null YES BTREE 2196col_myp337 0 index_26 1 $ix_t26_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 26 null BTREE 2197col_myp337 0 index_26 2 $ix_t26_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 26 null YES BTREE 2198col_myp337 0 index_26 3 $ix_i26_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE 2199col_myp337 0 index_26 4 $ix_i26_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE 2200col_myp337 0 index_26 5 $ix_bt26_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 26 null BTREE 2201col_myp337 0 index_26 6 $ix_bt26_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 26 null YES BTREE 2202col_myp337 0 index_27 1 $ix_t27_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 27 null BTREE 2203col_myp337 0 index_27 2 $ix_t27_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 27 null YES BTREE 2204col_myp337 0 index_27 3 $ix_i27_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE 2205col_myp337 0 index_27 4 $ix_i27_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE 2206col_myp337 0 index_27 5 $ix_bt27_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 27 null BTREE 2207col_myp337 0 index_27 6 $ix_bt27_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 27 null YES BTREE 2208col_myp337 0 index_28 1 $ix_t28_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 28 null BTREE 2209col_myp337 0 index_28 2 $ix_t28_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 28 null YES BTREE 2210col_myp337 0 index_28 3 $ix_i28_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE 2211col_myp337 0 index_28 4 $ix_i28_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE 2212col_myp337 0 index_28 5 $ix_bt28_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 28 null BTREE 2213col_myp337 0 index_28 6 $ix_bt28_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 28 null YES BTREE 2214col_myp337 0 index_29 1 $ix_t29_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 29 null BTREE 2215col_myp337 0 index_29 2 $ix_t29_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 29 null YES BTREE 2216col_myp337 0 index_29 3 $ix_i29_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE 2217col_myp337 0 index_29 4 $ix_i29_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE 2218col_myp337 0 index_29 5 $ix_bt29_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 29 null BTREE 2219col_myp337 0 index_29 6 $ix_bt29_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 29 null YES BTREE 22200 rows affected 2221RUN SHOW INDEX from xplugintest.col_myp337 where Key_name rlike '^index_[34][0-9]*' 2222Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment 2223col_myp337 0 index_30 1 $ix_t30_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 30 null BTREE 2224col_myp337 0 index_30 2 $ix_t30_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 30 null YES BTREE 2225col_myp337 0 index_30 3 $ix_i30_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE 2226col_myp337 0 index_30 4 $ix_i30_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE 2227col_myp337 0 index_30 5 $ix_bt30_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 30 null BTREE 2228col_myp337 0 index_30 6 $ix_bt30_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 30 null YES BTREE 2229col_myp337 0 index_31 1 $ix_t31_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 31 null BTREE 2230col_myp337 0 index_31 2 $ix_t31_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 31 null YES BTREE 2231col_myp337 0 index_31 3 $ix_i31_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE 2232col_myp337 0 index_31 4 $ix_i31_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE 2233col_myp337 0 index_31 5 $ix_bt31_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 31 null BTREE 2234col_myp337 0 index_31 6 $ix_bt31_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 31 null YES BTREE 2235col_myp337 0 index_32 1 $ix_t32_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 32 null BTREE 2236col_myp337 0 index_32 2 $ix_t32_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 32 null YES BTREE 2237col_myp337 0 index_32 3 $ix_i32_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE 2238col_myp337 0 index_32 4 $ix_i32_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE 2239col_myp337 0 index_32 5 $ix_bt32_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 32 null BTREE 2240col_myp337 0 index_32 6 $ix_bt32_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 32 null YES BTREE 2241col_myp337 0 index_33 1 $ix_t33_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 33 null BTREE 2242col_myp337 0 index_33 2 $ix_t33_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 33 null YES BTREE 2243col_myp337 0 index_33 3 $ix_i33_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE 2244col_myp337 0 index_33 4 $ix_i33_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE 2245col_myp337 0 index_33 5 $ix_bt33_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 33 null BTREE 2246col_myp337 0 index_33 6 $ix_bt33_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 33 null YES BTREE 2247col_myp337 0 index_34 1 $ix_t34_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 34 null BTREE 2248col_myp337 0 index_34 2 $ix_t34_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 34 null YES BTREE 2249col_myp337 0 index_34 3 $ix_i34_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE 2250col_myp337 0 index_34 4 $ix_i34_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE 2251col_myp337 0 index_34 5 $ix_bt34_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 34 null BTREE 2252col_myp337 0 index_34 6 $ix_bt34_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 34 null YES BTREE 2253col_myp337 0 index_35 1 $ix_t35_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 35 null BTREE 2254col_myp337 0 index_35 2 $ix_t35_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 35 null YES BTREE 2255col_myp337 0 index_35 3 $ix_i35_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE 2256col_myp337 0 index_35 4 $ix_i35_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE 2257col_myp337 0 index_35 5 $ix_bt35_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 35 null BTREE 2258col_myp337 0 index_35 6 $ix_bt35_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 35 null YES BTREE 2259col_myp337 0 index_36 1 $ix_t36_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 36 null BTREE 2260col_myp337 0 index_36 2 $ix_t36_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 36 null YES BTREE 2261col_myp337 0 index_36 3 $ix_i36_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE 2262col_myp337 0 index_36 4 $ix_i36_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE 2263col_myp337 0 index_36 5 $ix_bt36_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 36 null BTREE 2264col_myp337 0 index_36 6 $ix_bt36_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 36 null YES BTREE 2265col_myp337 0 index_37 1 $ix_t37_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 37 null BTREE 2266col_myp337 0 index_37 2 $ix_t37_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 37 null YES BTREE 2267col_myp337 0 index_37 3 $ix_i37_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE 2268col_myp337 0 index_37 4 $ix_i37_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE 2269col_myp337 0 index_37 5 $ix_bt37_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 37 null BTREE 2270col_myp337 0 index_37 6 $ix_bt37_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 37 null YES BTREE 2271col_myp337 0 index_38 1 $ix_t38_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 38 null BTREE 2272col_myp337 0 index_38 2 $ix_t38_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 38 null YES BTREE 2273col_myp337 0 index_38 3 $ix_i38_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE 2274col_myp337 0 index_38 4 $ix_i38_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE 2275col_myp337 0 index_38 5 $ix_bt38_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 38 null BTREE 2276col_myp337 0 index_38 6 $ix_bt38_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 38 null YES BTREE 2277col_myp337 0 index_39 1 $ix_t39_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 39 null BTREE 2278col_myp337 0 index_39 2 $ix_t39_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 39 null YES BTREE 2279col_myp337 0 index_39 3 $ix_i39_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE 2280col_myp337 0 index_39 4 $ix_i39_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE 2281col_myp337 0 index_39 5 $ix_bt39_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 39 null BTREE 2282col_myp337 0 index_39 6 $ix_bt39_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 39 null YES BTREE 2283col_myp337 0 index_40 1 $ix_t40_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 40 null BTREE 2284col_myp337 0 index_40 2 $ix_t40_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 40 null YES BTREE 2285col_myp337 0 index_40 3 $ix_i40_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE 2286col_myp337 0 index_40 4 $ix_i40_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE 2287col_myp337 0 index_40 5 $ix_bt40_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 40 null BTREE 2288col_myp337 0 index_40 6 $ix_bt40_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 40 null YES BTREE 22890 rows affected 2290Mysqlx.Ok { 2291 msg: "bye!" 2292} 2293ok 2294RUN DROP DATABASE IF EXISTS xplugintest 2295 22964 rows affected 2297RUN DROP DATABASE IF EXISTS xplugintest_1 2298 22990 rows affected 2300Mysqlx.Ok { 2301 msg: "bye!" 2302} 2303ok 2304UNINSTALL PLUGIN mysqlx; 2305