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([ONE_EXECUTION_EXAMPLE], [dnl
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}]}]
197 m4_define([EXECUTION_EXAMPLES], [
198 ONE_EXECUTION_EXAMPLE
199 OVSDB_CHECK_EXECUTION([insert row, query table],
204 "row": {"number": 0, "name": "zero"}}]]],
209 [[[{"uuid":["uuid","<0>"]}]
210 [{"rows":[{"_uuid":["uuid","<0>"],"_version":["uuid","<1>"],"name":"zero","number":0}]}]
213 OVSDB_CHECK_EXECUTION([insert rows, query by value],
218 "row": {"number": 0, "name": "zero"}}]]],
222 "row": {"number": 1, "name": "one"}}]]],
226 "where": [["name", "==", "zero"]]}]]],
230 "where": [["name", "==", "one"]]}]]]],
231 [[[{"uuid":["uuid","<0>"]}]
232 [{"uuid":["uuid","<1>"]}]
233 [{"rows":[{"_uuid":["uuid","<0>"],"_version":["uuid","<2>"],"name":"zero","number":0}]}]
234 [{"rows":[{"_uuid":["uuid","<1>"],"_version":["uuid","<3>"],"name":"one","number":1}]}]
237 OVSDB_CHECK_EXECUTION([insert rows, query by named-uuid],
242 "row": {"number": 0, "name": "zero"},
243 "uuid-name": "first"},
246 "row": {"number": 1, "name": "one"},
247 "uuid-name": "second"},
250 "where": [["_uuid", "==", ["named-uuid", "first"]]]},
253 "where": [["_uuid", "==", ["named-uuid", "second"]]]}]]]],
254 [[[{"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}]}]
257 OVSDB_CHECK_EXECUTION([insert rows, update rows by value],
262 "row": {"number": 0, "name": "zero"},
263 "uuid-name": "first"}]]],
267 "row": {"number": 1, "name": "one"},
268 "uuid-name": "first"}]]],
272 "where": [["name", "==", "zero"]],
273 "row": {"name": "nought"}}]]],
278 "sort": ["number"]}]]]],
279 [[[{"uuid":["uuid","<0>"]}]
280 [{"uuid":["uuid","<1>"]}]
282 [{"rows":[{"_uuid":["uuid","<0>"],"_version":["uuid","<2>"],"name":"nought","number":0},{"_uuid":["uuid","<1>"],"_version":["uuid","<3>"],"name":"one","number":1}]}]
285 OVSDB_CHECK_EXECUTION([insert rows, mutate rows],
290 "row": {"number": 0, "name": "zero"},
291 "uuid-name": "first"}]]],
295 "row": {"number": 1, "name": "one"},
296 "uuid-name": "first"}]]],
300 "where": [["name", "==", "zero"]],
301 "mutations": [["number", "+=", 2]]}]]],
306 "sort": ["number"]}]]]],
307 [[[{"uuid":["uuid","<0>"]}]
308 [{"uuid":["uuid","<1>"]}]
310 [{"rows":[{"_uuid":["uuid","<1>"],"_version":["uuid","<2>"],"name":"one","number":1},{"_uuid":["uuid","<0>"],"_version":["uuid","<3>"],"name":"zero","number":2}]}]
313 OVSDB_CHECK_EXECUTION([insert rows, delete by named-uuid],
318 "row": {"number": 0, "name": "zero"},
319 "uuid-name": "first"},
322 "row": {"number": 1, "name": "one"},
323 "uuid-name": "second"},
326 "where": [["_uuid", "==", ["named-uuid", "first"]]]},
330 "columns": ["name","number"]}]]]],
331 [[[{"uuid":["uuid","<0>"]},{"uuid":["uuid","<1>"]},{"count":1},{"rows":[{"name":"one","number":1}]}]
334 OVSDB_CHECK_EXECUTION([insert rows, delete rows by value],
339 "row": {"number": 0, "name": "zero"},
340 "uuid-name": "first"}]]],
344 "row": {"number": 1, "name": "one"},
345 "uuid-name": "first"}]]],
349 "where": [["name", "==", "zero"]]}]]],
354 [[[{"uuid":["uuid","<0>"]}]
355 [{"uuid":["uuid","<1>"]}]
357 [{"rows":[{"_uuid":["uuid","<1>"],"_version":["uuid","<2>"],"name":"one","number":1}]}]
360 OVSDB_CHECK_EXECUTION([insert rows, delete by (non-matching) value],
365 "row": {"number": 0, "name": "zero"},
366 "uuid-name": "first"}]]],
370 "row": {"number": 1, "name": "one"},
371 "uuid-name": "first"}]]],
375 "where": [["name", "==", "nought"]]}]]],
380 "sort": ["number"]}]]]],
381 [[[{"uuid":["uuid","<0>"]}]
382 [{"uuid":["uuid","<1>"]}]
384 [{"rows":[{"_uuid":["uuid","<0>"],"_version":["uuid","<2>"],"name":"zero","number":0},{"_uuid":["uuid","<1>"],"_version":["uuid","<3>"],"name":"one","number":1}]}]
387 OVSDB_CHECK_EXECUTION([insert rows, delete all],
392 "row": {"number": 0, "name": "zero"},
393 "uuid-name": "first"},
396 "row": {"number": 1, "name": "one"},
397 "uuid-name": "second"},
404 "columns": ["name","number"]}]]]],
405 [[[{"uuid":["uuid","<0>"]},{"uuid":["uuid","<1>"]},{"count":2},{"rows":[]}]
408 OVSDB_CHECK_EXECUTION([insert row, query table, commit],
413 "row": {"number": 0, "name": "zero"}},
418 "durable": false}]]]],
419 [[[{"uuid":["uuid","<0>"]},{"rows":[{"_uuid":["uuid","<0>"],"_version":["uuid","<1>"],"name":"zero","number":0}]},{}]
422 OVSDB_CHECK_EXECUTION([insert row, query table, commit durably],
427 "row": {"number": 0, "name": "zero"}},
432 "durable": true}]]]],
433 [[[{"uuid":["uuid","<0>"]},{"rows":[{"_uuid":["uuid","<0>"],"_version":["uuid","<1>"],"name":"zero","number":0}]},{}]
436 OVSDB_CHECK_EXECUTION([equality wait with correct rows],
441 "row": {"number": 0, "name": "zero"}},
444 "row": {"number": 1, "name": "one"}},
449 "columns": ["name", "number"],
451 "rows": [{"name": "zero", "number": 0},
452 {"name": "one", "number": 1}]}]]]],
453 [[[{"uuid":["uuid","<0>"]},{"uuid":["uuid","<1>"]},{}]
456 OVSDB_CHECK_EXECUTION([equality wait with extra row],
461 "row": {"number": 0, "name": "zero"}},
464 "row": {"number": 1, "name": "one"}},
469 "columns": ["name", "number"],
471 "rows": [{"name": "zero", "number": 0},
472 {"name": "one", "number": 1},
473 {"name": "two", "number": 2}]}]]]],
474 [[[{"uuid":["uuid","<0>"]},{"uuid":["uuid","<1>"]},{"details":"\"wait\" timed out","error":"timed out"}]
477 OVSDB_CHECK_EXECUTION([equality wait with missing row],
482 "row": {"number": 0, "name": "zero"}},
485 "row": {"number": 1, "name": "one"}},
490 "columns": ["name", "number"],
492 "rows": [{"name": "one", "number": 1}]}]]]],
493 [[[{"uuid":["uuid","<0>"]},{"uuid":["uuid","<1>"]},{"details":"\"wait\" timed out","error":"timed out"}]
496 OVSDB_CHECK_EXECUTION([inequality wait with correct rows],
501 "row": {"number": 0, "name": "zero"}},
504 "row": {"number": 1, "name": "one"}},
509 "columns": ["name", "number"],
511 "rows": [{"name": "zero", "number": 0},
512 {"name": "one", "number": 1}]}]]]],
513 [[[{"uuid":["uuid","<0>"]},{"uuid":["uuid","<1>"]},{"details":"\"wait\" timed out","error":"timed out"}]
516 OVSDB_CHECK_EXECUTION([inequality wait with extra row],
521 "row": {"number": 0, "name": "zero"}},
524 "row": {"number": 1, "name": "one"}},
529 "columns": ["name", "number"],
531 "rows": [{"name": "zero", "number": 0},
532 {"name": "one", "number": 1},
533 {"name": "two", "number": 2}]}]]]],
534 [[[{"uuid":["uuid","<0>"]},{"uuid":["uuid","<1>"]},{}]
537 OVSDB_CHECK_EXECUTION([inequality wait with missing row],
542 "row": {"number": 0, "name": "zero"}},
545 "row": {"number": 1, "name": "one"}},
550 "columns": ["name", "number"],
552 "rows": [{"name": "one", "number": 1}]}]]]],
553 [[[{"uuid":["uuid","<0>"]},{"uuid":["uuid","<1>"]},{}]
556 OVSDB_CHECK_EXECUTION([insert and update constraints],
560 "table": "constrained",
564 "table": "constrained",
565 "row": {"positive": -1}}]]],
568 "table": "constrained",
570 "row": {"positive": -2}}]]],
573 "table": "constrained",
574 "row": {"positive": 1}}]]],
577 "table": "constrained",
578 "row": {"positive": 2}}]]]],
579 [[[{"details":"0 is less than minimum allowed value 1","error":"constraint violation"}]
580 [{"details":"-1 is less than minimum allowed value 1","error":"constraint violation"}]
581 [{"details":"-2 is less than minimum allowed value 1","error":"constraint violation"}]
582 [{"uuid":["uuid","<0>"]}]
583 [{"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"}]
586 OVSDB_CHECK_EXECUTION([index uniqueness checking],
588 dnl Insert initial row.
592 "row": {"number": 1, "name": "one"}}]]],
593 dnl Try to insert row with identical value (fails).
597 "row": {"number": 1, "name": "another one"}}]]],
598 dnl Remove initial row and insert new row with identical value in a single
599 dnl transaction (succeeds).
603 "row": {"number": 1, "name": "another one"}},
606 "where": [["name", "==", "one"]]}]]],
607 dnl Remove row and insert two new rows with identical value in a single
608 dnl transaction (fails).
615 "row": {"number": 1, "name": "one"}},
618 "row": {"number": 1, "name": "still another one"}}]]],
619 dnl Add new row with different value (succeeds).
623 "row": {"number": 2, "name": "two"}}]]],
624 dnl Change rows so values collide (fails).
629 "row": {"number": 3}}]]],
630 dnl Swap rows' values (succeeds).
634 "where": [["number", "==", 1]],
635 "row": {"number": 2, "name": "old two"}},
638 "where": [["name", "==", "two"]],
639 "row": {"number": 1, "name": "old one"}}]]],
640 dnl Change all rows' values to values not used before and insert values that
641 dnl collide (only) with their previous values (succeeds).
646 "mutations": [["number", "*=", 10]]},
649 "row": {"number": 1, "name": "new one"}},
652 "row": {"number": 2, "name": "new two"}},
656 "columns": ["number", "name"],
657 "sort": ["number"]}]]]],
658 [[[{"uuid":["uuid","<0>"]}]
659 [{"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"}]
660 [{"uuid":["uuid","<2>"]},{"count":1}]
661 [{"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"}]
662 [{"uuid":["uuid","<5>"]}]
663 [{"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"}]
664 [{"count":1},{"count":1}]
665 [{"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}]}]
668 OVSDB_CHECK_EXECUTION([referential integrity -- simple],
674 "uuid-name": "brow"},
678 "a2b": ["set", [["named-uuid", "brow"]]]}},
682 "a2b": ["set", [["named-uuid", "brow"]]]}},
686 "a2b": ["set", [["named-uuid", "brow"]]]}}]]],
691 dnl Check that "mutate" honors number-of-elements constraints on sets and maps.
696 "mutations": [["x", "delete", 0]]}]]],
700 "where": [["a", "==", 0]]}]]],
708 "where": [["a", "==", 1]]}]]],
716 "where": [["a", "==", 2]]}]]],
721 [[[{"uuid":["uuid","<0>"]},{"uuid":["uuid","<1>"]},{"uuid":["uuid","<2>"]},{"uuid":["uuid","<3>"]}]
722 [{"count":1},{"details":"cannot delete b row <0> because of 3 remaining reference(s)","error":"referential integrity violation"}]
723 [{"details":"Attempted to store 0 elements in set of 1 to 2 integers.","error":"constraint violation"}]
725 [{"count":1},{"details":"cannot delete b row <0> because of 2 remaining reference(s)","error":"referential integrity violation"}]
727 [{"count":1},{"details":"cannot delete b row <0> because of 1 remaining reference(s)","error":"referential integrity violation"}]
732 OVSDB_CHECK_EXECUTION([referential integrity -- mutual references],
738 "a2b": ["set", [["named-uuid", "row2"]]],
739 "a2a": ["set", [["named-uuid", "row1"]]]},
740 "uuid-name": "row1"},
744 "b2b": ["set", [["named-uuid", "row2"]]],
745 "b2a": ["set", [["named-uuid", "row1"]]]},
746 "uuid-name": "row2"}]]],
750 "row": {"a2b": ["set", [["uuid", "b516b960-5b19-4fc2-bb82-fe1cbd6d0241"]]]}}]]],
754 "where": [["a", "==", 0]]}]]],
758 "where": [["b", "==", 1]]}]]],
759 dnl Try the deletions again to make sure that the refcounts got rolled back.
763 "where": [["a", "==", 0]]}]]],
767 "where": [["b", "==", 1]]}]]],
771 "where": [["a", "==", 0]]},
774 "where": [["b", "==", 1]]}]]]],
775 [[[{"uuid":["uuid","<0>"]},{"uuid":["uuid","<1>"]}]
776 [{"uuid":["uuid","<2>"]},{"details":"Table a column a2b row <2> references nonexistent row <3> in table b.","error":"referential integrity violation"}]
777 [{"count":1},{"details":"cannot delete a row <0> because of 1 remaining reference(s)","error":"referential integrity violation"}]
778 [{"count":1},{"details":"cannot delete b row <1> because of 1 remaining reference(s)","error":"referential integrity violation"}]
779 [{"count":1},{"details":"cannot delete a row <0> because of 1 remaining reference(s)","error":"referential integrity violation"}]
780 [{"count":1},{"details":"cannot delete b row <1> because of 1 remaining reference(s)","error":"referential integrity violation"}]
781 [{"count":1},{"count":1}]
784 OVSDB_CHECK_EXECUTION([weak references],
790 "a2a": ["set", [["named-uuid", "row1"],
791 ["named-uuid", "row2"],
792 ["uuid", "0e767b36-6822-4044-8307-d58467e04669"]]],
793 "a2a1": ["named-uuid", "row1"],
794 "a2b": ["named-uuid", "row3"]},
795 "uuid-name": "row1"},
799 "a2a": ["set", [["named-uuid", "row1"],
800 ["named-uuid", "row2"]]],
801 "a2a1": ["named-uuid", "row2"],
802 "a2b": ["named-uuid", "row3"]},
803 "uuid-name": "row2"},
807 "a2a": ["set", [["named-uuid", "row1"],
808 ["named-uuid", "row2"]]],
809 "a2a1": ["named-uuid", "row2"],
810 "a2b": ["named-uuid", "row4"]}},
814 "b2a": ["named-uuid", "row1"]},
815 "uuid-name": "row3"},
819 "b2a": ["named-uuid", "row2"]},
820 "uuid-name": "row4"}]]],
821 dnl Check that the nonexistent row UUID we added to row a0 was deleted,
822 dnl and that other rows were inserted as requested.
827 "columns": ["_uuid", "a2a", "a2a1", "a2b"],
833 "columns": ["_uuid", "b", "b2a"],
835 dnl Try to insert invalid all-zeros weak reference (the default) into
836 dnl "a2b", which requires exactly one value.
840 "row": {"a2a1": ["named-uuid", "me"]},
841 "uuid-name": "me"}]]],
842 dnl Try to delete row from "b" that is referred to by weak references
843 dnl from "a" table "a2b" column that requires exactly one value.
847 "where": [["b", "==", 3]]}]]],
848 dnl Try to delete row from "a" that is referred to by weak references
849 dnl from "a" table "a2a1" column that requires exactly one value.
853 "where": [["a", "==", 1]]}]]],
854 dnl Delete the row that had the reference that caused the previous
855 dnl deletion to fail, then check that other rows are unchanged.
859 "where": [["a", "==", 2]]}]]],
864 "columns": ["_uuid", "a2a", "a2a1", "a2b"],
870 "columns": ["_uuid", "b", "b2a"],
872 dnl Delete row a0 then check that references to it were removed.
876 "where": [["a", "==", 0]]}]]],
881 "columns": ["_uuid", "a2a", "a2a1", "a2b"],
887 "columns": ["_uuid", "b", "b2a"],
889 dnl Delete row a1 then check that references to it were removed.
893 "where": [["a", "==", 1]]}]]],
898 "columns": ["_uuid", "a2a", "a2a1", "a2b"],
904 "columns": ["_uuid", "b", "b2a"],
906 [[[{"uuid":["uuid","<0>"]},{"uuid":["uuid","<1>"]},{"uuid":["uuid","<2>"]},{"uuid":["uuid","<3>"]},{"uuid":["uuid","<4>"]}]
907 [{"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>"]}]}]
908 [{"rows":[{"_uuid":["uuid","<3>"],"b":2,"b2a":["uuid","<0>"]},{"_uuid":["uuid","<4>"],"b":3,"b2a":["uuid","<1>"]}]}]
909 [{"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"}]
910 [{"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"}]
911 [{"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 [{"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>"]}]}]
914 [{"rows":[{"_uuid":["uuid","<3>"],"b":2,"b2a":["uuid","<0>"]},{"_uuid":["uuid","<4>"],"b":3,"b2a":["uuid","<1>"]}]}]
916 [{"rows":[{"_uuid":["uuid","<1>"],"a2a":["uuid","<1>"],"a2a1":["uuid","<1>"],"a2b":["uuid","<3>"]}]}]
917 [{"rows":[{"_uuid":["uuid","<3>"],"b":2,"b2a":["set",[]]},{"_uuid":["uuid","<4>"],"b":3,"b2a":["uuid","<1>"]}]}]
920 [{"rows":[{"_uuid":["uuid","<3>"],"b":2,"b2a":["set",[]]},{"_uuid":["uuid","<4>"],"b":3,"b2a":["set",[]]}]}]
923 OVSDB_CHECK_EXECUTION([immutable columns],
929 "uuid-name": "row1"}]]],
944 "mutations": [["i", "-=", 5]]}]]],
949 "mutations": [["i", "*=", 1]]}]]]],
950 [[[{"uuid":["uuid","<0>"]}]
951 [{"details":"Cannot update immutable column i in table a.","error":"constraint violation","syntax":"{\"op\":\"update\",\"row\":{\"i\":10},\"table\":\"a\",\"where\":[]}"}]
952 [{"details":"Cannot update immutable column i in table a.","error":"constraint violation","syntax":"{\"op\":\"update\",\"row\":{\"i\":5},\"table\":\"a\",\"where\":[]}"}]
953 [{"details":"Cannot mutate immutable column i in table a.","error":"constraint violation","syntax":"[\"i\",\"-=\",5]"}]
954 [{"details":"Cannot mutate immutable column i in table a.","error":"constraint violation","syntax":"[\"i\",\"*=\",1]"}]
957 OVSDB_CHECK_EXECUTION([garbage collection],
959 [dnl Check that inserting a row without any references is a no-op.
968 "columns": ["a"]}]]],
969 dnl Check that inserting a chain of rows that reference each other
970 dnl in turn is also a no-op.
974 "row": {"a": 0, "a2a": ["named-uuid", "row1"]},
975 "uuid-name": "row0"},
978 "row": {"a": 1, "a2a": ["named-uuid", "row2"]},
979 "uuid-name": "row1"},
982 "row": {"a": 2, "a2a": ["named-uuid", "row3"]},
983 "uuid-name": "row2"},
987 "uuid-name": "row3"}]]],
992 "columns": ["a"]}]]],
993 dnl Check that inserting a pair of rows that mutually reference each
994 dnl other causes the rows to be retained.
998 "row": {"a": 4, "a2a": ["named-uuid", "row5"]},
999 "uuid-name": "row4"},
1002 "row": {"a": 5, "a2a": ["named-uuid", "row4"]},
1003 "uuid-name": "row5"}]]],
1010 dnl Check that unreferencing one of the rows causes the other to be deleted.
1014 "where": [["a", "==", 4]],
1015 "row": {"a2a": ["set", []]}}]]],
1020 "columns": ["a"]}]]],
1021 dnl Check that inserting a pair of rows that mutually weak reference each
1022 dnl other is a no-op.
1026 "row": {"a": 6, "wa2a": ["named-uuid", "row7"]},
1027 "uuid-name": "row6"},
1030 "row": {"a": 7, "wa2a": ["named-uuid", "row6"]},
1031 "uuid-name": "row7"}]]],
1036 "columns": ["a"]}]]],
1037 dnl Check that a circular chain of rows is retained.
1041 "row": {"a": 8, "a2a": ["named-uuid", "row9"]},
1042 "uuid-name": "row8"},
1045 "row": {"a": 9, "a2a": ["named-uuid", "row10"]},
1046 "uuid-name": "row9"},
1049 "row": {"a": 10, "a2a": ["named-uuid", "row11"]},
1050 "uuid-name": "row10"},
1053 "row": {"a": 11, "a2a": ["named-uuid", "row8"]},
1054 "uuid-name": "row11"}]]],
1061 dnl Check that breaking the chain causes all of the rows to be deleted.
1065 "where": [["a", "==", 9]],
1066 "row": {"a2a": ["set", []]}}]]],
1071 "columns": ["a"]}]]],
1072 dnl Check that inserting a row only referenced by itself is a no-op.
1076 "row": {"a": 12, "a2a": ["named-uuid", "self"]},
1077 "uuid-name": "self"}]]],
1082 "columns": ["a"]}]]]],
1083 [[[{"uuid":["uuid","<0>"]}]
1085 [{"uuid":["uuid","<1>"]},{"uuid":["uuid","<2>"]},{"uuid":["uuid","<3>"]},{"uuid":["uuid","<4>"]}]
1087 [{"uuid":["uuid","<5>"]},{"uuid":["uuid","<6>"]}]
1088 [{"rows":[{"a":4},{"a":5}]}]
1091 [{"uuid":["uuid","<7>"]},{"uuid":["uuid","<8>"]}]
1093 [{"uuid":["uuid","<9>"]},{"uuid":["uuid","<10>"]},{"uuid":["uuid","<11>"]},{"uuid":["uuid","<12>"]}]
1094 [{"rows":[{"a":8},{"a":9},{"a":10},{"a":11}]}]
1097 [{"uuid":["uuid","<13>"]}]