"bitsweat" has kicked AR/SQLServer while it was down...

http://dev.rubyonrails.org/changeset/7675
------------------------------------------------------------------------
r7675 | bitsweat | 2007-09-28 16:55:50 -0700 (Fri, 28 Sep 2007) | 1 line

Failing counter cache test. References #6896.
------------------------------------------------------------------------

U    activerecord\test\associations_test.rb
Updated to revision 7675.

  1) Error:
test_scoped_find_limit_offset_including_has_many_association(BasicsTest):
ActiveRecord::StatementInvalid: DBI::DatabaseError: Execute
    OLE error code:80040E14 in Microsoft OLE DB Provider for SQL Server
      Ambiguous column name 'id'.
    HRESULT error code:0x80020009
      Exception occurred.: SELECT topics.[id] AS t0_r0, topics.[title] AS 
t0_r1, topics.[author_name] AS t0_r2, topics.[author_email_address] AS t0_r3, 
topics.[written_on] AS t0_r4, topics.[bonus_time] AS t0_r5, topics.[last_read] 
AS t0_r6, topics.[content] AS t0_r7, topics.[approved] AS t0_r8, 
topics.[replies_count] AS t0_r9, topics.[parent_id] AS t0_r10, topics.[type] AS 
t0_r11, replies_topics.[id] AS t1_r0, replies_topics.[title] AS t1_r1, 
replies_topics.[author_name] AS t1_r2, replies_topics.[author_email_address] AS 
t1_r3, replies_topics.[written_on] AS t1_r4, replies_topics.[bonus_time] AS 
t1_r5, replies_topics.[last_read] AS t1_r6, replies_topics.[content] AS t1_r7, 
replies_topics.[approved] AS t1_r8, replies_topics.[replies_count] AS t1_r9, 
replies_topics.[parent_id] AS t1_r10, replies_topics.[type] AS t1_r11 FROM 
topics  LEFT OUTER JOIN topics replies_topics ON replies_topics.parent_id = 
topics.id AND replies_topics.[type] = 'Reply' WHERE  topics.id IN (2)  ORDER BY 
id
    ./test/../lib/active_record/connection_adapters/abstract_adapter.rb:137:in 
`log'
    ./test/../lib/active_record/connection_adapters/sqlserver_adapter.rb:337:in 
`execute_without_counting'
    ./test/abstract_unit.rb:71:in `execute'
    ./test/../lib/active_record/connection_adapters/sqlserver_adapter.rb:533:in 
`select'
    
./test/../lib/active_record/connection_adapters/abstract/database_statements.rb:7:in
 `select_all_without_query_cache'
    
./test/../lib/active_record/connection_adapters/abstract/query_cache.rb:55:in 
`select_all'
    ./test/../lib/active_record/associations.rb:1229:in `select_all_rows'
    ./test/../lib/active_record/associations.rb:1110:in `find_with_associations'
    ./test/../lib/active_record/associations.rb:1108:in `catch'
    ./test/../lib/active_record/associations.rb:1108:in `find_with_associations'
    ./test/../lib/active_record/base.rb:986:in `find_every'
    ./test/../lib/active_record/base.rb:427:in `find'
    ./test/base_test.rb:1434:in 
`test_scoped_find_limit_offset_including_has_many_association'
    ./test/../lib/active_record/base.rb:1434:in `with_scope'
    ./test/base_test.rb:1433:in 
`test_scoped_find_limit_offset_including_has_many_association'
    
c:/ruby/lib/ruby/gems/1.8/gems/mocha-0.4.0/lib/mocha/test_case_adapter.rb:19:in 
`__send__'
    
c:/ruby/lib/ruby/gems/1.8/gems/mocha-0.4.0/lib/mocha/test_case_adapter.rb:19:in 
`run'

  2) Failure:
test_belongs_to_counter_after_save(BelongsToAssociationsTest)
    [./test/associations_test.rb:1167:in `test_belongs_to_counter_after_save'
     
c:/ruby/lib/ruby/gems/1.8/gems/mocha-0.4.0/lib/mocha/test_case_adapter.rb:19:in 
`__send__'
     
c:/ruby/lib/ruby/gems/1.8/gems/mocha-0.4.0/lib/mocha/test_case_adapter.rb:19:in 
`run']:
<1> expected but was
<0>.

  3) Failure:
test_belongs_to_counter_after_update_attributes(BelongsToAssociationsTest)
    [./test/associations_test.rb:1176:in 
`test_belongs_to_counter_after_update_attributes'
     
c:/ruby/lib/ruby/gems/1.8/gems/mocha-0.4.0/lib/mocha/test_case_adapter.rb:19:in 
`__send__'
     
c:/ruby/lib/ruby/gems/1.8/gems/mocha-0.4.0/lib/mocha/test_case_adapter.rb:19:in 
`run']:
<1> expected but was
<0>.

  4) Error:
test_saves_both_date_and_time(DateTimeTest):
ArgumentError: argument out of range
    ./test/../lib/active_record/connection_adapters/sqlserver_adapter.rb:106:in 
`mktime'
    ./test/../lib/active_record/connection_adapters/sqlserver_adapter.rb:106:in 
`cast_to_datetime'
    ./test/../lib/active_record/connection_adapters/sqlserver_adapter.rb:79:in 
`type_cast'
    ./test/../lib/active_record/attribute_methods.rb:193:in `read_attribute'
    ./test/../lib/active_record/base.rb:2144:in `send'
    ./test/../lib/active_record/base.rb:2144:in `clone_attribute_value'
    ./test/../lib/active_record/base.rb:2138:in `clone_attributes'
    ./test/../lib/active_record/attribute_methods.rb:135:in `inject'
    ./test/../lib/active_record/base.rb:2137:in `each'
    ./test/../lib/active_record/base.rb:2137:in `inject'
    ./test/../lib/active_record/base.rb:2137:in `clone_attributes'
    ./test/../lib/active_record/base.rb:1838:in `attributes'
    ./test/../lib/active_record/base.rb:2022:in `attributes_with_quotes'
    ./test/../lib/active_record/base.rb:2114:in `quoted_column_names'
    ./test/../lib/active_record/base.rb:1971:in `create_without_callbacks'
    ./test/../lib/active_record/callbacks.rb:226:in `create_without_timestamps'
    ./test/../lib/active_record/timestamp.rb:29:in `create'
    ./test/../lib/active_record/base.rb:1947:in 
`create_or_update_without_callbacks'
    ./test/../lib/active_record/callbacks.rb:213:in `create_or_update'
    ./test/../lib/active_record/base.rb:1707:in `save_without_validation!'
    ./test/../lib/active_record/validations.rb:884:in 
`save_without_transactions!'
    ./test/../lib/active_record/transactions.rb:109:in `save!'
    
./test/../lib/active_record/connection_adapters/abstract/database_statements.rb:66:in
 `transaction'
    ./test/../lib/active_record/transactions.rb:77:in `transaction'
    ./test/../lib/active_record/transactions.rb:97:in `transaction'
    ./test/../lib/active_record/transactions.rb:109:in `save!'
    ./test/../lib/active_record/transactions.rb:117:in 
`rollback_active_record_state!'
    ./test/../lib/active_record/transactions.rb:109:in `save!'
    ./test/date_time_test.rb:11:in `test_saves_both_date_and_time'
    
c:/ruby/lib/ruby/gems/1.8/gems/mocha-0.4.0/lib/mocha/test_case_adapter.rb:19:in 
`__send__'
    
c:/ruby/lib/ruby/gems/1.8/gems/mocha-0.4.0/lib/mocha/test_case_adapter.rb:19:in 
`run'

  5) Error:
test_eager_association_loading_with_explicit_join(EagerAssociationTest):
ActiveRecord::StatementInvalid: DBI::DatabaseError: Execute
    OLE error code:80040E14 in Microsoft OLE DB Provider for SQL Server
      ORDER BY items must appear in the select list if SELECT DISTINCT is 
specified.
    HRESULT error code:0x80020009
      Exception occurred.: SELECT DISTINCT TOP 1 posts.id FROM posts  LEFT 
OUTER JOIN comments ON comments.post_id = posts.id  INNER JOIN authors ON 
posts.author_id = authors.id AND authors.name = 'Mary'  ORDER BY author_id
    ./test/../lib/active_record/connection_adapters/abstract_adapter.rb:137:in 
`log'
    ./test/../lib/active_record/connection_adapters/sqlserver_adapter.rb:337:in 
`execute_without_counting'
    ./test/abstract_unit.rb:71:in `execute'
    ./test/../lib/active_record/connection_adapters/sqlserver_adapter.rb:533:in 
`select'
    
./test/../lib/active_record/connection_adapters/abstract/database_statements.rb:7:in
 `select_all_without_query_cache'
    
./test/../lib/active_record/connection_adapters/abstract/query_cache.rb:55:in 
`select_all'
    ./test/../lib/active_record/associations.rb:1263:in 
`select_limited_ids_list'
    ./test/../lib/active_record/associations.rb:1253:in 
`add_limited_ids_condition!'
    ./test/../lib/active_record/associations.rb:1242:in 
`construct_finder_sql_with_included_associations'
    ./test/../lib/active_record/associations.rb:1230:in `select_all_rows'
    ./test/../lib/active_record/associations.rb:1110:in `find_with_associations'
    ./test/../lib/active_record/associations.rb:1108:in `catch'
    ./test/../lib/active_record/associations.rb:1108:in `find_with_associat

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby 
on Rails: Core" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/rubyonrails-core?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to