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

XMLDB bigint check fails using postgres

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.3.2
    • Fix Version/s: 2.4
    • Component/s: Database SQL/XMLDB
    • Labels:
      None
    • Database:
      PostgreSQL
    • Testing Instructions:
      Hide

      1/ install MySQL
      2/ run integer test in XMLDB editor - no problems expected
      3/ modify some DB tables - change biging to int in some tables
      4/ run integer test in XMLDB editor - broken columns should be identified
      5/ execute the fix SQL queries
      6/ run integer test in XMLDB editor - all problems should be fixed

      7/ repeat for PostgreSQL

      Show
      1/ install MySQL 2/ run integer test in XMLDB editor - no problems expected 3/ modify some DB tables - change biging to int in some tables 4/ run integer test in XMLDB editor - broken columns should be identified 5/ execute the fix SQL queries 6/ run integer test in XMLDB editor - all problems should be fixed 7/ repeat for PostgreSQL
    • Affected Branches:
      MOODLE_23_STABLE
    • Fixed Branches:
      MOODLE_24_STABLE
    • Pull from Repository:
    • Pull Master Branch:
      w41_MDL-35691_m24_intsizes

      Description

      xmld bigint check always fails for postgresql.

      I install clean moodle 2.3 from tar.gz. Run bigints check 1367 errors.
      DB Postgres.

      Check is not valid, colums are either bigint or bigserial in database.

      Postgres version 8.4.13

        Attachments

          Activity

            People

            Assignee:
            skodak Petr Skoda
            Reporter:
            katcher Eric Katchan
            Integrator:
            Eloy Lafuente (stronk7)
            Tester:
            Frédéric Massart
            Participants:
            Component watchers:
            Andrew Nicols, 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/Dec/12