DB::Exception: Missing columns

[heyboV]

I have a SQL such like
select 1 as c0 from ( select C.字段AS字段from ( select 2 as bb) A LEFT JOIN ( select '1' as字段) C ON 1 = 1 LEFT JOIN ( select 1 as a) D ON 1 = 1) asT0whereT0.字段 = '1'
I got a Missing columns Error.

When I replace all Chinese characters with English characters, the SQL works。

In addition, When I change the alias with some other Chinese characters that different to column name, the SQL also works.

Clickhouse Server version is ClickHouse 23.2.3.17.
Is it a bug?
Thanks!

[Alex-Cheng]

It should be a bug, I can produce it too and I cannot find a workaround yet.

[den-crane]

@Alex-Cheng provide a repro

[Alex-Cheng]

https://fiddle.clickhouse.com/4ab4f391-34b0-42f1-97b0-7e7a5a3b0e0b
or
https://fiddle.clickhouse.com/dcd1a076-f0cb-4937-abd4-91d642bb6ce1

If the alias is all ASCII code, it works well. The issue occur when the alias is Unicode（non-ascii character）, such as ＄