From ecd5b465c09b92f598786508f1457d0aba1fc694 Mon Sep 17 00:00:00 2001
From: gongchunyi <deslre0381@gmail.com>
Date: 星期三, 14 一月 2026 11:53:33 +0800
Subject: [PATCH] fix:偏差预警查询SQL去除多余的逗号
---
inspect-server/src/main/resources/mapper/InsProductDeviationWarningMapper.xml | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/inspect-server/src/main/resources/mapper/InsProductDeviationWarningMapper.xml b/inspect-server/src/main/resources/mapper/InsProductDeviationWarningMapper.xml
index ab44e9e..42ac779 100644
--- a/inspect-server/src/main/resources/mapper/InsProductDeviationWarningMapper.xml
+++ b/inspect-server/src/main/resources/mapper/InsProductDeviationWarningMapper.xml
@@ -25,7 +25,7 @@
isa.model AS sample_model,
io.ifs_inventory_id,
CONCAT(ip.inspection_item, ip.inspection_item_subclass) AS inspection_item_name,
- sto.object_type,
+ sto.object_type
FROM ins_product_deviation_warning ipdw
LEFT JOIN ins_sample isa ON isa.id = ipdw.ins_sample_id
LEFT JOIN ins_product ip ON ip.id = ipdw.ins_product_id
--
Gitblit v1.9.3