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

dengn commented 1 year ago

Is there an existing issue for the same bug?

[X] 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:

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

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 commented 1 year ago

will be fixed in next release

daviszhen commented 1 year ago

0.8来不及了。

daviszhen commented 1 year ago

下一个迭代

dengn commented 1 year ago

customer test replied on this fix.