Last active
August 29, 2015 13:55
-
-
Save jesk/8687668 to your computer and use it in GitHub Desktop.
Results of Tests for activrecord_jdbc_adapter with "rake test_mssql"
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
Using ActiveRecord::VERSION = 3.0.20 | |
MASTER | |
180 tests, 384 assertions, 1 failures, 3 errors, 0 pendings, 1 omissions, 0 notifications | |
97.7654% passed | |
FORK | |
180 tests, 386 assertions, 1 failures, 2 errors, 0 pendings, 1 omissions, 0 notifications | |
98.3240% passed | |
============= | |
Using ActiveRecord::VERSION = 3.1.12 | |
MASTER | |
195 tests, 419 assertions, 1 failures, 1 errors, 0 pendings, 1 omissions, 0 notifications | |
98.9691% passed | |
FORK | |
195 tests, 421 assertions, 1 failures, 0 errors, 0 pendings, 1 omissions, 0 notifications | |
99.4845% passed | |
============= | |
Using ActiveRecord::VERSION = 4.0.2 | |
MASTER | |
Test execution hangs | |
FORK | |
Test execution hangs | |
============= | |
Using ActiveRecord::VERSION = 4.1.0.beta1 | |
MASTER | |
Test execution hangs | |
FORK | |
Test execution hangs |
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
The following error occurs in master, but not in my fork ;) | |
=============================================================================== | |
.E, [2014-01-29T14:44:05.140000 #8852] ERROR -- : ActiveRecord::JDBCError: Column 'long_ships.id' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.: SELECT t.* FROM ( SELECT ROW_NUMBER() OVER(ORDER BY long_ships.id) AS _row_num, [long_ships].[name] FROM [long_ships] GROUP BY name ) AS t WHERE t._row_num BETWEEN 1 AND 2 | |
E | |
=============================================================================== | |
Error: test_limit_with_group_by(MSSQLLimitOffsetTest) | |
ActiveRecord::StatementInvalid: ActiveRecord::JDBCError: Column 'long_ships.id' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.: SELECT t.* FROM ( SELECT ROW_NUMBER() OVER(ORDER BY long_ships.id) AS _row_num, [long_ships].[name] FROM [long_ships] GROUP BY name ) AS t WHERE t._row_num BETWEEN 1 AND 2 | |
arjdbc/jdbc/RubyJdbcConnection.java:838:in `execute_query' | |
/Users/jesko/tmp/activerecord-jdbc-adapter-orig2/lib/arjdbc/mssql/adapter.rb:562:in `exec_query' | |
/Users/jesko/.rvm/gems/jruby-1.7.8@jdbcadapter_test2/bundler/gems/rails-f142527eb306/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:367:in `log' | |
/Users/jesko/.rvm/gems/jruby-1.7.8@jdbcadapter_test2/bundler/gems/rails-f142527eb306/activesupport/lib/active_support/notifications/instrumenter.rb:20:in `instrument' | |
/Users/jesko/.rvm/gems/jruby-1.7.8@jdbcadapter_test2/bundler/gems/rails-f142527eb306/activesupport/lib/active_support/notifications/instrumenter.rb:19:in `instrument' | |
/Users/jesko/.rvm/gems/jruby-1.7.8@jdbcadapter_test2/bundler/gems/rails-f142527eb306/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:361:in `log' | |
/Users/jesko/tmp/activerecord-jdbc-adapter-orig2/lib/arjdbc/mssql/adapter.rb:562:in `exec_query' | |
/Users/jesko/tmp/activerecord-jdbc-adapter-orig2/lib/arjdbc/jdbc/adapter.rb:518:in `select' | |
/Users/jesko/.rvm/gems/jruby-1.7.8@jdbcadapter_test2/bundler/gems/rails-f142527eb306/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:23:in `select_all' | |
/Users/jesko/.rvm/gems/jruby-1.7.8@jdbcadapter_test2/bundler/gems/rails-f142527eb306/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:69:in `select_all' | |
/Users/jesko/.rvm/gems/jruby-1.7.8@jdbcadapter_test2/bundler/gems/rails-f142527eb306/activerecord/lib/active_record/querying.rb:39:in `find_by_sql' | |
/Users/jesko/.rvm/gems/jruby-1.7.8@jdbcadapter_test2/bundler/gems/rails-f142527eb306/activerecord/lib/active_record/relation.rb:603:in `exec_queries' | |
/Users/jesko/.rvm/gems/jruby-1.7.8@jdbcadapter_test2/bundler/gems/rails-f142527eb306/activerecord/lib/active_record/relation.rb:487:in `load' | |
/Users/jesko/.rvm/gems/jruby-1.7.8@jdbcadapter_test2/bundler/gems/rails-f142527eb306/activerecord/lib/active_record/relation.rb:231:in `to_a' | |
/Users/jesko/.rvm/gems/jruby-1.7.8@jdbcadapter_test2/bundler/gems/rails-f142527eb306/activerecord/lib/active_record/relation/delegation.rb:46:in `map' | |
/Users/jesko/tmp/activerecord-jdbc-adapter-orig2/test/db/mssql/limit_offset_test.rb:179:in `test_limit_with_group_by' | |
176: LongShip.create!(:name => name) | |
177: end | |
178: ships = LongShip.select(:name).group(:name).limit(2).all | |
=> 179: assert_equal ['one', 'two'], ships.map(&:name) | |
180: | |
181: ships = LongShip.select(:name).group(:name).limit(2).offset(2) | |
182: assert_equal ['three', 'four'], ships.map(&:name) | |
=============================================================================== |
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
HINT: specify AR version with `rake appraisal:{version} test_{adapter}' where version=(rails23|rails30|rails31|rails32|rails40|rails41) (`touch .disable-appraisal-hint' to disable) | |
Using ActiveRecord::VERSION = 3.2.16 | |
MSSQLMultipleConnectionsTest skipped since no second MS-SQL database configured | |
Loaded suite /Users/jesko/.rvm/gems/jruby-1.7.8@jdbcadapter_test2/gems/rake-10.1.1/lib/rake/rake_test_loader | |
Started | |
....................................................ArJdbc: double loading /Users/jesko/tmp/activerecord-jdbc-adapter/lib/arjdbc/tasks/databases.rake please delete lib/tasks/jdbc.rake if present! | |
.ArJdbc: double loading /Users/jesko/tmp/activerecord-jdbc-adapter/lib/arjdbc/tasks/databases.rake please delete lib/tasks/jdbc.rake if present! | |
.ArJdbc: double loading /Users/jesko/tmp/activerecord-jdbc-adapter/lib/arjdbc/tasks/databases.rake please delete lib/tasks/jdbc.rake if present! | |
.ArJdbc: double loading /Users/jesko/tmp/activerecord-jdbc-adapter/lib/arjdbc/tasks/databases.rake please delete lib/tasks/jdbc.rake if present! | |
O | |
=============================================================================== | |
smoscript not available [test: rake db:structure:dump (and db:structure:load)(MSSQLRakeDbCreateTest)] | |
/Users/jesko/tmp/activerecord-jdbc-adapter/test/db/mssql/rake_test.rb:53:in `test: rake db:structure:dump (and db:structure:load)' | |
=============================================================================== | |
ArJdbc: double loading /Users/jesko/tmp/activerecord-jdbc-adapter/lib/arjdbc/tasks/databases.rake please delete lib/tasks/jdbc.rake if present! | |
...................................................................... | |
. | |
........ | |
.............................F | |
=============================================================================== | |
Failure: | |
<2007-01-01 00:00:00 UTC> expected to be an instance of | |
<Date> but was | |
<Time>. | |
test_save_date(MSSQLSimpleTest) | |
/Users/jesko/tmp/activerecord-jdbc-adapter/test/simple.rb:1230:in `assert_date_type' | |
/Users/jesko/tmp/activerecord-jdbc-adapter/test/simple.rb:380:in `test_save_date' | |
377: e = DbType.new | |
378: e.sample_date = date | |
379: e.save!; e.reload | |
=> 380: assert_date_type e.sample_date | |
381: assert_date_equal date, e.sample_date | |
382: end | |
383: | |
=============================================================================== | |
................................. | |
Finished in 42.122 seconds. | |
198 tests, 426 assertions, 1 failures, 0 errors, 0 pendings, 1 omissions, 0 notifications | |
99.4924% passed | |
4.70 tests/s, 10.11 assertions/s |
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
HINT: specify AR version with `rake appraisal:{version} test_{adapter}' where version=(rails23|rails30|rails31|rails32|rails40|rails41) (`touch .disable-appraisal-hint' to disable) | |
Using ActiveRecord::VERSION = 3.2.16 | |
MSSQLMultipleConnectionsTest skipped since no second MS-SQL database configured | |
Loaded suite /Users/jesko/.rvm/gems/jruby-1.7.8@jdbcadapter_test2/gems/rake-10.1.1/lib/rake/rake_test_loader | |
Started | |
...................E | |
=============================================================================== | |
Error: test_limit_with_group_by(MSSQLLimitOffsetTest) | |
ActiveRecord::StatementInvalid: ActiveRecord::JDBCError: Column 'long_ships.id' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.: SELECT t.* FROM ( SELECT ROW_NUMBER() OVER(ORDER BY long_ships.id) AS _row_num, name FROM [long_ships] GROUP BY name ) AS t WHERE t._row_num BETWEEN 1 AND 2 | |
arjdbc/jdbc/RubyJdbcConnection.java:725:in `execute_query_raw' | |
/Users/jesko/tmp/activerecord-jdbc-adapter-orig2/lib/arjdbc/mssql/adapter.rb:576:in `exec_query_raw' | |
/Users/jesko/.rvm/gems/jruby-1.7.8@jdbcadapter_test2/gems/activerecord-3.2.16/lib/active_record/connection_adapters/abstract_adapter.rb:280:in `log' | |
/Users/jesko/.rvm/gems/jruby-1.7.8@jdbcadapter_test2/gems/activesupport-3.2.16/lib/active_support/notifications/instrumenter.rb:20:in `instrument' | |
/Users/jesko/.rvm/gems/jruby-1.7.8@jdbcadapter_test2/gems/activesupport-3.2.16/lib/active_support/notifications/instrumenter.rb:19:in `instrument' | |
/Users/jesko/.rvm/gems/jruby-1.7.8@jdbcadapter_test2/gems/activerecord-3.2.16/lib/active_record/connection_adapters/abstract_adapter.rb:275:in `log' | |
/Users/jesko/tmp/activerecord-jdbc-adapter-orig2/lib/arjdbc/mssql/adapter.rb:576:in `exec_query_raw' | |
/Users/jesko/tmp/activerecord-jdbc-adapter-orig2/lib/arjdbc/jdbc/adapter.rb:525:in `select' | |
/Users/jesko/.rvm/gems/jruby-1.7.8@jdbcadapter_test2/gems/activerecord-3.2.16/lib/active_record/connection_adapters/abstract/database_statements.rb:18:in `select_all' | |
/Users/jesko/.rvm/gems/jruby-1.7.8@jdbcadapter_test2/gems/activerecord-3.2.16/lib/active_record/connection_adapters/abstract/query_cache.rb:63:in `select_all' | |
/Users/jesko/.rvm/gems/jruby-1.7.8@jdbcadapter_test2/gems/activerecord-3.2.16/lib/active_record/querying.rb:38:in `find_by_sql' | |
/Users/jesko/.rvm/gems/jruby-1.7.8@jdbcadapter_test2/gems/activerecord-3.2.16/lib/active_record/explain.rb:41:in `logging_query_plan' | |
/Users/jesko/.rvm/gems/jruby-1.7.8@jdbcadapter_test2/gems/activerecord-3.2.16/lib/active_record/querying.rb:37:in `find_by_sql' | |
/Users/jesko/.rvm/gems/jruby-1.7.8@jdbcadapter_test2/gems/activerecord-3.2.16/lib/active_record/relation.rb:171:in `exec_queries' | |
/Users/jesko/.rvm/gems/jruby-1.7.8@jdbcadapter_test2/gems/activerecord-3.2.16/lib/active_record/relation.rb:160:in `to_a' | |
/Users/jesko/.rvm/gems/jruby-1.7.8@jdbcadapter_test2/gems/activerecord-3.2.16/lib/active_record/explain.rb:41:in `logging_query_plan' | |
/Users/jesko/.rvm/gems/jruby-1.7.8@jdbcadapter_test2/gems/activerecord-3.2.16/lib/active_record/relation.rb:159:in `to_a' | |
/Users/jesko/.rvm/gems/jruby-1.7.8@jdbcadapter_test2/gems/activerecord-3.2.16/lib/active_record/relation/finder_methods.rb:159:in `all' | |
/Users/jesko/tmp/activerecord-jdbc-adapter-orig2/test/db/mssql/limit_offset_test.rb:178:in `test_limit_with_group_by' | |
175: %w( one two three four five six seven eight ).each do |name| | |
176: LongShip.create!(:name => name) | |
177: end | |
=> 178: ships = LongShip.select(:name).group(:name).limit(2).all | |
179: assert_equal ['one', 'two'], ships.map(&:name) | |
180: | |
181: ships = LongShip.select(:name).group(:name).limit(2).offset(2) | |
=============================================================================== | |
................................ArJdbc: double loading /Users/jesko/tmp/activerecord-jdbc-adapter-orig2/lib/arjdbc/tasks/databases.rake please delete lib/tasks/jdbc.rake if present! | |
.ArJdbc: double loading /Users/jesko/tmp/activerecord-jdbc-adapter-orig2/lib/arjdbc/tasks/databases.rake please delete lib/tasks/jdbc.rake if present! | |
.ArJdbc: double loading /Users/jesko/tmp/activerecord-jdbc-adapter-orig2/lib/arjdbc/tasks/databases.rake please delete lib/tasks/jdbc.rake if present! | |
.ArJdbc: double loading /Users/jesko/tmp/activerecord-jdbc-adapter-orig2/lib/arjdbc/tasks/databases.rake please delete lib/tasks/jdbc.rake if present! | |
O | |
=============================================================================== | |
smoscript not available [test: rake db:structure:dump (and db:structure:load)(MSSQLRakeDbCreateTest)] | |
/Users/jesko/tmp/activerecord-jdbc-adapter-orig2/test/db/mssql/rake_test.rb:53:in `test: rake db:structure:dump (and db:structure:load)' | |
=============================================================================== | |
ArJdbc: double loading /Users/jesko/tmp/activerecord-jdbc-adapter-orig2/lib/arjdbc/tasks/databases.rake please delete lib/tasks/jdbc.rake if present! | |
...................................................................... | |
. | |
........ | |
.............................F | |
=============================================================================== | |
Failure: | |
<2007-01-01 00:00:00 UTC> expected to be an instance of | |
<Date> but was | |
<Time>. | |
test_save_date(MSSQLSimpleTest) | |
/Users/jesko/tmp/activerecord-jdbc-adapter-orig2/test/simple.rb:1230:in `assert_date_type' | |
/Users/jesko/tmp/activerecord-jdbc-adapter-orig2/test/simple.rb:380:in `test_save_date' | |
377: e = DbType.new | |
378: e.sample_date = date | |
379: e.save!; e.reload | |
=> 380: assert_date_type e.sample_date | |
381: assert_date_equal date, e.sample_date | |
382: end | |
383: | |
=============================================================================== | |
................................. | |
Finished in 42.241 seconds. | |
198 tests, 424 assertions, 1 failures, 1 errors, 0 pendings, 1 omissions, 0 notifications | |
98.9848% passed | |
4.69 tests/s, 10.04 assertions/s |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment