Change the table comment after created the table is not supported now?
Like mysql : ALTER TABLE [tableName] COMMNET [comment]; 
The sql "ALTER TABLE `system`.tables UPDATE Comment='test' WHERE NAME='t1';" also not supported!!!
My version is '21.9.4.35'。
const ASTPtr & ,
    const StorageMetadataPtr & ,
    const ASTPtr & partition,
    bool final,
    bool deduplicate,
    const Names & ,
    ContextPtr )
{
    if (partition)
        throw Exception("Partition cannot be specified when optimizing table of type Buffer", ErrorCodes::NOT_IMPLEMENTED);
    if (final)
        throw Exception("FINAL cannot be specified when optimizing table of type Buffer", ErrorCodes::NOT_IMPLEMENTED);
    if (deduplicate)
        throw Exception("DEDUPLICATE cannot be specified when optimizing table of type Buffer", ErrorCodes::NOT_IMPLEMENTED);
    flushAllBuffers(false, true);
    return true;
}
bool StorageBuffer::supportsPrewhere() const