Not support "ON DUPLICATE KEY"

[haomeihong]

GORM Playground Link

can not work correct on this SQL:
INSERT INTO risk_result (campaign_id,risk_level,dirty,manual_mark,ext,create_time,update_time,delete_time,id) VALUES (?,?,?,?,?,?,?,?,?) ON DUPLICATE KEY UPDATE campaign_id=VALUES(campaign_id)

[penril0326]

I have same issue

err := tx.WithContext(ctx).Clauses(clause.OnConflict{
	Columns: []clause.Column{{Name: "unique_col_a"}},
	DoUpdates: clause.AssignmentColumns([]string{
		"col_b", "col_c", "col_d",
	}),
}).Create(&list).Error
if err != nil {
	return nil, err
}

The err will give me Field 'id' doesn't have a default value error msg. The id is my primary key and it's generated by gorm (using algorithm sharding.PKSnowflake). I think I don't need to gen id by myself.