Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Not a Bug
    • Affects Version/s: 10.3.9
    • Fix Version/s: N/A
    • Component/s: Prepared Statements
    • Labels:
      None
    • Environment:
      windows 10

      Description

      DELIMITER $$
       DROP PROCEDURE IF EXISTS epic_from_exch_epic$$
       CREATE PROCEDURE epic_from_exch_epic()
       BEGIN
       DECLARE x  INT;
       DECLARE y  INT;
       DECLARE str  VARCHAR(255);
       
        SET x = 1;
        SET y = 20000000;
       
       WHILE x  <= y DO
       SET  str = CONCAT(str,x,',');
       
       
       SET @idlow = 26423400;
      SET @idhi = @idlow + 2000000;
       
      UPDATE sharescope_ex_ep 
      SET epic = substring_index(exch_epic, ':' , -1)
      WHERE 
      epic = ''
      AND id_sharescope_data between @idlow and @idhi;
       
       SET  x = x + 1; 
       
       END WHILE;
       
       select * from sharescope_ex_ep 
      WHERE id_sharescope_data > (y - 10)
      order by id_sharescope_data
      limit 100;
       
      select * from sharescope_ex_ep order by id_sharescope_data DESC limit 10;
       
       
       END$$
      DELIMITER ;
      

      RESULT is following error:

      SQL Error (1558)
      Column count of mysql.proc is wrong. Expected 21, found 20.
      Unable to resolve by running mysql_upgrade.exe

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              both_66516 Michael Both
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: