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

Moodle Features Demo course does not restore cleanly to Oracle

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.9
    • Fix Version/s: 1.9.5
    • Component/s: Database SQL/XMLDB
    • Labels:
      None
    • Database:
      Oracle
    • Affected Branches:
      MOODLE_19_STABLE
    • Fixed Branches:
      MOODLE_19_STABLE

      Description

      The Moodle features demo course does not restore cleanly to Oracle.

      The main problem has to do with explicit comparisons between CLOBs and text that are performed to avoid duplicate records. Oracle does not support something as simple as

      SELECT id FROM table WHERE clobcolumn = 'sometext';

      Upon this, it barfs with "ORA-00932: inconsistent datatypes: expected - got CLOB"

      Instead, we have to do

      SELECT id FROM table WHERE clobcolumn LIKE 'sometext';

      with the added inconsistency that under MySQL LIKE is case-insensitive. It is case-sensitive everywhere else.

      There are additional problems with hotpot and quoting.

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                1 Vote for this issue
                Watchers:
                9 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  13/May/09