Repository navigation
Regression: bit_and aggregate function is incorrect #6955
Description
Describe the bug
#6904 introduced a bug where bit_and when a GROUP BY will now return zero always
This was found with the tests added in #6952
To Reproduce
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
Expected behavior
Test should pass
Additional context
No response
Activity
izveigor commentedon Jul 13, 2023
@alamb I think the main problem is with the default value. (for
bit_andit is-1).alamb commentedon Jul 13, 2023
You are 100% correct -- thank you @izveigor