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

Create one XMLDB option to analyse all the INTs within a DB

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.7.3, 1.8.3, 1.9
    • Fix Version/s: 1.9
    • Component/s: Database SQL/XMLDB
    • Labels:
      None
    • Environment:
      Any MySQL & PostgreSQL server
    • Database:
      MySQL, PostgreSQL
    • Affected Branches:
      MOODLE_17_STABLE, MOODLE_18_STABLE, MOODLE_19_STABLE
    • Fixed Branches:
      MOODLE_19_STABLE

      Description

      changing them to BIGINTs as necessary (when possible).

      From Moodle 1.7 all int(10) were changed to bigint(10) for new columns. These leave old sites with a mix of INTs and BIGINTs that should be normalized, to avoid losing any DB thought put performing unnecessary CASTS or SORT merges.

      Implement one utility within the XMLDB editor, able to iterate over all the int(10) columns, looking if they are correct BIGINTs or no.

      The utility won't perform any action against the DB but provide one SQL script to be executed by hand.

      Ciao

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              stronk7 Eloy Lafuente (stronk7)
              Reporter:
              stronk7 Eloy Lafuente (stronk7)
              Tester:
              Tim Hunt
              Participants:
              Component watchers:
              Andrew Nicols, Dongsheng Cai, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Fix Release Date:
                3/Mar/08