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/08/17 03:23:21 UTC

[GitHub] [incubator-doris] chaoyli opened a new issue #4368: Except wrong answer

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


   TPCDS qualification query87 will do two except.
   ```
   select count(*)
   from ((select distinct c_last_name, c_first_name, d_date
          from store_sales, date_dim, customer
          where store_sales.ss_sold_date_sk = date_dim.d_date_sk
            and store_sales.ss_customer_sk = customer.c_customer_sk
            and d_month_seq between 1200 and 1200+11)
          except
         (select distinct c_last_name, c_first_name, d_date
          from catalog_sales, date_dim, customer
          where catalog_sales.cs_sold_date_sk = date_dim.d_date_sk
            and catalog_sales.cs_bill_customer_sk = customer.c_customer_sk
            and d_month_seq between 1200 and 1200+11)
          except
         (select distinct c_last_name, c_first_name, d_date
          from web_sales, date_dim, customer
          where web_sales.ws_sold_date_sk = date_dim.d_date_sk
            and web_sales.ws_bill_customer_sk = customer.c_customer_sk
            and d_month_seq between 1200 and 1200+11)
   ) cool_cust
   ;
   ```


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



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

[GitHub] [incubator-doris] chaoyli closed issue #4368: Except wrong answer

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


   


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



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

[GitHub] [incubator-doris] chaoyli commented on issue #4368: Except wrong answer

Posted by GitBox <gi...@apache.org>.
chaoyli commented on issue #4368:
URL: https://github.com/apache/incubator-doris/issues/4368#issuecomment-674635371


   excepted answer
   ```
   +----------+
   | count(*) |
   +----------+
   |    47298 |
   +----------+
   ```
   
   Now the answer
   ```
   +----------+
   | count(*) |
   +----------+
   |    47297 |
   +----------+
   ```


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



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