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: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'