Debian Codegraph @

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

raw
1
2 0 rows affected
3 1
4 1
5 0 rows affected
6 SCHEMA_NAME DIGEST_TEXT COUNT_STAR
7 null TRUNCATE TABLE `performance_schema` . `events_statements_summary_by_digest` 1
8 null SELECT ? 1
9 0 rows affected
10
11 1 rows affected
12 ######### create_collection #########
13
14 command ok
15 Query
16 SELECT @@lower_case_table_names
17 CREATE TABLE `xtest`.`test` (doc JSON,_id VARBINARY(32) GENERATED ALWAYS AS (JSON_UNQUOTE(JSON_EXTRACT(doc, '$._id'))) STORED PRIMARY KEY, _json_schema JSON GENERATED ALWAYS AS ('{"type":"object"}'), CONSTRAINT `$val_strict_94BDCEBE19083CE2A1F959FD02F964C7AF4CFC29` CHECK (JSON_SCHEMA_VALID(_json_schema, doc)) NOT ENFORCED) CHARSET utf8mb4 ENGINE=InnoDB
18 0 rows affected
19 ######### Crud.Insert #########
20
21 1 rows affected
22 Query
23 SELECT @@mysqlx_document_id_unique_prefix,@@auto_increment_offset,@@auto_increment_increment
24 INSERT INTO `xtest`.`test` (doc) VALUES ('{\"_id\": \"one\"}')
25 0 rows affected
26 ######### Crud.Insert (upsert) #########
27
28 1 rows affected
29 Query
30 SELECT @@mysqlx_document_id_unique_prefix,@@auto_increment_offset,@@auto_increment_increment
31 INSERT INTO `xtest`.`test` (doc) VALUES ('{\"_id\": \"two\"}') AS _UPSERT_NEW_VALUES_(_NEW_DOC_) ON DUPLICATE KEY UPDATE doc = IF(JSON_UNQUOTE(JSON_EXTRACT(doc, '$._id')) = JSON_UNQUOTE(JSON_EXTRACT(_UPSERT_NEW_VALUES_._NEW_DOC_, '$._id')), _UPSERT_NEW_VALUES_._NEW_DOC_, MYSQLX_ERROR(5018))
32 0 rows affected
33 ######### Crud.Update #########
34
35 1 rows affected
36 Rows matched: 1 Changed: 1 Warnings: 0
37 Query
38 UPDATE `xtest`.`test` SET doc=JSON_SET(JSON_SET(doc,'$.key','val'),'$._id',JSON_EXTRACT(`doc`,'$._id')) WHERE (`_id` = 'one')
39 0 rows affected
40 ######### Crud.CreateView #########
41 Mysqlx.Ok {
42 }
43
44 Query
45 CREATE VIEW `xtest`.`test_view` AS SELECT JSON_OBJECT('id', `_id`) AS doc FROM `xtest`.`test`
46 0 rows affected
47 ######### Crud.ModifyView #########
48 Mysqlx.Ok {
49 }
50
51 Query
52 ALTER VIEW `xtest`.`test_view` AS SELECT JSON_OBJECT('id', `_id`) AS doc FROM `xtest`.`test`
53 0 rows affected
54 ######### Crud.DropView #########
55 Mysqlx.Ok {
56 }
57
58 Query
59 DROP VIEW `xtest`.`test_view`
60 0 rows affected
61 ######### Crud.Find #########
62 doc
63 {"_id": "one", "key": "val"}
64 {"_id": "two"}
65 command ok
66 Query
67 SELECT doc FROM `xtest`.`test`
68 0 rows affected
69 ######### Crud.Find with shared lock #########
70 doc
71 {"_id": "one", "key": "val"}
72 {"_id": "two"}
73 command ok
74 Query
75 SELECT doc FROM `xtest`.`test` FOR SHARE
76 0 rows affected
77 ######### Crud.Find with exclusive lock #########
78 doc
79 {"_id": "one", "key": "val"}
80 {"_id": "two"}
81 command ok
82 Query
83 SELECT doc FROM `xtest`.`test` FOR UPDATE
84 0 rows affected
85 ######### Crud.Delete #########
86
87 1 rows affected
88 Query
89 DELETE FROM `xtest`.`test` WHERE (`_id` = 'one')
90 0 rows affected
91 ######### create_collection #########
92
93 command ok
94 Query
95 SELECT @@lower_case_table_names
96 CREATE TABLE `xtest`.`test2` (doc JSON,_id VARBINARY(32) GENERATED ALWAYS AS (JSON_UNQUOTE(JSON_EXTRACT(doc, '$._id'))) STORED PRIMARY KEY, _json_schema JSON GENERATED ALWAYS AS ('{"type":"object"}'), CONSTRAINT `$val_strict_7CEB3FDE5F7A9C4CE5FBE610D7D8EDA62EBE5F4E` CHECK (JSON_SCHEMA_VALID(_json_schema, doc)) NOT ENFORCED) CHARSET utf8mb4 ENGINE=InnoDB
97 0 rows affected
98 ######### ensure_collection #########
99
100 command ok
101 Query
102 SELECT @@lower_case_table_names
103 CREATE TABLE `xtest`.`test2` (doc JSON,_id VARBINARY(32) GENERATED ALWAYS AS (JSON_UNQUOTE(JSON_EXTRACT(doc, '$._id'))) STORED PRIMARY KEY, _json_schema JSON GENERATED ALWAYS AS ('{"type":"object"}'), CONSTRAINT `$val_strict_7CEB3FDE5F7A9C4CE5FBE610D7D8EDA62EBE5F4E` CHECK (JSON_SCHEMA_VALID(_json_schema, doc)) NOT ENFORCED) CHARSET utf8mb4 ENGINE=InnoDB
104 SELECT @@sql_mode
105 SELECT COUNT(*) AS cnt,COUNT(CASE WHEN (column_name = 'doc' AND data_type = 'json') THEN 1 ELSE NULL END) AS doc,COUNT(CASE WHEN (column_name = '_id' AND generation_expression RLIKE '^json_unquote\\(json_extract\\(`doc`,(_[[:alnum:]]+)?\\\\''\\$\\._id\\\\''\\)\\)$') THEN 1 ELSE NULL END) AS id,COUNT(CASE WHEN (column_name != '_id' AND column_name != 'doc' AND column_name != '_json_schema' AND generation_expression RLIKE 'json_extract\\(`doc`,(_[[:alnum:]]+)?\\\\''\\$((\\*{2})?(\\[([[:digit:]]+|\\*)\\]|\\.([[:alpha:]_\\$][[:alnum:]_\\$]*|\\*|\\".*\\"|`.*`)))*\\\\''\\)') THEN 1 ELSE NULL END) AS gen, COUNT(CASE WHEN (column_name = '_json_schema') THEN 1 ELSE NULL END) AS validation_schema FROM information_schema.columns WHERE table_name = 'test2' AND table_schema = 'xtest'
106 SELECT @@lower_case_table_names
107 ALTER TABLE `xtest`.`test2` MODIFY COLUMN _json_schema JSON GENERATED ALWAYS AS ('{"type":"object"}') VIRTUAL, ALTER CHECK `$val_strict_7CEB3FDE5F7A9C4CE5FBE610D7D8EDA62EBE5F4E` NOT ENFORCED
108 0 rows affected
109 ######### get validation error when working with collections #########
110
111 command ok
112 Got expected error:
113 Mysqlx.Error {
114 severity: ERROR
115 code: 5180
116 msg: "Document is not valid according to the schema assigned to collection. The JSON document location \'#/value\' failed requirement \'maximum\' at JSON Schema location \'#/properties/value\'."
117 sql_state: "HY000"
118 }
119
120 Query
121 SELECT @@mysqlx_document_id_unique_prefix,@@auto_increment_offset,@@auto_increment_increment
122 INSERT INTO `xtest`.`test3` (doc) VALUES ('{\"_id\": \"one\", \"value\": 100}')
123 GET DIAGNOSTICS CONDITION 1 @$internal_validation_error_message = MESSAGE_TEXT
124 SELECT @$internal_validation_error_message
125 0 rows affected
126
127 command ok
128 ######### create_collection_index #########
129
130 command ok
131 Query
132 SHOW CREATE TABLE `xtest`.`test2`
133 SHOW COLUMNS FROM `xtest`.`test2` WHERE Field = '$ix_t1_F3A2A51A9B0F2BE2468926B4132313728C250DBF'
134 ALTER TABLE `xtest`.`test2` ADD COLUMN `$ix_t1_F3A2A51A9B0F2BE2468926B4132313728C250DBF` TEXT GENERATED ALWAYS AS (JSON_UNQUOTE(JSON_EXTRACT(doc, '$.foo'))) VIRTUAL, ADD UNIQUE INDEX `foo` (`$ix_t1_F3A2A51A9B0F2BE2468926B4132313728C250DBF`(1))
135 0 rows affected
136 ######### drop_collection_index #########
137
138 command ok
139 Query
140 SELECT @@sql_mode
141 SELECT column_name, COUNT(index_name) AS count FROM information_schema.statistics WHERE table_name='test2' AND table_schema='xtest' AND column_name IN (SELECT column_name FROM information_schema.statistics WHERE table_name='test2' AND table_schema='xtest' AND index_name='foo' AND column_name RLIKE '^\\$ix_[[:alnum:]_]+[[:xdigit:]]+$') GROUP BY column_name HAVING count = 1
142 ALTER TABLE `xtest`.`test2` DROP INDEX `foo`, DROP COLUMN `$ix_t1_F3A2A51A9B0F2BE2468926B4132313728C250DBF`
143 0 rows affected
144 ######### create_collection_index (spatial) #########
145
146 command ok
147 Query
148 SHOW CREATE TABLE `xtest`.`test2`
149 SHOW COLUMNS FROM `xtest`.`test2` WHERE Field = '$ix_gj_r_F3A2A51A9B0F2BE2468926B4132313728C250DBF'
150 ALTER TABLE `xtest`.`test2` ADD COLUMN `$ix_gj_r_F3A2A51A9B0F2BE2468926B4132313728C250DBF` GEOMETRY GENERATED ALWAYS AS (ST_GEOMFROMGEOJSON(JSON_EXTRACT(doc, '$.foo'),1,4326)) STORED NOT NULL SRID 4326, ADD SPATIAL INDEX `bar` (`$ix_gj_r_F3A2A51A9B0F2BE2468926B4132313728C250DBF`)
151 0 rows affected
152 ######### drop_collection_index (spatial) #########
153
154 command ok
155 Query
156 SELECT @@sql_mode
157 SELECT column_name, COUNT(index_name) AS count FROM information_schema.statistics WHERE table_name='test2' AND table_schema='xtest' AND column_name IN (SELECT column_name FROM information_schema.statistics WHERE table_name='test2' AND table_schema='xtest' AND index_name='bar' AND column_name RLIKE '^\\$ix_[[:alnum:]_]+[[:xdigit:]]+$') GROUP BY column_name HAVING count = 1
158 ALTER TABLE `xtest`.`test2` DROP INDEX `bar`, DROP COLUMN `$ix_gj_r_F3A2A51A9B0F2BE2468926B4132313728C250DBF`
159 0 rows affected
160 ######### create_collection_index (fulltext) #########
161
162 command ok
163 Query
164 SHOW CREATE TABLE `xtest`.`test2`
165 SHOW COLUMNS FROM `xtest`.`test2` WHERE Field = '$ix_ft_r_F3A2A51A9B0F2BE2468926B4132313728C250DBF'
166 ALTER TABLE `xtest`.`test2` ADD COLUMN `$ix_ft_r_F3A2A51A9B0F2BE2468926B4132313728C250DBF` TEXT GENERATED ALWAYS AS (JSON_UNQUOTE(JSON_EXTRACT(doc, '$.foo'))) STORED NOT NULL, ADD FULLTEXT INDEX `foobar` (`$ix_ft_r_F3A2A51A9B0F2BE2468926B4132313728C250DBF`) WITH PARSER ngram
167 0 rows affected
168 ######### drop_collection_index (fulltext) #########
169
170 command ok
171 Query
172 SELECT @@sql_mode
173 SELECT column_name, COUNT(index_name) AS count FROM information_schema.statistics WHERE table_name='test2' AND table_schema='xtest' AND column_name IN (SELECT column_name FROM information_schema.statistics WHERE table_name='test2' AND table_schema='xtest' AND index_name='foobar' AND column_name RLIKE '^\\$ix_[[:alnum:]_]+[[:xdigit:]]+$') GROUP BY column_name HAVING count = 1
174 ALTER TABLE `xtest`.`test2` DROP INDEX `foobar`, DROP COLUMN `$ix_ft_r_F3A2A51A9B0F2BE2468926B4132313728C250DBF`
175 0 rows affected
176 ######### list_objects #########
177 name type
178 test COLLECTION
179 test2 COLLECTION
180 command ok
181 Query
182 SHOW TABLES FROM `xtest`
183 SELECT @@sql_mode
184 SELECT T.table_name AS name, IF(ANY_VALUE(T.table_type) LIKE '%VIEW', IF(COUNT(*)=1 AND COUNT(CASE WHEN (column_name = 'doc' AND data_type = 'json') THEN 1 ELSE NULL END)=1, 'COLLECTION_VIEW', 'VIEW'), IF(COUNT(CASE WHEN (column_name != '_json_schema') THEN 1 ELSE NULL END)-2 = COUNT(CASE WHEN (column_name != '_id' AND column_name != 'doc' AND column_name != '_json_schema' AND generation_expression RLIKE 'json_extract\\(`doc`,(_[[:alnum:]]+)?\\\\''\\$((\\*{2})?(\\[([[:digit:]]+|\\*)\\]|\\.([[:alpha:]_\\$][[:alnum:]_\\$]*|\\*|\\".*\\"|`.*`)))*\\\\''\\)') THEN 1 ELSE NULL END) AND COUNT(CASE WHEN (column_name = 'doc' AND data_type = 'json') THEN 1 ELSE NULL END)=1 AND COUNT(CASE WHEN (column_name = '_id' AND generation_expression RLIKE '^json_unquote\\(json_extract\\(`doc`,(_[[:alnum:]]+)?\\\\''\\$\\._id\\\\''\\)\\)$') THEN 1 ELSE NULL END)=1, 'COLLECTION', 'TABLE')) AS type FROM information_schema.tables AS T LEFT JOIN information_schema.columns AS C ON (T.table_schema = C.table_schema AND T.table_name = C.table_name) WHERE T.table_schema = 'xtest' GROUP BY name ORDER BY name
185 0 rows affected
186 ######### drop_collection #########
187
188 command ok
189 Query
190 DROP TABLE `xtest`.`test2`
191 0 rows affected
192 ######### list_clients #########
193
194 0 rows affected
195
196 0 rows affected
197 client_id user host sql_session
198 1 x_root localhost $SESSION
199 command ok
200 Query
201 CREATE USER 'unpriv'@'localhost'
202 SET PASSWORD FOR `unpriv`@`localhost`=<secret>
203 0 rows affected
204 ######### kill_client #########
205 connecting...
206 active session is now 'unpriv'
207 connecting...
208 active session is now 'x_root'
209
210 command ok
211 Server disconnected
212 closing session unpriv
213 switched to session default
214
215 0 rows affected
216 Query
217 /* xplugin authentication */ SELECT /*+ SET_VAR(SQL_MODE = 'TRADITIONAL') */ @@require_secure_transport, `authentication_string`, `plugin`, (`account_locked`='Y') as is_account_locked, (`password_expired`!='N') as `is_password_expired`, @@disconnect_on_expired_password as `disconnect_on_expired_password`, @@offline_mode and (`Super_priv`='N') as `is_offline_mode_and_not_super_user`, `ssl_type`, `ssl_cipher`, `x509_issuer`, `x509_subject` FROM mysql.user WHERE 'x_root' = `user` AND 'localhost' = `host`
218 KILL
219 drop user unpriv@localhost
220 0 rows affected
221 ######### list_notices #########
222 notice enabled
223 warnings 1
224 group_replication/membership/quorum_loss 0
225 group_replication/membership/view 0
226 group_replication/status/role_change 0
227 group_replication/status/state_change 0
228 account_expired 1
229 generated_insert_id 1
230 rows_affected 1
231 produced_message 1
232 command ok
233 Query
234 0 rows affected
235 ######### disable_notices #########
236
237 command ok
238 1/0
239 null
240 0 rows affected
241 Query
242 SELECT 1/0
243 0 rows affected
244 ######### enable_notices #########
245
246 command ok
247 1/0
248 null
249 0 rows affected
250 Warnings generated:
251 WARNING | 1365 | Division by 0
252 Query
253 SELECT 1/0
254 SHOW WARNINGS
255 0 rows affected
256 ######### ping #########
257
258 command ok
259 Query
260 0 rows affected
261 closing session x_root
262 Mysqlx.Ok {
263 msg: "bye!"
264 }
265 ok