[jira] [Created] (OPTIQ-397) "SELECT DISTINCT *" gives ClassCastException at runtime

[Julian Hyde (JIRA)]

Julian Hyde created OPTIQ-397:
---------------------------------

             Summary: "SELECT DISTINCT *" gives ClassCastException at runtime
                 Key: OPTIQ-397
                 URL: https://issues.apache.org/jira/browse/OPTIQ-397
             Project: Optiq
          Issue Type: Bug
            Reporter: Julian Hyde
            Assignee: Julian Hyde


Given the query

{code:sql}
select distinct *
from "hr"."emps"
{code}

Optiq gives the error

{code}
Caused by: java.lang.ClassCastException: 
net.hydromatic.optiq.test.JdbcTest$Employee cannot be cast to 
[Ljava.lang.Object;
        at 
net.hydromatic.linq4j.function.Functions$ArrayEqualityComparer.hashCode(Functions.java:491)
        at 
net.hydromatic.linq4j.EnumerableDefaults$Wrapped.hashCode(EnumerableDefaults.java:2252)
        at java.util.HashMap.hash(HashMap.java:338)
        at java.util.HashMap.put(HashMap.java:611)
        at java.util.HashSet.add(HashSet.java:219)
        at 
net.hydromatic.linq4j.EnumerableDefaults.into(EnumerableDefaults.java:2120)
        at 
net.hydromatic.linq4j.DefaultEnumerable.into(DefaultEnumerable.java:325)
        at 
net.hydromatic.linq4j.EnumerableDefaults.distinct(EnumerableDefaults.java:405)
        at 
net.hydromatic.linq4j.DefaultEnumerable.distinct(DefaultEnumerable.java:193)
        at Baz.bind(Unknown Source)
        at 
net.hydromatic.optiq.jdbc.OptiqPrepare$PrepareResult.getEnumerable(OptiqPrepare.java:270)
{code}

Suspect that {{EnumerableAggregateRel}} is not generating its input record 
accessor correctly.

I'll add a test case {{JdbcTest.testSelectDistinctStar}} shortly.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)