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, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze, Andrew Nicols, Jun Pataleta, 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