Magento2: Product resource getAttributeRawValue function does not return anything if there is no default value

[VincentMarmiesse]

Preconditions

1. Magento 2.2.4
2. PHP 7.1.17

Steps to reproduce

1. Create a storeview EN
2. Create a storeview FR
3. Create a dropdown attribute with some values
4. Change this attribute value on EN view
5. Use getAttributeRawValue() to retrieve it, ie

$product->getResource()->getAttributeRawValue($product->getId(), 'attribute_code', $this->_storeManager->getStore()->getId());

Expected result

1. Value is returned

Actual result

1. No value is returned because there is no value in default store (store 0).

[magento-engcom-team]

Hi @VincentMarmiesse. Thank you for your report.
To help us process this issue please make sure that you provided the following information:

• [x] Summary of the issue
• [x] Information on your environment
• [x] Steps to reproduce
• [x] Expected and actual results

Please make sure that the issue is reproducible on the vanilla Magento instance following Steps to reproduce. To deploy vanilla Magento instance on our environment, please, add a comment to the issue:

@magento-engcom-team give me {$VERSION} instance

where {$VERSION} is version tags (starting from 2.2.0+) or develop branches (2.2-develop +).
For more details, please, review the Magento Contributor Assistant documentation.

@VincentMarmiesse do you confirm that you was able to reproduce the issue on vanilla Magento instance following steps to reproduce?

• [ ] yes
• [ ] no

[VincentMarmiesse]

@magento-engcom-team give me 2.2.4 instance

[magento-engcom-team]

Hi @VincentMarmiesse. Thank you for your request. I'm working on Magento 2.2.4 instance for you

[magento-engcom-team]

Hi @VincentMarmiesse, here is your Magento instance.
Admin access: https://i-16382-2-2-4.engcom.dev.magento.com/admin
Login: admin Password: 123123q
Instance will be terminated in up to 3 hours.

[VincentMarmiesse]

I can't confirm with this instance because I have to write some code and call the function getAttributeRawValue.
Can I do it with your instance?

[orlangur]

@VincentMarmiesse is it a duplicate of https://github.com/magento/magento2/issues/15205 maybe? Please check if corresponding PR worked for you.

[VincentMarmiesse]

@orlangur no it's not. It's not related to the session or translation, the SQL request done by getAttributeRawValue is assuming there is a value for the store 0, but it's not always the case.

[engcom-backlog-nickolas]

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

[magento-engcom-team]

Hi @shikhamis11. 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.

[shikhamis11]

MM19IN

[funnyboy1190]

@magento-engcom-team give me 2.2.4 instance

[magento-engcom-team]

Hi @funnyboy1190. Thank you for your request. I'm working on Magento 2.2.4 instance for you

[magento-engcom-team]

Hi @funnyboy1190, here is your Magento instance.
Admin access: https://i-16382-2-2-4.instances.magento-community.engineering/admin
Login: admin Password: 123123q
Instance will be terminated in up to 3 hours.

[semajeg]

mmuk2019

[m2-assistant[bot]]

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

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

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

  Details

  - Add the comment @magento 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 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.

---

• Join Magento Community Engineering Slack and ask your questions in #github channel.

[magento-engcom-team]

Hi @VincentMarmiesse. Thank you for your report.
The issue has been fixed in magento/magento2#23369 by @semajeg in 2.3-develop branch
Related commit(s):

• 01f1f157dc2f17a0bbefcfe9ba717c96d788fb53
• 64184b3bf28b2a88ac691ca651d219ed74cf94ef
• 35c5185bdae84cae7ac5008098ae0d2d893cf05b
• 9ae33c855dd68bbdfcfe4148facaaa9c0c4b30a1
• 8c4bfa62528235b651a06e9a24f4a8a0b3a5f7f9
• 7b0e528a316af06dac9d6327db25ed53065a0893
• c34f83cb30a5960a62dbeff562fdbf7215d616a0
• 4d380bf488e027047833d270bb7d816d78d0f43f
• 540f03e33772b366205c3862cc9c44a125f110ea

The fix will be available with the upcoming 2.3.4 release.