Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jesk/8687668 to your computer and use it in GitHub Desktop.
Save jesk/8687668 to your computer and use it in GitHub Desktop.
Results of Tests for activrecord_jdbc_adapter with "rake test_mssql"
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
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)
===============================================================================
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
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