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 2021/08/04 13:34:56 UTC

[GitHub] [incubator-doris] stdpain opened a new issue #6378: [BUG] got a wrong result in a left semi join

stdpain opened a new issue #6378:
URL: https://github.com/apache/incubator-doris/issues/6378


   **Describe the bug**
   
   Table 
   ```
   create table a_table (`products_id` bigint NULL)
   ENGINE=OLAP
   DUPLICATE KEY(`products_id`)
   DISTRIBUTED BY HASH(`products_id`) BUCKETS 6
   PROPERTIES (
   "replication_num" = "1",
   "in_memory" = "false",
   "storage_format" = "V2"
   );
   
   create table b_table (`products_id` bigint NULL)
   ENGINE=OLAP
   DUPLICATE KEY(`products_id`)
   DISTRIBUTED BY HASH(`products_id`) BUCKETS 6
   PROPERTIES (
   "replication_num" = "1",
   "in_memory" = "false",
   "storage_format" = "V2"
   );
   ```
   
   SQL:
   ```
   SELECT count( distinct products_id) FROM a_table as a WHERE 1=1 AND products_id in ( SELECT products_id from b_table );
   ```
   Result:
   ```
   mysql> select count(*) from a_table where products_id in (select products_id from b_table);
   +----------+
   | count(*) |
   +----------+
   |    10000 |
   +----------+
   1 row in set (0.40 sec)
   
   mysql> select count(*) from a_table where products_id in (select products_id from b_table);
   +----------+
   | count(*) |
   +----------+
   |     9999 |
   +----------+
   ```
   
   
   **Expected behavior**
   A clear and concise description of what you expected to happen.
   
   **Screenshots**
   If applicable, add screenshots to help explain your problem.
   
   **Desktop (please complete the following information):**
    - OS: [e.g. iOS]
    - Browser [e.g. chrome, safari]
    - Version [e.g. 22]
   
   **Smartphone (please complete the following information):**
    - Device: [e.g. iPhone6]
    - OS: [e.g. iOS8.1]
    - Browser [e.g. stock browser, safari]
    - Version [e.g. 22]
   
   **Additional context**
   Add any other context about the problem here.
   


-- 
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

[GitHub] [incubator-doris] morningman closed issue #6378: [BUG] got a wrong result in a left semi join

Posted by GitBox <gi...@apache.org>.
morningman closed issue #6378:
URL: https://github.com/apache/incubator-doris/issues/6378


   


-- 
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