You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2020/03/30 07:55:45 UTC
[GitHub] [incubator-doris] yangzhg opened a new issue #3227: May output
incorrect results when using intersect and except statements
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:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] imay closed issue #3227: output results may
incorrect when using intersect and except statements
Posted by GitBox <gi...@apache.org>.
imay closed issue #3227: output results may incorrect when using intersect and except statements
URL: https://github.com/apache/incubator-doris/issues/3227
----------------------------------------------------------------
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:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org