[doc](sql-functions) Fix GROUP_ARRAY_INTERSECT example SQL in 3.x (#4552) ### What problem does this PR solve? Issue Number: close #3886 In the English and Chinese `3.x` documentation for `GROUP_ARRAY_INTERSECT`, the first example selects `c_array_string` with `id IN (18, 20)`, but the displayed result contains columns `id | col` and rows with IDs `1`, `2`, and `3`. The next query also uses `col`. Change the first query to `select id, col from group_array_intersect_test;` so it matches the displayed result and the following aggregation query. The branch has been rebased onto the latest `master`. The English and Chinese `dev` (`current`) and `4.x` pages were checked: they already define and consistently use `c_array_string` in self-contained examples, so they do not need this fix. The original `2.1` changes have been omitted because those pages are now frozen source snapshots under `archived_docs/`. ## Versions - [ ] dev (checked; already consistent) - [ ] 4.x (checked; already consistent) - [x] 3.x - [ ] 2.1 or older (archived snapshots unchanged) ## Languages - [x] Chinese - [x] English ## Validation - `git diff --check` passed. - Targeted front matter and Markdown structure checks passed for all six English/Chinese pages across dev, 4.x, and 3.x. - Language/version sync checks found no errors or warnings. The informational reminder to check current docs was addressed by inspecting the dev and 4.x examples. - The repository's local Markdown link check passed. - SQL examples were checked for column consistency and English/Chinese parity. SQL was not executed against a Doris cluster. ## Docs Checklist - [x] Checked by AI - [ ] Test Cases Built - [x] Updated required version and language counterparts, or explained why not - [x] If only one language changed, confirmed whether source/translation counterparts need sync
diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/aggregate-functions/group-array-intersect.md b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/aggregate-functions/group-array-intersect.md index e8adb06..f994ce1 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/aggregate-functions/group-array-intersect.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/aggregate-functions/group-array-intersect.md
@@ -29,7 +29,7 @@ ## 举例 ```sql -select c_array_string from group_array_intersect_test where id in (18, 20); +select id, col from group_array_intersect_test; ``` ```text
diff --git a/versioned_docs/version-3.x/sql-manual/sql-functions/aggregate-functions/group-array-intersect.md b/versioned_docs/version-3.x/sql-manual/sql-functions/aggregate-functions/group-array-intersect.md index fda13a1..4735e0b 100644 --- a/versioned_docs/version-3.x/sql-manual/sql-functions/aggregate-functions/group-array-intersect.md +++ b/versioned_docs/version-3.x/sql-manual/sql-functions/aggregate-functions/group-array-intersect.md
@@ -29,7 +29,7 @@ ## Example ```sql -select c_array_string from group_array_intersect_test where id in (18, 20); +select id, col from group_array_intersect_test; ``` ```text