【TiDB 版本】v8.5.1-
TPCH sf1000 测试中Q13在开启 tidb_opt_agg_push_down=on后报错
[2025-04-24 17:42:14] execute run failed, err execute query
/PLACEHOLDER/ select
c_count,
count(*) as custdist
from
(
select
c_custkey,
count(o_orderkey) as c_count
from
customer left outer join orders on
c_custkey = o_custkey
and o_comment not like ‘%pending%deposits%’
group by
c_custkey
) c_orders
group by
c_count
order by
custdist desc,
c_count desc;
failed Error 1105: other error for mpp stream: Code: 0, e.displayText() = DB::Exception: Receiver state: ERROR, error message: Code: 349, e.displayText() = DB::Exception: Cannot convert NULL value to non-Nullable type, e.what() = DB::Exception,, e.what() = DB::Exception,