cloudberry icon indicating copy to clipboard operation
cloudberry copied to clipboard

Subquery multiple return value test unstable

Open my-ship-it opened this issue 2 years ago • 0 comments

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

my-ship-it avatar Jul 24 '23 08:07 my-ship-it