Unexpected SQL Query Generation with Consecutive First Calls about gorm HOT 5 CLOSED

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.io ✨ Search Before Asking ✨

from gorm.

Maybe is work as expected?
add one line between the two calls will solve your Immediately after problem:

user.ID = 0

from gorm.

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.io ✨ Search Before Asking ✨

from gorm.

Maybe is work as expected? add one line between the two calls will solve your Immediately after problem:

user.ID = 0

db.First(&user, 1)
log.Println(user)
user.ID = 0
db.First(&user, "1")
log.Println(user)

Indeed get the expected results！

Reason: When executing a query like db.First(&user, 1), the field ID of the user structure is filled with values retrieved from the database. If the same user instance is used again in consecutive queries without resetting its state, such as if user.ID has been set to a specific non-zero value, GORM may treat this ID value as an implicit query condition.

Thank you!

from gorm.

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.io ✨ Search Before Asking ✨

from gorm.