构造样本验证规则命中
构造样本验证规则命中
WITH mock AS (
SELECT NULL AS order_id, -1 AS amount UNION ALL
SELECT 1001, 10 UNION ALL
SELECT 1001, 20
)
SELECT
SUM(CASE WHEN order_id IS NULL THEN 1 ELSE 0 END) AS null_hit,
SUM(CASE WHEN amount < 0 THEN 1 ELSE 0 END) AS neg_hit,
COUNT(*) - COUNT(DISTINCT order_id) AS dup_hit
FROM mock;历史分区回放是低成本验证：拿上周真实数据跑新规则，先看误报率再决定阈值。