bitmap_not

description

Syntax

BITMAP BITMAP_NOT(BITMAP lhs, BITMAP rhs)

Calculate the set after lhs minus rhs, return the new bitmap.

example

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

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

keyword

1. BITMAP_NOT,BITMAP