Summary

• Add bit_and() aggregate function - returns bitwise AND of all non-null values
• Add bit_or() aggregate function - returns bitwise OR of all non-null values
• Add bit_xor() aggregate function - returns bitwise XOR of all non-null values

All functions support byte, short, int, and long column types.

Features

• Proper null handling (nulls are skipped, similar to other aggregate functions)
• Constant folding optimization in factories
• Parallel execution support via merge() method
• Returns null for empty tables or all-null inputs

Usage Examples

-- Basic usage
SELECT bit_and(flags) FROM events;
SELECT bit_or(permissions) FROM users;
SELECT bit_xor(checksum) FROM data;

-- With GROUP BY
SELECT category, bit_and(status_flags) FROM items GROUP BY category;

Test plan

• Basic tests for all types (byte, short, int, long)
• Null handling tests
• Empty table tests
• All-null value tests
• GROUP BY tests
• Constant argument tests
• Parallel execution tests with WorkerPool (4 workers, 100K rows)
• Parallel execution tests with null values interspersed

🤖 Generated with Claude Code