CTE join BUG

[h1k]

Describe the unexpected behaviour
When a CTE expression is used to associate multiple tables, an exception is thrown, indicating that the table does not exist

How to reproduce

• Which ClickHouse server version to use
  v23.3.18.15-lts

create table t  (ID UInt8) Engine= Memory() ;
insert into t values(1),(2),(3);
with a as (select 1 as column_a) , b as (select 2 as column_b) 
  select * FROM remote('127.0.0.{1,2}', default, t) as c
  inner join a on ID=column_a inner join b on ID=column_b

Expected behavior
Normal query

Error message and/or stacktrace
DB::Exception: Table default.a does not exist. Maybe you meant default.t?. (UNKNOWN_TABLE)

Additional context
Tried multiple versions in fiddle.clickhouse.com and all throw exception
https://fiddle.clickhouse.com/8d772c06-7026-4725-be20-710db3f7db56