MySQL Bugs: #40382: Connector wants to read from not existing information

Bug #40382	Connector wants to read from not existing information_schema.parameters table
Submitted:	28 Oct 2008 22:51	Modified:	10 Nov 2008 14:27
Reporter:	Pavel Bazanov
Status:	Closed
Category:	Connector/Net	Severity:	S2 (Serious)
Version:	5.2.3	OS:	Microsoft Windows
Assigned to:		Target Version:
Tags:	stored procedure, GetParametersFromIS, Parameters, information_schema, 5.2.3, .net, connector
Triage:	Needs Triage: D2 (Serious)

Description:
Hello, 
I have upgraded to Connector v5.2.3 (previously I had 5.1.5) and now I get exception when
I try to work with stored procedures. Here is the sample code: 

MySqlConnection conn = new
MySqlConnection("Server=localhost;Database=mydb;Uid=root;Pwd=mypass;charset=cp1251;"); 
conn.Open(); 
MySqlCommand command = new MySqlCommand("GetCustomersList", conn); 
command.CommandType = CommandType.StoredProcedure; 
command.ExecuteReader(); 

On ExecuteReader() (it can be ExecuteNonQuery(), no matter) I get an exception: 

"Unknown table 'parameters' in information_schema" 

I don't have table parameters in information_schema database. I checked another server
with MySQL 6.0.2 installed and there is also no parameters table in information_schema.

Actually, the ISSchemaProvider.GetParametersFromIS() method wants to read
information_schema.parameters table. This method did not exist in 5.1.5 (and also in
5.1.7). So maybe this information helps you somehow.

Thank you in advance.

How to repeat:
MySqlConnection conn = new
MySqlConnection("Server=localhost;Database=mydb;Uid=root;Pwd=mypass;charset=cp1251;"); 
conn.Open(); 
MySqlCommand command = new MySqlCommand("GetCustomersList", conn); 
command.CommandType = CommandType.StoredProcedure; 
command.ExecuteReader(); // <----- exception here ("Unknown table 'parameters' in
information_schema")

Thank you for a problem report. 

According to the manual, http://dev.mysql.com/doc/refman/6.0/en/parameters-table.html,
that table was added in 6.0.6. So when working with older version of 6.x connector should
NOT use this table.

So, it will be fixed in the next version of Connector/Net ?

Actually, according to the manual, that table was added in 5.2.6:

http://dev.mysql.com/doc/refman/6.0/en/parameters-table.html

"The PARAMETERS table was added in MySQL 5.2.6."

I have been having this issue since I started developing against MySQL.
Looking at the forums, a number of people are getting the same issue.
I our case the effect is that we can not see details of fields with Visual Studio and do
not get values returned from the stored procedures into VB2008.
If it is not fixed soon we may need to stop the migration to MySQL and use SQL Server.

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/58113

fixed in 5.2.4+

Added entry to the 5.2.4 changelog:

When working with stored procedures Connector/NET generated an exception Unknown "table
parameters" in information_schema.