SYSTEM DROP FORMAT SCHEMA CACHE does not work

[electrachong]

Describe what's wrong

Expected:
Able to run SYSTEM DROP FORMAT SCHEMA CACHE

Actual:

ch :) EXPLAIN SYNTAX SYSTEM DROP FORMAT SCHEMA CACHE;

Syntax error: failed at position 28 ('FORMAT'):

EXPLAIN SYNTAX SYSTEM DROP FORMAT SCHEMA CACHE;

Expected one of: DNS CACHE, MARK CACHE, UNCOMPRESSED CACHE, INDEX MARK CACHE, INDEX UNCOMPRESSED CACHE, MMAP CACHE, QUERY CACHE, COMPILED EXPRESSION CACHE, FILESYSTEM CACHE, SCHEMA CACHE, S3 CLIENT CACHE, REPLICA, DATABASE REPLICA

ch :) SYSTEM DROP FORMAT SCHEMA CACHE;

Syntax error: failed at position 13 ('FORMAT'):

SYSTEM DROP FORMAT SCHEMA CACHE;

Expected one of: DNS CACHE, MARK CACHE, UNCOMPRESSED CACHE, INDEX MARK CACHE, INDEX UNCOMPRESSED CACHE, MMAP CACHE, QUERY CACHE, COMPILED EXPRESSION CACHE, FILESYSTEM CACHE, SCHEMA CACHE, S3 CLIENT CACHE, REPLICA, DATABASE REPLICA

ch :) 

Does it reproduce on the most recent release?

The list of releases
Not sure

How to reproduce

• Which ClickHouse server version to use: ClickHouse server version 23.5.3 revision 54462.
• Which interface to use, if it matters: clickhouse-client

Additional context

May be related to: ClickHouse/clickhouse-java#1549

[den-crane]

23.5.3 is obsolete

DROP FORMAT SCHEMA was implemented with 23.10

v23.10.1.1976-stable.md:* Allow to drop cache for Protobuf format with SYSTEM DROP SCHEMA FORMAT CACHE [FOR Protobuf]. #55064 (Aleksandr Musorin).

[electrachong]

I see, thanks for pointing out the version for which it got implemented.