When using multiple data sources, if an error occurs when querying one of the data sources, the SQL of the other data sources cannot automatically switch dialects to generate SQL

[SoaringCode]

Caused by: org.postgresql.util.PSQLException: ERROR: LIMIT #,# syntax is not supported
建议：Use separate LIMIT and OFFSET clauses.
位置：420
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2733)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2420)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:372)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:517)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:434)
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:194)
at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:180)
at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:497)
at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:65)
at com.mybatisflex.core.mybatis.FlexStatementHandler.query(FlexStatementHandler.java:101)
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:65)
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:336)
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:158)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:110)
at com.github.pagehelper.util.ExecutorUtil.pageQuery(ExecutorUtil.java:215)
at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:161)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:59)
at jdk.proxy2/jdk.proxy2.$Proxy275.query(Unknown Source)

[abel533]

https://github.com/pagehelper/Mybatis-PageHelper/blob/master/src/main/java/com/github/pagehelper/dialect/helper/PostgreSqlDialect.java

The dialect needs to be configured as postgresql.

[abel533]

helperDialect=postgresql

https://github.com/pagehelper/Mybatis-PageHelper/blob/master/wikis/en/HowToUse.md

[SoaringCode]

helperDialect=postgresql

https://github.com/pagehelper/Mybatis-PageHelper/blob/master/wikis/en/HowToUse.md

We use multiple data sources, but when querying PostgreSQL's data pagination using MySQL as the main data source, an error occurs and we are unable to continue executing

[LSL1618]

dynamic data sources in Spring and connect different types of databases
https://github.com/pagehelper/Mybatis-PageHelper/blob/master/wikis/en/HowToUse.md#scene-5