Auto-increment value in UPDATE conflicts with internally generated values

[NitroCao]

gorm version: 1.24.1
MySQL version: 8.0.31

I have the following models:

type Report struct {
	ID                   int64                 `gorm:"column:id;type:bigint;primaryKey"`
	UUID                 UUID                  `gorm:"column:uuid;type:binary(16)"`
	Name                 string                `gorm:"column:name;type:varchar(1024)"`
	Records              []Record              `gorm:"many2many:report_record"`
	UpdatedAt            time.Time             `gorm:"column:updated_at;type:timestamp;autoUpdateTime" sql:"default:current_timestamp"`
}

type Record struct {
	ID             int64        `gorm:"column:id;type:bigint;primaryKey"`
	UpdatedAt      time.Time    `gorm:"column:updated_at;type:timestamp;autoUpdateTime" sql:"default:current_timestamp"`
	Name           string       `gorm:"column:name;type:varchar(64);uniqueIndex:name"`
}

According to the Many to Many, I'll have a join table called report_record.

Now I'm going to insert a Report record, in which the length of Records is 720. The insert function is:

func (d *dao) Create(report *Report) (int64, error) {
	result := d.db.Debug().Clauses(clause.OnConflict{
		Columns:   []clause.Column{{Name: "id"}},
		DoUpdates: clause.AssignmentColumns([]string{"uuid"}),
	}).Create(report)
	if result.Error != nil {
		return 0, fmt.Errorf("failed to insert report: %w", result.Error)
	}

	return int64(report.ID), result.Error
}

Expected behavior is:

• Insert the Report record into report table.
• Insert all 720 Record records into record table, do nothing but return ids if conflicts happen.
• Insert all relations between the report and the records into report_record table.

The actual behavior is:

• Return error ERROR 1869 when inserting 720 Record records.

I'm a noob in MySQL. Can anyone help this problem? Thanks in advance.