We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
#6904 introduced a bug where bit_and when a GROUP BY will now return zero always
bit_and
This was found with the tests added in #6952
Run test in #6952
External error: query result mismatch: [SQL] SELECT bit_and(c1), bit_and(c2), bit_and(c3), bit_or(c1), bit_or(c2), bit_or(c3), bit_xor(c1), bit_xor(c2), bit_xor(c3), tag FROM bit_aggregate_functions GROUP BY tag ORDER BY tag [Diff] (-expected|+actual) - 1 8 11 13 14 11 12 6 11 A - 33 11 NULL 33 11 NULL 33 11 NULL B + 0 0 0 13 14 11 12 6 11 A + 0 0 NULL 33 11 NULL 33 11 NULL B at tests/sqllogictests/test_files/aggregate.slt:1546
Test should pass
No response
The text was updated successfully, but these errors were encountered:
@alamb I think the main problem is with the default value. (for bit_and it is -1).
-1
Sorry, something went wrong.
BitAnd
You are 100% correct -- thank you @izveigor
Successfully merging a pull request may close this issue.
Describe the bug
#6904 introduced a bug where
bit_and
when a GROUP BY will now return zero alwaysThis was found with the tests added in #6952
To Reproduce
Run test in #6952
Expected behavior
Test should pass
Additional context
No response
The text was updated successfully, but these errors were encountered: