[Bug] [Connector-V2]字段存在但是报： Unknown column

[zheng594]

Search before asking

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

What happened

{ "password": "****", "driver": "com.mysql.cj.jdbc.Driver", "query": "select id as id,area_code as area_code,area_name as area_name from test.lwx_test04", "where_condition": "where create_time >'2024-11-11 11:00:00'", "fetch_size": 10000, "compatible_mode": "doris", "plugin_name": "Jdbc", "user": "user", "url": "url" } 上述配置报：ErrorCode:[JDBC-04], ErrorDescription:[Connector database failed] - open() failed.errCode = 2, detailMessage = Unknown column 'create_time' in 'table list' at…… 实际上create_time字段是存在的。 将 ： "query": "select id as id,area_code as area_code,area_name as area_name from test.lwx_test04", "where_condition": "where create_time >'2024-11-11 11:00:00'", 合并改成： "query": "select id as id,area_code as area_code,area_name as area_name from test.lwx_test04 where create_time >'2024-11-11 11:00:00", sql能正常执行。 后续原因是create_time字段在query所在select字段中不存在所以报错，这个应该是一个bug

SeaTunnel Version

V2.3.8

SeaTunnel Config

none

Running Command

none

Error Exception

ErrorCode:[JDBC-04], ErrorDescription:[Connector database failed] - open() failed.errCode = 2, detailMessage = Unknown column 'create_time' in 'table list' at……

Zeta or Flink or Spark Version

No response

Java or Scala Version

No response

Screenshots

No response

Are you willing to submit PR?

• [ ] Yes I am willing to submit a PR!

Code of Conduct

• [ ] I agree to follow this project's Code of Conduct