[Bug]: design table in navicat doesn't work

[dengn]

Is there an existing issue for the same bug?

• I have checked the existing issues.

Environment

- Version or commit-id (e.g. v0.1.0 or 8b23a93):
- Hardware parameters:
- OS type:
- Others:

Actual Behavior

In navicat, users usually use design table to modify table structures.

But this has two issues:

1. we get an error of partitition doesn't exist issue. The cause is this SQL doesn't work.

SELECT TABLE_NAME, PARTITION_NAME, SUBPARTITION_NAME, PARTITION_METHOD, SUBPARTITION_METHOD, PARTITION_EXPRESSION, SUBPARTITION_EXPRESSION, PARTITION_DESCRIPTION, PARTITION_COMMENT, NODEGROUP, TABLESPACE_NAME FROM information_schema.PARTITIONS WHERE NOT ISNULL(PARTITION_NAME) AND TABLE_SCHEMA LIKE 'eladmin' AND TABLE_NAME LIKE 'sys_job' ORDER BY TABLE_NAME, PARTITION_NAME, PARTITION_ORDINAL_POSITION, SUBPARTITION_ORDINAL_POSITION

2. any operation is blocked afterwards.
   we cann't click on any column and do anything on it.

This is blocking usage of any alter table function.

Expected Behavior

No response

Steps to Reproduce

No response

Additional information

No response

[domingozhang]

will be fixed in next release

[daviszhen]

0.8来不及了。

[daviszhen]

下一个迭代

[dengn]

customer test replied on this fix.

[qingxinhome]

The issue has been confirmed

[qingxinhome]

Processing

[dengn]

@lacrimosaprinz This fix will affect information_schema related doc, please refer to this PR #10330 for more details.

[qingxinhome]

Code review in progress

[qingxinhome]

Code review in progress

[qingxinhome]

Code review in progress

[qingxinhome]

In research and design

[qingxinhome]

In research and design

[qingxinhome]

Code review in progress

[qingxinhome]

To begin

[qingxinhome]

I haven't started yet

[qingxinhome]

I haven't started yet

[qingxinhome]

not working on it

[qingxinhome]

not working on it

[qingxinhome]

The partition table system view function has been implemented, please verify and test it @dengn @domingozhang @daviszhen

[dengn]

fixed.