Debian Codegraph @

mysql-test/suite/x/t/collection_compatibility.test

raw
1 ## Test backward compatibility of collections containing validation
2
3 ## Preamble
4 --source include/xplugin_preamble.inc
5 --source include/xplugin_create_user.inc
6
7 create schema xtest default charset 'utf8mb4';
8
9 --let $xtest_file= $MYSQL_TMP_DIR/collection_compatibility.xpl
10 --write_file $xtest_file
11 -->import validation_schema.macro
12
13 -->macro create_collection_varbin32 %NAME%
14 -->sql
15 CREATE TABLE xtest.%NAME% (doc JSON, _id VARBINARY(32) GENERATED ALWAYS AS
16 (JSON_UNQUOTE(JSON_EXTRACT(doc, '$._id'))) STORED PRIMARY KEY) CHARSET utf8mb4
17 ENGINE=InnoDB;
18 -->endsql
19 -->endmacro
20
21 -->macro create_collection_varchar32 %NAME%
22 -->sql
23 CREATE TABLE xtest.%NAME% (doc JSON, _id VARCHAR(32) GENERATED ALWAYS AS
24 (JSON_UNQUOTE(JSON_EXTRACT(doc, '$._id'))) STORED PRIMARY KEY)
25 CHARSET utf8mb4 ENGINE=InnoDB;
26 -->endsql
27 -->endmacro
28
29 -->macro create_collection_with_json_schema %NAME%
30 -->sql
31 CREATE TABLE xtest.%NAME% (`doc` json DEFAULT NULL, `_id` varbinary(32)
32 GENERATED ALWAYS AS (json_unquote(json_extract(`doc`,_utf8mb4'$._id'))) STORED
33 NOT NULL, `_json_schema` json GENERATED ALWAYS AS (_utf8mb4'{"type":"object"}')
34 VIRTUAL, PRIMARY KEY (`_id`), CONSTRAINT
35 `$val_strict_F2DE1896B6B5A7BAD6369FB94E3B214EBC2F27EA` CHECK
36 (JSON_SCHEMA_VALID(`_json_schema`,`doc`)) ENFORCED) CHARSET utf8mb4
37 ENGINE=InnoDB;
38 -->endsql
39 -->endmacro
40
41 -->macro List_xtest_objects
42 -->stmtadmin list_objects {"schema": "xtest"}
43 -->recvresult
44 -->endmacro
45
46 -->macro List_collection_columns %COLLECTION_NAME%
47 stmtsql SELECT column_name FROM information_schema.columns WHERE
48 table_name = '%COLLECTION_NAME%' ORDER BY column_name ASC;
49 -->recvresult
50 -->endmacro
51
52 -->echo
53 -->echo
54 -->echo ## I. Create collection with respect to old style collections.
55 -->echo #
56 -->echo # 1. Create collection when there is an old collection with same name.
57 -->echo # 2. Create collection when there is an old collection with different
58 -->echo # name.
59 -->echo
60 -->echo ## II. Create collection using ensure_collection with respect to old
61 -->echo ## style collections.
62 -->echo #
63 -->echo # 1. Create collection when there is an old collection with same name.
64 -->echo
65 -->echo ## III. List collection objects created with and without validation
66 -->echo ## schema
67 -->echo #
68 -->echo # 1. List just old style collection.
69 -->echo # 2. List old and new collection types.
70 -->echo # 3. List old and new collection types with regular table.
71 -->echo # 4. Drop old collection and list new collection type and a regular
72 -->echo # table.
73 -->echo
74 -->echo ## IV. Call modify_collection_options on a schema created without
75 -->echo ## a schema validation
76 -->echo #
77 -->echo # 1. Modify old collection by trying to change only the validation
78 -->echo # level.
79 -->echo # 2. Modify old collection by trying to change only the validation
80 -->echo # schema.
81 -->echo # 3. Modify old collection by trying to change both validation schema
82 -->echo # and level.
83 -->echo # 4. Modify old collection containing data that is not valid according
84 -->echo # to the new schema,
85 -->echo # modification must fail and old table layout should not be changed.
86 -->echo # Update the
87 -->echo # faulty value, modification must pass and layout should be updated.
88 -->echo
89 -->echo ## V. Call get_collection_options on a schema created withoud a schema
90 -->echo ## validation.
91 -->echo #
92 -->echo # 1. Fetch valid option.
93 -->echo # 1. Fetch invalid option.
94
95
96 -->stmtsql USE xtest;
97 -->recvresult
98
99 -->echo
100 -->echo #
101 -->echo # I.1
102 -->callmacro %CREATE_COLLECTION% foobar
103 stmtadmin create_collection {"schema": "xtest", "name": "foobar", "options": {
104 "validation": {
105 "level": "STRICT",
106 "schema": "{\"type\": \"object\"}"
107 }
108 }};
109 -->recverror ER_TABLE_EXISTS_ERROR
110 -->stmtadmin create_collection {"schema": "xtest", "name": "foobar"}
111 -->recverror ER_TABLE_EXISTS_ERROR
112 -->stmtsql SHOW CREATE TABLE xtest.foobar
113 -->recvresult
114 -->callmacro Drop_collection foobar
115
116 -->echo
117 -->echo #
118 -->echo # I.2
119 -->callmacro %CREATE_COLLECTION% foo
120 stmtadmin create_collection {"schema": "xtest", "name": "bar", "options": {
121 "validation": {
122 "schema": "{\"type\": \"object\"}"
123 }
124 }};
125 -->recvresult
126 -->stmtsql SHOW CREATE TABLE xtest.foo
127 -->recvresult
128 -->stmtsql SHOW CREATE TABLE xtest.bar
129 -->recvresult
130 -->callmacro Drop_collection foo
131 -->callmacro Drop_collection bar
132
133 -->echo
134 -->echo #
135 -->echo # II.1
136 -->callmacro %CREATE_COLLECTION% foobar
137 stmtadmin ensure_collection {"schema": "xtest", "name": "foobar", "options": {
138 "validation": {
139 "schema": "{\"type\": \"object\"}"
140 }
141 }};
142 -->recvresult
143 -->stmtadmin ensure_collection {"schema": "xtest", "name": "foobar"}
144 -->recvresult
145 -->stmtadmin ensure_collection {"name": "foobar"}
146 -->recvresult
147 -->stmtsql SHOW CREATE TABLE xtest.foobar
148 -->recvresult
149 -->callmacro Drop_collection foobar
150
151 -->echo
152 -->echo #
153 -->echo # III.1
154 -->callmacro %CREATE_COLLECTION% old_coll
155 -->callmacro List_xtest_objects
156
157 -->echo
158 -->echo #
159 -->echo # III.2
160 stmtadmin create_collection {"schema": "xtest", "name": "new_coll2", "options": {
161 "validation": {
162 "schema": "{\"type\": \"object\"}"
163 }
164 }};
165 -->recvresult
166 -->callmacro List_xtest_objects
167 -->stmtadmin create_collection {"schema": "xtest", "name": "new_coll3"}
168 -->recvresult
169 -->callmacro List_xtest_objects
170
171 -->echo
172 -->echo #
173 -->echo # III.3
174 -->stmtsql CREATE TABLE xtest.regular_tab (doc JSON);
175 -->recvresult
176 -->callmacro List_xtest_objects
177
178 -->echo
179 -->echo #
180 -->echo # III.4
181 -->callmacro Drop_collection old_coll
182 -->callmacro List_xtest_objects
183
184 -->quiet
185 -->stmtsql DROP TABLE xtest.new_coll2, xtest.new_coll3, xtest.regular_tab;
186 -->recvresult
187 -->noquiet
188
189
190 -->echo
191 -->echo #
192 -->echo # IV.1
193 -->callmacro %CREATE_COLLECTION% old_coll
194 -->callmacro List_collection_columns old_coll
195 callmacro Insert_value_to_collection old_coll
196 '{"_id": "1", "name": "Robb", "amount": 125.21}';
197 -->recvresult
198 stmtadmin modify_collection_options
199 {"schema": "xtest", "name": "old_coll", "options": {
200 "validation": {
201 "level":"strict"
202 }
203 }
204 };
205 -->recvresult
206 -->callmacro List_collection_columns old_coll
207 -->callmacro Assert_is_enforced old_coll YES
208 -->callmacro Drop_collection old_coll
209
210
211 -->echo
212 -->echo #
213 -->echo # IV.2
214 -->callmacro %CREATE_COLLECTION% old_coll
215 -->callmacro List_collection_columns old_coll
216 callmacro Insert_value_to_collection old_coll
217 '{"_id": "1", "name": "Robb", "amount": 125.21}';
218 -->recvresult
219 stmtadmin modify_collection_options
220 {"schema": "xtest", "name": "old_coll", "options": {
221 "validation": {
222 "level": "strict",
223 "schema":{"type":"object"}
224 }
225 }
226 };
227 -->recvresult
228 -->callmacro List_collection_columns old_coll
229 -->callmacro Assert_is_enforced old_coll YES
230 -->callmacro Drop_collection old_coll
231
232
233 -->echo
234 -->echo #
235 -->echo # IV.3
236 -->callmacro %CREATE_COLLECTION% old_coll
237 -->callmacro List_collection_columns old_coll
238 callmacro Insert_value_to_collection
239 old_coll
240 '{"_id": "1", "name": "Robb", "amount": 125.21}';
241 -->recvresult
242 stmtadmin modify_collection_options
243 {"schema": "xtest", "name": "old_coll", "options": {
244 "validation": {
245 "schema":{"type":"object"},
246 "level":"off"
247 }
248 }
249 };
250 -->recvresult
251 -->callmacro List_collection_columns old_coll
252 -->callmacro Assert_is_enforced old_coll NO
253 -->callmacro Drop_collection old_coll
254
255 -->echo
256 -->echo #
257 -->echo # IV.4
258 -->callmacro %CREATE_COLLECTION% old_coll
259 -->callmacro List_collection_columns old_coll
260 callmacro Insert_value_to_collection old_coll
261 '{"_id": "1", "name": "Robb", "amount": 125.21}';
262 -->recvresult
263 callmacro Insert_value_to_collection old_coll
264 '{"_id": "2", "name": "Bob", "amount": 11.19}';
265 -->recvresult
266 callmacro Insert_value_to_collection old_coll
267 '{"_id": "3", "name": "John", "amount": 223.17}';
268 -->recvresult
269
270 varlet %STR% "type": "object", "properties": {
271 "amount": {"type": "number", "minimum": 100}},
272 "required": ["amount"];
273
274 -->callmacro Modify_level old_coll STRICT
275 -->recvresult
276 -->callmacro Modify_schema old_coll {%STR%}
277 -->recverror ER_X_DOCUMENT_DOESNT_MATCH_EXPECTED_SCHEMA
278 callmacro Update_item old_coll
279 amount
280 {type: V_DOUBLE v_double: 11.19}
281 {type: V_DOUBLE v_double: 200};
282 -->recvresult
283 -->callmacro Modify_schema old_coll {%STR%}
284 -->recvresult
285 -->callmacro List_collection_columns old_coll
286 -->callmacro Drop_collection old_coll
287
288 -->echo
289 -->echo #
290 -->echo # V.1
291 -->callmacro %CREATE_COLLECTION% old_coll
292 stmtadmin get_collection_options
293 {"schema": "xtest", "name": "old_coll", "options": ["validation"]};
294 -->recvresult
295 -->callmacro Drop_collection old_coll
296
297 -->echo
298 -->echo #
299 -->echo # V.2
300 -->callmacro %CREATE_COLLECTION% old_coll
301 stmtadmin get_collection_options
302 {"schema": "xtest", "name": "old_coll", "options": ["foo", "validation"]};
303 -->recverror ER_X_COLLECTION_OPTION_DOESNT_EXISTS
304 -->callmacro Drop_collection old_coll
305
306 EOF
307
308 exec $MYSQLXTEST
309 -ux_root
310 --password=''
311 -v%CREATE_COLLECTION%=create_collection_varchar32
312 --file=$xtest_file 2>&1;
313
314 exec $MYSQLXTEST
315 -ux_root
316 --password=''
317 -v%CREATE_COLLECTION%=create_collection_varbin32
318 --file=$xtest_file 2>&1;
319
320 exec $MYSQLXTEST
321 -ux_root
322 --password=''
323 -v%CREATE_COLLECTION%=create_collection_with_json_schema
324 --file=$xtest_file 2>&1;
325
326 ## Cleanup
327 --source ../include/xplugin_cleanup.inc