Bug #89335 Connector MySqlCommandBuilder.DeriveParamaters cant't handle JSON value type.

• Submitted: 20 Jan 2018 12:29
• Modified: 23 Jan 2018 6:24
• Reporter: Andreas Baier
• Status: Verified
• Category: Connector / NET
• Severity: S3 (Non-critical)
• Version: 6.10.5.0, 8.0.16
• OS: Microsoft Windows
• CPU Architecture: Any
• Tags: json

[20 Jan 2018 12:29] Andreas Baier

Description:
Trying to use MySqlCommandBuilder.DeriveParameters methode on an procedure with JSON paramaters throws an MySql.Data.MySqlClient.MySqlException
  HResult=0x80004005
  Nachricht = Unhandled type encountered
  Quelle = MySql.Data
  Stapelüberwachung:
   at MySql.Data.Types.MetaData.NameToType(String typeName, Boolean unsigned, Boolean realAsFloat, MySqlConnection connection)
   at MySql.Data.MySqlClient.MySqlCommandBuilder.DeriveParameters(MySqlCommand command)
   at MySqlJsonTest.Program.Main(String[] args)

How to repeat:
Insert a procedure like:
CREATE DEFINER=`root`@`%` PROCEDURE `SetJson`(vJson JSON)
BEGIN
	SELECT vJson;
END

Create a c# console application:

using MySql.Data.MySqlClient;
using System;

namespace MySqlJsonTest
{
    class Program
    {
        static void Main(string[] args)
        {
            //var _conn = new MySqlConnection("server=192.168.1.44;database=test;user id=jsonuser;password=json");
            _conn.Open();
            var _cmd = new MySqlCommand("test.SetJson", _conn);
            _cmd.CommandType = System.Data.CommandType.StoredProcedure;
            MySqlCommandBuilder.DeriveParameters(_cmd);  //MySqlException here!
            Console.ReadKey();
        }
    }
}

[21 Jan 2018 5:51] Bradley Grainger

@Andreas Baier, MySqlConnector now implements MySqlCommandBuilder.DeriveParameters (and it supports JSON parameters): https://github.com/mysql-net/MySqlConnector/issues/419

[23 Jan 2018 6:24] Chiranjeevi Battula

Hello Andreas Baier,

Thank you for the bug report.
Verified this behavior on Visual Studio 2017 (C#.Net) and Connector/NET 6.10.5 version.

Thanks,
Chiranjeevi.

[23 Jan 2018 6:25] Chiranjeevi Battula

Screenshot

Attachment: Bug_89335.PNG (image/png, text), 88.22 KiB.

[12 Jun 2019 9:51] MySQL Verification Team

Bug #95748 marked as duplicate of this one