I am trying to remove a
catalog_product custom attribute the Magento way by using
Mage_Eav_Model_Entity_Setup::removeAttribute() but it results in bad data integrity: the attribute gets deleted from
eav_attribute table but not from
show create table catalog_eav_attribute
I see the the
attribute_id FK to
eav_attribute defined correctly with
on delete cascade in place
Is this a known bug of Magento or rather a mysql bug?
Magento version is 220.127.116.11, mysql version is 5.5.46 running on ubuntu 14.04.2
Edit: I tried to reproduce the error by mocking a custom relationship between two custom tables using a foreign key constraint with on delete cascade enabled and it worked: when I deleted a row in the parent table, all related rows in child table were deleted accordingly. Why won't the same work for the
Edit2: the same happens with other tables referencing the
customer_eav_attribute, etc, leaving Magento with lots of orphaned child rows in aforementioned tables.