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:Microsoft Windows
Assigned to: CPU Architecture:Any

[13 May 2016 8:44] Stephen Maddock
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.
[13 May 2016 9:25] Chiranjeevi Battula
Hello  Stephen Maddock,

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

Thanks,
Chiranjeevi
[13 May 2016 9:25] Chiranjeevi Battula
Screenshot.

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

[17 Nov 2016 0:33] Javier TreviƱo
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.
[2 May 2017 16:42] Rafael Antonio Bedoy Torres
Posted by developer:
 
Fixed on 1.3.7 build 2
[2 May 2017 18:33] Christine Cole
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.