Mercurial > hgrepos > hgweb.cgi > s4

changeset 834:a87030974b99

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Detect defference between src/dest table using EXCEPT.
author HIROSE Yuuji <yuuji@gentei.org>
date Tue, 23 Jun 2020 11:14:44 +0900
parents f3d422665ea8
children fa23017ba273
files s4-world.sh
diffstat 1 files changed, 2 insertions(+), 6 deletions(-) [+]
line wrap: on
line diff
--- a/s4-world.sh	Mon Jun 22 18:53:43 2020 +0900
+++ b/s4-world.sh	Tue Jun 23 11:14:44 2020 +0900
@@ -93,12 +93,8 @@
 DELETE FROM main.user_m WHERE rowid NOT IN (SELECT rowid FROM m.user_m);
 REPLACE INTO main.user_m(rowid, name, key, type, val, bin)
 	SELECT rowid,* FROM m.user_m
-	WHERE user_m.name	!= m.user_m.name
-	   OR user_m.key	!= m.user_m.key
-	   OR user_m.type	!= m.user_m.type
-	   OR user_m.val	!= m.user_m.val
-	   OR length(user_m.bin)!= length(m.user_m.bin)
-	;
+	   EXCEPT
+	SELECT rowid,* FROM main.user_m;
 END;
 
 /* Compare user tables */

yatex.org