Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-27764 Feature Parity between PostgreSQL and Spark
  3. SPARK-30000

Trim the string when cast string type to decimals

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 3.0.0
    • 3.0.0
    • SQL
    • None

    Description

      https://bugs.openjdk.java.net/browse/JDK-8170259
      https://bugs.openjdk.java.net/browse/JDK-8170563

      When we cast string type to decimal type, we rely on java.math. BigDecimal. It can't accept leading and training spaces, as you can see in the above links. This behavior is not consistent with other numeric types now. we need to fix it and keep consistency.

      Attachments

        Issue Links

          is a clone of

          Sub-task - The sub-task of the issue SPARK-28023 Trim the string when cast string type to other types

          • Major - Major loss of function.
          • Resolved
          is duplicated by

          Sub-task - The sub-task of the issue SPARK-29980 Whitespaces handling for Cast and BinaryOperation between StringType and NumericTypes

          • Major - Major loss of function.
          • Resolved
          is related to

          Sub-task - The sub-task of the issue SPARK-27931 Accept 'on' and 'off' as input for boolean data type

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. SPARK-25098 Trim the string when cast stringToTimestamp and stringToDate

          • Major - Major loss of function.
          • Resolved
          links to

          Web Link GitHub Pull Request #24872

          Web Link GitHub Pull Request #26622

          Web Link GitHub Pull Request #26640

          Activity

            People

              Qin Yao Kent Yao 2
              Qin Yao Kent Yao 2
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: