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

If this information is useful, please help other people find it:
Share via:
Rich Cox
2007-May-21 19:00 UTC
Rails AR/SQLServer Unit Test: [6798] failed (getting worse)

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

http://dev.rubyonrails.org/changeset/6798
------------------------------------------------------------------------
r6798 | rick | 2007-05-21 11:54:51 -0700 (Mon, 21 May 2007) | 1 line

Fix column type detection while loading fixtures.  Closes #7987 [roderickvd]
------------------------------------------------------------------------

U    activerecord\test\fixtures_test.rb
U    activerecord\lib\active_record\fixtures.rb
U    activerecord\CHANGELOG
Updated to revision 6798.

  1) 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:1283:in
`select_limited_ids_list''
    ./test/../lib/active_record/associations.rb:1275:in
`add_limited_ids_condition!''
    ./test/../lib/active_record/associations.rb:1263:in
`construct_finder_sql_with_included_associations''
    ./test/../lib/active_record/associations.rb:1251:in
`select_all_rows''
    ./test/../lib/active_record/associations.rb:1107:in
`find_with_associations''
    ./test/../lib/active_record/associations.rb:1105:in `catch''
    ./test/../lib/active_record/associations.rb:1105:in
`find_with_associations''
    ./test/../lib/active_record/base.rb:1074:in `find_every''
    ./test/../lib/active_record/base.rb:431:in `find''
    ./test/associations/eager_test.rb:300:in
`test_limited_eager_with_multiple_order_columns''

  2) 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 =
posts.author_id  LEFT OUTER JOIN comments ON comments.post_id = posts.id WHERE
(authors.name = ''David'') ORDER BY UPPER(posts.title)) AS tmp1
ORDER BY title DESC) AS tmp2 ORDER BY title
    ./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:1283:in
`select_limited_ids_list''
    ./test/../lib/active_record/associations.rb:1275:in
`add_limited_ids_condition!''
    ./test/../lib/active_record/associations.rb:1263:in
`construct_finder_sql_with_included_associations''
    ./test/../lib/active_record/associations.rb:1251:in
`select_all_rows''
    ./test/../lib/active_record/associations.rb:1107:in
`find_with_associations''
    ./test/../lib/active_record/associations.rb:1105:in `catch''
    ./test/../lib/active_record/associations.rb:1105:in
`find_with_associations''
    ./test/../lib/active_record/base.rb:1074:in `find_every''
    ./test/../lib/active_record/base.rb:431:in `find''
    ./test/associations/eager_test.rb:295:in
`test_limited_eager_with_order''

  3) Error:
test_attributes(FixturesTest):
Errno::ENOENT: No such file or directory - ./test/fixtures/binaries
    ./test/../lib/active_record/fixtures.rb:347:in `open''
    ./test/../lib/active_record/fixtures.rb:347:in `entries''
    ./test/../lib/active_record/fixtures.rb:347:in `read_fixture_files''
    ./test/../lib/active_record/fixtures.rb:284:in `initialize''
    ./test/../lib/active_record/fixtures.rb:253:in `new''
    ./test/../lib/active_record/fixtures.rb:253:in `create_fixtures''
    ./test/../lib/active_record/fixtures.rb:252:in `map''
    ./test/../lib/active_record/fixtures.rb:252:in `create_fixtures''
    ./test/../lib/active_record/base.rb:945:in `silence''
    ./test/../lib/active_record/fixtures.rb:249:in `create_fixtures''
    ./test/../lib/active_record/fixtures.rb:604:in `load_fixtures''
    ./test/../lib/active_record/fixtures.rb:558:in `setup''

  4) Error:
test_bad_format(FixturesTest):
Errno::ENOENT: No such file or directory - ./test/fixtures/binaries
    ./test/../lib/active_record/fixtures.rb:347:in `open''
    ./test/../lib/active_record/fixtures.rb:347:in `entries''
    ./test/../lib/active_record/fixtures.rb:347:in `read_fixture_files''
    ./test/../lib/active_record/fixtures.rb:284:in `initialize''
    ./test/../lib/active_record/fixtures.rb:253:in `new''
    ./test/../lib/active_record/fixtures.rb:253:in `create_fixtures''
    ./test/../lib/active_record/fixtures.rb:252:in `map''
    ./test/../lib/active_record/fixtures.rb:252:in `create_fixtures''
    ./test/../lib/active_record/base.rb:945:in `silence''
    ./test/../lib/active_record/fixtures.rb:249:in `create_fixtures''
    ./test/../lib/active_record/fixtures.rb:604:in `load_fixtures''
    ./test/../lib/active_record/fixtures.rb:558:in `setup''

  5) Error:
test_binary_in_fixtures(FixturesTest):
Errno::ENOENT: No such file or directory - ./test/fixtures/binaries
    ./test/../lib/active_record/fixtures.rb:347:in `open''
    ./test/../lib/active_record/fixtures.rb:347:in `entries''
    ./test/../lib/active_record/fixtures.rb:347:in `read_fixture_files''
    ./test/../lib/active_record/fixtures.rb:284:in `initialize''
    ./test/../lib/active_record/fixtures.rb:253:in `new''
    ./test/../lib/active_record/fixtures.rb:253:in `create_fixtures''
    ./test/../lib/active_record/fixtures.rb:252:in `map''
    ./test/../lib/active_record/fixtures.rb:252:in `create_fixtures''
    ./test/../lib/active_record/base.rb:945:in `silence''
    ./test/../lib/active_record/fixtures.rb:249:in `create_fixtures''
    ./test/../lib/active_record/fixtures.rb:604:in `load_fixtures''
    ./test/../lib/active_record/fixtures.rb:558:in `setup''

  6) Error:
test_clean_fixtures(FixturesTest):
Errno::ENOENT: No such file or directory - ./test/fixtures/binaries
    ./test/../lib/active_record/fixtures.rb:347:in `open''
    ./test/../lib/active_record/fixtures.rb:347:in `entries''
    ./test/../lib/active_record/fixtures.rb:347:in `read_fixture_files''
    ./test/../lib/active_record/fixtures.rb:284:in `initialize''
    ./test/../lib/active_record/fixtures.rb:253:in `new''
    ./test/../lib/active_record/fixtures.rb:253:in `create_fixtures''
    ./test/../lib/active_record/fixtures.rb:252:in `map''
    ./test/../lib/active_record/fixtures.rb:252:in `create_fixtures''
    ./test/../lib/active_record/base.rb:945:in `silence''
    ./test/../lib/active_record/fixtures.rb:249:in `create_fixtures''
    ./test/../lib/active_record/fixtures.rb:604:in `load_fixtures''
    ./test/../lib/active_record/fixtures.rb:558:in `setup''

  7) Error:
test_complete_instantiation(FixturesTest):
Errno::ENOENT: No such file or directory - ./test/fixtures/binaries
    ./test/../lib/active_record/fixtures.rb:347:in `open''
    ./test/../lib/active_record/fixtures.rb:347:in `entries''
    ./test/../lib/active

--~--~---------~--~----~------------~-------~--~----~
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 - May 2007 - Rails AR/SQLServer Unit Test: [6798] failed (getting worse)

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