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

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

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 2.7
    • 2.7.1, 2.8
    • Quiz

    Description

      Found by 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

              timhunt Tim Hunt
              timhunt Tim Hunt
              Juan Leyva Juan Leyva
              Damyon Wiese Damyon Wiese
              Frédéric Massart Frédéric Massart
              Tim Hunt, Andrew Lyons, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                14/Jul/14