Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ConvertToMySqlDbType for NewDate is not implemented #1007

Closed
dtrickett opened this issue Jul 1, 2021 · 2 comments
Closed

ConvertToMySqlDbType for NewDate is not implemented #1007

dtrickett opened this issue Jul 1, 2021 · 2 comments
Assignees
Labels

Comments

@dtrickett
Copy link

Using MySQL 5.7.12 and running into the following when a UNION query contains a date:

  ----> MySqlConnector.MySqlException : Failed to read the result set.
Data:
  Server Error Code: 0
  SqlState: <null>

  ----> System.NotImplementedException : ConvertToMySqlDbType for NewDate is not implemented

Seems this is fixed in MySQL 5.7.22
"Metadata from result sets for UNION ALL queries could say NEWDATE rather than DATE. (Bug #27422376)"

Is this something that can be addressed within the library, or only by updating MySQL? We are attempting to migrate from MySql.Data and this is currently the only blocker.

@bgrainger bgrainger added the bug label Jul 1, 2021
@bgrainger bgrainger self-assigned this Jul 1, 2021
@bgrainger
Copy link
Member

This will require a bugfix in the library.

Thanks for reporting the detail that it requires an old MySQL 5.7.x version with a UNION ALL query to repro.

@bgrainger
Copy link
Member

Fixed in 1.3.11.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Development

No branches or pull requests

2 participants