yangzhg opened a new issue #3227: May output incorrect results when using intersect and except statements URL: https://github.com/apache/incubator-doris/issues/3227 **Describe the bug** The output tuple of intersect and except is one tuple. When the number of input tuples of the intersect and except nodes is greater than one, the intersect and except nodes do not properly merge the input data. **To Reproduce** using tpcds query 14 or query like ``` SELECT iss.i_brand_id brand_id , iss.i_class_id class_id , iss.i_category_id category_id FROM store_sales ,item iss ,date_dim d1 WHERE ss_item_sk = iss.i_item_sk AND ss_sold_date_sk = d1.d_date_sk AND d1.d_year BETWEEN 1998 AND 1998 + 2 INTERSECT SELECT ics.i_brand_id , ics.i_class_id , ics.i_category_id FROM catalog_sales ,item ics ,date_dim d2 WHERE cs_item_sk = ics.i_item_sk AND cs_sold_date_sk = d2.d_date_sk AND d2.d_year BETWEEN 1998 AND 1998 + 2 ``` you will see the result is incorrect， but the reult count is correct
---------------------------------------------------------------- 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. For queries about this service, please contact Infrastructure at: us...@infra.apache.org With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
