TPCC Consistency 约束验证SQLs 以下,是按照TPCC标准,撰写的验证Consistency的12条SQL,每条SQL返回结果为Empty Sets时,说明此验证通过。 以下所有的SQL,在MySQL + TNT引擎 + TPCC-MySQL + 10-warehouses下执行成功(除了Condition 10,11,12,最终的SQL未能撰写成功)。 Consistency Conditions ————————— Consistency Condition 1 -——————————– – Entries in the WAREHOUSE and DISTRICT tables must satisfy the relationship: – W_YTD = sum(D_YTD) – for each warehouse … 继续阅读 →
Community journal
Follow the feed
The latest from the MySQL community
Ideas, releases, practical guides, and perspectives from the people building with MySQL.
Showing entries 1 to 1 of 1
« Previous |
Next »
Aug
21
2012