| 1 |
call mtr.add_suppression("Error parsing message of type 12: args"); |
| 2 |
call mtr.add_suppression("Error handling message: args"); |
| 3 |
call mtr.add_suppression("Compute virtual column values failed"); |
| 4 |
RUN DROP DATABASE IF EXISTS xplugintest |
| 5 |
|
| 6 |
0 rows affected |
| 7 |
RUN DROP DATABASE IF EXISTS xplugintest_1 |
| 8 |
|
| 9 |
0 rows affected |
| 10 |
RUN CREATE DATABASE xplugintest |
| 11 |
|
| 12 |
1 rows affected |
| 13 |
RUN CREATE DATABASE xplugintest_1 |
| 14 |
|
| 15 |
1 rows affected |
| 16 |
RUN USE xplugintest |
| 17 |
|
| 18 |
0 rows affected |
| 19 |
RUN CREATE TABLE table1 ( _id INT , doc JSON ) |
| 20 |
|
| 21 |
0 rows affected |
| 22 |
|
| 23 |
command ok |
| 24 |
Mysqlx.Sql.StmtExecuteOk { |
| 25 |
} |
| 26 |
|
| 27 |
RUN INSERT INTO xplugintest.table2(doc) VALUES('{"col1":"01234567890123456789","_id":0}') |
| 28 |
|
| 29 |
1 rows affected |
| 30 |
Mysqlx.Sql.StmtExecuteOk { |
| 31 |
} |
| 32 |
|
| 33 |
RUN SHOW CREATE TABLE xplugintest.table2 |
| 34 |
Table Create Table |
| 35 |
table2 CREATE TABLE `table2` ( |
| 36 |
`doc` json DEFAULT NULL, |
| 37 |
`_id` varbinary(32) GENERATED ALWAYS AS (json_unquote(json_extract(`doc`,_utf8mb4'$._id'))) STORED NOT NULL, |
| 38 |
`_json_schema` json GENERATED ALWAYS AS (_utf8mb4'{"type":"object"}') VIRTUAL, |
| 39 |
`$ix_t13_r_5E11219941D8F091BF6F252A48E0EEAA9D734FF9` text GENERATED ALWAYS AS (json_unquote(json_extract(`doc`,_utf8mb4'$.col1'))) VIRTUAL NOT NULL, |
| 40 |
`$ix_i_1C70785A292B9A2762EFA186DFCFB4F03C660E7F` int GENERATED ALWAYS AS (json_extract(`doc`,_utf8mb4'$.col2')) VIRTUAL, |
| 41 |
PRIMARY KEY (`_id`), |
| 42 |
UNIQUE KEY `col1_index` (`$ix_t13_r_5E11219941D8F091BF6F252A48E0EEAA9D734FF9`(13)), |
| 43 |
KEY `col2_index` (`$ix_i_1C70785A292B9A2762EFA186DFCFB4F03C660E7F`), |
| 44 |
CONSTRAINT `$val_strict_8A6DECD6D7FCE389DA6206C4247042D2D76E08AD` CHECK (json_schema_valid(`_json_schema`,`doc`)) /*!80016 NOT ENFORCED */ |
| 45 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
| 46 |
0 rows affected |
| 47 |
RUN INSERT INTO xplugintest.table2(doc) VALUES('{"col1":"val1","col2":101,"_id":1}') |
| 48 |
|
| 49 |
1 rows affected |
| 50 |
RUN INSERT INTO xplugintest.table2(doc) VALUES('{"col1":"val1","col2":102,"_id":2}') |
| 51 |
While executing INSERT INTO xplugintest.table2(doc) VALUES('{"col1":"val1","col2":102,"_id":2}'): |
| 52 |
Got expected error: Duplicate entry 'val1' for key 'table2.col1_index' (code 1062) |
| 53 |
RUN INSERT INTO xplugintest.table2(doc) VALUES('{"col2":103,"_id":3}') |
| 54 |
While executing INSERT INTO xplugintest.table2(doc) VALUES('{"col2":103,"_id":3}'): |
| 55 |
Got expected error: Column '$ix_t13_r_5E11219941D8F091BF6F252A48E0EEAA9D734FF9' cannot be null (code 1048) |
| 56 |
RUN SELECT * FROM xplugintest.table2 |
| 57 |
doc _id _json_schema $ix_t13_r_5E11219941D8F091BF6F252A48E0EEAA9D734FF9 $ix_i_1C70785A292B9A2762EFA186DFCFB4F03C660E7F |
| 58 |
{"_id": 0, "col1": "01234567890123456789"} 0 {"type": "object"} 01234567890123456789 null |
| 59 |
{"_id": 1, "col1": "val1", "col2": 101} 1 {"type": "object"} val1 101 |
| 60 |
0 rows affected |
| 61 |
RUN INSERT INTO xplugintest.table2(doc) VALUES('{"col1":"val4","col2":102,"_id":4}') |
| 62 |
|
| 63 |
1 rows affected |
| 64 |
RUN INSERT INTO xplugintest.table2(doc) VALUES('{"col1":"val5","_id":5}') |
| 65 |
|
| 66 |
1 rows affected |
| 67 |
RUN SELECT * FROM xplugintest.table2 |
| 68 |
doc _id _json_schema $ix_t13_r_5E11219941D8F091BF6F252A48E0EEAA9D734FF9 $ix_i_1C70785A292B9A2762EFA186DFCFB4F03C660E7F |
| 69 |
{"_id": 0, "col1": "01234567890123456789"} 0 {"type": "object"} 01234567890123456789 null |
| 70 |
{"_id": 1, "col1": "val1", "col2": 101} 1 {"type": "object"} val1 101 |
| 71 |
{"_id": 4, "col1": "val4", "col2": 102} 4 {"type": "object"} val4 102 |
| 72 |
{"_id": 5, "col1": "val5"} 5 {"type": "object"} val5 null |
| 73 |
0 rows affected |
| 74 |
RUN SELECT _id,doc, CONCAT("Prefix",`$ix_t13_r_5E11219941D8F091BF6F252A48E0EEAA9D734FF9`) , `$ix_i_1C70785A292B9A2762EFA186DFCFB4F03C660E7F` |
| 75 |
FROM xplugintest.table2 |
| 76 |
_id doc CONCAT("Prefix",`$ix_t13_r_5E11219941D8F091BF6F252A48E0EEAA9D734FF9`) $ix_i_1C70785A292B9A2762EFA186DFCFB4F03C660E7F |
| 77 |
0 {"_id": 0, "col1": "01234567890123456789"} Prefix01234567890123456789 null |
| 78 |
1 {"_id": 1, "col1": "val1", "col2": 101} Prefixval1 101 |
| 79 |
4 {"_id": 4, "col1": "val4", "col2": 102} Prefixval4 102 |
| 80 |
5 {"_id": 5, "col1": "val5"} Prefixval5 null |
| 81 |
0 rows affected |
| 82 |
RUN INSERT INTO xplugintest.table2(doc) VALUES('{"col1":"val6","col2":"non_int_val","_id":6}') |
| 83 |
While executing INSERT INTO xplugintest.table2(doc) VALUES('{"col1":"val6","col2":"non_int_val","_id":6}'): |
| 84 |
Got expected error: Invalid JSON value for CAST to INTEGER from column json_extract at row 1 (code 3156) |
| 85 |
Mysqlx.Error { |
| 86 |
severity: ERROR |
| 87 |
code: 1061 |
| 88 |
msg: "Duplicate key name \'col2_index\'" |
| 89 |
sql_state: "42000" |
| 90 |
} |
| 91 |
|
| 92 |
RUN ALTER TABLE xplugintest.table2 ADD COLUMN `$ix_t13_bf29f74d5ecec695774cb5b3f1ff979e7643bf36` TEXT |
| 93 |
|
| 94 |
0 rows affected |
| 95 |
Records: 0 Duplicates: 0 Warnings: 0 |
| 96 |
Mysqlx.Sql.StmtExecuteOk { |
| 97 |
} |
| 98 |
|
| 99 |
Mysqlx.Sql.StmtExecuteOk { |
| 100 |
} |
| 101 |
|
| 102 |
Mysqlx.Error { |
| 103 |
severity: ERROR |
| 104 |
code: 5017 |
| 105 |
msg: "Invalid value for argument \'fields.field\'" |
| 106 |
sql_state: "HY000" |
| 107 |
} |
| 108 |
|
| 109 |
RUN SHOW CREATE TABLE xplugintest.table2 |
| 110 |
Table Create Table |
| 111 |
table2 CREATE TABLE `table2` ( |
| 112 |
`doc` json DEFAULT NULL, |
| 113 |
`_id` varbinary(32) GENERATED ALWAYS AS (json_unquote(json_extract(`doc`,_utf8mb4'$._id'))) STORED NOT NULL, |
| 114 |
`_json_schema` json GENERATED ALWAYS AS (_utf8mb4'{"type":"object"}') VIRTUAL, |
| 115 |
`$ix_t13_r_5E11219941D8F091BF6F252A48E0EEAA9D734FF9` text GENERATED ALWAYS AS (json_unquote(json_extract(`doc`,_utf8mb4'$.col1'))) VIRTUAL NOT NULL, |
| 116 |
`$ix_i_1C70785A292B9A2762EFA186DFCFB4F03C660E7F` int GENERATED ALWAYS AS (json_extract(`doc`,_utf8mb4'$.col2')) VIRTUAL, |
| 117 |
`$ix_t13_bf29f74d5ecec695774cb5b3f1ff979e7643bf36` text, |
| 118 |
`$ix_t13_8B49C928244561F5DACBE63B030ADA2983C76BFF` text GENERATED ALWAYS AS (json_unquote(json_extract(`doc`,_utf8mb4'$.col3'))) VIRTUAL, |
| 119 |
`$ix_i_ED8EA5BF0D44065A674B92033FC24920B41C5F42` int GENERATED ALWAYS AS (json_extract(`doc`,_utf8mb4'$._id')) VIRTUAL, |
| 120 |
PRIMARY KEY (`_id`), |
| 121 |
UNIQUE KEY `col1_index` (`$ix_t13_r_5E11219941D8F091BF6F252A48E0EEAA9D734FF9`(13)), |
| 122 |
KEY `col2_index` (`$ix_i_1C70785A292B9A2762EFA186DFCFB4F03C660E7F`), |
| 123 |
KEY `col3_index` (`$ix_t13_8B49C928244561F5DACBE63B030ADA2983C76BFF`(13)), |
| 124 |
KEY `_id_index` (`$ix_i_ED8EA5BF0D44065A674B92033FC24920B41C5F42`), |
| 125 |
CONSTRAINT `$val_strict_8A6DECD6D7FCE389DA6206C4247042D2D76E08AD` CHECK (json_schema_valid(`_json_schema`,`doc`)) /*!80016 NOT ENFORCED */ |
| 126 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
| 127 |
0 rows affected |
| 128 |
RUN ALTER TABLE xplugintest.table2 DROP INDEX `col1_index` |
| 129 |
|
| 130 |
0 rows affected |
| 131 |
Records: 0 Duplicates: 0 Warnings: 0 |
| 132 |
RUN ALTER TABLE xplugintest.table2 DROP COLUMN `$ix_t13_r_5E11219941D8F091BF6F252A48E0EEAA9D734FF9` |
| 133 |
|
| 134 |
0 rows affected |
| 135 |
Records: 0 Duplicates: 0 Warnings: 0 |
| 136 |
RUN SHOW CREATE TABLE xplugintest.table2 |
| 137 |
Table Create Table |
| 138 |
table2 CREATE TABLE `table2` ( |
| 139 |
`doc` json DEFAULT NULL, |
| 140 |
`_id` varbinary(32) GENERATED ALWAYS AS (json_unquote(json_extract(`doc`,_utf8mb4'$._id'))) STORED NOT NULL, |
| 141 |
`_json_schema` json GENERATED ALWAYS AS (_utf8mb4'{"type":"object"}') VIRTUAL, |
| 142 |
`$ix_i_1C70785A292B9A2762EFA186DFCFB4F03C660E7F` int GENERATED ALWAYS AS (json_extract(`doc`,_utf8mb4'$.col2')) VIRTUAL, |
| 143 |
`$ix_t13_bf29f74d5ecec695774cb5b3f1ff979e7643bf36` text, |
| 144 |
`$ix_t13_8B49C928244561F5DACBE63B030ADA2983C76BFF` text GENERATED ALWAYS AS (json_unquote(json_extract(`doc`,_utf8mb4'$.col3'))) VIRTUAL, |
| 145 |
`$ix_i_ED8EA5BF0D44065A674B92033FC24920B41C5F42` int GENERATED ALWAYS AS (json_extract(`doc`,_utf8mb4'$._id')) VIRTUAL, |
| 146 |
PRIMARY KEY (`_id`), |
| 147 |
KEY `col2_index` (`$ix_i_1C70785A292B9A2762EFA186DFCFB4F03C660E7F`), |
| 148 |
KEY `col3_index` (`$ix_t13_8B49C928244561F5DACBE63B030ADA2983C76BFF`(13)), |
| 149 |
KEY `_id_index` (`$ix_i_ED8EA5BF0D44065A674B92033FC24920B41C5F42`), |
| 150 |
CONSTRAINT `$val_strict_8A6DECD6D7FCE389DA6206C4247042D2D76E08AD` CHECK (json_schema_valid(`_json_schema`,`doc`)) /*!80016 NOT ENFORCED */ |
| 151 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
| 152 |
0 rows affected |
| 153 |
RUN SELECT * FROM xplugintest.table2 |
| 154 |
doc _id _json_schema $ix_i_1C70785A292B9A2762EFA186DFCFB4F03C660E7F $ix_t13_bf29f74d5ecec695774cb5b3f1ff979e7643bf36 $ix_t13_8B49C928244561F5DACBE63B030ADA2983C76BFF $ix_i_ED8EA5BF0D44065A674B92033FC24920B41C5F42 |
| 155 |
{"_id": 0, "col1": "01234567890123456789"} 0 {"type": "object"} null null null 0 |
| 156 |
{"_id": 1, "col1": "val1", "col2": 101} 1 {"type": "object"} 101 null null 1 |
| 157 |
{"_id": 4, "col1": "val4", "col2": 102} 4 {"type": "object"} 102 null null 4 |
| 158 |
{"_id": 5, "col1": "val5"} 5 {"type": "object"} null null null 5 |
| 159 |
0 rows affected |
| 160 |
RUN ALTER TABLE xplugintest.table2 ADD COLUMN `$col1_ix_t13` text |
| 161 |
GENERATED ALWAYS AS (LEFT(JSON_UNQUOTE(JSON_EXTRACT(doc, '$.col1')), 13)) STORED |
| 162 |
|
| 163 |
4 rows affected |
| 164 |
Records: 4 Duplicates: 0 Warnings: 0 |
| 165 |
RUN SHOW CREATE TABLE xplugintest.table2 |
| 166 |
Table Create Table |
| 167 |
table2 CREATE TABLE `table2` ( |
| 168 |
`doc` json DEFAULT NULL, |
| 169 |
`_id` varbinary(32) GENERATED ALWAYS AS (json_unquote(json_extract(`doc`,_utf8mb4'$._id'))) STORED NOT NULL, |
| 170 |
`_json_schema` json GENERATED ALWAYS AS (_utf8mb4'{"type":"object"}') VIRTUAL, |
| 171 |
`$ix_i_1C70785A292B9A2762EFA186DFCFB4F03C660E7F` int GENERATED ALWAYS AS (json_extract(`doc`,_utf8mb4'$.col2')) VIRTUAL, |
| 172 |
`$ix_t13_bf29f74d5ecec695774cb5b3f1ff979e7643bf36` text, |
| 173 |
`$ix_t13_8B49C928244561F5DACBE63B030ADA2983C76BFF` text GENERATED ALWAYS AS (json_unquote(json_extract(`doc`,_utf8mb4'$.col3'))) VIRTUAL, |
| 174 |
`$ix_i_ED8EA5BF0D44065A674B92033FC24920B41C5F42` int GENERATED ALWAYS AS (json_extract(`doc`,_utf8mb4'$._id')) VIRTUAL, |
| 175 |
`$col1_ix_t13` text GENERATED ALWAYS AS (left(json_unquote(json_extract(`doc`,_utf8mb4'$.col1')),13)) STORED, |
| 176 |
PRIMARY KEY (`_id`), |
| 177 |
KEY `col2_index` (`$ix_i_1C70785A292B9A2762EFA186DFCFB4F03C660E7F`), |
| 178 |
KEY `col3_index` (`$ix_t13_8B49C928244561F5DACBE63B030ADA2983C76BFF`(13)), |
| 179 |
KEY `_id_index` (`$ix_i_ED8EA5BF0D44065A674B92033FC24920B41C5F42`), |
| 180 |
CONSTRAINT `$val_strict_8A6DECD6D7FCE389DA6206C4247042D2D76E08AD` CHECK (json_schema_valid(`_json_schema`,`doc`)) /*!80016 NOT ENFORCED */ |
| 181 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
| 182 |
0 rows affected |
| 183 |
RUN SELECT * FROM xplugintest.table2 |
| 184 |
doc _id _json_schema $ix_i_1C70785A292B9A2762EFA186DFCFB4F03C660E7F $ix_t13_bf29f74d5ecec695774cb5b3f1ff979e7643bf36 $ix_t13_8B49C928244561F5DACBE63B030ADA2983C76BFF $ix_i_ED8EA5BF0D44065A674B92033FC24920B41C5F42 $col1_ix_t13 |
| 185 |
{"_id": 0, "col1": "01234567890123456789"} 0 {"type": "object"} null null null 0 0123456789012 |
| 186 |
{"_id": 1, "col1": "val1", "col2": 101} 1 {"type": "object"} 101 null null 1 val1 |
| 187 |
{"_id": 4, "col1": "val4", "col2": 102} 4 {"type": "object"} 102 null null 4 val4 |
| 188 |
{"_id": 5, "col1": "val5"} 5 {"type": "object"} null null null 5 val5 |
| 189 |
0 rows affected |
| 190 |
Mysqlx.Sql.StmtExecuteOk { |
| 191 |
} |
| 192 |
|
| 193 |
RUN SHOW CREATE TABLE xplugintest.table2 |
| 194 |
Table Create Table |
| 195 |
table2 CREATE TABLE `table2` ( |
| 196 |
`doc` json DEFAULT NULL, |
| 197 |
`_id` varbinary(32) GENERATED ALWAYS AS (json_unquote(json_extract(`doc`,_utf8mb4'$._id'))) STORED NOT NULL, |
| 198 |
`_json_schema` json GENERATED ALWAYS AS (_utf8mb4'{"type":"object"}') VIRTUAL, |
| 199 |
`$ix_i_1C70785A292B9A2762EFA186DFCFB4F03C660E7F` int GENERATED ALWAYS AS (json_extract(`doc`,_utf8mb4'$.col2')) VIRTUAL, |
| 200 |
`$ix_t13_bf29f74d5ecec695774cb5b3f1ff979e7643bf36` text, |
| 201 |
`$ix_t13_8B49C928244561F5DACBE63B030ADA2983C76BFF` text GENERATED ALWAYS AS (json_unquote(json_extract(`doc`,_utf8mb4'$.col3'))) VIRTUAL, |
| 202 |
`$ix_i_ED8EA5BF0D44065A674B92033FC24920B41C5F42` int GENERATED ALWAYS AS (json_extract(`doc`,_utf8mb4'$._id')) VIRTUAL, |
| 203 |
`$col1_ix_t13` text GENERATED ALWAYS AS (left(json_unquote(json_extract(`doc`,_utf8mb4'$.col1')),13)) STORED, |
| 204 |
`$ix_i_19A716031E8396A7049831D1FFB53409FB4689A6` int GENERATED ALWAYS AS (json_extract(`doc`,_utf8mb4'$.col9')) VIRTUAL, |
| 205 |
PRIMARY KEY (`_id`), |
| 206 |
KEY `col2_index` (`$ix_i_1C70785A292B9A2762EFA186DFCFB4F03C660E7F`), |
| 207 |
KEY `col3_index` (`$ix_t13_8B49C928244561F5DACBE63B030ADA2983C76BFF`(13)), |
| 208 |
KEY `_id_index` (`$ix_i_ED8EA5BF0D44065A674B92033FC24920B41C5F42`), |
| 209 |
KEY `_id` (`$ix_i_19A716031E8396A7049831D1FFB53409FB4689A6`), |
| 210 |
CONSTRAINT `$val_strict_8A6DECD6D7FCE389DA6206C4247042D2D76E08AD` CHECK (json_schema_valid(`_json_schema`,`doc`)) /*!80016 NOT ENFORCED */ |
| 211 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
| 212 |
0 rows affected |
| 213 |
Mysqlx.Error { |
| 214 |
severity: ERROR |
| 215 |
code: 5015 |
| 216 |
msg: "Invalid number of arguments, expected value for \'name\'" |
| 217 |
sql_state: "HY000" |
| 218 |
} |
| 219 |
|
| 220 |
RUN TRUNCATE xplugintest.table2 |
| 221 |
|
| 222 |
0 rows affected |
| 223 |
RUN INSERT INTO xplugintest.table2(doc) VALUES('{"F1":1, "F2":"abcd", "F3":1000, "_id":0}') |
| 224 |
|
| 225 |
1 rows affected |
| 226 |
Mysqlx.Sql.StmtExecuteOk { |
| 227 |
} |
| 228 |
|
| 229 |
Create index on two fields |
| 230 |
Mysqlx.Sql.StmtExecuteOk { |
| 231 |
} |
| 232 |
|
| 233 |
RUN TRUNCATE xplugintest.table2 |
| 234 |
|
| 235 |
0 rows affected |
| 236 |
RUN INSERT INTO xplugintest.table2(doc) VALUES('{"F2":"REQUIRED", "F3":"1", "KeyName_VeryLongKeyNameWithKeyNameLength_FiFtyFourAndEvenABitLonger": "abcdefgh", "_id":1}') |
| 237 |
|
| 238 |
1 rows affected |
| 239 |
Mysqlx.Sql.StmtExecuteOk { |
| 240 |
} |
| 241 |
|
| 242 |
RUN SHOW CREATE TABLE xplugintest.table2 |
| 243 |
Table Create Table |
| 244 |
table2 CREATE TABLE `table2` ( |
| 245 |
`doc` json DEFAULT NULL, |
| 246 |
`_id` varbinary(32) GENERATED ALWAYS AS (json_unquote(json_extract(`doc`,_utf8mb4'$._id'))) STORED NOT NULL, |
| 247 |
`_json_schema` json GENERATED ALWAYS AS (_utf8mb4'{"type":"object"}') VIRTUAL, |
| 248 |
`$ix_i_1C70785A292B9A2762EFA186DFCFB4F03C660E7F` int GENERATED ALWAYS AS (json_extract(`doc`,_utf8mb4'$.col2')) VIRTUAL, |
| 249 |
`$ix_t13_bf29f74d5ecec695774cb5b3f1ff979e7643bf36` text, |
| 250 |
`$ix_t13_8B49C928244561F5DACBE63B030ADA2983C76BFF` text GENERATED ALWAYS AS (json_unquote(json_extract(`doc`,_utf8mb4'$.col3'))) VIRTUAL, |
| 251 |
`$ix_i_ED8EA5BF0D44065A674B92033FC24920B41C5F42` int GENERATED ALWAYS AS (json_extract(`doc`,_utf8mb4'$._id')) VIRTUAL, |
| 252 |
`$col1_ix_t13` text GENERATED ALWAYS AS (left(json_unquote(json_extract(`doc`,_utf8mb4'$.col1')),13)) STORED, |
| 253 |
`$ix_i_19A716031E8396A7049831D1FFB53409FB4689A6` int GENERATED ALWAYS AS (json_extract(`doc`,_utf8mb4'$.col9')) VIRTUAL, |
| 254 |
`$ix_bt767_8870EF04DBC5C827B87C34BF582F39442A78BBD9` blob GENERATED ALWAYS AS (json_unquote(json_extract(`doc`,_utf8mb4'$.F2'))) VIRTUAL, |
| 255 |
`$ix_ib_r_755774C7760C6184F154B25E88F81712F65BC712` bigint GENERATED ALWAYS AS (json_extract(`doc`,_utf8mb4'$.F3')) VIRTUAL NOT NULL, |
| 256 |
`$ix_bt767_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9` blob GENERATED ALWAYS AS (json_unquote(json_extract(`doc`,_utf8mb4'$.F2'))) VIRTUAL NOT NULL, |
| 257 |
`$ix_bt3000_EED9F4FDE93464D65631C14643D3B9F9E401EA43` blob GENERATED ALWAYS AS (json_unquote(json_extract(`doc`,_utf8mb4'$.KeyName_VeryLongKeyNameWithKeyNameLength_FiFtyFourAndEvenABitLonger'))) VIRTUAL, |
| 258 |
PRIMARY KEY (`_id`), |
| 259 |
UNIQUE KEY `iX3` (`$ix_ib_r_755774C7760C6184F154B25E88F81712F65BC712`,`$ix_bt767_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9`(767)), |
| 260 |
KEY `col2_index` (`$ix_i_1C70785A292B9A2762EFA186DFCFB4F03C660E7F`), |
| 261 |
KEY `col3_index` (`$ix_t13_8B49C928244561F5DACBE63B030ADA2983C76BFF`(13)), |
| 262 |
KEY `_id_index` (`$ix_i_ED8EA5BF0D44065A674B92033FC24920B41C5F42`), |
| 263 |
KEY `_id` (`$ix_i_19A716031E8396A7049831D1FFB53409FB4689A6`), |
| 264 |
KEY `iX1` (`$ix_bt767_8870EF04DBC5C827B87C34BF582F39442A78BBD9`(767)), |
| 265 |
KEY `iXLong` (`$ix_bt3000_EED9F4FDE93464D65631C14643D3B9F9E401EA43`(3000)), |
| 266 |
CONSTRAINT `$val_strict_8A6DECD6D7FCE389DA6206C4247042D2D76E08AD` CHECK (json_schema_valid(`_json_schema`,`doc`)) /*!80016 NOT ENFORCED */ |
| 267 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
| 268 |
0 rows affected |
| 269 |
RUN SELECT * FROM xplugintest.table2 |
| 270 |
doc _id _json_schema $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 |
| 271 |
{"F2": "REQUIRED", "F3": "1", "_id": 1, "KeyName_VeryLongKeyNameWithKeyNameLength_FiFtyFourAndEvenABitLonger": "abcdefgh"} 1 {"type": "object"} null null null 1 null null REQUIRED 1 REQUIRED abcdefgh |
| 272 |
0 rows affected |
| 273 |
Mysqlx.Sql.StmtExecuteOk { |
| 274 |
} |
| 275 |
|
| 276 |
Mysqlx.Error { |
| 277 |
severity: ERROR |
| 278 |
code: 5017 |
| 279 |
msg: "Invalid value for argument \'fields.field\'" |
| 280 |
sql_state: "HY000" |
| 281 |
} |
| 282 |
|
| 283 |
Mysqlx.Sql.StmtExecuteOk { |
| 284 |
} |
| 285 |
|
| 286 |
Mysqlx.Sql.StmtExecuteOk { |
| 287 |
} |
| 288 |
|
| 289 |
Mysqlx.Error { |
| 290 |
severity: ERROR |
| 291 |
code: 5017 |
| 292 |
msg: "Invalid value for argument \'fields.field\'" |
| 293 |
sql_state: "HY000" |
| 294 |
} |
| 295 |
|
| 296 |
Mysqlx.Sql.StmtExecuteOk { |
| 297 |
} |
| 298 |
|
| 299 |
Mysqlx.Sql.StmtExecuteOk { |
| 300 |
} |
| 301 |
|
| 302 |
Mysqlx.Sql.StmtExecuteOk { |
| 303 |
} |
| 304 |
|
| 305 |
Mysqlx.Error { |
| 306 |
severity: ERROR |
| 307 |
code: 5017 |
| 308 |
msg: "Invalid value for argument \'fields.field\'" |
| 309 |
sql_state: "HY000" |
| 310 |
} |
| 311 |
|
| 312 |
Mysqlx.Error { |
| 313 |
severity: ERROR |
| 314 |
code: 5017 |
| 315 |
msg: "Invalid value for argument \'fields.field\'" |
| 316 |
sql_state: "HY000" |
| 317 |
} |
| 318 |
|
| 319 |
Mysqlx.Error { |
| 320 |
severity: ERROR |
| 321 |
code: 5017 |
| 322 |
msg: "Invalid value for argument \'fields.field\'" |
| 323 |
sql_state: "HY000" |
| 324 |
} |
| 325 |
|
| 326 |
Mysqlx.Error { |
| 327 |
severity: ERROR |
| 328 |
code: 5017 |
| 329 |
msg: "Invalid value for argument \'fields.field\'" |
| 330 |
sql_state: "HY000" |
| 331 |
} |
| 332 |
|
| 333 |
Mysqlx.Error { |
| 334 |
severity: ERROR |
| 335 |
code: 5017 |
| 336 |
msg: "Invalid value for argument \'fields.field\'" |
| 337 |
sql_state: "HY000" |
| 338 |
} |
| 339 |
|
| 340 |
Mysqlx.Sql.StmtExecuteOk { |
| 341 |
} |
| 342 |
|
| 343 |
Document path 2k long |
| 344 |
Mysqlx.Sql.StmtExecuteOk { |
| 345 |
} |
| 346 |
|
| 347 |
RUN SHOW CREATE TABLE xplugintest.table3 |
| 348 |
Table Create Table |
| 349 |
table3 CREATE TABLE `table3` ( |
| 350 |
`doc` json DEFAULT NULL, |
| 351 |
`_id` varbinary(32) GENERATED ALWAYS AS (json_unquote(json_extract(`doc`,_utf8mb4'$._id'))) STORED NOT NULL, |
| 352 |
`_json_schema` json GENERATED ALWAYS AS (_utf8mb4'{"type":"object"}') VIRTUAL, |
| 353 |
`$ix_i_r_366242F9B1A1445156C6129A699299650D68D08A` int GENERATED ALWAYS AS (json_extract(`doc`,_utf8mb4'$')) VIRTUAL NOT NULL, |
| 354 |
`$ix_i_r_DB5D40CADB1AF49035A1BEE0FFF0C8B4CA357CC2` int GENERATED ALWAYS AS (json_extract(`doc`,_utf8mb4'$.`a#1`')) VIRTUAL NOT NULL, |
| 355 |
`$ix_i_r_C30BDD20F69BA78166A26D8620EDA8C634E8BDBD` int GENERATED ALWAYS AS (json_extract(`doc`,_utf8mb4'$.`a\'1`')) VIRTUAL NOT NULL, |
| 356 |
`$ix_i_r_7C10F13A9677599586BF002593F6406D5258416F` int GENERATED ALWAYS AS (json_extract(`doc`,_utf8mb4'$.`a\\\'1`')) VIRTUAL NOT NULL, |
| 357 |
`$ix_i_r_1928696E67DA726A0C9E86E760E04CDFE4CA77B2` int GENERATED ALWAYS AS (json_extract(`doc`,_utf8mb4'$.`a\\\\\'1`')) VIRTUAL NOT NULL, |
| 358 |
`$ix_i_r_0B6D1F04DD08A4AB089A8F9D3B079ECFDFBBD179` int GENERATED ALWAYS AS (json_extract(`doc`,_utf8mb4'$.`b))` virtual not null; drop database xplugintest; alter table table3 add column x int GENERATED ALWAYS AS (JSON_EXTRACT(doc, $.`c`')) VIRTUAL NOT NULL, |
| 359 |
`$ix_i_r_9BC5A3EB89CA6B17C3272000A817E7A813E3986B` int GENERATED ALWAYS AS (json_extract(`doc`,_utf8mb4'$.a0123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678')) VIRTUAL NOT NULL, |
| 360 |
PRIMARY KEY (`_id`), |
| 361 |
UNIQUE KEY `IX0` (`$ix_i_r_366242F9B1A1445156C6129A699299650D68D08A`), |
| 362 |
UNIQUE KEY `IX1` (`$ix_i_r_DB5D40CADB1AF49035A1BEE0FFF0C8B4CA357CC2`), |
| 363 |
UNIQUE KEY `IX3` (`$ix_i_r_C30BDD20F69BA78166A26D8620EDA8C634E8BDBD`), |
| 364 |
UNIQUE KEY `IX4` (`$ix_i_r_7C10F13A9677599586BF002593F6406D5258416F`), |
| 365 |
UNIQUE KEY `IX5` (`$ix_i_r_1928696E67DA726A0C9E86E760E04CDFE4CA77B2`), |
| 366 |
UNIQUE KEY `IX11` (`$ix_i_r_0B6D1F04DD08A4AB089A8F9D3B079ECFDFBBD179`), |
| 367 |
UNIQUE KEY `IXLong1` (`$ix_i_r_9BC5A3EB89CA6B17C3272000A817E7A813E3986B`), |
| 368 |
CONSTRAINT `$val_strict_277216D0C5EE89D2C81687894B832AF376E26465` CHECK (json_schema_valid(`_json_schema`,`doc`)) /*!80016 NOT ENFORCED */ |
| 369 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
| 370 |
0 rows affected |
| 371 |
|
| 372 |
command ok |
| 373 |
Mysqlx.Sql.StmtExecuteOk { |
| 374 |
} |
| 375 |
|
| 376 |
Mysqlx.Sql.StmtExecuteOk { |
| 377 |
} |
| 378 |
|
| 379 |
Mysqlx.Sql.StmtExecuteOk { |
| 380 |
} |
| 381 |
|
| 382 |
Mysqlx.Sql.StmtExecuteOk { |
| 383 |
} |
| 384 |
|
| 385 |
Mysqlx.Sql.StmtExecuteOk { |
| 386 |
} |
| 387 |
|
| 388 |
Mysqlx.Sql.StmtExecuteOk { |
| 389 |
} |
| 390 |
|
| 391 |
Mysqlx.Sql.StmtExecuteOk { |
| 392 |
} |
| 393 |
|
| 394 |
Mysqlx.Sql.StmtExecuteOk { |
| 395 |
} |
| 396 |
|
| 397 |
Mysqlx.Sql.StmtExecuteOk { |
| 398 |
} |
| 399 |
|
| 400 |
Mysqlx.Sql.StmtExecuteOk { |
| 401 |
} |
| 402 |
|
| 403 |
Mysqlx.Sql.StmtExecuteOk { |
| 404 |
} |
| 405 |
|
| 406 |
Mysqlx.Sql.StmtExecuteOk { |
| 407 |
} |
| 408 |
|
| 409 |
Mysqlx.Sql.StmtExecuteOk { |
| 410 |
} |
| 411 |
|
| 412 |
Mysqlx.Sql.StmtExecuteOk { |
| 413 |
} |
| 414 |
|
| 415 |
Mysqlx.Sql.StmtExecuteOk { |
| 416 |
} |
| 417 |
|
| 418 |
Mysqlx.Sql.StmtExecuteOk { |
| 419 |
} |
| 420 |
|
| 421 |
Mysqlx.Sql.StmtExecuteOk { |
| 422 |
} |
| 423 |
|
| 424 |
Mysqlx.Sql.StmtExecuteOk { |
| 425 |
} |
| 426 |
|
| 427 |
Mysqlx.Sql.StmtExecuteOk { |
| 428 |
} |
| 429 |
|
| 430 |
Mysqlx.Sql.StmtExecuteOk { |
| 431 |
} |
| 432 |
|
| 433 |
Mysqlx.Sql.StmtExecuteOk { |
| 434 |
} |
| 435 |
|
| 436 |
Mysqlx.Sql.StmtExecuteOk { |
| 437 |
} |
| 438 |
|
| 439 |
Mysqlx.Sql.StmtExecuteOk { |
| 440 |
} |
| 441 |
|
| 442 |
Mysqlx.Sql.StmtExecuteOk { |
| 443 |
} |
| 444 |
|
| 445 |
Mysqlx.Sql.StmtExecuteOk { |
| 446 |
} |
| 447 |
|
| 448 |
Mysqlx.Sql.StmtExecuteOk { |
| 449 |
} |
| 450 |
|
| 451 |
Mysqlx.Sql.StmtExecuteOk { |
| 452 |
} |
| 453 |
|
| 454 |
Mysqlx.Sql.StmtExecuteOk { |
| 455 |
} |
| 456 |
|
| 457 |
Mysqlx.Sql.StmtExecuteOk { |
| 458 |
} |
| 459 |
|
| 460 |
Mysqlx.Sql.StmtExecuteOk { |
| 461 |
} |
| 462 |
|
| 463 |
RUN ANALYZE TABLE xplugintest.col_myp337 |
| 464 |
Table Op Msg_type Msg_text |
| 465 |
xplugintest.col_myp337 analyze status OK |
| 466 |
0 rows affected |
| 467 |
RUN SHOW INDEX from xplugintest.col_myp337 where Key_name rlike '^index_[12][0-9]*' |
| 468 |
Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment Visible Expression |
| 469 |
col_myp337 0 index_11 1 $ix_t11_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 11 null BTREE YES null |
| 470 |
col_myp337 0 index_11 2 $ix_t11_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 11 null YES BTREE YES null |
| 471 |
col_myp337 0 index_11 3 $ix_i11_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE YES null |
| 472 |
col_myp337 0 index_11 4 $ix_i11_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE YES null |
| 473 |
col_myp337 0 index_11 5 $ix_bt11_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 11 null BTREE YES null |
| 474 |
col_myp337 0 index_11 6 $ix_bt11_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 11 null YES BTREE YES null |
| 475 |
col_myp337 0 index_12 1 $ix_t12_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 12 null BTREE YES null |
| 476 |
col_myp337 0 index_12 2 $ix_t12_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 12 null YES BTREE YES null |
| 477 |
col_myp337 0 index_12 3 $ix_i12_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE YES null |
| 478 |
col_myp337 0 index_12 4 $ix_i12_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE YES null |
| 479 |
col_myp337 0 index_12 5 $ix_bt12_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 12 null BTREE YES null |
| 480 |
col_myp337 0 index_12 6 $ix_bt12_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 12 null YES BTREE YES null |
| 481 |
col_myp337 0 index_13 1 $ix_t13_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 13 null BTREE YES null |
| 482 |
col_myp337 0 index_13 2 $ix_t13_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 13 null YES BTREE YES null |
| 483 |
col_myp337 0 index_13 3 $ix_i13_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE YES null |
| 484 |
col_myp337 0 index_13 4 $ix_i13_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE YES null |
| 485 |
col_myp337 0 index_13 5 $ix_bt13_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 13 null BTREE YES null |
| 486 |
col_myp337 0 index_13 6 $ix_bt13_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 13 null YES BTREE YES null |
| 487 |
col_myp337 0 index_14 1 $ix_t14_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 14 null BTREE YES null |
| 488 |
col_myp337 0 index_14 2 $ix_t14_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 14 null YES BTREE YES null |
| 489 |
col_myp337 0 index_14 3 $ix_i14_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE YES null |
| 490 |
col_myp337 0 index_14 4 $ix_i14_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE YES null |
| 491 |
col_myp337 0 index_14 5 $ix_bt14_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 14 null BTREE YES null |
| 492 |
col_myp337 0 index_14 6 $ix_bt14_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 14 null YES BTREE YES null |
| 493 |
col_myp337 0 index_15 1 $ix_t15_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 15 null BTREE YES null |
| 494 |
col_myp337 0 index_15 2 $ix_t15_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 15 null YES BTREE YES null |
| 495 |
col_myp337 0 index_15 3 $ix_i15_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE YES null |
| 496 |
col_myp337 0 index_15 4 $ix_i15_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE YES null |
| 497 |
col_myp337 0 index_15 5 $ix_bt15_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 15 null BTREE YES null |
| 498 |
col_myp337 0 index_15 6 $ix_bt15_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 15 null YES BTREE YES null |
| 499 |
col_myp337 0 index_16 1 $ix_t16_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 16 null BTREE YES null |
| 500 |
col_myp337 0 index_16 2 $ix_t16_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 16 null YES BTREE YES null |
| 501 |
col_myp337 0 index_16 3 $ix_i16_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE YES null |
| 502 |
col_myp337 0 index_16 4 $ix_i16_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE YES null |
| 503 |
col_myp337 0 index_16 5 $ix_bt16_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 16 null BTREE YES null |
| 504 |
col_myp337 0 index_16 6 $ix_bt16_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 16 null YES BTREE YES null |
| 505 |
col_myp337 0 index_17 1 $ix_t17_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 17 null BTREE YES null |
| 506 |
col_myp337 0 index_17 2 $ix_t17_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 17 null YES BTREE YES null |
| 507 |
col_myp337 0 index_17 3 $ix_i17_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE YES null |
| 508 |
col_myp337 0 index_17 4 $ix_i17_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE YES null |
| 509 |
col_myp337 0 index_17 5 $ix_bt17_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 17 null BTREE YES null |
| 510 |
col_myp337 0 index_17 6 $ix_bt17_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 17 null YES BTREE YES null |
| 511 |
col_myp337 0 index_18 1 $ix_t18_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 18 null BTREE YES null |
| 512 |
col_myp337 0 index_18 2 $ix_t18_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 18 null YES BTREE YES null |
| 513 |
col_myp337 0 index_18 3 $ix_i18_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE YES null |
| 514 |
col_myp337 0 index_18 4 $ix_i18_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE YES null |
| 515 |
col_myp337 0 index_18 5 $ix_bt18_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 18 null BTREE YES null |
| 516 |
col_myp337 0 index_18 6 $ix_bt18_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 18 null YES BTREE YES null |
| 517 |
col_myp337 0 index_19 1 $ix_t19_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 19 null BTREE YES null |
| 518 |
col_myp337 0 index_19 2 $ix_t19_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 19 null YES BTREE YES null |
| 519 |
col_myp337 0 index_19 3 $ix_i19_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE YES null |
| 520 |
col_myp337 0 index_19 4 $ix_i19_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE YES null |
| 521 |
col_myp337 0 index_19 5 $ix_bt19_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 19 null BTREE YES null |
| 522 |
col_myp337 0 index_19 6 $ix_bt19_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 19 null YES BTREE YES null |
| 523 |
col_myp337 0 index_20 1 $ix_t20_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 20 null BTREE YES null |
| 524 |
col_myp337 0 index_20 2 $ix_t20_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 20 null YES BTREE YES null |
| 525 |
col_myp337 0 index_20 3 $ix_i20_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE YES null |
| 526 |
col_myp337 0 index_20 4 $ix_i20_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE YES null |
| 527 |
col_myp337 0 index_20 5 $ix_bt20_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 20 null BTREE YES null |
| 528 |
col_myp337 0 index_20 6 $ix_bt20_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 20 null YES BTREE YES null |
| 529 |
col_myp337 0 index_21 1 $ix_t21_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 21 null BTREE YES null |
| 530 |
col_myp337 0 index_21 2 $ix_t21_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 21 null YES BTREE YES null |
| 531 |
col_myp337 0 index_21 3 $ix_i21_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE YES null |
| 532 |
col_myp337 0 index_21 4 $ix_i21_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE YES null |
| 533 |
col_myp337 0 index_21 5 $ix_bt21_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 21 null BTREE YES null |
| 534 |
col_myp337 0 index_21 6 $ix_bt21_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 21 null YES BTREE YES null |
| 535 |
col_myp337 0 index_22 1 $ix_t22_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 22 null BTREE YES null |
| 536 |
col_myp337 0 index_22 2 $ix_t22_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 22 null YES BTREE YES null |
| 537 |
col_myp337 0 index_22 3 $ix_i22_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE YES null |
| 538 |
col_myp337 0 index_22 4 $ix_i22_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE YES null |
| 539 |
col_myp337 0 index_22 5 $ix_bt22_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 22 null BTREE YES null |
| 540 |
col_myp337 0 index_22 6 $ix_bt22_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 22 null YES BTREE YES null |
| 541 |
col_myp337 0 index_23 1 $ix_t23_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 23 null BTREE YES null |
| 542 |
col_myp337 0 index_23 2 $ix_t23_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 23 null YES BTREE YES null |
| 543 |
col_myp337 0 index_23 3 $ix_i23_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE YES null |
| 544 |
col_myp337 0 index_23 4 $ix_i23_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE YES null |
| 545 |
col_myp337 0 index_23 5 $ix_bt23_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 23 null BTREE YES null |
| 546 |
col_myp337 0 index_23 6 $ix_bt23_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 23 null YES BTREE YES null |
| 547 |
col_myp337 0 index_24 1 $ix_t24_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 24 null BTREE YES null |
| 548 |
col_myp337 0 index_24 2 $ix_t24_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 24 null YES BTREE YES null |
| 549 |
col_myp337 0 index_24 3 $ix_i24_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE YES null |
| 550 |
col_myp337 0 index_24 4 $ix_i24_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE YES null |
| 551 |
col_myp337 0 index_24 5 $ix_bt24_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 24 null BTREE YES null |
| 552 |
col_myp337 0 index_24 6 $ix_bt24_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 24 null YES BTREE YES null |
| 553 |
col_myp337 0 index_25 1 $ix_t25_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 25 null BTREE YES null |
| 554 |
col_myp337 0 index_25 2 $ix_t25_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 25 null YES BTREE YES null |
| 555 |
col_myp337 0 index_25 3 $ix_i25_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE YES null |
| 556 |
col_myp337 0 index_25 4 $ix_i25_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE YES null |
| 557 |
col_myp337 0 index_25 5 $ix_bt25_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 25 null BTREE YES null |
| 558 |
col_myp337 0 index_25 6 $ix_bt25_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 25 null YES BTREE YES null |
| 559 |
col_myp337 0 index_26 1 $ix_t26_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 26 null BTREE YES null |
| 560 |
col_myp337 0 index_26 2 $ix_t26_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 26 null YES BTREE YES null |
| 561 |
col_myp337 0 index_26 3 $ix_i26_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE YES null |
| 562 |
col_myp337 0 index_26 4 $ix_i26_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE YES null |
| 563 |
col_myp337 0 index_26 5 $ix_bt26_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 26 null BTREE YES null |
| 564 |
col_myp337 0 index_26 6 $ix_bt26_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 26 null YES BTREE YES null |
| 565 |
col_myp337 0 index_27 1 $ix_t27_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 27 null BTREE YES null |
| 566 |
col_myp337 0 index_27 2 $ix_t27_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 27 null YES BTREE YES null |
| 567 |
col_myp337 0 index_27 3 $ix_i27_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE YES null |
| 568 |
col_myp337 0 index_27 4 $ix_i27_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE YES null |
| 569 |
col_myp337 0 index_27 5 $ix_bt27_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 27 null BTREE YES null |
| 570 |
col_myp337 0 index_27 6 $ix_bt27_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 27 null YES BTREE YES null |
| 571 |
col_myp337 0 index_28 1 $ix_t28_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 28 null BTREE YES null |
| 572 |
col_myp337 0 index_28 2 $ix_t28_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 28 null YES BTREE YES null |
| 573 |
col_myp337 0 index_28 3 $ix_i28_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE YES null |
| 574 |
col_myp337 0 index_28 4 $ix_i28_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE YES null |
| 575 |
col_myp337 0 index_28 5 $ix_bt28_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 28 null BTREE YES null |
| 576 |
col_myp337 0 index_28 6 $ix_bt28_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 28 null YES BTREE YES null |
| 577 |
col_myp337 0 index_29 1 $ix_t29_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 29 null BTREE YES null |
| 578 |
col_myp337 0 index_29 2 $ix_t29_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 29 null YES BTREE YES null |
| 579 |
col_myp337 0 index_29 3 $ix_i29_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE YES null |
| 580 |
col_myp337 0 index_29 4 $ix_i29_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE YES null |
| 581 |
col_myp337 0 index_29 5 $ix_bt29_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 29 null BTREE YES null |
| 582 |
col_myp337 0 index_29 6 $ix_bt29_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 29 null YES BTREE YES null |
| 583 |
0 rows affected |
| 584 |
RUN SHOW INDEX from xplugintest.col_myp337 where Key_name rlike '^index_[34][0-9]*' |
| 585 |
Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment Visible Expression |
| 586 |
col_myp337 0 index_30 1 $ix_t30_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 30 null BTREE YES null |
| 587 |
col_myp337 0 index_30 2 $ix_t30_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 30 null YES BTREE YES null |
| 588 |
col_myp337 0 index_30 3 $ix_i30_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE YES null |
| 589 |
col_myp337 0 index_30 4 $ix_i30_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE YES null |
| 590 |
col_myp337 0 index_30 5 $ix_bt30_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 30 null BTREE YES null |
| 591 |
col_myp337 0 index_30 6 $ix_bt30_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 30 null YES BTREE YES null |
| 592 |
col_myp337 0 index_31 1 $ix_t31_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 31 null BTREE YES null |
| 593 |
col_myp337 0 index_31 2 $ix_t31_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 31 null YES BTREE YES null |
| 594 |
col_myp337 0 index_31 3 $ix_i31_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE YES null |
| 595 |
col_myp337 0 index_31 4 $ix_i31_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE YES null |
| 596 |
col_myp337 0 index_31 5 $ix_bt31_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 31 null BTREE YES null |
| 597 |
col_myp337 0 index_31 6 $ix_bt31_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 31 null YES BTREE YES null |
| 598 |
col_myp337 0 index_32 1 $ix_t32_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 32 null BTREE YES null |
| 599 |
col_myp337 0 index_32 2 $ix_t32_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 32 null YES BTREE YES null |
| 600 |
col_myp337 0 index_32 3 $ix_i32_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE YES null |
| 601 |
col_myp337 0 index_32 4 $ix_i32_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE YES null |
| 602 |
col_myp337 0 index_32 5 $ix_bt32_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 32 null BTREE YES null |
| 603 |
col_myp337 0 index_32 6 $ix_bt32_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 32 null YES BTREE YES null |
| 604 |
col_myp337 0 index_33 1 $ix_t33_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 33 null BTREE YES null |
| 605 |
col_myp337 0 index_33 2 $ix_t33_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 33 null YES BTREE YES null |
| 606 |
col_myp337 0 index_33 3 $ix_i33_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE YES null |
| 607 |
col_myp337 0 index_33 4 $ix_i33_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE YES null |
| 608 |
col_myp337 0 index_33 5 $ix_bt33_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 33 null BTREE YES null |
| 609 |
col_myp337 0 index_33 6 $ix_bt33_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 33 null YES BTREE YES null |
| 610 |
col_myp337 0 index_34 1 $ix_t34_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 34 null BTREE YES null |
| 611 |
col_myp337 0 index_34 2 $ix_t34_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 34 null YES BTREE YES null |
| 612 |
col_myp337 0 index_34 3 $ix_i34_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE YES null |
| 613 |
col_myp337 0 index_34 4 $ix_i34_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE YES null |
| 614 |
col_myp337 0 index_34 5 $ix_bt34_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 34 null BTREE YES null |
| 615 |
col_myp337 0 index_34 6 $ix_bt34_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 34 null YES BTREE YES null |
| 616 |
col_myp337 0 index_35 1 $ix_t35_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 35 null BTREE YES null |
| 617 |
col_myp337 0 index_35 2 $ix_t35_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 35 null YES BTREE YES null |
| 618 |
col_myp337 0 index_35 3 $ix_i35_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE YES null |
| 619 |
col_myp337 0 index_35 4 $ix_i35_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE YES null |
| 620 |
col_myp337 0 index_35 5 $ix_bt35_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 35 null BTREE YES null |
| 621 |
col_myp337 0 index_35 6 $ix_bt35_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 35 null YES BTREE YES null |
| 622 |
col_myp337 0 index_36 1 $ix_t36_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 36 null BTREE YES null |
| 623 |
col_myp337 0 index_36 2 $ix_t36_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 36 null YES BTREE YES null |
| 624 |
col_myp337 0 index_36 3 $ix_i36_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE YES null |
| 625 |
col_myp337 0 index_36 4 $ix_i36_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE YES null |
| 626 |
col_myp337 0 index_36 5 $ix_bt36_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 36 null BTREE YES null |
| 627 |
col_myp337 0 index_36 6 $ix_bt36_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 36 null YES BTREE YES null |
| 628 |
col_myp337 0 index_37 1 $ix_t37_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 37 null BTREE YES null |
| 629 |
col_myp337 0 index_37 2 $ix_t37_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 37 null YES BTREE YES null |
| 630 |
col_myp337 0 index_37 3 $ix_i37_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE YES null |
| 631 |
col_myp337 0 index_37 4 $ix_i37_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE YES null |
| 632 |
col_myp337 0 index_37 5 $ix_bt37_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 37 null BTREE YES null |
| 633 |
col_myp337 0 index_37 6 $ix_bt37_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 37 null YES BTREE YES null |
| 634 |
col_myp337 0 index_38 1 $ix_t38_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 38 null BTREE YES null |
| 635 |
col_myp337 0 index_38 2 $ix_t38_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 38 null YES BTREE YES null |
| 636 |
col_myp337 0 index_38 3 $ix_i38_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE YES null |
| 637 |
col_myp337 0 index_38 4 $ix_i38_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE YES null |
| 638 |
col_myp337 0 index_38 5 $ix_bt38_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 38 null BTREE YES null |
| 639 |
col_myp337 0 index_38 6 $ix_bt38_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 38 null YES BTREE YES null |
| 640 |
col_myp337 0 index_39 1 $ix_t39_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 39 null BTREE YES null |
| 641 |
col_myp337 0 index_39 2 $ix_t39_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 39 null YES BTREE YES null |
| 642 |
col_myp337 0 index_39 3 $ix_i39_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE YES null |
| 643 |
col_myp337 0 index_39 4 $ix_i39_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE YES null |
| 644 |
col_myp337 0 index_39 5 $ix_bt39_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 39 null BTREE YES null |
| 645 |
col_myp337 0 index_39 6 $ix_bt39_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 39 null YES BTREE YES null |
| 646 |
col_myp337 0 index_40 1 $ix_t40_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 40 null BTREE YES null |
| 647 |
col_myp337 0 index_40 2 $ix_t40_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 40 null YES BTREE YES null |
| 648 |
col_myp337 0 index_40 3 $ix_i40_r_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null BTREE YES null |
| 649 |
col_myp337 0 index_40 4 $ix_i40_8870EF04DBC5C827B87C34BF582F39442A78BBD9 A 0 null null YES BTREE YES null |
| 650 |
col_myp337 0 index_40 5 $ix_bt40_r_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 40 null BTREE YES null |
| 651 |
col_myp337 0 index_40 6 $ix_bt40_7ED2EEDDC197ED77968204C8668FFC142B3F8878 A 0 40 null YES BTREE YES null |
| 652 |
0 rows affected |
| 653 |
Mysqlx.Ok { |
| 654 |
msg: "bye!" |
| 655 |
} |
| 656 |
ok |
| 657 |
RUN DROP DATABASE IF EXISTS xplugintest |
| 658 |
|
| 659 |
4 rows affected |
| 660 |
RUN DROP DATABASE IF EXISTS xplugintest_1 |
| 661 |
|
| 662 |
0 rows affected |
| 663 |
Mysqlx.Ok { |
| 664 |
msg: "bye!" |
| 665 |
} |
| 666 |
ok |