This is an automated email from the ASF dual-hosted git repository.
morningman pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris-website.git
The following commit(s) were added to refs/heads/master by this push:
new 7a852084a5e [fix](doc) dev: correct four wrong SQL-function examples
(trim_in / murmur_hash3_64_v2 / json_extract_bigint / uncompress) (#3864)
7a852084a5e is described below
commit 7a852084a5e6ce2a236a689da8b7c808e6b52b21
Author: boluor <[email protected]>
AuthorDate: Mon Jun 1 23:59:59 2026 -0700
[fix](doc) dev: correct four wrong SQL-function examples (trim_in /
murmur_hash3_64_v2 / json_extract_bigint / uncompress) (#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)
Co-authored-by: verify-sweep <verify@local>
Co-authored-by: Claude Opus 4.8 (1M context) <[email protected]>
---
.../sql-functions/scalar-functions/string-functions/trim-in.md | 10 +++++-----
.../encrypt-digest-functions/murmur-hash3-64-v2.md | 10 +++++-----
.../scalar-functions/json-functions/json-extract-bigint.md | 2 +-
.../scalar-functions/string-functions/uncompress.md | 2 +-
4 files changed, 12 insertions(+), 12 deletions(-)
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/string-functions/trim-in.md
b/docs/sql-manual/sql-functions/scalar-functions/string-functions/trim-in.md
index e0db04ef3cb..49bb5323ec9 100644
--- a/docs/sql-manual/sql-functions/scalar-functions/string-functions/trim-in.md
+++ b/docs/sql-manual/sql-functions/scalar-functions/string-functions/trim-in.md
@@ -65,11 +65,11 @@ SELECT trim_in('ababccaab', 'ab') str;
SELECT trim_in('ababccaab', 'ab'), trim('ababccaab', 'ab');
```
```text
-+-----------------------------+--------------------------+
-| trim_in('ababccaab', 'ab') | trim('ababccaab', 'ab') |
-+-----------------------------+--------------------------+
-| cc | ababccaab |
-+-----------------------------+--------------------------+
++----------------------------+-------------------------+
+| trim_in('ababccaab', 'ab') | trim('ababccaab', 'ab') |
++----------------------------+-------------------------+
+| cc | cca |
++----------------------------+-------------------------+
```
4. Character set order does not matter
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-64-v2.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-64-v2.md
index b516fbf0d99..8483ea58b36 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-64-v2.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/encrypt-digest-functions/murmur-hash3-64-v2.md
@@ -39,11 +39,11 @@ select murmur_hash3_64_v2(null),
murmur_hash3_64_v2("hello"), murmur_hash3_64_v2
```
```text
-+-----------------------+--------------------------+-----------------------------------+
-| murmur_hash3_64(NULL) | murmur_hash3_64('hello') | murmur_hash3_64('hello',
'world') |
-+-----------------------+--------------------------+-----------------------------------+
-| NULL | -3215607508166160593 |
3583109472027628045 |
-+-----------------------+--------------------------+-----------------------------------+
++--------------------------+-----------------------------+--------------------------------------+
+| murmur_hash3_64_v2(null) | murmur_hash3_64_v2("hello") |
murmur_hash3_64_v2("hello", "world") |
++--------------------------+-----------------------------+--------------------------------------+
+| NULL | -3758069500696749310 |
-662943091231200135 |
++--------------------------+-----------------------------+--------------------------------------+
```
```sql
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-bigint.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-bigint.md
index 73b6a8f3f60..dfcd14aa0e4 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-bigint.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/json-functions/json-extract-bigint.md
@@ -33,7 +33,7 @@ JSON_EXTRACT_BIGINT(<json_object>, <json_path>)
## 示例
1. 正常参数
```sql
- SELECT json_extract_int('{"id": 122222222222223, "name": "doris"}',
'$.id');
+ SELECT json_extract_bigint('{"id": 122222222222223, "name": "doris"}',
'$.id');
```
```text
+-------------------------------------------------------------------------+
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/uncompress.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/uncompress.md
index da128899bd6..9e2f3068cdd 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/uncompress.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/string-functions/uncompress.md
@@ -52,7 +52,7 @@ select uncompress(compress(''));
+--------------------------+
```
```sql
-select uncompress(compress(abc));
+select uncompress('abc');
```
```text
+-------------------+
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
