Gorm preload给出模棱两可的列错误

Question

我有以下结构

type Employee struct {
EmployeeID        int64  `gorm:"primary_key;column:employee_id"`
EmployeeCode      string `gorm:"column:employee_code"`
FirstName         string `gorm:"column:first_name"`
LastName          string `gorm:"column:last_name"`
DesignationID     int64  `gorm:"column:designation_id;"`
Designation       *Designation `gorm:"foreignkey:DesignationID"`
}
type Designation struct {
DesignationID   int64  `gorm:"primary_key;column:designation_id"`
DesignationName string `gorm:"column:designation_name"`
}
func GetEmployee(id int64) (*Employee, error) {
db := connection.GetConn() //get connection
defer db.Close()
employee := &Employee{}
err := db.Model(employees).Preload("Designation", func(db *gorm.DB) *gorm.DB {
return db.Join("INNER JOIN employees ON employees.designation_id = designations.id").Order("employees.first_name DESC")
}).Find(employee).Error
return employee, err
}

生成的查询是

SELECT * FROM employees;
SELECT * FROM designations INNER JOIN employees ON employees.designation_id = designations.id WHERE id IN (1,2) order by employees.first_name DESC;

我有一个连接，类似于我在上面的函数中所写的。这里我无法证明连接，但在实际情况下，我知道连接是必需的，预加载表和连接表都有id字段。由于两个表有相同的列名，即id，在这种情况下，MYSQL抛出错误:

Error 1052: Column 'id' in where clause is ambiguous

我在gorm v1.9.16面临这个问题

我没有发现任何资源提到类似的问题。我们如何解决这个问题?

Answer 1

你可以试试最新的版本吗(>v1.20.x) ?

问题已解决https://github.com/go-gorm/gorm/issues/2653

这个问题似乎在新版本中修复了https://github.com/go-gorm/gorm/commit/2ae0653af2bc19cd31f687e797b189c85f0ac3f6