2 comments (2 comments)0 reactions (0 reactions)0 assignees (0 assignees)Java9,451 stars (9,451 stars)3,886 forks (3,886 forks)batch import
help wanted
Description
pgsql驱动:42.3.3
连接数据库正常,但是使用navicat连接mycat客户端时,打开DataSource出现sql错误:
配置如下:

Contributor guide
- Tech stack
- javapostgresqlsql
- Domain
- databasebackend
- Issue type
- bug
- DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
- 3
- Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
- 1-2 days
- Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
- stale
- ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
- needs investigation
- Prerequisites
- Basic understanding of MycatPostgreSQL JDBC driver configurationJava debugging skills
- Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
- 35
- Research direction
- The issue describes an SQL error when connecting to Mycat via Navicat, with PostgreSQL 42.3.3 driver. To reproduce, set up Mycat 1.6.7.6 with PostgreSQL backend and connect using Navicat. Investigate the error message (likely a schema or query issue). Check Mycat logs and network traffic. Look at Mycat's PostgreSQL protocol handling code, possibly in source files like 'src/main/java/io/mycat/net/PostgreSQLPacket.java' or similar. The maintainers may need to clarify if this is a known incompatibility.