BIT_XOR

Description

Aggregate function.

The BIT_XOR(expr) function returns the bitwise XOR of all bits in expr.

Syntax

1. > BIT_XOR(expr)

Arguments

Examples

1. > drop table if exists t1;
2. > CREATE TABLE t1 (id CHAR(1), number INT);
3. > INSERT INTO t1 VALUES
4. ('a',111),('a',110),('a',100),
5. ('a',000),('b',001),('b',011);

7. > select id, BIT_XOR(number) FROM t1 GROUP BY id;
8. +------+-----------------+
9. | id   | bit_xor(number) |
10. +------+-----------------+
11. | a    |             101 |
12. | b    |              10 |
13. +------+-----------------+

Constraints

Currently, MatrixOne doesn’t support select function() without from tables.