You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@datafusion.apache.org by "2010YOUY01 (via GitHub)" <gi...@apache.org> on 2024/08/06 10:34:44 UTC

[I] Potential bug in `bool_and()` aggregate function [datafusion]

2010YOUY01 opened a new issue, #11846:
URL: https://github.com/apache/datafusion/issues/11846

   ### Describe the bug
   
   The last query in reproducer should return `true`
   
   Run in datafusion-cli:
   ```
   DataFusion CLI v40.0.0
   > create table t1(v1 int, v2 boolean);
   0 row(s) fetched.
   Elapsed 0.073 seconds.
   
   > insert into t1 values (1, true), (1, true);
   +-------+
   | count |
   +-------+
   | 2     |
   +-------+
   1 row(s) fetched.
   Elapsed 0.051 seconds.
   
   > select bool_and(v2) from t1;
   +-----------------+
   | bool_and(t1.v2) |
   +-----------------+
   | true            |
   +-----------------+
   1 row(s) fetched.
   Elapsed 0.016 seconds.
   
   > select v1, bool_and(v2) from t1 group by v1;
   +----+-----------------+
   | v1 | bool_and(t1.v2) |
   +----+-----------------+
   | 1  | false           |
   +----+-----------------+
   1 row(s) fetched.
   Elapsed 0.011 seconds.
   dd
   ```
   
   ### To Reproduce
   
   _No response_
   
   ### Expected behavior
   
   _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@datafusion.apache.org.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org


Re: [I] Potential bug in `bool_and()` aggregate function [datafusion]

Posted by "Dandandan (via GitHub)" <gi...@apache.org>.
Dandandan closed issue #11846: Potential bug in `bool_and()` aggregate function
URL: https://github.com/apache/datafusion/issues/11846


-- 
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@datafusion.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org