Multiple Select attribute value not display in search result page properly.

[RakeshJesadiya]

I have installed Magento 2.2.2 with sample data. I want to be searchable for Pattern attributes from default sample data. I have edit Patter attribute from Stores -> Product and Set Use In Search of Yes and set search Weight to default 1. Now There are Total 5 products are available to Pattern with striped value in sample data.

When we search for 'striped' from search bar, They will give result only four product instead of five products already contains the striped value for pattern attributes. If I set for another product with striped value for pattern attribute though they will also not display in search result page. I have tried with run indexer and cache command but not getting the proper result. Is there an Issue for multiple select attribute value in search page?

Preconditions

1. Magento CE 2.2.2

Steps to reproduce

1. Install Sample data in fresh instance.
2. Go To Stores -> Product, Make Pattern Attribute for Use in Search.
3. Run Indexer command.
4. Search Striped or any other option from Pattern attribute.

Expected result

1.In search result, Display all of the product which has Attribute option value equal to striped.

Actual result

[magento-engcom-team]

@RakeshJesadiya, thank you for your report.
We've acknowledged the issue and added to our backlog.

[magento-engcom-team]

Hi @engcom-backlog-andrii. Thank you for working on this issue.
Looks like this issue is already verified and confirmed. But if your want to validate it one more time, please, go though the following instruction:

• 1. Add/Edit Component: XXXXX label(s) to the ticket, indicating the components it may be related to.

• 2. Verify that the issue is reproducible on 2.3-develop branch

  Details

  - Add the comment @magento-engcom-team give me 2.3-develop instance to deploy test instance on Magento infrastructure.
  - If the issue is reproducible on 2.3-develop branch, please, add the label Reproduced on 2.3.x.
  - If the issue is not reproducible, add your comment that issue is not reproducible and close the issue and stop verification process here!

• 3. Verify that the issue is reproducible on 2.2-develop branch.

  Details

  - Add the comment @magento-engcom-team give me 2.2-develop instance to deploy test instance on Magento infrastructure.
  - If the issue is reproducible on 2.2-develop branch, please add the label Reproduced on 2.2.x

• 4. If the issue is not relevant or is not reproducible any more, feel free to close it.

[magento-engcom-team]

@engcom-backlog-tomash Thank you for verifying the issue.

Unfortunately, not enough information was provided to created internal ticket. Please consider adding the following:

• Update issue content to follow format required by Issue Reporting Guidelines

Once all required information is added, please add label "Issue: Confirmed" again.
Thanks!

[ghost]

@RakeshJesadiya, thank you for reporting this issue!
I tried to reproduce this issue on Magento with and without SampleData installed.
This issue is reproducible when MySQL is used for CatalogSearch. Note that starting from Magento 2.3.0 the recommended solution for this is ElasticSearch. Search results do not include Sport Shorts. I duplicated this item and nothing changed.

At the same time I haven't found good combination to reproduce this problem on clean Magento with products and attributed created by hands. Visually the same attributes can have some properties under the hood that were added programmatically.

I suggest to move this issue to another repository for getting more information from experts who has deep understanding of how SampleData is made. For now I can state that the products that were added manually are available in search results and duplicates of the Shorts aren't. I have no explanation for this problem or any idea on how it can be reproduced without SampleData

[sdzhepa]

Hello @RakeshJesadiya

According to the comment above:
This issue reproduced only on Magento with sample data installed and cannot be reproduced with the same case but without sample data
I move this ticket into Sample Data track

Thank you for feedback and collaboration!