### What is the problem the feature request solves? Spark has specific handling of overflows when ANSI mode is enabled and we need to add the same in Comet. ### Describe the potential solution _No response_ ### Additional context _No response_