Problem with guest os mappings for Red Hat Enterprise Linux 9 in ACS 4.18.0.0 #7781

I checked the databases for RHEL9 guest os mappings and found some issues

1. there are two guest os for Red Hat Enterprise Linux 9

mysql> select * from guest_os where display_name like "Red Hat Enterprise Linux 9%";

2. guest os name has extra comma

select * from guest_os_hypervisor where guest_os_id=316;

3. another guest os only applies on VMware 7.0.1.0

select * from guest_os_hypervisor where guest_os_id=336;

this is not the only one. all guest os mappings in #7095 have the same problem (only supported in VMwre 7.0.1.0).

ISSUE TYPE

• Bug Report

COMPONENT NAME

CLOUDSTACK VERSION

4.18.0.0

CONFIGURATION

OS / ENVIRONMENT

SUMMARY

STEPS TO REPRODUCE

EXPECTED RESULTS

ACTUAL RESULTS