]>
Commit | Line | Data |
---|---|---|
f85f8ebb BP |
1 | AT_BANNER([OVSDB -- execution]) |
2 | ||
39ab07af BP |
3 | m4_divert_push([PREPARE_TESTS]) |
4 | [ | |
5 | ||
6 | ordinal_schema () { | |
7 | cat <<'EOF' | |
8 | {"name": "ordinals", | |
f85f8ebb BP |
9 | "tables": { |
10 | "ordinals": { | |
11 | "columns": { | |
12 | "number": {"type": "integer"}, | |
6910a6e6 BP |
13 | "name": {"type": "string"}}, |
14 | "indexes": [["number"]]}}, | |
6aa09313 | 15 | "version": "5.1.3", |
39ab07af BP |
16 | "cksum": "12345678 9"} |
17 | EOF | |
18 | } | |
f85f8ebb | 19 | |
39ab07af BP |
20 | constraint_schema () { |
21 | cat << 'EOF' | |
22 | {"name": "constraints", | |
bd76d25d | 23 | "tables": { |
0d0f05b9 BP |
24 | "a": { |
25 | "columns": { | |
26 | "a": {"type": "integer"}, | |
27 | "a2a": {"type": {"key": {"type": "uuid", "refTable": "a"}, | |
28 | "min": 0, "max": "unlimited"}}, | |
29 | "a2b": {"type": {"key": {"type": "uuid", "refTable": "b"}, | |
30 | "min": 0, "max": "unlimited"}}}}, | |
31 | "b": { | |
32 | "columns": { | |
33 | "b": {"type": "integer"}, | |
34 | "b2a": {"type": {"key": {"type": "uuid", "refTable": "a"}, | |
35 | "min": 0, "max": "unlimited"}}, | |
36 | "b2b": {"type": {"key": {"type": "uuid", "refTable": "b"}, | |
b7585d1d BP |
37 | "min": 0, "max": "unlimited"}}, |
38 | "x": {"type": {"key": "integer", "min": 1, "max": 2}}}}, | |
bd76d25d BP |
39 | "constrained": { |
40 | "columns": { | |
41 | "positive": {"type": {"key": {"type": "integer", | |
87ab878c | 42 | "minInteger": 1}}}}, |
39ab07af BP |
43 | "maxRows": 1}}} |
44 | EOF | |
45 | } | |
bd76d25d | 46 | |
39ab07af BP |
47 | weak_schema () { |
48 | cat <<'EOF' | |
49 | {"name": "weak", | |
7360012b BP |
50 | "tables": { |
51 | "a": { | |
52 | "columns": { | |
53 | "a": {"type": "integer"}, | |
54 | "a2a": {"type": {"key": {"type": "uuid", | |
55 | "refTable": "a", | |
56 | "refType": "weak"}, | |
57 | "min": 0, "max": "unlimited"}}, | |
58 | "a2a1": {"type": {"key": {"type": "uuid", | |
59 | "refTable": "a", | |
60 | "refType": "weak"}}}, | |
61 | "a2b": {"type": {"key": {"type": "uuid", | |
62 | "refTable": "b", | |
63 | "refType": "weak"}}}}}, | |
64 | "b": { | |
65 | "columns": { | |
66 | "b": {"type": "integer"}, | |
67 | "b2a": {"type": {"key": {"type": "uuid", | |
68 | "refTable": "a", | |
69 | "refType": "weak"}, | |
39ab07af BP |
70 | "min": 0, "max": "unlimited"}}}}}} |
71 | EOF | |
72 | } | |
7360012b | 73 | |
39ab07af BP |
74 | gc_schema () { |
75 | cat <<'EOF' | |
76 | {"name": "gc", | |
c5f341ab BP |
77 | "tables": { |
78 | "root": { | |
79 | "columns": { | |
80 | "a": {"type": {"key": {"type": "uuid", | |
81 | "refTable": "a"}, | |
82 | "min": 0, "max": "unlimited"}}}, | |
83 | "isRoot": true}, | |
84 | "a": { | |
85 | "columns": { | |
86 | "a": {"type": "integer"}, | |
87 | "a2a": {"type": {"key": {"type": "uuid", | |
88 | "refTable": "a"}, | |
89 | "min": 0, "max": "unlimited"}}, | |
90 | "a2b": {"type": {"key": {"type": "uuid", | |
91 | "refTable": "b"}, | |
92 | "min": 0, "max": "unlimited"}}, | |
93 | "wa2a": {"type": {"key": {"type": "uuid", | |
94 | "refTable": "a", | |
95 | "refType": "weak"}, | |
96 | "min": 0, "max": "unlimited"}}, | |
97 | "wa2b": {"type": {"key": {"type": "uuid", | |
98 | "refTable": "b", | |
99 | "refType": "weak"}, | |
100 | "min": 0, "max": "unlimited"}}}}, | |
101 | "b": { | |
102 | "columns": { | |
103 | "b": {"type": "integer"}, | |
104 | "b2a": {"type": {"key": {"type": "uuid", | |
105 | "refTable": "a"}, | |
106 | "min": 0, "max": "unlimited"}}, | |
107 | "wb2a": {"type": {"key": {"type": "uuid", | |
108 | "refTable": "a", | |
109 | "refType": "weak"}, | |
110 | "min": 0, "max": "unlimited"}}}, | |
39ab07af BP |
111 | "isRoot": false}}} |
112 | EOF | |
113 | } | |
341c4e59 BP |
114 | |
115 | immutable_schema () { | |
116 | cat <<'EOF' | |
117 | {"name": "immutable", | |
118 | "tables": { | |
119 | "a": { | |
120 | "columns": {"i": {"type": "integer", "mutable": false}}}}} | |
121 | EOF | |
122 | } | |
39ab07af BP |
123 | ] |
124 | m4_divert_pop([PREPARE_TESTS]) | |
c5f341ab | 125 | |
21ff1aee BP |
126 | # OVSDB_CHECK_EXECUTION(TITLE, SCHEMA, TRANSACTIONS, OUTPUT, [KEYWORDS]) |
127 | # | |
128 | # Runs "test-ovsdb execute" with the given SCHEMA and each of the | |
129 | # TRANSACTIONS (which should be a quoted list of quoted strings). | |
130 | # | |
131 | # Checks that the overall output is OUTPUT, but UUIDs in the output | |
f85f8ebb BP |
132 | # are replaced by markers of the form <N> where N is a number. The |
133 | # first unique UUID is replaced by <0>, the next by <1>, and so on. | |
134 | # If a given UUID appears more than once it is always replaced by the | |
135 | # same marker. | |
21ff1aee BP |
136 | # |
137 | # TITLE is provided to AT_SETUP and KEYWORDS to AT_KEYWORDS. | |
39ab07af | 138 | m4_define([OVSDB_CHECK_EXECUTION], |
f85f8ebb | 139 | [AT_SETUP([$1]) |
21ff1aee | 140 | AT_KEYWORDS([ovsdb execute execution positive $5]) |
2c487bc8 | 141 | OVS_RUNDIR=`pwd`; export OVS_RUNDIR |
39ab07af | 142 | AT_CHECK([test-ovsdb execute "`$2`" m4_foreach([txn], [$3], [ 'txn'])], |
21ff1aee | 143 | [0], [stdout], []) |
5c6d0628 | 144 | AT_CHECK([${PERL} $srcdir/uuidfilt.pl stdout], [0], [$4]) |
f85f8ebb BP |
145 | AT_CLEANUP]) |
146 | ||
d198c4be | 147 | OVSDB_CHECK_EXECUTION([uuid-name must be <id>], |
39ab07af | 148 | [constraint_schema], |
d198c4be BP |
149 | [[[["constraints", |
150 | {"op": "insert", | |
151 | "table": "a", | |
152 | "row": {}, | |
153 | "uuid-name": "0"}]]]], | |
154 | [[[{"details":"Parsing ovsdb operation 1 of 1 failed: Type mismatch for member 'uuid-name'.","error":"syntax error","syntax":"{\"op\":\"insert\",\"row\":{},\"table\":\"a\",\"uuid-name\":\"0\"}"}] | |
155 | ]]) | |
156 | ||
157 | OVSDB_CHECK_EXECUTION([named-uuid must be <id>], | |
39ab07af | 158 | [constraint_schema], |
d198c4be BP |
159 | [[[["constraints", |
160 | {"op": "insert", | |
161 | "table": "a", | |
162 | "row": {"a2a": ["named-uuid", "0"]}}]]]], | |
163 | [[[{"details":"named-uuid string is not a valid <id>","error":"syntax error","syntax":"[\"named-uuid\",\"0\"]"}] | |
164 | ]]) | |
165 | ||
19b48a81 | 166 | OVSDB_CHECK_EXECUTION([duplicate uuid-name not allowed], |
39ab07af | 167 | [ordinal_schema], |
19b48a81 BP |
168 | [[[["ordinals", |
169 | {"op": "insert", | |
170 | "table": "ordinals", | |
171 | "row": {}, | |
172 | "uuid-name": "x"}, | |
173 | {"op": "insert", | |
174 | "table": "ordinals", | |
175 | "row": {}, | |
176 | "uuid-name": "x"}]]]], | |
177 | [[[{"uuid":["uuid","<0>"]},{"details":"This \"uuid-name\" appeared on an earlier \"insert\" operation.","error":"duplicate uuid-name","syntax":"\"x\""}] | |
178 | ]]) | |
179 | ||
e731d71b | 180 | m4_define([ONE_EXECUTION_EXAMPLE], [dnl |
88942565 BP |
181 | dnl At one point the "commit" code ignored new rows with all-default values, |
182 | dnl so this checks for that problem. | |
183 | OVSDB_CHECK_EXECUTION([insert default row, query table], | |
39ab07af | 184 | [ordinal_schema], |
88942565 BP |
185 | [[[["ordinals", |
186 | {"op": "insert", | |
187 | "table": "ordinals", | |
188 | "row": {}}]]], | |
189 | [[["ordinals", | |
190 | {"op": "select", | |
191 | "table": "ordinals", | |
192 | "where": []}]]]], | |
193 | [[[{"uuid":["uuid","<0>"]}] | |
194 | [{"rows":[{"_uuid":["uuid","<0>"],"_version":["uuid","<1>"],"name":"","number":0}]}] | |
195 | ]]) | |
e731d71b | 196 | ]) |
88942565 | 197 | |
e731d71b AS |
198 | m4_define([EXECUTION_EXAMPLES], [ |
199 | ONE_EXECUTION_EXAMPLE | |
f85f8ebb | 200 | OVSDB_CHECK_EXECUTION([insert row, query table], |
39ab07af | 201 | [ordinal_schema], |
9cb53f26 BP |
202 | [[[["ordinals", |
203 | {"op": "insert", | |
f85f8ebb | 204 | "table": "ordinals", |
21ff1aee | 205 | "row": {"number": 0, "name": "zero"}}]]], |
9cb53f26 BP |
206 | [[["ordinals", |
207 | {"op": "select", | |
f85f8ebb | 208 | "table": "ordinals", |
21ff1aee | 209 | "where": []}]]]], |
f85f8ebb BP |
210 | [[[{"uuid":["uuid","<0>"]}] |
211 | [{"rows":[{"_uuid":["uuid","<0>"],"_version":["uuid","<1>"],"name":"zero","number":0}]}] | |
212 | ]]) | |
213 | ||
214 | OVSDB_CHECK_EXECUTION([insert rows, query by value], | |
39ab07af | 215 | [ordinal_schema], |
9cb53f26 BP |
216 | [[[["ordinals", |
217 | {"op": "insert", | |
f85f8ebb | 218 | "table": "ordinals", |
21ff1aee | 219 | "row": {"number": 0, "name": "zero"}}]]], |
9cb53f26 BP |
220 | [[["ordinals", |
221 | {"op": "insert", | |
f85f8ebb | 222 | "table": "ordinals", |
21ff1aee | 223 | "row": {"number": 1, "name": "one"}}]]], |
9cb53f26 BP |
224 | [[["ordinals", |
225 | {"op": "select", | |
f85f8ebb | 226 | "table": "ordinals", |
21ff1aee | 227 | "where": [["name", "==", "zero"]]}]]], |
9cb53f26 BP |
228 | [[["ordinals", |
229 | {"op": "select", | |
f85f8ebb | 230 | "table": "ordinals", |
21ff1aee | 231 | "where": [["name", "==", "one"]]}]]]], |
f85f8ebb BP |
232 | [[[{"uuid":["uuid","<0>"]}] |
233 | [{"uuid":["uuid","<1>"]}] | |
234 | [{"rows":[{"_uuid":["uuid","<0>"],"_version":["uuid","<2>"],"name":"zero","number":0}]}] | |
235 | [{"rows":[{"_uuid":["uuid","<1>"],"_version":["uuid","<3>"],"name":"one","number":1}]}] | |
236 | ]]) | |
237 | ||
238 | OVSDB_CHECK_EXECUTION([insert rows, query by named-uuid], | |
39ab07af | 239 | [ordinal_schema], |
9cb53f26 BP |
240 | [[[["ordinals", |
241 | {"op": "insert", | |
f85f8ebb BP |
242 | "table": "ordinals", |
243 | "row": {"number": 0, "name": "zero"}, | |
244 | "uuid-name": "first"}, | |
245 | {"op": "insert", | |
246 | "table": "ordinals", | |
247 | "row": {"number": 1, "name": "one"}, | |
248 | "uuid-name": "second"}, | |
249 | {"op": "select", | |
250 | "table": "ordinals", | |
251 | "where": [["_uuid", "==", ["named-uuid", "first"]]]}, | |
252 | {"op": "select", | |
253 | "table": "ordinals", | |
21ff1aee | 254 | "where": [["_uuid", "==", ["named-uuid", "second"]]]}]]]], |
f85f8ebb BP |
255 | [[[{"uuid":["uuid","<0>"]},{"uuid":["uuid","<1>"]},{"rows":[{"_uuid":["uuid","<0>"],"_version":["uuid","<2>"],"name":"zero","number":0}]},{"rows":[{"_uuid":["uuid","<1>"],"_version":["uuid","<3>"],"name":"one","number":1}]}] |
256 | ]]) | |
257 | ||
258 | OVSDB_CHECK_EXECUTION([insert rows, update rows by value], | |
39ab07af | 259 | [ordinal_schema], |
9cb53f26 BP |
260 | [[[["ordinals", |
261 | {"op": "insert", | |
f85f8ebb BP |
262 | "table": "ordinals", |
263 | "row": {"number": 0, "name": "zero"}, | |
21ff1aee | 264 | "uuid-name": "first"}]]], |
9cb53f26 BP |
265 | [[["ordinals", |
266 | {"op": "insert", | |
f85f8ebb BP |
267 | "table": "ordinals", |
268 | "row": {"number": 1, "name": "one"}, | |
21ff1aee | 269 | "uuid-name": "first"}]]], |
9cb53f26 BP |
270 | [[["ordinals", |
271 | {"op": "update", | |
f85f8ebb BP |
272 | "table": "ordinals", |
273 | "where": [["name", "==", "zero"]], | |
21ff1aee | 274 | "row": {"name": "nought"}}]]], |
9cb53f26 BP |
275 | [[["ordinals", |
276 | {"op": "select", | |
f85f8ebb BP |
277 | "table": "ordinals", |
278 | "where": [], | |
21ff1aee | 279 | "sort": ["number"]}]]]], |
f85f8ebb BP |
280 | [[[{"uuid":["uuid","<0>"]}] |
281 | [{"uuid":["uuid","<1>"]}] | |
282 | [{"count":1}] | |
283 | [{"rows":[{"_uuid":["uuid","<0>"],"_version":["uuid","<2>"],"name":"nought","number":0},{"_uuid":["uuid","<1>"],"_version":["uuid","<3>"],"name":"one","number":1}]}] | |
284 | ]]) | |
285 | ||
e9f8f936 | 286 | OVSDB_CHECK_EXECUTION([insert rows, mutate rows], |
39ab07af | 287 | [ordinal_schema], |
9cb53f26 BP |
288 | [[[["ordinals", |
289 | {"op": "insert", | |
e9f8f936 BP |
290 | "table": "ordinals", |
291 | "row": {"number": 0, "name": "zero"}, | |
292 | "uuid-name": "first"}]]], | |
9cb53f26 BP |
293 | [[["ordinals", |
294 | {"op": "insert", | |
e9f8f936 BP |
295 | "table": "ordinals", |
296 | "row": {"number": 1, "name": "one"}, | |
297 | "uuid-name": "first"}]]], | |
9cb53f26 BP |
298 | [[["ordinals", |
299 | {"op": "mutate", | |
e9f8f936 BP |
300 | "table": "ordinals", |
301 | "where": [["name", "==", "zero"]], | |
302 | "mutations": [["number", "+=", 2]]}]]], | |
9cb53f26 BP |
303 | [[["ordinals", |
304 | {"op": "select", | |
e9f8f936 BP |
305 | "table": "ordinals", |
306 | "where": [], | |
307 | "sort": ["number"]}]]]], | |
308 | [[[{"uuid":["uuid","<0>"]}] | |
309 | [{"uuid":["uuid","<1>"]}] | |
310 | [{"count":1}] | |
311 | [{"rows":[{"_uuid":["uuid","<1>"],"_version":["uuid","<2>"],"name":"one","number":1},{"_uuid":["uuid","<0>"],"_version":["uuid","<3>"],"name":"zero","number":2}]}] | |
312 | ]]) | |
313 | ||
f85f8ebb | 314 | OVSDB_CHECK_EXECUTION([insert rows, delete by named-uuid], |
39ab07af | 315 | [ordinal_schema], |
9cb53f26 BP |
316 | [[[["ordinals", |
317 | {"op": "insert", | |
f85f8ebb BP |
318 | "table": "ordinals", |
319 | "row": {"number": 0, "name": "zero"}, | |
320 | "uuid-name": "first"}, | |
321 | {"op": "insert", | |
322 | "table": "ordinals", | |
323 | "row": {"number": 1, "name": "one"}, | |
324 | "uuid-name": "second"}, | |
325 | {"op": "delete", | |
326 | "table": "ordinals", | |
327 | "where": [["_uuid", "==", ["named-uuid", "first"]]]}, | |
328 | {"op": "select", | |
329 | "table": "ordinals", | |
330 | "where": [], | |
21ff1aee | 331 | "columns": ["name","number"]}]]]], |
f85f8ebb BP |
332 | [[[{"uuid":["uuid","<0>"]},{"uuid":["uuid","<1>"]},{"count":1},{"rows":[{"name":"one","number":1}]}] |
333 | ]]) | |
334 | ||
335 | OVSDB_CHECK_EXECUTION([insert rows, delete rows by value], | |
39ab07af | 336 | [ordinal_schema], |
9cb53f26 BP |
337 | [[[["ordinals", |
338 | {"op": "insert", | |
f85f8ebb BP |
339 | "table": "ordinals", |
340 | "row": {"number": 0, "name": "zero"}, | |
21ff1aee | 341 | "uuid-name": "first"}]]], |
9cb53f26 BP |
342 | [[["ordinals", |
343 | {"op": "insert", | |
f85f8ebb BP |
344 | "table": "ordinals", |
345 | "row": {"number": 1, "name": "one"}, | |
21ff1aee | 346 | "uuid-name": "first"}]]], |
9cb53f26 BP |
347 | [[["ordinals", |
348 | {"op": "delete", | |
f85f8ebb | 349 | "table": "ordinals", |
21ff1aee | 350 | "where": [["name", "==", "zero"]]}]]], |
9cb53f26 BP |
351 | [[["ordinals", |
352 | {"op": "select", | |
f85f8ebb | 353 | "table": "ordinals", |
21ff1aee | 354 | "where": []}]]]], |
f85f8ebb BP |
355 | [[[{"uuid":["uuid","<0>"]}] |
356 | [{"uuid":["uuid","<1>"]}] | |
357 | [{"count":1}] | |
358 | [{"rows":[{"_uuid":["uuid","<1>"],"_version":["uuid","<2>"],"name":"one","number":1}]}] | |
359 | ]]) | |
360 | ||
361 | OVSDB_CHECK_EXECUTION([insert rows, delete by (non-matching) value], | |
39ab07af | 362 | [ordinal_schema], |
9cb53f26 BP |
363 | [[[["ordinals", |
364 | {"op": "insert", | |
f85f8ebb BP |
365 | "table": "ordinals", |
366 | "row": {"number": 0, "name": "zero"}, | |
21ff1aee | 367 | "uuid-name": "first"}]]], |
9cb53f26 BP |
368 | [[["ordinals", |
369 | {"op": "insert", | |
f85f8ebb BP |
370 | "table": "ordinals", |
371 | "row": {"number": 1, "name": "one"}, | |
21ff1aee | 372 | "uuid-name": "first"}]]], |
9cb53f26 BP |
373 | [[["ordinals", |
374 | {"op": "delete", | |
f85f8ebb | 375 | "table": "ordinals", |
21ff1aee | 376 | "where": [["name", "==", "nought"]]}]]], |
9cb53f26 BP |
377 | [[["ordinals", |
378 | {"op": "select", | |
f85f8ebb BP |
379 | "table": "ordinals", |
380 | "where": [], | |
21ff1aee | 381 | "sort": ["number"]}]]]], |
f85f8ebb BP |
382 | [[[{"uuid":["uuid","<0>"]}] |
383 | [{"uuid":["uuid","<1>"]}] | |
384 | [{"count":0}] | |
385 | [{"rows":[{"_uuid":["uuid","<0>"],"_version":["uuid","<2>"],"name":"zero","number":0},{"_uuid":["uuid","<1>"],"_version":["uuid","<3>"],"name":"one","number":1}]}] | |
386 | ]]) | |
387 | ||
388 | OVSDB_CHECK_EXECUTION([insert rows, delete all], | |
39ab07af | 389 | [ordinal_schema], |
9cb53f26 BP |
390 | [[[["ordinals", |
391 | {"op": "insert", | |
f85f8ebb BP |
392 | "table": "ordinals", |
393 | "row": {"number": 0, "name": "zero"}, | |
394 | "uuid-name": "first"}, | |
395 | {"op": "insert", | |
396 | "table": "ordinals", | |
397 | "row": {"number": 1, "name": "one"}, | |
398 | "uuid-name": "second"}, | |
399 | {"op": "delete", | |
400 | "table": "ordinals", | |
401 | "where": []}, | |
402 | {"op": "select", | |
403 | "table": "ordinals", | |
404 | "where": [], | |
21ff1aee | 405 | "columns": ["name","number"]}]]]], |
f85f8ebb BP |
406 | [[[{"uuid":["uuid","<0>"]},{"uuid":["uuid","<1>"]},{"count":2},{"rows":[]}] |
407 | ]]) | |
408 | ||
409 | OVSDB_CHECK_EXECUTION([insert row, query table, commit], | |
39ab07af | 410 | [ordinal_schema], |
9cb53f26 BP |
411 | [[[["ordinals", |
412 | {"op": "insert", | |
f85f8ebb BP |
413 | "table": "ordinals", |
414 | "row": {"number": 0, "name": "zero"}}, | |
415 | {"op": "select", | |
416 | "table": "ordinals", | |
417 | "where": []}, | |
418 | {"op": "commit", | |
21ff1aee | 419 | "durable": false}]]]], |
f85f8ebb BP |
420 | [[[{"uuid":["uuid","<0>"]},{"rows":[{"_uuid":["uuid","<0>"],"_version":["uuid","<1>"],"name":"zero","number":0}]},{}] |
421 | ]]) | |
422 | ||
423 | OVSDB_CHECK_EXECUTION([insert row, query table, commit durably], | |
39ab07af | 424 | [ordinal_schema], |
9cb53f26 BP |
425 | [[[["ordinals", |
426 | {"op": "insert", | |
f85f8ebb BP |
427 | "table": "ordinals", |
428 | "row": {"number": 0, "name": "zero"}}, | |
429 | {"op": "select", | |
430 | "table": "ordinals", | |
431 | "where": []}, | |
432 | {"op": "commit", | |
21ff1aee | 433 | "durable": true}]]]], |
f85f8ebb BP |
434 | [[[{"uuid":["uuid","<0>"]},{"rows":[{"_uuid":["uuid","<0>"],"_version":["uuid","<1>"],"name":"zero","number":0}]},{}] |
435 | ]]) | |
436 | ||
437 | OVSDB_CHECK_EXECUTION([equality wait with correct rows], | |
39ab07af | 438 | [ordinal_schema], |
9cb53f26 BP |
439 | [[[["ordinals", |
440 | {"op": "insert", | |
f85f8ebb BP |
441 | "table": "ordinals", |
442 | "row": {"number": 0, "name": "zero"}}, | |
443 | {"op": "insert", | |
444 | "table": "ordinals", | |
445 | "row": {"number": 1, "name": "one"}}, | |
446 | {"op": "wait", | |
447 | "timeout": 0, | |
448 | "table": "ordinals", | |
449 | "where": [], | |
450 | "columns": ["name", "number"], | |
451 | "until": "==", | |
452 | "rows": [{"name": "zero", "number": 0}, | |
21ff1aee | 453 | {"name": "one", "number": 1}]}]]]], |
f85f8ebb BP |
454 | [[[{"uuid":["uuid","<0>"]},{"uuid":["uuid","<1>"]},{}] |
455 | ]]) | |
456 | ||
457 | OVSDB_CHECK_EXECUTION([equality wait with extra row], | |
39ab07af | 458 | [ordinal_schema], |
9cb53f26 BP |
459 | [[[["ordinals", |
460 | {"op": "insert", | |
f85f8ebb BP |
461 | "table": "ordinals", |
462 | "row": {"number": 0, "name": "zero"}}, | |
463 | {"op": "insert", | |
464 | "table": "ordinals", | |
465 | "row": {"number": 1, "name": "one"}}, | |
466 | {"op": "wait", | |
467 | "timeout": 0, | |
468 | "table": "ordinals", | |
469 | "where": [], | |
470 | "columns": ["name", "number"], | |
471 | "until": "==", | |
472 | "rows": [{"name": "zero", "number": 0}, | |
473 | {"name": "one", "number": 1}, | |
21ff1aee | 474 | {"name": "two", "number": 2}]}]]]], |
f85f8ebb BP |
475 | [[[{"uuid":["uuid","<0>"]},{"uuid":["uuid","<1>"]},{"details":"\"wait\" timed out","error":"timed out"}] |
476 | ]]) | |
477 | ||
478 | OVSDB_CHECK_EXECUTION([equality wait with missing row], | |
39ab07af | 479 | [ordinal_schema], |
9cb53f26 BP |
480 | [[[["ordinals", |
481 | {"op": "insert", | |
f85f8ebb BP |
482 | "table": "ordinals", |
483 | "row": {"number": 0, "name": "zero"}}, | |
484 | {"op": "insert", | |
485 | "table": "ordinals", | |
486 | "row": {"number": 1, "name": "one"}}, | |
487 | {"op": "wait", | |
488 | "timeout": 0, | |
489 | "table": "ordinals", | |
490 | "where": [], | |
491 | "columns": ["name", "number"], | |
492 | "until": "==", | |
21ff1aee | 493 | "rows": [{"name": "one", "number": 1}]}]]]], |
f85f8ebb BP |
494 | [[[{"uuid":["uuid","<0>"]},{"uuid":["uuid","<1>"]},{"details":"\"wait\" timed out","error":"timed out"}] |
495 | ]]) | |
496 | ||
497 | OVSDB_CHECK_EXECUTION([inequality wait with correct rows], | |
39ab07af | 498 | [ordinal_schema], |
9cb53f26 BP |
499 | [[[["ordinals", |
500 | {"op": "insert", | |
f85f8ebb BP |
501 | "table": "ordinals", |
502 | "row": {"number": 0, "name": "zero"}}, | |
503 | {"op": "insert", | |
504 | "table": "ordinals", | |
505 | "row": {"number": 1, "name": "one"}}, | |
506 | {"op": "wait", | |
507 | "timeout": 0, | |
508 | "table": "ordinals", | |
509 | "where": [], | |
510 | "columns": ["name", "number"], | |
511 | "until": "!=", | |
512 | "rows": [{"name": "zero", "number": 0}, | |
21ff1aee | 513 | {"name": "one", "number": 1}]}]]]], |
f85f8ebb BP |
514 | [[[{"uuid":["uuid","<0>"]},{"uuid":["uuid","<1>"]},{"details":"\"wait\" timed out","error":"timed out"}] |
515 | ]]) | |
516 | ||
517 | OVSDB_CHECK_EXECUTION([inequality wait with extra row], | |
39ab07af | 518 | [ordinal_schema], |
9cb53f26 BP |
519 | [[[["ordinals", |
520 | {"op": "insert", | |
f85f8ebb BP |
521 | "table": "ordinals", |
522 | "row": {"number": 0, "name": "zero"}}, | |
523 | {"op": "insert", | |
524 | "table": "ordinals", | |
525 | "row": {"number": 1, "name": "one"}}, | |
526 | {"op": "wait", | |
527 | "timeout": 0, | |
528 | "table": "ordinals", | |
529 | "where": [], | |
530 | "columns": ["name", "number"], | |
531 | "until": "!=", | |
532 | "rows": [{"name": "zero", "number": 0}, | |
533 | {"name": "one", "number": 1}, | |
21ff1aee | 534 | {"name": "two", "number": 2}]}]]]], |
f85f8ebb BP |
535 | [[[{"uuid":["uuid","<0>"]},{"uuid":["uuid","<1>"]},{}] |
536 | ]]) | |
537 | ||
538 | OVSDB_CHECK_EXECUTION([inequality wait with missing row], | |
39ab07af | 539 | [ordinal_schema], |
9cb53f26 BP |
540 | [[[["ordinals", |
541 | {"op": "insert", | |
f85f8ebb BP |
542 | "table": "ordinals", |
543 | "row": {"number": 0, "name": "zero"}}, | |
544 | {"op": "insert", | |
545 | "table": "ordinals", | |
546 | "row": {"number": 1, "name": "one"}}, | |
547 | {"op": "wait", | |
548 | "timeout": 0, | |
549 | "table": "ordinals", | |
550 | "where": [], | |
551 | "columns": ["name", "number"], | |
552 | "until": "!=", | |
21ff1aee | 553 | "rows": [{"name": "one", "number": 1}]}]]]], |
f85f8ebb BP |
554 | [[[{"uuid":["uuid","<0>"]},{"uuid":["uuid","<1>"]},{}] |
555 | ]]) | |
bd76d25d BP |
556 | |
557 | OVSDB_CHECK_EXECUTION([insert and update constraints], | |
39ab07af | 558 | [constraint_schema], |
9cb53f26 BP |
559 | [[[["constraints", |
560 | {"op": "insert", | |
bd76d25d BP |
561 | "table": "constrained", |
562 | "row": {}}]]], | |
9cb53f26 BP |
563 | [[["constraints", |
564 | {"op": "insert", | |
bd76d25d BP |
565 | "table": "constrained", |
566 | "row": {"positive": -1}}]]], | |
9cb53f26 BP |
567 | [[["constraints", |
568 | {"op": "update", | |
bd76d25d BP |
569 | "table": "constrained", |
570 | "where": [], | |
87ab878c BP |
571 | "row": {"positive": -2}}]]], |
572 | [[["constraints", | |
573 | {"op": "insert", | |
574 | "table": "constrained", | |
575 | "row": {"positive": 1}}]]], | |
576 | [[["constraints", | |
577 | {"op": "insert", | |
578 | "table": "constrained", | |
579 | "row": {"positive": 2}}]]]], | |
bd76d25d BP |
580 | [[[{"details":"0 is less than minimum allowed value 1","error":"constraint violation"}] |
581 | [{"details":"-1 is less than minimum allowed value 1","error":"constraint violation"}] | |
582 | [{"details":"-2 is less than minimum allowed value 1","error":"constraint violation"}] | |
87ab878c BP |
583 | [{"uuid":["uuid","<0>"]}] |
584 | [{"uuid":["uuid","<1>"]},{"details":"transaction causes \"constrained\" table to contain 2 rows, greater than the schema-defined limit of 1 row(s)","error":"constraint violation"}] | |
0d0f05b9 BP |
585 | ]]) |
586 | ||
6910a6e6 | 587 | OVSDB_CHECK_EXECUTION([index uniqueness checking], |
39ab07af | 588 | [ordinal_schema], |
6910a6e6 BP |
589 | dnl Insert initial row. |
590 | [[[["ordinals", | |
591 | {"op": "insert", | |
592 | "table": "ordinals", | |
593 | "row": {"number": 1, "name": "one"}}]]], | |
594 | dnl Try to insert row with identical value (fails). | |
595 | [[["ordinals", | |
596 | {"op": "insert", | |
597 | "table": "ordinals", | |
598 | "row": {"number": 1, "name": "another one"}}]]], | |
599 | dnl Remove initial row and insert new row with identical value in a single | |
600 | dnl transaction (succeeds). | |
601 | [[["ordinals", | |
602 | {"op": "insert", | |
603 | "table": "ordinals", | |
604 | "row": {"number": 1, "name": "another one"}}, | |
605 | {"op": "delete", | |
606 | "table": "ordinals", | |
607 | "where": [["name", "==", "one"]]}]]], | |
608 | dnl Remove row and insert two new rows with identical value in a single | |
609 | dnl transaction (fails). | |
610 | [[["ordinals", | |
611 | {"op": "delete", | |
612 | "table": "ordinals", | |
613 | "where": []}, | |
614 | {"op": "insert", | |
615 | "table": "ordinals", | |
616 | "row": {"number": 1, "name": "one"}}, | |
617 | {"op": "insert", | |
618 | "table": "ordinals", | |
619 | "row": {"number": 1, "name": "still another one"}}]]], | |
620 | dnl Add new row with different value (succeeds). | |
621 | [[["ordinals", | |
622 | {"op": "insert", | |
623 | "table": "ordinals", | |
624 | "row": {"number": 2, "name": "two"}}]]], | |
625 | dnl Change rows so values collide (fails). | |
626 | [[["ordinals", | |
627 | {"op": "update", | |
628 | "table": "ordinals", | |
629 | "where": [], | |
630 | "row": {"number": 3}}]]], | |
631 | dnl Swap rows' values (succeeds). | |
632 | [[["ordinals", | |
633 | {"op": "update", | |
634 | "table": "ordinals", | |
635 | "where": [["number", "==", 1]], | |
636 | "row": {"number": 2, "name": "old two"}}, | |
637 | {"op": "update", | |
638 | "table": "ordinals", | |
639 | "where": [["name", "==", "two"]], | |
640 | "row": {"number": 1, "name": "old one"}}]]], | |
641 | dnl Change all rows' values to values not used before and insert values that | |
642 | dnl collide (only) with their previous values (succeeds). | |
643 | [[["ordinals", | |
644 | {"op": "mutate", | |
645 | "table": "ordinals", | |
646 | "where": [], | |
647 | "mutations": [["number", "*=", 10]]}, | |
648 | {"op": "insert", | |
649 | "table": "ordinals", | |
650 | "row": {"number": 1, "name": "new one"}}, | |
651 | {"op": "insert", | |
652 | "table": "ordinals", | |
653 | "row": {"number": 2, "name": "new two"}}, | |
654 | {"op": "select", | |
655 | "table": "ordinals", | |
656 | "where": [], | |
657 | "columns": ["number", "name"], | |
658 | "sort": ["number"]}]]]], | |
659 | [[[{"uuid":["uuid","<0>"]}] | |
660 | [{"uuid":["uuid","<1>"]},{"details":"Transaction causes multiple rows in \"ordinals\" table to have identical values (1) for index on column \"number\". First row, with UUID <0>, existed in the database before this transaction and was not modified by the transaction. Second row, with UUID <1>, was inserted by this transaction.","error":"constraint violation"}] | |
661 | [{"uuid":["uuid","<2>"]},{"count":1}] | |
662 | [{"count":1},{"uuid":["uuid","<3>"]},{"uuid":["uuid","<4>"]},{"details":"Transaction causes multiple rows in \"ordinals\" table to have identical values (1) for index on column \"number\". First row, with UUID <4>, was inserted by this transaction. Second row, with UUID <3>, was inserted by this transaction.","error":"constraint violation"}] | |
663 | [{"uuid":["uuid","<5>"]}] | |
664 | [{"count":2},{"details":"Transaction causes multiple rows in \"ordinals\" table to have identical values (3) for index on column \"number\". First row, with UUID <5>, had the following index values before the transaction: 2. Second row, with UUID <2>, had the following index values before the transaction: 1.","error":"constraint violation"}] | |
665 | [{"count":1},{"count":1}] | |
666 | [{"count":2},{"uuid":["uuid","<6>"]},{"uuid":["uuid","<7>"]},{"rows":[{"name":"new one","number":1},{"name":"new two","number":2},{"name":"old one","number":10},{"name":"old two","number":20}]}] | |
667 | ]]) | |
668 | ||
0d0f05b9 | 669 | OVSDB_CHECK_EXECUTION([referential integrity -- simple], |
39ab07af | 670 | [constraint_schema], |
9cb53f26 BP |
671 | [[[["constraints", |
672 | {"op": "insert", | |
0d0f05b9 BP |
673 | "table": "b", |
674 | "row": {"b": 1}, | |
675 | "uuid-name": "brow"}, | |
676 | {"op": "insert", | |
677 | "table": "a", | |
678 | "row": {"a": 0, | |
679 | "a2b": ["set", [["named-uuid", "brow"]]]}}, | |
680 | {"op": "insert", | |
681 | "table": "a", | |
682 | "row": {"a": 1, | |
683 | "a2b": ["set", [["named-uuid", "brow"]]]}}, | |
684 | {"op": "insert", | |
685 | "table": "a", | |
686 | "row": {"a": 2, | |
687 | "a2b": ["set", [["named-uuid", "brow"]]]}}]]], | |
9cb53f26 BP |
688 | [[["constraints", |
689 | {"op": "delete", | |
0d0f05b9 BP |
690 | "table": "b", |
691 | "where": []}]]], | |
b7585d1d BP |
692 | dnl Check that "mutate" honors number-of-elements constraints on sets and maps. |
693 | [[["constraints", | |
694 | {"op": "mutate", | |
695 | "table": "b", | |
696 | "where": [], | |
697 | "mutations": [["x", "delete", 0]]}]]], | |
9cb53f26 BP |
698 | [[["constraints", |
699 | {"op": "delete", | |
0d0f05b9 BP |
700 | "table": "a", |
701 | "where": [["a", "==", 0]]}]]], | |
9cb53f26 BP |
702 | [[["constraints", |
703 | {"op": "delete", | |
0d0f05b9 BP |
704 | "table": "b", |
705 | "where": []}]]], | |
9cb53f26 BP |
706 | [[["constraints", |
707 | {"op": "delete", | |
0d0f05b9 BP |
708 | "table": "a", |
709 | "where": [["a", "==", 1]]}]]], | |
9cb53f26 BP |
710 | [[["constraints", |
711 | {"op": "delete", | |
0d0f05b9 BP |
712 | "table": "b", |
713 | "where": []}]]], | |
9cb53f26 BP |
714 | [[["constraints", |
715 | {"op": "delete", | |
0d0f05b9 BP |
716 | "table": "a", |
717 | "where": [["a", "==", 2]]}]]], | |
9cb53f26 BP |
718 | [[["constraints", |
719 | {"op": "delete", | |
0d0f05b9 BP |
720 | "table": "b", |
721 | "where": []}]]]], | |
722 | [[[{"uuid":["uuid","<0>"]},{"uuid":["uuid","<1>"]},{"uuid":["uuid","<2>"]},{"uuid":["uuid","<3>"]}] | |
723 | [{"count":1},{"details":"cannot delete b row <0> because of 3 remaining reference(s)","error":"referential integrity violation"}] | |
b7585d1d | 724 | [{"details":"Attempted to store 0 elements in set of 1 to 2 integers.","error":"constraint violation"}] |
0d0f05b9 BP |
725 | [{"count":1}] |
726 | [{"count":1},{"details":"cannot delete b row <0> because of 2 remaining reference(s)","error":"referential integrity violation"}] | |
727 | [{"count":1}] | |
728 | [{"count":1},{"details":"cannot delete b row <0> because of 1 remaining reference(s)","error":"referential integrity violation"}] | |
729 | [{"count":1}] | |
730 | [{"count":1}] | |
731 | ]]) | |
732 | ||
733 | OVSDB_CHECK_EXECUTION([referential integrity -- mutual references], | |
39ab07af | 734 | [constraint_schema], |
9cb53f26 BP |
735 | [[[["constraints", |
736 | {"op": "insert", | |
0d0f05b9 BP |
737 | "table": "a", |
738 | "row": {"a": 0, | |
739 | "a2b": ["set", [["named-uuid", "row2"]]], | |
740 | "a2a": ["set", [["named-uuid", "row1"]]]}, | |
741 | "uuid-name": "row1"}, | |
742 | {"op": "insert", | |
743 | "table": "b", | |
744 | "row": {"b": 1, | |
745 | "b2b": ["set", [["named-uuid", "row2"]]], | |
746 | "b2a": ["set", [["named-uuid", "row1"]]]}, | |
747 | "uuid-name": "row2"}]]], | |
9cb53f26 BP |
748 | [[["constraints", |
749 | {"op": "insert", | |
0d0f05b9 BP |
750 | "table": "a", |
751 | "row": {"a2b": ["set", [["uuid", "b516b960-5b19-4fc2-bb82-fe1cbd6d0241"]]]}}]]], | |
9cb53f26 BP |
752 | [[["constraints", |
753 | {"op": "delete", | |
0d0f05b9 BP |
754 | "table": "a", |
755 | "where": [["a", "==", 0]]}]]], | |
9cb53f26 BP |
756 | [[["constraints", |
757 | {"op": "delete", | |
0d0f05b9 BP |
758 | "table": "b", |
759 | "where": [["b", "==", 1]]}]]], | |
760 | dnl Try the deletions again to make sure that the refcounts got rolled back. | |
9cb53f26 BP |
761 | [[["constraints", |
762 | {"op": "delete", | |
0d0f05b9 BP |
763 | "table": "a", |
764 | "where": [["a", "==", 0]]}]]], | |
9cb53f26 BP |
765 | [[["constraints", |
766 | {"op": "delete", | |
0d0f05b9 BP |
767 | "table": "b", |
768 | "where": [["b", "==", 1]]}]]], | |
9cb53f26 BP |
769 | [[["constraints", |
770 | {"op": "delete", | |
0d0f05b9 BP |
771 | "table": "a", |
772 | "where": [["a", "==", 0]]}, | |
773 | {"op": "delete", | |
774 | "table": "b", | |
775 | "where": [["b", "==", 1]]}]]]], | |
fbf925e4 | 776 | [[[{"uuid":["uuid","<0>"]},{"uuid":["uuid","<1>"]}] |
97f7803b | 777 | [{"uuid":["uuid","<2>"]},{"details":"Table a column a2b row <2> references nonexistent row <3> in table b.","error":"referential integrity violation"}] |
0d0f05b9 BP |
778 | [{"count":1},{"details":"cannot delete a row <0> because of 1 remaining reference(s)","error":"referential integrity violation"}] |
779 | [{"count":1},{"details":"cannot delete b row <1> because of 1 remaining reference(s)","error":"referential integrity violation"}] | |
780 | [{"count":1},{"details":"cannot delete a row <0> because of 1 remaining reference(s)","error":"referential integrity violation"}] | |
781 | [{"count":1},{"details":"cannot delete b row <1> because of 1 remaining reference(s)","error":"referential integrity violation"}] | |
782 | [{"count":1},{"count":1}] | |
7360012b BP |
783 | ]]) |
784 | ||
785 | OVSDB_CHECK_EXECUTION([weak references], | |
39ab07af | 786 | [weak_schema], |
7360012b BP |
787 | [[[["weak", |
788 | {"op": "insert", | |
789 | "table": "a", | |
790 | "row": {"a": 0, | |
791 | "a2a": ["set", [["named-uuid", "row1"], | |
792 | ["named-uuid", "row2"], | |
793 | ["uuid", "0e767b36-6822-4044-8307-d58467e04669"]]], | |
794 | "a2a1": ["named-uuid", "row1"], | |
795 | "a2b": ["named-uuid", "row3"]}, | |
796 | "uuid-name": "row1"}, | |
797 | {"op": "insert", | |
798 | "table": "a", | |
799 | "row": {"a": 1, | |
800 | "a2a": ["set", [["named-uuid", "row1"], | |
801 | ["named-uuid", "row2"]]], | |
802 | "a2a1": ["named-uuid", "row2"], | |
803 | "a2b": ["named-uuid", "row3"]}, | |
804 | "uuid-name": "row2"}, | |
805 | {"op": "insert", | |
806 | "table": "a", | |
807 | "row": {"a": 2, | |
808 | "a2a": ["set", [["named-uuid", "row1"], | |
809 | ["named-uuid", "row2"]]], | |
810 | "a2a1": ["named-uuid", "row2"], | |
811 | "a2b": ["named-uuid", "row4"]}}, | |
812 | {"op": "insert", | |
813 | "table": "b", | |
814 | "row": {"b": 2, | |
815 | "b2a": ["named-uuid", "row1"]}, | |
816 | "uuid-name": "row3"}, | |
817 | {"op": "insert", | |
818 | "table": "b", | |
819 | "row": {"b": 3, | |
820 | "b2a": ["named-uuid", "row2"]}, | |
821 | "uuid-name": "row4"}]]], | |
822 | dnl Check that the nonexistent row UUID we added to row a0 was deleted, | |
823 | dnl and that other rows were inserted as requested. | |
824 | [[["weak", | |
825 | {"op": "select", | |
826 | "table": "a", | |
827 | "where": [], | |
828 | "columns": ["_uuid", "a2a", "a2a1", "a2b"], | |
829 | "sort": ["a"]}]]], | |
830 | [[["weak", | |
831 | {"op": "select", | |
832 | "table": "b", | |
833 | "where": [], | |
834 | "columns": ["_uuid", "b", "b2a"], | |
835 | "sort": ["b"]}]]], | |
836 | dnl Try to insert invalid all-zeros weak reference (the default) into | |
837 | dnl "a2b", which requires exactly one value. | |
838 | [[["weak", | |
839 | {"op": "insert", | |
840 | "table": "a", | |
1f4f3cd7 BP |
841 | "row": {"a2a1": ["named-uuid", "me"]}, |
842 | "uuid-name": "me"}]]], | |
7360012b BP |
843 | dnl Try to delete row from "b" that is referred to by weak references |
844 | dnl from "a" table "a2b" column that requires exactly one value. | |
845 | [[["weak", | |
846 | {"op": "delete", | |
847 | "table": "b", | |
848 | "where": [["b", "==", 3]]}]]], | |
849 | dnl Try to delete row from "a" that is referred to by weak references | |
850 | dnl from "a" table "a2a1" column that requires exactly one value. | |
851 | [[["weak", | |
852 | {"op": "delete", | |
853 | "table": "a", | |
854 | "where": [["a", "==", 1]]}]]], | |
855 | dnl Delete the row that had the reference that caused the previous | |
856 | dnl deletion to fail, then check that other rows are unchanged. | |
857 | [[["weak", | |
858 | {"op": "delete", | |
859 | "table": "a", | |
860 | "where": [["a", "==", 2]]}]]], | |
861 | [[["weak", | |
862 | {"op": "select", | |
863 | "table": "a", | |
864 | "where": [], | |
865 | "columns": ["_uuid", "a2a", "a2a1", "a2b"], | |
866 | "sort": ["a"]}]]], | |
867 | [[["weak", | |
868 | {"op": "select", | |
869 | "table": "b", | |
870 | "where": [], | |
871 | "columns": ["_uuid", "b", "b2a"], | |
872 | "sort": ["b"]}]]], | |
873 | dnl Delete row a0 then check that references to it were removed. | |
874 | [[["weak", | |
875 | {"op": "delete", | |
876 | "table": "a", | |
877 | "where": [["a", "==", 0]]}]]], | |
878 | [[["weak", | |
879 | {"op": "select", | |
880 | "table": "a", | |
881 | "where": [], | |
882 | "columns": ["_uuid", "a2a", "a2a1", "a2b"], | |
883 | "sort": ["a"]}]]], | |
884 | [[["weak", | |
885 | {"op": "select", | |
886 | "table": "b", | |
887 | "where": [], | |
888 | "columns": ["_uuid", "b", "b2a"], | |
889 | "sort": ["b"]}]]], | |
890 | dnl Delete row a1 then check that references to it were removed. | |
891 | [[["weak", | |
892 | {"op": "delete", | |
893 | "table": "a", | |
894 | "where": [["a", "==", 1]]}]]], | |
895 | [[["weak", | |
896 | {"op": "select", | |
897 | "table": "a", | |
898 | "where": [], | |
899 | "columns": ["_uuid", "a2a", "a2a1", "a2b"], | |
900 | "sort": ["a"]}]]], | |
901 | [[["weak", | |
902 | {"op": "select", | |
903 | "table": "b", | |
904 | "where": [], | |
905 | "columns": ["_uuid", "b", "b2a"], | |
906 | "sort": ["b"]}]]]], | |
907 | [[[{"uuid":["uuid","<0>"]},{"uuid":["uuid","<1>"]},{"uuid":["uuid","<2>"]},{"uuid":["uuid","<3>"]},{"uuid":["uuid","<4>"]}] | |
908 | [{"rows":[{"_uuid":["uuid","<0>"],"a2a":["set",[["uuid","<0>"],["uuid","<1>"]]],"a2a1":["uuid","<0>"],"a2b":["uuid","<3>"]},{"_uuid":["uuid","<1>"],"a2a":["set",[["uuid","<0>"],["uuid","<1>"]]],"a2a1":["uuid","<1>"],"a2b":["uuid","<3>"]},{"_uuid":["uuid","<2>"],"a2a":["set",[["uuid","<0>"],["uuid","<1>"]]],"a2a1":["uuid","<1>"],"a2b":["uuid","<4>"]}]}] | |
909 | [{"rows":[{"_uuid":["uuid","<3>"],"b":2,"b2a":["uuid","<0>"]},{"_uuid":["uuid","<4>"],"b":3,"b2a":["uuid","<1>"]}]}] | |
910 | [{"uuid":["uuid","<5>"]},{"details":"Weak reference column \"a2b\" in \"a\" row <5> (inserted within this transaction) contained all-zeros UUID (probably as the default value for this column) but deleting this value caused a constraint volation because this column is not allowed to be empty.","error":"constraint violation"}] | |
911 | [{"count":1},{"details":"Deletion of 1 weak reference(s) to deleted (or never-existing) rows from column \"a2b\" in \"a\" row <2> caused this column to become empty, but constraints on this column disallow an empty column.","error":"constraint violation"}] | |
912 | [{"count":1},{"details":"Deletion of 1 weak reference(s) to deleted (or never-existing) rows from column \"a2a1\" in \"a\" row <2> caused this column to become empty, but constraints on this column disallow an empty column.","error":"constraint violation"}] | |
913 | [{"count":1}] | |
914 | [{"rows":[{"_uuid":["uuid","<0>"],"a2a":["set",[["uuid","<0>"],["uuid","<1>"]]],"a2a1":["uuid","<0>"],"a2b":["uuid","<3>"]},{"_uuid":["uuid","<1>"],"a2a":["set",[["uuid","<0>"],["uuid","<1>"]]],"a2a1":["uuid","<1>"],"a2b":["uuid","<3>"]}]}] | |
915 | [{"rows":[{"_uuid":["uuid","<3>"],"b":2,"b2a":["uuid","<0>"]},{"_uuid":["uuid","<4>"],"b":3,"b2a":["uuid","<1>"]}]}] | |
916 | [{"count":1}] | |
917 | [{"rows":[{"_uuid":["uuid","<1>"],"a2a":["uuid","<1>"],"a2a1":["uuid","<1>"],"a2b":["uuid","<3>"]}]}] | |
918 | [{"rows":[{"_uuid":["uuid","<3>"],"b":2,"b2a":["set",[]]},{"_uuid":["uuid","<4>"],"b":3,"b2a":["uuid","<1>"]}]}] | |
919 | [{"count":1}] | |
920 | [{"rows":[]}] | |
921 | [{"rows":[{"_uuid":["uuid","<3>"],"b":2,"b2a":["set",[]]},{"_uuid":["uuid","<4>"],"b":3,"b2a":["set",[]]}]}] | |
c5f341ab BP |
922 | ]]) |
923 | ||
341c4e59 BP |
924 | OVSDB_CHECK_EXECUTION([immutable columns], |
925 | [immutable_schema], | |
926 | [[[["immutable", | |
927 | {"op": "insert", | |
928 | "table": "a", | |
929 | "row": {"i": 5}, | |
930 | "uuid-name": "row1"}]]], | |
931 | [[["immutable", | |
932 | {"op": "update", | |
933 | "table": "a", | |
934 | "row": {"i": 10}, | |
935 | "where": []}]]], | |
936 | [[["immutable", | |
937 | {"op": "update", | |
938 | "table": "a", | |
939 | "row": {"i": 5}, | |
940 | "where": []}]]], | |
941 | [[["immutable", | |
942 | {"op": "mutate", | |
943 | "table": "a", | |
944 | "where": [], | |
945 | "mutations": [["i", "-=", 5]]}]]], | |
946 | [[["immutable", | |
947 | {"op": "mutate", | |
948 | "table": "a", | |
949 | "where": [], | |
950 | "mutations": [["i", "*=", 1]]}]]]], | |
951 | [[[{"uuid":["uuid","<0>"]}] | |
952 | [{"details":"Cannot update immutable column i in table a.","error":"constraint violation","syntax":"{\"op\":\"update\",\"row\":{\"i\":10},\"table\":\"a\",\"where\":[]}"}] | |
953 | [{"details":"Cannot update immutable column i in table a.","error":"constraint violation","syntax":"{\"op\":\"update\",\"row\":{\"i\":5},\"table\":\"a\",\"where\":[]}"}] | |
954 | [{"details":"Cannot mutate immutable column i in table a.","error":"constraint violation","syntax":"[\"i\",\"-=\",5]"}] | |
955 | [{"details":"Cannot mutate immutable column i in table a.","error":"constraint violation","syntax":"[\"i\",\"*=\",1]"}] | |
956 | ]]) | |
957 | ||
c5f341ab | 958 | OVSDB_CHECK_EXECUTION([garbage collection], |
39ab07af | 959 | [gc_schema], |
c5f341ab BP |
960 | [dnl Check that inserting a row without any references is a no-op. |
961 | [[["gc", | |
962 | {"op": "insert", | |
963 | "table": "a", | |
964 | "row": {"a": 0}}]]], | |
965 | [[["gc", | |
966 | {"op": "select", | |
967 | "table": "a", | |
968 | "where": [], | |
969 | "columns": ["a"]}]]], | |
970 | dnl Check that inserting a chain of rows that reference each other | |
971 | dnl in turn is also a no-op. | |
972 | [[["gc", | |
973 | {"op": "insert", | |
974 | "table": "a", | |
975 | "row": {"a": 0, "a2a": ["named-uuid", "row1"]}, | |
976 | "uuid-name": "row0"}, | |
977 | {"op": "insert", | |
978 | "table": "a", | |
979 | "row": {"a": 1, "a2a": ["named-uuid", "row2"]}, | |
980 | "uuid-name": "row1"}, | |
981 | {"op": "insert", | |
982 | "table": "a", | |
983 | "row": {"a": 2, "a2a": ["named-uuid", "row3"]}, | |
984 | "uuid-name": "row2"}, | |
985 | {"op": "insert", | |
986 | "table": "a", | |
987 | "row": {"a": 3}, | |
988 | "uuid-name": "row3"}]]], | |
989 | [[["gc", | |
990 | {"op": "select", | |
991 | "table": "a", | |
992 | "where": [], | |
993 | "columns": ["a"]}]]], | |
994 | dnl Check that inserting a pair of rows that mutually reference each | |
995 | dnl other causes the rows to be retained. | |
996 | [[["gc", | |
997 | {"op": "insert", | |
998 | "table": "a", | |
999 | "row": {"a": 4, "a2a": ["named-uuid", "row5"]}, | |
1000 | "uuid-name": "row4"}, | |
1001 | {"op": "insert", | |
1002 | "table": "a", | |
1003 | "row": {"a": 5, "a2a": ["named-uuid", "row4"]}, | |
1004 | "uuid-name": "row5"}]]], | |
1005 | [[["gc", | |
1006 | {"op": "select", | |
1007 | "table": "a", | |
1008 | "where": [], | |
1009 | "columns": ["a"], | |
1010 | "sort": ["a"]}]]], | |
1011 | dnl Check that unreferencing one of the rows causes the other to be deleted. | |
1012 | [[["gc", | |
1013 | {"op": "update", | |
1014 | "table": "a", | |
1015 | "where": [["a", "==", 4]], | |
1016 | "row": {"a2a": ["set", []]}}]]], | |
1017 | [[["gc", | |
1018 | {"op": "select", | |
1019 | "table": "a", | |
1020 | "where": [], | |
1021 | "columns": ["a"]}]]], | |
1022 | dnl Check that inserting a pair of rows that mutually weak reference each | |
1023 | dnl other is a no-op. | |
1024 | [[["gc", | |
1025 | {"op": "insert", | |
1026 | "table": "a", | |
1027 | "row": {"a": 6, "wa2a": ["named-uuid", "row7"]}, | |
1028 | "uuid-name": "row6"}, | |
1029 | {"op": "insert", | |
1030 | "table": "a", | |
1031 | "row": {"a": 7, "wa2a": ["named-uuid", "row6"]}, | |
1032 | "uuid-name": "row7"}]]], | |
1033 | [[["gc", | |
1034 | {"op": "select", | |
1035 | "table": "a", | |
1036 | "where": [], | |
1037 | "columns": ["a"]}]]], | |
1038 | dnl Check that a circular chain of rows is retained. | |
1039 | [[["gc", | |
1040 | {"op": "insert", | |
1041 | "table": "a", | |
1042 | "row": {"a": 8, "a2a": ["named-uuid", "row9"]}, | |
1043 | "uuid-name": "row8"}, | |
1044 | {"op": "insert", | |
1045 | "table": "a", | |
1046 | "row": {"a": 9, "a2a": ["named-uuid", "row10"]}, | |
1047 | "uuid-name": "row9"}, | |
1048 | {"op": "insert", | |
1049 | "table": "a", | |
1050 | "row": {"a": 10, "a2a": ["named-uuid", "row11"]}, | |
1051 | "uuid-name": "row10"}, | |
1052 | {"op": "insert", | |
1053 | "table": "a", | |
1054 | "row": {"a": 11, "a2a": ["named-uuid", "row8"]}, | |
1055 | "uuid-name": "row11"}]]], | |
1056 | [[["gc", | |
1057 | {"op": "select", | |
1058 | "table": "a", | |
1059 | "where": [], | |
1060 | "columns": ["a"], | |
1061 | "sort": ["a"]}]]], | |
1062 | dnl Check that breaking the chain causes all of the rows to be deleted. | |
1063 | [[["gc", | |
1064 | {"op": "update", | |
1065 | "table": "a", | |
1066 | "where": [["a", "==", 9]], | |
1067 | "row": {"a2a": ["set", []]}}]]], | |
1068 | [[["gc", | |
1069 | {"op": "select", | |
1070 | "table": "a", | |
1071 | "where": [], | |
1072 | "columns": ["a"]}]]], | |
1073 | dnl Check that inserting a row only referenced by itself is a no-op. | |
1074 | [[["gc", | |
1075 | {"op": "insert", | |
1076 | "table": "a", | |
1077 | "row": {"a": 12, "a2a": ["named-uuid", "self"]}, | |
1078 | "uuid-name": "self"}]]], | |
1079 | [[["gc", | |
1080 | {"op": "select", | |
1081 | "table": "a", | |
1082 | "where": [], | |
1083 | "columns": ["a"]}]]]], | |
1084 | [[[{"uuid":["uuid","<0>"]}] | |
1085 | [{"rows":[]}] | |
1086 | [{"uuid":["uuid","<1>"]},{"uuid":["uuid","<2>"]},{"uuid":["uuid","<3>"]},{"uuid":["uuid","<4>"]}] | |
1087 | [{"rows":[]}] | |
1088 | [{"uuid":["uuid","<5>"]},{"uuid":["uuid","<6>"]}] | |
1089 | [{"rows":[{"a":4},{"a":5}]}] | |
1090 | [{"count":1}] | |
1091 | [{"rows":[]}] | |
1092 | [{"uuid":["uuid","<7>"]},{"uuid":["uuid","<8>"]}] | |
1093 | [{"rows":[]}] | |
1094 | [{"uuid":["uuid","<9>"]},{"uuid":["uuid","<10>"]},{"uuid":["uuid","<11>"]},{"uuid":["uuid","<12>"]}] | |
1095 | [{"rows":[{"a":8},{"a":9},{"a":10},{"a":11}]}] | |
1096 | [{"count":1}] | |
1097 | [{"rows":[]}] | |
1098 | [{"uuid":["uuid","<13>"]}] | |
1099 | [{"rows":[]}] | |
bd76d25d | 1100 | ]])]) |
21ff1aee BP |
1101 | |
1102 | EXECUTION_EXAMPLES |