bitmap_and_not,bitmap_andnot

description

Syntax

BITMAP BITMAP_AND_NOT(BITMAP lhs, BITMAP rhs)

Calculate the set after lhs minus intersection of two input bitmaps, return the new bitmap.

example

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

8. mysql> select bitmap_to_string(bitmap_and_not(bitmap_from_string('1,2,3'),bitmap_from_string('3,4,5')));
9. +--------------------------------------------------------------------------------------------+
10. | bitmap_to_string(bitmap_and_not(bitmap_from_string('1,2,3'), bitmap_from_string('3,4,5'))) |
11. +--------------------------------------------------------------------------------------------+
12. | 1,2                                                                                        |
13. +--------------------------------------------------------------------------------------------+

15. mysql> select bitmap_to_string(bitmap_and_not(bitmap_from_string('1,2,3'),bitmap_empty())) ;
16. +-------------------------------------------------------------------------------+
17. | bitmap_to_string(bitmap_and_not(bitmap_from_string('1,2,3'), bitmap_empty())) |
18. +-------------------------------------------------------------------------------+
19. | 1,2,3                                                                         |
20. +-------------------------------------------------------------------------------+

22. mysql> select bitmap_to_string(bitmap_and_not(bitmap_from_string('1,2,3'),NULL));
23. +---------------------------------------------------------------------+
24. | bitmap_to_string(bitmap_and_not(bitmap_from_string('1,2,3'), NULL)) |
25. +---------------------------------------------------------------------+
26. | NULL                                                                |
27. +---------------------------------------------------------------------+

keywords

1. BITMAP_AND_NOT,BITMAP_ANDNOT,BITMAP