bug: SHOW TABLES, DROP TABLE fails if STORAGE_FORMAT is invalid

[jason-heo]

Search before asking

• I had searched in the issues and found no similar issues.

Version

SELECT VERSION()

┌────────────────────────────────────────────────────────────────────────────────────────┐
│                                        version()                                       │
│                                         String                                         │
├────────────────────────────────────────────────────────────────────────────────────────┤
│ Databend Query v1.2.615-a8da519a63(rust-1.81.0-nightly-2024-08-19T03:29:16.412442905Z) │
└────────────────────────────────────────────────────────────────────────────────────────┘

What's Wrong?

Hello, I'm new to DataBend.

Thank you for GREAT OLAP DB! It's awesome and blazingly fast.

I got a minor bug.

Thank you.

How to Reproduce?

root@localhost:8000/default> CREATE TABLE members
(
  name VARCHAR,
  age INT
)
STORAGE_FORMAT = 'abc';
processed in (0.012 sec)

root@localhost:8000/default> SHOW TABLES;
server warning: Failed to list tables in database: default, UnknownFormat. Code: 1074, Text = unknown fuse storage_format abc.

root@localhost:8000/default> DROP TABLE members;
error: APIError: ResponseError with 1074: error on validating table access
unknown fuse storage_format abc

The only thing I can do to resolve is DROP DATABASE

Are you willing to submit PR?

• Yes I am willing to submit a PR!

[TCeason]

Thx. The create need to fail.

CREATE TABLE members
(
  name VARCHAR,
  age INT
)
STORAGE_FORMAT = 'abc';