[jira] [Created] (FLINK-13651) table api not support cast to decimal with precision and scale

[Shang Yuanchun (Jira)]

Zhenghua Gao created FLINK-13651:
------------------------------------

             Summary: table api not support cast to decimal with precision and scale
                 Key: FLINK-13651
                 URL: https://issues.apache.org/jira/browse/FLINK-13651
             Project: Flink
          Issue Type: Bug
          Components: Table SQL / Planner
    Affects Versions: 1.9.0, 1.10.0
            Reporter: Zhenghua Gao


could reproduce in  ScalarFunctionsTest:

`testAllApis(
  'f31.cast(DataTypes.DECIMAL(38, 18)).truncate(2),
  "f31.cast(DECIMAL(10, 10)).truncate(2)",
  "truncate(cast(f31 as decimal(38, 18)), 2)",
  "-0.12")`

 

A possible reason is LookupCallResolver treat decimal(38, 18) as a function call.



--
This message was sent by Atlassian JIRA
(v7.6.14#76016)