[jira] [Created] (CALCITE-4271) RelBuilder.in should allow duplicate values

["Julian Hyde (Jira)" <ji...@apache.org>]

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)