Rich Cox
2007-Oct-15 03:41 UTC
Rails AR/SQLServer Unit Test: [7895] failed (but getting better)
"bitsweat" has given AR/SQLServer some love, but it''s still
unhappy...
http://dev.rubyonrails.org/changeset/7895
------------------------------------------------------------------------
r7895 | bitsweat | 2007-10-14 20:32:00 -0700 (Sun, 14 Oct 2007) | 2 lines
Update IGNORED_SQL for SQL Server. Closes #9638 [lawrence]
------------------------------------------------------------------------
U activerecord\test\abstract_unit.rb
Updated to revision 7895.
1) Failure:
test_save_for_record_with_only_primary_key(BasicsTest)
[./test/base_test.rb:197:in
`test_save_for_record_with_only_primary_key''
c:/ruby/lib/ruby/gems/1.8/gems/mocha-0.5.5/lib/mocha/test_case_adapter.rb:19:in
`__send__''
c:/ruby/lib/ruby/gems/1.8/gems/mocha-0.5.5/lib/mocha/test_case_adapter.rb:19:in
`run'']:
Exception raised:
Class: <ActiveRecord::StatementInvalid>
Message: <"DBI::DatabaseError: Execute\n OLE error code:80040E14 in
Microsoft OLE DB Provider for SQL Server\n An explicit value for the
identity column in table ''minimalistics'' can only be specified
when a column list is used and IDENTITY_INSERT is ON.\n HRESULT error
code:0x80020009\n Exception occurred.: INSERT INTO minimalistics
VALUES(DEFAULT)">
---Backtrace---
./test/../lib/active_record/connection_adapters/abstract_adapter.rb:137:in
`log''
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-sqlserver-adapter-1.0.0/lib/active_record/connection_adapters/sqlserver_adapter.rb:337:in
`execute_without_counting''
./test/abstract_unit.rb:70:in `execute''
./test/../lib/active_record/connection_adapters/abstract/database_statements.rb:155:in
`insert_sql''
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-sqlserver-adapter-1.0.0/lib/active_record/connection_adapters/sqlserver_adapter.rb:318:in
`insert_sql''
./test/../lib/active_record/connection_adapters/abstract/database_statements.rb:44:in
`insert_without_query_dirty''
./test/../lib/active_record/connection_adapters/abstract/query_cache.rb:19:in
`insert''
./test/../lib/active_record/base.rb:2013: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:1979:in
`create_or_update_without_callbacks''
./test/../lib/active_record/callbacks.rb:213:in `create_or_update''
./test/../lib/active_record/base.rb:1731:in `save_without_validation''
./test/../lib/active_record/validations.rb:877:in
`save_without_transactions''
./test/../lib/active_record/transactions.rb:105: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:105:in `save''
./test/../lib/active_record/transactions.rb:117:in
`rollback_active_record_state!''
./test/../lib/active_record/transactions.rb:105:in `save''
./test/base_test.rb:197:in `test_save_for_record_with_only_primary_key''
./test/base_test.rb:197:in `test_save_for_record_with_only_primary_key''
c:/ruby/lib/ruby/gems/1.8/gems/mocha-0.5.5/lib/mocha/test_case_adapter.rb:19:in
`__send__''
c:/ruby/lib/ruby/gems/1.8/gems/mocha-0.5.5/lib/mocha/test_case_adapter.rb:19:in
`run''
---------------
2) Failure:
test_save_for_record_with_only_primary_key_that_is_provided(BasicsTest)
[./test/base_test.rb:201:in
`test_save_for_record_with_only_primary_key_that_is_provided''
c:/ruby/lib/ruby/gems/1.8/gems/mocha-0.5.5/lib/mocha/test_case_adapter.rb:19:in
`__send__''
c:/ruby/lib/ruby/gems/1.8/gems/mocha-0.5.5/lib/mocha/test_case_adapter.rb:19:in
`run'']:
Exception raised:
Class: <ActiveRecord::StatementInvalid>
Message: <"DBI::DatabaseError: Execute\n OLE error code:80040E14 in
Microsoft OLE DB Provider for SQL Server\n An explicit value for the
identity column in table ''minimalistics'' can only be specified
when a column list is used and IDENTITY_INSERT is ON.\n HRESULT error
code:0x80020009\n Exception occurred.: INSERT INTO minimalistics
VALUES(DEFAULT)">
---Backtrace---
./test/../lib/active_record/connection_adapters/abstract_adapter.rb:137:in
`log''
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-sqlserver-adapter-1.0.0/lib/active_record/connection_adapters/sqlserver_adapter.rb:337:in
`execute_without_counting''
./test/abstract_unit.rb:70:in `execute''
./test/../lib/active_record/connection_adapters/abstract/database_statements.rb:155:in
`insert_sql''
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-sqlserver-adapter-1.0.0/lib/active_record/connection_adapters/sqlserver_adapter.rb:318:in
`insert_sql''
./test/../lib/active_record/connection_adapters/abstract/database_statements.rb:44:in
`insert_without_query_dirty''
./test/../lib/active_record/connection_adapters/abstract/query_cache.rb:19:in
`insert''
./test/../lib/active_record/base.rb:2013: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:1979:in
`create_or_update_without_callbacks''
./test/../lib/active_record/callbacks.rb:213:in `create_or_update''
./test/../lib/active_record/base.rb:1737:in `save_without_validation!''
./test/../lib/active_record/validations.rb:887: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/../lib/active_record/validations.rb:852:in `create!''
./test/base_test.rb:201:in
`test_save_for_record_with_only_primary_key_that_is_provided''
./test/base_test.rb:201:in
`test_save_for_record_with_only_primary_key_that_is_provided''
c:/ruby/lib/ruby/gems/1.8/gems/mocha-0.5.5/lib/mocha/test_case_adapter.rb:19:in
`__send__''
c:/ruby/lib/ruby/gems/1.8/gems/mocha-0.5.5/lib/mocha/test_case_adapter.rb:19:in
`run''
---------------
3) 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:137:in
`log''
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-sqlserver-adapter-1.0.0/lib/active_record/connection_adapters/sqlserver_adapter.rb:337:in
`execute_without_counting''
./test/abstract_unit.rb:70:in `execute''
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-sqlserver-adapter-1.0.0/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:1237:in
`select_all_rows''
./test/../lib/active_record/associations.rb:1119:in
`find_with_associations''
./test/../lib/active_record/associations.rb:1117:in `catch''
./test/../lib/active_record/associations.rb:1117:in
`find_with_associations''
./test/../lib/active_record/base.rb:1009:in `find_every''
./test/../lib/active_record/base.rb:436:in `find''
./test/base_test.rb:1487:in
`test_scoped_find_limit_offset_including_has_many_association''
./test/../lib/active_record/base.rb:1464:in `with_scope''
./test/base_test.rb:1486:in
`test_scoped_find_limit_offset_including_has_many_association''
c:/ruby/lib/ruby/gems/1.8/gems/mocha-0.5.5/lib/mocha/test_case_adapter.rb:19:in
`__send__''
c:/ruby/lib/ruby/gems/1.8/gems/mocha-0.5.5/lib/mocha/test_case_adapter.rb:19:in
`run''
4) Error:
test_saves_both_date_and_time(DateTimeTest):
ArgumentError: argument out of range
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-sqlserver-adapter-1.0.0/lib/active_record/connection_adapters/sqlserver_adapter.rb:106:in
`mktime''
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-sqlserver-adapter-1.0.0/lib/active_record/connection_adapters/sqlserver_adapter.rb:106:in
`cast_to_datetime''
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-sqlserver-adapter-1.0.0/lib/active_record/connection_adapters/sqlserver_adapter.rb:79:in
`type_cast''
./test/../lib/active_record/attribute_methods.rb:218:in
`read_attribute''
./test/../lib/active_record/base.rb:2207:in `send''
./test/../lib/active_record/base.rb:2207:in `clone_attribute_value''
./test/../lib/active_record/base.rb:2201:in `clone_attributes''
./test/../lib/active_record/attribute_methods.rb:160:in `inject''
./test/../lib/active_record/base.rb:2200:in `each''
./test/../lib/active_record/base.rb:2200:in `inject''
./test/../lib/active_record/base.rb:2200:in `clone_attributes''
./test/../lib/active_record/base.rb:1870:in `attributes''
./test/../lib/active_record/base.rb:2084:in
`attributes_with_quotes''
./test/../lib/active_record/base.rb:2003: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:1979:in
`create_or_update_without_callbacks''
./test/../lib/active_record/callbacks.rb:213:in `create_or_update''
./test/../lib/active_record/base.rb:1737:in
`save_without_validation!''
./test/../lib/active_record/validations.rb:887: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.5.5/lib/mocha/test_case_adapter.rb:19:in
`__send__''
c:/ruby/lib/ruby/gems/1.8/gems/mocha-0.5.5/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''
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-sqlserver-adapter-1.0.0/lib/active_record/connection_adapters/sqlserver_adapter.rb:337:in
`execute_without_counting''
./test/abstract_unit.rb:70:in `execute''
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-sqlserver-adapter-1.0.0/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:1271:in
`select_limited_ids_list''
./test/../lib/active_record/associations.rb:1261: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:1119:in
`find_with_associations''
./test/../lib/active_record/associations.rb:1117:in `catch''
./test/../lib/active_record/associations.rb:1117:in
`find_with_associations''
./test/../lib/active_record/base.rb:1009:in `find_every''
./test/../lib/active_record/base.rb:436:in `find''
./test/associations/eager_test.rb:107:in
`test_eager_association_loading_with_explicit_join''
c:/ruby/lib/ruby/gems/1.8/gems/mocha-0.5.5/lib/mocha/test_case_adapter.rb:19:in
`__send__''
c:/ruby/lib/ruby/gems/1.8/gems/mocha-0.5.5/lib/mocha/test_case_adapter.rb:19:in
`run''
6) 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:137:in
`log''
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-sqlserver-adapter-1.0.0/lib/active_record/connection_adapters/sqlserver_adapter.rb:337:in
`execute_without_counting''
./test/abstract_unit.rb:70:in `execute''
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-sqlserver-adapter-1.0.0/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:1271:in
`select_limited_ids_list''
./test/../lib/active_record/associations.rb:1261: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/asso
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---