This is an automated email from the ASF dual-hosted git repository.
morningman 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 f2d0e9cc8aa0 [docs] Align EXPORT_SET example projection with its
output (#4614)
f2d0e9cc8aa0 is described below
commit f2d0e9cc8aa05c39afa793d833b0f2bb1c8fc547
Author: Mingyu Chen (Rayner) <[email protected]>
AuthorDate: Fri Nov 13 08:01:59 2026 +0800
[docs] Align EXPORT_SET example projection with its output (#4614)
Select the five input columns together with `EXPORT_SET(...) AS ans`,
matching the six displayed output columns. Expose the existing setup SQL
so readers can create the example table before running the query.
Fixes #3879
Versions and languages: dev and 4.x, English and Chinese; 3.x has no
EXPORT_SET page.
Source verification:
- Doris branch-4.0 and master test_string_function.groovy define the
same 13 input rows and evaluate the same EXPORT_SET overload
- The current example output has five input columns and ans, whereas its
SQL projects only one expression
Validation:
- Checked all four copies contain identical corrected SQL
- Verified existing setup data is preserved and now visible
- Checked function call against branch-4.0 and master regression source
- git diff --check
Review:
- Goal: correct the reported documentation issue; the changed content
directly addresses it.
- Scope: targeted documentation edits.
- Information architecture: active version and locale counterparts
inspected; archived snapshots unchanged.
- Navigation: no paths, slugs, anchors or sidebar entries changed.
- Frontend/build: no framework, styling or build-script changes.
- Validation limits: no live Doris execution or full website build
performed.
- Other concerns: No additional correctness, usability, accessibility,
SEO or maintainability issues found in the changed content.
Co-authored-by: morningman <[email protected]>
---
.../sql-functions/scalar-functions/string-functions/export-set.md | 7 ++++---
.../sql-functions/scalar-functions/string-functions/export-set.md | 7 ++++---
.../sql-functions/scalar-functions/string-functions/export-set.md | 7 ++++---
.../sql-functions/scalar-functions/string-functions/export-set.md | 7 ++++---
4 files changed, 16 insertions(+), 12 deletions(-)
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/export-set.md
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/export-set.md
index 66dd38d4329f..a9e48a5d5e7f 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/export-set.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/export-set.md
@@ -37,10 +37,10 @@ Returns a string. For each bit in `bits`, from the least
significant bit to the
If `number_of_bits` is out of range [-2^31, 2^31 - 1] or any parameter in the
function is NULL, return NULL.
## Example
-<!-- setup-sql
+```sql
CREATE TABLE test_export_set (`bits` BIGINT, `on` VARCHAR(20), `off`
VARCHAR(20), `sep` VARCHAR(20), `num_of_b` INT) DISTRIBUTED BY HASH(`bits`)
BUCKETS 1 PROPERTIES("replication_num"="1");
INSERT INTO test_export_set VALUES
(-1,'1','0',',',50),(-2,'1','0','',64),(5,'Y','N',',',5),(5,'1','0','',64),(5,'','0','',65),(6,'1','','',63),(19284249819,'1','0',',',64),(9,'apache','doris','|123|',64),(NULL,'1','0',',',5),(5,NULL,'0','',5),(5,'1',NULL,',',10),(5,'1','0',NULL,10),(5,'1','0',',',NULL);
--->
+```
```sql
SELECT EXPORT_SET(-2, '1', '0');
@@ -89,7 +89,8 @@ FROM `test_export_set`;
```
```sql
-SELECT EXPORT_SET(`bits`, `on`, `off`, `sep`, `num_of_b`)
+SELECT `bits`, `on`, `off`, `sep`, `num_of_b`,
+ EXPORT_SET(`bits`, `on`, `off`, `sep`, `num_of_b`) AS ans
FROM `test_export_set`;
```
```text
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/export-set.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/export-set.md
index 2adb4a3d1326..9fc00572f385 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/export-set.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/export-set.md
@@ -39,10 +39,10 @@ EXPORT_SET(bits, on, off[, separator[, number_of_bits]])
## 举例
-<!-- setup-sql
+```sql
CREATE TABLE test_export_set (`bits` BIGINT, `on` VARCHAR(20), `off`
VARCHAR(20), `sep` VARCHAR(20), `num_of_b` INT) DISTRIBUTED BY HASH(`bits`)
BUCKETS 1 PROPERTIES("replication_num"="1");
INSERT INTO test_export_set VALUES
(-1,'1','0',',',50),(-2,'1','0','',64),(5,'Y','N',',',5),(5,'1','0','',64),(5,'','0','',65),(6,'1','','',63),(19284249819,'1','0',',',64),(9,'apache','doris','|123|',64),(NULL,'1','0',',',5),(5,NULL,'0','',5),(5,'1',NULL,',',10),(5,'1','0',NULL,10),(5,'1','0',',',NULL);
--->
+```
```sql
SELECT EXPORT_SET(-2, '1', '0');
@@ -91,7 +91,8 @@ FROM `test_export_set`;
```
```sql
-SELECT EXPORT_SET(`bits`, `on`, `off`, `sep`, `num_of_b`)
+SELECT `bits`, `on`, `off`, `sep`, `num_of_b`,
+ EXPORT_SET(`bits`, `on`, `off`, `sep`, `num_of_b`) AS ans
FROM `test_export_set`;
```
```text
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/export-set.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/export-set.md
index 2adb4a3d1326..9fc00572f385 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/export-set.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/export-set.md
@@ -39,10 +39,10 @@ EXPORT_SET(bits, on, off[, separator[, number_of_bits]])
## 举例
-<!-- setup-sql
+```sql
CREATE TABLE test_export_set (`bits` BIGINT, `on` VARCHAR(20), `off`
VARCHAR(20), `sep` VARCHAR(20), `num_of_b` INT) DISTRIBUTED BY HASH(`bits`)
BUCKETS 1 PROPERTIES("replication_num"="1");
INSERT INTO test_export_set VALUES
(-1,'1','0',',',50),(-2,'1','0','',64),(5,'Y','N',',',5),(5,'1','0','',64),(5,'','0','',65),(6,'1','','',63),(19284249819,'1','0',',',64),(9,'apache','doris','|123|',64),(NULL,'1','0',',',5),(5,NULL,'0','',5),(5,'1',NULL,',',10),(5,'1','0',NULL,10),(5,'1','0',',',NULL);
--->
+```
```sql
SELECT EXPORT_SET(-2, '1', '0');
@@ -91,7 +91,8 @@ FROM `test_export_set`;
```
```sql
-SELECT EXPORT_SET(`bits`, `on`, `off`, `sep`, `num_of_b`)
+SELECT `bits`, `on`, `off`, `sep`, `num_of_b`,
+ EXPORT_SET(`bits`, `on`, `off`, `sep`, `num_of_b`) AS ans
FROM `test_export_set`;
```
```text
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/export-set.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/export-set.md
index 66dd38d4329f..a9e48a5d5e7f 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/export-set.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/string-functions/export-set.md
@@ -37,10 +37,10 @@ Returns a string. For each bit in `bits`, from the least
significant bit to the
If `number_of_bits` is out of range [-2^31, 2^31 - 1] or any parameter in the
function is NULL, return NULL.
## Example
-<!-- setup-sql
+```sql
CREATE TABLE test_export_set (`bits` BIGINT, `on` VARCHAR(20), `off`
VARCHAR(20), `sep` VARCHAR(20), `num_of_b` INT) DISTRIBUTED BY HASH(`bits`)
BUCKETS 1 PROPERTIES("replication_num"="1");
INSERT INTO test_export_set VALUES
(-1,'1','0',',',50),(-2,'1','0','',64),(5,'Y','N',',',5),(5,'1','0','',64),(5,'','0','',65),(6,'1','','',63),(19284249819,'1','0',',',64),(9,'apache','doris','|123|',64),(NULL,'1','0',',',5),(5,NULL,'0','',5),(5,'1',NULL,',',10),(5,'1','0',NULL,10),(5,'1','0',',',NULL);
--->
+```
```sql
SELECT EXPORT_SET(-2, '1', '0');
@@ -89,7 +89,8 @@ FROM `test_export_set`;
```
```sql
-SELECT EXPORT_SET(`bits`, `on`, `off`, `sep`, `num_of_b`)
+SELECT `bits`, `on`, `off`, `sep`, `num_of_b`,
+ EXPORT_SET(`bits`, `on`, `off`, `sep`, `num_of_b`) AS ans
FROM `test_export_set`;
```
```text
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
