greptimedb icon indicating copy to clipboard operation
greptimedb copied to clipboard

Frontend show tables failed with table name "sys.cpu.system"

Open MichaelScofield opened this issue 2 years ago • 1 comments

mysql> show tables; ERROR 1815 (HY000): Failed to execute query: show tables, source: Failed to execute query: show tables, source: General catalog error: Cannot parse catalog value, source: Invalid catalog info: __tg-greptime-public-sys.cpu.system

MichaelScofield avatar Nov 14 '22 15:11 MichaelScofield

Don't think that's an issue, allowing . in table name will cause confusion, since full qualified table name already uses . as the delimiter between catalog name and schema name. MySQL does not allow table name with . too.

Maybe we should transform the prometheus table name from sys.cpu.system to sys_cpu_system in the protocol handler layer, which won't break the invariants in database layer.

v0y4g3r avatar Nov 14 '22 16:11 v0y4g3r