You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by ji...@apache.org on 2022/05/09 01:17:29 UTC
[incubator-doris] branch master updated: [doc] Update DECIMAL.md (#9451)
This is an automated email from the ASF dual-hosted git repository.
jiafengzheng pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/incubator-doris.git
The following commit(s) were added to refs/heads/master by this push:
new 35f0725387 [doc] Update DECIMAL.md (#9451)
35f0725387 is described below
commit 35f0725387fb28725d13839c28eebe186dd57e39
Author: emerkfu <59...@users.noreply.github.com>
AuthorDate: Mon May 9 09:17:24 2022 +0800
[doc] Update DECIMAL.md (#9451)
* Update DECIMAL.md
---
docs/en/sql-manual/sql-reference/Data-Types/DECIMAL.md | 9 +++++++--
docs/zh-CN/sql-manual/sql-reference/Data-Types/DECIMAL.md | 8 +++++---
2 files changed, 12 insertions(+), 5 deletions(-)
diff --git a/docs/en/sql-manual/sql-reference/Data-Types/DECIMAL.md b/docs/en/sql-manual/sql-reference/Data-Types/DECIMAL.md
index 95b78bedff..450285d4cc 100644
--- a/docs/en/sql-manual/sql-reference/Data-Types/DECIMAL.md
+++ b/docs/en/sql-manual/sql-reference/Data-Types/DECIMAL.md
@@ -27,8 +27,13 @@ under the License.
## DECIMAL
### Description
DECIMAL (M [,D])
-High-precision fixed-point, M stands for the total number of significant numbers (precision), D stands for the maximum number of decimal points (scale)
-The range of M is [1,27], the range of D is [1,9], in addition, M must be greater than or equal to the value of D. The default value of D is 0.
+
+High-precision fixed-point, M stands for the total number of significant numbers (precision), D stands for the maximum number of decimal points (scale).
+The range of M is [1, 27], the range of D is [0, 9], the integer part is [1, 18].
+
+in addition, M must be greater than or equal to the value of D.
+
+The default value is DECIMAL(9, 0).
### keywords
DECIMAL
diff --git a/docs/zh-CN/sql-manual/sql-reference/Data-Types/DECIMAL.md b/docs/zh-CN/sql-manual/sql-reference/Data-Types/DECIMAL.md
index 64c7dd81c9..f59c280fc5 100644
--- a/docs/zh-CN/sql-manual/sql-reference/Data-Types/DECIMAL.md
+++ b/docs/zh-CN/sql-manual/sql-reference/Data-Types/DECIMAL.md
@@ -27,9 +27,11 @@ under the License.
## DECIMAL
### description
DECIMAL(M[,D])
- 高精度定点数，M代表一共有多少个有效数字(precision)，D代表小数点后最多有多少数字(scale)
- M的范围是[1,27], D的范围[1, 9], 另外，M必须要大于等于D的取值。默认的D取值为0
+ 高精度定点数，M 代表一共有多少个有效数字(precision)，D 代表小数位有多少数字(scale)，
+ 有效数字 M 的范围是 [1, 27]，小数位数字数量 D 的范围是 [0, 9]，整数位数字数量的范围是 [1, 18]，
+ 另外，M 必须要大于等于 D 的取值。
-### keywords
+ 默认值为 DECIMAL(9, 0)。
+### keywords
DECIMAL
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org