OceanBase 数据库 V4.x 版本集群在执行 sum() over() 语法时，出现 ORA-00932: inconsistent datatypes 的原因和解决方法

ErrorCode = 932, SQLState = 22001, Details = ORA-00932: inconsistent datatypes

[2024-09-04 10:14:31.132228] WDIAG [SQL.ENG] calc_result_type2 (ob_expr_cast.cpp:352) [2935][T1002_L0_G0][T1002][xxxxx-xxxxx-xxxxx-xxxxx] [lt=6][errcode=-5083] transition does not support(src="INTERVAL_DAY_TO_SECOND", dst="NUMBER")
[2024-09-04 10:14:31.132240] WDIAG [SQL.RESV] calc_result_type (ob_raw_expr_deduce_type.cpp:477) [2935][T1002_L0_G0][T1002][xxxxx-xxxxx-xxxxx-xxxxx] [lt=11][errcode=-5083] calc result type2 failed(ret=-5083)
[2024-09-04 10:14:31.132244] WDIAG [SQL.RESV] visit (ob_raw_expr_deduce_type.cpp:2300) [2935][T1002_L0_G0][T1002][xxxxx-xxxxx-xxxxx-xxxxx] [lt=4][errcode=-5083] fail to calc result type(ret=-5083, types=[{meta:{type:"INTERVAL_DAY_TO_SECOND", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:-1, scale:20}, flag:1, calc_type:{type:"INTERVAL_DAY_TO_SECOND", collation:"binary", coercibility:"NUMERIC"}}, {meta:{type:"BIGINT", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:1, calc_type:{type:"BIGINT", collation:"binary", coercibility:"NUMERIC"}}])
[2024-09-04 10:14:31.132277] WDIAG [SQL.RESV] postorder_accept (ob_raw_expr.cpp:569) [2935][T1002_L0_G0][T1002][xxxxx-xxxxx-xxxxx-xxxxx] [lt=32][errcode=-5083] visit failed(ret=-5083, type=501, name="T_FUN_SYS_CAST")

[2024-09-04 10:14:31.132228] WDIAG [SQL.ENG] calc_result_type2 (ob_expr_cast.cpp:352) [2935][T1002_L0_G0][T1002][xxxxx-xxxxx-xxxxx-xxxxx] [lt=6][errcode=-5083] transition does not support(src="INTERVAL_DAY_TO_SECOND", dst="NUMBER")