Rich Cox
2007-May-18 02:21 UTC
Rails AR/SQLServer Unit Test: [6761] failed (getting worse)
"bitsweat" has kicked AR/SQLServer while it was down...
http://dev.rubyonrails.org/changeset/6761
------------------------------------------------------------------------
r6761 | bitsweat | 2007-05-17 19:11:43 -0700 (Thu, 17 May 2007) | 1 line
Sanitize Base#inspect. Closes #8392.
------------------------------------------------------------------------
U activerecord\test\associations_test.rb
U activerecord\test\base_test.rb
U activerecord\lib\active_record\associations\association_proxy.rb
U activerecord\lib\active_record\base.rb
U activerecord\CHANGELOG
Updated to revision 6761.
1) Failure:
test_inspect(BasicsTest) [./test/base_test.rb:1651]:
<"#<Topic id: 1, title: \"The First Topic\", author_name:
\"David\", author_email_address: \"david@loudthinking.com\",
written_on: \"2003-07-16 07:28:11\", bonus_time: \"2005-01-30
07:28:00\", last_read: \"2004-04-15 00:00:00\", content:
\"Have a nice day\", approved: false, replies_count: 1, parent_id:
nil, type: nil>"> expected but was
<"#<Topic id: 1, title: \"The First Topic\", author_name:
\"David\", author_email_address: \"david@loudthinking.com\",
written_on: \"2003-07-16 07:28:11\", bonus_time: \"2000-01-01
06:28:00\", last_read: \"2004-04-15\", content: \"Have a
nice day\", approved: false, replies_count: 1, parent_id: nil, type:
nil>">.
2) 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:1270:in
`select_limited_ids_list''
./test/../lib/active_record/associations.rb:1262:in
`add_limited_ids_condition!''
./test/../lib/active_record/associations.rb:1250:in
`construct_finder_sql_with_included_associations''
./test/../lib/active_record/associations.rb:1238:in
`select_all_rows''
./test/../lib/active_record/associations.rb:1094:in
`find_with_associations''
./test/../lib/active_record/associations.rb:1092:in `catch''
./test/../lib/active_record/associations.rb:1092: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''
3) 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:1270:in
`select_limited_ids_list''
./test/../lib/active_record/associations.rb:1262:in
`add_limited_ids_condition!''
./test/../lib/active_record/associations.rb:1250:in
`construct_finder_sql_with_included_associations''
./test/../lib/active_record/associations.rb:1238:in
`select_all_rows''
./test/../lib/active_record/associations.rb:1094:in
`find_with_associations''
./test/../lib/active_record/associations.rb:1092:in `catch''
./test/../lib/active_record/associations.rb:1092: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''
4) Error:
test_select_limited_ids_list(HasAndBelongsToManyAssociationsTest):
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 projects.id FROM projects LEFT OUTER
JOIN developers_projects ON developers_projects.project_id = projects.id LEFT
OUTER JOIN developers ON developers.id = developers_projects.developer_id ORDER
BY developers.created_at
./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:1270:in
`select_limited_ids_list''
./test/associations_test.rb:1838:in `send''
./test/associations_test.rb:1838:in `test_select_limited_ids_list''
5) Failure:
test_not_resaved_when_unchanged(HasOneAssociationsTest)
[./test/abstract_unit.rb:40:in `assert_queries''
./test/associations_test.rb:380:in
`test_not_resaved_when_unchanged'']:
2 instead of 1 queries were executed.
<1> expected but was
<2>.
6) Failure:
test_native_decimal_insert_manual_vs_automatic(MigrationTest)
[./test/migration_test.rb:234]:
<#<BigDecimal:b29948c,''0.1234567890 1234567890
0123456789E20'',32(36)>> expected but was
<#<BigDecimal:b28ca84,''0.1234567890 1234567890
012345678E20'',32(36)>>.
7) Failure:
test_native_types(MigrationTest) [./test/migration_test.rb:287]:
<#<BigDecimal:b223dcc,''0.1234567890 1234567890
0123456789E20'',32(36)>> expected but was
<#<BigDecimal:b223d2c,''0.1234567890 1234567890
012345678E20'',32(36)>>.
1071 tests, 4893 assertions, 4 failures, 3 errors
Skipping QueryCacheExpiryTest tests. `gem install mocha` and try again.
./test/../lib/active_record/connection_adapters/abstract/quoting.rb:13: warning:
Object#type is deprecated; use Object#class
./test/../lib/active_record/connection_adapters/abstract/quoting.rb:15: warning:
Object#type is deprecated; use Object#class
rake aborted!
Command failed with status (1): [c:/ruby/bin/ruby -Ilib;test;test/connectio...]
(See full trace by running task with --trace)
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---