New problems with ActiveRecord tests

I tried to use ActiveRecord 2.3.2, opened ad as a Ruby project with
existing source, to run its tests and they worked but with 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:inrun’]:
    <" 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:inrun’]:
    <" 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:inrun’]:
    <“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:inrun’]:
    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:inexecute’
    ./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:injdbc_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:inupdate_all’
    ./test/cases/…/…/lib/active_record/associations/association_collection.rb:375:in
    method_missing' ./test/cases/../../lib/active_record/base.rb:2148:inwith_scope’
    ./test/cases/…/…/lib/active_record/associations/association_proxy.rb:206:in
    with_scope' ./test/cases/../../lib/active_record/associations/association_collection.rb:371:inmethod_missing’
    test/cases/base_test.rb:696:in
    test_update_all_with_order_and_limit_updates_subset_only' test/cases/base_test.rb:693:intest_update_all_with_order_and_limit_updates_subset_only’
    ./test/cases/…/…/…/activesupport/lib/active_support/testing/setup_and_teardown.rb:62:in
    `run’


  1. Failure:
    test_integer_creates_integer_column(ChangeTableMigrationsTest)
    [(eval):16:in integer' (eval):5:ineach’
    (eval):5:in integer' test/cases/migration_test.rb:1399:intest_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:inchange_table’
    test/cases/migration_test.rb:1490:in with_change_table' test/cases/migration_test.rb:1396:intest_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’, {})

    1. 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:inexecute’
      ./test/cases/helper.rb:37:in execute_with_query_record' ./test/cases/../../lib/active_record/connection_adapters/abstract/schema_statements.rb:114:increate_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:intest_create_table_with_defaults’
      ./test/cases/…/…/…/activesupport/lib/active_support/testing/setup_and_teardown.rb:62:in
      `run’

    2. 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:inrun’]:
      expected but was
      .

    3. 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:inrun’]:
      <70000> expected but was
      .

    4. 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:inrun’]:
      ActiveRecord::ActiveRecordError exception expected but was
      Class:
      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:inrename_column’
      test/cases/migration_test.rb:573:in test_rename_nonexistent_column' test/cases/migration_test.rb:572:intest_rename_nonexistent_column’
      ./test/cases/…/…/…/activesupport/lib/active_support/testing/setup_and_teardown.rb:62:in
      `run’


  1. 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:intest_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:incache’
    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:inrun’]:
    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>.

  2. 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:inrun’]:
    <"# 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/>.

  3. 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:inrun’]:
    Removed adapter should no longer be active.
    is not true.

  4. 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:inwith_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:inrun’]:
    is not true.

  5. 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:inwith_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:inrun’]:
    is not true.

  6. 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:inwith_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:inrun’]:
    #<ActiveRecord::Errors:0x512bcf @errors={“title”=>[“is too long (maximum
    is 5 characters)”]}, @base=#<Topic id: nil, title: “一二三四五”, author_name:
    nil, author_email_address: “[email protected]”, written_on: nil, bonus_time:
    nil, last_read: nil, content: nil, approved: true, replies_count: 0,
    parent_id: nil, type: nil>>.
    is not true.

  7. 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:inrun’]:
    Should be valid.
    is not true.

  8. 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:inwith_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:inrun’]:
    is not true.

  9. 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:inwith_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:inrun’]:
    is not true.

  10. 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:inwith_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:inrun’]:
    is not true.

  11. 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:inwith_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:inrun’]:
    <“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?

Thanks a lot!!!