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

Quiz unit test fails on Oracle (AS in table alias)

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.7
    • Fix Version/s: 2.7.1, 2.8
    • Component/s: Quiz

      Description

      Found by Dan Poltawski in MDL-35453.

      vendor/bin/phpunit mod_quiz_editlib_testcase mod/quiz/tests/editlib_test.php
      Moodle 2.8dev (Build: 20140619), oci, 2ce9a94d962405a1fb2f3f375068d3ad031d966e
      PHPUnit 3.7.37 by Sebastian Bergmann.
       
      Configuration read from /Users/danp/moodles/pm/moodle/phpunit.xml
       
      .E
       
      Time: 7.52 seconds, Memory: 78.25Mb
       
      There was 1 error:
       
      1) mod_quiz_editlib_testcase::test_quiz_remove_slot
      dml_read_exception: Error reading from database (ORA-00933: SQL command not properly ended
      SELECT qs.*, q.qtype AS qtype
                             FROM t_quiz_slots AS qs
                             JOIN t_question AS q ON qs.questionid = q.id
                            WHERE qs.quizid = :o_param1
                         ORDER BY qs.slot
      [array (
        'o_param1' => '1',
      )])
       
      /Users/danp/moodles/pm/moodle/lib/dml/moodle_database.php:443
      /Users/danp/moodles/pm/moodle/lib/dml/oci_native_moodle_database.php:271
      /Users/danp/moodles/pm/moodle/lib/dml/oci_native_moodle_database.php:1127
      /Users/danp/moodles/pm/moodle/mod/quiz/tests/editlib_test.php:79
      /Users/danp/moodles/pm/moodle/lib/phpunit/classes/advanced_testcase.php:80
       
      To re-run:
       vendor/bin/phpunit mod_quiz_editlib_testcase mod/quiz/tests/editlib_test.php
      

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  14/Jul/14