如何做 TiDB BenchmarkSQL 测试

ricemaster · 2021 年2 月 1 日 11:45

张鱼小丸子-PingCAP:

-- Condition 5: For any row in the ORDER table, O_CARRIER_ID is set to a null -- value if and only if there is a corresponding row in the -- NEW-ORDER table 
SELECT * FROM 
  (SELECT o.o_w_id, o.o_d_id, o.o_id, o.o_carrier_id, no.count_no 
   FROM bmsql_oorder o, (
     SELECT no_w_id, no_d_id, no_o_id, COUNT(*) count_no 
     FROM bmsql_new_order 
     GROUP BY no_w_id, no_d_id, no_o_id) no 
  WHERE o.o_w_id = no.no_w_id AND o.o_d_id = no.no_d_id AND o.o_id = no.no_o_id) as x 
WHERE (o_carrier_id IS NULL AND count_no = 0) OR (o_carrier_id IS NOT NULL AND count_no != 0);

请问这个检查的是什么条件啊？
尤其是最后的where，承运商是null并且新订单数量为0，这不应该是正确的条件吗？
为什么最终会select不出结果呢？