Mihai Budiu created CALCITE-6322: ------------------------------------ Summary: Casts to DECIMAL types are ignored Key: CALCITE-6322 URL: https://issues.apache.org/jira/browse/CALCITE-6322 Project: Calcite Issue Type: Bug Components: core Affects Versions: 1.36.0 Reporter: Mihai Budiu
The following SqlOperatorTest fails: {code:java} f.checkScalar("CAST(1.123 AS DECIMAL(4, 0))", "1.0", "DECIMAL(4, 0) NOT NULL"); {code} 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. -- This message was sent by Atlassian Jira (v8.20.10#820010)