Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-29516 DB layer improvements 2.3 META
  3. MDL-31899

Rewrite mysql get_columns to use information_schema table

    XMLWordPrintable

    Details

    • Type: Sub-task
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.2
    • Fix Version/s: 2.3
    • Component/s: Database SQL/XMLDB
    • Labels:

      Description

      The current implementation of mysqli_native_moodle_database->get_columns gets its information by doing a SHOW_COLUMNS and parsing the output. There are some limitations with this approach, not the least of which is that it doesn't return the maximum length for text fields, which would help resolve MDL-15678. I've also noticed in my own testing that the values returned by the current function don't match what comes out of the information_schema table (which may be related to MDL-27634).

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                2 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  25/Jun/12