s4

changeset 834:a87030974b99

find changesets by author, revision, files, or words in the commit message
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 diff
     1.1 --- a/s4-world.sh	Mon Jun 22 18:53:43 2020 +0900
     1.2 +++ b/s4-world.sh	Tue Jun 23 11:14:44 2020 +0900
     1.3 @@ -93,12 +93,8 @@
     1.4  DELETE FROM main.user_m WHERE rowid NOT IN (SELECT rowid FROM m.user_m);
     1.5  REPLACE INTO main.user_m(rowid, name, key, type, val, bin)
     1.6  	SELECT rowid,* FROM m.user_m
     1.7 -	WHERE user_m.name	!= m.user_m.name
     1.8 -	   OR user_m.key	!= m.user_m.key
     1.9 -	   OR user_m.type	!= m.user_m.type
    1.10 -	   OR user_m.val	!= m.user_m.val
    1.11 -	   OR length(user_m.bin)!= length(m.user_m.bin)
    1.12 -	;
    1.13 +	   EXCEPT
    1.14 +	SELECT rowid,* FROM main.user_m;
    1.15  END;
    1.16  
    1.17  /* Compare user tables */