thr3ads.net - Rails core - Rails AR/SQLServer Unit Test: [7471] failed (getting worse) [Sep 2007]

If this information is useful, please help other people find it:
Share via:
Rich Cox
2007-Sep-13 23:20 UTC
Rails AR/SQLServer Unit Test: [7471] failed (getting worse)

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

http://dev.rubyonrails.org/changeset/7471
------------------------------------------------------------------------
r7471 | bitsweat | 2007-09-13 16:13:34 -0700 (Thu, 13 Sep 2007) | 1 line

minor speedups + forward-compat syntax
------------------------------------------------------------------------

D    activerecord\test\mixin_nested_set_test.rb
U    activerecord\lib\active_record\validations.rb
U   
activerecord\lib\active_record\connection_adapters\abstract\database_statements.rb
U    activerecord\lib\active_record\connection_adapters\oracle_adapter.rb
U    activerecord\lib\active_record\base.rb
U    activerecord\lib\active_record\schema_dumper.rb
Updated to revision 7471.

  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, rep
 lies_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:135:in
`log''
    ./test/../lib/active_record/connection_adapters/sqlserver_adapter.rb:321:in
`execute_without_counting''
    ./test/abstract_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: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:998:in `find_every''
    ./test/../lib/active_record/base.rb:429:in `find''
    ./test/base_test.rb:1427:in
`test_scoped_find_limit_offset_including_has_many_association''
    ./test/../lib/active_record/base.rb:1443:in `with_scope''
    ./test/base_test.rb:1426: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) 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:186:in
`read_attribute''
    ./test/../lib/active_record/base.rb:2153:in `send''
    ./test/../lib/active_record/base.rb:2153:in `clone_attribute_value''
    ./test/../lib/active_record/base.rb:2147:in `clone_attributes''
    ./test/../lib/active_record/attribute_methods.rb:128:in `inject''
    ./test/../lib/active_record/base.rb:2146:in `each''
    ./test/../lib/active_record/base.rb:2146:in `inject''
    ./test/../lib/active_record/base.rb:2146:in `clone_attributes''
    ./test/../lib/active_record/base.rb:1847:in `attributes''
    ./test/../lib/active_record/base.rb:2031:in
`attributes_with_quotes''
    ./test/../lib/active_record/base.rb:2123:in `quoted_column_names''
    ./test/../lib/active_record/base.rb:1980: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:1956:in
`create_or_update_without_callbacks''
    ./test/../lib/active_record/callbacks.rb:213:in `create_or_update''
    ./test/../lib/active_record/base.rb:1716: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:59: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''

  3) Error:
test_limited_eager_with_multiple_order_columns(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 * FROM (SELECT TOP 2 * FROM (SELECT DISTINCT
TOP 3  posts.id FROM posts  LEFT OUTER JOIN authors ON authors.id =
posts.author_id  LEFT OUTER JOIN comments ON comments.post_id = posts.id WHERE
(authors.name = ''David'')  ORDER BY UPPER(posts.title),
posts.id) AS tmp1 ORDER BY title DESC, id DESC) AS tmp2 ORDER BY title, id
    ./test/../lib/active_record/connection_adapters/abstract_adapter.rb:135:in
`log''
    ./test/../lib/active_record/connection_adapters/sqlserver_adapter.rb:321:in
`execute_without_counting''
    ./test/abstract_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:1261: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_associations''
    ./test/../lib/active_record/base.rb:998:in `find_every''
    ./test/../lib/active_record/base.rb:429:in `find''
    ./test/associations/eager_test.rb:313:in
`test_limited_eager_with_multiple_order_columns''
   
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''

  4) Error:
test_limited_eager_with_order(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 * FROM (SELECT TOP 2 * FROM (SELECT DISTINCT
TOP 3  posts.id FROM posts  LEFT OUTER JOIN authors ON authors.id = post

--~--~---------~--~----~------------~-------~--~----~
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 rubyonrails-core@googlegroups.com
To unsubscribe from this group, send email to
rubyonrails-core-unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-core?hl=en
-~----------~----~----~----~------~----~------~--~---
Rails core - Sep 2007 - Rails AR/SQLServer Unit Test: [7471] failed (getting worse)

Rails AR/SQLServer Unit Test: [7471] failed (getting worse)
