From 4ca77edbe07508f1bd4a878c7c00d7b7fbf0abb5 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期一, 12 六月 2023 13:57:34 +0800
Subject: [PATCH] 数据上传添加矢量数据入库的错误记录数

---
 data/update.sql |    4 ++--
 1 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/data/update.sql b/data/update.sql
index c2adf2f..a71e683 100644
--- a/data/update.sql
+++ b/data/update.sql
@@ -220,12 +220,12 @@
 -- 椤圭洰琛�
 select a.*,st_astext(geom) from bs.bs_project a;
 
--- 鎸夐」鐩粺璁℃暟鎹�
+-- 鎸夐」鐩粺璁℃暟鎹� *
 select name "鍚嶇О", (select count(*) from lf.sys_meta b where b.dircode like a.code || '%') "鏂囦欢鏁�",
 	(select sum(sizes) from lf.sys_meta b where b.dircode like a.code || '%') "鏁伴噺(MB)"
 from lf.sys_dir a where id > 1 and pid = 0;
 
-select name "m1", (select sum(sizes) from lf.sys_meta b where b.dircode like a.code || '%') "sizes",
+select name "m1", coalesce((select sum(sizes) from lf.sys_meta b where b.dircode like a.code || '%'), 0) "sizes",
 	(select count(*) from lf.sys_meta b where b.dircode like a.code || '%') "count"	
 from lf.sys_dir a where pid = 0 order by a.code;
 

--
Gitblit v1.9.3