Persist and review data branch differences

CREATE DATABASE cookbook_branch;
CREATE TABLE cookbook_branch.base(id INT PRIMARY KEY, amount INT);
INSERT INTO cookbook_branch.base VALUES(1,10),(2,20);
DATA BRANCH CREATE TABLE cookbook_branch.work FROM cookbook_branch.base;
UPDATE cookbook_branch.work SET amount=15 WHERE id=1;
INSERT INTO cookbook_branch.work VALUES(3,30);
DATA BRANCH DIFF cookbook_branch.work AGAINST cookbook_branch.base
OUTPUT AS cookbook_branch.review;
SELECT __mo_diff_source,__mo_diff_flag,id,amount
FROM cookbook_branch.review ORDER BY id;
DATA BRANCH MERGE cookbook_branch.work INTO cookbook_branch.base;
SELECT id,amount FROM cookbook_branch.base ORDER BY id;
DROP DATABASE cookbook_branch;

After the merge, the base table should contain (1,15),(2,20),(3,30). review is a persistent regular table that can be inspected before merging; it is not automatically removed afterward. See the Data Branch tutorial and source OUTPUT AS test for schema changes and conflicts.