MySQL Bugs: #81417: Excel Addin - Cannot pass NULL parameter to Stored Proc to Import Data

Bug #81417	Excel Addin - Cannot pass NULL parameter to Stored Proc to Import Data
Submitted:	13 May 2016 8:44	Modified:	2 May 2017 18:33
Reporter:	Stephen Maddock	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL for Windows: MySQL for Excel	Severity:	S1 (Critical)
Version:	1.3.6	OS:	Windows
Assigned to:		CPU Architecture:	Any

Description:
I am using MySql Addin for Excel 1.3.6 

I select the stored procedure, click on 'Import MySQL Data' which brings up a dialog form showing all parameters. 

When I attempt to clear a parameter value (to represent a NULL value), for an integer parameter as an example, I get the following error msg: 
Property value is not valid. 
is not a valid value for UInt32. 

NULL string doesn't work either.

How to repeat:
Select a stored procedure with at least one numeric parameter and click on 'Import MySQL Data' which brings up a dialog form showing all parameters. 

Attempt to clear the initial parameter value.

Hello  Stephen Maddock,

Thank you for your feedback.
Verified this behavior on MS Excel 2013 with MySQL for Excel 1.3.6.

Thanks,
Chiranjeevi

Screenshot.

Attachment: 81417.JPG (image/jpeg, text), 204.75 KiB.

Posted by developer:
 
Enhanced the way parameter values are handled in the Import Procedure Data dialog, so that numeric values can be blanked out and treated as null values.

Posted by developer:
 
Fixed on 1.3.7 build 2

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

Clearing numeric parameter values within an stored procedure, or setting
any of the initial values to NULL, during an Import MySQL Data operation
emitted an error.

Thank you for the bug report.