Individual Songs not showing in Artist search results IOS 18.3.2

More detail added:

In ALL cases these are searches conducted on My Library.

If I enter an Artist name e.g. 'Stardust' in the Apple Music Artists search box I get no results. But when I search for Songs by that artist using the Song Search option e.g. the song: 'Music Sounds Better with Me' I get four results on different albums - each result shows the artist name: 'Stardust'.

Let's pick another artist just to prove its not because the track isn't part of a complete album purchase...

Artist search input: 'Herb Alpert', Song: '!!Going Places!!'. I get the Album 'Tijuana Taxi' and when I click on the Album it shows the one Song I purchased from it: '!!Going Places!!'- CORRECT. So how come this did not work for the search on Artist: 'Stardust'???

So let's double check the Artist metadata (on MacOS) for the Song 'Music Sounds Better with Me'. it shows 'Stardust' in all 4 cases. RISK: that if I search by Artist I won't find a track and instead go and buy yet another copy of the same music from iTunes.

Something isn't working... Logged with Apple as UK Incident: 1************94. My appreciation to Apple for spending over 1 hour trying to fix this issue. Incident still open after being escalated to Level 2 support.