[Join] Illegal column Int64 of first argument of function toString

[zzcclp]

Execute the below sql:

select
	l_orderkey,
	o_orderdate,
  l_tax,
  l_returnflag,
  c_nationkey
from
	ch_customer,
	ch_orders,
	ch_lineitem
where
	c_custkey = o_custkey
	and l_orderkey = o_orderkey

throw the below error in clickhouse backend:

Right sample block: l_orderkey Int64 Int64(size = 0), l_tax Float64 Float64(size = 0), l_returnflag String String(size = 0)
project input: c_nationkey, o_orderkey, o_orderdate, l_tax, l_returnflag, l_orderkey
project input: c_nationkey, o_orderkey, o_orderdate, l_tax, l_returnflag, l_orderkey
Join type: key64, kind: Inner, strictness: All
Before join block: 'c_nationkey Int64 Int64(size = 0), o_orderkey Int64 Int64(size = 0), o_orderdate Date UInt16(size = 0)'
After join block: 'c_nationkey Int64 Int64(size = 0), o_orderkey Int64 Int64(size = 0), o_orderdate Date UInt16(size = 0), l_tax Float64 Float64(size = 0), l_returnflag String String(size = 0), l_orderkey Int64 Int64(size = 0)'
Before join block: 'c_nationkey Int64 Int64(size = 0), o_orderkey Int64 Int64(size = 0), o_orderdate Date UInt16(size = 0)'
After join block: 'c_nationkey Int64 Int64(size = 0), o_orderkey Int64 Int64(size = 0), o_orderdate Date UInt16(size = 0), l_tax Float64 Float64(size = 0), l_returnflag String String(size = 0), l_orderkey Int64 Int64(size = 0)'
build pipeline 0.053 ms; create executor 0.006 ms;
libc++abi: terminating with uncaught exception of type DB::Exception: Illegal column Int64 of first argument of function toString: while executing 'FUNCTION toString(o_orderdate :: 1) -> toString(o_orderdate) String : 0'

You have to provide the following information whenever possible.

Describe what's wrong

A clear and concise description of what works not as it is supposed to.

Does it reproduce on recent release?

The list of releases

Enable crash reporting

If possible, change "enabled" to true in "send_crash_reports" section in config.xml:

<send_crash_reports>
        <!-- Changing <enabled> to true allows sending crash reports to -->
        <!-- the ClickHouse core developers team via Sentry https://sentry.io -->
        <enabled>false</enabled>

How to reproduce

• Which ClickHouse server version to use
• Which interface to use, if matters
• Non-default settings, if any
• CREATE TABLE statements for all tables involved
• Sample data for all these tables, use clickhouse-obfuscator if necessary
• Queries to run that lead to unexpected result

Expected behavior

A clear and concise description of what you expected to happen.

Error message and/or stacktrace

If applicable, add screenshots to help explain your problem.

Additional context

Add any other context about the problem here.