rhtyd commented on a change in pull request #4574:
URL: https://github.com/apache/cloudstack/pull/4574#discussion_r592134122
##########
File path: engine/schema/src/main/resources/META-INF/db/schema-41500to41510.sql
##########
@@ -19,3 +19,7 @@
-- Schema upgrade from 4.15.0.0 to 4.15.1.0
--;
+-- Correct guest OS names
+UPDATE `cloud`.`guest_os` SET display_name='Fedora Linux (32 bit)' WHERE
id=320;
+UPDATE `cloud`.`guest_os` SET display_name='Mandriva Linux (32 bit)' WHERE
id=323;
+UPDATE `cloud`.`guest_os` SET display_name='OpenSUSE Linux (32 bit)' WHERE
id=327;
Review comment:
Nevermind the only mapping is that for opensuse/vmware:
```
mysql> select * from guest_os_hypervisor where guest_os_id=327;
+------+-----------------+---------------+-------------+--------------------+--------------------------------------+---------------------+---------+-----------------+
| id | hypervisor_type | guest_os_name | guest_os_id | hypervisor_version
| uuid | created | removed |
is_user_defined |
+------+-----------------+---------------+-------------+--------------------+--------------------------------------+---------------------+---------+-----------------+
| 7156 | VMware | opensuseGuest | 327 | 6.0
| 81c7f8a1-4b4d-11eb-8705-dca6322512d7 | 2020-12-31 09:49:42 | NULL |
0 |
| 7157 | VMware | opensuseGuest | 327 | 6.5
| 81c8b2d6-4b4d-11eb-8705-dca6322512d7 | 2020-12-31 09:49:42 | NULL |
0 |
| 7158 | VMware | opensuseGuest | 327 | 6.7
| 81c95b16-4b4d-11eb-8705-dca6322512d7 | 2020-12-31 09:49:42 | NULL |
0 |
| 7159 | VMware | opensuseGuest | 327 | 6.7.1
| 81ca26a0-4b4d-11eb-8705-dca6322512d7 | 2020-12-31 09:49:42 | NULL |
0 |
| 7160 | VMware | opensuseGuest | 327 | 6.7.2
| 81cadedc-4b4d-11eb-8705-dca6322512d7 | 2020-12-31 09:49:42 | NULL |
0 |
| 7161 | VMware | opensuseGuest | 327 | 6.7.3
| 81cbadad-4b4d-11eb-8705-dca6322512d7 | 2020-12-31 09:49:42 | NULL |
0 |
+------+-----------------+---------------+-------------+--------------------+--------------------------------------+---------------------+---------+-----------------+
6 rows in set (0.00 sec)
```
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
