bitmap_xor_count

description

Syntax

BIGINT BITMAP_XOR_COUNT(BITMAP lhs, BITMAP rhs, ...)

将两个及以上bitmap集合进行异或操作并返回结果集的大小

example

1. mysql> select bitmap_xor_count(bitmap_from_string('1,2,3'),bitmap_from_string('3,4,5'));
2. +----------------------------------------------------------------------------+
3. | bitmap_xor_count(bitmap_from_string('1,2,3'), bitmap_from_string('3,4,5')) |
4. +----------------------------------------------------------------------------+
5. |                                                                          4 |
6. +----------------------------------------------------------------------------+

8. mysql> select bitmap_xor_count(bitmap_from_string('1,2,3'),bitmap_from_string('1,2,3'));
9. +----------------------------------------------------------------------------+
10. | bitmap_xor_count(bitmap_from_string('1,2,3'), bitmap_from_string('1,2,3')) |
11. +----------------------------------------------------------------------------+
12. |                                                                          0 |
13. +----------------------------------------------------------------------------+

15. mysql> select bitmap_xor_count(bitmap_from_string('1,2,3'),bitmap_from_string('4,5,6'));
16. +----------------------------------------------------------------------------+
17. | bitmap_xor_count(bitmap_from_string('1,2,3'), bitmap_from_string('4,5,6')) |
18. +----------------------------------------------------------------------------+
19. |                                                                          6 |
20. +----------------------------------------------------------------------------+

22. MySQL> select (bitmap_xor_count(bitmap_from_string('2,3'),bitmap_from_string('1,2,3,4'),bitmap_from_string('3,4,5')));
23. +-----------------------------------------------------------------------------------------------------------+
24. | (bitmap_xor_count(bitmap_from_string('2,3'), bitmap_from_string('1,2,3,4'), bitmap_from_string('3,4,5'))) |
25. +-----------------------------------------------------------------------------------------------------------+
26. |                                                                                                         3 |
27. +-----------------------------------------------------------------------------------------------------------+

29. MySQL> select (bitmap_xor_count(bitmap_from_string('2,3'),bitmap_from_string('1,2,3,4'),bitmap_from_string('3,4,5'),bitmap_empty()));
30. +---------------------------------------------------------------------------------------------------------------------------+
31. | (bitmap_xor_count(bitmap_from_string('2,3'), bitmap_from_string('1,2,3,4'), bitmap_from_string('3,4,5'), bitmap_empty())) |
32. +---------------------------------------------------------------------------------------------------------------------------+
33. |                                                                                                                         3 |
34. +---------------------------------------------------------------------------------------------------------------------------+

36. MySQL> select (bitmap_xor_count(bitmap_from_string('2,3'),bitmap_from_string('1,2,3,4'),bitmap_from_string('3,4,5'),NULL));
37. +-----------------------------------------------------------------------------------------------------------------+
38. | (bitmap_xor_count(bitmap_from_string('2,3'), bitmap_from_string('1,2,3,4'), bitmap_from_string('3,4,5'), NULL)) |
39. +-----------------------------------------------------------------------------------------------------------------+
40. |                                                                                                            NULL |
41. +-----------------------------------------------------------------------------------------------------------------+

keyword

1. BITMAP_XOR_COUNT,BITMAP