Issue selecting multiple columns from related table in v10

[wavded]

I'm having an issue upgrading from v9 to v10. Before, I could select specific columns from the related table (this is a many2many) like so:

db.Model(record).
  Column("record.*"). // Select all columns from main table.
  Column("Related.id", "Related.name"). // Select specific columns from related table.
  WherePK().
  Select()

From my reading it seems like the replacement for this should be:

db.Model(record).
  Relation("Related", func(q *orm.Query) (*orm.Query, error) {
    return q.Column("id", "name"), nil
  }).
  WherePK().
  Select()

However this gives me warning such as "ERROR #42702 column reference "id" is ambiguous". What is the recommended way to select specific columns from a related table? Or is there a bug somewhere?

[wavded]

Note this is may be related to #1562

[wavded]

I was able to get the same or very similar behavior as v9 by doing the following. It produce a single query:

db.Model(record).
  Relation("Related.id").
  Relation("Related.name").
  WherePK().
  Select()

Given Relation doesn't take a spread of columns like Column did, I had to call Relation for every field.

[vmihailenco]

I would try:

    return q.Column("Related.id", "Related.name"), nil

or

    return q.Column("your_alias.id", "your_alias.name"), nil

Closing since there is no reproducer and guessing is no fun.

[rustjson]

I would try:

    return q.Column("Related.id", "Related.name"), nil

or

    return q.Column("your_alias.id", "your_alias.name"), nil

Closing since there is no reproducer and guessing is no fun.

This doesn't work 👎 , This is simply ADD two same field in the query, but the query already include all the fileds!