[Maintenance][Umbrella] Breaking changes introduced by Calcite engine (V3)

[LantaoJin]

This issue is an Umbrella issue for recording breaking changes introduced by Calcite engine (V3). The context is duplicated to #3248 (comment).

Breaking behavior in 3.0+ introduced by Calcite Integration ( from 3.0.0-beta )

• [FEATURE] Return value of regexp function should be boolean instead of integer in V3 #3453
• [BUG] timestampdiff return wrong schema in V2 #3475
• [BUG] like function behaviour in V2 is not correct #3428
• [BUG] Sum multiple null values should return null instead of 0 #3408
• [BUG] Cast_to_boolean behaviour is different in OpenSearch SQL and Spark SQL #3443
• [BUG] Some math functions return types are different between V2 and V3 #3479
• [BUG] Return type of count() and dc() should be Long instead of Integer #3486
• [BUG] percentile returns wrong value in V2 #3495
• [BUG] Mismatch in documented and actual function argument types #3494