[ErrorCode -9971]Cannot determine the return types of a query or return types are inconsistent 报错解决方案

当使用SQL查询表的时候，会遇到一下的问题。

org.jkiss.dbeaver.model.sql.DBSQLException: SQL 错误 [IX000]: Cannot determine the return types of a query or return types are inconsistent.
    at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:133)
    at org.jkiss.dbeaver.model.impl.jdbc.struct.JDBCTable.readData(JDBCTable.java:187)
    at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.lambda$0(ResultSetJobDataRead.java:123)
    at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:189)
    at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.run(ResultSetJobDataRead.java:121)
    at org.jkiss.dbeaver.ui.controls.resultset.ResultSetViewer$ResultSetDataPumpJob.run(ResultSetViewer.java:5101)
    at org.jkiss.dbeaver.model.runtime.AbstractJob.run(AbstractJob.java:105)
    at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63)
Caused by: java.sql.SQLException: Cannot determine the return types of a query or return types are inconsistent.
    at com.gbasedbt.util.IfxErrMsg.getSQLException(IfxErrMsg.java:408)
    at com.gbasedbt.jdbc.IfxSqli.a(IfxSqli.java:3572)
    at com.gbasedbt.jdbc.IfxSqli.D(IfxSqli.java:3852)
    at com.gbasedbt.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2738)
    at com.gbasedbt.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2663)
    at com.gbasedbt.jdbc.IfxSqli.a(IfxSqli.java:1896)
    at com.gbasedbt.jdbc.IfxSqli.executeExecute(IfxSqli.java:2591)
    at com.gbasedbt.jdbc.IfxSqli.executeExecute(IfxSqli.java:2546)
    at com.gbasedbt.jdbc.IfxResultSet.b(IfxResultSet.java:366)
    at com.gbasedbt.jdbc.IfxStatement.a(IfxStatement.java:1412)
    at com.gbasedbt.jdbc.IfxStatement.executeImpl(IfxStatement.java:1384)
    at com.gbasedbt.jdbc.IfxStatement.c(IfxStatement.java:1003)
    at com.gbasedbt.jdbc.IfxStatement.execute(IfxStatement.java:921)
    at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.execute(JDBCStatementImpl.java:330)
    at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:131)
    ... 7 more
Caused by: java.sql.SQLException
    at com.gbasedbt.util.IfxErrMsg.getSQLException(IfxErrMsg.java:408)
    at com.gbasedbt.jdbc.IfxSqli.D(IfxSqli.java:3857)
    ... 19 more

解决方案：

1.检查数据库驱动与数据库服务版本是否一致，这个是由于驱动版本与数据库服务端本版不一致导致的，更换驱动