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-website.git
The following commit(s) were added to refs/heads/master by this push:
new 5341b69bc70 bitmap_from_string support uint64 string, but docs is wrong
5341b69bc70 is described below
commit 5341b69bc704f5526bca4de105fbc07a03c60e36
Author: jiafeng.zhang <[email protected]>
AuthorDate: Fri Aug 5 08:50:08 2022 +0800
bitmap_from_string support uint64 string, but docs is wrong
bitmap_from_string support uint64 string, but docs is wrong
---
.../sql-functions/bitmap-functions/bitmap_from_string.md | 10 +++++++++-
.../sql-functions/bitmap-functions/bitmap_from_string.md | 11 ++++++++++-
2 files changed, 19 insertions(+), 2 deletions(-)
diff --git
a/docs/sql-manual/sql-functions/bitmap-functions/bitmap_from_string.md
b/docs/sql-manual/sql-functions/bitmap-functions/bitmap_from_string.md
index 0d2f71c74f7..413c9ec5c32 100644
--- a/docs/sql-manual/sql-functions/bitmap-functions/bitmap_from_string.md
+++ b/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,14 @@ 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/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/bitmap-functions/bitmap_from_string.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/bitmap-functions/bitmap_from_string.md
index d4eb875a156..5c7d5fd091c 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/bitmap-functions/bitmap_from_string.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/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,15 @@ 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]
