bitmap_from_string

description

Syntax

BITMAP BITMAP_FROM_STRING(VARCHAR input)

Convert a string into a bitmap. The input string should be a comma separated unsigned bigint (ranging from 0 to 18446744073709551615). For example: input string “0, 1, 2” will be converted to a Bitmap with bit 0, 1, 2 set. If input string is invalid, return NULL.

example

1. mysql> select bitmap_to_string(bitmap_empty());
2. +----------------------------------+
3. | bitmap_to_string(bitmap_empty()) |
4. +----------------------------------+
5. |                                  |
6. +----------------------------------+

8. mysql> select bitmap_to_string(bitmap_from_string("0, 1, 2"));
9. +-------------------------------------------------+
10. | bitmap_to_string(bitmap_from_string('0, 1, 2')) |
11. +-------------------------------------------------+
12. | 0,1,2                                           |
13. +-------------------------------------------------+

15. mysql> select bitmap_from_string("-1, 0, 1, 2");
16. +-----------------------------------+
17. | bitmap_from_string('-1, 0, 1, 2') |
18. +-----------------------------------+
19. | NULL                              |
20. +-----------------------------------+

22. mysql> select bitmap_to_string(bitmap_from_string("0, 1, 18446744073709551615"));
23. +--------------------------------------------------------------------+
24. | bitmap_to_string(bitmap_from_string('0, 1, 18446744073709551615')) |
25. +--------------------------------------------------------------------+
26. | 0,1,18446744073709551615                                           |
27. +--------------------------------------------------------------------+

keywords

1. BITMAP_FROM_STRING,BITMAP