Hello,
I would like to know the purpose of the functional running tests for the database.
I am using MySQL 5.5.13 in Windows 2008/IIS7 and I got the following exceptions when I run the test:
Fail: lib/dml/simpletest/testdml.php / ► dml_test / ► test_unique_index_collation_trouble
Unique index is accent insensitive, this may cause problems for non-ascii languages. This is usually caused by accent insensitive default collation. at [E:\moodle_test\lib\dml\simpletest\testdml.php line 3361]
Unique index is accent insensitive, this may cause problems for non-ascii languages. This is usually caused by accent insensitive default collation. at [E:\moodle_test\lib\dml\simpletest\testdml.php line 3361]
- line ... of ...
- line 3361 of \lib\dml\simpletest\testdml.php: call to SimpleTestCase->fail()
- line ... of ...
- line 53 of \admin\tool\unittest\ex_simple_test.php: call to TestSuite->run()
- line ... of ...
- line 113 of \admin\tool\unittest\dbtest.php: call to autogroup_test_coverage->run_with_external_coverage()
Exception: lib/dml/simpletest/testdml.php / ► dml_test / ► test_unique_index_collation_trouble
Unexpected exception of type [dml_write_exception] with message [Error writing to database] in [E:\moodle_test\lib\dml\moodle_database.php line 397]
Unexpected exception of type [dml_write_exception] with message [Error writing to database] in [E:\moodle_test\lib\dml\moodle_database.php line 397]
Debug info:
Duplicate entry 'aäa' for key 'mdl_unittabl_nam_uix' INSERT INTO mdl_unit_table (name) VALUES(?) [array ( 0 => 'aäa', )]
- line 973 of \lib\dml\mysqli_native_moodle_database.php: call to moodle_database->query_end()
- line 1015 of \lib\dml\mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->insert_record_raw()
- line 3355 of \lib\dml\simpletest\testdml.php: call to mysqli_native_moodle_database->insert_record()
- line ... of ...
- line 53 of \admin\tool\unittest\ex_simple_test.php: call to TestSuite->run()
- line ... of ...
- line 113 of \admin\tool\unittest\dbtest.php: call to autogroup_test_coverage->run_with_external_coverage()
Fail: lib/dml/simpletest/testdml.php / ► dml_test / ► test_sql_binary_equal
SQL operator "=" is expected to be accent sensitive at [E:\moodle_test\lib\dml\simpletest\testdml.php line 3389]
SQL operator "=" is expected to be accent sensitive at [E:\moodle_test\lib\dml\simpletest\testdml.php line 3389]
- line ... of ...
- line 3389 of \lib\dml\simpletest\testdml.php: call to UnitTestCase->assertEqual()
- line ... of ...
- line 53 of \admin\tool\unittest\ex_simple_test.php: call to TestSuite->run()
- line ... of ...
- line 113 of \admin\tool\unittest\dbtest.php: call to autogroup_test_coverage->run_with_external_coverage()
Fail: lib/dml/simpletest/testdml.php / ► dml_test / ► test_sql_binary_equal
SQL operator "=" is expected to be case sensitive at [E:\moodle_test\lib\dml\simpletest\testdml.php line 3392]
SQL operator "=" is expected to be case sensitive at [E:\moodle_test\lib\dml\simpletest\testdml.php line 3392]
- line ... of ...
- line 3392 of \lib\dml\simpletest\testdml.php: call to UnitTestCase->assertEqual()
- line ... of ...
- line 53 of \admin\tool\unittest\ex_simple_test.php: call to TestSuite->run()
- line ... of ...
- line 113 of \admin\tool\unittest\dbtest.php: call to autogroup_test_coverage->run_with_external_coverage()
2/2 test cases complete: 1181 passes, 3 fails and 1 exceptions.
Run at Friday, 11 January 2013, 12:30 PM. Time taken: 32 secs. Using SimpleTest version 1.0.1.
____________________________________________________________________
Is it something I should be worried about ?
Can you please advise ?