You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Julian Hyde (JIRA)" <ji...@apache.org> on 2014/10/28 18:54:34 UTC

[jira] [Resolved] (CALCITE-397) "SELECT DISTINCT *" gives ClassCastException at runtime

     [ https://issues.apache.org/jira/browse/CALCITE-397?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Julian Hyde resolved CALCITE-397.
---------------------------------
       Resolution: Fixed
    Fix Version/s: 0.9.2-incubating

Fixed in http://git-wip-us.apache.org/repos/asf/incubator-calcite/commit/1f91bbf8.

> "SELECT DISTINCT *" gives ClassCastException at runtime
> -------------------------------------------------------
>
>                 Key: CALCITE-397
>                 URL: https://issues.apache.org/jira/browse/CALCITE-397
>             Project: Calcite
>          Issue Type: Bug
>            Reporter: Julian Hyde
>            Assignee: Julian Hyde
>             Fix For: 0.9.2-incubating
>
>
> 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)