update_at time is not consistent

[AWaterColorPen]

GORM Playground Link

go-gorm/playground#288

Description

For example:
when we call updates method, user.update_at is "2021-02-26 20:47:16.823720459Z" .
But the UPDATE sql uses "update_at"="2021-02-26 20:47:16.824Z", and SELECT sql uses "update_at"="2021-02-26 20:47:16.823Z"

update_at is not consistent.

I think update_at should be consistent. And it should be no error for this case

[jinzhu]

Should use &user to Update

[AWaterColorPen]

@jinzhu hope reopen this issue.
Updated code. It still got error on mysql

2021/03/10 12:32:03 /home/runner/work/playground/playground/main_test.go:14
[10.449ms] [rows:1] INSERT INTO `users` (`created_at`,`updated_at`,`deleted_at`,`name`,`age`,`birthday`,`company_id`,`manager_id`,`active`) VALUES ('2021-03-10 12:32:03.353','2021-03-10 12:32:03.353',NULL,'jinzhu',0,NULL,NULL,NULL,false)

2021/03/10 12:32:03 /home/runner/work/playground/playground/main_test.go:16
[2.513ms] [rows:1] UPDATE `users` SET `created_at`='2021-03-10 12:32:03.353',`updated_at`='2021-03-10 12:32:03.363',`name`='jinzhu' WHERE `id` = 1

2021/03/10 12:32:03 /home/runner/work/playground/playground/main_test.go:21 record not found
[0.908ms] [rows:0] SELECT * FROM `users` WHERE `users`.`id` = 1 AND `users`.`created_at` = '2021-03-10 12:32:03.353' AND `users`.`updated_at` = '2021-03-10 12:32:03.363' AND `users`.`name` = 'jinzhu' AND `users`.`deleted_at` IS NULL LIMIT 1
    main_test.go:22: Failed, got error: record not found
--- FAIL: TestGORM (0.01s)

[jinzhu]

because mysql's time's precision issue, you can change gorm.Config's NowFunc to func() time.Time { return time.Now().Local().Round(time.Millisecond) }

[AWaterColorPen]

Thanks for the solution.
BTW, is it possible to fix the mysql's time's precision issue at gorm.io/driver/sqlite by default? or set func() time.Time { return time.Now().Local().Round(time.Millisecond) } to gorm.Config.NowFunc by default when dbType is mysql?

[jinzhu]

Processed it by default, needs to use the latest GORM master and mysql v1.0.5