Problems running ActiveRecord test

[ffrancy]

I downloaded the source code of ActiveRecord 2.3.2 and I put it in
NetBeansProject folder (I use that IDE).

I opened it as a Ruby project with existing source. I had also to put
activesupport and the other gems in the same folder of ActiveRecord.

Tests works but this following errors:

Finished in 71.143069 seconds.

1) Failure:
test_add_limit_offset_should_sanitize_sql_injection_for_limit_with_comas(AdapterTest)
[test/cases/adapter_test.rb:129:in `test_add_limit_offset_should_sanitize_sql_injection_for_limit_with_comas'
./test/cases/../../../activesupport/lib/active_support/testing/setup_and_teardown.rb:62:in `run']:
<" LIMIT 1,7"> expected but was
<" LIMIT 1, 7 procedure help()">.

2) Failure:
test_add_limit_offset_should_sanitize_sql_injection_for_limit_without_comas(AdapterTest)
[test/cases/adapter_test.rb:115:in `test_add_limit_offset_should_sanitize_sql_injection_for_limit_without_comas'
./test/cases/../../../activesupport/lib/active_support/testing/setup_and_teardown.rb:62:in `run']:
<" LIMIT 1"> expected but was
<" LIMIT 1 select * from schema">.

3) Failure:
test_read_attributes_before_type_cast_on_datetime(BasicsTest)
[test/cases/base_test.rb:148:in `test_read_attributes_before_type_cast_on_datetime'
./test/cases/../../../activesupport/lib/active_support/testing/setup_and_teardown.rb:62:in `run']:
<"2009-06-09 09:29:03"> expected but was
<"2009-06-09 09:29:03.0">.

4) Failure:
test_update_all_with_order_and_limit_updates_subset_only(BasicsTest)
[test/cases/base_test.rb:693:in `test_update_all_with_order_and_limit_updates_subset_only'
./test/cases/../../../activesupport/lib/active_support/testing/setup_and_teardown.rb:62:in `run']:
Exception raised:
Class: <ActiveRecord::StatementInvalid>
Message: <"ActiveRecord::ActiveRecordError: This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery': UPDATE `posts` SET body = 'bulk update!' WHERE `id` IN (SELECT `id` FROM `posts` WHERE (`posts`.author_id = 1) ORDER BY posts.id LIMIT 1)">
---Backtrace---
./test/cases/../../lib/active_record/connection_adapters/abstract_adapter.rb:212:in `log'
/home/ffrancy/.gem/jruby/1.8/gems/activerecord-jdbc-adapter-0.9.1/lib/active_record/connection_adapters/jdbc_adapter.rb:563:in `execute'
./test/cases/helper.rb:37:in `execute_with_query_record'
/home/ffrancy/.gem/jruby/1.8/gems/activerecord-jdbc-adapter-0.9.1/lib/active_record/connection_adapters/jdbc_adapter.rb:582:in `jdbc_update'
./test/cases/../../lib/active_record/connection_adapters/abstract/query_cache.rb:25:in `update_with_query_dirty'
./test/cases/../../lib/active_record/base.rb:852:in `update_all'
./test/cases/../../lib/active_record/associations/association_collection.rb:375:in `method_missing'
./test/cases/../../lib/active_record/base.rb:2148:in `with_scope'
./test/cases/../../lib/active_record/associations/association_proxy.rb:206:in `with_scope'
./test/cases/../../lib/active_record/associations/association_collection.rb:371:in `method_missing'
test/cases/base_test.rb:696:in `test_update_all_with_order_and_limit_updates_subset_only'
test/cases/base_test.rb:693:in `test_update_all_with_order_and_limit_updates_subset_only'
./test/cases/../../../activesupport/lib/active_support/testing/setup_and_teardown.rb:62:in `run'
---------------

5) Failure:
test_integer_creates_integer_column(ChangeTableMigrationsTest)
[(eval):16:in `integer'
(eval):5:in `each'
(eval):5:in `integer'
test/cases/migration_test.rb:1399:in `test_integer_creates_integer_column'
test/cases/migration_test.rb:1491:in `with_change_table'
./test/cases/../../lib/active_record/connection_adapters/abstract/schema_statements.rb:175:in `change_table'
test/cases/migration_test.rb:1490:in `with_change_table'
test/cases/migration_test.rb:1396:in `test_integer_creates_integer_column'
./test/cases/../../../activesupport/lib/active_support/testing/setup_and_teardown.rb:62:in `run']:
unexpected invocation: #<ActiveRecord::ConnectionAdapters::JdbcAdapter:0x18b8>.add_column(:delete_me, :foo, 'integer(10)', {})
unsatisfied expectations:
- expected exactly once, not yet invoked: #<ActiveRecord::ConnectionAdapters::JdbcAdapter:0x18b8>.add_column(:delete_me, :bar, 'integer', {})
- expected exactly once, not yet invoked: #<ActiveRecord::ConnectionAdapters::JdbcAdapter:0x18b8>.add_column(:delete_me, :foo, 'integer', {})

6) Error:
test_create_table_with_defaults(MigrationTest):
ActiveRecord::StatementInvalid: ActiveRecord::ActiveRecordError: BLOB/TEXT column 'five' can't have a default value: CREATE TABLE `testings` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `one` varchar(255) DEFAULT 'hello', `two` tinyint(1) DEFAULT 1, `three` tinyint(1) DEFAULT 0, `four` integer(10) DEFAULT 1, `five` text DEFAULT 'hello') ENGINE=InnoDB CHARACTER SET `utf8`
./test/cases/../../lib/active_record/connection_adapters/abstract_adapter.rb:212:in `log'
/home/ffrancy/.gem/jruby/1.8/gems/activerecord-jdbc-adapter-0.9.1/lib/active_record/connection_adapters/jdbc_adapter.rb:563:in `execute'
./test/cases/helper.rb:37:in `execute_with_query_record'
./test/cases/../../lib/active_record/connection_adapters/abstract/schema_statements.rb:114:in `create_table'
/home/ffrancy/.gem/jruby/1.8/gems/activerecord-jdbc-adapter-0.9.1/lib/jdbc_adapter/jdbc_mysql.rb:171:in `create_table'
test/cases/migration_test.rb:149:in `test_create_table_with_defaults'
./test/cases/../../../activesupport/lib/active_support/testing/setup_and_teardown.rb:62:in `run'

7) Failure:
test_keeping_default_and_notnull_constaint_on_change(MigrationTest)
[test/cases/migration_test.rb:775:in `test_keeping_default_and_notnull_constaint_on_change'
./test/cases/../../../activesupport/lib/active_support/testing/setup_and_teardown.rb:62:in `run']:
<false> expected but was
<true>.

Failure:
test_rename_column_preserves_default_value_not_null(MigrationTest)
[test/cases/migration_test.rb:556:in `test_rename_column_preserves_default_value_not_null'
./test/cases/../../../activesupport/lib/active_support/testing/setup_and_teardown.rb:62:in `run']:
<70000> expected but was
<nil>.

9) Failure:
test_rename_nonexistent_column(MigrationTest)
[test/cases/migration_test.rb:572:in `test_rename_nonexistent_column'
./test/cases/../../../activesupport/lib/active_support/testing/setup_and_teardown.rb:62:in `run']:
<ActiveRecord::ActiveRecordError> exception expected but was
Class: <NoMethodError>
Message: <"undefined method `[]' for nil:NilClass">
---Backtrace---
/home/ffrancy/.gem/jruby/1.8/gems/activerecord-jdbc-adapter-0.9.1/lib/jdbc_adapter/jdbc_mysql.rb:200:in `rename_column'
test/cases/migration_test.rb:573:in `test_rename_nonexistent_column'
test/cases/migration_test.rb:572:in `test_rename_nonexistent_column'
./test/cases/../../../activesupport/lib/active_support/testing/setup_and_teardown.rb:62:in `run'
---------------

10) Failure:
test_count_queries_with_cache(QueryCacheTest)
[./test/cases/../../lib/active_record/test_case.rb:31:in `assert_queries'
test/cases/query_cache_test.rb:25:in `test_count_queries_with_cache'
./test/cases/../../lib/active_record/connection_adapters/abstract/query_cache.rb:34:in `cache'
./test/cases/../../lib/active_record/query_cache.rb:9:in `cache'
test/cases/query_cache_test.rb:24:in `test_count_queries_with_cache'
./test/cases/../../../activesupport/lib/active_support/testing/setup_and_teardown.rb:62:in `run']:
2 instead of 1 queries were executed.
Queries:
SELECT count(*) AS count_all FROM `tasks`
SELECT count(*) AS count_all FROM `tasks` .
<1> expected but was
<2>.

11) Failure:
test_schema_dump_includes_limit_constraint_for_integer_columns(SchemaDumperTest)
[test/cases/schema_dumper_test.rb:113:in `test_schema_dump_includes_limit_constraint_for_integer_columns'
./test/cases/../../../activesupport/lib/active_support/testing/setup_and_teardown.rb:62:in `run']:
<"# This file is auto-generated from the current state of the database. Instead of editing this file, \n# please use the migrations feature of Active Record to incrementally modify your database, and\n# then regenerate this schema definition.\n#\n# Note that this schema.rb definition is the authoritative source for your database schema. If you need\n# to create the application database on another system, you should be using db:schema:load, not running\n# all the migrations from scratch. The latter is a flawed and unsustainable approach (the more migrations\n# you'll amass, the slower it'll run and the greater likelihood for issues).\n#\n# It's strongly recommended to check this file into your version control system.\n\nActiveRecord::Schema.define(:version => 0) do\n\n create_table \"integer_limits\", :force => true do |t|\n t.integer \"c_int_without_limit\"\n t.integer \"c_int_1\", :limit => 1\n t.integer \"c_int_2\", :limit => 2\n t.integer \"c_int_3\", :limit => 3\n t.integer \"c_int_4\", :limit => 4\n t.integer \"c_int_5\", :limit => 5\n t.integer \"c_int_6\", :limit => 6\n t.integer \"c_int_7\", :limit => 7\n t.integer \"c_int_8\", :limit => 8\n end\n\nend\n"> expected to be =~
</c_int_5.*:limit => 8/>.

12) Failure:
test_underlying_adapter_no_longer_active(TestUnconnectedAdapter)
[test/cases/unconnected_test.rb:30:in `test_underlying_adapter_no_longer_active'
./test/cases/../../../activesupport/lib/active_support/testing/setup_and_teardown.rb:62:in `run']:
Removed adapter should no longer be active.
<false> is not true.

13) Failure:
test_optionally_validates_length_of_using_within_on_create_utf8(ValidationsTest)
[test/cases/validations_test.rb:1074:in `test_optionally_validates_length_of_using_within_on_create_utf8'
./test/cases/../../lib/active_record/test_case.rb:57:in `with_kcode'
test/cases/validations_test.rb:1065:in `test_optionally_validates_length_of_using_within_on_create_utf8'
./test/cases/../../../activesupport/lib/active_support/testing/setup_and_teardown.rb:62:in `run']:
<false> is not true.

14) Failure:
test_optionally_validates_length_of_using_within_on_update_utf8(ValidationsTest)
[test/cases/validations_test.rb:1092:in `test_optionally_validates_length_of_using_within_on_update_utf8'
./test/cases/../../lib/active_record/test_case.rb:57:in `with_kcode'
test/cases/validations_test.rb:1088:in `test_optionally_validates_length_of_using_within_on_update_utf8'
./test/cases/../../../activesupport/lib/active_support/testing/setup_and_teardown.rb:62:in `run']:
<false> is not true.

15) Failure:
test_optionally_validates_length_of_using_within_utf8(ValidationsTest)
[test/cases/validations_test.rb:1054:in `test_optionally_validates_length_of_using_within_utf8'
./test/cases/../../lib/active_record/test_case.rb:57:in `with_kcode'
test/cases/validations_test.rb:1050:in `test_optionally_validates_length_of_using_within_utf8'
./test/cases/../../../activesupport/lib/active_support/testing/setup_and_teardown.rb:62:in `run']:
#<ActiveRecord::Errors:0x512bcf @errors={"title"=>["is too long (maximum is 5 characters)"]}, @base=#<Topic id: nil, title: "一二三四五", author_name: nil, author_email_address: "test@test.com", written_on: nil, bonus_time: nil, last_read: nil, content: nil, approved: true, replies_count: 0, parent_id: nil, type: nil>>.
<false> is not true.

16) Failure:
test_validate_case_sensitive_uniqueness(ValidationsTest)
[test/cases/validations_test.rb:485:in `test_validate_case_sensitive_uniqueness'
./test/cases/../../../activesupport/lib/active_support/testing/setup_and_teardown.rb:62:in `run']:
Should be valid.
<false> is not true.

17) Failure:
test_validates_length_of_using_is_utf8(ValidationsTest)
[test/cases/validations_test.rb:1114:in `test_validates_length_of_using_is_utf8'
./test/cases/../../lib/active_record/test_case.rb:57:in `with_kcode'
test/cases/validations_test.rb:1110:in `test_validates_length_of_using_is_utf8'
./test/cases/../../../activesupport/lib/active_support/testing/setup_and_teardown.rb:62:in `run']:
<false> is not true.

1 Failure:
test_validates_length_of_using_maximum_utf8(ValidationsTest)
[test/cases/validations_test.rb:1026:in `test_validates_length_of_using_maximum_utf8'
./test/cases/../../lib/active_record/test_case.rb:57:in `with_kcode'
test/cases/validations_test.rb:1022:in `test_validates_length_of_using_maximum_utf8'
./test/cases/../../../activesupport/lib/active_support/testing/setup_and_teardown.rb:62:in `run']:
<false> is not true.

19) Failure:
test_validates_length_of_using_minimum_utf8(ValidationsTest)
[test/cases/validations_test.rb:1015:in `test_validates_length_of_using_minimum_utf8'
./test/cases/../../lib/active_record/test_case.rb:57:in `with_kcode'
test/cases/validations_test.rb:1008:in `test_validates_length_of_using_minimum_utf8'
./test/cases/../../../activesupport/lib/active_support/testing/setup_and_teardown.rb:62:in `run']:
<false> is not true.

20) Failure:
test_validates_length_of_using_within_utf8(ValidationsTest)
[test/cases/validations_test.rb:1041:in `test_validates_length_of_using_within_utf8'
./test/cases/../../lib/active_record/test_case.rb:57:in `with_kcode'
test/cases/validations_test.rb:1036:in `test_validates_length_of_using_within_utf8'
./test/cases/../../../activesupport/lib/active_support/testing/setup_and_teardown.rb:62:in `run']:
<"is too short (minimum is 3 characters)"> expected but was
<"is too long (maximum is 5 characters)">.

2013 tests, 6503 assertions, 19 failures, 1 errors
rake aborted!
Command failed with status (1): [/opt/jruby/bin/jruby -Ilib:test:test/conne...]


I have to say that I'm using JRuby 1.6, Glassfish V 3 Prelude, Rails 2.2.2 and NetBeans IDE.

How can I make everything work?
Do I have to upgrade something?

And also, if I have to use rails 2.3.2, how can I make it work with
glassfish?

Thank you in advance!

[Erno Mononen]

Hi,

Unfortunately I can't really help with the AR test failures (except that
they seem to require a newer MySQL version than you have). Wrt. Rails
2.3.2 and GlassFish, there will be a new V3 prelude release that
supports Rails 2.3.2. NB 6.7 FCS will bundle that relese. Meanwhile you
can use the GF gem (http://rubyforge.org/projects/glassfishgem).

Cheers,
Erno


ffrancy wrote: