[Bug] ERROR: unexpected argument locus to set operation (cdbsetop.c:178)

[avamingli]

Apache Cloudberry version

main

What happened

ERROR: unexpected argument locus to set operation (cdbsetop.c:178)

What you think should happen instead

No response

How to reproduce

create table rt(a int) distributed replicated;
insert into rt select generate_series(1,10);
create table p1(a int) distributed by (a);
insert into p1 select generate_series(1,3);
CREATE TABLE
INSERT 0 10
CREATE TABLE
INSERT 0 3

explain(costs off) with result as (update rt set a = a +1 where a < 5 returning *) select * from result except select * from p1;
ERROR:  unexpected argument locus to set operation (cdbsetop.c:178)
show optimizer;
 optimizer
-----------
 on
(1 row)

set optimizer=off;
SET

explain(costs off) with result as (update rt set a = a +1 where a < 5 returning *) select * from result except select * from p1;
ERROR:  unexpected argument locus to set operation (cdbsetop.c:178)

Operating System

All

Anything else

No response

Are you willing to submit PR?

• [x] Yes, I am willing to submit a PR!

Code of Conduct

• [x] I agree to follow this project's Code of Conduct.