mysql - rails 4 : find by includes field

Question

在 Rails 3 中我有这样的查询:

Supporter.includes(:person).where("concat(club_member_number, ' ', people.surname, ' ',  people.name) LIKE ?", term)

但是在 Rails 4 中它会报错:

ActiveRecord::StatementInvalid Exception: Mysql2::Error: Unknown column 'person.surname'

如何更改查询以使其在 Rails 4 中工作？

Answer 1

尝试跟随

Supporter.eager_load(:person).where("concat(club_member_number, ' ', people.surname, ' ',  people.name) LIKE ?", term)

或使用 references(:person) 和 includes

Supporter.includes(:person).where("concat(club_member_number, ' ', people.surname, ' ',  people.name) LIKE ?", term).references(:person)

引用this