[ https://issues.apache.org/jira/browse/FLINK-16577?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jark Wu reassigned FLINK-16577: ------------------------------- Assignee: godfrey he > Exception will be thrown when computing columnInterval relmetadata in some > case > ------------------------------------------------------------------------------- > > Key: FLINK-16577 > URL: https://issues.apache.org/jira/browse/FLINK-16577 > Project: Flink > Issue Type: Bug > Components: Table SQL / Planner > Affects Versions: 1.10.0 > Reporter: Shuo Cheng > Assignee: godfrey he > Priority: Major > Fix For: 1.11.0 > > Attachments: image-2020-03-13-10-32-35-375.png, > image-2020-03-13-10-38-17-001.png > > > Consider the following SQL > > {code:java} > // a: INT, c: LONG > SELECT > c, SUM(a) > FROM T > WHERE a > 0.1 AND a < 1 > GROUP BY c{code} > > Here the sql type of 0.1 is Decimal and 1 is Integer, and they are both in > NUMERIC type family, and do not trigger type coercion, so the plan is: > {code:java} > FlinkLogicalAggregate(group=[{0}], EXPR$1=[SUM($1)]) > +- FlinkLogicalCalc(select=[c, a], where=[AND(>(a, 0.1:DECIMAL(2, 1)), <(a, > 1))]) > +- FlinkLogicalTableSourceScan(table=[[...]], fields=[a, b, c]) > {code} > When we calculate the filtered column interval of calc, it'll lead to > validation exception of `FiniteValueInterval`: > !image-2020-03-13-10-32-35-375.png! -- This message was sent by Atlassian Jira (v8.3.4#803005)