lightning's internal table does not have PK so can't work with sql_require_primary_key=ON

[lance6716]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

turn on sql_require_primary_key and run lightning

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

no error

3. What did you see instead (Required)

lightning will create some internal tables, and failed with error Unable to create or change a table without a primary key, when the system variable 'sql_require_primary_key' is set. Add a primary key to the table or unset this variable to avoid this message. Note that tables without a primary key can cause performance problems in row-based replication, so please consult your DBA before changing this setting. This is because these tables have no PK

4. What is your TiDB version? (Required)

all version

[D3Hunter]

does DM have this issue?

[lance6716]

does DM have this issue?

Yes we should also upgrade lightning dependency for DM

[D3Hunter]

I mean does any DM's internal table has no PK?

[lance6716]

DM internal tables also need to add PK, like (cp *RemoteCheckPoint) createTable. Will create issue in tiflow repo soon

[lance6716]

forget to change the VIEW name, reopen.

[lance6716]

seems no need to change VIEW name, because we use CREATE OR REPLACE VIEW