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

core_grouplib_testcase::test_groups_get_groups_members() fails in Oracle

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 3.3
    • Fix Version/s: 3.3
    • Component/s: Groups, Unit tests
    • Labels:
    • Testing Instructions:
      Hide
      1. Run the following unit test in Oracle:

        vendor/bin/phpunit core_grouplib_testcase lib/tests/grouplib_test.php
        

        • Confirm that you don't encounter any errors nor failures.

      Bonus: Test also on other DB (e.g. PostgreSQL, MySQL, MSSQL). Confirm that everything passes.

      Show
      Run the following unit test in Oracle: vendor/bin/phpunit core_grouplib_testcase lib/tests/grouplib_test.php Confirm that you don't encounter any errors nor failures. Bonus: Test also on other DB (e.g. PostgreSQL, MySQL, MSSQL). Confirm that everything passes.
    • Affected Branches:
      MOODLE_33_STABLE
    • Fixed Branches:
      MOODLE_33_STABLE
    • Pull Master Branch:
      MDL-58563-master

      Description

      1) core_grouplib_testcase::test_groups_get_groups_members
      dml_read_exception: Error reading from database (ORA-00918: column ambiguously defined
      SELECT u.*
      FROM g_user u, g_groups_members gm
      WHERE u.id = gm.userid AND gm.groupid = :o_param1
      ORDER BY id ASC
      [array (
      'o_param1' => '2',
      )])

      /var/www/html/moodle/lib/dml/moodle_database.php:486
      /var/www/html/moodle/lib/dml/oci_native_moodle_database.php:277
      /var/www/html/moodle/lib/dml/oci_native_moodle_database.php:1179
      /var/www/html/moodle/lib/grouplib.php:432
      /var/www/html/moodle/lib/tests/grouplib_test.php:1446
      /var/www/html/moodle/lib/phpunit/classes/advanced_testcase.php:80

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                jpataleta Jun Pataleta
                Reporter:
                jpataleta Jun Pataleta
                Peer reviewer:
                Andrew Nicols
                Integrator:
                Jake Dallimore
                Tester:
                Jake Dallimore
                Participants:
                Component watchers:
                Andrew Nicols, Mathew May, Michael Hawkins, Shamim Rezaie, Simey Lameze, Andrew Nicols, Mathew May, Michael Hawkins, Shamim Rezaie, Simey Lameze
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  15/May/17