持久化数据分支差异并合并¶
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;
合并后主表应有 (1,15),(2,20),(3,30)。review 是持久普通表,可先交给审阅方;它不会在合并后自动消失。Schema 变化和冲突行为见 Data Branch 教程与源码 OUTPUT AS 测试。