remote() and a database name with a dot

[hczhcz]

Describe the unexpected behaviour
We can not access database with a name like a.b using remote() function

How to reproduce

create database `x.x`;
create table `x.x`.`x` ...;
select * from remote('localhost', 'x.x', 'x'); -- case 1: fail
select * from remote('localhost', 'x.x.x'); -- case 2: fail
select * from remote('localhost', '`x.x`.x'); -- case 3: fail

Expected behavior
Case 1 is expected to work. It will be good if case 3 could work too.

[qoega]

@vitlibar I remember you faced this problem with dictionaries. Will you fix it for remote also?

[4ertus2]

We should fix it but it's not a very good idea to use dots in db or table name in production. Dots are used for database and table split, table and column split, column and nested column split. All this things depends on context where the name is present. And sometimes we do not know the contexts.

[4ertus2]

Related #12527