go-gorm / gorm

The fantastic ORM library for Golang, aims to be developer friendly
https://gorm.io
MIT License
37.02k stars 3.94k forks source link

db.save() is not behaving as expected when updating #7262

Open mintesnotAfework opened 2 weeks ago

mintesnotAfework commented 2 weeks ago

when i use to udpate a table called users it using the db.save(&user{}) it generate incorrect sql command for postgres sql which contain two users statement.

2024/11/01 20:52:57 .../models/userModel.go:123 ERROR: table name "users" specified more than once (SQLSTATE 42712) [7.572ms] [rows:1] UPDATE "users" SET "created_at"='2024-11-01 19:53:50.361',"updated_at"='2024-11-01 20:52:57.627',"user_name"='xrake2',"first_name"='abc',"last_name"='efc',"middle_name"=cdf',"email"='abc@gmail.co',"password"='$2a$12$E5qebklNRD5qH2QWySI1kugfrpR1.0By/5gGWEtEMXUxAma1LVAga',"user_type"='USER' FROM "users" WHERE ID=1 AND "users"."deleted_at" IS NULL AND "id" = 1

github-actions[bot] commented 2 weeks ago

The issue has been automatically marked as stale as it missing playground pull request link, which is important to help others understand your issue effectively and make sure the issue hasn't been fixed on latest master, checkout https://github.com/go-gorm/playground for details. it will be closed in 30 days if no further activity occurs. if you are asking question, please use the Question template, most likely your question already answered https://github.com/go-gorm/gorm/issues or described in the document https://gorm.ioSearch Before Asking