go-gorm/mysql

Execute ALTER TABLE every time when use AutoMigrate

lansi951 opened this issue · 0 comments

GORM Playground Link

Description

Since 1.0.3 version, Execute ALTER TABLE id column every time when use AutoMigrate.
Until 1.0.2 version, did not execute duplicate migrate on once migrated column.

2020/12/18 17:01:34 /go/pkg/mod/gorm.io/driver/mysql@v1.0.3/migrator.go:83 SLOW SQL >= 200ms
[215.581ms] [rows:0] ALTER TABLE `...` MODIFY COLUMN `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT

model setting

type Model struct {
	ID        int       `gorm:"type:INT(10) UNSIGNED NOT NULL AUTO_INCREMENT;primaryKey"`
	...
}