# HG changeset patch
# User HIROSE Yuuji <yuuji@gentei.org>
# Date 1609644799 -32400
# Node ID d81dd0ed2d6d2316397c0cc5bbab8cdcfbe07c5e
# Parent  d9ecb727edcd5165f3e61afc3a16def191d99f4f
Add performance check logging.

diff -r d9ecb727edcd -r d81dd0ed2d6d s4-world.sh
--- a/s4-world.sh	Sun Jan 03 09:51:46 2021 +0900
+++ b/s4-world.sh	Sun Jan 03 12:33:19 2021 +0900
@@ -106,7 +106,7 @@
     esac
   fi
 ##  num=$(sqlite3 -bail -cmd 'PRAGMA FOREIGN_KEYS=on' $db <<EOF
-  num=$(query <<EOF
+  result=$(query <<EOF
 BEGIN;
 DElETE FROM main.user WHERE rowid NOT IN (SELECT rowid FROM m.user);
 INSERT INTO main.user(rowid, name)
@@ -123,17 +123,23 @@
 	   EXCEPT
 	SELECT rowid,* FROM main.user_m $SYNCCOND
 	;} /* SYNC_M closed here */
+SELECT 'OK';
 END;
-
+EOF
+	)
+  err "`gdate +%S.%3N` Update account tables finished with result=[$result]"
+  test x"$result" = x"OK" && num=$(query <<EOF
 /* Compare user tables */
 WITH master AS (
   SELECT p.rowid,* FROM m.user p
   			 NATURAL LEFT JOIN m.user_s
 	 ${SYNC_M:+	 NATURAL LEFT JOIN m.user_m}
+  $SYNCCOND
 ), thisworld AS (
   SELECT p.rowid,* FROM user p
 		  	NATURAL LEFT JOIN user_s
  	 ${SYNC_M:+	NATURAL LEFT JOIN user_m}
+  $SYNCCOND
 ), m_a AS (
   SELECT * FROM master EXCEPT SELECT * FROM thisworld
 ), a_m AS (