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;