This is an automated email from the ASF dual-hosted git repository.
peacewong pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/linkis.git
The following commit(s) were added to refs/heads/master by this push:
new ead682223 fix pg bug (#4833)
ead682223 is described below
commit ead682223d02af3aec0f6d0c18ede0753e1359f0
Author: sjgllgh <[email protected]>
AuthorDate: Fri Jul 28 14:24:04 2023 +0800
fix pg bug (#4833)
---
.../src/main/resources/mapper/postgresql/LabelManagerMapper.xml | 6 ++++--
1 file changed, 4 insertions(+), 2 deletions(-)
diff --git
a/linkis-computation-governance/linkis-manager/linkis-manager-persistence/src/main/resources/mapper/postgresql/LabelManagerMapper.xml
b/linkis-computation-governance/linkis-manager/linkis-manager-persistence/src/main/resources/mapper/postgresql/LabelManagerMapper.xml
index c9614ed60..653df3daa 100644
---
a/linkis-computation-governance/linkis-manager/linkis-manager-persistence/src/main/resources/mapper/postgresql/LabelManagerMapper.xml
+++
b/linkis-computation-governance/linkis-manager/linkis-manager-persistence/src/main/resources/mapper/postgresql/LabelManagerMapper.xml
@@ -216,8 +216,10 @@
</select>
<delete id="deleteLabelResourceByByTicketId">
- <!-- delete from linkis_cg_manager_label_resource A,
linkis_cg_manager_linkis_resources B where A.resource_id = B.id and
B.ticketId=#{ticketId} -->
- delete from linkis_cg_manager_label_resource USING
linkis_cg_manager_label_resource A join linkis_cg_manager_linkis_resources B on
A.resource_id = B.id and B."ticketId"=#{ticketId}
+ DELETE FROM linkis_cg_manager_label_resource a
+ USING linkis_cg_manager_linkis_resources b
+ WHERE a.resource_id = b.id
+ AND b."ticketId" = #{ticketId}
</delete>
<delete id="deleteLabelIdsAndInstance">
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
