enhance conflictdetector package

[wk989898]

Is your feature request related to a problem?

No

Describe the feature you'd like

The column info and data are linked by their index rather than by column ID. This necessitates sorting the columns to maintain alignment with the column information, which is both imprecise and unreliable.

ticdc/downstreamadapter/sink/conflictdetector/helper.go

Lines 110 to 132 in 5d58767

	for _, i := range colIdx {
	// If the index contain generated column, we can't use this key to detect conflict with other DML,
	if columnInfos[i] == nil || tableInfo.GetColumnFlags()[columnInfos[i].ID].IsGeneratedColumn() {
	return nil, nil
	}
	value, err := common.FormatColVal(row, columnInfos[i], i)
	if err != nil {
	return nil, err
	}
	// if a column value is null, we can ignore this index
	if value == nil {
	return nil, nil
	}
	val := model.ColumnValueString(value)
	if columnNeeds2LowerCase(columnInfos[i].GetType(), columnInfos[i].GetCollate()) {
	val = strings.ToLower(val)
	}
	key = append(key, []byte(val)...)
	key = append(key, 0)
	}

Describe alternatives you've considered

No response

Teachability, Documentation, Adoption, Migration Strategy

No response