Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-6737

Stored routines do now work with swe7: "The table mysql.proc is missing, corrupt, or contains bad data"

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 5.5.39, 10.0.13
    • 10.0.14
    • None
    • None

    Description

      This script:

      SET NAMES swe7;
      		 
      DROP FUNCTION IF EXISTS f1;
      		 
      CREATE FUNCTION f1() RETURNS INT RETURN 1;
      		 
      SELECT f1();

      produces this error:

      ERROR 1457 (HY000): Failed to load routine test.f1. The table mysql.proc is missing, corrupt, or contains bad data (internal code -6)

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          bar Alexander Barkov created issue -
          bar Alexander Barkov made changes -
          Field Original Value New Value
          Description This script:
          {code}
          SET NAMES swe7;
          DROP FUNCTION IF EXISTS f1;
          CREATE FUNCTION f1() RETURNS INT RETURN 1;
          SELECT f1();
          {code}

          produces and error:
          {noformat}
          ERROR 1457 (HY000): Failed to load routine test.f1. The table mysql.proc is missing, corrupt, or contains bad data (internal code -6)
          {noformat}

          		 This script:
          {code}
          SET NAMES swe7;
          DROP FUNCTION IF EXISTS f1;
          CREATE FUNCTION f1() RETURNS INT RETURN 1;
          SELECT f1();
          {code}

          produces this error:

          {noformat}
          ERROR 1457 (HY000): Failed to load routine test.f1. The table mysql.proc is missing, corrupt, or contains bad data (internal code -6)
          {noformat}
          bar Alexander Barkov made changes -
          Fix Version/s 10.0.14 [ 17101 ]
          Resolution Fixed [ 1 ]
          Status Open [ 1 ] Closed [ 6 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Workflow MariaDB v2 [ 53834 ] MariaDB v3 [ 61678 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 61678 ] MariaDB v4 [ 148220 ]

          People

            bar Alexander Barkov
            bar Alexander Barkov
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.