tpcc验证一致性的简单方法

(Select w_id, w_ytd from warehouse) except(select 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 (select 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 (select no_w_id, no_d_id, max(no_o_id) from new_order group by no_w_id, no_d_id);


select * from (select (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;


(select o_w_id, o_d_id, sum(o_ol_cnt) from oorder  group by o_w_id, o_d_id) except (select ol_w_id, ol_d_id, count
(ol_o_id) from order_line group by ol_w_id, ol_d_id);

(select d_w_id, sum(d_ytd) from district group by d_w_id)  except(Select w_id, w_ytd from warehouse);

连接到数据库做以上查询，如果结果全为0行，则说明tpcc库是一致的，否则说明此库在运行过程中数据出现混乱。