org.hibernate.exception.SQLGrammarException: JDBC exception executing SQL [SELECT * FROM table_with_double_arrays t WHERE the_array IS NOT DISTINCT FROM ?] [ERROR: operator does not exist: double precision[] = real[]
Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
Position: 58] [n/a]
at app//org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:89)
at app//org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:56)
at app//org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:108)
at app//org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:94)
at app//org.hibernate.sql.results.jdbc.internal.DeferredResultSetAccess.executeQuery(DeferredResultSetAccess.java:252)
at app//org.hibernate.sql.results.jdbc.internal.DeferredResultSetAccess.getResultSet(DeferredResultSetAccess.java:164)
at app//org.hibernate.sql.results.jdbc.internal.AbstractResultSetAccess.getMetaData(AbstractResultSetAccess.java:36)
at app//org.hibernate.sql.results.jdbc.internal.AbstractResultSetAccess.getColumnCount(AbstractResultSetAccess.java:52)
at app//org.hibernate.query.results.ResultSetMappingImpl.resolve(ResultSetMappingImpl.java:193)
at app//org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.resolveJdbcValuesSource(JdbcSelectExecutorStandardImpl.java:478)
at app//org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.doExecuteQuery(JdbcSelectExecutorStandardImpl.java:267)
at app//org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.executeQuery(JdbcSelectExecutorStandardImpl.java:168)
at app//org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.list(JdbcSelectExecutorStandardImpl.java:93)
at app//org.hibernate.sql.exec.spi.JdbcSelectExecutor.list(JdbcSelectExecutor.java:31)
at app//org.hibernate.query.sql.internal.NativeSelectQueryPlanImpl.performList(NativeSelectQueryPlanImpl.java:102)
at app//org.hibernate.query.sql.internal.NativeQueryImpl.doList(NativeQueryImpl.java:621)
at app//org.hibernate.query.spi.AbstractSelectionQuery.list(AbstractSelectionQuery.java:367)
at app//org.hibernate.query.spi.AbstractSelectionQuery.getSingleResult(AbstractSelectionQuery.java:461)
at app//org.hibernate.orm.test.type.DoubleArrayTest.lambda$testNativeQuery$6(DoubleArrayTest.java:134)
at app//org.hibernate.testing.transaction.TransactionUtil2.inSession(TransactionUtil2.java:35)
at app//org.hibernate.testing.junit4.BaseNonConfigCoreFunctionalTestCase.inSession(BaseNonConfigCoreFunctionalTestCase.java:575)
at app//org.hibernate.orm.test.type.DoubleArrayTest.testNativeQuery(DoubleArrayTest.java:127)
Caused by:
com.edb.util.PSQLException: ERROR: operator does not exist: double precision[] = real[]
Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
Position: 58
at app//com.edb.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2946)
at app//com.edb.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2500)
at app//com.edb.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:508)
at app//com.edb.jdbc.PgStatement.executeInternal(PgStatement.java:528)
at app//com.edb.jdbc.PgStatement.execute(PgStatement.java:442)
at app//com.edb.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:403)
at app//com.edb.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:347)
at app//org.hibernate.sql.results.jdbc.internal.DeferredResultSetAccess.executeQuery(DeferredResultSetAccess.java:240)
... 17 more