boluor opened a new pull request, #3864:
URL: https://github.com/apache/doris-website/pull/3864
Four dev function-reference examples whose documented output or SQL did not
match actual behavior. Each verified end-to-end on a live master daily build
(`doris-0.0.0-2e72603618c`); fixes use the real cluster output.
### 1. EN `string-functions/trim-in.md` — wrong `trim()` value
The "Comparison with TRIM function" example showed `trim('ababccaab','ab')`
= `ababccaab` (unchanged), which is wrong — `TRIM` strips the `ab` unit from
both ends. (ZH page already correct.)
```
SELECT trim_in('ababccaab','ab'), trim('ababccaab','ab');
+----------------------------+-------------------------+
| trim_in('ababccaab', 'ab') | trim('ababccaab', 'ab') |
+----------------------------+-------------------------+
| cc | cca |
+----------------------------+-------------------------+
```
### 2. ZH `encrypt-digest-functions/murmur-hash3-64-v2.md` — result table
copied from the non-v2 page
The first example queries `murmur_hash3_64_v2(...)` but the result table
(header **and** values) was copy-pasted from `murmur_hash3_64`. Replaced with
the v2 output (mirrors the EN page):
```
select murmur_hash3_64_v2(null), murmur_hash3_64_v2("hello"),
murmur_hash3_64_v2("hello","world");
-> NULL | -3758069500696749310 | -662943091231200135
```
### 3. ZH `json-functions/json-extract-bigint.md` — wrong function in first
example
Called `json_extract_int` (which returns `NULL` for `122222222222223` via
int overflow) while the header/expected showed `json_extract_bigint`. Corrected
the call to match the header, the expected value, and the EN page:
```
SELECT json_extract_bigint('{"id": 122222222222223, "name": "doris"}',
'$.id'); -> 122222222222223
```
### 4. ZH `string-functions/uncompress.md` — broken third-example query
Query was `uncompress(compress(abc))` (`abc` unquoted → parser error
`Unknown column 'abc'`) while its header/expected showed `uncompress('abc')` →
`NULL`. Corrected to match the header, expected, and EN page:
```
select uncompress('abc'); -> NULL
```
**Scope:** dev only (`docs/` + `i18n/.../current/`). No `ja-source` changes.
(`murmur_hash3_64_v2`, `json_extract_bigint` also exist in released versions —
backport scope will be mapped separately.)
🤖 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]