Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-38753

Error in enrolment web service unit test with Oracle

    Details

      Description

      The following failure is reported when running unit tests with Oracle (only). I found this error in the current master and 2.4.3+. I assume it has not been introduced by recent changes.

      1) core_enrol_external_testcase::test_get_users_courses
      dml_read_exception: Error reading from database (ORA-00933: SQL command not prop
      erly ended
      SELECT COUNT(*) FROM (SELECT DISTINCT eu2_u.id
                    FROM p_user eu2_u
                  JOIN p_user_enrolments eu2_ue ON eu2_ue.userid = eu2_u.id
      JOIN p_enrol eu2_e ON (eu2_e.id = eu2_ue.enrolid AND eu2_e.courseid = :o_eu2_cou
      rseid)
                 WHERE eu2_u.deleted = 0 AND eu2_u.id <> :o_eu2_guestid) AS enrolledus
      erids
      [array (
        'o_eu2_courseid' => '3',
        'o_eu2_guestid' => '1',
      )])
       
      D:\xampp\htdocs\master_integration\lib\dml\moodle_database.php:426
      D:\xampp\htdocs\master_integration\lib\dml\oci_native_moodle_database.php:272
      D:\xampp\htdocs\master_integration\lib\dml\oci_native_moodle_database.php:1114
      D:\xampp\htdocs\master_integration\lib\dml\moodle_database.php:1401
      D:\xampp\htdocs\master_integration\lib\dml\oci_native_moodle_database.php:1048
      D:\xampp\htdocs\master_integration\lib\dml\moodle_database.php:1474
      D:\xampp\htdocs\master_integration\lib\dml\moodle_database.php:1645
      D:\xampp\htdocs\master_integration\enrol\externallib.php:320
      D:\xampp\htdocs\master_integration\enrol\tests\externallib_test.php:113
      D:\xampp\htdocs\master_integration\lib\phpunit\classes\advanced_testcase.php:76
       
      To re-run:
       \xampp\php\phpunit core_enrol_external_testcase enrol\tests\externallib_test.php
      

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Votes:
                  0 Vote for this issue
                  Watchers:
                  1 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:
                    Fix Release Date:
                    13/May/13