Error backup with table '.inner.test_table'

[molchanovdp]

Hello!
Clickhouse version 19.1.8

When creating a backup request failed:

can't freeze partition '0590dc88487514d92e90360839939c5f' on 'default..inner.test_table' with: code: 62, message: Syntax error: failed at position 21: .inner.test_table FREEZE PARTITION ID '0590dc88487514d92e90360839939c5f';. Expected identifier

It may be worth escaping the name of the table with ``?

[AlexAkulov]

It's a good proposal!

[AlexAkulov]

Unfortunately it's not as easy as it seems.

[molchanovdp]

But I think it is worth doing it, otherwise quite often similar problems will arise. Here is another example, here the table name starts with a number. So it does not work either.

can't freeze partition '20170626' on 'default.2table' with: code: 62, message: Syntax error: failed at position 21: 2table FREEZE PARTITION ID '20170626';. Wrong number

[molchanovdp]

As I understand it, this is already fixed in the ba996f1
I checked and no errors occur

[AlexAkulov]

No. These changes fixed 'freeze' command but 'create' and 'restore' still don't work. This is related to how ClickhHouse encode special characters in paths on filesystem. For example, table with name '.table1' will be saved on FS as '%2Etable' but clickhouse-backup does't expect this.

[mrtarsa]

We experience the same problem. Any progress on this?

[AlexAkulov]

It must be fixed in v0.4.0. Please check it.