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 <59500675+emer...@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-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org