MySQL catalog search engine will be removed in Adobe Commerce 2.4.0. You must have the Elasticsearch host set up and configured prior to installing version 2.4.0. Refer to Install and configure Elasticsearch in our developer documentation.
This article provides a patch for the known Adobe Commerce on cloud infrastructure 2.2.3 issue related to getting different search results for the same search query with MySQL and ElasticSearch.
Your catalog search results with the same filter set differ depending on the search engine being used, MySQL or ElasticSearch.
Steps to reproduce :
Expected result:
The number of matching products is the same.
Actual result:
The number of matching products is different.
The patches are attached to this article. To download a patch, scroll down to the end of the article and click the required file name, or click on the following links:
Download MDVA-12312_EE_2.2.3_COMPOSER_v1.patch
Download MDVA-14172_EE_2.2.6_COMPOSER_v1.patch
The patches were created for:
MDVA-12312_EE_2.2.3_COMPOSER_v1.patch
file)MDVA-14172_EE_2.2.6_COMPOSER_v1.patch
file)The MDVA-12312_EE_2.2.3_COMPOSER_v1.patch
patch is also compatible (but might not solve the issue) with the following Adobe Commerce versions and editions:
The MDVA-14172_EE_2.2.6_COMPOSER_v1.patch
patch is also compatible (but might not solve the issue) with the following Adobe Commerce versions and editions:
See How to apply a composer patch provided by Adobe in our support knowledge base for instructions.