Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- diff --git a/Model/ResourceModel/Product/Indexer/Price/Query/BaseFinalPrice.php b/ResourceModel/Product/Indexer/Price/Query/BaseFinalPrice.php
- index 8428ff3688b2..0005ac8dea58 100644
- --- a/Model/ResourceModel/Product/Indexer/Price/Query/BaseFinalPrice.php
- +++ b/Model/ResourceModel/Product/Indexer/Price/Query/BaseFinalPrice.php
- @@ -190,7 +190,7 @@ public function getQuery(array $dimensions, string $productType, array $entityId
- $specialFromExpr = "{$specialFrom} IS NULL OR {$specialFromDate} <= {$currentDate}";
- $specialToExpr = "{$specialTo} IS NULL OR {$specialToDate} >= {$currentDate}";
- $specialPriceExpr = $connection->getCheckSql(
- - "{$specialPrice} IS NOT NULL AND {$specialFromExpr} AND {$specialToExpr}",
- + "{$specialPrice} IS NOT NULL AND ({$specialFromExpr}) AND ({$specialToExpr})",
- $specialPrice,
- $maxUnsignedBigint
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement