Foreign Key GA

[YangKeao]

Foreign Key feature has been supported for a long time. However, it's not GA yet. There are some existing issues about foreign key, and this issue will track the things which we'll need to do before mark it as GA.

Known issues

• Consistency

  • ddl, planner: avoid running queries on the non-Public state table #55891
  • ddl: fix foreign key consistency under async commit #56349
  • Unistore TiDB cannot handle foreign key in transaction #56663
  • executor: fix the issue that INSERT IGNORE doesn't lock the parent table #56661

• Compatibility

  • Create index doesn't rename the old index that has same columns as the new one #43267 (WON'T FIX)
  • delete ignore foreign key check failed #39712
  • Support the operation of dropping multi-foreign-keys in one statement... #28421 (Multi-schema change)
  • play replay dump wrongly save the table with foreign key  #56458
  • play replay load cannot restore the table with foreign key #56456
  • UPDATE IGNORE doesn't omit the foreign key error #56681
  • INSERT IGNORE ... ON DUPLICATE UPDATE ... doesn't omit foreign key error #56678
  • ALTER TABLE ... DROP FOREIGN KEY IF EXISTS ... shouldn't be supported in parser #56701

• Add more tests

  • Enrich tests for foreign key with PREPARE and "Non-Transactional DML" #56365
  • Add test for SAVEPOINT with Foreign Key function #56562
  • Add test for IMPORT INTO with Foreign Key. #56563
  • tests: add foreign key tests with log filter tiflow#11703

• Others

  • unknownplan in execution plan for insert query #49271

Enhancement