Upgraded to mysql 8.0 - table now fails to update thorugh entity framework

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
KW
Posts: 135
Joined: Tue 19 Feb 2008 19:12

Upgraded to mysql 8.0 - table now fails to update thorugh entity framework

Post by KW » Wed 20 Jun 2018 20:03

I have a column named Grouping in one of my entities which works correctly using mysql 5.7

I have updated mysql 8.0, so now when I use entity framework to save changes to this entity it throws a syntax exception.

https://dev.mysql.com/doc/refman/8.0/en/keywords.html

Grouping is now a keyword, so my column needs to be quoted - is this something that I can force entityframework to do or can you update entity developer to use ` ` around the grouping column?

Thanks.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Upgraded to mysql 8.0 - table now fails to update thorugh entity framework

Post by Shalex » Mon 25 Jun 2018 18:25

Thank you for your report. We will notify you when MySQL v8.0 keywords are supported.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Upgraded to mysql 8.0 - table now fails to update thorugh entity framework

Post by Shalex » Fri 20 Jul 2018 11:38

MySQL 8.0 is supported: viewtopic.php?f=2&t=37477.

Post Reply