Bug #101424 Insert/Update enum error "Value *column name* is not of the correct type".
Submitted: 2 Nov 2020 14:51 Modified: 10 Nov 2020 12:15
Reporter: Michael Buchok Email Updates:
Status: Duplicate Impact on me:
Category:Connector / NET Severity:S2 (Serious)
Version:8.0.22 OS:Any
Assigned to: CPU Architecture:Any
Tags: enums, type conversion

[2 Nov 2020 14:51] Michael Buchok
I have a C# .NET Core web app that is using MySQL.Data v8.0.21. All calls to every stored procedure work fine with this version and prior. After migrating to v8.0.22 all stored procedures that accept an enum parameter fail with the error "Value *column name* is not of the correct type". After reverting to v8.0.21 everything works properly again.

How to repeat:
Write a stored procedure that accepts an enum parameter. Make a call passing in an enum value.

Suggested fix:
Whatever was done in 8.0.22 related to enum value types should be reverted. Everything worked fine in previous versions.
[2 Nov 2020 16:34] MySQL Verification Team
Thank you for the bug report. Please provide (attach it with Files tab) a console C# test case which reproduce the behavior reported. Thanks in advance.
[2 Nov 2020 17:43] MySQL Verification Team
Thank you for the feedback. Please attach the text files *.cs, *.sql instead of pictures. Thanks.
[6 Nov 2020 19:46] Bradley Grainger
This sounds similar to the report I filed at Bug #101302.
[10 Nov 2020 12:15] MySQL Verification Team
Hello Michael Buchok,

Thank you for the details.
Discussed with Connector/NET developer(s) and we concluded that this is duplicate of Bug #101302 since both are related to DataTypes. please see Bug #101302.

Ashwini Patil