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 8c4b097eff3 [fix](doc) correct AGG_STATE example and workload-group
sql fence rendering (#3747)
8c4b097eff3 is described below
commit 8c4b097eff3316d3670c23d42607a01755121482
Author: boluor <[email protected]>
AuthorDate: Sat May 23 05:24:22 2026 -0700
[fix](doc) correct AGG_STATE example and workload-group sql fence rendering
(#3747)
## Summary
Two long-open doc bugs fixed in one PR.
### 1. AGG_STATE example uses combinators on a non-agg_state column
(#2929)
`table-design/data-model/aggregate.md` declares the example table with
`v1 int SUM`, `v2 agg_state<group_concat(string)>`. The page then
incorrectly calls `sum_union(v1)` (union-insert) and `sum_merge(v1)`
(result query) — but `v1` is a plain aggregate-key column, not
`agg_state<sum(int)>`. `MergeCombinator` and `UnionCombinator` in
`fe/fe-core/src/main/java/org/apache/doris/nereids/trees/expressions/functions/combinator/`
cast their argument to `AggStateType`, so the example as written fails
at analysis time.
Replace with plain `sum(v1)` across the union-insert and the two result
queries. Numeric output (`20` / `16`) is unchanged and matches what the
doc already claims. `group_concat_merge(v2)` / `group_concat_union(v2)`
on `v2` remain correct because `v2` is genuinely declared as
`agg_state`.
Result tables re-flowed to mysql-CLI-correct column widths.
### 2. workload-group "View Schema" SQL block renders as literal text
(#2497)
`admin-manual/workload-management/workload-group.md` had a
4-space-indented `\`\`\`sql DESC FUNCTION s3 (...) \`\`\`` block sitting
directly after a plain paragraph (no parent list item). CommonMark
treats 4-space indent as an indented code block, so the inner fence
markers render as literal text on the rendered page — exactly what the
reporter's screenshot shows.
De-indent the block to column 0. `current` and `version-4.x` already
carry this fix; backport to `version-2.1` and `version-3.x` EN + zh.
## Scope
| Fix | Files |
|---|---|
| AGG_STATE — `sum_merge`/`sum_union(v1)` → `sum(v1)` | `aggregate.md` ×
8 (current/2.1/3.x/4.x EN+zh) |
| workload-group — de-indent DESC FUNCTION block | `workload-group.md` ×
4 (2.1/3.x EN+zh) |
## Test plan
- [x] Dead-link check passes
- [x] Result tables align in monospace
- [x] No remaining `sum_merge(v1)` / `sum_union(v1)` in aggregate.md
Closes #2497
Closes #2929
---
docs/table-design/data-model/aggregate.md | 28 +++++++++++-----------
.../current/table-design/data-model/aggregate.md | 28 +++++++++++-----------
.../workload-management/workload-group.md | 19 +++++++--------
.../table-design/data-model/aggregate.md | 26 ++++++++++----------
.../workload-management/workload-group.md | 19 +++++++--------
.../table-design/data-model/aggregate.md | 28 +++++++++++-----------
.../table-design/data-model/aggregate.md | 28 +++++++++++-----------
.../workload-management/workload-group.md | 18 +++++++-------
.../table-design/data-model/aggregate.md | 28 +++++++++++-----------
.../workload-management/workload-group.md | 18 +++++++-------
.../table-design/data-model/aggregate.md | 28 +++++++++++-----------
.../table-design/data-model/aggregate.md | 28 +++++++++++-----------
12 files changed, 147 insertions(+), 149 deletions(-)
diff --git a/docs/table-design/data-model/aggregate.md
b/docs/table-design/data-model/aggregate.md
index 8fa6c29fdcf..5b68d136b68 100644
--- a/docs/table-design/data-model/aggregate.md
+++ b/docs/table-design/data-model/aggregate.md
@@ -161,7 +161,7 @@ If you do not need the final aggregated result and instead
want to retain the in
```sql
INSERT INTO aggstate
-SELECT 3, sum_union(v1), group_concat_union(v2) FROM aggstate;
+SELECT 3, sum(v1), group_concat_union(v2) FROM aggstate;
```
The computation in the table at this point is shown in the following figure:
@@ -171,17 +171,17 @@ The computation in the table at this point is shown in
the following figure:
The query results are as follows:
```sql
-mysql> SELECT sum_merge(v1), group_concat_merge(v2) FROM aggstate;
-+---------------+------------------------+
-| sum_merge(v1) | group_concat_merge(v2) |
-+---------------+------------------------+
-| 20 | c,b,a,d,c,b,a,d |
-+---------------+------------------------+
-
-mysql> SELECT sum_merge(v1), group_concat_merge(v2) FROM aggstate WHERE k1 !=
2;
-+---------------+------------------------+
-| sum_merge(v1) | group_concat_merge(v2) |
-+---------------+------------------------+
-| 16 | c,b,a,d,c,b,a |
-+---------------+------------------------+
+mysql> SELECT sum(v1), group_concat_merge(v2) FROM aggstate;
++---------+------------------------+
+| sum(v1) | group_concat_merge(v2) |
++---------+------------------------+
+| 20 | c,b,a,d,c,b,a,d |
++---------+------------------------+
+
+mysql> SELECT sum(v1), group_concat_merge(v2) FROM aggstate WHERE k1 != 2;
++---------+------------------------+
+| sum(v1) | group_concat_merge(v2) |
++---------+------------------------+
+| 16 | c,b,a,d,c,b,a |
++---------+------------------------+
```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/table-design/data-model/aggregate.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/table-design/data-model/aggregate.md
index 736bf1251c3..42de20f8d52 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/table-design/data-model/aggregate.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/table-design/data-model/aggregate.md
@@ -161,7 +161,7 @@ SELECT group_concat_merge(v2) FROM aggstate;
```sql
INSERT INTO aggstate
-SELECT 3, sum_union(v1), group_concat_union(v2) FROM aggstate;
+SELECT 3, sum(v1), group_concat_union(v2) FROM aggstate;
```
此时表内计算方式如下图所示：
@@ -171,17 +171,17 @@ SELECT 3, sum_union(v1), group_concat_union(v2) FROM
aggstate;
查询结果如下：
```sql
-mysql> SELECT sum_merge(v1), group_concat_merge(v2) FROM aggstate;
-+---------------+------------------------+
-| sum_merge(v1) | group_concat_merge(v2) |
-+---------------+------------------------+
-| 20 | c,b,a,d,c,b,a,d |
-+---------------+------------------------+
-
-mysql> SELECT sum_merge(v1), group_concat_merge(v2) FROM aggstate WHERE k1 !=
2;
-+---------------+------------------------+
-| sum_merge(v1) | group_concat_merge(v2) |
-+---------------+------------------------+
-| 16 | c,b,a,d,c,b,a |
-+---------------+------------------------+
+mysql> SELECT sum(v1), group_concat_merge(v2) FROM aggstate;
++---------+------------------------+
+| sum(v1) | group_concat_merge(v2) |
++---------+------------------------+
+| 20 | c,b,a,d,c,b,a,d |
++---------+------------------------+
+
+mysql> SELECT sum(v1), group_concat_merge(v2) FROM aggstate WHERE k1 != 2;
++---------+------------------------+
+| sum(v1) | group_concat_merge(v2) |
++---------+------------------------+
+| 16 | c,b,a,d,c,b,a |
++---------+------------------------+
```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/admin-manual/workload-management/workload-group.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/admin-manual/workload-management/workload-group.md
index 74e2d0defbf..513914b7d42 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/admin-manual/workload-management/workload-group.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/admin-manual/workload-management/workload-group.md
@@ -573,16 +573,15 @@ BrokerLoad 和 S3Load 是常用的大批量数据导入方式，用户可以把
上传成功后可以使用命令查看 Schema 信息。
- ```sql
- // 查看schema
- DESC FUNCTION s3 (
- "URI" = "https://bucketname/1kw.tsv";,
- "s3.access_key"= "ak",
- "s3.secret_key" = "sk",
- "format" = "csv",
- "use_path_style"="true"
- );
- ```
+```sql
+DESC FUNCTION s3 (
+ "URI" = "https://bucketname/1kw.tsv";,
+ "s3.access_key" = "ak",
+ "s3.secret_key" = "sk",
+ "format" = "csv",
+ "use_path_style" = "true"
+);
+```
**测试不限制远程读的 IO**
1. 发起单并发测试，全表扫描 clickbench 表。
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/table-design/data-model/aggregate.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/table-design/data-model/aggregate.md
index f0ce70dd330..1512d9adf51 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/table-design/data-model/aggregate.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/table-design/data-model/aggregate.md
@@ -161,18 +161,18 @@ select sum(v1), group_concat_merge(v2) from aggstate
where k1 != 2;
查询结果如下：
```sql
-mysql> select sum_merge(v1) , group_concat_merge(v2)from aggstate;
-+---------------+------------------------+
-| sum_merge(v1) | group_concat_merge(v2) |
-+---------------+------------------------+
-| 20 | c,b,a,d,c,b,a,d |
-+---------------+------------------------+
-
-mysql> select sum_merge(v1) , group_concat_merge(v2)from aggstate where k1 !=
2;
-+---------------+------------------------+
-| sum_merge(v1) | group_concat_merge(v2) |
-+---------------+------------------------+
-| 16 | c,b,a,d,c,b,a |
-+---------------+------------------------+
+mysql> select sum(v1), group_concat_merge(v2) from aggstate;
++---------+------------------------+
+| sum(v1) | group_concat_merge(v2) |
++---------+------------------------+
+| 20 | c,b,a,d,c,b,a,d |
++---------+------------------------+
+
+mysql> select sum(v1), group_concat_merge(v2) from aggstate where k1 != 2;
++---------+------------------------+
+| sum(v1) | group_concat_merge(v2) |
++---------+------------------------+
+| 16 | c,b,a,d,c,b,a |
++---------+------------------------+
```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/admin-manual/workload-management/workload-group.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/admin-manual/workload-management/workload-group.md
index 741de5b8421..21ee30276c5 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/admin-manual/workload-management/workload-group.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/admin-manual/workload-management/workload-group.md
@@ -573,16 +573,15 @@ BrokerLoad 和 S3Load 是常用的大批量数据导入方式，用户可以把
上传成功后可以使用命令查看 Schema 信息。
- ```sql
- // 查看schema
- DESC FUNCTION s3 (
- "URI" = "https://bucketname/1kw.tsv";,
- "s3.access_key"= "ak",
- "s3.secret_key" = "sk",
- "format" = "csv",
- "use_path_style"="true"
- );
- ```
+```sql
+DESC FUNCTION s3 (
+ "URI" = "https://bucketname/1kw.tsv";,
+ "s3.access_key" = "ak",
+ "s3.secret_key" = "sk",
+ "format" = "csv",
+ "use_path_style" = "true"
+);
+```
**测试不限制远程读的 IO**
1. 发起单并发测试，全表扫描 clickbench 表。
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/table-design/data-model/aggregate.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/table-design/data-model/aggregate.md
index af0fe0bbe2c..7e417e67ff8 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/table-design/data-model/aggregate.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/table-design/data-model/aggregate.md
@@ -148,7 +148,7 @@ select group_concat_merge(v2) from aggstate;
如果不想要最终的聚合结果，而希望保留中间结果，可以使用 `union` 操作：
```sql
-insert into aggstate select 3,sum_union(v1),group_concat_union(v2) from
aggstate;
+insert into aggstate select 3, sum(v1), group_concat_union(v2) from aggstate;
```
此时表中计算如下：
@@ -158,17 +158,17 @@ insert into aggstate select
3,sum_union(v1),group_concat_union(v2) from aggstate
查询结果如下：
```sql
-mysql> select sum_merge(v1) , group_concat_merge(v2)from aggstate;
-+---------------+------------------------+
-| sum_merge(v1) | group_concat_merge(v2) |
-+---------------+------------------------+
-| 20 | c,b,a,d,c,b,a,d |
-+---------------+------------------------+
-
-mysql> select sum_merge(v1) , group_concat_merge(v2)from aggstate where k1 !=
2;
-+---------------+------------------------+
-| sum_merge(v1) | group_concat_merge(v2) |
-+---------------+------------------------+
-| 16 | c,b,a,d,c,b,a |
-+---------------+------------------------+
+mysql> select sum(v1), group_concat_merge(v2) from aggstate;
++---------+------------------------+
+| sum(v1) | group_concat_merge(v2) |
++---------+------------------------+
+| 20 | c,b,a,d,c,b,a,d |
++---------+------------------------+
+
+mysql> select sum(v1), group_concat_merge(v2) from aggstate where k1 != 2;
++---------+------------------------+
+| sum(v1) | group_concat_merge(v2) |
++---------+------------------------+
+| 16 | c,b,a,d,c,b,a |
++---------+------------------------+
```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/table-design/data-model/aggregate.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/table-design/data-model/aggregate.md
index 736bf1251c3..42de20f8d52 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/table-design/data-model/aggregate.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/table-design/data-model/aggregate.md
@@ -161,7 +161,7 @@ SELECT group_concat_merge(v2) FROM aggstate;
```sql
INSERT INTO aggstate
-SELECT 3, sum_union(v1), group_concat_union(v2) FROM aggstate;
+SELECT 3, sum(v1), group_concat_union(v2) FROM aggstate;
```
此时表内计算方式如下图所示：
@@ -171,17 +171,17 @@ SELECT 3, sum_union(v1), group_concat_union(v2) FROM
aggstate;
查询结果如下：
```sql
-mysql> SELECT sum_merge(v1), group_concat_merge(v2) FROM aggstate;
-+---------------+------------------------+
-| sum_merge(v1) | group_concat_merge(v2) |
-+---------------+------------------------+
-| 20 | c,b,a,d,c,b,a,d |
-+---------------+------------------------+
-
-mysql> SELECT sum_merge(v1), group_concat_merge(v2) FROM aggstate WHERE k1 !=
2;
-+---------------+------------------------+
-| sum_merge(v1) | group_concat_merge(v2) |
-+---------------+------------------------+
-| 16 | c,b,a,d,c,b,a |
-+---------------+------------------------+
+mysql> SELECT sum(v1), group_concat_merge(v2) FROM aggstate;
++---------+------------------------+
+| sum(v1) | group_concat_merge(v2) |
++---------+------------------------+
+| 20 | c,b,a,d,c,b,a,d |
++---------+------------------------+
+
+mysql> SELECT sum(v1), group_concat_merge(v2) FROM aggstate WHERE k1 != 2;
++---------+------------------------+
+| sum(v1) | group_concat_merge(v2) |
++---------+------------------------+
+| 16 | c,b,a,d,c,b,a |
++---------+------------------------+
```
diff --git
a/versioned_docs/version-2.1/admin-manual/workload-management/workload-group.md
b/versioned_docs/version-2.1/admin-manual/workload-management/workload-group.md
index 14a0e51c629..62d6d622a57 100644
---
a/versioned_docs/version-2.1/admin-manual/workload-management/workload-group.md
+++
b/versioned_docs/version-2.1/admin-manual/workload-management/workload-group.md
@@ -586,15 +586,15 @@ To mitigate the impact on other workloads, the Workload
Group's remote IO limit
After the upload is successful, you can use the command to view the schema
information.
- ```sql
- DESC FUNCTION s3 (
- "URI" = "https://bucketname/1kw.tsv";,
- "s3.access_key"= "ak",
- "s3.secret_key" = "sk",
- "format" = "csv",
- "use_path_style"="true"
- );
- ```
+```sql
+DESC FUNCTION s3 (
+ "URI" = "https://bucketname/1kw.tsv";,
+ "s3.access_key" = "ak",
+ "s3.secret_key" = "sk",
+ "format" = "csv",
+ "use_path_style" = "true"
+);
+```
**Test without restricting remote read IO**
1. Initiate a single-threaded test to perform a full table scan on the
clickbench table.
diff --git a/versioned_docs/version-2.1/table-design/data-model/aggregate.md
b/versioned_docs/version-2.1/table-design/data-model/aggregate.md
index 6423133d4e9..f8e4784261d 100644
--- a/versioned_docs/version-2.1/table-design/data-model/aggregate.md
+++ b/versioned_docs/version-2.1/table-design/data-model/aggregate.md
@@ -161,7 +161,7 @@ select group_concat_merge(v2) from aggstate;
If you do not want the final aggregation result, you can use `union` to
combine multiple intermediate aggregation results and generate a new
intermediate result.
```sql
-insert into aggstate select 3,sum_union(v1),group_concat_union(v2) from
aggstate;
+insert into aggstate select 3, sum(v1), group_concat_union(v2) from aggstate;
```
The calculations in the table are as follows:
@@ -171,18 +171,18 @@ The calculations in the table are as follows:
The query result is as follows:
```sql
-mysql> select sum_merge(v1) , group_concat_merge(v2)from aggstate;
-+---------------+------------------------+
-| sum_merge(v1) | group_concat_merge(v2) |
-+---------------+------------------------+
-| 20 | c,b,a,d,c,b,a,d |
-+---------------+------------------------+
-
-mysql> select sum_merge(v1) , group_concat_merge(v2)from aggstate where k1 !=
2;
-+---------------+------------------------+
-| sum_merge(v1) | group_concat_merge(v2) |
-+---------------+------------------------+
-| 16 | c,b,a,d,c,b,a |
-+---------------+------------------------+
+mysql> select sum(v1), group_concat_merge(v2) from aggstate;
++---------+------------------------+
+| sum(v1) | group_concat_merge(v2) |
++---------+------------------------+
+| 20 | c,b,a,d,c,b,a,d |
++---------+------------------------+
+
+mysql> select sum(v1), group_concat_merge(v2) from aggstate where k1 != 2;
++---------+------------------------+
+| sum(v1) | group_concat_merge(v2) |
++---------+------------------------+
+| 16 | c,b,a,d,c,b,a |
++---------+------------------------+
```
diff --git
a/versioned_docs/version-3.x/admin-manual/workload-management/workload-group.md
b/versioned_docs/version-3.x/admin-manual/workload-management/workload-group.md
index 0b713ae1f20..26ccb96f0ae 100644
---
a/versioned_docs/version-3.x/admin-manual/workload-management/workload-group.md
+++
b/versioned_docs/version-3.x/admin-manual/workload-management/workload-group.md
@@ -586,15 +586,15 @@ To mitigate the impact on other workloads, the Workload
Group's remote IO limit
After the upload is successful, you can use the command to view the schema
information.
- ```sql
- DESC FUNCTION s3 (
- "URI" = "https://bucketname/1kw.tsv";,
- "s3.access_key"= "ak",
- "s3.secret_key" = "sk",
- "format" = "csv",
- "use_path_style"="true"
- );
- ```
+```sql
+DESC FUNCTION s3 (
+ "URI" = "https://bucketname/1kw.tsv";,
+ "s3.access_key" = "ak",
+ "s3.secret_key" = "sk",
+ "format" = "csv",
+ "use_path_style" = "true"
+);
+```
**Test without restricting remote read IO**
1. Initiate a single-threaded test to perform a full table scan on the
clickbench table.
diff --git a/versioned_docs/version-3.x/table-design/data-model/aggregate.md
b/versioned_docs/version-3.x/table-design/data-model/aggregate.md
index 07326304075..ecb4b3f502f 100644
--- a/versioned_docs/version-3.x/table-design/data-model/aggregate.md
+++ b/versioned_docs/version-3.x/table-design/data-model/aggregate.md
@@ -160,7 +160,7 @@ select group_concat_merge(v2) from aggstate;
If you do not want the final aggregation result, you can use `union` to
combine multiple intermediate aggregation results and generate a new
intermediate result.
```sql
-insert into aggstate select 3,sum_union(v1),group_concat_union(v2) from
aggstate;
+insert into aggstate select 3, sum(v1), group_concat_union(v2) from aggstate;
```
The calculations in the table are as follows:
@@ -170,17 +170,17 @@ The calculations in the table are as follows:
The query result is as follows:
```sql
-mysql> select sum_merge(v1) , group_concat_merge(v2)from aggstate;
-+---------------+------------------------+
-| sum_merge(v1) | group_concat_merge(v2) |
-+---------------+------------------------+
-| 20 | c,b,a,d,c,b,a,d |
-+---------------+------------------------+
-
-mysql> select sum_merge(v1) , group_concat_merge(v2)from aggstate where k1 !=
2;
-+---------------+------------------------+
-| sum_merge(v1) | group_concat_merge(v2) |
-+---------------+------------------------+
-| 16 | c,b,a,d,c,b,a |
-+---------------+------------------------+
+mysql> select sum(v1), group_concat_merge(v2) from aggstate;
++---------+------------------------+
+| sum(v1) | group_concat_merge(v2) |
++---------+------------------------+
+| 20 | c,b,a,d,c,b,a,d |
++---------+------------------------+
+
+mysql> select sum(v1), group_concat_merge(v2) from aggstate where k1 != 2;
++---------+------------------------+
+| sum(v1) | group_concat_merge(v2) |
++---------+------------------------+
+| 16 | c,b,a,d,c,b,a |
++---------+------------------------+
```
diff --git a/versioned_docs/version-4.x/table-design/data-model/aggregate.md
b/versioned_docs/version-4.x/table-design/data-model/aggregate.md
index 8fa6c29fdcf..5b68d136b68 100644
--- a/versioned_docs/version-4.x/table-design/data-model/aggregate.md
+++ b/versioned_docs/version-4.x/table-design/data-model/aggregate.md
@@ -161,7 +161,7 @@ If you do not need the final aggregated result and instead
want to retain the in
```sql
INSERT INTO aggstate
-SELECT 3, sum_union(v1), group_concat_union(v2) FROM aggstate;
+SELECT 3, sum(v1), group_concat_union(v2) FROM aggstate;
```
The computation in the table at this point is shown in the following figure:
@@ -171,17 +171,17 @@ The computation in the table at this point is shown in
the following figure:
The query results are as follows:
```sql
-mysql> SELECT sum_merge(v1), group_concat_merge(v2) FROM aggstate;
-+---------------+------------------------+
-| sum_merge(v1) | group_concat_merge(v2) |
-+---------------+------------------------+
-| 20 | c,b,a,d,c,b,a,d |
-+---------------+------------------------+
-
-mysql> SELECT sum_merge(v1), group_concat_merge(v2) FROM aggstate WHERE k1 !=
2;
-+---------------+------------------------+
-| sum_merge(v1) | group_concat_merge(v2) |
-+---------------+------------------------+
-| 16 | c,b,a,d,c,b,a |
-+---------------+------------------------+
+mysql> SELECT sum(v1), group_concat_merge(v2) FROM aggstate;
++---------+------------------------+
+| sum(v1) | group_concat_merge(v2) |
++---------+------------------------+
+| 20 | c,b,a,d,c,b,a,d |
++---------+------------------------+
+
+mysql> SELECT sum(v1), group_concat_merge(v2) FROM aggstate WHERE k1 != 2;
++---------+------------------------+
+| sum(v1) | group_concat_merge(v2) |
++---------+------------------------+
+| 16 | c,b,a,d,c,b,a |
++---------+------------------------+
```
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
