opengauss hibernate6异常

**Is this a BUG REPORT or FEATURE REQUEST?**:

- bug

**What happened**:

我从springboot2.x迁移到springboot3.x, hibernate升级到了6.1.7，执行分页sql查询出现如下异常。

```
sql = select distinct p.package_code as packageCode, p.package_name as packageName
 from p_package p
 where p.status in ('INTERNAL', 'INUSE') and p.using_flag = 'T'

NativeQuery query = (NativeQuery) entityManager.createNativeQuery(sql);
 query.setFirstResult(0)
                .setMaxResults(999)
                .getResultList();

Caused by: org.hibernate.exception.SQLGrammarException: JDBC exception executing SQL [select distinct p.package_code as packageCode, p.package_name as packageName
 from p_package p
 where p.status in ('INTERNAL', 'INUSE') and p.using_flag = 'T' fetch first ? rows only]
	at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:89) ~[hibernate-core-6.1.7.Final.jar:6.1.7.Final]
	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:56) ~[hibernate-core-6.1.7.Final.jar:6.1.7.Final]
	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109) ~[hibernate-core-6.1.7.Final.jar:6.1.7.Final]
	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:95) ~[hibernate-core-6.1.7.Final.jar:6.1.7.Final]
	at org.hibernate.sql.results.jdbc.internal.DeferredResultSetAccess.executeQuery(DeferredResultSetAccess.java:253) ~[hibernate-core-6.1.7.Final.jar:6.1.7.Final]
	at org.hibernate.sql.results.jdbc.internal.DeferredResultSetAccess.getResultSet(DeferredResultSetAccess.java:146) ~[hibernate-core-6.1.7.Final.jar:6.1.7.Final]
	at org.hibernate.sql.results.jdbc.internal.AbstractResultSetAccess.getMetaData(AbstractResultSetAccess.java:33) ~[hibernate-core-6.1.7.Final.jar:6.1.7.Final]
	at org.hibernate.sql.results.jdbc.internal.AbstractResultSetAccess.getColumnCount(AbstractResultSetAccess.java:49) ~[hibernate-core-6.1.7.Final.jar:6.1.7.Final]
	at org.hibernate.query.results.ResultSetMappingImpl.resolve(ResultSetMappingImpl.java:187) ~[hibernate-core-6.1.7.Final.jar:6.1.7.Final]
	at org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.resolveJdbcValuesSource(JdbcSelectExecutorStandardImpl.java:559) ~[hibernate-core-6.1.7.Final.jar:6.1.7.Final]
	at org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.doExecuteQuery(JdbcSelectExecutorStandardImpl.java:350) ~[hibernate-core-6.1.7.Final.jar:6.1.7.Final]
	at org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.executeQuery(JdbcSelectExecutorStandardImpl.java:166) ~[hibernate-core-6.1.7.Final.jar:6.1.7.Final]
	at org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.list(JdbcSelectExecutorStandardImpl.java:91) ~[hibernate-core-6.1.7.Final.jar:6.1.7.Final]
	at org.hibernate.sql.exec.spi.JdbcSelectExecutor.list(JdbcSelectExecutor.java:31) ~[hibernate-core-6.1.7.Final.jar:6.1.7.Final]
	at org.hibernate.query.sql.internal.NativeSelectQueryPlanImpl.performList(NativeSelectQueryPlanImpl.java:105) ~[hibernate-core-6.1.7.Final.jar:6.1.7.Final]
	at org.hibernate.query.sql.internal.NativeQueryImpl.doList(NativeQueryImpl.java:602) ~[hibernate-core-6.1.7.Final.jar:6.1.7.Final]
	at org.hibernate.query.spi.AbstractSelectionQuery.list(AbstractSelectionQuery.java:363) ~[hibernate-core-6.1.7.Final.jar:6.1.7.Final]
	... 110 common frames omitted
Caused by: org.opengauss.util.PSQLException: [127.0.0.1:56751/ocalhost/127.0.0.1:35432] ERROR: syntax error at or near "$1"
  位置：172
	at org.opengauss.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2901) ~[opengauss-jdbc-3.0.0.jar:na]
	at org.opengauss.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2630) ~[opengauss-jdbc-3.0.0.jar:na]
	at org.opengauss.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:362) ~[opengauss-jdbc-3.0.0.jar:na]
	at org.opengauss.jdbc.PgStatement.runQueryExecutor(PgStatement.java:562) ~[opengauss-jdbc-3.0.0.jar:na]
	at org.opengauss.jdbc.PgStatement.executeInternal(PgStatement.java:539) ~[opengauss-jdbc-3.0.0.jar:na]
	at org.opengauss.jdbc.PgStatement.execute(PgStatement.java:397) ~[opengauss-jdbc-3.0.0.jar:na]
	at org.opengauss.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:156) ~[opengauss-jdbc-3.0.0.jar:na]
	at org.opengauss.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:112) ~[opengauss-jdbc-3.0.0.jar:na]
	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52) ~[HikariCP-3.1.0.jar:na]
	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java) ~[HikariCP-3.1.0.jar:na]
	at org.hibernate.sql.results.jdbc.internal.DeferredResultSetAccess.executeQuery(DeferredResultSetAccess.java:217) ~[hibernate-core-6.1.7.Final.jar:6.1.7.Final]
	... 122 common frames omitted
```

**What you expected to happen**:
sql语句本身是可以执行的，可能是jdbc内部问题。

**How to reproduce it (as minimally and precisely as possible)**:
见代码片段

**Anything else we need to know?**:

**Environment**:
- Version: opengauss-jdbc-3.0.0.jar
- OS (e.g. from /etc/os-release): na
- Kernel (e.g. `uname -a`):na
- Install tools: na
- Others: na

openGauss/openGauss-connector-jdbc

内容风险标识

评论 (16)

openGauss/openGauss-connector-jdbc .gitee-modal { width: 500px !important; }

内容风险标识