How do you search for different conditions from the same join table?
With these associations only the magnification results returns the correct results, but when I try and search for the second association it will return 0 results.

    has_one :magnification,
      :class_name => 'ProductAttribute',
      :foreign_key => 'product_id',
      :conditions => {:key => 'Magnification'}
    has_one :objective_lens,
      :class_name => 'ProductAttribute',
      :foreign_key => 'product_id',
      :conditions => {:key => 'Objective Lens Diameter'}

    define_index do
      has magnification(:value), :type => :float, :as => :magnification
      has objective_lens(:value), :type => :float, :as => :objective_lens_diameter
    end

Sample Code Used

    # returns expected results
    Product.search(nil, :with => {:magnification => (8.0..9.0)})

    # returns 0 results
    Product.search(nil, :with => {:objective_lens_diameter => (31.0..61.0)})

But when I reverse the order of the define_index the opposite occurs. So the objective lens diameter results returns the right results and the magnification results returns 0.

Using Rails v2.2, Thinking-Sphinx as a plugin v1.2.12 and Sphinx 0.9.8
How do you search for different conditions from the same join table?
===

With these associations only the magnification results returns the correct results, but when I try and search for the second association it will return 0 results.

    has_one :magnification,
      :class_name => 'ProductAttribute',
      :foreign_key => 'product_id',
      :conditions => {:key => 'Magnification'}
    has_one :objective_lens,
      :class_name => 'ProductAttribute',
      :foreign_key => 'product_id',
      :conditions => {:key => 'Objective Lens Diameter'}

    define_index do
      has magnification(:value), :type => :float, :as => :magnification
      has objective_lens(:value), :type => :float, :as => :objective_lens_diameter
    end

Sample Code Used

    # returns expected results
    Product.search(nil, :with => {:magnification => (8.0..9.0)})

    # returns 0 results
    Product.search(nil, :with => {:objective_lens_diameter => (31.0..61.0)})

But when I reverse the order of the define_index the opposite occurs. So the objective lens diameter results returns the right results and the magnification results returns 0.

Using Rails v2.2, Thinking-Sphinx as a plugin v1.2.12 and Sphinx 0.9.8