Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-6322

Casts to DECIMAL types are ignored

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 1.36.0
    • 1.37.0
    • core

    Description

      The following SqlOperatorTest fails:

      f.checkScalar("CAST(1.123 AS DECIMAL(4, 0))", "1.0", "DECIMAL(4, 0) NOT NULL");

      The result computed by Calcite is 1.123, ignoring the scale of the DECIMAL result.
      Spark, Postgres, MySQL all return 1.0.

      I have marked this as a major bug.

      Attachments

        Issue Links

          contains

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-5860 Decimal type conversion missing scale

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-6073 Documentation does not specify CAST behavior

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open
          relates to

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-6328 The BigQuery functions SAFE_* do not match the BigQuery specification

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-6324 Type inferred for result of STDDEV, VAR_SAMP, etc. is incorrect

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          links to

          Web Link GitHub Pull Request #3733

          Activity

            People

              Unassigned Unassigned
              mbudiu Mihai Budiu
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated: