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

Error sorting assignment submissions by comment (in Oracle)

    XMLWordPrintable

    Details

    • Database:
      Oracle
    • Testing Instructions:
      Hide

      Sorting assignment submissions by comment shouldn't give any error

      Show
      Sorting assignment submissions by comment shouldn't give any error
    • Workaround:
      Hide

      As far as clob datatype isn't allowed in an order by sentence, I suppose that those datatype columns should be casted in allowed datatypes somehow.

      Show
      As far as clob datatype isn't allowed in an order by sentence, I suppose that those datatype columns should be casted in allowed datatypes somehow.
    • Affected Branches:
      MOODLE_21_STABLE

      Description

      When sorting the assignment submissions by comment it crashes with ORA-00932 inconsistent datatypes: expected - got clob

      * line 394 of \lib\dml\moodle_database.php: dml_read_exception thrown
      * line 268 of \lib\dml\oci_native_moodle_database.php: call to moodle_database->query_end()
      * line 1093 of \lib\dml\oci_native_moodle_database.php: call to oci_native_moodle_database->query_end()
      * line 1325 of \mod\assignment\lib.php: call to oci_native_moodle_database->get_records_sql()
      * line 649 of \mod\assignment\lib.php: call to assignment_base->display_submissions()
      * line 369 of \mod\assignment\type\upload\assignment.class.php: call to assignment_base->submissions()
      * line 57 of \mod\assignment\submissions.php: call to assignment_upload->submissions()

      This is because the comment column (mdl_assignment_submissions.submissioncomment) datatype is CLOB, and that's because (at least in Oracle) that kind of columns aren't allowed in the order by sentence

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              moodle.com moodle.com
              Reporter:
              izendegi Iñigo Zendegi
              Participants:
              Component watchers:
              Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias, Sujith Haridasan, Andrew Lyons, Dongsheng Cai, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: