Can't construct type from Float32(Float32) and Int64(Int64)

[hanyisong]

Is this a problem with my operation, or a feature to be improved.

CREATE DATABASE databend0;
USE databend0;
CREATE TABLE t0(c0 BIGINT NULL, c1 DOUBLE NULL DEFAULT(true));
CREATE TABLE t1(c0 FLOAT NULL);
SELECT SUM(count) FROM (SELECT ((false IS NOT NULL AND false) ::INT64)as count FROM t1 NATURAL LEFT JOIN t0) as res;

Code: 1010, displayText = Can't construct type from Float32(Float32) and Int64(Int64).

[BohuTANG]

cc @andylokandy

[sundy-li]

It's a bug. Let's convert to issue.

[Xuanwo]

Tracked in #7164. Let's mark this question as resolved. Thank @hanyisong for reporting.