Bug #86096 Error opening a schema in a MySQL Server 8.0

• Submitted: 26 Apr 2017 20:49
• Modified: 5 May 2017 20:37
• Reporter: Javier Treviño
• Status: Closed
• Category: MySQL for Windows: MySQL for Excel
• Severity: S2 (Serious)
• Version: 1.3.6
• OS: Any
• CPU Architecture: Any

[26 Apr 2017 20:49] Javier Treviño

Description:
When opening a Schema for a MySQL Server 8.0 connection, an error like the following is always shown to users:

Table 'mysql.proc' doesn't exist
(6:22:25 PM) javier.trevino: Stack trace:
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader()
   at MySql.Data.MySqlClient.SchemaProvider.GetProcedures(String[] restrictions)
   at MySql.Data.MySqlClient.ISSchemaProvider.GetProcedures(String[] restrictions)
   at MySql.Data.MySqlClient.ISSchemaProvider.GetSchemaInternal(String collection, String[] restrictions)
   at MySql.Data.MySqlClient.SchemaProvider.GetSchema(String collection, String[] restrictions)
   at MySql.Data.MySqlClient.MySqlConnection.GetSchema(String collectionName, String[] restrictionValues)

This bug is actually present in Connetor/NET, and there is already a bug created for this very problem.

How to repeat:
1. Open MySQL for Excel.
2. Open a connection to a MySQL Server 8.0.0 or 8.0.1.
3. Open any schema (that presumably has stored procedures)
4. An error is shown, and stored procedures are not loaded

Suggested fix:
Implement a direct way (bypassing MySqlConnection.GetSchema) to query stored procedures from the information_schema table to avoid waiting until this is fixed in Connector/NET

[26 Apr 2017 20:51] Javier Treviño

Posted by developer:
 
Added code to the Utilities that queries stored procedures from the information_schema directly without using Connector/NET's MySqlConnection.GetSchema.
This code may be removed later on when that Connector/NET's method is fixed to work with 8.0 Servers.

[5 May 2017 19:51] Rafael Antonio Bedoy Torres

Posted by developer:
 
Fixed on 1.3.7 build 2

[5 May 2017 20:37] Christine Cole

Fixed as of the upcoming MySQL for Excel 1.3.7 release, and here's the changelog entry:

Selecting a schema containing at least one stored procedure for a MySQL
8.0 or 8.1 connection emitted an error.

Thank you for the bug report.