boluor opened a new pull request, #3821: URL: https://github.com/apache/doris-website/pull/3821
## Summary Doc page (4.x): \`sql-functions/window-functions/dense-rank.md\` (EN + ZH). Both EN and ZH reference a table \`int_t\` that the page never creates, so copy-pasting the example fails on a fresh cluster. Two more inherited issues on the same result block: 1. The header separator was rendered as a markdown table separator \`| --- | --- | ---- |\` interleaved into what was otherwise an ASCII grid — that is not mysql client output. 2. Two of the data rows had trailing \`-- comment\` annotations appended after the row's closing \`|\` (e.g. \`| ... | -- Same values receive the same rank |\`). This is the same shape that broke verification on \`first-value.md\` (PR #3788). This PR: - Adds a setup block (CREATE TABLE + INSERT of 9 rows) to both EN and ZH. - Replaces the malformed result block with the verbatim mysql client output from Apache Doris 4.1.1 (clean 6-char-wide columns, no markdown separator, no inline comments). - Lifts the two teaching annotations out of the table into a single prose sentence above the result block. ## Verification \`\`\` mysql> -- after the setup block above mysql> select x, y, dense_rank() over(partition by x order by y) as rank from int_t; +------+------+------+ | x | y | rank | +------+------+------+ | 1 | 1 | 1 | | 1 | 2 | 2 | | 1 | 2 | 2 | | 2 | 1 | 1 | | 2 | 2 | 2 | | 2 | 3 | 3 | | 3 | 1 | 1 | | 3 | 1 | 1 | | 3 | 2 | 2 | +------+------+------+ \`\`\` Run three times — row order is stable across runs on a single-bucket partition. ## Test plan - [x] CREATE/INSERT + the example SELECT on a 4.1.1 cluster — produces the documented output exactly. - [x] EN and ZH structure mirror each other (same setup, same SQL, same result, parallel prose). - [x] No deletion of teaching content; the two inline annotations are preserved as a one-sentence intro to the result. 🤖 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]
