"bitsweat" has given AR/SQLServer some love, but it's still unhappy...
http://dev.rubyonrails.org/changeset/6348 ------------------------------------------------------------------------ r6348 | bitsweat | 2007-03-06 02:39:50 -0700 (Tue, 06 Mar 2007) | 1 line Oracle: overflow Time to DateTime. Closes #7718. ------------------------------------------------------------------------ U activerecord\test\associations_test.rb U activerecord\test\base_test.rb U activerecord\test\abstract_unit.rb U activerecord\lib\active_record\connection_adapters\oracle_adapter.rb U activerecord\CHANGELOG Updated to revision 6348. 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:139:in `log' ./test/../lib/active_record/connection_adapters/sqlserver_adapter.rb:321:in `execute_without_counting' ./test/abstract_unit.rb:73: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:1255:in `select_limited_ids_list' ./test/../lib/active_record/associations.rb:1247:in `add_limited_ids_condition!' ./test/../lib/active_record/associations.rb:1235:in `construct_finder_sql_with_included_associations' ./test/../lib/active_record/associations.rb:1223:in `select_all_rows' ./test/../lib/active_record/associations.rb:1079:in `find_with_associations' ./test/../lib/active_record/associations.rb:1077:in `catch' ./test/../lib/active_record/associations.rb:1077:in `find_with_associations' ./test/../lib/active_record/base.rb:1023:in `find_every' ./test/../lib/active_record/base.rb:422: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:139:in `log' ./test/../lib/active_record/connection_adapters/sqlserver_adapter.rb:321:in `execute_without_counting' ./test/abstract_unit.rb:73: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:1255:in `select_limited_ids_list' ./test/../lib/active_record/associations.rb:1247:in `add_limited_ids_condition!' ./test/../lib/active_record/associations.rb:1235:in `construct_finder_sql_with_included_associations' ./test/../lib/active_record/associations.rb:1223:in `select_all_rows' ./test/../lib/active_record/associations.rb:1079:in `find_with_associations' ./test/../lib/active_record/associations.rb:1077:in `catch' ./test/../lib/active_record/associations.rb:1077:in `find_with_associations' ./test/../lib/active_record/base.rb:1023:in `find_every' ./test/../lib/active_record/base.rb:422:in `find' ./test/associations/eager_test.rb:295:in `test_limited_eager_with_order' 3) 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:139:in `log' ./test/../lib/active_record/connection_adapters/sqlserver_adapter.rb:321:in `execute_without_counting' ./test/abstract_unit.rb:73: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:1255:in `select_limited_ids_list' ./test/associations_test.rb:1855:in `send' ./test/associations_test.rb:1855:in `test_select_limited_ids_list' 4) Failure: test_not_resaved_when_unchanged(HasOneAssociationsTest) [./test/abstract_unit.rb:42:in `assert_queries' ./test/associations_test.rb:397:in `test_not_resaved_when_unchanged']: 2 instead of 1 queries were executed. <1> expected but was <2>. 5) Failure: test_native_decimal_insert_manual_vs_automatic(MigrationTest) [./test/migration_test.rb:235]: <#<BigDecimal:b1174c4,'0.1234567890 1234567890 0123456789E20',32(36)>> expected but was <#<BigDecimal:b10a9cc,'0.1234567890 1234567890 012345678E20',32(36)>>. 6) Failure: test_native_types(MigrationTest) [./test/migration_test.rb:287]: <#<BigDecimal:b07db1c,'0.1234567890 1234567890 0123456789E20',32(36)>> expected but was <#<BigDecimal:b07da7c,'0.1234567890 1234567890 012345678E20',32(36)>>. 1048 tests, 5268 assertions, 3 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 [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/rubyonrails-core?hl=en -~----------~----~----~----~------~----~------~--~---
