You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@arrow.apache.org by "jayzhan211 (via GitHub)" <gi...@apache.org> on 2024/03/11 00:20:57 UTC

[I] Non deterministic result for window function [arrow-datafusion]

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

   ### Is your feature request related to a problem or challenge?
   
   This query failed sometimes.
   https://github.com/apache/arrow-datafusion/actions/runs/8222295671/job/22483743010
   https://github.com/apache/arrow-datafusion/actions/runs/8221664632/job/22482282908?pr=9524
   
   It is not always reproducible.
   
   [SQL] select lag(a) over () as x1
           from
           (select 2 id, 'b' a union all select 1 id, null a union all select 3 id, null);
   [Diff] (-expected|+actual)
       NULL
   Error: Execution("1 failures")
       NULL
   -   b
   +   NULL
   at test_files/window.slt:4302
   
   ### Describe the solution you'd like
   
   Not sure what is the root cause yet. We expect not to meet this failure again.
   
   ### Describe alternatives you've considered
   
   _No response_
   
   ### 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] Non deterministic result for window function [arrow-datafusion]

Posted by "jayzhan211 (via GitHub)" <gi...@apache.org>.
jayzhan211 commented on issue #9544:
URL: https://github.com/apache/arrow-datafusion/issues/9544#issuecomment-1991853684

   > Thanks @jayzhan211 for this issue. This problem is fixed with the [PR9559](https://github.com/apache/arrow-datafusion/pull/9559). I wasn't aware of this issue. Hence didn't mention this issue in the PR. If you agree that this problem no longer happens, we can close this issue.
   
   I see, thanks @mustafasrepo 


-- 
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] Non deterministic result for window function [arrow-datafusion]

Posted by "mustafasrepo (via GitHub)" <gi...@apache.org>.
mustafasrepo commented on issue #9544:
URL: https://github.com/apache/arrow-datafusion/issues/9544#issuecomment-1991845883

   This problem is fixed with the [PR9559](https://github.com/apache/arrow-datafusion/pull/9559). I wasn't aware of this issue. Hence didn't mention it in the PR. 


-- 
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] Non deterministic result for window function [arrow-datafusion]

Posted by "jayzhan211 (via GitHub)" <gi...@apache.org>.
jayzhan211 closed issue #9544: Non deterministic result for window function
URL: https://github.com/apache/arrow-datafusion/issues/9544


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