Created
February 7, 2012 14:12
-
-
Save metaskills/1759870 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
1) Error: | |
test_update_all_with_joins_and_offset(RelationTest): | |
ActiveRecord::StatementInvalid: TinyTds::Error: The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP or FOR XML is also specified.: EXEC sp_executesql N'UPDATE [comments] SET [post_id] = 2 WHERE [comments].[id] IN (SELECT [__rnt].[id] FROM ( SELECT ROW_NUMBER() OVER (ORDER BY [comments].[id] ASC) AS [__rn], [comments].[id] FROM [comments] INNER JOIN [posts] ON [posts].[id] = [comments].[post_id] WHERE [posts].[id] = 1 ) AS [__rnt] WHERE [__rnt].[__rn] > (1) ORDER BY [__rnt].[__rn] ASC); SELECT @@ROWCOUNT AS AffectedRows' | |
./lib/active_record/connection_adapters/sqlserver/database_statements.rb:412:in `each' | |
./lib/active_record/connection_adapters/sqlserver/database_statements.rb:412:in `handle_to_names_and_values_dblib' | |
./lib/active_record/connection_adapters/sqlserver/database_statements.rb:401:in `handle_to_names_and_values' | |
./lib/active_record/connection_adapters/sqlserver/database_statements.rb:373:in `_raw_select' | |
./lib/active_record/connection_adapters/sqlserver/database_statements.rb:367:in `raw_select' | |
/Users/kencollins/.rbenv/versions/ree/lib/ruby/gems/1.8/bundler/gems/rails-f36dcaf488b4/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:280:in `log' | |
/Users/kencollins/.rbenv/versions/ree/lib/ruby/gems/1.8/bundler/gems/rails-f36dcaf488b4/activesupport/lib/active_support/notifications/instrumenter.rb:20:in `instrument' | |
/Users/kencollins/.rbenv/versions/ree/lib/ruby/gems/1.8/bundler/gems/rails-f36dcaf488b4/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:275:in `log' | |
./lib/active_record/connection_adapters/sqlserver/database_statements.rb:367:in `raw_select' | |
./lib/active_record/connection_adapters/sqlserver/database_statements.rb:350:in `do_exec_query' | |
./lib/active_record/connection_adapters/sqlserver/database_statements.rb:24:in `exec_query' | |
/Users/kencollins/.rbenv/versions/ree/lib/ruby/gems/1.8/bundler/gems/rails-f36dcaf488b4/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:75:in `exec_update' | |
./lib/active_record/connection_adapters/sqlserver/database_statements.rb:39:in `exec_update' | |
/Users/kencollins/.rbenv/versions/ree/lib/ruby/gems/1.8/bundler/gems/rails-f36dcaf488b4/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:94:in `update' | |
/Users/kencollins/.rbenv/versions/ree/lib/ruby/gems/1.8/bundler/gems/rails-f36dcaf488b4/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:14:in `update' | |
/Users/kencollins/.rbenv/versions/ree/lib/ruby/gems/1.8/bundler/gems/rails-f36dcaf488b4/activerecord/lib/active_record/relation.rb:293:in `update_all' | |
/Users/kencollins/.rbenv/versions/ree/lib/ruby/gems/1.8/bundler/gems/rails-f36dcaf488b4/activerecord/test/cases/relations_test.rb:1139:in `test_update_all_with_joins_and_offset' | |
/Users/kencollins/.rbenv/versions/ree/lib/ruby/gems/1.8/bundler/gems/rails-f36dcaf488b4/activesupport/lib/active_support/testing/setup_and_teardown.rb:67:in `__send__' | |
/Users/kencollins/.rbenv/versions/ree/lib/ruby/gems/1.8/bundler/gems/rails-f36dcaf488b4/activesupport/lib/active_support/testing/setup_and_teardown.rb:67:in `run' | |
/Users/kencollins/.rbenv/versions/ree/lib/ruby/gems/1.8/bundler/gems/rails-f36dcaf488b4/activesupport/lib/active_support/callbacks.rb:425:in `_run__2099165786__setup__4__callbacks' | |
/Users/kencollins/.rbenv/versions/ree/lib/ruby/gems/1.8/bundler/gems/rails-f36dcaf488b4/activesupport/lib/active_support/callbacks.rb:405:in `send' | |
/Users/kencollins/.rbenv/versions/ree/lib/ruby/gems/1.8/bundler/gems/rails-f36dcaf488b4/activesupport/lib/active_support/callbacks.rb:405:in `__run_callback' | |
/Users/kencollins/.rbenv/versions/ree/lib/ruby/gems/1.8/bundler/gems/rails-f36dcaf488b4/activesupport/lib/active_support/callbacks.rb:385:in `_run_setup_callbacks' | |
/Users/kencollins/.rbenv/versions/ree/lib/ruby/gems/1.8/bundler/gems/rails-f36dcaf488b4/activesupport/lib/active_support/callbacks.rb:81:in `send' | |
/Users/kencollins/.rbenv/versions/ree/lib/ruby/gems/1.8/bundler/gems/rails-f36dcaf488b4/activesupport/lib/active_support/callbacks.rb:81:in `run_callbacks' | |
/Users/kencollins/.rbenv/versions/ree/lib/ruby/gems/1.8/bundler/gems/rails-f36dcaf488b4/activesupport/lib/active_support/testing/setup_and_teardown.rb:65:in `run' | |
2) Error: | |
test_update_all_with_joins_and_offset_and_order(RelationTest): | |
ActiveRecord::StatementInvalid: TinyTds::Error: The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP or FOR XML is also specified.: EXEC sp_executesql N'UPDATE [comments] SET [post_id] = 2 WHERE [comments].[id] IN (SELECT [__rnt].[id] FROM ( SELECT ROW_NUMBER() OVER (ORDER BY posts.id ASC, comments.id ASC) AS [__rn], [comments].[id] FROM [comments] INNER JOIN [posts] ON [posts].[id] = [comments].[post_id] WHERE [posts].[id] = 1 ) AS [__rnt] WHERE [__rnt].[__rn] > (1) ORDER BY [__rnt].[__rn] ASC); SELECT @@ROWCOUNT AS AffectedRows' | |
./lib/active_record/connection_adapters/sqlserver/database_statements.rb:412:in `each' | |
./lib/active_record/connection_adapters/sqlserver/database_statements.rb:412:in `handle_to_names_and_values_dblib' | |
./lib/active_record/connection_adapters/sqlserver/database_statements.rb:401:in `handle_to_names_and_values' | |
./lib/active_record/connection_adapters/sqlserver/database_statements.rb:373:in `_raw_select' | |
./lib/active_record/connection_adapters/sqlserver/database_statements.rb:367:in `raw_select' | |
/Users/kencollins/.rbenv/versions/ree/lib/ruby/gems/1.8/bundler/gems/rails-f36dcaf488b4/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:280:in `log' | |
/Users/kencollins/.rbenv/versions/ree/lib/ruby/gems/1.8/bundler/gems/rails-f36dcaf488b4/activesupport/lib/active_support/notifications/instrumenter.rb:20:in `instrument' | |
/Users/kencollins/.rbenv/versions/ree/lib/ruby/gems/1.8/bundler/gems/rails-f36dcaf488b4/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:275:in `log' | |
./lib/active_record/connection_adapters/sqlserver/database_statements.rb:367:in `raw_select' | |
./lib/active_record/connection_adapters/sqlserver/database_statements.rb:350:in `do_exec_query' | |
./lib/active_record/connection_adapters/sqlserver/database_statements.rb:24:in `exec_query' | |
/Users/kencollins/.rbenv/versions/ree/lib/ruby/gems/1.8/bundler/gems/rails-f36dcaf488b4/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:75:in `exec_update' | |
./lib/active_record/connection_adapters/sqlserver/database_statements.rb:39:in `exec_update' | |
/Users/kencollins/.rbenv/versions/ree/lib/ruby/gems/1.8/bundler/gems/rails-f36dcaf488b4/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:94:in `update' | |
/Users/kencollins/.rbenv/versions/ree/lib/ruby/gems/1.8/bundler/gems/rails-f36dcaf488b4/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:14:in `update' | |
/Users/kencollins/.rbenv/versions/ree/lib/ruby/gems/1.8/bundler/gems/rails-f36dcaf488b4/activerecord/lib/active_record/relation.rb:293:in `update_all' | |
/Users/kencollins/.rbenv/versions/ree/lib/ruby/gems/1.8/bundler/gems/rails-f36dcaf488b4/activerecord/test/cases/relations_test.rb:1147:in `test_update_all_with_joins_and_offset_and_order' | |
/Users/kencollins/.rbenv/versions/ree/lib/ruby/gems/1.8/bundler/gems/rails-f36dcaf488b4/activesupport/lib/active_support/testing/setup_and_teardown.rb:67:in `__send__' | |
/Users/kencollins/.rbenv/versions/ree/lib/ruby/gems/1.8/bundler/gems/rails-f36dcaf488b4/activesupport/lib/active_support/testing/setup_and_teardown.rb:67:in `run' | |
/Users/kencollins/.rbenv/versions/ree/lib/ruby/gems/1.8/bundler/gems/rails-f36dcaf488b4/activesupport/lib/active_support/callbacks.rb:425:in `_run__2099165786__setup__4__callbacks' | |
/Users/kencollins/.rbenv/versions/ree/lib/ruby/gems/1.8/bundler/gems/rails-f36dcaf488b4/activesupport/lib/active_support/callbacks.rb:405:in `send' | |
/Users/kencollins/.rbenv/versions/ree/lib/ruby/gems/1.8/bundler/gems/rails-f36dcaf488b4/activesupport/lib/active_support/callbacks.rb:405:in `__run_callback' | |
/Users/kencollins/.rbenv/versions/ree/lib/ruby/gems/1.8/bundler/gems/rails-f36dcaf488b4/activesupport/lib/active_support/callbacks.rb:385:in `_run_setup_callbacks' | |
/Users/kencollins/.rbenv/versions/ree/lib/ruby/gems/1.8/bundler/gems/rails-f36dcaf488b4/activesupport/lib/active_support/callbacks.rb:81:in `send' | |
/Users/kencollins/.rbenv/versions/ree/lib/ruby/gems/1.8/bundler/gems/rails-f36dcaf488b4/activesupport/lib/active_support/callbacks.rb:81:in `run_callbacks' | |
/Users/kencollins/.rbenv/versions/ree/lib/ruby/gems/1.8/bundler/gems/rails-f36dcaf488b4/activesupport/lib/active_support/testing/setup_and_teardown.rb:65:in `run' |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment