Debian Codegraph @

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

raw
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