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.git
The following commit(s) were added to refs/heads/master by this push:
new 40bff30778 [doc](fix) add STRING conversion notice (#11895)
40bff30778 is described below
commit 40bff307782931824e251f3aeca354755f25a2f3
Author: a19920714liou <[email protected]>
AuthorDate: Thu Aug 18 21:31:04 2022 +0800
[doc](fix) add STRING conversion notice (#11895)
---
.../sql-reference/Data-Definition-Statements/Alter/ALTER-TABLE-COLUMN.md | 1 +
.../sql-reference/Data-Definition-Statements/Alter/ALTER-TABLE-COLUMN.md | 1 +
2 files changed, 2 insertions(+)
diff --git
a/docs/en/docs/sql-manual/sql-reference/Data-Definition-Statements/Alter/ALTER-TABLE-COLUMN.md
b/docs/en/docs/sql-manual/sql-reference/Data-Definition-Statements/Alter/ALTER-TABLE-COLUMN.md
index 27a77319d8..697ef2a912 100644
---
a/docs/en/docs/sql-manual/sql-reference/Data-Definition-Statements/Alter/ALTER-TABLE-COLUMN.md
+++
b/docs/en/docs/sql-manual/sql-reference/Data-Definition-Statements/Alter/ALTER-TABLE-COLUMN.md
@@ -116,6 +116,7 @@ Notice:
- DATE is converted to DATETIME (hours, minutes and seconds are
automatically filled with zeros, for example: `2019-12-09` <--> `2019-12-09
00:00:00`)
- Convert FLOAT to DOUBLE
- INT is converted to DATE (if the INT type data is illegal, the conversion
fails, and the original data remains unchanged)
+ - All can be converted to STRING except DATE and DATETIME, but STRING cannot
be converted to any other type
5. Reorder the column at the specified index
diff --git
a/docs/zh-CN/docs/sql-manual/sql-reference/Data-Definition-Statements/Alter/ALTER-TABLE-COLUMN.md
b/docs/zh-CN/docs/sql-manual/sql-reference/Data-Definition-Statements/Alter/ALTER-TABLE-COLUMN.md
index 743d29b8d4..287ca8a3f3 100644
---
a/docs/zh-CN/docs/sql-manual/sql-reference/Data-Definition-Statements/Alter/ALTER-TABLE-COLUMN.md
+++
b/docs/zh-CN/docs/sql-manual/sql-reference/Data-Definition-Statements/Alter/ALTER-TABLE-COLUMN.md
@@ -116,6 +116,7 @@ MODIFY COLUMN column_name column_type [KEY | agg_type]
[NULL | NOT NULL] [DEFAUL
- DATE 转换成 DATETIME(时分秒自动补零， 例如: `2019-12-09` <--> `2019-12-09 00:00:00`)
- FLOAT 转换成 DOUBLE
- INT 转换成 DATE (如果INT类型数据不合法则转换失败，原始数据不变)
+ - 除DATE与DATETIME以外都可以转换成STRING，但是STRING不能转换任何其他类型
5. 对指定 index 的列进行重新排序
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
