Skip to content

Instantly share code, notes, and snippets.

@annaswims
Created April 24, 2014 05:04
Show Gist options
  • Save annaswims/11242133 to your computer and use it in GitHub Desktop.
Save annaswims/11242133 to your computer and use it in GitHub Desktop.
activerecord-sqlserver-adapter errors w/rails 4.1.0
1) Failure:
ActiveRecord::AdapterTest#test_select_methods_passing_a_association_relation [/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/test/cases/adapter_test.rb:188]:
--- expected
+++ actual
@@ -1 +1 @@
-{"title"=>"foo"}
+{"title"=>"Welcome to the weblog"}
2) Error:
ActiveRecord::BindParameterTest#test_binds_are_logged_after_type_cast:
NoMethodError: undefined method `[]' for nil:NilClass
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/test/cases/bind_parameter_test.rb:52:in `test_binds_are_logged_after_type_cast'
3) Error:
EagerAssociationTest#test_join_eager_with_nil_order_should_generate_valid_sql:
NoMethodError: undefined method `to_sql' for nil:NilClass
/Users/acarey/code/nextgear/sqlserver/annaswims/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/schema_statements.rb:53:in `block in columns_for_distinct'
/Users/acarey/code/nextgear/sqlserver/annaswims/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/schema_statements.rb:51:in `map'
/Users/acarey/code/nextgear/sqlserver/annaswims/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/schema_statements.rb:51:in `columns_for_distinct'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/relation/finder_methods.rb:377:in `limited_ids_for'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/relation/finder_methods.rb:369:in `apply_join_dependency'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/relation/finder_methods.rb:330:in `find_with_associations'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/relation.rb:603:in `exec_queries'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/relation.rb:487:in `load'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/relation.rb:231:in `to_a'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/relation/finder_methods.rb:467:in `find_nth_with_limit'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/relation/finder_methods.rb:459:in `find_nth'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/relation/finder_methods.rb:132:in `first'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/test/cases/associations/eager_test.rb:1137:in `block in test_join_eager_with_nil_order_should_generate_valid_sql'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activesupport/lib/active_support/test_case.rb:63:in `assert_nothing_raised'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/test/cases/associations/eager_test.rb:1136:in `test_join_eager_with_nil_order_should_generate_valid_sql'
4) Failure:
FinderTest#test_coerced_find_with_order_on_included_associations_with_construct_finder_sql_for_association_limiting_and_is_distinct [/Users/acarey/code/nextgear/sqlserver/annaswims/activerecord-sqlserver-adapter/test/cases/finder_test_sqlserver.rb:34]:
Expected: 2
Actual: 1
5) Failure:
InheritanceTest#test_coerced_eager_load_belongs_to_primary_key_quoting [/Users/acarey/code/nextgear/sqlserver/annaswims/activerecord-sqlserver-adapter/test/cases/inheritance_test_sqlserver.rb:29]:
Query pattern(s) /\[companies\]\.\[id\] IN \(N''1''\)/ not found.
Queries:
EXEC sp_executesql N'SELECT TOP (1) [accounts].* FROM [accounts] WHERE [accounts].[id] = @0', N'@0 int', @0 = 1
EXEC sp_executesql N'SELECT [companies].* FROM [companies] WHERE [companies].[id] IN (1)'
6) Failure:
RelationTest#test_to_sql_on_eager_join [/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/test/cases/relations_test.rb:549]:
--- expected
+++ actual
@@ -1 +1 @@
-"EXEC sp_executesql N'SELECT [posts].[id] AS t0_r0, [posts].[author_id] AS t0_r1, [posts].[title] AS t0_r2, [posts].[body] AS t0_r3, [posts].[type] AS t0_r4, [posts].[comments_count] AS t0_r5, [posts].[taggings_count] AS t0_r6, [posts].[taggings_with_delete_all_count] AS t0_r7, [posts].[taggings_with_destroy_count] AS t0_r8, [posts].[tags_count] AS t0_r9, [posts].[tags_with_destroy_count] AS t0_r10, [posts].[tags_with_nullify_count] AS t0_r11, [comments].[id] AS t1_r0, [comments].[post_id] AS t1_r1, [comments].[body] AS t1_r2, [comments].[type] AS t1_r3, [comments].[taggings_count] AS t1_r4, [comments].[children_count] AS t1_r5, [comments].[parent_id] AS t1_r6 FROM [posts] LEFT OUTER JOIN [comments] ON [comments].[post_id] = [posts].[id] ORDER BY comments.id DESC'"
+"SELECT [posts].[id] AS t0_r0, [posts].[author_id] AS t0_r1, [posts].[title] AS t0_r2, [posts].[body] AS t0_r3, [posts].[type] AS t0_r4, [posts].[comments_count] AS t0_r5, [posts].[taggings_count] AS t0_r6, [posts].[taggings_with_delete_all_count] AS t0_r7, [posts].[taggings_with_destroy_count] AS t0_r8, [posts].[tags_count] AS t0_r9, [posts].[tags_with_destroy_count] AS t0_r10, [posts].[tags_with_nullify_count] AS t0_r11, [comments].[id] AS t1_r0, [comments].[post_id] AS t1_r1, [comments].[body] AS t1_r2, [comments].[type] AS t1_r3, [comments].[taggings_count] AS t1_r4, [comments].[children_count] AS t1_r5, [comments].[parent_id] AS t1_r6 FROM [posts] LEFT OUTER JOIN [comments] ON [comments].[post_id] = [posts].[id] ORDER BY comments.id DESC"
7) Failure:
ActiveRecord::ConnectionAdapters::ConnectionSpecification::ResolverTest#test_coerced_test_url_host_db [/Users/acarey/code/nextgear/sqlserver/annaswims/activerecord-sqlserver-adapter/test/cases/resolver_test_sqlserver.rb:27]:
--- expected
+++ actual
@@ -1 +1 @@
-{:adapter=>"sqlserver", :database=>"bar", :host=>"foo", :encoding=>"utf8"}
+{"encoding"=>"utf8", "adapter"=>"sqlserver", "database"=>"bar", "host"=>"foo"}
8) Failure:
ActiveRecord::ConnectionAdapters::ConnectionSpecification::ResolverTest#test_coerced_test_url_host_no_db [/Users/acarey/code/nextgear/sqlserver/annaswims/activerecord-sqlserver-adapter/test/cases/resolver_test_sqlserver.rb:19]:
--- expected
+++ actual
@@ -1 +1 @@
-{:adapter=>"sqlserver", :host=>"foo", :encoding=>"utf8"}
+{"encoding"=>"utf8", "adapter"=>"sqlserver", "host"=>"foo"}
9) Failure:
ActiveRecord::ConnectionAdapters::ConnectionSpecification::ResolverTest#test_coerced_test_url_port [/Users/acarey/code/nextgear/sqlserver/annaswims/activerecord-sqlserver-adapter/test/cases/resolver_test_sqlserver.rb:36]:
--- expected
+++ actual
@@ -1 +1 @@
-{:adapter=>"sqlserver", :port=>123, :host=>"foo", :encoding=>"utf8"}
+{"encoding"=>"utf8", "adapter"=>"sqlserver", "port"=>123, "host"=>"foo"}
10) Failure:
ActiveRecord::ConnectionAdapters::MergeAndResolveDefaultUrlConfigTest#test_blank_with_database_url [/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/test/cases/connection_adapters/connection_handler_test.rb:144]:
--- expected
+++ actual
@@ -1 +1 @@
-{"adapter"=>"postgresql", "database"=>"foo", "host"=>"localhost"}
+nil
11) Failure:
ActiveRecord::ConnectionAdapters::MergeAndResolveDefaultUrlConfigTest#test_environment_does_not_exist_in_config_url_does_exist [/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/test/cases/connection_adapters/connection_handler_test.rb:89]:
--- expected
+++ actual
@@ -1 +1 @@
-{"adapter"=>"postgresql", "database"=>"foo", "host"=>"localhost"}
+nil
12) Failure:
ActiveRecord::ConnectionAdapters::MergeAndResolveDefaultUrlConfigTest#test_merge_conflicts_with_database_url [/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/test/cases/connection_adapters/connection_handler_test.rb:194]:
--- expected
+++ actual
@@ -1 +1 @@
-{"default_env"=>{"adapter"=>"postgresql", "database"=>"foo", "host"=>"localhost", "pool"=>"5"}}
+{"default_env"=>{"adapter"=>"NOT-POSTGRES", "database"=>"NOT-FOO", "pool"=>"5"}, "development"=>{"adapter"=>"postgresql", "database"=>"foo", "host"=>"localhost"}}
13) Failure:
ActiveRecord::ConnectionAdapters::MergeAndResolveDefaultUrlConfigTest#test_merge_no_conflicts_with_database_url [/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/test/cases/connection_adapters/connection_handler_test.rb:179]:
--- expected
+++ actual
@@ -1 +1 @@
-{"default_env"=>{"adapter"=>"postgresql", "database"=>"foo", "host"=>"localhost", "pool"=>"5"}}
+{"default_env"=>{"pool"=>"5"}, "development"=>{"adapter"=>"postgresql", "database"=>"foo", "host"=>"localhost"}}
14) Failure:
ActiveRecord::ConnectionAdapters::MergeAndResolveDefaultUrlConfigTest#test_resolver_with_database_uri_and_and_current_env_string_key [/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/test/cases/connection_adapters/connection_handler_test.rb:41]:
--- expected
+++ actual
@@ -1 +1 @@
-{"adapter"=>"postgresql", "database"=>"foo", "host"=>"localhost"}
+{"adapter"=>"not_postgres", "database"=>"not_foo"}
15) Error:
ActiveRecord::ConnectionAdapters::MergeAndResolveDefaultUrlConfigTest#test_resolver_with_database_uri_and_current_env_symbol_key:
ActiveRecord::AdapterNotSpecified: 'default_env' database is not configured. Available: ["not_production", "development"]
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/connection_adapters/connection_specification.rb:257:in `resolve_symbol_connection'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/connection_adapters/connection_specification.rb:224:in `resolve_connection'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/connection_adapters/connection_specification.rb:152:in `resolve'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/test/cases/connection_adapters/connection_handler_test.rb:21:in `resolve'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/test/cases/connection_adapters/connection_handler_test.rb:31:in `test_resolver_with_database_uri_and_current_env_symbol_key'
16) Failure:
ActiveRecord::ConnectionAdapters::MergeAndResolveDefaultUrlConfigTest#test_url_sub_key_with_database_url [/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/test/cases/connection_adapters/connection_handler_test.rb:164]:
--- expected
+++ actual
@@ -1 +1 @@
-{"default_env"=>{"adapter"=>"postgresql", "database"=>"foo", "host"=>"localhost"}}
+{"default_env"=>{"adapter"=>"postgresql", "database"=>"foo", "host"=>"localhost"}, "development"=>{"adapter"=>"not_postgres", "database"=>"NOT_FOO", "host"=>"localhost"}}
17) Failure:
ActiveRecord::ConnectionAdapters::MergeAndResolveDefaultUrlConfigTest#test_url_with_hyphenated_scheme [/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/test/cases/connection_adapters/connection_handler_test.rb:97]:
--- expected
+++ actual
@@ -1 +1 @@
-{"adapter"=>"ibm_db", "database"=>"foo", "host"=>"localhost"}
+{"adapter"=>"not_postgres", "database"=>"not_foo", "host"=>"localhost"}
18) Failure:
DefaultStringsTest#test_default_strings_containing_single_quotes [/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/test/cases/defaults_test.rb:59]:
Expected: "O'Connor"
Actual: "O''Connor"
19) Error:
ActiveRecord::Migration::ChangeSchemaTest#test_change_column_null:
ActiveRecord::ActiveRecordError: No such column: testings.foo
/Users/acarey/code/nextgear/sqlserver/annaswims/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/schema_statements.rb:312:in `detect_column_for!'
/Users/acarey/code/nextgear/sqlserver/annaswims/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/schema_statements.rb:136:in `change_column_null'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/migration.rb:649:in `block in method_missing'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/migration.rb:621:in `block in say_with_time'
/Users/acarey/.rvm/rubies/ruby-2.0.0-p353/lib/ruby/2.0.0/benchmark.rb:281:in `measure'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/migration.rb:621:in `say_with_time'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/migration.rb:641:in `method_missing'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/test/cases/migration/change_schema_test.rb:315:in `change'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/migration.rb:595:in `exec_migration'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/migration.rb:579:in `block (2 levels) in migrate'
/Users/acarey/.rvm/rubies/ruby-2.0.0-p353/lib/ruby/2.0.0/benchmark.rb:281:in `measure'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/migration.rb:578:in `block in migrate'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:294:in `with_connection'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/migration.rb:577:in `migrate'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/migration.rb:410:in `migrate'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/test/cases/migration/change_schema_test.rb:319:in `block (2 levels) in test_change_column_null'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/migration.rb:629:in `suppress_messages'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/test/cases/migration/change_schema_test.rb:318:in `block in test_change_column_null'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/test/cases/migration/change_schema_test.rb:383:in `testing_table_with_only_foo_attribute'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/test/cases/migration/change_schema_test.rb:312:in `test_change_column_null'
20) Error:
MigrationTest#test_create_table_with_query:
ActiveRecord::StatementInvalid: TinyTds::Error: Incorrect syntax near the keyword 'AS'.: CREATE TABLE [table_from_query_testings] AS SELECT id FROM person
/Users/acarey/code/nextgear/sqlserver/annaswims/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/database_statements.rb:368:in `do'
/Users/acarey/code/nextgear/sqlserver/annaswims/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/database_statements.rb:368:in `raw_connection_do'
/Users/acarey/code/nextgear/sqlserver/annaswims/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/database_statements.rb:327:in `block (2 levels) in do_execute'
/Users/acarey/code/nextgear/sqlserver/annaswims/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver_adapter.rb:507:in `with_sqlserver_error_handling'
/Users/acarey/code/nextgear/sqlserver/annaswims/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/database_statements.rb:327:in `block in do_execute'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:373:in `block in log'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activesupport/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:367:in `log'
/Users/acarey/code/nextgear/sqlserver/annaswims/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/database_statements.rb:326:in `do_execute'
/Users/acarey/code/nextgear/sqlserver/annaswims/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/database_statements.rb:14:in `execute'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/connection_adapters/abstract/schema_statements.rb:205:in `create_table'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/test/cases/migration_test.rb:456:in `test_create_table_with_query'
21) Error:
MigrationTest#test_create_table_with_query_from_relation:
ActiveRecord::StatementInvalid: TinyTds::Error: Incorrect syntax near the keyword 'AS'.: CREATE TABLE [table_from_query_testings] AS SELECT [people].[id] FROM [people]
/Users/acarey/code/nextgear/sqlserver/annaswims/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/database_statements.rb:368:in `do'
/Users/acarey/code/nextgear/sqlserver/annaswims/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/database_statements.rb:368:in `raw_connection_do'
/Users/acarey/code/nextgear/sqlserver/annaswims/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/database_statements.rb:327:in `block (2 levels) in do_execute'
/Users/acarey/code/nextgear/sqlserver/annaswims/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver_adapter.rb:507:in `with_sqlserver_error_handling'
/Users/acarey/code/nextgear/sqlserver/annaswims/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/database_statements.rb:327:in `block in do_execute'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:373:in `block in log'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activesupport/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:367:in `log'
/Users/acarey/code/nextgear/sqlserver/annaswims/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/database_statements.rb:326:in `do_execute'
/Users/acarey/code/nextgear/sqlserver/annaswims/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/database_statements.rb:14:in `execute'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/connection_adapters/abstract/schema_statements.rb:205:in `create_table'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/test/cases/migration_test.rb:469:in `test_create_table_with_query_from_relation'
22) Failure:
PersistenceTest#test_update_all_doesnt_ignore_order [/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/test/cases/persistence_test.rb:47]:
Query pattern(s) /\AUPDATE .+ \(SELECT .* ORDER BY id DESC\)\Z/i not found.
Queries:
EXEC sp_executesql N'UPDATE [authors] SET id = id + 1 WHERE [authors].[id] IN (SELECT TOP (9223372036854775807) [authors].[id] FROM [authors] ORDER BY id DESC); SELECT @@ROWCOUNT AS AffectedRows'
23) Failure:
PersistenceTest#test_update_attributes [/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/test/cases/persistence_test.rb:704]:
[ActiveRecord::RecordNotUnique, ActiveRecord::StatementInvalid] expected but nothing was raised.
24) Error:
PersistenceTest#test_update_columns_changing_id:
ActiveRecord::StatementInvalid: TinyTds::Error: Cannot update identity column 'id'.: EXEC sp_executesql N'UPDATE [topics] SET [topics].[id] = 123 WHERE [topics].[id] = 1; SELECT @@ROWCOUNT AS AffectedRows'
/Users/acarey/code/nextgear/sqlserver/annaswims/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/database_statements.rb:424:in `each'
/Users/acarey/code/nextgear/sqlserver/annaswims/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/database_statements.rb:424:in `handle_to_names_and_values_dblib'
/Users/acarey/code/nextgear/sqlserver/annaswims/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/database_statements.rb:413:in `handle_to_names_and_values'
/Users/acarey/code/nextgear/sqlserver/annaswims/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/database_statements.rb:385:in `_raw_select'
/Users/acarey/code/nextgear/sqlserver/annaswims/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/database_statements.rb:379:in `block in raw_select'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:373:in `block in log'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activesupport/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:367:in `log'
/Users/acarey/code/nextgear/sqlserver/annaswims/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/database_statements.rb:379:in `raw_select'
/Users/acarey/code/nextgear/sqlserver/annaswims/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/database_statements.rb:362:in `do_exec_query'
/Users/acarey/code/nextgear/sqlserver/annaswims/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/database_statements.rb:33:in `exec_query'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:92:in `exec_update'
/Users/acarey/code/nextgear/sqlserver/annaswims/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/database_statements.rb:49:in `exec_update'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:111:in `update'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:14:in `update'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/relation.rb:327:in `update_all'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/persistence.rb:278:in `update_columns'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/test/cases/persistence_test.rb:654:in `test_update_columns_changing_id'
25) Error:
RelationMergingTest#test_merging_reorders_bind_params:
ActiveRecord::StatementInvalid: TinyTds::Error: Conversion failed when converting the nvarchar value 'Welcome to the weblog' to data type int.: EXEC sp_executesql N'SELECT TOP (1) [posts].* FROM [posts] WHERE [posts].[title] = @0 AND [posts].[id] = @0 ORDER BY [posts].[id] ASC', N'@0 nvarchar(255), @1 int', @0 = N'Welcome to the weblog', @1 = 1
/Users/acarey/code/nextgear/sqlserver/annaswims/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/database_statements.rb:424:in `each'
/Users/acarey/code/nextgear/sqlserver/annaswims/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/database_statements.rb:424:in `handle_to_names_and_values_dblib'
/Users/acarey/code/nextgear/sqlserver/annaswims/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/database_statements.rb:413:in `handle_to_names_and_values'
/Users/acarey/code/nextgear/sqlserver/annaswims/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/database_statements.rb:385:in `_raw_select'
/Users/acarey/code/nextgear/sqlserver/annaswims/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/database_statements.rb:379:in `block in raw_select'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:373:in `block in log'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activesupport/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:367:in `log'
/Users/acarey/code/nextgear/sqlserver/annaswims/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/database_statements.rb:379:in `raw_select'
/Users/acarey/code/nextgear/sqlserver/annaswims/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/database_statements.rb:362:in `do_exec_query'
/Users/acarey/code/nextgear/sqlserver/annaswims/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/database_statements.rb:33:in `exec_query'
/Users/acarey/code/nextgear/sqlserver/annaswims/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/database_statements.rb:305:in `select'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:31:in `select_all'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:69:in `select_all'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/querying.rb:39:in `find_by_sql'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/relation.rb:603:in `exec_queries'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/relation.rb:487:in `load'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/relation.rb:231:in `to_a'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/relation/finder_methods.rb:465:in `find_nth_with_limit'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/relation/finder_methods.rb:459:in `find_nth'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/relation/finder_methods.rb:132:in `first'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/test/cases/relation/merging_test.rb:129:in `test_merging_reorders_bind_params'
26) Failure:
ActiveRecord::PredicateBuilderTest#test_registering_new_handlers [/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/test/cases/relation/predicate_builder_test.rb:11]:
Expected /["`]topics["`].["`]title["`] ~ 'rails'/i to match "SELECT [topics].* FROM [topics] WHERE ([topics].[title] ~ N'rails')".
27) Error:
TransactionTest#test_releasing_named_savepoints:
ArgumentError: wrong number of arguments (1 for 0)
/Users/acarey/code/nextgear/sqlserver/annaswims/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/database_statements.rb:68:in `create_savepoint'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/test/cases/transactions_test.rb:398:in `block in test_releasing_named_savepoints'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:211:in `block in transaction'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:219:in `within_new_transaction'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:211:in `transaction'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/transactions.rb:208:in `transaction'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/test/cases/transactions_test.rb:397:in `test_releasing_named_savepoints'
28) Error:
TransactionTest#test_using_named_savepoints:
ArgumentError: wrong number of arguments (1 for 0)
/Users/acarey/code/nextgear/sqlserver/annaswims/activerecord-sqlserver-adapter/lib/active_record/connection_adapters/sqlserver/database_statements.rb:68:in `create_savepoint'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/test/cases/transactions_test.rb:382:in `block in test_using_named_savepoints'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:211:in `block in transaction'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:219:in `within_new_transaction'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:211:in `transaction'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/lib/active_record/transactions.rb:208:in `transaction'
/Users/acarey/.rvm/gems/ruby-2.0.0-p353/bundler/gems/rails-2ef79cdd9122/activerecord/test/cases/transactions_test.rb:379:in `test_using_named_savepoints'
4691 runs, 12185 assertions, 18 failures, 10 errors, 2 skips
@maysam
Copy link

maysam commented Aug 9, 2014

what was the solution for #15 (default_env' database is not configured) ?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment