Microsoft.EntityFrameworkCore.Migrations.RenameColumn bug
using Mysql DB & efCore version 5.0.10.0;
an error happened when I updating DB by cmd: "update-database" in VS2019 Ent.
migration source Code:
//
protected override void Up(MigrationBuilder migrationBuilder)
{
migrationBuilder.RenameColumn(
name: "Weig",
table: "Book",
newName: "Weight");
}
err Info:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'COLUMN Weig
TO Weight
' at line 1.
and other message:
Failed executing DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
ALTER TABLE Book
RENAME COLUMN Weig
TO Weight
;