[
https://issues.apache.org/jira/browse/CALCITE-317?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Julian Hyde resolved CALCITE-317.
---------------------------------
Resolution: Works for Me
> ClassCastException reading from MySQL TINYINT(4) column
> -------------------------------------------------------
>
> Key: CALCITE-317
> URL: https://issues.apache.org/jira/browse/CALCITE-317
> Project: Calcite
> Issue Type: Bug
> Reporter: Julian Hyde
> Priority: Major
>
> Reading from a TINYINT(4) column in a MySQL table, accessed via the JDBC
> adapter, we an exception:
> {code:sql}
> create table t2 (x tinyint(4), y int);
> insert into t2 values (1, 1);
> select "x" from "t2";
> {code}
> {quote}
> Caused by: java.lang.RuntimeException: Error while executing command
> net.hydromatic.optiq.tools.SqlRun$CheckResultCommand@1dde4cb2
> at
> net.hydromatic.optiq.tools.SqlRun$CompositeCommand.execute(SqlRun.java:679)
> at net.hydromatic.optiq.tools.SqlRun.execute(SqlRun.java:103)
> ... 28 more
> Caused by: java.lang.ClassCastException: java.lang.Integer cannot be cast to
> java.lang.Byte
> at Baz$1$1.current(Unknown Source)
> at
> net.hydromatic.optiq.runtime.ObjectEnumeratorCursor$ObjectEnumeratorGetter.getObject(ObjectEnumeratorCursor.java:60)
> at
> net.hydromatic.optiq.runtime.AbstractCursor$AccessorImpl.getObject(AbstractCursor.java:280)
> at
> net.hydromatic.optiq.runtime.AbstractCursor$AccessorImpl.getString(AbstractCursor.java:223)
> at
> net.hydromatic.avatica.AvaticaResultSet.getString(AvaticaResultSet.java:205)
> {quote}
> A different exception if the table has just one column.
> {code:sql}
> create table t1 (x tinyint(4));
> insert into t1 values (1);
> select "x" from "t1";
> {code}
> {quote}
> > Caused by: java.lang.ClassCastException: [Ljava.lang.Object; cannot be cast
> > to java.lang.Comparable
> > at
> > net.hydromatic.optiq.impl.clone.ColumnLoader.load(ColumnLoader.java:215)
> > at
> > net.hydromatic.optiq.impl.clone.ColumnLoader.<init>(ColumnLoader.java:103)
> {quote}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
