group_bitmap_xor

description

Syntax

BITMAP GROUP_BITMAP_XOR(expr)

对expr进行 xor 计算, 返回新的bitmap。

example

1. mysql>  select page, bitmap_to_string(user_id) from pv_bitmap;
2. +------+-----------------------------+
3. | page | bitmap_to_string(`user_id`) |
4. +------+-----------------------------+
5. | m    | 4,7,8                       |
6. | m    | 1,3,6,15                    |
7. | m    | 4,7                         |
8. +------+-----------------------------+

10. mysql> select page, bitmap_to_string(group_bitmap_xor(user_id)) from pv_bitmap group by page;
11. +------+-----------------------------------------------+
12. | page | bitmap_to_string(group_bitmap_xor(`user_id`)) |
13. +------+-----------------------------------------------+
14. | m    | 1,3,6,8,15                                    |
15. +------+-----------------------------------------------+

keywords

1. GROUP_BITMAP_XOR,BITMAP