bug: update from ConstantTableScan panic

[forsaken628]

Search before asking

• I had searched in the issues and found no similar issues.

Version

b444c5b

What's Wrong?

databend_common_tracing::panic_hook: panic_hook.rs:56 panicked at src/query/expression/src/evaluator.rs:124:13:
assertion left == right failed: column data type mismatch at index: 1, expr: if(CAST(_predicate (#18446744073709551615) AS Boolean NULL), CAST(tbb.col1 (#8) AS String NULL), tba.col1 (#0))
left: Nullable(String)
right: String

How to Reproduce?

create or replace table test_merge(
col1 varchar,
col2 varchar,
col3 varchar
);
insert into test_merge values(2,'abc',2),(3,'abc',3),(4,'abc',4);

set error_on_nondeterministic_update = 0;

with tbb("col1", "col2", "col3") as (values ('1', 'add', '11'), ('4', 'add', '44'))
update test_merge tba set tba.col1 =tbb.col1, tba.col2 = 'update', tba.col3 = tbb.col3 from tbb where tba.col1 = tbb.col1;

Are you willing to submit PR?

• Yes I am willing to submit a PR!