Skip to content

Subquery multiple return value test unstable #22

Description

@my-ship-it

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 

Metadata

Metadata

Assignees

No one assigned

    Labels

    type: BugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions