This sql also return empty set.
select CONSTRAINT_NAME, TABLE_NAME, COLUMN_NAME from information_schema.KEY_COLUMN_USAGE where REFERENCED_TABLE_NAME = ‘reporting_report_design’ and REFERENCED_COLUMN_NAME = ‘report_definition_id’;
Alright, let’s try not beating around the bush. Can you just try to execute this SQL:
ALTER TABLE reporting_report_design DROP COLUMN report_definition_id; ERROR 1553 (HY000): Cannot drop index ‘report_definition_id for reporting_report_design’: needed in a foreign key constraint
I also faced this issue few days before but after some struggle , i have done it by simply adding all modules one by one from legacy-ui and I was getting error but restarting server while encountering errors will solved the problem.
Ok thanks for the advice