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/doris-website.git
The following commit(s) were added to refs/heads/master by this push:
new 5ddc065c138 [doc](fix) add STRING conversion notice (#55)
5ddc065c138 is described below
commit 5ddc065c138fd5a48c2c5b12796ef019acea40eb
Author: a19920714liou <562951...@qq.com>
AuthorDate: Mon Aug 22 08:57:08 2022 +0800
[doc](fix) add STRING conversion notice (#55)
add STRING conversion notice
---
.../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/sql-manual/sql-reference/Data-Definition-Statements/Alter/ALTER-TABLE-COLUMN.md
b/docs/sql-manual/sql-reference/Data-Definition-Statements/Alter/ALTER-TABLE-COLUMN.md
index 27a77319d84..697ef2a912b 100644
---
a/docs/sql-manual/sql-reference/Data-Definition-Statements/Alter/ALTER-TABLE-COLUMN.md
+++
b/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/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-reference/Data-Definition-Statements/Alter/ALTER-TABLE-COLUMN.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-reference/Data-Definition-Statements/Alter/ALTER-TABLE-COLUMN.md
index 743d29b8d42..287ca8a3f3b 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-reference/Data-Definition-Statements/Alter/ALTER-TABLE-COLUMN.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/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: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
