Bug #13632 the MySQLCommandBuilder.deriveparameters has not been updated for MySQL 5

• Submitted: 30 Sep 2005 5:01
• Modified: 20 Nov 2005 4:44
• Reporter: Michael Cashion
• Status: Closed
• Category: Connector / NET
• Severity: S3 (Non-critical)
• Version: 1.0.5
• OS: Windows (Windows - .NET)
• Assigned to: Reggie Burnett
• CPU Architecture: Any

[30 Sep 2005 5:01] Michael Cashion

Description:
The MySQLCommandBuilder.deriveparameters method returns an error that MySql does not support "stored procedures".  The help also states that this method is not implemented because MySql does not support stored procedures.

All other methods I used so far have supported MySql 5's stored procedures.

How to repeat:
N/A

[30 Sep 2005 7:00] Vasily Kishkin

Could you please provide any test case ?

[3 Oct 2005 11:39] Michael Cashion

A VB Test function that uses this method

    Private Shared Function DiscoverSpParameterSet(ByVal connection As MySqlConnection, _
                                                       ByVal spName As String, _
                                                       ByVal includeReturnValueParameter As Boolean, _
                                                       ByVal ParamArray parameterValues() As Object) As MySqlParameter()

        Dim cmd As New MySqlCommand(spName, connection)
        cmd.CommandType = CommandType.StoredProcedure
        Dim discoveredParameters() As MySqlParameter
        connection.Open()
        MySqlCommandBuilder.DeriveParameters(cmd)
        connection.Close()
        If Not includeReturnValueParameter Then
            cmd.Parameters.RemoveAt(0)
        End If

        discoveredParameters = New MySqlParameter(cmd.Parameters.Count - 1) {}
        cmd.Parameters.CopyTo(discoveredParameters, 0)

        ' Init the parameters with a DBNull value
        Dim discoveredParameter As MySqlParameter
        For Each discoveredParameter In discoveredParameters
            discoveredParameter.Value = DBNull.Value
        Next

        Return discoveredParameters

    End Function ' DiscoverSpParameterSet

At the SqlCommandBuilder.DeriveParameters(cmd) line, an error message is generated stating the MySQL does not support stored procedures.

[11 Oct 2005 9:18] Vasily Kishkin

I was able to reproduce the bug on 1.0.6. Test case is attached.

[11 Oct 2005 9:20] Vasily Kishkin

Test case

Attachment: 13632.zip (application/force-download, text), 5.65 KiB.

[13 Oct 2005 20:43] Reggie Burnett

Fixed in 1.0.7

[1 Nov 2005 20:39] Paul DuBois

Reggie, can you suggest a sentence for the changelog describing
what was done here? Thanks.

[2 Nov 2005 9:17] Wagner Traut

When will this update be available for downloading?

[20 Nov 2005 4:44] Paul DuBois

Note in 1.0.7 changelog.

[19 May 2006 8:54] Gianluca Calabretta

Method MySQLCommandBuilder.DeriveParameters(...) doesn't work fine in release 1.0.7. It doesn't support:
- stored procedures without parameters
- stored procedures with 'char' type parameters