[doris] branch master updated: bitmap_from_string support uint64 string, but docs is wrong (#11510)

[jiafengzheng]

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 <104178...@qq.com>
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: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org