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 2e103a143de Update decimal doc (#2580)
2e103a143de is described below
commit 2e103a143de54cfe43608bc5f1b5853346661ef9
Author: TengJianPing <[email protected]>
AuthorDate: Fri Jul 4 19:43:12 2025 +0800
Update decimal doc (#2580)
## Versions
- [x] dev
- [x] 3.0
- [x] 2.1
- [ ] 2.0
## Languages
---
docs/sql-manual/basic-element/sql-data-types/numeric/DECIMAL.md | 2 ++
.../current/sql-manual/basic-element/sql-data-types/numeric/DECIMAL.md | 2 ++
.../sql-manual/basic-element/sql-data-types/numeric/DECIMAL.md | 2 ++
.../sql-manual/basic-element/sql-data-types/numeric/DECIMAL.md | 2 ++
.../sql-manual/basic-element/sql-data-types/numeric/DECIMAL.md | 2 ++
.../sql-manual/basic-element/sql-data-types/numeric/DECIMAL.md | 2 ++
6 files changed, 12 insertions(+)
diff --git a/docs/sql-manual/basic-element/sql-data-types/numeric/DECIMAL.md
b/docs/sql-manual/basic-element/sql-data-types/numeric/DECIMAL.md
index 85b00cb3b5a..4df308fb266 100644
--- a/docs/sql-manual/basic-element/sql-data-types/numeric/DECIMAL.md
+++ b/docs/sql-manual/basic-element/sql-data-types/numeric/DECIMAL.md
@@ -19,6 +19,8 @@ DECIMAL
The default value of enable_decimal256 is false. Setting it to true can
get more accurate results, but it will bring some performance loss.
+ When outputting decimal types, the decimal point is always followed by S
digits, even if the trailing digits are 0. For example, the number 123.456 of
type decimal(18, 6) will be output as 123.456000.
+
### Precision Deduction
DECIMAL has a very complex set of type inference rules. For different
expressions, different rules will be applied for precision inference.
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/basic-element/sql-data-types/numeric/DECIMAL.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/basic-element/sql-data-types/numeric/DECIMAL.md
index bc6392b0dfe..61dff8bee3c 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/basic-element/sql-data-types/numeric/DECIMAL.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/basic-element/sql-data-types/numeric/DECIMAL.md
@@ -19,6 +19,8 @@ DECIMAL
enable_decimal256 的默认值是false,设置为true 可以获得更加精确的结果,但是会带来一些性能损失。
+ decimal类型在输出时,小数点后总是显示S位数字,即使小数的后缀是0。比如类型decimal(18,
6)的数字123.456,会输出成123.456000。
+
### 精度推演
DECIMAL 有一套很复杂的类型推演规则,针对不同的表达式,会应用不同规则进行精度推断。
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/basic-element/sql-data-types/numeric/DECIMAL.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/basic-element/sql-data-types/numeric/DECIMAL.md
index bc6392b0dfe..61dff8bee3c 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/basic-element/sql-data-types/numeric/DECIMAL.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/basic-element/sql-data-types/numeric/DECIMAL.md
@@ -19,6 +19,8 @@ DECIMAL
enable_decimal256 的默认值是false,设置为true 可以获得更加精确的结果,但是会带来一些性能损失。
+ decimal类型在输出时,小数点后总是显示S位数字,即使小数的后缀是0。比如类型decimal(18,
6)的数字123.456,会输出成123.456000。
+
### 精度推演
DECIMAL 有一套很复杂的类型推演规则,针对不同的表达式,会应用不同规则进行精度推断。
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/basic-element/sql-data-types/numeric/DECIMAL.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/basic-element/sql-data-types/numeric/DECIMAL.md
index bc6392b0dfe..61dff8bee3c 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/basic-element/sql-data-types/numeric/DECIMAL.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/basic-element/sql-data-types/numeric/DECIMAL.md
@@ -19,6 +19,8 @@ DECIMAL
enable_decimal256 的默认值是false,设置为true 可以获得更加精确的结果,但是会带来一些性能损失。
+ decimal类型在输出时,小数点后总是显示S位数字,即使小数的后缀是0。比如类型decimal(18,
6)的数字123.456,会输出成123.456000。
+
### 精度推演
DECIMAL 有一套很复杂的类型推演规则,针对不同的表达式,会应用不同规则进行精度推断。
diff --git
a/versioned_docs/version-2.1/sql-manual/basic-element/sql-data-types/numeric/DECIMAL.md
b/versioned_docs/version-2.1/sql-manual/basic-element/sql-data-types/numeric/DECIMAL.md
index 85b00cb3b5a..4df308fb266 100644
---
a/versioned_docs/version-2.1/sql-manual/basic-element/sql-data-types/numeric/DECIMAL.md
+++
b/versioned_docs/version-2.1/sql-manual/basic-element/sql-data-types/numeric/DECIMAL.md
@@ -19,6 +19,8 @@ DECIMAL
The default value of enable_decimal256 is false. Setting it to true can
get more accurate results, but it will bring some performance loss.
+ When outputting decimal types, the decimal point is always followed by S
digits, even if the trailing digits are 0. For example, the number 123.456 of
type decimal(18, 6) will be output as 123.456000.
+
### Precision Deduction
DECIMAL has a very complex set of type inference rules. For different
expressions, different rules will be applied for precision inference.
diff --git
a/versioned_docs/version-3.0/sql-manual/basic-element/sql-data-types/numeric/DECIMAL.md
b/versioned_docs/version-3.0/sql-manual/basic-element/sql-data-types/numeric/DECIMAL.md
index 85b00cb3b5a..4df308fb266 100644
---
a/versioned_docs/version-3.0/sql-manual/basic-element/sql-data-types/numeric/DECIMAL.md
+++
b/versioned_docs/version-3.0/sql-manual/basic-element/sql-data-types/numeric/DECIMAL.md
@@ -19,6 +19,8 @@ DECIMAL
The default value of enable_decimal256 is false. Setting it to true can
get more accurate results, but it will bring some performance loss.
+ When outputting decimal types, the decimal point is always followed by S
digits, even if the trailing digits are 0. For example, the number 123.456 of
type decimal(18, 6) will be output as 123.456000.
+
### Precision Deduction
DECIMAL has a very complex set of type inference rules. For different
expressions, different rules will be applied for precision inference.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]