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 Email Updates:
Status: Verified Impact on me:
None 
Category:Connector / NET Severity:S3 (Non-critical)
Version:6.10.5.0, 8.0.16 OS:Windows
Assigned to: 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