Properties are not copied from mysql_service to other services when running Chef 18

[nshoreibah]

🗣️ Foreword

Thank for taking the time to fill this bug report fully. Without it we may not be able to fix the bug, and the issue may be closed without resolution.

👻 Brief Description

When using the mysql_service library in Chef 18, properties are not copied to the mysql_server_installation and mysql_service_manager instances.

🥞 Cookbook version

11.1.9

👩‍🍳 Chef-Infra Version

18.7.10

🎩 Platform details

GitHub Actions Runner with Ubuntu, Test Kitchen

Steps To Reproduce

Steps to reproduce the behavior:

1. Ensure you are running Chef 18 and have created a cookbook
2. Add the mysql cookbook as a dependency
3. Create an instance of the mysql_service object and specify a version property that is not the default for your platform
4. Test the cookbook (I did in test kitchen)
5. The version of the mysql_server_installation and mysql_service_manager will match the defaults instead of the version you specified

A clear and concise description of what you expected to happen.
I expected the versions to match what I specified in the mysql_service properties instead of my platform's default

➕ Additional context

Maybe the addition of unified mode in Chef 18 breaks this by modifying the behavior of methods used in the mysql_service copy_properties_to function
https://docs.chef.io/release_notes_client/#18.0.185-potential-breaking-change
https://docs.chef.io/unified_mode/#out-of-order-execution