This is an automated email from the ASF dual-hosted git repository.
dataroaring 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 ba863a992e [doc](alter table) add notes for modify column (#23720)
ba863a992e is described below
commit ba863a992ea068da28215f97b1fa768dab06357a
Author: zhannngchen <[email protected]>
AuthorDate: Fri Sep 1 19:32:44 2023 +0800
[doc](alter table) add notes for modify column (#23720)
---
.../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 e3976a36c7..3e477cead2 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
@@ -198,6 +198,7 @@ Note: Whether you modify the key column or the value
column, you need to declare
ALTER TABLE example_db.my_table
MODIFY COLUMN val1 VARCHAR(64) REPLACE DEFAULT "abc";
```
+Note: You can only modify the column's data type; other attributes of the
column must remain unchanged.
9. Reorder the columns in example_rollup_index (set the original column order
as: k1,k2,k3,v1,v2)
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 ca16ffb441..6394ba6294 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
@@ -198,6 +198,7 @@ MODIFY COLUMN col1 BIGINT KEY DEFAULT "1" AFTER col2;
ALTER TABLE example_db.my_table
MODIFY COLUMN val1 VARCHAR(64) REPLACE DEFAULT "abc";
```
+注意：只能修改列的类型，列的其他属性维持原样
9. 重新排序 example_rollup_index 中的列（设原列顺序为：k1,k2,k3,v1,v2）
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
