1 AT_BANNER([OVSDB -- execution])
3 m4_divert_push([PREPARE_TESTS])
12 "number": {"type": "integer"},
13 "name": {"type": "string"}},
14 "indexes": [["number"]]}},
16 "cksum": "12345678 9"}
20 constraint_schema () {
22 {"name": "constraints",
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"}}}},
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}}}},
41 "positive": {"type": {"key": {"type": "integer",
53 "a": {"type": "integer"},
54 "a2a": {"type": {"key": {"type": "uuid",
57 "min": 0, "max": "unlimited"}},
58 "a2a1": {"type": {"key": {"type": "uuid",
61 "a2b": {"type": {"key": {"type": "uuid",
63 "refType": "weak"}}}}},
66 "b": {"type": "integer"},
67 "b2a": {"type": {"key": {"type": "uuid",
70 "min": 0, "max": "unlimited"}}}}}}
80 "a": {"type": {"key": {"type": "uuid",
82 "min": 0, "max": "unlimited"}}},
86 "a": {"type": "integer"},
87 "a2a": {"type": {"key": {"type": "uuid",
89 "min": 0, "max": "unlimited"}},
90 "a2b": {"type": {"key": {"type": "uuid",
92 "min": 0, "max": "unlimited"}},
93 "wa2a": {"type": {"key": {"type": "uuid",
96 "min": 0, "max": "unlimited"}},
97 "wa2b": {"type": {"key": {"type": "uuid",
100 "min": 0, "max": "unlimited"}}}},
103 "b": {"type": "integer"},
104 "b2a": {"type": {"key": {"type": "uuid",
106 "min": 0, "max": "unlimited"}},
107 "wb2a": {"type": {"key": {"type": "uuid",
110 "min": 0, "max": "unlimited"}}},
115 immutable_schema () {
117 {"name": "immutable",
120 "columns": {"i": {"type": "integer", "mutable": false}}}}}
124 m4_divert_pop([PREPARE_TESTS])
126 # OVSDB_CHECK_EXECUTION(TITLE, SCHEMA, TRANSACTIONS, OUTPUT, [KEYWORDS])
128 # Runs "test-ovsdb execute" with the given SCHEMA and each of the
129 # TRANSACTIONS (which should be a quoted list of quoted strings).
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
137 # TITLE is provided to AT_SETUP and KEYWORDS to AT_KEYWORDS.
138 m4_define([OVSDB_CHECK_EXECUTION],
140 AT_KEYWORDS([ovsdb execute execution positive $5])
141 AT_CHECK([test-ovsdb execute "`$2`" m4_foreach([txn], [$3], [ 'txn'])],
143 AT_CHECK([perl $srcdir/uuidfilt.pl stdout], [0], [$4])
146 OVSDB_CHECK_EXECUTION([uuid-name must be <id>],
152 "uuid-name": "0"}]]]],
153 [[[{"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\"}"}]
156 OVSDB_CHECK_EXECUTION([named-uuid must be <id>],
161 "row": {"a2a": ["named-uuid", "0"]}}]]]],
162 [[[{"details":"named-uuid string is not a valid <id>","error":"syntax error","syntax":"[\"named-uuid\",\"0\"]"}]
165 OVSDB_CHECK_EXECUTION([duplicate uuid-name not allowed],
175 "uuid-name": "x"}]]]],
176 [[[{"uuid":["uuid","<0>"]},{"details":"This \"uuid-name\" appeared on an earlier \"insert\" operation.","error":"duplicate uuid-name","syntax":"\"x\""}]
179 m4_define([EXECUTION_EXAMPLES], [
180 dnl At one point the "commit" code ignored new rows with all-default values,
181 dnl so this checks for that problem.
182 OVSDB_CHECK_EXECUTION([insert default row, query table],
192 [[[{"uuid":["uuid","<0>"]}]
193 [{"rows":[{"_uuid":["uuid","<0>"],"_version":["uuid","<1>"],"name":"","number":0}]}]
196 OVSDB_CHECK_EXECUTION([insert row, query table],
201 "row": {"number": 0, "name": "zero"}}]]],
206 [[[{"uuid":["uuid","<0>"]}]
207 [{"rows":[{"_uuid":["uuid","<0>"],"_version":["uuid","<1>"],"name":"zero","number":0}]}]
210 OVSDB_CHECK_EXECUTION([insert rows, query by value],
215 "row": {"number": 0, "name": "zero"}}]]],
219 "row": {"number": 1, "name": "one"}}]]],
223 "where": [["name", "==", "zero"]]}]]],
227 "where": [["name", "==", "one"]]}]]]],
228 [[[{"uuid":["uuid","<0>"]}]
229 [{"uuid":["uuid","<1>"]}]
230 [{"rows":[{"_uuid":["uuid","<0>"],"_version":["uuid","<2>"],"name":"zero","number":0}]}]
231 [{"rows":[{"_uuid":["uuid","<1>"],"_version":["uuid","<3>"],"name":"one","number":1}]}]
234 OVSDB_CHECK_EXECUTION([insert rows, query by named-uuid],
239 "row": {"number": 0, "name": "zero"},
240 "uuid-name": "first"},
243 "row": {"number": 1, "name": "one"},
244 "uuid-name": "second"},
247 "where": [["_uuid", "==", ["named-uuid", "first"]]]},
250 "where": [["_uuid", "==", ["named-uuid", "second"]]]}]]]],
251 [[[{"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}]}]
254 OVSDB_CHECK_EXECUTION([insert rows, update rows by value],
259 "row": {"number": 0, "name": "zero"},
260 "uuid-name": "first"}]]],
264 "row": {"number": 1, "name": "one"},
265 "uuid-name": "first"}]]],
269 "where": [["name", "==", "zero"]],
270 "row": {"name": "nought"}}]]],
275 "sort": ["number"]}]]]],
276 [[[{"uuid":["uuid","<0>"]}]
277 [{"uuid":["uuid","<1>"]}]
279 [{"rows":[{"_uuid":["uuid","<0>"],"_version":["uuid","<2>"],"name":"nought","number":0},{"_uuid":["uuid","<1>"],"_version":["uuid","<3>"],"name":"one","number":1}]}]
282 OVSDB_CHECK_EXECUTION([insert rows, mutate rows],
287 "row": {"number": 0, "name": "zero"},
288 "uuid-name": "first"}]]],
292 "row": {"number": 1, "name": "one"},
293 "uuid-name": "first"}]]],
297 "where": [["name", "==", "zero"]],
298 "mutations": [["number", "+=", 2]]}]]],
303 "sort": ["number"]}]]]],
304 [[[{"uuid":["uuid","<0>"]}]
305 [{"uuid":["uuid","<1>"]}]
307 [{"rows":[{"_uuid":["uuid","<1>"],"_version":["uuid","<2>"],"name":"one","number":1},{"_uuid":["uuid","<0>"],"_version":["uuid","<3>"],"name":"zero","number":2}]}]
310 OVSDB_CHECK_EXECUTION([insert rows, delete by named-uuid],
315 "row": {"number": 0, "name": "zero"},
316 "uuid-name": "first"},
319 "row": {"number": 1, "name": "one"},
320 "uuid-name": "second"},
323 "where": [["_uuid", "==", ["named-uuid", "first"]]]},
327 "columns": ["name","number"]}]]]],
328 [[[{"uuid":["uuid","<0>"]},{"uuid":["uuid","<1>"]},{"count":1},{"rows":[{"name":"one","number":1}]}]
331 OVSDB_CHECK_EXECUTION([insert rows, delete rows by value],
336 "row": {"number": 0, "name": "zero"},
337 "uuid-name": "first"}]]],
341 "row": {"number": 1, "name": "one"},
342 "uuid-name": "first"}]]],
346 "where": [["name", "==", "zero"]]}]]],
351 [[[{"uuid":["uuid","<0>"]}]
352 [{"uuid":["uuid","<1>"]}]
354 [{"rows":[{"_uuid":["uuid","<1>"],"_version":["uuid","<2>"],"name":"one","number":1}]}]
357 OVSDB_CHECK_EXECUTION([insert rows, delete by (non-matching) value],
362 "row": {"number": 0, "name": "zero"},
363 "uuid-name": "first"}]]],
367 "row": {"number": 1, "name": "one"},
368 "uuid-name": "first"}]]],
372 "where": [["name", "==", "nought"]]}]]],
377 "sort": ["number"]}]]]],
378 [[[{"uuid":["uuid","<0>"]}]
379 [{"uuid":["uuid","<1>"]}]
381 [{"rows":[{"_uuid":["uuid","<0>"],"_version":["uuid","<2>"],"name":"zero","number":0},{"_uuid":["uuid","<1>"],"_version":["uuid","<3>"],"name":"one","number":1}]}]
384 OVSDB_CHECK_EXECUTION([insert rows, delete all],
389 "row": {"number": 0, "name": "zero"},
390 "uuid-name": "first"},
393 "row": {"number": 1, "name": "one"},
394 "uuid-name": "second"},
401 "columns": ["name","number"]}]]]],
402 [[[{"uuid":["uuid","<0>"]},{"uuid":["uuid","<1>"]},{"count":2},{"rows":[]}]
405 OVSDB_CHECK_EXECUTION([insert row, query table, commit],
410 "row": {"number": 0, "name": "zero"}},
415 "durable": false}]]]],
416 [[[{"uuid":["uuid","<0>"]},{"rows":[{"_uuid":["uuid","<0>"],"_version":["uuid","<1>"],"name":"zero","number":0}]},{}]
419 OVSDB_CHECK_EXECUTION([insert row, query table, commit durably],
424 "row": {"number": 0, "name": "zero"}},
429 "durable": true}]]]],
430 [[[{"uuid":["uuid","<0>"]},{"rows":[{"_uuid":["uuid","<0>"],"_version":["uuid","<1>"],"name":"zero","number":0}]},{}]
433 OVSDB_CHECK_EXECUTION([equality wait with correct rows],
438 "row": {"number": 0, "name": "zero"}},
441 "row": {"number": 1, "name": "one"}},
446 "columns": ["name", "number"],
448 "rows": [{"name": "zero", "number": 0},
449 {"name": "one", "number": 1}]}]]]],
450 [[[{"uuid":["uuid","<0>"]},{"uuid":["uuid","<1>"]},{}]
453 OVSDB_CHECK_EXECUTION([equality wait with extra row],
458 "row": {"number": 0, "name": "zero"}},
461 "row": {"number": 1, "name": "one"}},
466 "columns": ["name", "number"],
468 "rows": [{"name": "zero", "number": 0},
469 {"name": "one", "number": 1},
470 {"name": "two", "number": 2}]}]]]],
471 [[[{"uuid":["uuid","<0>"]},{"uuid":["uuid","<1>"]},{"details":"\"wait\" timed out","error":"timed out"}]
474 OVSDB_CHECK_EXECUTION([equality wait with missing row],
479 "row": {"number": 0, "name": "zero"}},
482 "row": {"number": 1, "name": "one"}},
487 "columns": ["name", "number"],
489 "rows": [{"name": "one", "number": 1}]}]]]],
490 [[[{"uuid":["uuid","<0>"]},{"uuid":["uuid","<1>"]},{"details":"\"wait\" timed out","error":"timed out"}]
493 OVSDB_CHECK_EXECUTION([inequality wait with correct rows],
498 "row": {"number": 0, "name": "zero"}},
501 "row": {"number": 1, "name": "one"}},
506 "columns": ["name", "number"],
508 "rows": [{"name": "zero", "number": 0},
509 {"name": "one", "number": 1}]}]]]],
510 [[[{"uuid":["uuid","<0>"]},{"uuid":["uuid","<1>"]},{"details":"\"wait\" timed out","error":"timed out"}]
513 OVSDB_CHECK_EXECUTION([inequality wait with extra row],
518 "row": {"number": 0, "name": "zero"}},
521 "row": {"number": 1, "name": "one"}},
526 "columns": ["name", "number"],
528 "rows": [{"name": "zero", "number": 0},
529 {"name": "one", "number": 1},
530 {"name": "two", "number": 2}]}]]]],
531 [[[{"uuid":["uuid","<0>"]},{"uuid":["uuid","<1>"]},{}]
534 OVSDB_CHECK_EXECUTION([inequality wait with missing row],
539 "row": {"number": 0, "name": "zero"}},
542 "row": {"number": 1, "name": "one"}},
547 "columns": ["name", "number"],
549 "rows": [{"name": "one", "number": 1}]}]]]],
550 [[[{"uuid":["uuid","<0>"]},{"uuid":["uuid","<1>"]},{}]
553 OVSDB_CHECK_EXECUTION([insert and update constraints],
557 "table": "constrained",
561 "table": "constrained",
562 "row": {"positive": -1}}]]],
565 "table": "constrained",
567 "row": {"positive": -2}}]]],
570 "table": "constrained",
571 "row": {"positive": 1}}]]],
574 "table": "constrained",
575 "row": {"positive": 2}}]]]],
576 [[[{"details":"0 is less than minimum allowed value 1","error":"constraint violation"}]
577 [{"details":"-1 is less than minimum allowed value 1","error":"constraint violation"}]
578 [{"details":"-2 is less than minimum allowed value 1","error":"constraint violation"}]
579 [{"uuid":["uuid","<0>"]}]
580 [{"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"}]
583 OVSDB_CHECK_EXECUTION([index uniqueness checking],
585 dnl Insert initial row.
589 "row": {"number": 1, "name": "one"}}]]],
590 dnl Try to insert row with identical value (fails).
594 "row": {"number": 1, "name": "another one"}}]]],
595 dnl Remove initial row and insert new row with identical value in a single
596 dnl transaction (succeeds).
600 "row": {"number": 1, "name": "another one"}},
603 "where": [["name", "==", "one"]]}]]],
604 dnl Remove row and insert two new rows with identical value in a single
605 dnl transaction (fails).
612 "row": {"number": 1, "name": "one"}},
615 "row": {"number": 1, "name": "still another one"}}]]],
616 dnl Add new row with different value (succeeds).
620 "row": {"number": 2, "name": "two"}}]]],
621 dnl Change rows so values collide (fails).
626 "row": {"number": 3}}]]],
627 dnl Swap rows' values (succeeds).
631 "where": [["number", "==", 1]],
632 "row": {"number": 2, "name": "old two"}},
635 "where": [["name", "==", "two"]],
636 "row": {"number": 1, "name": "old one"}}]]],
637 dnl Change all rows' values to values not used before and insert values that
638 dnl collide (only) with their previous values (succeeds).
643 "mutations": [["number", "*=", 10]]},
646 "row": {"number": 1, "name": "new one"}},
649 "row": {"number": 2, "name": "new two"}},
653 "columns": ["number", "name"],
654 "sort": ["number"]}]]]],
655 [[[{"uuid":["uuid","<0>"]}]
656 [{"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"}]
657 [{"uuid":["uuid","<2>"]},{"count":1}]
658 [{"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"}]
659 [{"uuid":["uuid","<5>"]}]
660 [{"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"}]
661 [{"count":1},{"count":1}]
662 [{"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}]}]
665 OVSDB_CHECK_EXECUTION([referential integrity -- simple],
671 "uuid-name": "brow"},
675 "a2b": ["set", [["named-uuid", "brow"]]]}},
679 "a2b": ["set", [["named-uuid", "brow"]]]}},
683 "a2b": ["set", [["named-uuid", "brow"]]]}}]]],
688 dnl Check that "mutate" honors number-of-elements constraints on sets and maps.
693 "mutations": [["x", "delete", 0]]}]]],
697 "where": [["a", "==", 0]]}]]],
705 "where": [["a", "==", 1]]}]]],
713 "where": [["a", "==", 2]]}]]],
718 [[[{"uuid":["uuid","<0>"]},{"uuid":["uuid","<1>"]},{"uuid":["uuid","<2>"]},{"uuid":["uuid","<3>"]}]
719 [{"count":1},{"details":"cannot delete b row <0> because of 3 remaining reference(s)","error":"referential integrity violation"}]
720 [{"details":"Attempted to store 0 elements in set of 1 to 2 integers.","error":"constraint violation"}]
722 [{"count":1},{"details":"cannot delete b row <0> because of 2 remaining reference(s)","error":"referential integrity violation"}]
724 [{"count":1},{"details":"cannot delete b row <0> because of 1 remaining reference(s)","error":"referential integrity violation"}]
729 OVSDB_CHECK_EXECUTION([referential integrity -- mutual references],
735 "a2b": ["set", [["named-uuid", "row2"]]],
736 "a2a": ["set", [["named-uuid", "row1"]]]},
737 "uuid-name": "row1"},
741 "b2b": ["set", [["named-uuid", "row2"]]],
742 "b2a": ["set", [["named-uuid", "row1"]]]},
743 "uuid-name": "row2"}]]],
747 "row": {"a2b": ["set", [["uuid", "b516b960-5b19-4fc2-bb82-fe1cbd6d0241"]]]}}]]],
751 "where": [["a", "==", 0]]}]]],
755 "where": [["b", "==", 1]]}]]],
756 dnl Try the deletions again to make sure that the refcounts got rolled back.
760 "where": [["a", "==", 0]]}]]],
764 "where": [["b", "==", 1]]}]]],
768 "where": [["a", "==", 0]]},
771 "where": [["b", "==", 1]]}]]]],
772 [[[{"uuid":["uuid","<0>"]},{"uuid":["uuid","<1>"]}]
773 [{"uuid":["uuid","<2>"]},{"details":"Table a column a2b row <2> references nonexistent row <3> in table b.","error":"referential integrity violation"}]
774 [{"count":1},{"details":"cannot delete a row <0> because of 1 remaining reference(s)","error":"referential integrity violation"}]
775 [{"count":1},{"details":"cannot delete b row <1> because of 1 remaining reference(s)","error":"referential integrity violation"}]
776 [{"count":1},{"details":"cannot delete a row <0> because of 1 remaining reference(s)","error":"referential integrity violation"}]
777 [{"count":1},{"details":"cannot delete b row <1> because of 1 remaining reference(s)","error":"referential integrity violation"}]
778 [{"count":1},{"count":1}]
781 OVSDB_CHECK_EXECUTION([weak references],
787 "a2a": ["set", [["named-uuid", "row1"],
788 ["named-uuid", "row2"],
789 ["uuid", "0e767b36-6822-4044-8307-d58467e04669"]]],
790 "a2a1": ["named-uuid", "row1"],
791 "a2b": ["named-uuid", "row3"]},
792 "uuid-name": "row1"},
796 "a2a": ["set", [["named-uuid", "row1"],
797 ["named-uuid", "row2"]]],
798 "a2a1": ["named-uuid", "row2"],
799 "a2b": ["named-uuid", "row3"]},
800 "uuid-name": "row2"},
804 "a2a": ["set", [["named-uuid", "row1"],
805 ["named-uuid", "row2"]]],
806 "a2a1": ["named-uuid", "row2"],
807 "a2b": ["named-uuid", "row4"]}},
811 "b2a": ["named-uuid", "row1"]},
812 "uuid-name": "row3"},
816 "b2a": ["named-uuid", "row2"]},
817 "uuid-name": "row4"}]]],
818 dnl Check that the nonexistent row UUID we added to row a0 was deleted,
819 dnl and that other rows were inserted as requested.
824 "columns": ["_uuid", "a2a", "a2a1", "a2b"],
830 "columns": ["_uuid", "b", "b2a"],
832 dnl Try to insert invalid all-zeros weak reference (the default) into
833 dnl "a2b", which requires exactly one value.
837 "row": {"a2a1": ["named-uuid", "me"]},
838 "uuid-name": "me"}]]],
839 dnl Try to delete row from "b" that is referred to by weak references
840 dnl from "a" table "a2b" column that requires exactly one value.
844 "where": [["b", "==", 3]]}]]],
845 dnl Try to delete row from "a" that is referred to by weak references
846 dnl from "a" table "a2a1" column that requires exactly one value.
850 "where": [["a", "==", 1]]}]]],
851 dnl Delete the row that had the reference that caused the previous
852 dnl deletion to fail, then check that other rows are unchanged.
856 "where": [["a", "==", 2]]}]]],
861 "columns": ["_uuid", "a2a", "a2a1", "a2b"],
867 "columns": ["_uuid", "b", "b2a"],
869 dnl Delete row a0 then check that references to it were removed.
873 "where": [["a", "==", 0]]}]]],
878 "columns": ["_uuid", "a2a", "a2a1", "a2b"],
884 "columns": ["_uuid", "b", "b2a"],
886 dnl Delete row a1 then check that references to it were removed.
890 "where": [["a", "==", 1]]}]]],
895 "columns": ["_uuid", "a2a", "a2a1", "a2b"],
901 "columns": ["_uuid", "b", "b2a"],
903 [[[{"uuid":["uuid","<0>"]},{"uuid":["uuid","<1>"]},{"uuid":["uuid","<2>"]},{"uuid":["uuid","<3>"]},{"uuid":["uuid","<4>"]}]
904 [{"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>"]}]}]
905 [{"rows":[{"_uuid":["uuid","<3>"],"b":2,"b2a":["uuid","<0>"]},{"_uuid":["uuid","<4>"],"b":3,"b2a":["uuid","<1>"]}]}]
906 [{"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"}]
907 [{"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"}]
908 [{"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"}]
910 [{"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>"]}]}]
911 [{"rows":[{"_uuid":["uuid","<3>"],"b":2,"b2a":["uuid","<0>"]},{"_uuid":["uuid","<4>"],"b":3,"b2a":["uuid","<1>"]}]}]
913 [{"rows":[{"_uuid":["uuid","<1>"],"a2a":["uuid","<1>"],"a2a1":["uuid","<1>"],"a2b":["uuid","<3>"]}]}]
914 [{"rows":[{"_uuid":["uuid","<3>"],"b":2,"b2a":["set",[]]},{"_uuid":["uuid","<4>"],"b":3,"b2a":["uuid","<1>"]}]}]
917 [{"rows":[{"_uuid":["uuid","<3>"],"b":2,"b2a":["set",[]]},{"_uuid":["uuid","<4>"],"b":3,"b2a":["set",[]]}]}]
920 OVSDB_CHECK_EXECUTION([immutable columns],
926 "uuid-name": "row1"}]]],
941 "mutations": [["i", "-=", 5]]}]]],
946 "mutations": [["i", "*=", 1]]}]]]],
947 [[[{"uuid":["uuid","<0>"]}]
948 [{"details":"Cannot update immutable column i in table a.","error":"constraint violation","syntax":"{\"op\":\"update\",\"row\":{\"i\":10},\"table\":\"a\",\"where\":[]}"}]
949 [{"details":"Cannot update immutable column i in table a.","error":"constraint violation","syntax":"{\"op\":\"update\",\"row\":{\"i\":5},\"table\":\"a\",\"where\":[]}"}]
950 [{"details":"Cannot mutate immutable column i in table a.","error":"constraint violation","syntax":"[\"i\",\"-=\",5]"}]
951 [{"details":"Cannot mutate immutable column i in table a.","error":"constraint violation","syntax":"[\"i\",\"*=\",1]"}]
954 OVSDB_CHECK_EXECUTION([garbage collection],
956 [dnl Check that inserting a row without any references is a no-op.
965 "columns": ["a"]}]]],
966 dnl Check that inserting a chain of rows that reference each other
967 dnl in turn is also a no-op.
971 "row": {"a": 0, "a2a": ["named-uuid", "row1"]},
972 "uuid-name": "row0"},
975 "row": {"a": 1, "a2a": ["named-uuid", "row2"]},
976 "uuid-name": "row1"},
979 "row": {"a": 2, "a2a": ["named-uuid", "row3"]},
980 "uuid-name": "row2"},
984 "uuid-name": "row3"}]]],
989 "columns": ["a"]}]]],
990 dnl Check that inserting a pair of rows that mutually reference each
991 dnl other causes the rows to be retained.
995 "row": {"a": 4, "a2a": ["named-uuid", "row5"]},
996 "uuid-name": "row4"},
999 "row": {"a": 5, "a2a": ["named-uuid", "row4"]},
1000 "uuid-name": "row5"}]]],
1007 dnl Check that unreferencing one of the rows causes the other to be deleted.
1011 "where": [["a", "==", 4]],
1012 "row": {"a2a": ["set", []]}}]]],
1017 "columns": ["a"]}]]],
1018 dnl Check that inserting a pair of rows that mutually weak reference each
1019 dnl other is a no-op.
1023 "row": {"a": 6, "wa2a": ["named-uuid", "row7"]},
1024 "uuid-name": "row6"},
1027 "row": {"a": 7, "wa2a": ["named-uuid", "row6"]},
1028 "uuid-name": "row7"}]]],
1033 "columns": ["a"]}]]],
1034 dnl Check that a circular chain of rows is retained.
1038 "row": {"a": 8, "a2a": ["named-uuid", "row9"]},
1039 "uuid-name": "row8"},
1042 "row": {"a": 9, "a2a": ["named-uuid", "row10"]},
1043 "uuid-name": "row9"},
1046 "row": {"a": 10, "a2a": ["named-uuid", "row11"]},
1047 "uuid-name": "row10"},
1050 "row": {"a": 11, "a2a": ["named-uuid", "row8"]},
1051 "uuid-name": "row11"}]]],
1058 dnl Check that breaking the chain causes all of the rows to be deleted.
1062 "where": [["a", "==", 9]],
1063 "row": {"a2a": ["set", []]}}]]],
1068 "columns": ["a"]}]]],
1069 dnl Check that inserting a row only referenced by itself is a no-op.
1073 "row": {"a": 12, "a2a": ["named-uuid", "self"]},
1074 "uuid-name": "self"}]]],
1079 "columns": ["a"]}]]]],
1080 [[[{"uuid":["uuid","<0>"]}]
1082 [{"uuid":["uuid","<1>"]},{"uuid":["uuid","<2>"]},{"uuid":["uuid","<3>"]},{"uuid":["uuid","<4>"]}]
1084 [{"uuid":["uuid","<5>"]},{"uuid":["uuid","<6>"]}]
1085 [{"rows":[{"a":4},{"a":5}]}]
1088 [{"uuid":["uuid","<7>"]},{"uuid":["uuid","<8>"]}]
1090 [{"uuid":["uuid","<9>"]},{"uuid":["uuid","<10>"]},{"uuid":["uuid","<11>"]},{"uuid":["uuid","<12>"]}]
1091 [{"rows":[{"a":8},{"a":9},{"a":10},{"a":11}]}]
1094 [{"uuid":["uuid","<13>"]}]