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

Remove SQL "id,id" which causes errors on Oracle

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 1.8.3, 1.9, 2.0
    • 1.8.4, 1.9, 2.0
    • Assignment (2.2), Blocks
    • None
    • Oracle
    • MOODLE_18_STABLE, MOODLE_19_STABLE, MOODLE_20_STABLE
    • MOODLE_18_STABLE, MOODLE_19_STABLE, MOODLE_20_STABLE

    Description

      We have instances of SELECT id,id... in blocks/onlineusers and mod/assignment. Oracle complains about this because the column names collide.

      Credit for the reported – and initial patch – to Dennis Rochford <Dennis.Rochford@usq.edu.au> the USQ identifier for the bug is MOOD-559 .

      Attachments

        Activity

          People

            martinlanghoff Martín Langhoff
            martinlanghoff Martín Langhoff
            Nobody Nobody
            Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias, Sujith Haridasan, Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias, Sujith Haridasan
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:
              11/Jan/08