Julian Hyde created CALCITE-4271:
------------------------------------
Summary: 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
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)
