search for: select_limited_ids_list

...ce the new query returns a lot more rows since articles.created_at is pretty much different all the time. So, I used to get a list of 10 authors. Now depending on how many articles each author has, I get about 2. In active records changelog I see the following commit for 1.14.3: Associations#select_limited_ids_list adds the ORDER BY columns to the SELECT DISTINCT List for postgresql. [Rick] And looking through the code in activerecord-1.14.4/lib/active_record/associations.rb I see where and why that is happening (I''m ordering by a field not in the model''s table). But what I don''t...

...nce the new query returns a lot more rows since articles.created_at is pretty much different all the time. So, I used to get a list of 10 authors. Now depending on how many articles each author has, I get about 2. In active records changelog I see the following commit for 1.14.3: Associations#select_limited_ids_list adds the ORDER BY columns to the SELECT DISTINCT List for postgresql. [Rick] And looking through the code in activerecord-1.14.4/lib/active_record/associations.rb I see where and why that is happening (I''m ordering by a field not in the model''s table). But what I don''t...

...' called for #<Array:0x31da378> RAILS_ROOT: ./script/../config/.. Application Trace | Framework Trace | Full Trace active_record/associations.rb:964:in`include_eager_conditions?'' :952:in`construct_finder_sql_for_association_limiting'' active_record/associations.rb:946:in`select_limited_ids_list'' active_record/associations.rb:939:in`add_limited_ids_condition!'' :929:in`construct_finder_sql_with_included_associations'' active_record/associations.rb:917:in`select_all_rows'' active_record/associations.rb:830:in`find_with_associations'' active_record/ba...

..._unit.rb:71:in `execute'' ./test/../lib/active_record/connection_adapters/sqlserver_adapter.rb:517:in `select'' ./test/../lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `select_all'' ./test/../lib/active_record/associations.rb:1319:in `select_limited_ids_list'' ./test/../lib/active_record/associations.rb:1311:in `add_limited_ids_condition!'' ./test/../lib/active_record/associations.rb:1299:in `construct_finder_sql_with_included_associations'' ./test/../lib/active_record/associations.rb:1287:in `select_all_rows'...

Skipped content of type multipart/alternative-------------- next part -------------- Index: connection_adapters/abstract/connection_specification.rb =================================================================== --- connection_adapters/abstract/connection_specification.rb (revision 4617) +++ connection_adapters/abstract/connection_specification.rb (working copy) @@ -1,10 +1,21 @@ require

...rb:176:in `select_all'' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.0/lib/ active_record/connection_adapters/abstract/database_statements.rb: 23:in `select_values'' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.0/lib/ active_record/associations.rb:1147:in `select_limited_ids_list'' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.0/lib/ active_record/associations.rb:1141:in `add_limited_ids_condition!'' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.0/lib/ active_record/associations.rb:1131:in `construct_finder_sql_with_included_associa...

...ot;, "post_id"=>5, "id"=>10}>]> expected but was <[#<SpecialComment:0x45f696f8 @attributes={"body"=>"go crazy", "type"=>"SpecialComment", "post_id"=>7, "id"=>11}>]>. 3) Error: test_select_limited_ids_list(HasAndBelongsToManyAssociationsTest): ActiveRecord::StatementInvalid: OCIError: ORA-01791: not a SELECTed expression: SELECT DISTINCT projects.id FROM projects LEFT OUTER JOIN developers_projects ON developers_projects.project_id = projects.id LEFT OUTER JOIN developers ON developers.id = develop...