gatorsmile commented on issue #24872: [SPARK-28023][SQL] Trim the string when cast string type to Boolean/Numeric types URL: https://github.com/apache/spark/pull/24872#issuecomment-509442950 We are unable to 100% match the semantics of PostgreSQL. Adding the extra `trim` for the Boolean/Numeric type casting will impact the perf of a common operation, although it is not high. Based on the above discussions, it might not be worth it to support this corner case. I think, in the future, we can add the PostgreSQL-compatible mode for supporting all the corner cases. This effort will be big. If we decide to add it, it might need 1000+ JIRAs and PRs.
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
