[
https://issues.apache.org/jira/browse/CALCITE-4573?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Julian Hyde resolved CALCITE-4573.
----------------------------------
Fix Version/s: avatica-1.19.0
Resolution: Fixed
Fixed in
[03e69d24|https://github.com/apache/calcite-avatica/commit/03e69d2410e306f242ad449ed3d938967ee14dc0];
thanks for the PR, [~stupid_pig]!
> NullPointerException while fetching from a column of type ARRAY
> ---------------------------------------------------------------
>
> Key: CALCITE-4573
> URL: https://issues.apache.org/jira/browse/CALCITE-4573
> Project: Calcite
> Issue Type: Bug
> Components: avatica
> Affects Versions: avatica-1.17.0
> Reporter: chenyuzhi
> Priority: Major
> Labels: pull-request-available
> Fix For: avatica-1.19.0
>
> Time Spent: 20m
> Remaining Estimate: 0h
>
> When querying array-type column, it throws {{NullPointerException}}. Here is
> the log.
> {noformat}
> 2021-04-09 22:56:03.152 - Can't read column 'age_array'
> valuejava.lang.NullPointerException
> at
> org.apache.calcite.avatica.AvaticaResultSet.close(AvaticaResultSet.java:156)
> at
> org.jkiss.dbeaver.model.impl.jdbc.data.JDBCCollection.makeCollectionFromResultSet(JDBCCollection.java:339)
> at
> org.jkiss.dbeaver.model.impl.jdbc.data.JDBCCollection.makeCollectionFromArray(JDBCCollection.java:222)
> at
> org.jkiss.dbeaver.model.impl.jdbc.data.handlers.JDBCArrayValueHandler.getValueFromObject(JDBCArrayValueHandler.java:62)
> at
> org.jkiss.dbeaver.model.impl.jdbc.data.handlers.JDBCArrayValueHandler.getValueFromObject(JDBCArrayValueHandler.java:1)
> at
> org.jkiss.dbeaver.model.impl.jdbc.data.handlers.JDBCComplexValueHandler.fetchColumnValue(JDBCComplexValueHandler.java:50)
> at
> org.jkiss.dbeaver.model.impl.jdbc.data.handlers.JDBCAbstractValueHandler.fetchValueObject(JDBCAbstractValueHandler.java:49)
> at
> org.jkiss.dbeaver.ui.controls.resultset.ResultSetDataReceiver.fetchRow(ResultSetDataReceiver.java:122)
> at
> org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.fetchQueryData(SQLQueryJob.java:755)
> at
> org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeStatement(SQLQueryJob.java:484)
> at
> org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.lambda$0(SQLQueryJob.java:407)
> at
> org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:146)
> at
> org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeSingleQuery(SQLQueryJob.java:405)
> at
> org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.extractData(SQLQueryJob.java:849)
> at
> org.jkiss.dbeaver.ui.editors.sql.SQLEditor$QueryResultsContainer.readData(SQLEditor.java:2778)
> at
> org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.lambda$0(ResultSetJobDataRead.java:98)
> at
> org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:146)
> at
> org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.run(ResultSetJobDataRead.java:96)
> at org.jkiss.dbeaver.model.runtime.AbstractJob.run(AbstractJob.java:102)
> at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63)
> {noformat}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
