lightning: cannot generate value for auto_random column if it's in a composite primary key

[D3Hunter]

Bug Report

Please answer these questions before submitting your issue. Thanks!

on tidb 6.5, we can create a table with auto_random column and it's in a composite primary key, while we cannot do it on 6.1
currently lightning check it using pkIsHandle, so will not auto generate data for this column in local backend(tidb backend don't has this problem) if it's the extra column added in downstream but it doesn't exist in source file

tidb/br/pkg/lightning/backend/kv/sql2kv.go

Line 497 in 8497f7d

case isTableAutoRandom(tblMeta) && isPKCol(col.ToInfo()):

we should check it with this now

tidb/ddl/ddl_api.go

Line 1552 in 8497f7d

func IsAutoRandomColumnID(tblInfo *model.TableInfo, colID int64) bool {

1. Minimal reproduce step (Required)

2. What did you expect to see? (Required)

3. What did you see instead (Required)

4. What is your TiDB version? (Required)