[hibernate-issues] [JIRA] (HHH-16342) operator does not exist: double precision[] = real[] on EnterpriseDB

Martin Simka ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiYzhhMTE3YWQx... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16342?atlOrigin=eyJpIjoiYzhhMT... ) HHH-16342 ( https://hibernate.atlassian.net/browse/HHH-16342?atlOrigin=eyJpIjoiYzhhMT... ) operator does not exist: double precision[] = real[] on EnterpriseDB ( https://hibernate.atlassian.net/browse/HHH-16342?atlOrigin=eyJpIjoiYzhhMT... ) Issue Type: Bug Affects Versions: 6.2.0.CR4 Assignee: Unassigned Components: hibernate-core, testsuite Created: 21/Mar/2023 07:08 AM Environment: Hibernate ORM 6.2.0.CR4 + EnterpriseDB 14.4 + EDB JDBC Connector 42.5.0.1 + extra connection parameters: `preparedStatementCacheQueries=0&escapeSyntaxCallMode=callIfNoReturn` Priority: Major Reporter: Martin Simka ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) DoubleArrayTest fails with EnterpriseDB 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 ( https://hibernate.atlassian.net/browse/HHH-16342#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16342#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=Em... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100218- sha1:518c67a )