weizhouapache commented on PR #7799:
URL: https://github.com/apache/cloudstack/pull/7799#issuecomment-1685800562
tested a fresh installation with this PR, all looks good
```
MariaDB [cloud]> select display_name,count(1) as count from guest_os group
by display_name having count >1;
+------------------+-------+
| display_name | count |
+------------------+-------+
| Oracle Linux 9 | 2 |
| SCO OpenServer 5 | 2 |
+------------------+-------+
2 rows in set (0.00 sec)
MariaDB [cloud]>
MariaDB [cloud]> select * from guest_os join (select display_name,count(1)
as count from guest_os group by display_name having count >1) dup where
guest_os.display_name = dup.display_name;
+-----+-------------+------+--------------------------------------+------------------+---------------------+---------+-----------------+---------+------------------+-------+
| id | category_id | name | uuid |
display_name | created | removed | is_user_defined | display |
display_name | count |
+-----+-------------+------+--------------------------------------+------------------+---------------------+---------+-----------------+---------+------------------+-------+
| 85 | 9 | NULL | e37ab646-3db2-11ee-89e3-1e00fe0000fb | SCO
OpenServer 5 | 2023-08-18 10:35:25 | NULL | 0 | 1 | SCO
OpenServer 5 | 2 |
| 315 | 1 | NULL | f75a059f-3db2-11ee-89e3-1e00fe0000fb | Oracle
Linux 9 | 2023-08-18 10:35:35 | NULL | 0 | 1 | Oracle
Linux 9 | 2 |
| 329 | 3 | NULL | 68dea665-038b-4437-ae31-54599e892a24 | Oracle
Linux 9 | 2023-08-18 10:35:37 | NULL | 0 | 0 | Oracle
Linux 9 | 2 |
| 353 | 7 | NULL | 4988ca91-11aa-43e4-91bf-dc1de45265e1 | SCO
OpenServer 5 | 2023-08-18 10:35:37 | NULL | 0 | 0 | SCO
OpenServer 5 | 2 |
+-----+-------------+------+--------------------------------------+------------------+---------------------+---------+-----------------+---------+------------------+-------+
4 rows in set (0.00 sec)
MariaDB [cloud]>
MariaDB [cloud]> select * from guest_os where display_name like "Red Hat
Enterprise Linux 9%";
+-----+-------------+------+--------------------------------------+------------------------------+---------------------+---------+-----------------+---------+
| id | category_id | name | uuid |
display_name | created | removed | is_user_defined
| display |
+-----+-------------+------+--------------------------------------+------------------------------+---------------------+---------+-----------------+---------+
| 316 | 1 | NULL | f75a1769-3db2-11ee-89e3-1e00fe0000fb | Red Hat
Enterprise Linux 9 | 2023-08-18 10:35:35 | NULL | 0 |
0 |
| 332 | 4 | NULL | be590632-316c-46ea-970c-9569dfd7e732 | Red Hat
Enterprise Linux 9.0 | 2023-08-18 10:35:37 | NULL | 0 |
1 |
+-----+-------------+------+--------------------------------------+------------------------------+---------------------+---------+-----------------+---------+
2 rows in set (0.00 sec)
MariaDB [cloud]> select * from guest_os_hypervisor where guest_os_id in
(select id from guest_os where display_name like "Red Hat Enterprise Linux 9");
+------+-----------------+----------------------------+-------------+--------------------+--------------------------------------+---------------------+---------+-----------------+
| id | hypervisor_type | guest_os_name | guest_os_id |
hypervisor_version | uuid | created
| removed | is_user_defined |
+------+-----------------+----------------------------+-------------+--------------------+--------------------------------------+---------------------+---------+-----------------+
| 8584 | KVM | Red Hat Enterprise Linux 9 | 316 |
default | f75a1f1e-3db2-11ee-89e3-1e00fe0000fb | 2023-08-18 10:35:35
| NULL | 0 |
| 8588 | VMware | rhel9_64Guest | 316 | 7.0
| f75a62c8-3db2-11ee-89e3-1e00fe0000fb | 2023-08-18 10:35:35 | NULL
| 0 |
| 8592 | VMware | rhel9_64Guest | 316 |
7.0.1.0 | f75aa4cc-3db2-11ee-89e3-1e00fe0000fb | 2023-08-18 10:35:35
| NULL | 0 |
| 8596 | VMware | rhel9_64Guest | 316 |
7.0.2.0 | f75ae5aa-3db2-11ee-89e3-1e00fe0000fb | 2023-08-18 10:35:35
| NULL | 0 |
| 8600 | VMware | rhel9_64Guest | 316 |
7.0.3.0 | f75b2753-3db2-11ee-89e3-1e00fe0000fb | 2023-08-18 10:35:35
| NULL | 0 |
| 8827 | VMware | rhel9_64Guest | 316 | 8.0
| f75bafe2-3db2-11ee-89e3-1e00fe0000fb | 2023-08-18 10:35:35 | NULL
| 0 |
| 9082 | VMware | rhel9_64Guest | 316 |
8.0.0.1 | f75c73f7-3db2-11ee-89e3-1e00fe0000fb | 2023-08-18 10:35:35
| NULL | 0 |
| 9631 | VMware | rhel9_64Guest | 316 | 8.0.1
| 047a6fc6-4649-4993-9be1-3407adb19d57 | 2023-08-18 10:35:37 | NULL
| 0 |
+------+-----------------+----------------------------+-------------+--------------------+--------------------------------------+---------------------+---------+-----------------+
8 rows in set (0.00 sec)
MariaDB [cloud]> select * from guest_os_hypervisor where guest_os_id in
(select id from guest_os where display_name like "Red Hat Enterprise Linux
9.0");
+------+-----------------+----------------------------+-------------+--------------------+--------------------------------------+---------------------+---------+-----------------+
| id | hypervisor_type | guest_os_name | guest_os_id |
hypervisor_version | uuid | created
| removed | is_user_defined |
+------+-----------------+----------------------------+-------------+--------------------+--------------------------------------+---------------------+---------+-----------------+
| 9138 | VMware | rhel9_64Guest | 332 |
7.0.1.0 | 1d2b9b9d-0fd1-4b56-afa7-fd1ab544bf41 | 2023-08-18 10:35:37
| NULL | 0 |
| 9646 | KVM | Red Hat Enterprise Linux 9 | 332 |
default | a179dc2e-2fa8-4d37-b02b-fc4f1c1e7a31 | 2023-08-18 10:35:37
| NULL | 0 |
| 9647 | VMware | rhel9_64Guest | 332 | 7.0
| 250aeb8a-9b28-425e-ad35-febd810ee7c3 | 2023-08-18 10:35:37 | NULL
| 0 |
| 9648 | VMware | rhel9_64Guest | 332 |
7.0.2.0 | c5b5703e-9a63-4826-a7d2-d6abe56bad28 | 2023-08-18 10:35:37
| NULL | 0 |
| 9649 | VMware | rhel9_64Guest | 332 |
7.0.3.0 | b4eba39d-55c9-4c46-83e3-f7a31136e64a | 2023-08-18 10:35:37
| NULL | 0 |
| 9650 | VMware | rhel9_64Guest | 332 | 8.0
| 0657753f-1587-40e3-9785-439503ef979a | 2023-08-18 10:35:37 | NULL
| 0 |
| 9651 | VMware | rhel9_64Guest | 332 |
8.0.0.1 | fd73ef92-e817-4f91-8963-b3711a7917b7 | 2023-08-18 10:35:37
| NULL | 0 |
| 9652 | VMware | rhel9_64Guest | 332 | 8.0.1
| 7cfdb21e-fbe0-471c-b2f3-6730901073a0 | 2023-08-18 10:35:37 | NULL
| 0 |
+------+-----------------+----------------------------+-------------+--------------------+--------------------------------------+---------------------+---------+-----------------+
8 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.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
