[Bug] The cast function does not convert string to int as expected

[yongjinhou]

Search before asking

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

Version

2.0.11 & master

What's Wrong?

select cast("123.123" as tinyint)
实际值: None
期望值: 123

select cast("123.123" as smallint)
实际值: None
期望值: 123

select cast("123.123" as int)
实际值: None
期望值: 123

select cast("123.123" as bigint)
实际值: None
期望值: 123

What You Expected?

输出符合期望值

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

[morrySnow]

should not change this behavior. becaues be return null when do cast('123.123' as int). we should let fe return same result with be