[jira] [Created] (CALCITE-5901) Compiler should not accept DECIMAL types with precision < scale

["Mihai Budiu (Jira)" <ji...@apache.org>]

Mihai Budiu created CALCITE-5901:
------------------------------------

             Summary: Compiler should not accept DECIMAL types with precision < scale
                 Key: CALCITE-5901
                 URL: https://issues.apache.org/jira/browse/CALCITE-5901
             Project: Calcite
          Issue Type: Bug
          Components: core
    Affects Versions: 1.35.0
            Reporter: Mihai Budiu


The following test, when added to to SqlOperatorTest, passes:

{code:java}
f.checkScalar("cast(0.012 as DECIMAL(2, 5))", new  BigDecimal("0.012"), "DECIMAL(2, 5) NOT NULL");
{code}

However, according to the SQL standard "The <scale> of an <exact numeric type> shall not be greater than the <precision> of the <exact numeric type>." In this case the precision is 2 and the scale is 5.

So I would expect this test to fail. The validator should reject such types. I think that this change would affect quite a few tests.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)