boluor opened a new pull request, #3838:
URL: https://github.com/apache/doris-website/pull/3838
## Summary
The original ZH example 3 ("多种空白字符处理") in `ltrim.md` ran:
```sql
SELECT LTRIM(' \t\n hello world');
```
and claimed the result was `hello world`. That's wrong: by default `LTRIM`
strips only ASCII space, not tab (`\t`) or newline (`\n`), so the actual result
is `\t\n hello world` — two characters shorter than the input (the two leading
spaces), not six chars shorter.
Rewrote the example along the same lines as the corresponding RTRIM "默认只剥除
ASCII 空格" example: compare `LENGTH()` before and after the call so the behavior
is unambiguous and the doc renders cleanly without embedded tabs/newlines in
the result table.
## Verification
On Doris 4.1.1:
```
LENGTH(' \t\n hello world') -> 17
LENGTH(LTRIM(' \t\n hello world')) -> 15
```
So only 2 chars (the two leading spaces) are removed, as documented now.
## Context
Originally flagged when this example was excluded from the bulk ZH→EN
backport in PR #3833 (the only zh-only ltrim example whose expected output
didn't match reality on the cluster).
🤖 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]
