boluor opened a new pull request, #3833:
URL: https://github.com/apache/doris-website/pull/3833
## Summary
For these five pages the ZH version had grown to 9-10 examples while EN
still only documented 3-5. Backported the missing ZH-only examples to EN with
English headers. All expected outputs were captured directly from a fresh Doris
4.1.1 cluster (not transcribed from the ZH page) so the EN side is verified
against the implementation.
| Page | Examples before | Examples added | Examples after |
|------|-----------------|----------------|----------------|
| `locate.md` | 3 | +7 | 10 |
| `instr.md` | 4 | +6 | 10 |
| `length.md` | 3 | +6 | 9 |
| `lpad.md` | 3 | +6 | 9 |
| `from-base64.md` | 5 | +5 | 10 |
Examples added cover the natural corner cases each function tends to have:
NULL / empty / boundary inputs, UTF-8 multi-byte, repeated occurrences,
numeric/URL/email/JSON shapes, round-trip pairs (`FROM_BASE64(TO_BASE64(x))`),
etc. All were already passing on ZH; this PR just brings EN to parity.
## What's not in this PR
`ltrim.md` was on the original P1-zh-richer list but the only zh-only
example ("多种空白字符处理", `LTRIM(' \t\n hello world')`) has an incorrect expected
output: by default `LTRIM` strips only the ASCII space character, not `\t` /
`\n`, so the actual result still contains the tab and newline. Did not backport
this one — will file the ZH expected-output bug separately.
## Verification
For each file:
- Ran every added SQL against Doris 4.1.1 and pasted the exact ASCII output
the cluster returned
- Re-extracted each EN markdown file with the verifier's SQL extractor;
statement counts now match the ZH side (10 / 10 / 9 / 9 / 10)
- No fence / markdown-parsing changes were needed
## Test plan
- [x] Each added example runs cleanly on Doris 4.1.1 and matches the printed
expected output
- [x] EN stmt structure now parallels ZH after the change
- [x] No SQL was authored or modified — only EN prose headers translated;
SQL and result tables are byte-identical to the corresponding ZH blocks
🤖 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]
