Bug #92982 | Wrong GUID type when execute SHOW COLLATION statment | ||
---|---|---|---|
Submitted: | 29 Oct 2018 7:59 | Modified: | 27 Jun 2019 6:07 |
Reporter: | Realanan May | Email Updates: | |
Status: | Duplicate | Impact on me: | |
Category: | Connector / NET | Severity: | S3 (Non-critical) |
Version: | 6.9.12, 8.0.16 | OS: | Windows |
Assigned to: | CPU Architecture: | x86 | |
Tags: | Connect/NET, datatype |
[29 Oct 2018 7:59]
Realanan May
[30 Oct 2018 12:45]
MySQL Verification Team
Hello Realanan May, Thank you for the report. I could not repeat the issue at our end using with Visual Studio 2017, Connector/NET 8.0.13. Could you please provide exact sample project which triggers this issue? Thank you. Also, MySQL Connector/NET 8.0 is highly recommended for use with MySQL Server 8.0, 5.7, 5.6, and 5.5. Please upgrade to MySQL Connector/NET 8.0. regards, Umesh
[31 Oct 2018 0:07]
Realanan May
Hello Umesh Shastry, Thank you for your reply. I tested it again and found the reason. I set the skip-character-set-client-handshake option in server's my.cnf file. When I commented this option, the problem was disappeared. I also debugged the connector's source code. I found an interesting things. When I set the skip-character-set-client-handshake option, the "SHOW COLLATION" statment will return a resultset with the field "Pad_attribute" in CHAR(36) type. And when I unset the skip-character-set-client-handshake option, the field is CHAR(27) type. So that's the problem. Thank you for your reply. Best regards, Realanan
[31 Oct 2018 10:51]
MySQL Verification Team
Thank you for confirming that problem disappeared after commenting out the option. Closing this bug# for now but if don't agree with this then please feel free to add exact sample project which triggers this issue and change the status back to 'Open'. Thank you for your interest in MySQL. regards, Umesh
[27 Jun 2019 6:07]
MySQL Verification Team
Marking this as duplicate of Bug #93399 (sorry, ideally newer one should be marked as duplicate but since Bug #93399 is verified hence marking this as duplicate for now) regards, Umesh