[Bug] 文本类型小数无法使用bigint转数值，decimal(38,0) + decimal(38,8)的情况下会返回整数

[Jinxv1007]

Search before asking

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

Version

2.1.5

What's Wrong?

文本类型小数无法使用bigint转数值

decimal(38,0) + decimal(38,8)的情况下会返回整数

What You Expected?

CAST("123.123" AS BIGINT) 能返回123而不是null;
CAST(123 AS DECIMAL(38,0))+CAST(123.123 AS DECIMAL(38,8) 返回小数而不是整数

How to Reproduce?

No response

Anything Else?

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[Mryange]

CAST("123.123" AS BIGINT) 能返回123而不是null;

#38847
在这个pr里面支持了，但是没有合入到2.1的分支，合进了3.0.
之前的cast string to int的行为类似pg，比较严格。
https://dbfiddle.uk/OsHBViAA

[spihiker]

SELECT CAST(123.123 AS BIGINT);