s4
changeset 904:0352ff0fb37f
Suppress user.name update for unchanged values, which takes a lot time.
author | HIROSE Yuuji <yuuji@gentei.org> |
---|---|
date | Sun, 03 Jan 2021 13:37:20 +0900 |
parents | d81dd0ed2d6d |
children | 5acef432b1de |
files | s4-world.sh |
diffstat | 1 files changed, 2 insertions(+), 1 deletions(-) [+] |
line diff
1.1 --- a/s4-world.sh Sun Jan 03 12:33:19 2021 +0900 1.2 +++ b/s4-world.sh Sun Jan 03 13:37:20 2021 +0900 1.3 @@ -112,7 +112,8 @@ 1.4 INSERT INTO main.user(rowid, name) 1.5 SELECT rowid, name FROM m.user 1.6 WHERE m.user.rowid NOT IN (SELECT rowid FROM user); 1.7 -UPDATE user SET name = (SELECT name FROM m.user WHERE main.user.rowid=m.user.rowid); 1.8 +/* PrimaryKey:name cannot be changed, but ensure the integrity of user */ 1.9 +UPDATE user SET name = (SELECT name FROM m.user WHERE main.user.rowid=m.user.rowid) WHERE name != (SELECT name from m.user WHERE main.user.rowid=m.user.rowid); 1.10 DELETE FROM main.user_s WHERE rowid NOT IN (SELECT rowid FROM m.user_s); 1.11 REPLACE INTO main.user_s(rowid, name, key, type, val, bin) 1.12 SELECT rowid,* FROM m.user_s;