Mercurial > hgrepos > hgweb.cgi > 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 wrap: on
line diff
--- a/s4-world.sh Sun Jan 03 12:33:19 2021 +0900 +++ b/s4-world.sh Sun Jan 03 13:37:20 2021 +0900 @@ -112,7 +112,8 @@ INSERT INTO main.user(rowid, name) SELECT rowid, name FROM m.user WHERE m.user.rowid NOT IN (SELECT rowid FROM user); -UPDATE user SET name = (SELECT name FROM m.user WHERE main.user.rowid=m.user.rowid); +/* PrimaryKey:name cannot be changed, but ensure the integrity of user */ +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); DELETE FROM main.user_s WHERE rowid NOT IN (SELECT rowid FROM m.user_s); REPLACE INTO main.user_s(rowid, name, key, type, val, bin) SELECT rowid,* FROM m.user_s;
