Gorm gorm v1 and v2 is incompatible (db=db.Where())

Your Question

v1:

v2:

v2 result: {"level":"DEBUG","time":"2022-05-30 17:40:29","caller":"mysql/user.go:17","message":"Database Query","sql":"SELECT * FROM users WHERE 1 = 1 AND 1 = 2 ","time":"47.249ms","rows":0} {"level":"DEBUG","time":"2022-05-30 17:40:29","caller":"mysql/user.go:20","message":"Database Query","sql":"SELECT * FROM users WHERE 1 = 1 AND 1 = 2 AND 2 = 3 ","time":"46.799ms","rows":0}

The document you expected this should be explained

Expected answer

Comment From: li-jin-gou

可以参考 https://gorm.cn/zh_CN/docs/method_chaining.html#%E6%96%B9%E6%B3%95%E9%93%BE%E5%92%8C%E5%8D%8F%E7%A8%8B%E5%AE%89%E5%85%A8

 GORM 复用 Statement 这可能会引发预期之外的问题

这个也是 V1 和 V2 的一个 break change https://gorm.cn/zh_CN/docs/v2_release_note.html#%E6%96%B9%E6%B3%95%E9%93%BE%E5%92%8C%E5%8D%8F%E7%A8%8B%E5%AE%89%E5%85%A8