Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-21432 META: Backup & restore 2.0
  3. MDL-21834

pre: Some fixes to DB generators and temp tables support

    XMLWordPrintable

Details

    • Sub-task
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 2.0
    • 2.0
    • Backup, Database SQL/XMLDB
    • None
    • MOODLE_20_STABLE
    • MOODLE_20_STABLE
    • Difficult

    Description

      While using temp tables in backup stuff, I've found some annoyances:

      • concurrent (different connection) temp tables is not working ok in PostgreSQL, MSSQL and Oracle.
      • sql generators have one PHP static cache that make things behave strange if 2 connections are used in the same request.

      TODO:

      • Add ddl tests about concurrent temp tables behavior.
      • Fix concurrent temp tables behavior in PG, MSSQL and Oracle.
      • Kill the static cache in generators. It really doesn't save too much (was useful before 1.9, when we were using it to guess object names, but now we are going against he dictionary).

      Ciao

      Attachments

        Activity

          People

            stronk7 Eloy Lafuente (stronk7)
            stronk7 Eloy Lafuente (stronk7)
            Adrian Greeve, David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo, David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:
              24/Nov/10