Bug #15077 Error MySqlCommandBuilder.DeriveParameters for sp without parameters.

Description:
My application crashes whe use MySqlCommandBuilder.DeriveParameters for stored procedures without parameters.
No problem when the sp has parameters.

How to repeat:
I use C# Express and MySqlClient for Net 2.0
The null exception (object no set an instance of object) occurs in StoredProcedure class at DiscoverParameters(MySqlCommand cmd, string procType) method.

Sorry...I was not able to reproduce the bug. Could you please create and attach your test case ?

Ok, I make a little proyect to test and work fine.
The problem occurs in my real project that work with reomoting and so on.
I wil test  more to know whiy crashes there.
Thank You

I set status "Not a Bug". If you will be able to reproduce the bug on simple test case - please re-open this bug.

Hi, I upload a test project to see this problem.
Than you!
Winxp
C# Express 2005
MySql 5.0

C# express 2005 project

Attachment: TestProject.zip (application/x-zip-compressed, text), 36.93 KiB.

Thanks for test case. I'm sorry I missed that you work with .NET 2.0.
I was able to reproduce the bug.

I am experiencing this problem on .NET framework 1.1.

I have a stored procedure that will get all the values from a table and it takes 0 parameters. When I call DeriveParameters() an exception is thrown "object not set to instance". 

I'll create a test application for you to test with. Here's the sample of code that appears to be going wrong though.

public static MySqlParameter[] DiscoverSpParameterSet(MySqlConnection connection, string spName)
{
using (MySqlCommand cmd = new MySqlCommand(spName,connection))
{
cmd.CommandType = CommandType.StoredProcedure;
try
{
	MySqlCommandBuilder.DeriveParameters(cmd);
}
catch (Exception e)
{
	throw e;
}
			
MySqlParameter[] discoveredParameters = new MySqlParameter[cmd.Parameters.Count];
cmd.Parameters.CopyTo(discoveredParameters, 0);
return discoveredParameters;
}
}

I have a sample project that shows the problem on .NET framework 1.1.

If you would like the project, I can email it to you but I can't upload it to this bug report.

Do you know of a workaround for this problem that will allow us to continue with our respect projects?

regards,

Emma

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/6633

pushed to 1.0.8

A note has been added to the 1.0.8 changelog.