[CLOUDSTACK-3608] "guest_os_hypervisor" table has repeated mappings of hypervisor and guest OS

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.2.0
• Fix Version/s: 4.5.0
• Component/s: Management Server
• Security Level: Public (Anyone can view this level - this is the default.)
• Assignee: Amogh Vasekar
• Reporter: Chandan Purushothama
• Created: 17/Jul/13 22:04
• Updated: 03/Nov/14 23:39
• Resolved: 03/Nov/14 23:37

Description

mysql> select hypervisor_type,guest_os_name,guest_os_id from guest_os_hypervisor where guest_os_id in (165,166,167,168);
--------------------------------------------------------

hypervisor_type

guest_os_name

guest_os_id

--------------------------------------------------------

XenServer	Windows 8 (32-bit)	165
XenServer	Windows 8 (64-bit)	166
XenServer	Windows Server 2012 (64-bit)	167
XenServer	Windows Server 8 (64-bit)	168
VmWare	Windows 8 (32-bit)	165
VmWare	Windows 8 (64-bit)	166
VmWare	Windows Server 2012 (64-bit)	167
VmWare	Windows Server 8 (64-bit)	168
VmWare	Windows 8 (32-bit)	165
VmWare	Windows 8 (64-bit)	166
VmWare	Windows Server 2012 (64-bit)	167
VmWare	Windows Server 8 (64-bit)	168
XenServer	Windows 8 (32-bit)	165
XenServer	Windows 8 (64-bit)	166
XenServer	Windows Server 2012 (64-bit)	167
XenServer	Windows Server 8 (64-bit)	168

--------------------------------------------------------
16 rows in set (0.00 sec)