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

Moodle Features Demo course does not restore cleanly to Oracle

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.9
    • 1.9.5
    • Database SQL/XMLDB
    • None
    • Oracle
    • MOODLE_19_STABLE
    • 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

              stronk7 Eloy Lafuente (stronk7)
              martinlanghoff Martín Langhoff
              Petr Skoda Petr Skoda
              David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo
              Votes:
              1 Vote for this issue
              Watchers:
              9 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                13/May/09