DB.Clauses Where not work

[XiaoXiaoSN]

GORM Playground Link

go-gorm/playground#275

Description

DB.Clauses where not work

Postgres

except

INSERT INTO "users" ("created_at","updated_at","deleted_at","name","age","birthday","company_id","manager_id","active","id") 
VALUES ('2021-02-08 17:29:10.811','2021-02-08 17:29:10.811',NULL,'alice',18,NULL,NULL,NULL,false,1) 
ON CONFLICT ("id") DO  UPDATE SET "age"=20 WHERE "name" = 'bob'  RETURNING "id"

got

INSERT INTO "users" ("created_at","updated_at","deleted_at","name","age","birthday","company_id","manager_id","active","id") 
VALUES ('2021-02-08 17:29:10.811','2021-02-08 17:29:10.811',NULL,'alice',18,NULL,NULL,NULL,false,1) 
ON CONFLICT ("id") WHERE "name" = 'bob' DO UPDATE SET "age"=20 RETURNING "id"

mysql (update: MySQL doesn't support on duplicated with Where)

except

INSERT INTO `users` (`created_at`,`updated_at`,`deleted_at`,`name`,`age`,`birthday`,`company_id`,`manager_id`,`active`,`id`) 
VALUES ('2021-02-08 17:33:42.736','2021-02-08 17:33:42.736',NULL,'alice',18,NULL,NULL,NULL,false,1) 
ON DUPLICATE KEY UPDATE `age`=20 WHERE `name`='bob'

got

INSERT INTO `users` (`created_at`,`updated_at`,`deleted_at`,`name`,`age`,`birthday`,`company_id`,`manager_id`,`active`,`id`) 
VALUES ('2021-02-08 17:33:42.736','2021-02-08 17:33:42.736',NULL,'alice',18,NULL,NULL,NULL,false,1) 
ON DUPLICATE KEY UPDATE `age`=20

[jinzhu]

MySQL doesn't support on duplicated with Where

[XiaoXiaoSN]

But it is also incorrect in Postgres. I expect that WHERE statement is after UPDATE SET.

[jinzhu]

@XiaoXiaoSN Fixed this on latest master