**How to reproduce**
Clickhouse Server 20.13
```
SELECT *
FROM url('https://storage.yandexcloud.net/my-test-bucket-768/data.csv.gz', 'CSV', 'column1 UInt32, column2 UInt32, column3 UInt32')
LIMIT 2

Query id: 31d85b1f-cc2a-41c4-978d-1fb09840d7b7

┌─column1─┬─column2─┬─column3─┐
│       1 │       2 │       3 │
│       3 │       2 │       1 │
└─────────┴─────────┴─────────┘

SELECT *
FROM url('https://storage.yandexcloud.net/my-test-bucket-768/data.csv.gz', 'CSV', 'column1 UInt32, column2 UInt32, column3 UInt32', auto)
LIMIT 2

Query id: 34742713-7a41-49ba-a2dd-713e6ddbbc00

┌─column1─┬─column2─┬─column3─┐
│       1 │       2 │       3 │
│       3 │       2 │       1 │
└─────────┴─────────┴─────────┘

SELECT *
FROM s3('https://storage.yandexcloud.net/my-test-bucket-768/data.csv.gz', 'CSV', 'column1 UInt32, column2 UInt32, column3 UInt32', auto)
LIMIT 2

Query id: 6d3975a2-07d6-48fc-8c22-5293eb42c380


Received exception from server (version 20.13.1):
Code: 27. DB::Exception: Received from localhost:9000. DB::Exception: Cannot parse input: expected ',' before: '�\b\bpg�_\0data.csv\03�1�1�2��\\f:@�e��\\\0�V>�\0\0\0'{}:
Row 1:
Column 0,   name: column1, type: UInt32, ERROR: text "<0x1F>�<BACKSPACE><BACKSPACE>pg�_<ASCII NUL><0x03>" is not like UInt32

: While executing S3.


SELECT *
FROM s3('https://storage.yandexcloud.net/my-test-bucket-768/data.csv.gz', 'CSV', 'column1 UInt32, column2 UInt32, column3 UInt32')
LIMIT 2

Query id: 5fbb23a1-9893-4b1a-a4b0-ffa36225e8bb


Received exception from server (version 20.13.1):
Code: 27. DB::Exception: Received from localhost:9000. DB::Exception: Cannot parse input: expected ',' before: '�\b\bpg�_\0data.csv\03�1�1�2��\\f:@�e��\\\0�V>�\0\0\0'{}:
Row 1:
Column 0,   name: column1, type: UInt32, ERROR: text "<0x1F>�<BACKSPACE><BACKSPACE>pg�_<ASCII NUL><0x03>" is not like UInt32

: While executing S3.


SELECT *
FROM s3('https://storage.yandexcloud.net/my-test-bucket-768/data.csv.gz', 'CSV', 'column1 UInt32, column2 UInt32, column3 UInt32', gz)
LIMIT 2

Query id: 7ce193ce-fd55-4369-be85-d59c83b0dfa8

┌─column1─┬─column2─┬─column3─┐
│       1 │       2 │       3 │
│       3 │       2 │       1 │
└─────────┴─────────┴─────────┘

```

**Expected behavior**
s3 table function would recognize compression from file extension.

**Additional context**
https://github.com/ClickHouse/ClickHouse/pull/7840#issuecomment-570837458

const S3::URI & uri_,
    const String & access_key_id_,
    const String & secret_access_key_,
    const StorageID & table_id_,
    const String & format_name_,
    UInt64 min_upload_part_size_,
    UInt64 max_single_part_upload_size_,
    UInt64 max_connections_,
    const ColumnsDescription & columns_,
    const ConstraintsDescription & constraints_,
    const Context & context_,
    const String & compression_method_)
    : IStorage(table_id_)
    , uri(uri_)
    , global_context(context_.getGlobalContext())
    , format_name(format_name_)
    , min_upload_part_size(min_upload_part_size_)
    , max_single_part_upload_size(max_single_part_upload_size_)
    , compression_method(compression_method_)
    , name(uri_.storage_name)