bitmap_not

description

Syntax

BITMAP BITMAP_NOT(BITMAP lhs, BITMAP rhs)

计算lhs减去rhs之后的集合，返回新的bitmap.

example

1. mysql> select bitmap_to_string(bitmap_not(bitmap_from_string('2,3'),bitmap_from_string('1,2,3,4')));
2. +----------------------------------------------------------------------------------------+
3. | bitmap_to_string(bitmap_not(bitmap_from_string('2,3'), bitmap_from_string('1,2,3,4'))) |
4. +----------------------------------------------------------------------------------------+
5. |                                                                                        |
6. +----------------------------------------------------------------------------------------+
7. 1 row in set (0.01 sec)

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

keywords

1. BITMAP_NOT,BITMAP