Tracking issues for migrating TiDB DDL/DML related test

[maxshuang]

What did you do?

Background

In order to ensure the correctness of TiCDC DDL/DML-related processing logic and to facilitate the verification of the correctness of pr modification, it is necessary to introduce DDL/DML-related feature test cases in TIDB.

Test Form

• Integration Test
• Test-infra

Migration Cases

Integration Test https://github.com/pingcap/tidb-test

• ddl_test --- multi-types DDL
• mysql_test --- mysql test cases
  • migrate tidb mysql test to ticdc(part2) #5081
  • bigint
  • composite_index
  • date_formats
  • datetime_insert.test
  • datetime_update.test
  • drop
  • mysql_replace
  • gcol_alter_table.test
  • insert_select.test
  • insert_update.test
  • json.test
  • partition_bug18198.test
  • partition_list.test
  • partition_range.test
  • single_delete_update.test
  • time.test
  • timestamp_insert.test
  • timestamp_update.test
  • transaction_isolation_func.test
  • type_decimal.test
  • type_time.test
  • type_timestamp.test
  • type_uint.test
  • update.test
  • update_stmt.test
  • concurrent_ddl
  • alter_table.test
  • alter_table_PK.test
  • alter_table1.test
  • date_time_ddl.test
  • insert.test --- select result wrong
  • ctype_gbk.test --- gbk charset related， default charset ??
  • delete.test --- delete DML, strange output ??
  • expression_index.test ---expression index, tidb error Error 8200??
  • issue_*.test --- issues related
  • json_function.test/json_gcol.test
  • multi_update.test --- update multi-tables in one sql， stuck by TiDB, rename error ??
  • partition_innodb.test/partition_hash.test
  • replace.test --- replace into, text output bug??
  • str_quoted.test --- string with quota. --- has problems with quoted ??
  • temp_table.test --- tidb not support rename tmp table ??
  • type_binary.test/type_enum.test/type_varchar.test -- quote error ??
• randgen-test --- go-randgen data test
• tidb_test --- DDL/DML related
• massive_ddl_test --- massive DDL
• https://github.com/PingCAP-QE/schrddl --- DDL related

Test-infra

• TODO

Related BUG

• table schema corrupt, Error 1105: invalid data type: Unsupported datum flag 9 for Bit vector" tidb#32506 --- bit type support, affect default value integration test
• Set default DDL still work after rename table, which cause TiCDC fail tidb#32610. --- stuck schrddl test
• Delete using outer join can mistakenly delete the row whose handle=0 tidb#31321. --- migrate the multi-update test case
• Integration test clustered_index_test find data inconsistency on t_set/t_enum #3421 --- some bug in kafka test, need deal
• Default value may cause more data inconsistency #4048 --- default value related
• DML construct error and changefeed stop caused by 'rename tables' #5059 --- cdc rename table bug
• data inconsistency for json generate column from json_gcol(tidb-mysql-test) #5075.
• Data Race when running schrddl test #6134