BIT_XOR
Description
Aggregate function.
The BIT_XOR(expr) function returns the bitwise XOR of all bits in expr.
Syntax
> BIT_XOR(expr)
Arguments
Arguments | Description |
---|---|
expr | UINT data types |
Examples
> drop table if exists t1;
> CREATE TABLE t1 (id CHAR(1), number INT);
> INSERT INTO t1 VALUES
('a',111),('a',110),('a',100),
('a',000),('b',001),('b',011);
> select id, BIT_XOR(number) FROM t1 GROUP BY id;
+------+-----------------+
| id | bit_xor(number) |
+------+-----------------+
| a | 101 |
| b | 10 |
+------+-----------------+
Constraints
Currently, MatrixOne doesn’t support select function() without from tables.