[Bug] (PiplineX&SetOperaor)when do intersect ,result is uncertain(wrong)

[TomaYoko]

Search before asking

• I had searched in the issues and found no similar issues.

Version

2.1.7 rc1

What's Wrong?

when the result of join and agg intersect with another query ,the result is ambiguous.

CREATE TABLE test1
( id VARCHAR(20),
c1 int
)
ENGINE=OLAP
DUPLICATE KEY( id )
COMMENT "OLAP"
DISTRIBUTED BY HASH( id ) BUCKETS auto
PROPERTIES (
"replication_num" = "1"
);
insert into test1 values ('a',1);
SELECT c1 FROM test1 GROUP BY c1 HAVING EXISTS(SELECT 1) INTERSECT SELECT c1 FROM test1; ---wrong result sql

What You Expected?

fix it

How to Reproduce?

Anything Else?

Hope that someone capable can fix it and notify me

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct