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 bd782437631 [doc](create table) add since version for some new
features (#30506)
bd782437631 is described below
commit bd782437631d90807d105e759be8fe5abecc510a
Author: zhannngchen <[email protected]>
AuthorDate: Thu Feb 22 09:13:35 2024 +0800
[doc](create table) add since version for some new features (#30506)
---
.../sql-reference/Data-Definition-Statements/Create/CREATE-TABLE.md | 4 ++--
.../sql-reference/Data-Definition-Statements/Create/CREATE-TABLE.md | 4 ++--
2 files changed, 4 insertions(+), 4 deletions(-)
diff --git
a/docs/en/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-TABLE.md
b/docs/en/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-TABLE.md
index 012720428c2..44dbf5cceb8 100644
---
a/docs/en/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-TABLE.md
+++
b/docs/en/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-TABLE.md
@@ -115,7 +115,7 @@ Column definition list:
BITMAP_UNION: The aggregation mode of BIMTAP type columns, which
performs the union aggregation of bitmaps.
```
- * `AUTO_INCREMENT(auto_inc_start_value)`(Available from version 2.1 and
later.)
+ * <version since="2.1"
type="inline">`AUTO_INCREMENT(auto_inc_start_value)`</version>
To indicate if the column is a auto-increment column. Auto-increment
column can be used to generate a unique identity for new row. If no values are
assgined for auto-increment column when inserting, Doris will generate sequence
numbers automatically. You can also assign the auto-increment column with NULL
literal to indicate Doris to generate sequence numbers. It should be noted
that, for performance reasons, BE will cache some values of auto-increment
column in memory. Therefore [...]
A table can have at most one auto-incremnt column. The auto-increment
column should be BIGINT type and be NOT NULL.
@@ -143,7 +143,7 @@ Column definition list:
dt DATETIME DEFAULT CURRENT_TIMESTAMP
```
- * `on update current_timestamp`
+ * <version since="2.1" type="inline">`on update
current_timestamp`</version>
To indicate that whether the value of this column should be updated to
the current timestamp (`current_timestamp`) when there is an update on the row.
The feature is only available on unique table with merge-on-write enabled.
Columns with this feature enabled must declare a default value, and the default
value must be `current_timestamp`. If the precision of the timestamp is
declared here, the timestamp precision in the default value of the column must
be the same as the precisio [...]
diff --git
a/docs/zh-CN/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-TABLE.md
b/docs/zh-CN/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-TABLE.md
index e760bf9892f..e8ac8e69f0a 100644
---
a/docs/zh-CN/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-TABLE.md
+++
b/docs/zh-CN/docs/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-TABLE.md
@@ -106,7 +106,7 @@ distribution_desc
HLL_UNION：HLL 类型的列的聚合方式，通过 HyperLogLog 算法聚合。
BITMAP_UNION：BIMTAP 类型的列的聚合方式，进行位图的并集聚合。
```
- * `AUTO_INCREMENT(auto_inc_start_value)`(2.1版本及以后可用)
+ * <version since="2.1"
type="inline">`AUTO_INCREMENT(auto_inc_start_value)`</version>
是否为自增列，自增列可以用来为新插入的行生成一个唯一标识。在插入表数据时如果没有指定自增列的值，则会自动生成一个合法的值。当自增列被显示地插入NULL时，其值也会被替换为生成的合法值。需要注意的是，处于性能考虑，BE会在内存中缓存部分自增列的值，所以自增列自动生成的值只能保证单调性和唯一性，无法保证严格的连续性。
一张表中至多有一个列是自增列，自增列必须是BIGINT类型，且必须为NOT NULL。
@@ -130,7 +130,7 @@ distribution_desc
// 只用于DATETIME类型，导入数据缺失该值时系统将赋予当前时间
dt DATETIME DEFAULT CURRENT_TIMESTAMP
```
- * `on update current_timestamp`
+ * <version since="2.1" type="inline">`on update current_timestamp`</version>
是否在该行有列更新时将该列的值更新为当前时间(`current_timestamp`)。该特性只能在开启了merge-on-write的unique表上使用，开启了这个特性的列必须声明默认值，且默认值必须为`current_timestamp`。如果此处声明了时间戳的精度，则该列默认值中的时间戳精度必须与该处的时间戳精度相同。
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
