BIT_XOR

1
SELECT
2
  batch_id,
3
  BIT_XOR(record_hash) as checksum
4
FROM data_records
5
GROUP BY batch_id;

1
SELECT BIT_XOR(value) as odd_occurrence
2
FROM (
3
  SELECT 5 as value UNION ALL
4
  SELECT 3 UNION ALL
5
  SELECT 5 UNION ALL
6
  SELECT 7 UNION ALL
7
  SELECT 3
8
);

1
SELECT
2
  transaction_date,
3
  BIT_XOR(transaction_id) as parity,
4
  CASE
5
    WHEN BIT_XOR(transaction_id) = 0 THEN 'Even count'
6
    ELSE 'Odd count detected'
7
  END as parity_status
8
FROM transactions
9
GROUP BY transaction_date;