JerryZ521 opened a new issue, #38043:
URL: https://github.com/apache/shardingsphere/issues/38043
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
);`
--
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]
