Rich Cox
2007-Oct-07 01:10 UTC
Rails AR/SQLServer Unit Test: [7761] failed (getting worse)
"bitsweat" has kicked AR/SQLServer while it was down... http://dev.rubyonrails.org/changeset/7761 ------------------------------------------------------------------------ r7761 | bitsweat | 2007-10-06 18:05:42 -0700 (Sat, 06 Oct 2007) | 1 line Unbundle Builder in favor of a gem dependency. ------------------------------------------------------------------------ U activesupport\Rakefile D activesupport\lib\active_support\vendor\builder D activesupport\lib\active_support\vendor\builder.rb U activesupport\CHANGELOG Updated to revision 7761. 1) Failure: test_save_for_record_with_only_primary_key(BasicsTest) [./test/base_test.rb:190: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:1998: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:1964:in `create_or_update_without_callbacks'' ./test/../lib/active_record/callbacks.rb:213:in `create_or_update'' ./test/../lib/active_record/base.rb:1718:in `save_without_validation'' ./test/../lib/active_record/validations.rb:874: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:190:in `test_save_for_record_with_only_primary_key'' ./test/base_test.rb:190: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:194: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:1998: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:1964:in `create_or_update_without_callbacks'' ./test/../lib/active_record/callbacks.rb:213:in `create_or_update'' ./test/../lib/active_record/base.rb:1724: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/../lib/active_record/validations.rb:849:in `create!'' ./test/base_test.rb:194:in `test_save_for_record_with_only_primary_key_that_is_provided'' ./test/base_test.rb:194: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:1233:in `select_all_rows'' ./test/../lib/active_record/associations.rb:1114:in `find_with_associations'' ./test/../lib/active_record/associations.rb:1112:in `catch'' ./test/../lib/active_record/associations.rb:1112:in `find_with_associations'' ./test/../lib/active_record/base.rb:1003:in `find_every'' ./test/../lib/active_record/base.rb:430:in `find'' ./test/base_test.rb:1465:in `test_scoped_find_limit_offset_including_has_many_association'' ./test/../lib/active_record/base.rb:1451:in `with_scope'' ./test/base_test.rb:1464: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_should_allow_except_option_for_list_of_authors(DatabaseConnectedJsonEncodingTest): ArgumentError: wrong number of arguments (1 for 0) ./test/json_serialization_test.rb:154:in `to_json'' ./test/json_serialization_test.rb:154:in `test_should_allow_except_option_for_list_of_authors'' 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_should_allow_includes_for_list_of_authors(DatabaseConnectedJsonEncodingTest): ArgumentError: wrong number of arguments (1 for 0) ./test/json_serialization_test.rb:159:in `to_json'' ./test/json_serialization_test.rb:159:in `test_should_allow_includes_for_list_of_authors'' 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_should_allow_only_option_for_list_of_authors(DatabaseConnectedJsonEncodingTest): ArgumentError: wrong number of arguments (1 for 0) ./test/json_serialization_test.rb:148:in `to_json'' ./test/json_serialization_test.rb:148:in `test_should_allow_only_option_for_list_of_authors'' 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'' 7) Error: test_should_allow_options_for_hash_of_authors(DatabaseConnectedJsonEncodingTest): ArgumentError: wrong number of arguments (1 for 0) ./test/json_serialization_test.rb:178:in `to_json'' ./test/json_serialization_test.rb:178:in `test_should_allow_options_for_hash_of_authors'' 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'' 8) 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:2178:in `send'' ./test/../lib/active_record/base.rb:2178:in `clone_attribute_value'' ./test/../lib/active_record/base.rb:2172:in `clone_attributes'' ./test/../lib/active_record/attribute_methods.rb:160:in `inject'' ./test/../lib/active_record/base.rb:2171:in `each'' ./test/../lib/active_record/base.rb:2171:in `inject'' ./test/../lib/active_record/base.rb:2171:in `clone_attributes'' ./test/../lib/active_record/base.rb:1855:in `attributes'' ./test/../lib/active_record/base.rb:2055:in `attributes_with_quotes'' ./test/../lib/active_record/base.rb:1988: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:1964:in `create_or_update_without_callbacks'' ./test/../lib/active_record/callbacks.rb:213:in `create_or_update'' ./test/../lib/active_record/base.rb:1724: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.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'' 9) 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:1267:in `select_limited_ids_list'' ./test/../lib/active_record/associations.rb:1257:in `add_limited_ids_condition!'' ./test/../lib/active_record/associations.rb:1246:in `construct_finder_sql_with_included_associations'' ./test/../lib/active_record/associations.rb:1234:in `select_all_rows'' ./test/../lib/active_record/associations.rb:1114:in `find_with_associations'' ./test/../lib/active_record/associations.rb:1112:in `catch'' ./test/../lib/active_record/associations.rb:1112:in `find_with_associations'' ./test/../lib/active_record/base.rb:1003:in `find_every'' ./test/../lib/active_record/base.rb:430:in `find'' ./test/associations/eager_test.rb:107:in `test_eager_association_loadin --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---