MySQL Bugs: #44600: vs2008 crash when try to create a stored procedure

Bug #44600	vs2008 crash when try to create a stored procedure
Submitted:	1 May 2009 11:41	Modified:	7 May 2009 19:53
Reporter:	rabosa Cando	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	Connector / NET	Severity:	S2 (Serious)
Version:	5.2.6, 6.0.3	OS:	Windows (XP SP3)
Assigned to:	Assigned Account	CPU Architecture:	Any

Description:
vs2008 crash when try to create a stored procedure with output variable

How to repeat:
I created the procedure:
create procedure IniciarSessio(in _idUsuari int(4), out iIdSessio int(6))
begin
insert into log_dtl (idUsuari,hora_inici,data_inici) values (_idUsuari, now(),now());
select Last_Insert_ID() into iIdSessio ;
end

now i try to insert into the dataset with the wizard and crash visual studio 2008 C#

Hi Rabosa. Verified as described:
  o Picking *any* SP when using c/NET 6.0.3 closes the wizard without notice
  o Picking SP with OUT param when using c/NET 5.2.6 closes the wizard without notice

How to repeat:
create table bug44600 (Id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, SomeText VARCHAR(25) DEFAULT "default");
create procedure spBug44600(in inint int, out outid int)
begin
  insert into bug44600 (SomeText) values (CONCAT(inint, " def"));
  select Last_Insert_ID() into outid;
end;
mysql> set @x = 0;
Query OK, 0 rows affected (0.00 sec)
mysql> call spBug44600(1,@x);
Query OK, 0 rows affected (0.00 sec)
mysql> select @x;
+------+
| @x   |
+------+
|    1 |
+------+

Open new C# project, add references... Right-click DataSet designer, choose Add/Query, From SP, pick above SP from drop-down list.

Just occurred to me, "User variables" were allowed. Don't know if that's relevant though.

I think this is a dupe of #44460 which is fixed for 6.0.4.  I was unable to reproduce with 5.2.6 and 5.2.7

I think this is a dupe of #44460 which is fixed for 6.0.4.  I was unable to reproduce with 5.2.6 and 5.2.7