Bug #76191 Index names are generated without quotes in EF 6 Code First Migrations
| Submitted: | 6 Mar 2015 15:08 | Modified: | 8 Apr 2015 5:10 |
|---|---|---|---|
| Reporter: | Alessio Parma | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | Connector / NET | Severity: | S2 (Serious) |
| Version: | 6.9.6 | OS: | Windows |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | code first migrations index code generator | ||
[8 Apr 2015 5:10]
Chiranjeevi Battula
Hello Alessio Parma, Thank you for the bug report. This is duplicate of Bug #73278. Thanks, Chiranjeevi.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.051 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.
Description: Software versions (downloaded from NuGet): * EntityFramework 6.1.2 * MySql.Data.Entity 6.9.6 Migrations which contain indexes cause compilation errors, because MySQL code generator (MySql.Data.Entity.MySqlMigrationCodeGenerator) creates index names without quotes. Example: .Index(t => new { t.COL_A, t.COL_B }, unique: true, name: UN_test_test) How to repeat: Create an entity with an IndexAttribute and run "Add-Migration". Index name will apper without quotes and the generated migration file. Suggested fix: Inside: MySqlMigrationCodeGenerator.GenerateInline(CreateIndexOperation createIndexOperation, IndentedTextWriter writer) Change string ", name: {0}" with ", name: \"{0}\"", so that index name is quoted. We solved this problem by locally overriding that method, and the proposed fix solved the issue.