[Feature Request]: Aggregate function bit_or()

[dengn]

Is there an existing issue for the same feature request?

• [X] I have checked the existing issues.

Is your feature request related to a problem?

Describe the feature you'd like

1. Similar to MySQL 8.0 in syntax.
2. Function syntax

BIT_OR(expr) [over_clause]

Returns the bitwise OR of all bits in expr.
Both input parameters and output values are of type uint.

mysql> SELECT  MAKER, BIT_OR(PRICE) BITS
          FROM CARS GROUP BY MAKER

+---------------------------------------------------------+
|MAKER           BITS                                     |
+---------------------------------------------------------+
|CHRYSLER        62293                                    |
|FORD            16127                                    |
|HONDA           32766                                    |
+---------------------------------------------------------+

Describe implementation you've considered

Documentation, Adoption, Use Case, Migration Strategy

• Please refer to the tutorial about how to develop an aggregate function.

• Please specify your factorization formula as well as the performance result with the dataset in our tutorial.

Additional information

[NTH19]

/assign

[dengn]

/assign

ok. Please sign up for the event before being assigned: https://www.wjx.top/vm/Ys1rz1I.aspx

[NTH19]

"I have finished Issue #1994" https://github.com/matrixorigin/matrixone/pull/2123

[dengn]

Feature implemented.