JerryZ521 opened a new issue, #38305: URL: https://github.com/apache/shardingsphere/issues/38305
I tried using the MySQL driver to access the backend PostgreSQL database through the proxy, but it was unsuccessful. version：5.5.2 global config： `mode: type: Standalone repository: type: JDBC props: provider: H2 jdbc_url: jdbc:h2:mem:config;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MYSQL username: test password: Test@9876 authority: users: - user: root@% password: QFTKyBr9Q4AKnnA admin: true privilege: type: ALL_PERMITTED props: proxy-frontend-database-protocol-type: MySQL proxy-frontend-ssl-mode: disabled sql-show: true sql-simple: false sql-federation-enabled: true` db config： `databaseName: vh_pg dataSources: vh_pg: url: jdbc:postgresql://10.4.241.41:5432/vh?serverTimezone=Asia/Shanghai&stringtype=unspecified&databaseType=postgresql username: admin password: 6786868 connectionTimeoutMilliseconds: 30000 idleTimeoutMilliseconds: 60000 maxLifetimeMilliseconds: 1800000 maxPoolSize: 50 minPoolSize: 1 rules: !SINGLE defaultDataSource: vh_pg tables: "." !SQL_TRANSLATOR type: NATIVE useOriginalSQLWhenTranslatingFailed: true` logs： [INFO ] 2026-02-14 07:15:16.068 [ShardingSphere-Command-0] ShardingSphere-SQL - Logic SQL: /* ApplicationName=DBeaver 25.0.0 - SQLEditor <Script-12.sql> */ SELECT count(1) FROM a_task LIMIT 0, 200 [INFO ] 2026-02-14 07:15:16.068 [ShardingSphere-Command-0] ShardingSphere-SQL - Actual SQL: vh_pg ::: /* ApplicationName=DBeaver 25.0.0 - SQLEditor <Script-12.sql> */ SELECT count(1) FROM a_task LIMIT 0, 200 [ERROR] 2026-02-14 07:15:16.083 [ShardingSphere-Command-0] o.a.s.p.f.c.CommandExecutorTask - Exception occur: org.postgresql.util.PSQLException: ERROR: LIMIT #,# syntax is not supported Hint: Use separate LIMIT and OFFSET clauses. Position: 110 a_task table： CREATE TABLE a_task ( id BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, t_info JSONB NOT NULL ); PG Version：16 proxy runtime libs about Translator： <img width="537" height="189" alt="Image" src="https://github.com/user-attachments/assets/ad3350e7-6ef6-4f1d-992e-6d25d3fd8de5"; /> proxy init info： <img width="1338" height="132" alt="Image" src="https://github.com/user-attachments/assets/9d1c73f4-2a49-4f46-91eb-9e76135fdebb"; /> SHOW SQL_TRANSLATOR RULE： <img width="533" height="111" alt="Image" src="https://github.com/user-attachments/assets/13839a82-d2e4-4ab4-92c9-c790a400320f"; /> -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
