This is an automated email from the ASF dual-hosted git repository.
jiafengzheng pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new 74340dac44 bitmap_from_string support uint64 string, but docs is wrong
(#11510)
74340dac44 is described below
commit 74340dac44eee92c004c903aa320b6007b68ed10
Author: camby <[email protected]>
AuthorDate: Fri Aug 5 08:49:38 2022 +0800
bitmap_from_string support uint64 string, but docs is wrong (#11510)
bitmap_from_string support uint64 string, but docs is wrong
---
.../sql-functions/bitmap-functions/bitmap_from_string.md | 9 ++++++++-
.../sql-functions/bitmap-functions/bitmap_from_string.md | 9 ++++++++-
2 files changed, 16 insertions(+), 2 deletions(-)
diff --git
a/docs/en/docs/sql-manual/sql-functions/bitmap-functions/bitmap_from_string.md
b/docs/en/docs/sql-manual/sql-functions/bitmap-functions/bitmap_from_string.md
index 0d2f71c74f..f30afa0684 100644
---
a/docs/en/docs/sql-manual/sql-functions/bitmap-functions/bitmap_from_string.md
+++
b/docs/en/docs/sql-manual/sql-functions/bitmap-functions/bitmap_from_string.md
@@ -29,7 +29,7 @@ under the License.
`BITMAP BITMAP_FROM_STRING(VARCHAR input)`
-Convert a string into a bitmap. The input string should be a comma separated
UNIT32.
+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.
@@ -56,6 +56,13 @@ mysql> select bitmap_from_string("-1, 0, 1, 2");
+-----------------------------------+
| NULL |
+-----------------------------------+
+
+mysql> select bitmap_to_string(bitmap_from_string("0, 1,
18446744073709551615"));
++--------------------------------------------------------------------+
+| bitmap_to_string(bitmap_from_string('0, 1, 18446744073709551615')) |
++--------------------------------------------------------------------+
+| 0,1,18446744073709551615 |
++--------------------------------------------------------------------+
```
### keywords
diff --git
a/docs/zh-CN/docs/sql-manual/sql-functions/bitmap-functions/bitmap_from_string.md
b/docs/zh-CN/docs/sql-manual/sql-functions/bitmap-functions/bitmap_from_string.md
index d4eb875a15..4a495473e2 100644
---
a/docs/zh-CN/docs/sql-manual/sql-functions/bitmap-functions/bitmap_from_string.md
+++
b/docs/zh-CN/docs/sql-manual/sql-functions/bitmap-functions/bitmap_from_string.md
@@ -29,7 +29,7 @@ under the License.
`BITMAP BITMAP_FROM_STRING(VARCHAR input)`
-将一个字符串转化为一个BITMAP，字符串是由逗号分隔的一组UINT32数字组成.
+将一个字符串转化为一个BITMAP，字符串是由逗号分隔的一组unsigned bigint数字组成.(数字取值在:0 ~
18446744073709551615)
比如"0, 1, 2"字符串会转化为一个Bitmap，其中的第0, 1, 2位被设置.
当输入字段不合法时，返回NULL
@@ -56,6 +56,13 @@ mysql> select bitmap_from_string("-1, 0, 1, 2");
+-----------------------------------+
| NULL |
+-----------------------------------+
+
+mysql> select bitmap_to_string(bitmap_from_string("0, 1,
18446744073709551615"));
++--------------------------------------------------------------------+
+| bitmap_to_string(bitmap_from_string('0, 1, 18446744073709551615')) |
++--------------------------------------------------------------------+
+| 0,1,18446744073709551615 |
++--------------------------------------------------------------------+
```
### keywords
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
