dylanhz created FLINK-38108:
-------------------------------

             Summary: Incorrect conversion from Java BigDecimal to SQL DECIMAL
                 Key: FLINK-38108
                 URL: https://issues.apache.org/jira/browse/FLINK-38108
             Project: Flink
          Issue Type: Bug
          Components: Table SQL / API
            Reporter: dylanhz


{code:java}
// Table API
tableEnv.fromValues(new BigDecimal("0.011")).printSchema();
> DECIMAL(5, 3) NOT NULL

// SQL
tableEnv.executeSql("SELECT TYPEOF(0.011)").print();
> DECIMAL(4, 3) NOT NULL
{code}

This issue is caused by incorrect precision conversion in the Table API.

By the way, this issue has been discussed before, but the actions taken did not 
resolve the problem. 
[FLINK-36378|https://issues.apache.org/jira/browse/FLINK-36378]





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

Reply via email to