Magento2: catalog_url_rewrite_product_category table missing PK

[siliconalchemy]

The catalog_url_rewrite_product_category table is missing a PK. Because of this, it cannot be replicated reliably in Galera based systems (eg. MariaDB, Percona XtradbCluster). It appears to be the only table without a PK. This is more of a problem with PXC 5.7 as it recommends enforcing strict mode which will actively break usage of this table.

Magento 2.1.5
Mysql: Percona XtraDBCluster 5.7

[veloraven]

@siliconalchemy please, format this issue according to the Issue reporting guidelines: with steps to reproduce, actual result and expected result.

[siliconalchemy]

Did you read this? How much more specific do you want it to be? Never mind, you can leave your (buggy) project buggy (ier).

[korostii]

Hi @veloraven, @magento-team,
The description seems quite extensive. Could you maybe pass this along to someone having some technical expertise in this field?

[ihor-sviziev]

@engcom-Golf @engcom-Alfa could you double check if this issue still valid, as we're having bugfix for this issue in #25746?