ruby-on-rails - 对关联分页时将对缺少的 FROM 子句条目进行分页

Question

我使用 Rails 2.3.5、will_paginate-2.3.15 和 postgress。我有 2 个属于同一张表。如果我首先搜索属性，然后搜索别名表属性，则会抛出异常。如果我在有效的条件下颠倒顺序...

class House
  belongs_to :owner, :class => "User"
  belogns_to :creator, :class => "User"
end

House.paginate(
  :page=>1, 
  :include=>[:creator, :owner], 
  :per_page=>20, 
  :conditions=>"houses.city ILIKE E'%new yo%' and owners_houses.architect ILIKE E'%tom%'")

加薪

ActiveRecord::StatementInvalid: PGError: ERROR:  missing FROM-clause entry for table "owners_houses", 

in 记录没有加入 from 子句

这有效:

House.paginate(
  :page=>1, 
  :include=>[:creator, :owner], 
  :per_page=>20, 
  :conditions=>"owners_houses.architect ILIKE E'%tom%' and houses.city ILIKE E'%new yo%'")

这是 will_paginate 中的错误吗？为什么会发生这种情况？

Answer 1

检查development.log中为WORKING和NON WORKING语句生成的Sql查询