This is an automated email from the ASF dual-hosted git repository.
yiguolei 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 8c3f219783f [doc](function)add docs for isnan,isinf (#2729)
8c3f219783f is described below
commit 8c3f219783f303477916fa791e597a590fe7efaa
Author: Mryange <[email protected]>
AuthorDate: Wed Aug 13 11:27:39 2025 +0800
[doc](function)add docs for isnan,isinf (#2729)
## Versions
- [x] dev
- [ ] 3.0
- [ ] 2.1
- [ ] 2.0
## Languages
- [x] Chinese
- [x] English
## Docs Checklist
- [ ] Checked by AI
- [ ] Test Cases Built
---
.../scalar-functions/numeric-functions/isinf.md | 84 +++++++++++++++++++++
.../scalar-functions/numeric-functions/isnan.md | 84 +++++++++++++++++++++
.../scalar-functions/numeric-functions/isinf.md | 87 ++++++++++++++++++++++
.../scalar-functions/numeric-functions/isnan.md | 85 +++++++++++++++++++++
sidebars.json | 2 +
5 files changed, 342 insertions(+)
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/isinf.md
b/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/isinf.md
new file mode 100644
index 00000000000..a74324324be
--- /dev/null
+++ b/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/isinf.md
@@ -0,0 +1,84 @@
+---
+{
+ "title": "ISINF",
+ "language": "en"
+}
+---
+
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+## Description
+
+Determines whether the specified value is infinity.
+
+## Syntax
+
+```sql
+ISINF(<value>)
+```
+
+## Parameters
+
+| Parameter | Description |
+| -- | -- |
+| `<value>` | The value to be checked, which must be a DOUBLE or FLOAT type |
+
+## Return Value
+
+Returns 1 if the value is infinity (positive or negative), otherwise returns 0.
+If the value is NULL, returns NULL.
+
+## Examples
+
+```sql
+SELECT isinf(1);
+```
+
+```text
++----------+
+| isinf(1) |
++----------+
+| 0 |
++----------+
+```
+
+```sql
+SELECT cast('inf' as double),isinf(cast('inf' as double))
+```
+
+```text
++-----------------------+------------------------------+
+| cast('inf' as double) | isinf(cast('inf' as double)) |
++-----------------------+------------------------------+
+| Infinity | 1 |
++-----------------------+------------------------------+
+```
+
+```sql
+SELECT isinf(NULL)
+```
+
+```text
++-------------+
+| isinf(NULL) |
++-------------+
+| NULL |
++-------------+
+```
diff --git
a/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/isnan.md
b/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/isnan.md
new file mode 100644
index 00000000000..31530463ce6
--- /dev/null
+++ b/docs/sql-manual/sql-functions/scalar-functions/numeric-functions/isnan.md
@@ -0,0 +1,84 @@
+---
+{
+ "title": "ISNAN",
+ "language": "en"
+}
+---
+
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+## Description
+
+Determines whether the specified value is NaN (Not a Number).
+
+## Syntax
+
+```sql
+ISNAN(<value>)
+```
+
+## Parameters
+
+| Parameter | Description |
+| -- | -- |
+| `<value>` | The value to be checked, which must be a DOUBLE or FLOAT type |
+
+## Return Value
+
+Returns 1 if the value is NaN, otherwise returns 0.
+If the value is NULL, returns NULL.
+
+## Examples
+
+```sql
+SELECT isnan(1);
+```
+
+```text
++----------+
+| isnan(1) |
++----------+
+| 0 |
++----------+
+```
+
+```sql
+SELECT cast('nan' as double),isnan(cast('nan' as double));
+```
+
+```text
++-----------------------+------------------------------+
+| cast('nan' as double) | isnan(cast('nan' as double)) |
++-----------------------+------------------------------+
+| NaN | 1 |
++-----------------------+------------------------------+
+```
+
+```sql
+SELECT isnan(NULL)
+```
+
+```text
++-------------+
+| isnan(NULL) |
++-------------+
+| NULL |
++-------------+
+```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/numeric-functions/isinf.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/numeric-functions/isinf.md
new file mode 100644
index 00000000000..46f1961cf64
--- /dev/null
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/numeric-functions/isinf.md
@@ -0,0 +1,87 @@
+---
+{
+ "title": "ISINF",
+ "language": "zh-CN"
+}
+---
+
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+## Description
+
+判断指定的值是否为无穷大。
+
+## Syntax
+
+```sql
+ISINF(<value>)
+```
+
+## Parameters
+
+| Parameter | Description |
+| -- | -- |
+| `<value>` | 要检查的值，DOUBLE 或 FLOAT 类型 |
+
+## Return Value
+
+如果值是无穷大（正无穷或负无穷），则返回 1，否则返回 0。
+如果值为 NULL，则返回 NULL。
+
+## Examples
+
+```sql
+SELECT isinf(1);
+```
+
+```text
++----------+
+| isinf(1) |
++----------+
+| 0 |
++----------+
+```
+
+```sql
+SELECT cast('inf' as double),isinf(cast('inf' as double))
+```
+
+```text
++-----------------------+------------------------------+
+| cast('inf' as double) | isinf(cast('inf' as double)) |
++-----------------------+------------------------------+
+| Infinity | 1 |
++-----------------------+------------------------------+
+```
+
+```sql
+SELECT isinf(NULL)
+```
+
+```text
++-------------+
+| isinf(NULL) |
++-------------+
+| NULL |
++-------------+
+```
+
+
+
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/numeric-functions/isnan.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/numeric-functions/isnan.md
new file mode 100644
index 00000000000..c41b66893a7
--- /dev/null
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/scalar-functions/numeric-functions/isnan.md
@@ -0,0 +1,85 @@
+---
+{
+ "title": "ISNAN",
+ "language": "zh-CN"
+}
+---
+
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+## Description
+
+判断指定的值是否为 NaN（非数字）。
+
+## Syntax
+
+```sql
+ISNAN(<value>)
+```
+
+## Parameters
+
+| Parameter | Description |
+| -- | -- |
+| `<value>` | 要检查的值，DOUBLE 或 FLOAT 类型 |
+
+## Return Value
+
+如果值是 NaN，则返回 1，否则返回 0。
+如果值为 NULL，则返回 NULL。
+
+## Examples
+
+```sql
+SELECT isnan(1);
+```
+
+```text
++----------+
+| isnan(1) |
++----------+
+| 0 |
++----------+
+```
+
+```sql
+SELECT cast('nan' as double),isnan(cast('nan' as double));
+```
+
+```text
++-----------------------+------------------------------+
+| cast('nan' as double) | isnan(cast('nan' as double)) |
++-----------------------+------------------------------+
+| NaN | 1 |
++-----------------------+------------------------------+
+```
+
+```sql
+SELECT isnan(NULL)
+```
+
+```text
++-------------+
+| isnan(NULL) |
++-------------+
+| NULL |
++-------------+
+```
+
diff --git a/sidebars.json b/sidebars.json
index 2555ac3ba78..7e7567eb997 100644
--- a/sidebars.json
+++ b/sidebars.json
@@ -1159,6 +1159,8 @@
"sql-manual/sql-functions/scalar-functions/numeric-functions/floor",
"sql-manual/sql-functions/scalar-functions/numeric-functions/fmod",
"sql-manual/sql-functions/scalar-functions/numeric-functions/format-round",
+
"sql-manual/sql-functions/scalar-functions/numeric-functions/isinf",
+
"sql-manual/sql-functions/scalar-functions/numeric-functions/isnan",
"sql-manual/sql-functions/scalar-functions/numeric-functions/ln",
"sql-manual/sql-functions/scalar-functions/numeric-functions/log",
"sql-manual/sql-functions/scalar-functions/numeric-functions/log10",
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
