MySQL Bugs: #41451: CREATE A PROCEDURE WITH COMMUNITY SERVER 5.1.30

Bug #41451	CREATE A PROCEDURE WITH COMMUNITY SERVER 5.1.30
Submitted:	14 Dec 2008 4:11	Modified:	26 Dec 2008 23:51
Reporter:	Thierry VIEIL	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	5.1.30	OS:	Windows (WINDOWS 2000 PRO SP4)
Assigned to:		CPU Architecture:	Any
Tags:	CREATE A PROCEDURE

Description:
I use a Mysql server 5.0.67 on my computer
i develop with Connector .NET 5.2.3
and use GUI TOOLS  1.2 R12
in my soft i create procedures for new database
with success

How to repeat:

I have uninstalled server 5.0.67, connector 5.2.3 and GUI TOOLS 1.2 R12
I install server 5.1.30 connector 5.2.5
and GUI TOOLS 1.2 R15

Now when i create a new database with my model,
procedures can not be created.
Error 1307 "Failed to create PROCEDURE"

I send you an URL of a zip files which contain copy screen of my computer

http://www.vipac.fr/mrdu/logiciels/images.zip

Suggested fix:
Thanks to tell me if i have to come back in server 5.0.67

Thank you for a problem report. Please, send complete CREATE PROCEDURE statements that works for you in 5.0.67 and does NOT work in 5.1.30.

Here is one complete procedure that works on 5.0.67

cmd.CommandText = "CREATE PROCEDURE Ajouter_un_Constructeur(ParamIDConstructeur INTEGER,ParamNOM TEXT," & _
"ParamSITE_CONSTRUCTEUR TEXT,ParamCHEMIN_LOGOS TEXT," & _
"ParamNOM_FICHIER_IMAGE_LOGOS TEXT,ParamLARGEUR_IMAGE_LOGOS TEXT," & _
"ParamHAUTEUR_IMAGE_LOGOS TEXT,ParamINFORMATIONS_francais TEXT," & _
"ParamINFORMATIONS_anglais TEXT,ParamINFORMATIONS_allemand TEXT," & _
"ParamINFORMATIONS_espagnole TEXT,ParamINFORMATIONS_italien TEXT) " & _
"INSERT INTO CONSTRUCTEURS(IDConstructeur, NOM, SITE_CONSTRUCTEUR, " & _
"CHEMIN_LOGOS, NOM_FICHIER_IMAGE_LOGOS, LARGEUR_IMAGE_LOGOS, HAUTEUR_IMAGE_LOGOS," & _
"INFORMATIONS_francais, INFORMATIONS_anglais, INFORMATIONS_allemand, INFORMATIONS_espagnole," & _
"INFORMATIONS_italien) VALUES " & _
"(ParamIDConstructeur, ParamNOM, ParamSITE_CONSTRUCTEUR, ParamCHEMIN_LOGOS," & _
"ParamNOM_FICHIER_IMAGE_LOGOS, ParamLARGEUR_IMAGE_LOGOS, ParamHAUTEUR_IMAGE_LOGOS," & _
"ParamINFORMATIONS_francais, ParamINFORMATIONS_anglais, ParamINFORMATIONS_allemand," & _
"ParamINFORMATIONS_espagnole, ParamINFORMATIONS_italien)"

Screen shot on my computer

Attachment: images.zip (application/x-zip-compressed, text), 485.56 KiB.

I use Another server MySql essential 5.0.67 on a Windows 2000 PRO SP4
on my network

with my software which use connector 5.2.5 In VB NET on my windows XP PRO SP3
i create a new database on this server 5.0.67

It works properly, procedures are created.
Here is one of procedures which was created on this server

DELIMITER $$

DROP PROCEDURE IF EXISTS `test_15_12_2008`.`Ajouter_un_Constructeur` $$
CREATE DEFINER=`root`@`%` PROCEDURE `Ajouter_un_Constructeur`(ParamIDConstructeur INTEGER,ParamNOM TEXT,ParamSITE_CONSTRUCTEUR TEXT,ParamCHEMIN_LOGOS TEXT,ParamNOM_FICHIER_IMAGE_LOGOS TEXT,ParamLARGEUR_IMAGE_LOGOS TEXT,ParamHAUTEUR_IMAGE_LOGOS TEXT,ParamINFORMATIONS_francais TEXT,ParamINFORMATIONS_anglais TEXT,ParamINFORMATIONS_allemand TEXT,ParamINFORMATIONS_espagnole TEXT,ParamINFORMATIONS_italien TEXT)
INSERT INTO CONSTRUCTEURS(IDConstructeur, NOM, SITE_CONSTRUCTEUR, CHEMIN_LOGOS, NOM_FICHIER_IMAGE_LOGOS, LARGEUR_IMAGE_LOGOS, HAUTEUR_IMAGE_LOGOS,INFORMATIONS_francais, INFORMATIONS_anglais, INFORMATIONS_allemand, INFORMATIONS_espagnole,INFORMATIONS_italien) VALUES (ParamIDConstructeur, ParamNOM, ParamSITE_CONSTRUCTEUR, ParamCHEMIN_LOGOS,ParamNOM_FICHIER_IMAGE_LOGOS, ParamLARGEUR_IMAGE_LOGOS, ParamHAUTEUR_IMAGE_LOGOS,ParamINFORMATIONS_francais, ParamINFORMATIONS_anglais, ParamINFORMATIONS_allemand,ParamINFORMATIONS_espagnole, ParamINFORMATIONS_italien) $$

DELIMITER ;

Please, send the results of:

show create table CONSTRUCTEURS\G

>[16 Dec 5:58] Valeriy Kravchuk
>
>Please, send the results of:
>
>show create table CONSTRUCTEURS\G

mysql> use test_15_12_2008
Database changed
mysql> show create table CONSTRUCTEURS\G
*************************** 1. row ***************************
       Table: CONSTRUCTEURS
Create Table: CREATE TABLE `constructeurs` (
  `IDConstructeur` int(10) unsigned NOT NULL auto_increment COMMENT 'IDentificat
ion du constructeur',
  `NOM` text NOT NULL COMMENT 'Nom du constructeur',
  `SITE_CONSTRUCTEUR` text COMMENT 'URL site Internet',
  `CHEMIN_LOGOS` text COMMENT 'chemin image logos',
  `NOM_FICHIER_IMAGE_LOGOS` text COMMENT 'Nom du fichier image logos',
  `LARGEUR_IMAGE_LOGOS` text COMMENT 'Largeur image logos',
  `HAUTEUR_IMAGE_LOGOS` text COMMENT 'Hauteur image logos',
  `INFORMATIONS_francais` text COMMENT 'description de la société en français',
  `INFORMATIONS_anglais` text COMMENT 'description de la société en anglais',
  `INFORMATIONS_allemand` text COMMENT 'description de la société en allemand',
  `INFORMATIONS_espagnole` text COMMENT 'description de la société en espagnole'
,
  `INFORMATIONS_italien` text COMMENT 'description de la société en italien',
  PRIMARY KEY  (`IDConstructeur`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1
1 row in set (0.03 sec)

mysql>

I saw that i have restored a backup of mysql database which come from
a 5.0.26, on my 5.1.30. Error is viewed by GUI TOOLS during start of service
mysql "missing 'Event_priv' column in user table"

i reinstalled MySql without any old data and that's ok procedures are created
without problem.