[Bug] [API] Query task instance error

[wangbowen1024]

Search before asking

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

What happened

i use pg to save ds, and i get error when search task instance name:

[ERROR] 2024-01-13 14:08:22.192 +0800 org.apache.dolphinscheduler.api.exceptions.ApiExceptionHandler:[52] - 分页查询任务列表错误
org.springframework.jdbc.BadSqlGrammarException: 
### Error querying database.  Cause: org.postgresql.util.PSQLException: ERROR: could not determine data type of parameter $3
### The error may exist in class path resource [org/apache/dolphinscheduler/dao/mapper/TaskInstanceMapper.xml]
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT COUNT(*) AS total FROM t_ds_task_instance WHERE project_code = ? AND task_execute_type = ? AND process_instance_name LIKE concat('%', ?, '%')
### Cause: org.postgresql.util.PSQLException: ERROR: could not determine data type of parameter $3
; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: could not determine data type of parameter $3

and i find all search will faild with

 like concat('%', #{xxx}, '%')

What you expected to happen

no error

How to reproduce

every time

Anything else

No response

Version

3.2.x

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

[github-actions]

Search before asking

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

What happened

i use pg to save ds, and i get error when search task instance name:

[ERROR] 2024-01-13 14:08:22.192 +0800 org.apache.dolphinscheduler.api.exceptions.ApiExceptionHandler:[52] - 分页查询任务列表错误
org.springframework.jdbc.BadSqlGrammarException: 
### Error querying database.  Cause: org.postgresql.util.PSQLException: ERROR: could not determine data type of parameter $3
### The error may exist in class path resource [org/apache/dolphinscheduler/dao/mapper/TaskInstanceMapper.xml]
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT COUNT(*) AS total FROM t_ds_task_instance WHERE project_code = ? AND task_execute_type = ? AND process_instance_name LIKE concat('%', ?, '%')
### Cause: org.postgresql.util.PSQLException: ERROR: could not determine data type of parameter $3
; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: could not determine data type of parameter $3

and i find all search will faild with

 like concat('%', #{xxx}, '%')

What you expected to happen

no error

How to reproduce

every time

Anything else

No response

Version

3.2.x

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

[wangbowen1024]

because i use param stringtype=unspecified in url:
jdbc:postgresql://IP:PORT/dolphinscheduler?stringtype=unspecified