You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "boluor (via GitHub)" <gi...@apache.org> on 2026/05/27 13:33:07 UTC
[PR] [fix](doc) SELECT.md: add student/tb_book setup for the simple examples; flag JOIN/UNION snippets as illustrative [doris-website]
boluor opened a new pull request, #3824:
URL: https://github.com/apache/doris-website/pull/3824
## Summary
Doc page (4.x): \`sql-manual/sql-statements/data-query/SELECT.md\` (EN + ZH).
The Examples section calls out roughly 15 different tables (\`student\`, \`tb_book\`, \`t1\`-\`t4\`, \`employee\`, \`info\`, \`left_tbl\`, \`right_tbl\`, \`tournament\`, \`test_table\`, \`users\`, \`student_01\`/\`student_02\`), none of which the page creates. Adding setup for all 15 would balloon the doc and is not really the page's intent — most of the multi-table examples (UNION / WITH / JOIN / TABLESAMPLE) are illustrative of the syntax shape rather than meant to run end-to-end.
This PR adds a single small setup block at the top of \`## Example\` that creates the two tables shared by the simplest 9 examples — \`student\` (5 rows) and \`tb_book\` (5 rows). After this change, examples 1-9 (IN-list filter, ALL EXCEPT, GROUP BY, DISTINCT, ORDER BY, LIMIT, CONCAT, SUM aggregation, expression aliases) all run end-to-end on Apache Doris 4.1.1.
A one-line note above the setup explains that the later JOIN / UNION / WITH / TABLESAMPLE examples reference tables not created on the page and are illustrative.
## Verification
Each of examples 1-9 runs against the new setup on a single-node Apache Doris 4.1.1 cluster.
## Test plan
- [x] Examples 1-9 produce results consistent with the documented intent.
- [x] EN and ZH updated in parallel.
- [x] No existing example removed or relabeled.
🤖 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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](doc) SELECT.md: add student/tb_book setup for the simple examples; flag JOIN/UNION snippets as illustrative [doris-website]
Posted by "morningman (via GitHub)" <gi...@apache.org>.
morningman merged PR #3824:
URL: https://github.com/apache/doris-website/pull/3824
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org