[ISSUE-3451] pgsql “like” syntax bug fixed. (#3506)
Co-authored-by: benjobs <benjobx@gmail.com>
diff --git a/streampark-console/streampark-console-service/src/main/resources/mapper/core/ApplicationMapper.xml b/streampark-console/streampark-console-service/src/main/resources/mapper/core/ApplicationMapper.xml
index 41ee5f1..2f968a3 100644
--- a/streampark-console/streampark-console-service/src/main/resources/mapper/core/ApplicationMapper.xml
+++ b/streampark-console/streampark-console-service/src/main/resources/mapper/core/ApplicationMapper.xml
@@ -150,10 +150,10 @@
and t.execution_mode = #{app.executionMode}
</if>
<if test="app.jobName != null and app.jobName != ''">
- and t.job_name like concat('%', CAST(#{app.jobName} AS CHAR), '%')
+ and t.job_name like concat('%', '${app.jobName}', '%')
</if>
<if test="app.projectName != null and app.projectName != ''">
- and p.name like concat('%', CAST(#{app.projectName} AS CHAR), '%')
+ and p.name like concat('%', '${app.projectName}', '%')
</if>
<if test="app.appId != null and app.appId != ''">
and t.app_id = #{app.appId}
@@ -172,7 +172,7 @@
</foreach>
</if>
<if test="app.tags != null and app.tags != ''">
- and t.tags like concat('%', CAST(#{app.tags} AS CHAR), '%')
+ and t.tags like concat('%', '${app.tags}', '%')
</if>
</where>
</select>
diff --git a/streampark-console/streampark-console-service/src/main/resources/mapper/core/ProjectMapper.xml b/streampark-console/streampark-console-service/src/main/resources/mapper/core/ProjectMapper.xml
index ca651f9..e69136e 100644
--- a/streampark-console/streampark-console-service/src/main/resources/mapper/core/ProjectMapper.xml
+++ b/streampark-console/streampark-console-service/src/main/resources/mapper/core/ProjectMapper.xml
@@ -82,7 +82,7 @@
<where>
t.team_id = #{project.teamId}
<if test="project.name != null and project.name != ''">
- and t.name like concat('%', CAST(#{project.name} AS CHAR), '%')
+ and t.name like concat('%', '${project.name}', '%')
</if>
<if test="project.buildState != null">
and t.build_state = #{project.buildState}
diff --git a/streampark-console/streampark-console-service/src/main/resources/mapper/core/ResourceMapper.xml b/streampark-console/streampark-console-service/src/main/resources/mapper/core/ResourceMapper.xml
index 7f476a3..5322bb5 100644
--- a/streampark-console/streampark-console-service/src/main/resources/mapper/core/ResourceMapper.xml
+++ b/streampark-console/streampark-console-service/src/main/resources/mapper/core/ResourceMapper.xml
@@ -42,10 +42,10 @@
on v.creator_id = u.user_id
and v.team_id = ${resource.teamId}
<if test="resource.resourceName != null and resource.resourceName != ''">
- and v.resourceName like concat('%', CAST(#{resource.resourceName} AS CHAR), '%')
+ and v.resourceName like concat('%', '${resource.resourceName}', '%')
</if>
<if test="resource.description != null and resource.description != ''">
- and v.description like concat('%', CAST(#{resource.description} AS CHAR), '%')
+ and v.description like concat('%', '${resource.description}', '%')
</if>
</select>
diff --git a/streampark-console/streampark-console-service/src/main/resources/mapper/core/VariableMapper.xml b/streampark-console/streampark-console-service/src/main/resources/mapper/core/VariableMapper.xml
index 7f77e11..8a6cd73 100644
--- a/streampark-console/streampark-console-service/src/main/resources/mapper/core/VariableMapper.xml
+++ b/streampark-console/streampark-console-service/src/main/resources/mapper/core/VariableMapper.xml
@@ -38,10 +38,10 @@
on v.creator_id = u.user_id
and v.team_id = ${variable.teamId}
<if test="variable.description != null and variable.description != ''">
- and v.description like concat('%', CAST(#{variable.description} AS CHAR), '%')
+ and v.description like concat('%', '${variable.description}', '%')
</if>
<if test="variable.variableCode != null and variable.variableCode != ''">
- and v.variable_code like concat('%', CAST(#{variable.variableCode} AS CHAR), '%')
+ and v.variable_code like concat('%', '${variable.variableCode}', '%')
</if>
</select>
@@ -61,7 +61,7 @@
<where>
team_id = #{teamId}
<if test="keyword != null and keyword != ''">
- and variable_code like concat('%', CAST(#{keyword} AS CHAR), '%') or description like concat('%', CAST(#{keyword} AS CHAR), '%')
+ and variable_code like concat('%', '${keyword}', '%') or description like concat('%', '${keyword}', '%')
</if>
</where>
</select>
diff --git a/streampark-console/streampark-console-service/src/main/resources/mapper/core/YarnQueueMapper.xml b/streampark-console/streampark-console-service/src/main/resources/mapper/core/YarnQueueMapper.xml
index af9b539..3ec49ac 100644
--- a/streampark-console/streampark-console-service/src/main/resources/mapper/core/YarnQueueMapper.xml
+++ b/streampark-console/streampark-console-service/src/main/resources/mapper/core/YarnQueueMapper.xml
@@ -33,7 +33,7 @@
team_id = #{yarnQueue.teamId}
</if>
<if test="yarnQueue.queueLabel != null and yarnQueue.queueLabel != ''">
- and queue_label like concat('%', CAST(#{yarnQueue.queueLabel} AS CHAR), '%')
+ and queue_label like concat('%', '${yarnQueue.queueLabel}', '%')
</if>
<if test="yarnQueue.createTimeFrom != null and yarnQueue.createTimeFrom !=''">
and create_time > #{yarnQueue.createTimeFrom}
diff --git a/streampark-console/streampark-console-service/src/main/resources/mapper/system/MemberMapper.xml b/streampark-console/streampark-console-service/src/main/resources/mapper/system/MemberMapper.xml
index f4a1a83..40f2b41 100644
--- a/streampark-console/streampark-console-service/src/main/resources/mapper/system/MemberMapper.xml
+++ b/streampark-console/streampark-console-service/src/main/resources/mapper/system/MemberMapper.xml
@@ -51,7 +51,7 @@
<where>
tur.team_id = ${member.teamId}
<if test="member.userName != null and member.userName != ''">
- and u.username like concat('%', CAST(#{member.userName} AS CHAR), '%')
+ and u.username like concat('%', '${member.userName}', '%')
</if>
<if test="member.roleName != null and member.roleName != ''">
and r.role_name = ${member.roleName}
diff --git a/streampark-console/streampark-console-service/src/main/resources/mapper/system/RoleMapper.xml b/streampark-console/streampark-console-service/src/main/resources/mapper/system/RoleMapper.xml
index d5d1322..078181b 100644
--- a/streampark-console/streampark-console-service/src/main/resources/mapper/system/RoleMapper.xml
+++ b/streampark-console/streampark-console-service/src/main/resources/mapper/system/RoleMapper.xml
@@ -29,7 +29,7 @@
select * from t_role
<where>
<if test="role.roleName != null and role.roleName != ''">
- and role_name like concat('%', CAST(#{role.roleName} AS CHAR), '%')
+ and role_name like concat('%', '${role.roleName}', '%')
</if>
<if test="role.createTimeFrom != null and role.createTimeFrom !=''">
and create_time > #{role.createTimeFrom}
diff --git a/streampark-console/streampark-console-service/src/main/resources/mapper/system/TeamMapper.xml b/streampark-console/streampark-console-service/src/main/resources/mapper/system/TeamMapper.xml
index 0b15412..a09de5b 100644
--- a/streampark-console/streampark-console-service/src/main/resources/mapper/system/TeamMapper.xml
+++ b/streampark-console/streampark-console-service/src/main/resources/mapper/system/TeamMapper.xml
@@ -29,7 +29,7 @@
select * from t_team
<where>
<if test="team.teamName != null and team.teamName != ''">
- and team_name like concat('%', CAST(#{team.teamName} AS CHAR), '%')
+ and team_name like concat('%', '${team.teamName}', '%')
</if>
<if test="team.createTimeFrom != null and team.createTimeFrom !=''">
and create_time > #{team.createTimeFrom}
diff --git a/streampark-console/streampark-console-service/src/main/resources/mapper/system/UserMapper.xml b/streampark-console/streampark-console-service/src/main/resources/mapper/system/UserMapper.xml
index 20b83f6..3e8f158 100644
--- a/streampark-console/streampark-console-service/src/main/resources/mapper/system/UserMapper.xml
+++ b/streampark-console/streampark-console-service/src/main/resources/mapper/system/UserMapper.xml
@@ -38,7 +38,7 @@
select * from t_user
<where>
<if test="user.username != null and user.username != ''">
- and username like concat('%', CAST(#{user.username} AS CHAR), '%')
+ and username like concat('%', '${user.username}', '%')
</if>
<if test="user.createTimeFrom != null and user.createTimeFrom !=''">
and create_time > #{user.createTimeFrom}