footmanai opened a new issue, #2285:
URL: https://github.com/apache/doris-website/issues/2285
Path:/zh-CN/docs/3.0/sql-manual/sql-statements/table-and-view/table/SHOW-TABLE-STATUS
环境情况:
doris 3.0、mysql 8.0、
创建与 mysql 关联的 category,category 名称为 dit;
mysql 下有一个 schema 名为 base,还有一张表 t_yardage
查询驱动使用 jdbc:arrow-flight-sql 版本 0.12.0
2)在mysql下执行的SQL
`SELECT
table_name,
table_comment
FROM
information_schema.TABLES
WHERE
table_schema = 'base' and table_name='t_yardage'`
结果:
table_name,table_comment
t_yardage,全码谱明细值
3)在 doris 下采用下面3种方式查询结果
1. 方式1:
`use dit.base;
show table status like 't_yardage';`
结果:
comment 列为空白
2. 方式2:
`show table status from dit.base.t_yardage;`
结果:
执行错误
3. 方式3:
`SELECT
table_name,
table_comment
FROM
dit.information_schema.TABLES
WHERE
table_schema = 'base' where table_name = 't_yardage'`
结果:
comment 列为空白
通过 category 获取表 comment 都是空白。
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]