andygrove commented on PR #783:
URL: https://github.com/apache/datafusion-comet/pull/783#issuecomment-2271285188

   > @andygrove Somehow `TPC-DS Correctness / Run TPCDSQuerySuite (broadcast)` 
failed.
   > 
   > ```
   > - q97 *** FAILED *** (1 second, 268 milliseconds)
   >   java.lang.Exception: Expected "537833    285408  200", but got "538012   
285422  200" Result did not match
   > ```
   
   q97 (partial)
   
   ```sql
   select  sum(case when ssci.customer_sk is not null and csci.customer_sk is 
null then 1 else 0 end) store_only
         ,sum(case when ssci.customer_sk is null and csci.customer_sk is not 
null then 1 else 0 end) catalog_only
         ,sum(case when ssci.customer_sk is not null and csci.customer_sk is 
not null then 1 else 0 end) store_and_catalog
   from ssci full outer join csci on (ssci.customer_sk=csci.customer_sk
                                  and ssci.item_sk = csci.item_sk)
   ```
   
   Seems like this may be a regression in DataFusion. I did make a change to 
`IsNotNull`. I wonder if that is an issue.


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to