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 2022/07/09 08:42:06 UTC

[GitHub] [doris] Gabriel39 opened a new issue, #10715: [Bug] Wrong results when using in runtime filter

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

   ### Search before asking
   
   - [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues.
   
   
   ### Version
   
   master
   
   ### What's Wrong?
   
   When I set runtime_filter_type=1 which means IN runtime filter is forced to used, all data will be filtered in some cases
   
   ### What You Expected?
   
   get correct result
   
   ### How to Reproduce?
   
   TPCDS 1g
   
   WITH
     ws_wh AS (
      SELECT
        ws1.ws_order_number
      , ws1.ws_warehouse_sk wh1
      , ws2.ws_warehouse_sk wh2
      FROM
        web_sales ws1
      , web_sales ws2
      WHERE (ws1.ws_order_number = ws2.ws_order_number)
         AND (ws1.ws_warehouse_sk <> ws2.ws_warehouse_sk)
   )
   SELECT count(wr_order_number)
      FROM
        web_returns
      , ws_wh
      WHERE (wr_order_number = ws_wh.ws_order_number);
   
   ### 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](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-unsubscribe@doris.apache.org.apache.org

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


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

[GitHub] [doris] yiguolei closed issue #10715: [Bug] Wrong results when using in runtime filter

Posted by GitBox <gi...@apache.org>.
yiguolei closed issue #10715: [Bug] Wrong results when using in runtime filter
URL: https://github.com/apache/doris/issues/10715


-- 
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-unsubscribe@doris.apache.org

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


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