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