[Bug] cast datetime to decimal gets wrong result

[zhiqiang-hhhh]

Search before asking

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

Version

master

What's Wrong?

select cast(c as decimal(30,9)) from (select cast("9999-12-31" as datetime) c) t3
--------------

+------------------------------+
| cast(c as DECIMALV3(30, 9))  |
+------------------------------+
| 703674110198153216.000000000 |
+------------------------------+
1 row in set (0.02 sec)

What You Expected?

select cast(c as decimal(30,9)) from (select cast("9999-12-31" as datetime) c) t3

cast(c as decimal(30,9))
99991231000000.000000000

How to Reproduce?

No response

Anything Else?

fix reference https://github.com/apache/doris/pull/32518

this will be an easy task

Are you willing to submit PR?

• [ ] Yes I am willing to submit a PR!

Code of Conduct

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

[AcKing-Sam]

@zhiqiang-hhhh I am willing to fix it :)

[zhiqiang-hhhh]

@AcKing-Sam maybe you can combine the fix of datetime to https://github.com/apache/doris/pull/32515

[AcKing-Sam]

@zhiqiang-hhhh Ok, thanks a lot!