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

[via GitHub]

TomaYoko opened a new issue, #40949:
URL: https://github.com/apache/doris/issues/40949

   ### Search before asking
   
   - [X] I had searched in the 
[issues](https://github.com/apache/doris/issues?q=is%3Aissue) 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?
   
   
![image](https://github.com/user-attachments/assets/219d7818-396e-4191-a486-340fa2886fc3)
   
![image](https://github.com/user-attachments/assets/a81e729b-10ea-4a15-8dac-31909be589d6)
   
   
   ### How to Reproduce?
   
   _No response_
   
   ### 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
   
   - [X] I agree to follow this project's [Code of 
Conduct](https://www.apache.org/foundation/policies/conduct)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org