cloudberry
cloudberry copied to clipboard
Subquery multiple return value test unstable
In qp_union_intersect_optimizer.out line 1736,the sql:
set optimizer_segments=2; ANALYZE dml_union_r, dml_union_s; UPDATE dml_union_r SET a = ( SELECT a FROM dml_union_r UNION ALL SELECT a|1724 -- ERROR: one or more assertions failed FROM dml_union_s);
should always get the result:
ERROR: more than one row returned by a subquery used as an expression (seg2 slice1 10.138.0.30:7004 pid=3108610)
but we may get the result:
ERROR: one or more assertions failed DETAIL: Expected no more than one row to be returned by expression