boluor opened a new pull request, #3822: URL: https://github.com/apache/doris-website/pull/3822
## Summary Four pages on the 4.x doc referenced tables their example sections never created. A fresh-cluster copy-paste of the example failed with \"Table ... does not exist\". This PR adds a small \`CREATE TABLE + INSERT\` block scoped to each page's example needs, and updates the expected output where the new setup produces a different (but representative) value. Each change is mirrored on both the EN and ZH version of the page. | File | What was missing | What this PR adds | |------|------------------|-------------------| | \`bitmap-functions/bitmap-hash.md\` | \`words\` table | 4-distinct-value sample table; expected \`bitmap_count\` updated from \`33263478\` (an unreproducible illustration) to \`4\`, with a prose note that production-scale data can return much larger numbers | | \`encrypt-digest-functions/sha2.md\` | \`str(k0 VARCHAR, k1 INT)\` table | tiny setup so the two \"second-arg-must-be-literal\" error examples actually run and produce the documented error string. Also adds a one-sentence \"illustrative\" note in front of the two \`mysql_catalog.binary_test.binary_test\` examples — they need an external MySQL catalog most clusters do not have configured | | \`array-functions/arrays-overlap.md\` | proper expected-error block for the nested-arrays example | the existing leading \`--\` prose comment is replaced with the actual 4.1.1 error string under the SELECT, mirroring the format the rest of the page already uses | | \`sql-statements/table-and-view/table/DESC-TABLE.md\` | \`test_table\` itself | adds the CREATE block (user_id BIGINT, name VARCHAR, age INT, with column comments). Both \`DESC test_table\` examples and the \`SET show_column_comment_in_describe\` variant now reproduce the documented result blocks byte-for-byte | ## Verification Every added setup + example was run end-to-end on a single-node Apache Doris 4.1.1 cluster; the result/error blocks in this PR are the verbatim mysql client output. ## Note on a sibling page excluded \`grouping-id.md\` was triaged together with these but is **not** included. Its Example A uses \`ORDER BY GROUPING_ID(department, level) ASC\`, which 4.1.1 rejects with \`LOGICAL_SORT can not contains GroupingScalarFunction expression: Grouping_Id(department, level)\`. Adding the missing \`employee\` setup table alone would not make the example work — the SQL itself needs a rewrite or a planner change. Flagged separately for RD. ## Test plan - [x] Each new setup block executes on 4.1.1 and the following example produces the documented result. - [x] EN and ZH parallel-edited; structure mirrors between sides. - [x] No existing examples removed. 🤖 Generated with [Claude Code](https://claude.com/claude-code) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
