[I] aggregate sqllogictest fails [arrow-datafusion]

["doki23 (via GitHub)" <gi...@apache.org>]

doki23 opened a new issue, #7764:
URL: https://github.com/apache/arrow-datafusion/issues/7764

   ### Describe the bug
   
   I run the sqllogictest at latest commit of the main branch but it failed.
   > cargo test --test sqllogictests
   
   the result is
   > External error: query result mismatch:
   [SQL] select trace_id, MIN(timestamp) from traces group by trace_id order by MIN(timestamp) asc limit 4;
   [Diff] (-expected|+actual)
       NULL 0
       b 0
   \-   c 1
   \-   a 1
   \+   a 1
   \+   c 1
   at test_files/aggregate.slt:2357
   
   
   ### To Reproduce
   
   run the command
   > cargo test --test sqllogictests
   
   my laptop is macbook pro m1, and the commit is `c0409a7b`
   
   ### Expected behavior
   
   pass the test
   
   ### Additional context
   
   _No response_


-- 
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: github-unsubscribe@arrow.apache.org.apache.org

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

Re: [I] aggregate sqllogictest fails [arrow-datafusion]

["alamb (via GitHub)" <gi...@apache.org>]

alamb closed issue #7764: aggregate sqllogictest fails
URL: https://github.com/apache/arrow-datafusion/issues/7764


-- 
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: github-unsubscribe@arrow.apache.org

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

Re: [I] aggregate sqllogictest fails [arrow-datafusion]

["alamb (via GitHub)" <gi...@apache.org>]

alamb commented on issue #7764:
URL: https://github.com/apache/arrow-datafusion/issues/7764#issuecomment-1751679467

   Thanks @doki23  -- it looks to me like the problem is that the output of the query is not deterministic -- namely that `min(timestamp)` is not distinct so `ORDER BY MIN(timestamp)` can return either order
   
   I recommend we update the data used so that the min timestamp is distinct (aka add a row like `('a', 0)` or something


-- 
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: github-unsubscribe@arrow.apache.org

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