[
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)
