]> git.proxmox.com Git - mirror_ovs.git/blob - tests/ovsdb-execution.at
ofp-actions: Only set defined bits when encoding "load" actions.
[mirror_ovs.git] / tests / ovsdb-execution.at
1 AT_BANNER([OVSDB -- execution])
2
3 m4_divert_push([PREPARE_TESTS])
4 [
5
6 ordinal_schema () {
7 cat <<'EOF'
8 {"name": "ordinals",
9 "tables": {
10 "ordinals": {
11 "columns": {
12 "number": {"type": "integer"},
13 "name": {"type": "string"}},
14 "indexes": [["number"]]}},
15 "version": "5.1.3",
16 "cksum": "12345678 9"}
17 EOF
18 }
19
20 constraint_schema () {
21 cat << 'EOF'
22 {"name": "constraints",
23 "tables": {
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"},
37 "min": 0, "max": "unlimited"}},
38 "x": {"type": {"key": "integer", "min": 1, "max": 2}}}},
39 "constrained": {
40 "columns": {
41 "positive": {"type": {"key": {"type": "integer",
42 "minInteger": 1}}}},
43 "maxRows": 1}}}
44 EOF
45 }
46
47 weak_schema () {
48 cat <<'EOF'
49 {"name": "weak",
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"},
70 "min": 0, "max": "unlimited"}}}}}}
71 EOF
72 }
73
74 gc_schema () {
75 cat <<'EOF'
76 {"name": "gc",
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"}}},
111 "isRoot": false}}}
112 EOF
113 }
114
115 immutable_schema () {
116 cat <<'EOF'
117 {"name": "immutable",
118 "tables": {
119 "a": {
120 "columns": {"i": {"type": "integer", "mutable": false}}}}}
121 EOF
122 }
123 ]
124 m4_divert_pop([PREPARE_TESTS])
125
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
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.
136 #
137 # TITLE is provided to AT_SETUP and KEYWORDS to AT_KEYWORDS.
138 m4_define([OVSDB_CHECK_EXECUTION],
139 [AT_SETUP([$1])
140 AT_KEYWORDS([ovsdb execute execution positive $5])
141 OVS_RUNDIR=`pwd`; export OVS_RUNDIR
142 AT_CHECK([test-ovsdb execute "`$2`" m4_foreach([txn], [$3], [ 'txn'])],
143 [0], [stdout], [])
144 AT_CHECK([${PERL} $srcdir/uuidfilt.pl stdout], [0], [$4])
145 AT_CLEANUP])
146
147 OVSDB_CHECK_EXECUTION([uuid-name must be <id>],
148 [constraint_schema],
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>],
158 [constraint_schema],
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
166 OVSDB_CHECK_EXECUTION([duplicate uuid-name not allowed],
167 [ordinal_schema],
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
180 m4_define([ONE_EXECUTION_EXAMPLE], [dnl
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],
184 [ordinal_schema],
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 ]])
196 ])
197
198 m4_define([EXECUTION_EXAMPLES], [
199 ONE_EXECUTION_EXAMPLE
200 OVSDB_CHECK_EXECUTION([insert row, query table],
201 [ordinal_schema],
202 [[[["ordinals",
203 {"op": "insert",
204 "table": "ordinals",
205 "row": {"number": 0, "name": "zero"}}]]],
206 [[["ordinals",
207 {"op": "select",
208 "table": "ordinals",
209 "where": []}]]]],
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],
215 [ordinal_schema],
216 [[[["ordinals",
217 {"op": "insert",
218 "table": "ordinals",
219 "row": {"number": 0, "name": "zero"}}]]],
220 [[["ordinals",
221 {"op": "insert",
222 "table": "ordinals",
223 "row": {"number": 1, "name": "one"}}]]],
224 [[["ordinals",
225 {"op": "select",
226 "table": "ordinals",
227 "where": [["name", "==", "zero"]]}]]],
228 [[["ordinals",
229 {"op": "select",
230 "table": "ordinals",
231 "where": [["name", "==", "one"]]}]]]],
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],
239 [ordinal_schema],
240 [[[["ordinals",
241 {"op": "insert",
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",
254 "where": [["_uuid", "==", ["named-uuid", "second"]]]}]]]],
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],
259 [ordinal_schema],
260 [[[["ordinals",
261 {"op": "insert",
262 "table": "ordinals",
263 "row": {"number": 0, "name": "zero"},
264 "uuid-name": "first"}]]],
265 [[["ordinals",
266 {"op": "insert",
267 "table": "ordinals",
268 "row": {"number": 1, "name": "one"},
269 "uuid-name": "first"}]]],
270 [[["ordinals",
271 {"op": "update",
272 "table": "ordinals",
273 "where": [["name", "==", "zero"]],
274 "row": {"name": "nought"}}]]],
275 [[["ordinals",
276 {"op": "select",
277 "table": "ordinals",
278 "where": [],
279 "sort": ["number"]}]]]],
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
286 OVSDB_CHECK_EXECUTION([insert rows, mutate rows],
287 [ordinal_schema],
288 [[[["ordinals",
289 {"op": "insert",
290 "table": "ordinals",
291 "row": {"number": 0, "name": "zero"},
292 "uuid-name": "first"}]]],
293 [[["ordinals",
294 {"op": "insert",
295 "table": "ordinals",
296 "row": {"number": 1, "name": "one"},
297 "uuid-name": "first"}]]],
298 [[["ordinals",
299 {"op": "mutate",
300 "table": "ordinals",
301 "where": [["name", "==", "zero"]],
302 "mutations": [["number", "+=", 2]]}]]],
303 [[["ordinals",
304 {"op": "select",
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
314 OVSDB_CHECK_EXECUTION([insert rows, delete by named-uuid],
315 [ordinal_schema],
316 [[[["ordinals",
317 {"op": "insert",
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": [],
331 "columns": ["name","number"]}]]]],
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],
336 [ordinal_schema],
337 [[[["ordinals",
338 {"op": "insert",
339 "table": "ordinals",
340 "row": {"number": 0, "name": "zero"},
341 "uuid-name": "first"}]]],
342 [[["ordinals",
343 {"op": "insert",
344 "table": "ordinals",
345 "row": {"number": 1, "name": "one"},
346 "uuid-name": "first"}]]],
347 [[["ordinals",
348 {"op": "delete",
349 "table": "ordinals",
350 "where": [["name", "==", "zero"]]}]]],
351 [[["ordinals",
352 {"op": "select",
353 "table": "ordinals",
354 "where": []}]]]],
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],
362 [ordinal_schema],
363 [[[["ordinals",
364 {"op": "insert",
365 "table": "ordinals",
366 "row": {"number": 0, "name": "zero"},
367 "uuid-name": "first"}]]],
368 [[["ordinals",
369 {"op": "insert",
370 "table": "ordinals",
371 "row": {"number": 1, "name": "one"},
372 "uuid-name": "first"}]]],
373 [[["ordinals",
374 {"op": "delete",
375 "table": "ordinals",
376 "where": [["name", "==", "nought"]]}]]],
377 [[["ordinals",
378 {"op": "select",
379 "table": "ordinals",
380 "where": [],
381 "sort": ["number"]}]]]],
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],
389 [ordinal_schema],
390 [[[["ordinals",
391 {"op": "insert",
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": [],
405 "columns": ["name","number"]}]]]],
406 [[[{"uuid":["uuid","<0>"]},{"uuid":["uuid","<1>"]},{"count":2},{"rows":[]}]
407 ]])
408
409 OVSDB_CHECK_EXECUTION([insert row, query table, commit],
410 [ordinal_schema],
411 [[[["ordinals",
412 {"op": "insert",
413 "table": "ordinals",
414 "row": {"number": 0, "name": "zero"}},
415 {"op": "select",
416 "table": "ordinals",
417 "where": []},
418 {"op": "commit",
419 "durable": false}]]]],
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],
424 [ordinal_schema],
425 [[[["ordinals",
426 {"op": "insert",
427 "table": "ordinals",
428 "row": {"number": 0, "name": "zero"}},
429 {"op": "select",
430 "table": "ordinals",
431 "where": []},
432 {"op": "commit",
433 "durable": true}]]]],
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],
438 [ordinal_schema],
439 [[[["ordinals",
440 {"op": "insert",
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},
453 {"name": "one", "number": 1}]}]]]],
454 [[[{"uuid":["uuid","<0>"]},{"uuid":["uuid","<1>"]},{}]
455 ]])
456
457 OVSDB_CHECK_EXECUTION([equality wait with extra row],
458 [ordinal_schema],
459 [[[["ordinals",
460 {"op": "insert",
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},
474 {"name": "two", "number": 2}]}]]]],
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],
479 [ordinal_schema],
480 [[[["ordinals",
481 {"op": "insert",
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": "==",
493 "rows": [{"name": "one", "number": 1}]}]]]],
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],
498 [ordinal_schema],
499 [[[["ordinals",
500 {"op": "insert",
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},
513 {"name": "one", "number": 1}]}]]]],
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],
518 [ordinal_schema],
519 [[[["ordinals",
520 {"op": "insert",
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},
534 {"name": "two", "number": 2}]}]]]],
535 [[[{"uuid":["uuid","<0>"]},{"uuid":["uuid","<1>"]},{}]
536 ]])
537
538 OVSDB_CHECK_EXECUTION([inequality wait with missing row],
539 [ordinal_schema],
540 [[[["ordinals",
541 {"op": "insert",
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": "!=",
553 "rows": [{"name": "one", "number": 1}]}]]]],
554 [[[{"uuid":["uuid","<0>"]},{"uuid":["uuid","<1>"]},{}]
555 ]])
556
557 OVSDB_CHECK_EXECUTION([insert and update constraints],
558 [constraint_schema],
559 [[[["constraints",
560 {"op": "insert",
561 "table": "constrained",
562 "row": {}}]]],
563 [[["constraints",
564 {"op": "insert",
565 "table": "constrained",
566 "row": {"positive": -1}}]]],
567 [[["constraints",
568 {"op": "update",
569 "table": "constrained",
570 "where": [],
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}}]]]],
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"}]
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"}]
585 ]])
586
587 OVSDB_CHECK_EXECUTION([index uniqueness checking],
588 [ordinal_schema],
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
669 OVSDB_CHECK_EXECUTION([referential integrity -- simple],
670 [constraint_schema],
671 [[[["constraints",
672 {"op": "insert",
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"]]]}}]]],
688 [[["constraints",
689 {"op": "delete",
690 "table": "b",
691 "where": []}]]],
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]]}]]],
698 [[["constraints",
699 {"op": "delete",
700 "table": "a",
701 "where": [["a", "==", 0]]}]]],
702 [[["constraints",
703 {"op": "delete",
704 "table": "b",
705 "where": []}]]],
706 [[["constraints",
707 {"op": "delete",
708 "table": "a",
709 "where": [["a", "==", 1]]}]]],
710 [[["constraints",
711 {"op": "delete",
712 "table": "b",
713 "where": []}]]],
714 [[["constraints",
715 {"op": "delete",
716 "table": "a",
717 "where": [["a", "==", 2]]}]]],
718 [[["constraints",
719 {"op": "delete",
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"}]
724 [{"details":"Attempted to store 0 elements in set of 1 to 2 integers.","error":"constraint violation"}]
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],
734 [constraint_schema],
735 [[[["constraints",
736 {"op": "insert",
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"}]]],
748 [[["constraints",
749 {"op": "insert",
750 "table": "a",
751 "row": {"a2b": ["set", [["uuid", "b516b960-5b19-4fc2-bb82-fe1cbd6d0241"]]]}}]]],
752 [[["constraints",
753 {"op": "delete",
754 "table": "a",
755 "where": [["a", "==", 0]]}]]],
756 [[["constraints",
757 {"op": "delete",
758 "table": "b",
759 "where": [["b", "==", 1]]}]]],
760 dnl Try the deletions again to make sure that the refcounts got rolled back.
761 [[["constraints",
762 {"op": "delete",
763 "table": "a",
764 "where": [["a", "==", 0]]}]]],
765 [[["constraints",
766 {"op": "delete",
767 "table": "b",
768 "where": [["b", "==", 1]]}]]],
769 [[["constraints",
770 {"op": "delete",
771 "table": "a",
772 "where": [["a", "==", 0]]},
773 {"op": "delete",
774 "table": "b",
775 "where": [["b", "==", 1]]}]]]],
776 [[[{"uuid":["uuid","<0>"]},{"uuid":["uuid","<1>"]}]
777 [{"uuid":["uuid","<2>"]},{"details":"Table a column a2b row <2> references nonexistent row <3> in table b.","error":"referential integrity violation"}]
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}]
783 ]])
784
785 OVSDB_CHECK_EXECUTION([weak references],
786 [weak_schema],
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",
841 "row": {"a2a1": ["named-uuid", "me"]},
842 "uuid-name": "me"}]]],
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",[]]}]}]
922 ]])
923
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
958 OVSDB_CHECK_EXECUTION([garbage collection],
959 [gc_schema],
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":[]}]
1100 ]])])
1101
1102 EXECUTION_EXAMPLES