This is an automated email from the ASF dual-hosted git repository.
diwu pushed a commit to branch branch-1.2-lts
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-1.2-lts by this push:
new eef6a4ab6b [typo](docs) modify the documentation for the bitmap
function in 1.2-lts (#21724)
eef6a4ab6b is described below
commit eef6a4ab6b6d86dad33ae81e54f880a203b42d0c
Author: Euporia <[email protected]>
AuthorDate: Fri Jul 14 18:48:20 2023 +0800
[typo](docs) modify the documentation for the bitmap function in 1.2-lts
(#21724)
---
.../sql-functions/bitmap-functions/bitmap_and.md | 15 +++++++++----
.../bitmap-functions/bitmap_and_not.md | 21 +++++++++++++++++
.../sql-functions/bitmap-functions/bitmap_empty.md | 7 ++++++
.../bitmap-functions/bitmap_has_all.md | 26 +++++++++++-----------
.../bitmap-functions/bitmap_has_any.md | 26 +++++++++++-----------
.../bitmap-functions/bitmap_hash64.md | 12 +++++-----
.../sql-functions/bitmap-functions/bitmap_not.md | 14 ++++++------
.../sql-functions/bitmap-functions/bitmap_or.md | 25 +++++++++++++--------
.../sql-functions/bitmap-functions/bitmap_and.md | 15 +++++++++----
.../bitmap-functions/bitmap_and_not.md | 21 +++++++++++++++++
.../sql-functions/bitmap-functions/bitmap_empty.md | 7 ++++++
.../bitmap-functions/bitmap_has_all.md | 26 +++++++++++-----------
.../bitmap-functions/bitmap_has_any.md | 26 +++++++++++-----------
.../bitmap-functions/bitmap_hash64.md | 12 +++++-----
.../sql-functions/bitmap-functions/bitmap_not.md | 20 ++++++++---------
.../sql-functions/bitmap-functions/bitmap_or.md | 25 +++++++++++++--------
16 files changed, 191 insertions(+), 107 deletions(-)
diff --git
a/docs/en/docs/sql-manual/sql-functions/bitmap-functions/bitmap_and.md
b/docs/en/docs/sql-manual/sql-functions/bitmap-functions/bitmap_and.md
index a64a52b570..7cfdcec0d0 100644
--- a/docs/en/docs/sql-manual/sql-functions/bitmap-functions/bitmap_and.md
+++ b/docs/en/docs/sql-manual/sql-functions/bitmap-functions/bitmap_and.md
@@ -42,6 +42,13 @@ mysql> select bitmap_count(bitmap_and(to_bitmap(1),
to_bitmap(2))) cnt;
| 0 |
+------+
+mysql> select bitmap_to_string(bitmap_and(to_bitmap(1), to_bitmap(2)));
++----------------------------------------------------------+
+| bitmap_to_string(bitmap_and(to_bitmap(1), to_bitmap(2))) |
++----------------------------------------------------------+
+| |
++----------------------------------------------------------+
+
mysql> select bitmap_count(bitmap_and(to_bitmap(1), to_bitmap(1))) cnt;
+------+
| cnt |
@@ -49,28 +56,28 @@ mysql> select bitmap_count(bitmap_and(to_bitmap(1),
to_bitmap(1))) cnt;
| 1 |
+------+
-MySQL> select bitmap_to_string(bitmap_and(to_bitmap(1), to_bitmap(1)));
+mysql> select bitmap_to_string(bitmap_and(to_bitmap(1), to_bitmap(1)));
+----------------------------------------------------------+
| bitmap_to_string(bitmap_and(to_bitmap(1), to_bitmap(1))) |
+----------------------------------------------------------+
| 1 |
+----------------------------------------------------------+
-MySQL> select bitmap_to_string(bitmap_and(bitmap_from_string('1,2,3'),
bitmap_from_string('1,2'), bitmap_from_string('1,2,3,4,5')));
+mysql> select bitmap_to_string(bitmap_and(bitmap_from_string('1,2,3'),
bitmap_from_string('1,2'), bitmap_from_string('1,2,3,4,5')));
+-----------------------------------------------------------------------------------------------------------------------+
| bitmap_to_string(bitmap_and(bitmap_from_string('1,2,3'),
bitmap_from_string('1,2'), bitmap_from_string('1,2,3,4,5'))) |
+-----------------------------------------------------------------------------------------------------------------------+
| 1,2
|
+-----------------------------------------------------------------------------------------------------------------------+
-MySQL> select bitmap_to_string(bitmap_and(bitmap_from_string('1,2,3'),
bitmap_from_string('1,2'), bitmap_from_string('1,2,3,4,5'),bitmap_empty()));
+mysql> select bitmap_to_string(bitmap_and(bitmap_from_string('1,2,3'),
bitmap_from_string('1,2'), bitmap_from_string('1,2,3,4,5'),bitmap_empty()));
+---------------------------------------------------------------------------------------------------------------------------------------+
| bitmap_to_string(bitmap_and(bitmap_from_string('1,2,3'),
bitmap_from_string('1,2'), bitmap_from_string('1,2,3,4,5'), bitmap_empty())) |
+---------------------------------------------------------------------------------------------------------------------------------------+
|
|
+---------------------------------------------------------------------------------------------------------------------------------------+
-MySQL> select bitmap_to_string(bitmap_and(bitmap_from_string('1,2,3'),
bitmap_from_string('1,2'), bitmap_from_string('1,2,3,4,5'),NULL));
+mysql> select bitmap_to_string(bitmap_and(bitmap_from_string('1,2,3'),
bitmap_from_string('1,2'), bitmap_from_string('1,2,3,4,5'),NULL));
+-----------------------------------------------------------------------------------------------------------------------------+
| bitmap_to_string(bitmap_and(bitmap_from_string('1,2,3'),
bitmap_from_string('1,2'), bitmap_from_string('1,2,3,4,5'), NULL)) |
+-----------------------------------------------------------------------------------------------------------------------------+
diff --git
a/docs/en/docs/sql-manual/sql-functions/bitmap-functions/bitmap_and_not.md
b/docs/en/docs/sql-manual/sql-functions/bitmap-functions/bitmap_and_not.md
index e370ce90b3..b0f13dced1 100644
--- a/docs/en/docs/sql-manual/sql-functions/bitmap-functions/bitmap_and_not.md
+++ b/docs/en/docs/sql-manual/sql-functions/bitmap-functions/bitmap_and_not.md
@@ -41,6 +41,27 @@ mysql> select
bitmap_count(bitmap_and_not(bitmap_from_string('1,2,3'),bitmap_fro
+------+
| 2 |
+------+
+
+mysql> select
bitmap_to_string(bitmap_and_not(bitmap_from_string('1,2,3'),bitmap_from_string('3,4,5')));
++--------------------------------------------------------------------------------------------+
+| bitmap_to_string(bitmap_and_not(bitmap_from_string('1,2,3'),
bitmap_from_string('3,4,5'))) |
++--------------------------------------------------------------------------------------------+
+| 1,2
|
++--------------------------------------------------------------------------------------------+
+
+mysql> select
bitmap_to_string(bitmap_and_not(bitmap_from_string('1,2,3'),bitmap_empty())) ;
++-------------------------------------------------------------------------------+
+| bitmap_to_string(bitmap_and_not(bitmap_from_string('1,2,3'),
bitmap_empty())) |
++-------------------------------------------------------------------------------+
+| 1,2,3
|
++-------------------------------------------------------------------------------+
+
+mysql> select
bitmap_to_string(bitmap_and_not(bitmap_from_string('1,2,3'),NULL));
++---------------------------------------------------------------------+
+| bitmap_to_string(bitmap_and_not(bitmap_from_string('1,2,3'), NULL)) |
++---------------------------------------------------------------------+
+| NULL |
++---------------------------------------------------------------------+
```
### keywords
diff --git
a/docs/en/docs/sql-manual/sql-functions/bitmap-functions/bitmap_empty.md
b/docs/en/docs/sql-manual/sql-functions/bitmap-functions/bitmap_empty.md
index 6c5a90ccea..a8b4bbdcc1 100644
--- a/docs/en/docs/sql-manual/sql-functions/bitmap-functions/bitmap_empty.md
+++ b/docs/en/docs/sql-manual/sql-functions/bitmap-functions/bitmap_empty.md
@@ -45,6 +45,13 @@ mysql> select bitmap_count(bitmap_empty());
+------------------------------+
| 0 |
+------------------------------+
+
+mysql> select bitmap_to_string(bitmap_empty());
++----------------------------------+
+| bitmap_to_string(bitmap_empty()) |
++----------------------------------+
+| |
++----------------------------------+
```
### keywords
diff --git
a/docs/en/docs/sql-manual/sql-functions/bitmap-functions/bitmap_has_all.md
b/docs/en/docs/sql-manual/sql-functions/bitmap-functions/bitmap_has_all.md
index 7087abf531..a8dc6b19b5 100644
--- a/docs/en/docs/sql-manual/sql-functions/bitmap-functions/bitmap_has_all.md
+++ b/docs/en/docs/sql-manual/sql-functions/bitmap-functions/bitmap_has_all.md
@@ -36,19 +36,19 @@ Returns true if the second bitmap contains an empty element.
### example
```
-mysql> select bitmap_has_all(bitmap_from_string("0, 1, 2"),
bitmap_from_string("1, 2")) cnt;
-+------+
-| cnt |
-+------+
-| 1 |
-+------+
-
-mysql> select bitmap_has_all(bitmap_empty(), bitmap_from_string("1, 2")) cnt;
-+------+
-| cnt |
-+------+
-| 0 |
-+------+
+mysql> select bitmap_has_all(bitmap_from_string("0, 1, 2"),
bitmap_from_string("1, 2"));
++---------------------------------------------------------------------------+
+| bitmap_has_all(bitmap_from_string('0, 1, 2'), bitmap_from_string('1, 2')) |
++---------------------------------------------------------------------------+
+| 1 |
++---------------------------------------------------------------------------+
+
+mysql> select bitmap_has_all(bitmap_empty(), bitmap_from_string("1, 2"));
++------------------------------------------------------------+
+| bitmap_has_all(bitmap_empty(), bitmap_from_string('1, 2')) |
++------------------------------------------------------------+
+| 0 |
++------------------------------------------------------------+
```
### keywords
diff --git
a/docs/en/docs/sql-manual/sql-functions/bitmap-functions/bitmap_has_any.md
b/docs/en/docs/sql-manual/sql-functions/bitmap-functions/bitmap_has_any.md
index 4e47b6f343..0466aeb322 100644
--- a/docs/en/docs/sql-manual/sql-functions/bitmap-functions/bitmap_has_any.md
+++ b/docs/en/docs/sql-manual/sql-functions/bitmap-functions/bitmap_has_any.md
@@ -35,19 +35,19 @@ Calculate whether there are intersecting elements in the
two Bitmap columns. The
### example
```
-mysql> select bitmap_has_any(to_bitmap(1),to_bitmap(2)) cnt;
-+------+
-| cnt |
-+------+
-| 0 |
-+------+
-
-mysql> select bitmap_has_any(to_bitmap(1),to_bitmap(1)) cnt;
-+------+
-| cnt |
-+------+
-| 1 |
-+------+
+mysql> select bitmap_has_any(to_bitmap(1),to_bitmap(2));
++--------------------------------------------+
+| bitmap_has_any(to_bitmap(1), to_bitmap(2)) |
++--------------------------------------------+
+| 0 |
++--------------------------------------------+
+
+mysql> select bitmap_has_any(to_bitmap(1),to_bitmap(1));
++--------------------------------------------+
+| bitmap_has_any(to_bitmap(1), to_bitmap(1)) |
++--------------------------------------------+
+| 1 |
++--------------------------------------------+
```
### keywords
diff --git
a/docs/en/docs/sql-manual/sql-functions/bitmap-functions/bitmap_hash64.md
b/docs/en/docs/sql-manual/sql-functions/bitmap-functions/bitmap_hash64.md
index e633df9b94..a9a9f03e6d 100644
--- a/docs/en/docs/sql-manual/sql-functions/bitmap-functions/bitmap_hash64.md
+++ b/docs/en/docs/sql-manual/sql-functions/bitmap-functions/bitmap_hash64.md
@@ -39,12 +39,12 @@ cat data | curl --location-trusted -u user:passwd -T - -H
"columns: dt,page,devi
### example
```
-mysql> select bitmap_count(bitmap_hash64('hello'));
-+------------------------------------+
-| bitmap_count(bitmap_hash64('hello')) |
-+------------------------------------+
-| 1 |
-+------------------------------------+
+mysql> select bitmap_to_string(bitmap_hash64('hello'));
++------------------------------------------+
+| bitmap_to_string(bitmap_hash64('hello')) |
++------------------------------------------+
+| 15231136565543391023 |
++------------------------------------------+
```
### keywords
diff --git
a/docs/en/docs/sql-manual/sql-functions/bitmap-functions/bitmap_not.md
b/docs/en/docs/sql-manual/sql-functions/bitmap-functions/bitmap_not.md
index 4d26248091..c3e5a069bd 100644
--- a/docs/en/docs/sql-manual/sql-functions/bitmap-functions/bitmap_not.md
+++ b/docs/en/docs/sql-manual/sql-functions/bitmap-functions/bitmap_not.md
@@ -35,16 +35,16 @@ Calculate the set after lhs minus rhs, return the new
bitmap.
### example
```
-mysql> select
bitmap_count(bitmap_not(bitmap_from_string('2,3'),bitmap_from_string('1,2,3,4')))
cnt;
-+------+
-| cnt |
-+------+
-| 0 |
-+------+
+mysql> select
bitmap_to_string(bitmap_not(bitmap_from_string('2,3'),bitmap_from_string('1,2,3,4')));
++----------------------------------------------------------------------------------------+
+| bitmap_to_string(bitmap_not(bitmap_from_string('2,3'),
bitmap_from_string('1,2,3,4'))) |
++----------------------------------------------------------------------------------------+
+|
|
++----------------------------------------------------------------------------------------+
mysql> select
bitmap_to_string(bitmap_not(bitmap_from_string('2,3,5'),bitmap_from_string('1,2,3,4')));
+----------------------------------------------------------------------------------------+
-| bitmap_to_string(bitmap_xor(bitmap_from_string('2,3,5'),
bitmap_from_string('1,2,3,4'))) |
+| bitmap_to_string(bitmap_not(bitmap_from_string('2,3,5'),
bitmap_from_string('1,2,3,4'))) |
+----------------------------------------------------------------------------------------+
| 5
|
+----------------------------------------------------------------------------------------+
diff --git
a/docs/en/docs/sql-manual/sql-functions/bitmap-functions/bitmap_or.md
b/docs/en/docs/sql-manual/sql-functions/bitmap-functions/bitmap_or.md
index e5e9be9ac6..6754d8f321 100644
--- a/docs/en/docs/sql-manual/sql-functions/bitmap-functions/bitmap_or.md
+++ b/docs/en/docs/sql-manual/sql-functions/bitmap-functions/bitmap_or.md
@@ -35,42 +35,49 @@ Compute union of two or more input bitmaps, returns the new
bitmap.
### example
```
-mysql> select bitmap_count(bitmap_or(to_bitmap(1), to_bitmap(2))) cnt;
+mysql> select bitmap_count(bitmap_or(to_bitmap(1), to_bitmap(1))) cnt;
+------+
| cnt |
+------+
-| 2 |
+| 1 |
+------+
-mysql> select bitmap_count(bitmap_or(to_bitmap(1), to_bitmap(1))) cnt;
+mysql> select bitmap_to_string(bitmap_or(to_bitmap(1), to_bitmap(1))) ;
++---------------------------------------------------------+
+| bitmap_to_string(bitmap_or(to_bitmap(1), to_bitmap(1))) |
++---------------------------------------------------------+
+| 1 |
++---------------------------------------------------------+
+
+mysql> select bitmap_count(bitmap_or(to_bitmap(1), to_bitmap(2))) cnt;
+------+
| cnt |
+------+
-| 1 |
+| 2 |
+------+
-MySQL> select bitmap_to_string(bitmap_or(to_bitmap(1), to_bitmap(2)));
+mysql> select bitmap_to_string(bitmap_or(to_bitmap(1), to_bitmap(2)));
+---------------------------------------------------------+
| bitmap_to_string(bitmap_or(to_bitmap(1), to_bitmap(2))) |
+---------------------------------------------------------+
| 1,2 |
+---------------------------------------------------------+
-MySQL> select bitmap_to_string(bitmap_or(to_bitmap(1), to_bitmap(2),
to_bitmap(10), to_bitmap(0), NULL));
+mysql> select bitmap_to_string(bitmap_or(to_bitmap(1), to_bitmap(2),
to_bitmap(10), to_bitmap(0), NULL));
+--------------------------------------------------------------------------------------------+
| bitmap_to_string(bitmap_or(to_bitmap(1), to_bitmap(2), to_bitmap(10),
to_bitmap(0), NULL)) |
+--------------------------------------------------------------------------------------------+
-| NULL
|
+| 0,1,2,10
|
+--------------------------------------------------------------------------------------------+
-MySQL> select bitmap_to_string(bitmap_or(to_bitmap(1),
to_bitmap(2),to_bitmap(10),to_bitmap(0),bitmap_empty()));
+mysql> select bitmap_to_string(bitmap_or(to_bitmap(1),
to_bitmap(2),to_bitmap(10),to_bitmap(0),bitmap_empty()));
+------------------------------------------------------------------------------------------------------+
| bitmap_to_string(bitmap_or(to_bitmap(1), to_bitmap(2), to_bitmap(10),
to_bitmap(0), bitmap_empty())) |
+------------------------------------------------------------------------------------------------------+
| 0,1,2,10
|
+------------------------------------------------------------------------------------------------------+
-MySQL> select bitmap_to_string(bitmap_or(to_bitmap(10),
bitmap_from_string('1,2'), bitmap_from_string('1,2,3,4,5'))) ;
+mysql> select bitmap_to_string(bitmap_or(to_bitmap(10),
bitmap_from_string('1,2'), bitmap_from_string('1,2,3,4,5'))) ;
+--------------------------------------------------------------------------------------------------------+
| bitmap_to_string(bitmap_or(to_bitmap(10), bitmap_from_string('1,2'),
bitmap_from_string('1,2,3,4,5'))) |
+--------------------------------------------------------------------------------------------------------+
diff --git
a/docs/zh-CN/docs/sql-manual/sql-functions/bitmap-functions/bitmap_and.md
b/docs/zh-CN/docs/sql-manual/sql-functions/bitmap-functions/bitmap_and.md
index 9e342842ed..ccb413ae81 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/bitmap-functions/bitmap_and.md
+++ b/docs/zh-CN/docs/sql-manual/sql-functions/bitmap-functions/bitmap_and.md
@@ -42,6 +42,13 @@ mysql> select bitmap_count(bitmap_and(to_bitmap(1),
to_bitmap(2))) cnt;
| 0 |
+------+
+mysql> select bitmap_to_string(bitmap_and(to_bitmap(1), to_bitmap(2)));
++----------------------------------------------------------+
+| bitmap_to_string(bitmap_and(to_bitmap(1), to_bitmap(2))) |
++----------------------------------------------------------+
+| |
++----------------------------------------------------------+
+
mysql> select bitmap_count(bitmap_and(to_bitmap(1), to_bitmap(1))) cnt;
+------+
| cnt |
@@ -49,28 +56,28 @@ mysql> select bitmap_count(bitmap_and(to_bitmap(1),
to_bitmap(1))) cnt;
| 1 |
+------+
-MySQL> select bitmap_to_string(bitmap_and(to_bitmap(1), to_bitmap(1)));
+mysql> select bitmap_to_string(bitmap_and(to_bitmap(1), to_bitmap(1)));
+----------------------------------------------------------+
| bitmap_to_string(bitmap_and(to_bitmap(1), to_bitmap(1))) |
+----------------------------------------------------------+
| 1 |
+----------------------------------------------------------+
-MySQL> select bitmap_to_string(bitmap_and(bitmap_from_string('1,2,3'),
bitmap_from_string('1,2'), bitmap_from_string('1,2,3,4,5')));
+mysql> select bitmap_to_string(bitmap_and(bitmap_from_string('1,2,3'),
bitmap_from_string('1,2'), bitmap_from_string('1,2,3,4,5')));
+-----------------------------------------------------------------------------------------------------------------------+
| bitmap_to_string(bitmap_and(bitmap_from_string('1,2,3'),
bitmap_from_string('1,2'), bitmap_from_string('1,2,3,4,5'))) |
+-----------------------------------------------------------------------------------------------------------------------+
| 1,2
|
+-----------------------------------------------------------------------------------------------------------------------+
-MySQL> select bitmap_to_string(bitmap_and(bitmap_from_string('1,2,3'),
bitmap_from_string('1,2'), bitmap_from_string('1,2,3,4,5'),bitmap_empty()));
+mysql> select bitmap_to_string(bitmap_and(bitmap_from_string('1,2,3'),
bitmap_from_string('1,2'), bitmap_from_string('1,2,3,4,5'),bitmap_empty()));
+---------------------------------------------------------------------------------------------------------------------------------------+
| bitmap_to_string(bitmap_and(bitmap_from_string('1,2,3'),
bitmap_from_string('1,2'), bitmap_from_string('1,2,3,4,5'), bitmap_empty())) |
+---------------------------------------------------------------------------------------------------------------------------------------+
|
|
+---------------------------------------------------------------------------------------------------------------------------------------+
-MySQL> select bitmap_to_string(bitmap_and(bitmap_from_string('1,2,3'),
bitmap_from_string('1,2'), bitmap_from_string('1,2,3,4,5'),NULL));
+mysql> select bitmap_to_string(bitmap_and(bitmap_from_string('1,2,3'),
bitmap_from_string('1,2'), bitmap_from_string('1,2,3,4,5'),NULL));
+-----------------------------------------------------------------------------------------------------------------------------+
| bitmap_to_string(bitmap_and(bitmap_from_string('1,2,3'),
bitmap_from_string('1,2'), bitmap_from_string('1,2,3,4,5'), NULL)) |
+-----------------------------------------------------------------------------------------------------------------------------+
diff --git
a/docs/zh-CN/docs/sql-manual/sql-functions/bitmap-functions/bitmap_and_not.md
b/docs/zh-CN/docs/sql-manual/sql-functions/bitmap-functions/bitmap_and_not.md
index d24bcb3a87..f587af76c4 100644
---
a/docs/zh-CN/docs/sql-manual/sql-functions/bitmap-functions/bitmap_and_not.md
+++
b/docs/zh-CN/docs/sql-manual/sql-functions/bitmap-functions/bitmap_and_not.md
@@ -41,6 +41,27 @@ mysql> select
bitmap_count(bitmap_and_not(bitmap_from_string('1,2,3'),bitmap_fro
+------+
| 2 |
+------+
+
+mysql> select
bitmap_to_string(bitmap_and_not(bitmap_from_string('1,2,3'),bitmap_from_string('3,4,5')));
++--------------------------------------------------------------------------------------------+
+| bitmap_to_string(bitmap_and_not(bitmap_from_string('1,2,3'),
bitmap_from_string('3,4,5'))) |
++--------------------------------------------------------------------------------------------+
+| 1,2
|
++--------------------------------------------------------------------------------------------+
+
+mysql> select
bitmap_to_string(bitmap_and_not(bitmap_from_string('1,2,3'),bitmap_empty())) ;
++-------------------------------------------------------------------------------+
+| bitmap_to_string(bitmap_and_not(bitmap_from_string('1,2,3'),
bitmap_empty())) |
++-------------------------------------------------------------------------------+
+| 1,2,3
|
++-------------------------------------------------------------------------------+
+
+mysql> select
bitmap_to_string(bitmap_and_not(bitmap_from_string('1,2,3'),NULL));
++---------------------------------------------------------------------+
+| bitmap_to_string(bitmap_and_not(bitmap_from_string('1,2,3'), NULL)) |
++---------------------------------------------------------------------+
+| NULL |
++---------------------------------------------------------------------+
```
### keywords
diff --git
a/docs/zh-CN/docs/sql-manual/sql-functions/bitmap-functions/bitmap_empty.md
b/docs/zh-CN/docs/sql-manual/sql-functions/bitmap-functions/bitmap_empty.md
index b677f5ac11..f07e7343a2 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/bitmap-functions/bitmap_empty.md
+++ b/docs/zh-CN/docs/sql-manual/sql-functions/bitmap-functions/bitmap_empty.md
@@ -45,6 +45,13 @@ mysql> select bitmap_count(bitmap_empty());
+------------------------------+
| 0 |
+------------------------------+
+
+mysql> select bitmap_to_string(bitmap_empty());
++----------------------------------+
+| bitmap_to_string(bitmap_empty()) |
++----------------------------------+
+| |
++----------------------------------+
```
### keywords
diff --git
a/docs/zh-CN/docs/sql-manual/sql-functions/bitmap-functions/bitmap_has_all.md
b/docs/zh-CN/docs/sql-manual/sql-functions/bitmap-functions/bitmap_has_all.md
index c98f79313d..d38bfb4db5 100644
---
a/docs/zh-CN/docs/sql-manual/sql-functions/bitmap-functions/bitmap_has_all.md
+++
b/docs/zh-CN/docs/sql-manual/sql-functions/bitmap-functions/bitmap_has_all.md
@@ -36,19 +36,19 @@ under the License.
### example
```
-mysql> select bitmap_has_all(bitmap_from_string("0, 1, 2"),
bitmap_from_string("1, 2")) cnt;
-+------+
-| cnt |
-+------+
-| 1 |
-+------+
-
-mysql> select bitmap_has_all(bitmap_empty(), bitmap_from_string("1, 2")) cnt;
-+------+
-| cnt |
-+------+
-| 0 |
-+------+
+mysql> select bitmap_has_all(bitmap_from_string("0, 1, 2"),
bitmap_from_string("1, 2"));
++---------------------------------------------------------------------------+
+| bitmap_has_all(bitmap_from_string('0, 1, 2'), bitmap_from_string('1, 2')) |
++---------------------------------------------------------------------------+
+| 1 |
++---------------------------------------------------------------------------+
+
+mysql> select bitmap_has_all(bitmap_empty(), bitmap_from_string("1, 2"));
++------------------------------------------------------------+
+| bitmap_has_all(bitmap_empty(), bitmap_from_string('1, 2')) |
++------------------------------------------------------------+
+| 0 |
++------------------------------------------------------------+
```
### keywords
diff --git
a/docs/zh-CN/docs/sql-manual/sql-functions/bitmap-functions/bitmap_has_any.md
b/docs/zh-CN/docs/sql-manual/sql-functions/bitmap-functions/bitmap_has_any.md
index 858228ae31..b483d885db 100644
---
a/docs/zh-CN/docs/sql-manual/sql-functions/bitmap-functions/bitmap_has_any.md
+++
b/docs/zh-CN/docs/sql-manual/sql-functions/bitmap-functions/bitmap_has_any.md
@@ -35,19 +35,19 @@ under the License.
### example
```
-mysql> select bitmap_has_any(to_bitmap(1),to_bitmap(2)) cnt;
-+------+
-| cnt |
-+------+
-| 0 |
-+------+
-
-mysql> select bitmap_has_any(to_bitmap(1),to_bitmap(1)) cnt;
-+------+
-| cnt |
-+------+
-| 1 |
-+------+
+mysql> select bitmap_has_any(to_bitmap(1),to_bitmap(2));
++--------------------------------------------+
+| bitmap_has_any(to_bitmap(1), to_bitmap(2)) |
++--------------------------------------------+
+| 0 |
++--------------------------------------------+
+
+mysql> select bitmap_has_any(to_bitmap(1),to_bitmap(1));
++--------------------------------------------+
+| bitmap_has_any(to_bitmap(1), to_bitmap(1)) |
++--------------------------------------------+
+| 1 |
++--------------------------------------------+
```
### keywords
diff --git
a/docs/zh-CN/docs/sql-manual/sql-functions/bitmap-functions/bitmap_hash64.md
b/docs/zh-CN/docs/sql-manual/sql-functions/bitmap-functions/bitmap_hash64.md
index 38c6bf22b7..a0c4f5d103 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/bitmap-functions/bitmap_hash64.md
+++ b/docs/zh-CN/docs/sql-manual/sql-functions/bitmap-functions/bitmap_hash64.md
@@ -39,12 +39,12 @@ cat data | curl --location-trusted -u user:passwd -T - -H
"columns: dt,page,devi
### example
```
-mysql> select bitmap_count(bitmap_hash64('hello'));
-+------------------------------------+
-| bitmap_count(bitmap_hash64('hello')) |
-+------------------------------------+
-| 1 |
-+------------------------------------+
+mysql> select bitmap_to_string(bitmap_hash64('hello'));
++------------------------------------------+
+| bitmap_to_string(bitmap_hash64('hello')) |
++------------------------------------------+
+| 15231136565543391023 |
++------------------------------------------+
```
### keywords
diff --git
a/docs/zh-CN/docs/sql-manual/sql-functions/bitmap-functions/bitmap_not.md
b/docs/zh-CN/docs/sql-manual/sql-functions/bitmap-functions/bitmap_not.md
index d2e27f2a64..8c346939b8 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/bitmap-functions/bitmap_not.md
+++ b/docs/zh-CN/docs/sql-manual/sql-functions/bitmap-functions/bitmap_not.md
@@ -35,19 +35,19 @@ under the License.
### example
```
-mysql> select
bitmap_count(bitmap_not(bitmap_from_string('2,3'),bitmap_from_string('1,2,3,4')))
cnt;
-+------+
-| cnt |
-+------+
-| 0 |
-+------+
-
-mysql> select
bitmap_to_string(bitmap_not(bitmap_from_string('2,3,5'),bitmap_from_string('1,2,3,4')));
+mysql> select
bitmap_to_string(bitmap_not(bitmap_from_string('2,3'),bitmap_from_string('1,2,3,4')));
+----------------------------------------------------------------------------------------+
-| bitmap_to_string(bitmap_xor(bitmap_from_string('2,3,5'),
bitmap_from_string('1,2,3,4'))) |
+| bitmap_to_string(bitmap_not(bitmap_from_string('2,3'),
bitmap_from_string('1,2,3,4'))) |
+----------------------------------------------------------------------------------------+
-| 5
|
+|
|
+----------------------------------------------------------------------------------------+
+
+mysql> select
bitmap_to_string(bitmap_not(bitmap_from_string('2,3,5'),bitmap_from_string('1,2,3,4')));
++------------------------------------------------------------------------------------------+
+| bitmap_to_string(bitmap_not(bitmap_from_string('2,3,5'),
bitmap_from_string('1,2,3,4'))) |
++------------------------------------------------------------------------------------------+
+| 5
|
++------------------------------------------------------------------------------------------+
```
### keywords
diff --git
a/docs/zh-CN/docs/sql-manual/sql-functions/bitmap-functions/bitmap_or.md
b/docs/zh-CN/docs/sql-manual/sql-functions/bitmap-functions/bitmap_or.md
index 90c5f89590..811777fa8a 100644
--- a/docs/zh-CN/docs/sql-manual/sql-functions/bitmap-functions/bitmap_or.md
+++ b/docs/zh-CN/docs/sql-manual/sql-functions/bitmap-functions/bitmap_or.md
@@ -35,42 +35,49 @@ under the License.
### example
```
-mysql> select bitmap_count(bitmap_or(to_bitmap(1), to_bitmap(2))) cnt;
+mysql> select bitmap_count(bitmap_or(to_bitmap(1), to_bitmap(1))) cnt;
+------+
| cnt |
+------+
-| 2 |
+| 1 |
+------+
-mysql> select bitmap_count(bitmap_or(to_bitmap(1), to_bitmap(1))) cnt;
+mysql> select bitmap_to_string(bitmap_or(to_bitmap(1), to_bitmap(1))) ;
++---------------------------------------------------------+
+| bitmap_to_string(bitmap_or(to_bitmap(1), to_bitmap(1))) |
++---------------------------------------------------------+
+| 1 |
++---------------------------------------------------------+
+
+mysql> select bitmap_count(bitmap_or(to_bitmap(1), to_bitmap(2))) cnt;
+------+
| cnt |
+------+
-| 1 |
+| 2 |
+------+
-MySQL> select bitmap_to_string(bitmap_or(to_bitmap(1), to_bitmap(2)));
+mysql> select bitmap_to_string(bitmap_or(to_bitmap(1), to_bitmap(2)));
+---------------------------------------------------------+
| bitmap_to_string(bitmap_or(to_bitmap(1), to_bitmap(2))) |
+---------------------------------------------------------+
| 1,2 |
+---------------------------------------------------------+
-MySQL> select bitmap_to_string(bitmap_or(to_bitmap(1), to_bitmap(2),
to_bitmap(10), to_bitmap(0), NULL));
+mysql> select bitmap_to_string(bitmap_or(to_bitmap(1), to_bitmap(2),
to_bitmap(10), to_bitmap(0), NULL));
+--------------------------------------------------------------------------------------------+
| bitmap_to_string(bitmap_or(to_bitmap(1), to_bitmap(2), to_bitmap(10),
to_bitmap(0), NULL)) |
+--------------------------------------------------------------------------------------------+
-| NULL
|
+| 0,1,2,10
|
+--------------------------------------------------------------------------------------------+
-MySQL> select bitmap_to_string(bitmap_or(to_bitmap(1), to_bitmap(2),
to_bitmap(10), to_bitmap(0), bitmap_empty()));
+mysql> select bitmap_to_string(bitmap_or(to_bitmap(1), to_bitmap(2),
to_bitmap(10), to_bitmap(0), bitmap_empty()));
+------------------------------------------------------------------------------------------------------+
| bitmap_to_string(bitmap_or(to_bitmap(1), to_bitmap(2), to_bitmap(10),
to_bitmap(0), bitmap_empty())) |
+------------------------------------------------------------------------------------------------------+
| 0,1,2,10
|
+------------------------------------------------------------------------------------------------------+
-MySQL> select bitmap_to_string(bitmap_or(to_bitmap(10),
bitmap_from_string('1,2'), bitmap_from_string('1,2,3,4,5')));
+mysql> select bitmap_to_string(bitmap_or(to_bitmap(10),
bitmap_from_string('1,2'), bitmap_from_string('1,2,3,4,5')));
+--------------------------------------------------------------------------------------------------------+
| bitmap_to_string(bitmap_or(to_bitmap(10), bitmap_from_string('1,2'),
bitmap_from_string('1,2,3,4,5'))) |
+--------------------------------------------------------------------------------------------------------+
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
