Open travelliu opened 1 year ago
There is a check constraint after mySQL 8.0, and the previous version did not have view check_constraints
my:root@127/mtkd=> \d task_result_details error: failed to describe BASE TABLE mtkd.task_result_details: failed to list constraints: Error 1109 (42S02): Unknown table 'check_constraints' in information_schema my:root@127/mtkd=> desc task_result_details; Field | Type | Null | Key | Default | Extra -------------+--------------+------+-----+---------+---------------- id | bigint(20) | NO | PRI | | auto_increment task_id | bigint(20) | YES | MUL | | run_id | bigint(20) | YES | | | type_name | varchar(20) | YES | | | object_id | varchar(50) | YES | | | src_name | varchar(200) | YES | | | tgt_name | varchar(200) | YES | | | status | varchar(20) | YES | | | start_time | bigint(20) | YES | | | finish_time | bigint(20) | YES | | | use_time | bigint(20) | YES | | | src_sql | mediumblob | YES | | | tgt_sql | mediumblob | YES | | | row_num | bigint(20) | YES | | | target_num | bigint(20) | YES | | | ignore_num | bigint(20) | YES | | | source_diff | bigint(20) | YES | | | target_diff | bigint(20) | YES | | | size | bigint(20) | YES | | | reason | mediumblob | YES | | | reason1 | mediumblob | YES | | | reason2 | mediumblob | YES | | | warning | mediumblob | YES | | | (23 rows) my:root@127/mtkd=> select version(); version() ------------ 5.7.32-log (1 row)
There is a check constraint after mySQL 8.0, and the previous version did not have view check_constraints