[bug] Dbeaver show create table

[hantmac]

In Dbeaver, the DDL show create table is shown as:

But the table in databend should show create table as:

CREATE TABLE `source_table` (
  `id` INT NULL,
  `name` VARCHAR NULL,
  `age` INT NULL,
  `city` VARCHAR NULL
) ENGINE=FUSE

Dbeaver should shown the same with bendsql.

[hanxuanliang]

1. create a table in dbserver
2. In the databend bendsql, the create table sql is inconsistent. The field type is missing

Is that case? @hantmac

[hantmac]

1. create a table in dbserver
2. In the databend bendsql, the create table sql is inconsistent. The field type is missing

Is that case? @hantmac

The field nullable is missing. In dbeaver , there is no NULL .

[hanxuanliang]

dbeaver/dbeaver#23101

I submitted my question to DBeaver. Let's see if there are any settings that we haven't noticed.

[hanxuanliang]

https://github.com/dbeaver/dbeaver/blob/69eef4faa5735071be386281c2d752eba88dcf82/plugins/org.jkiss.dbeaver.ext.clickhouse/src/org/jkiss/dbeaver/ext/clickhouse/model/ClickhouseMetaModel.java#L121

We need to implement getTableDDL, and dbeaver can display DDL directly using the logic we implemented.