MySQL Bugs: #101424: Insert/Update enum error "Value *column name* is not of the correct type".

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:	None
Category:	Connector / NET	Severity:	S2 (Serious)
Version:	8.0.22	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	enums, type conversion

Description:
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.

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.

Thank you for the feedback. Please attach the text files *.cs, *.sql instead of pictures. Thanks.

This sounds similar to the report I filed at Bug #101302.

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.

Regards
Ashwini Patil