We're on a heavily modified EE 18.104.22.168 with some 20 store views - some of them sharing the same language - facing a problem with url keys.
These are generated and differ per language BUT this doesn't work reliably because of the unique index on the
value column in
catalog_product_entity_url_key. The unique constraint prevents duplicated url keys even if they belong to different store views.
As a result it seems impossible to have both of these links in the same magento installation:
Seems like in previous versions the index spanned
(store_id, value) but was changed to
value only. Can anyone explain why this has changed? Btw:
catalog_category_entity_url_key doesn't have any index on its
Is it safe to change the index back to
(store_id, value)? Would I have to change other tables as well (e.g. tmp or index ones)?
Any other suggestion on how to work around this?
Other URL-related tables (*_url_rewrite_*) all seem to include the store_id in their unique indices so this observed abnormality is getting even weirder.