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 dbd1606c672 [fix](sql-functions) provide setup data for
numeric-function examples querying an undefined table (#3878)
dbd1606c672 is described below
commit dbd1606c672b61f7f687c9b774227c864b0f2fa1
Author: boluor <[email protected]>
AuthorDate: Tue Jun 2 23:54:17 2026 -0700
[fix](sql-functions) provide setup data for numeric-function examples
querying an undefined table (#3878)
The `ROUND_BANKERS` and `UNIFORM` pages each show a `SELECT ... FROM
<table>` example with an expected result, but never define the table on
the page. As written these examples cannot be run or reproduced — a
reader who copies them gets `Table [...] does not exist`.
This PR adds the missing `CREATE TABLE` + `INSERT` for each table,
carried in a standard HTML comment (`<!-- setup-sql ... -->`) just
before the example. Because it is an HTML comment, **the rendered page
is unchanged** and **no documented expected output is modified**.
### Pages and tables
| Function | Table(s) |
| --- | --- |
| `ROUND_BANKERS` | `test_enhanced_round` |
| `UNIFORM` | `it`, `fn_test` |
`ROUND_BANKERS` is updated in EN + ZH across dev/`current`,
`version-4.x`, `version-3.x` and `version-2.1`; `UNIFORM` exists only in
dev/`current` and `version-4.x` (12 files total). Verified end-to-end:
ROUND_BANKERS on 4.1.1 / 3.1.4 / 2.1.11 / master, UNIFORM on 4.1.1 /
master. The deterministic examples failed with "table does not exist"
before this change and match the documented output after it. (`UNIFORM`s
`random()`-seeded examples are inherently non-deterministic, as the page
itself notes — those keep showing sample output.) No `ja-source`
changes.
🤖 Generated with [Claude Code](https://claude.com/claude-code)
Co-authored-by: Claude Opus 4.8 (1M context) <[email protected]>
---
.../scalar-functions/numeric-functions/round-bankers.md | 5 +++++
.../sql-functions/scalar-functions/numeric-functions/uniform.md | 7 +++++++
.../scalar-functions/numeric-functions/round-bankers.md | 5 +++++
.../sql-functions/scalar-functions/numeric-functions/uniform.md | 7 +++++++
.../scalar-functions/numeric-functions/round-bankers.md | 5 +++++
.../scalar-functions/numeric-functions/round-bankers.md | 5 +++++
.../scalar-functions/numeric-functions/round-bankers.md | 5 +++++
.../sql-functions/scalar-functions/numeric-functions/uniform.md | 7 +++++++
.../scalar-functions/numeric-functions/round-bankers.md | 5 +++++
.../scalar-functions/numeric-functions/round-bankers.md | 5 +++++
.../scalar-functions/numeric-functions/round-bankers.md | 5 +++++
.../sql-functions/scalar-functions/numeric-functions/uniform.md | 7 +++++++
12 files changed, 68 insertions(+)
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/round-bankers.md
b/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/round-bankers.md
index b9cf554e37b..081381d5f73 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/round-bankers.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/round-bankers.md
@@ -59,6 +59,11 @@ Returns an integer or a float-point number:
## Example
+<!-- setup-sql
+CREATE TABLE test_enhanced_round (rid INT, number INT) DISTRIBUTED BY
HASH(rid) BUCKETS 1 PROPERTIES("replication_num"="1");
+INSERT INTO test_enhanced_round VALUES (1,1);
+-->
+
```sql
select round_bankers(0.4);
```
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/uniform.md
b/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/uniform.md
index 498998fa4a7..91c51f8a880 100644
---
a/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/uniform.md
+++
b/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/uniform.md
@@ -32,6 +32,13 @@ Note that unlike Snowflake's [common
usage](https://docs.snowflake.com/en/sql-re
## Example
+<!-- setup-sql
+CREATE TABLE it (k0 INT) DISTRIBUTED BY HASH(k0) BUCKETS 1
PROPERTIES("replication_num"="1");
+INSERT INTO it VALUES (NULL),(1),(2),(3),(4),(5);
+CREATE TABLE fn_test (ksint INT) DISTRIBUTED BY HASH(ksint) BUCKETS 1
PROPERTIES("replication_num"="1");
+INSERT INTO fn_test VALUES (1);
+-->
+
When all input parameters are integers, return an integer:
```sql
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/numeric-functions/round-bankers.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/numeric-functions/round-bankers.md
index eac21af0b1a..c0053250986 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/numeric-functions/round-bankers.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/numeric-functions/round-bankers.md
@@ -59,6 +59,11 @@ ROUND_BANKERS(<x> [ , <d>])
## 举例
+<!-- setup-sql
+CREATE TABLE test_enhanced_round (rid INT, number INT) DISTRIBUTED BY
HASH(rid) BUCKETS 1 PROPERTIES("replication_num"="1");
+INSERT INTO test_enhanced_round VALUES (1,1);
+-->
+
```sql
select round_bankers(0.4);
```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/numeric-functions/uniform.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/numeric-functions/uniform.md
index d4aa3aa04a2..389da1c2502 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/numeric-functions/uniform.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/numeric-functions/uniform.md
@@ -32,6 +32,13 @@ UNIFORM( <min> , <max> , <gen> )
## 举例
+<!-- setup-sql
+CREATE TABLE it (k0 INT) DISTRIBUTED BY HASH(k0) BUCKETS 1
PROPERTIES("replication_num"="1");
+INSERT INTO it VALUES (NULL),(1),(2),(3),(4),(5);
+CREATE TABLE fn_test (ksint INT) DISTRIBUTED BY HASH(ksint) BUCKETS 1
PROPERTIES("replication_num"="1");
+INSERT INTO fn_test VALUES (1);
+-->
+
输入参数全为整数时，返回整数：
```sql
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/numeric-functions/round-bankers.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/numeric-functions/round-bankers.md
index eac21af0b1a..c0053250986 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/numeric-functions/round-bankers.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-functions/scalar-functions/numeric-functions/round-bankers.md
@@ -59,6 +59,11 @@ ROUND_BANKERS(<x> [ , <d>])
## 举例
+<!-- setup-sql
+CREATE TABLE test_enhanced_round (rid INT, number INT) DISTRIBUTED BY
HASH(rid) BUCKETS 1 PROPERTIES("replication_num"="1");
+INSERT INTO test_enhanced_round VALUES (1,1);
+-->
+
```sql
select round_bankers(0.4);
```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/scalar-functions/numeric-functions/round-bankers.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/scalar-functions/numeric-functions/round-bankers.md
index eac21af0b1a..c0053250986 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/scalar-functions/numeric-functions/round-bankers.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/sql-manual/sql-functions/scalar-functions/numeric-functions/round-bankers.md
@@ -59,6 +59,11 @@ ROUND_BANKERS(<x> [ , <d>])
## 举例
+<!-- setup-sql
+CREATE TABLE test_enhanced_round (rid INT, number INT) DISTRIBUTED BY
HASH(rid) BUCKETS 1 PROPERTIES("replication_num"="1");
+INSERT INTO test_enhanced_round VALUES (1,1);
+-->
+
```sql
select round_bankers(0.4);
```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/round-bankers.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/round-bankers.md
index eac21af0b1a..c0053250986 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/round-bankers.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/round-bankers.md
@@ -59,6 +59,11 @@ ROUND_BANKERS(<x> [ , <d>])
## 举例
+<!-- setup-sql
+CREATE TABLE test_enhanced_round (rid INT, number INT) DISTRIBUTED BY
HASH(rid) BUCKETS 1 PROPERTIES("replication_num"="1");
+INSERT INTO test_enhanced_round VALUES (1,1);
+-->
+
```sql
select round_bankers(0.4);
```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/uniform.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/uniform.md
index d4aa3aa04a2..389da1c2502 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/uniform.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/uniform.md
@@ -32,6 +32,13 @@ UNIFORM( <min> , <max> , <gen> )
## 举例
+<!-- setup-sql
+CREATE TABLE it (k0 INT) DISTRIBUTED BY HASH(k0) BUCKETS 1
PROPERTIES("replication_num"="1");
+INSERT INTO it VALUES (NULL),(1),(2),(3),(4),(5);
+CREATE TABLE fn_test (ksint INT) DISTRIBUTED BY HASH(ksint) BUCKETS 1
PROPERTIES("replication_num"="1");
+INSERT INTO fn_test VALUES (1);
+-->
+
输入参数全为整数时，返回整数：
```sql
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/numeric-functions/round-bankers.md
b/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/numeric-functions/round-bankers.md
index b9cf554e37b..081381d5f73 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/numeric-functions/round-bankers.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-functions/scalar-functions/numeric-functions/round-bankers.md
@@ -59,6 +59,11 @@ Returns an integer or a float-point number:
## Example
+<!-- setup-sql
+CREATE TABLE test_enhanced_round (rid INT, number INT) DISTRIBUTED BY
HASH(rid) BUCKETS 1 PROPERTIES("replication_num"="1");
+INSERT INTO test_enhanced_round VALUES (1,1);
+-->
+
```sql
select round_bankers(0.4);
```
diff --git
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/numeric-functions/round-bankers.md
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/numeric-functions/round-bankers.md
index b9cf554e37b..081381d5f73 100644
---
a/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/numeric-functions/round-bankers.md
+++
b/versioned_docs/version-3.x/sql-manual/sql-functions/scalar-functions/numeric-functions/round-bankers.md
@@ -59,6 +59,11 @@ Returns an integer or a float-point number:
## Example
+<!-- setup-sql
+CREATE TABLE test_enhanced_round (rid INT, number INT) DISTRIBUTED BY
HASH(rid) BUCKETS 1 PROPERTIES("replication_num"="1");
+INSERT INTO test_enhanced_round VALUES (1,1);
+-->
+
```sql
select round_bankers(0.4);
```
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/round-bankers.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/round-bankers.md
index b9cf554e37b..081381d5f73 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/round-bankers.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/round-bankers.md
@@ -59,6 +59,11 @@ Returns an integer or a float-point number:
## Example
+<!-- setup-sql
+CREATE TABLE test_enhanced_round (rid INT, number INT) DISTRIBUTED BY
HASH(rid) BUCKETS 1 PROPERTIES("replication_num"="1");
+INSERT INTO test_enhanced_round VALUES (1,1);
+-->
+
```sql
select round_bankers(0.4);
```
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/uniform.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/uniform.md
index 498998fa4a7..91c51f8a880 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/uniform.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/scalar-functions/numeric-functions/uniform.md
@@ -32,6 +32,13 @@ Note that unlike Snowflake's [common
usage](https://docs.snowflake.com/en/sql-re
## Example
+<!-- setup-sql
+CREATE TABLE it (k0 INT) DISTRIBUTED BY HASH(k0) BUCKETS 1
PROPERTIES("replication_num"="1");
+INSERT INTO it VALUES (NULL),(1),(2),(3),(4),(5);
+CREATE TABLE fn_test (ksint INT) DISTRIBUTED BY HASH(ksint) BUCKETS 1
PROPERTIES("replication_num"="1");
+INSERT INTO fn_test VALUES (1);
+-->
+
When all input parameters are integers, return an integer:
```sql
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
