apache / apache/doris-website

Issue on docs

Open
#2,285 2 comments 0 reactions 0 assignees View on GitHub
Dominant language
MDX
Stars
133
Forks
464
Avg merge
1d 1h
Merged PRs (30d)
50

Description

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 都是空白。

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.