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

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 

my-ship-it avatar Jul 19 '23 10:07 my-ship-it