vscode-database-client icon indicating copy to clipboard operation
vscode-database-client copied to clipboard

[BUG] clickhouse show table DDL failed

Open jhxud opened this issue 3 years ago • 1 comments
trafficstars

  • OS:
  • Database Type: Clickhouse

I want to get clickhouse table DDL, but it didn't worked. I find query sql is: SELECT create_table_query as "Create Table",name as table_name,'definition' as view_definition from system.tables WHERE database='system' and table='metric_log'

It is not right, system.tables does not has table column, should be: SELECT create_table_query as "Create Table",name as table_name,'definition' as view_definition from system.tables WHERE database='system' and name='metric_log'

jhxud avatar Jul 27 '22 09:07 jhxud

Thanks for your feedback, I will fix it in the next version.

cweijan avatar Jul 27 '22 10:07 cweijan

Hi, I forgot to notice you that the conditional column table has been changed to name, and now the ddl can be displayed normally.

cweijan avatar Aug 13 '22 12:08 cweijan