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

              Assignee:
              stronk7 Eloy Lafuente (stronk7)
              Reporter:
              martinlanghoff Martín Langhoff
              Tester:
              Petr Skoda
              Participants:
              Component watchers:
              Andrew Nicols, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
              Votes:
              1 Vote for this issue
              Watchers:
              9 Start watching this issue

                Dates

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