[Bug] [pgsql] 配置自定义sql的时候，表名解析有误

[codeAdun]

Search before asking

• I had searched in the issues and found no similar issues.

What happened

数据源：pgsql ，配置的schema是 inter，不是默认的public

自动义：inter.表名，当自定义sql带前缀的时候 最终会解析成 inter.inter.表名，导致表名验证失败

DataVines Version

无

DataVines Config

"sources": [
        {
            "plugin": "jdbc",
            "type": "source",
            "config": {
                "src_connector_type": "postgresql",
                "schema": "inter",
                "password": "******",
                "database": "inter",
                "driver": "org.postgresql.Driver",
                "user": "xxxx",
                "output_table": "mid_flt_price_ivs",
                "table": "inter.inter.mid_flt_price_ivs",
                "url": "jdbc:postgresql://xxx:5432/inter"
            }
        }
    ],

Running Command

无

Error Exception

1、加inter：com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: FATAL: database "inter" does not exist

2、不加inter：sql解析错误

Engine Type

No response

Java Version

No response

Screenshots

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!

[xxzuo]

How is your database configured?

[codeAdun]

[zixi0825]

那你自定义sql里面不要inter，sql解析报错是什么？

[codeAdun]

那你自定义sql里面不要inter，sql解析报错是什么？

不加inter：
[INFO] 2026-05-19 14:30:17.887 [JobExecutionUniqueId=JOB-20260519-client_local_52:[42] - local engine execute job execution [52]
[INFO] 2026-05-19 14:30:17.915 [JobExecutionUniqueId=JOB-20260519-client_local_52:[90] - transform sql is: select max(flt_date)-current_date as actual_value_5cb10397 from mid_flt_price_ivs where flt_date between current_date and current_date+100;, transform_type is : actual_value
[ERROR] 2026-05-19 14:30:17.933 [JobExecutionUniqueId=JOB-20260519-client_local_52:[109] - transform execute error:
org.postgresql.util.PSQLException: ERROR: relation "mid_flt_price_ivs" does not exist
位置：65
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2468)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2211)

脚本预览：
"sources": [
{
"plugin": "jdbc",
"type": "source",
"config": {
"src_connector_type": "postgresql",
"schema": "inter",
"password": "******",
"database": "rms_xx",
"driver": "org.postgresql.Driver",
"user": "postgres",
"output_table": "mid_flt_price_ivs",
"table": "rms_hu.inter.mid_flt_price_ivs",
"url": "jdbc:postgresql://xxx:5432/rms_xx"
}
}
],

加inter：
日志：
[INFO] 2026-05-19 14:18:03.320 [JobExecutionUniqueId=JOB-20260519-client_local_51:[42] - local engine execute job execution [51]
[ERROR] 2026-05-19 14:18:04.360 [JobExecutionUniqueId=JOB-20260519-client_local_51:[111] - check table inter.inter.mid_flt_price_ivs exists error :
com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: FATAL: database "inter" does not exist
at com.zaxxer.hikari.pool.HikariPool.throwPoolInitializationException(HikariPool.java:596)
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:582)
at com.zaxxer.hikari.pool.HikariPool.(HikariPool.java:115)
at com.zaxxer.hikari.HikariDataSource.(HikariDataSource.java:81)
脚本预览：
"sources": [
{
"plugin": "jdbc",
"type": "source",
"config": {
"src_connector_type": "postgresql",
"schema": "inter",
"password": "******",
"database": "inter",
"driver": "org.postgresql.Driver",
"user": "postgres",
"output_table": "mid_flt_price_ivs",
"table": "inter.inter.mid_flt_price_ivs",
"url": "jdbc:postgresql://xxxx:5432/inter"
}
}
],