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_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. +----------------------------------------------------------------------------------------+
  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_not(bitmap_from_string('2,3,5'), bitmap_from_string('1,2,3,4'))) |
  11. +------------------------------------------------------------------------------------------+
  12. | 5                                                                                        |
  13. +------------------------------------------------------------------------------------------+

keywords

  1. BITMAP_NOT,BITMAP