[Issue] Fixed table difference insert during price reindex #36482
Labels
Priority: P1
Once P0 defects have been fixed, a defect having this priority is the next candidate for fixing.
Progress: done
Projects
This issue is automatically created based on existing pull request: #36370: Fixed table difference insert during price reindex
Description (*)
Problem appears when dimensions are not used.
catalog_product_index_price
is now incompatible withcatalog_product_index_price_tmp
as new ID columnt addedhttps://devdocs.magento.com/guides/v2.4/release-notes/backward-incompatible-changes/reference.html
so method works incorrectly as final query contains additional column
We faced this issue while running graphql tests when indexers is set -
update on save
The issue might be skipped in fixtures but when tests are placing the order - it triggers reindex that blocks order placing.
In query logs we may see how temp table is created
Related Pull Requests
Fixed Issues (if relevant)
cannot reindex price
Manual testing scenarios (*)
Magento\Catalog\Model\Indexer\Product\Price::executeRow
Questions or comments
Contribution checklist (*)
The text was updated successfully, but these errors were encountered: