[
https://issues.apache.org/jira/browse/CALCITE-4271?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Julian Hyde reassigned CALCITE-4271:
------------------------------------
Assignee: Julian Hyde
> RelBuilder.in should allow duplicate values
> -------------------------------------------
>
> Key: CALCITE-4271
> URL: https://issues.apache.org/jira/browse/CALCITE-4271
> Project: Calcite
> Issue Type: Bug
> Reporter: Julian Hyde
> Assignee: Julian Hyde
> Priority: Major
>
> Currently, {{RelBuilder.in(e, constant(1), constant(2), constant(1))}}
> throws, as follows:
> {noformat}
> java.lang.IllegalArgumentException: Ranges may not overlap, but received
> [1..1] and [1..1]
> at
> com.google.common.base.Preconditions.checkArgument(Preconditions.java:146)
> at
> com.google.common.collect.ImmutableRangeSet$Builder.add(ImmutableRangeSet.java:585)
> at org.apache.calcite.rex.RexBuilder.toSarg(RexBuilder.java:1374)
> at org.apache.calcite.rex.RexBuilder.makeIn(RexBuilder.java:1310)
> at org.apache.calcite.tools.RelBuilder.in(RelBuilder.java:612)
> {noformat}
> Since the SQL expression {{e IN (1, 2, 1)}} is valid, the corresponding call
> to {{RelBuilder.in}} should be valid also.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
