查询的标的元数据信息,mysql 是可以的,但是doris 里边缺少AUTO_INCREMENT这个字段,哪个版本有兼容

Viewed 25

查询的标的元数据信息,mysql 是可以执行如下sql的,但是doris 里边缺少AUTO_INCREMENT这个字段,请问目前是否有版本兼容,是在哪个版本,我目前是会用的是2.0.7 的版本,谢谢

select TABLE_TYPE as tableType,
engine,
TABLE_ROWS as tableTows,
AVG_ROW_LENGTH as avgRowLength,
DATA_LENGTH as dataLength,
INDEX_LENGTH as indexLength,
DATA_FREE as dataFree,
AUTO_INCREMENT as autoIncrement,
UNIX_TIMESTAMP(CREATE_TIME) as createTime,
UNIX_TIMESTAMP(UPDATE_TIME) as updateTime,
TABLE_COLLATION as tableCollation,
CREATE_OPTIONS as createOption,
TABLE_COMMENT as tableComment
from TABLES

1 Answers

可以看看doris 2.1 带的自增列功能