tpcc验证⼀致性的简单⽅法
多风的英语>高等数学2(Select w_id, w_ytd from warehou) except(lect d_w_id, sum(d_ytd) from district group by d_w_id);
(Select d_w_id, d_id, D_NEXT_O_ID - 1 from district) except (lect o_w_id, o_d_id, max(o_id) from oorder group by o_w_id, o_d_id);
(Select d_w_id, d_id, D_NEXT_O_ID - 1 from district) except (lect no_w_id, no_d_id, max(no_o_id) from new_order group by no_w_id, no_d_id);
lect * from (lect (count(no_o_id)-(max(no_o_id)-min(no_o_id)+1)) as diff from new_order group by no_w_id, no_d_id) where diff != 0;
丰盛的早餐变废为宝作文(lect o_w_id, o_d_id, sum(o_ol_cnt) from oorder group by o_w_id, o_d_id) except (lect ol_w_id, ol_d_id, count
八字谚语
(ol_o_id) from order_line group by ol_w_id, ol_d_id);离婚申请书
(lect d_w_id, sum(d_ytd) from district group by d_w_id) except(Select w_id, w_ytd from warehou);医疗保险证明
心绞痛快速治疗
连接到数据库做以上查询，如果结果全为0⾏，则说明tpcc库是⼀致的，否则说明此库在运⾏过程中数据出现混乱。
