cloudberry
cloudberry copied to clipboard
Subquery multiple return value test unstable
qp_union_intersect,
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 get result sometime:
ERROR: one or more assertions failed
DETAIL: Expected no more than one row to be returned by expression