"GetMainAssetTypeAtPath" and "GetMainAssetTypeFromGUID" functions return the wrong type when the same type name exists in another namespace

Reproduction steps:
1. Open the attached “BugRepro” project
2. Run the test (Test > Find MyMaterial assets)
3. Observe the Console window

Expected result: No warnings are printed out
Actual result: Warnings are printed out regarding retrieved asset types not matching the real asset types

Reproducible with: 2022.3.15f1, 2023.1.8f1
Not reproducible with: 2023.2.0b1, 2023.2.3f1, 2023.3.0a17
Couldn’t test with: 2021.3.33f1, 2023.2.0a1 - 2023.2.0a22 - No support for the “AssetDatabase.GetMainAssetTypeFromGUID” function

Reproducible on: Windows 10
Not reproducible on: No other environment tested

Note:

• If the Library folder does not exist, launch the project, then close it and re-open it again. Otherwise, the bug does not reproduce.