weizhouapache commented on PR #7799:
URL: https://github.com/apache/cloudstack/pull/7799#issuecomment-1685855146

   test2: upgrade from 4.16.1.1 to 4.18, then to this PR
   
   - 4.16.1.1, looks ok, only 1 duplicated guest OS
   ```
   MariaDB [cloud]> select display_name,count(1) as count from guest_os group 
by display_name having count >1;
   +------------------+-------+
   | display_name     | count |
   +------------------+-------+
   | SCO OpenServer 5 |     2 |
   +------------------+-------+
   1 row in set (0.00 sec)
   
   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_name     | count |
   
+-----+-------------+------+--------------------------------------+------------------+---------------------+---------+-----------------+------------------+-------+
   |  85 |           9 | NULL | 221980dd-3d9d-11ee-af47-1e001e00011f | SCO 
OpenServer 5 | 2023-08-18 07:59:36 | NULL    |               0 | SCO OpenServer 
5 |     2 |
   | 324 |           7 | NULL | 916d7fff-4c71-4a8e-9122-e705495a13ce | SCO 
OpenServer 5 | 2023-08-18 07:59:44 | NULL    |               0 | SCO OpenServer 
5 |     2 |
   
+-----+-------------+------+--------------------------------------+------------------+---------------------+---------+-----------------+------------------+-------+
   2 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 |
   
+-----+-------------+------+--------------------------------------+------------------------------+---------------------+---------+-----------------+
   | 348 |           4 | NULL | 9458424f-0b9a-4abe-8119-b91b7c705fb1 | Red Hat 
Enterprise Linux 9.0 | 2023-08-18 07:59:44 | NULL    |               0 |
   
+-----+-------------+------+--------------------------------------+------------------------------+---------------------+---------+-----------------+
   1 row in set (0.00 sec)
   ```
   
   - upgrade to 4.18, 43 duplicated guest OSes
   ```
   MariaDB [cloud]> select display_name,count(1) as count from guest_os group 
by display_name having count >1;
   +-----------------------------------------------+-------+
   | display_name                                  | count |
   +-----------------------------------------------+-------+
   | Amazon Linux 2 (64 bit)                       |     2 |
   | Amazon Linux 3 (64 bit)                       |     2 |
   | Asianux Server 4 (32 bit)                     |     2 |
   | Asianux Server 4 (64 bit)                     |     2 |
   | Asianux Server 5 (32 bit)                     |     2 |
   | Asianux Server 5 (64 bit)                     |     2 |
   | Asianux Server 7 (32 bit)                     |     2 |
   | Asianux Server 7 (64 bit)                     |     2 |
   | Asianux Server 8 (64 bit)                     |     2 |
   | Asianux Server 9 (64 bit)                     |     2 |
   | CentOS 9                                      |     2 |
   | Debian GNU/Linux 11 (32-bit)                  |     2 |
   | Debian GNU/Linux 11 (64-bit)                  |     2 |
   | eComStation 2.0                               |     2 |
   | Fedora Linux (64 bit)                         |     2 |
   | FreeBSD 13 (32-bit)                           |     2 |
   | FreeBSD 13 (64-bit)                           |     2 |
   | Linux 3.x Kernel (32 bit)                     |     2 |
   | Linux 3.x Kernel (64 bit)                     |     2 |
   | Linux 5.x Kernel (32-bit)                     |     2 |
   | Linux 5.x Kernel (64-bit)                     |     2 |
   | macOS 10.13 (64 bit)                          |     2 |
   | macOS 10.14 (64 bit)                          |     2 |
   | macOS 10.15 (64 bit)                          |     2 |
   | macOS 11 (64 bit)                             |     2 |
   | Mandrake Linux                                |     2 |
   | Mandriva Linux (64 bit)                       |     2 |
   | NeoKylin Linux Server 7                       |     2 |
   | OpenSUSE Linux (32 bit)                       |     2 |
   | OpenSUSE Linux (64 bit)                       |     2 |
   | Oracle Linux 9                                |     3 |
   | OVF Configured OS                             |     2 |
   | Red Hat Enterprise Linux 9.0                  |     2 |
   | Scientific Linux 7                            |     2 |
   | SCO OpenServer 5                              |     3 |
   | SCO OpenServer 6                              |     2 |
   | Solaris 11 (64 bit)                           |     2 |
   | SUSE Linux Enterprise Desktop 12 SP3 (64-bit) |     2 |
   | SUSE Linux Enterprise Desktop 12 SP4 (64-bit) |     2 |
   | SUSE Linux Enterprise Server 12 SP4 (64-bit)  |     2 |
   | SUSE Linux Enterprise Server 16 (64-bit)      |     2 |
   | Ubuntu 20.04 LTS                              |     2 |
   | VMware Photon (64 bit)                        |     2 |
   +-----------------------------------------------+-------+
   43 rows in set (0.01 sec)
   ```
   the RHEL 9 issue also exist
   ```
   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 |
   
+-----+-------------+------+--------------------------------------+------------------------------+---------------------+---------+-----------------+
   | 348 |           4 | NULL | 9458424f-0b9a-4abe-8119-b91b7c705fb1 | Red Hat 
Enterprise Linux 9.0 | 2023-08-18 07:59:44 | NULL    |               0 |
   | 357 |           1 | NULL | 05a1e5a6-3ff8-11ee-af47-1e001e00011f | Red Hat 
Enterprise Linux 9   | 2023-08-21 07:54:57 | NULL    |               0 |
   | 377 |           4 | NULL | c5c314e4-5da2-4b72-927f-21fb35c8276a | Red Hat 
Enterprise Linux 9.0 | 2023-08-21 07:54:59 | NULL    |               0 |
   
+-----+-------------+------+--------------------------------------+------------------------------+---------------------+---------+-----------------+
   3 rows in set (0.00 sec)
   ```
   
   - upgrade to this PR, looks ok (only 1 of duplications has display=1, which 
has all the guest os mappings of other duplications)
   
   ```
   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 and display=1;
   
+-----+-------------+------+--------------------------------------+-----------------------------------------------+---------------------+---------+-----------------+---------+-----------------------------------------------+-------+
   | id  | category_id | name | uuid                                 | 
display_name                                  | created             | removed | 
is_user_defined | display | display_name                                  | 
count |
   
+-----+-------------+------+--------------------------------------+-----------------------------------------------+---------------------+---------+-----------------+---------+-----------------------------------------------+-------+
   |  85 |           9 | NULL | 221980dd-3d9d-11ee-af47-1e001e00011f | SCO 
OpenServer 5                              | 2023-08-18 07:59:36 | NULL    |     
          0 |       1 | SCO OpenServer 5                              |     3 |
   | 305 |          11 | NULL | 0bc2fefa-7a5a-4926-b34d-8acdae172201 | OVF 
Configured OS                             | 2023-08-18 07:59:44 | NULL    |     
          0 |       1 | OVF Configured OS                             |     2 |
   | 307 |           2 | NULL | ebffba86-cd83-41c5-aafe-44138d677f37 | Linux 
3.x Kernel (32 bit)                     | 2023-08-18 07:59:44 | NULL    |       
        0 |       1 | Linux 3.x Kernel (32 bit)                     |     2 |
   | 308 |           7 | NULL | fd352fb9-3dd9-4f97-8d46-1c879670dcce | Amazon 
Linux 2 (64 bit)                       | 2023-08-18 07:59:44 | NULL    |        
       0 |       1 | Amazon Linux 2 (64 bit)                       |     2 |
   | 310 |           7 | NULL | 88a61592-ed97-46b6-9d29-e0fd543acb1a | Asianux 
Server 4 (64 bit)                     | 2023-08-18 07:59:44 | NULL    |         
      0 |       1 | Asianux Server 4 (64 bit)                     |     2 |
   | 311 |           7 | NULL | c1a96eda-b0ba-4e43-86de-95b47194b814 | Asianux 
Server 5 (32 bit)                     | 2023-08-18 07:59:44 | NULL    |         
      0 |       1 | Asianux Server 5 (32 bit)                     |     2 |
   | 313 |           7 | NULL | 68ca7cd1-350b-4e57-a97b-93538a0b343a | Asianux 
Server 7 (32 bit)                     | 2023-08-18 07:59:44 | NULL    |         
      0 |       1 | Asianux Server 7 (32 bit)                     |     2 |
   | 314 |           7 | NULL | 7f67f35b-9b46-4997-8642-2241e74c110d | Asianux 
Server 7 (64 bit)                     | 2023-08-18 07:59:44 | NULL    |         
      0 |       1 | Asianux Server 7 (64 bit)                     |     2 |
   | 316 |           7 | NULL | ee6cd74c-814a-447e-b73c-5ee39736f3f4 | 
eComStation 2.0                               | 2023-08-18 07:59:44 | NULL    | 
              0 |       1 | eComStation 2.0                               |     
2 |
   | 318 |           7 | NULL | b4bbae23-be50-45e2-ba80-07c7d6a60a58 | macOS 
10.14 (64 bit)                          | 2023-08-18 07:59:44 | NULL    |       
        0 |       1 | macOS 10.14 (64 bit)                          |     2 |
   | 322 |           7 | NULL | b6458b04-7304-4f5a-841c-40c2d273cc41 | Mandriva 
Linux (64 bit)                       | 2023-08-18 07:59:44 | NULL    |          
     0 |       1 | Mandriva Linux (64 bit)                       |     2 |
   | 325 |           7 | NULL | 9044236c-4ac8-4217-b856-5b88b7789870 | SCO 
OpenServer 6                              | 2023-08-18 07:59:44 | NULL    |     
          0 |       1 | SCO OpenServer 6                              |     2 |
   | 326 |           7 | NULL | 71c7a8f9-6880-49b0-a293-e864a3e5084d | OpenSUSE 
Linux (64 bit)                       | 2023-08-18 07:59:44 | NULL    |          
     0 |       1 | OpenSUSE Linux (64 bit)                       |     2 |
   | 327 |           7 | NULL | 72f19dc8-0c18-49a4-911c-742fcfa17b2b | OpenSUSE 
Linux (32 bit)                       | 2023-08-18 07:59:44 | NULL    |          
     0 |       1 | OpenSUSE Linux (32 bit)                       |     2 |
   | 331 |           5 | NULL | fe0d744a-421c-4ce7-a3c1-cef3400ba0a8 | SUSE 
Linux Enterprise Desktop 12 SP4 (64-bit) | 2023-08-18 07:59:44 | NULL    |      
         0 |       1 | SUSE Linux Enterprise Desktop 12 SP4 (64-bit) |     2 |
   | 332 |           5 | NULL | 25f8ac9c-3c58-44a8-a4fc-3182544594e5 | SUSE 
Linux Enterprise Server 12 SP4 (64-bit)  | 2023-08-18 07:59:44 | NULL    |      
         0 |       1 | SUSE Linux Enterprise Server 12 SP4 (64-bit)  |     2 |
   | 334 |           9 | NULL | 366dc6ea-db79-4b5f-a9a0-1086aa359ac0 | NeoKylin 
Linux Server 7                       | 2023-08-18 07:59:44 | NULL    |          
     0 |       1 | NeoKylin Linux Server 7                       |     2 |
   | 336 |           7 | NULL | b513396d-37df-4374-a775-e78918f8789e | macOS 
10.15 (64 bit)                          | 2023-08-18 07:59:44 | NULL    |       
        0 |       1 | macOS 10.15 (64 bit)                          |     2 |
   | 337 |           2 | NULL | 36bc3d0e-5e83-4774-9089-bbf5d4d60056 | Debian 
GNU/Linux 11 (64-bit)                  | 2023-08-18 07:59:44 | NULL    |        
       0 |       1 | Debian GNU/Linux 11 (64-bit)                  |     2 |
   | 340 |           7 | NULL | af0c0f2f-fc62-4f42-aa86-9a9cdac14756 | Asianux 
Server 9 (64 bit)                     | 2023-08-18 07:59:44 | NULL    |         
      0 |       1 | Asianux Server 9 (64 bit)                     |     2 |
   | 341 |           1 | NULL | 88de984a-677e-48a3-9bdb-42f541cc7c0d | CentOS 9 
                                     | 2023-08-18 07:59:44 | NULL    |          
     0 |       1 | CentOS 9                                      |     2 |
   | 343 |           9 | NULL | 200d1ad2-9e5f-4ee2-a3ee-88b790377700 | FreeBSD 
13 (64-bit)                           | 2023-08-18 07:59:44 | NULL    |         
      0 |       1 | FreeBSD 13 (64-bit)                           |     2 |
   | 347 |           2 | NULL | edf33a5a-b36c-4863-a3d9-68770c4e5ac0 | Linux 
5.x Kernel (32-bit)                     | 2023-08-18 07:59:44 | NULL    |       
        0 |       1 | Linux 5.x Kernel (32-bit)                     |     2 |
   | 349 |           5 | NULL | 3f128ad6-1aec-4f82-9e11-f8ad23ce7c11 | SUSE 
Linux Enterprise Server 16 (64-bit)      | 2023-08-18 07:59:44 | NULL    |      
         0 |       1 | SUSE Linux Enterprise Server 16 (64-bit)      |     2 |
   | 356 |           1 | NULL | 05a19dc1-3ff8-11ee-af47-1e001e00011f | Oracle 
Linux 9                                | 2023-08-21 07:54:57 | NULL    |        
       0 |       1 | Oracle Linux 9                                |     3 |
   | 359 |           5 | NULL | 75a4607f-7491-4a3a-8b6c-e21794e5927b | SUSE 
Linux Enterprise Desktop 12 SP3 (64-bit) | 2023-08-21 07:54:58 | NULL    |      
         0 |       1 | SUSE Linux Enterprise Desktop 12 SP3 (64-bit) |     2 |
   | 362 |           9 | NULL | fe13d4de-d9dd-4b2c-8be4-937a94a5da64 | 
Scientific Linux 7                            | 2023-08-21 07:54:59 | NULL    | 
              0 |       1 | Scientific Linux 7                            |     
2 |
   | 364 |          10 | NULL | 6c757299-eb8c-42b5-b51b-cd74f8d1cfc2 | Ubuntu 
20.04 LTS                              | 2023-08-21 07:54:59 | NULL    |        
       0 |       1 | Ubuntu 20.04 LTS                              |     2 |
   | 367 |           2 | NULL | 42429e68-bad2-44dc-9b78-207161bcb538 | Debian 
GNU/Linux 11 (32-bit)                  | 2023-08-21 07:54:59 | NULL    |        
       0 |       1 | Debian GNU/Linux 11 (32-bit)                  |     2 |
   | 368 |           7 | NULL | 03947e9b-f56d-48b8-a0e8-634cc267d391 | Amazon 
Linux 3 (64 bit)                       | 2023-08-21 07:54:59 | NULL    |        
       0 |       1 | Amazon Linux 3 (64 bit)                       |     2 |
   | 371 |           7 | NULL | 9d30f036-d023-471b-886a-e3b01fc261a3 | macOS 11 
(64 bit)                             | 2023-08-21 07:54:59 | NULL    |          
     0 |       1 | macOS 11 (64 bit)                             |     2 |
   | 373 |           9 | NULL | dd4c2b9e-894a-4932-9ffc-b1ec749e3e41 | FreeBSD 
13 (32-bit)                           | 2023-08-21 07:54:59 | NULL    |         
      0 |       1 | FreeBSD 13 (32-bit)                           |     2 |
   | 375 |           2 | NULL | 09653b9e-f6fa-4658-8330-cc870f61b245 | Linux 
5.x Kernel (64-bit)                     | 2023-08-21 07:54:59 | NULL    |       
        0 |       1 | Linux 5.x Kernel (64-bit)                     |     2 |
   | 377 |           4 | NULL | c5c314e4-5da2-4b72-927f-21fb35c8276a | Red Hat 
Enterprise Linux 9.0                  | 2023-08-21 07:54:59 | NULL    |         
      0 |       1 | Red Hat Enterprise Linux 9.0                  |     2 |
   | 380 |           2 | NULL | 9c7b9808-e673-4303-a5a0-473aac98739b | Linux 
3.x Kernel (64 bit)                     | 2023-08-21 07:54:59 | NULL    |       
        0 |       1 | Linux 3.x Kernel (64 bit)                     |     2 |
   | 383 |           7 | NULL | 6ce50259-0ac3-412d-a8ec-ecc869c40f9e | Asianux 
Server 4 (32 bit)                     | 2023-08-21 07:54:59 | NULL    |         
      0 |       1 | Asianux Server 4 (32 bit)                     |     2 |
   | 386 |           7 | NULL | fee0669e-b2b6-4f89-acda-727405809c95 | Asianux 
Server 5 (64 bit)                     | 2023-08-21 07:54:59 | NULL    |         
      0 |       1 | Asianux Server 5 (64 bit)                     |     2 |
   | 389 |           7 | NULL | c38bb854-bc4e-489f-909f-4816d7a6da95 | Asianux 
Server 8 (64 bit)                     | 2023-08-21 07:54:59 | NULL    |         
      0 |       1 | Asianux Server 8 (64 bit)                     |     2 |
   | 391 |           7 | NULL | 22bf5465-5341-4dde-91d0-f65204e02af4 | macOS 
10.13 (64 bit)                          | 2023-08-21 07:54:59 | NULL    |       
        0 |       1 | macOS 10.13 (64 bit)                          |     2 |
   | 393 |           7 | NULL | 347a1787-35e8-483c-af45-ae72ab7c8a6b | Fedora 
Linux (64 bit)                         | 2023-08-21 07:54:59 | NULL    |        
       0 |       1 | Fedora Linux (64 bit)                         |     2 |
   | 395 |           7 | NULL | 7a08d54d-1bf2-43a8-aa2d-24da3b2ae8bf | Mandrake 
Linux                                | 2023-08-21 07:54:59 | NULL    |          
     0 |       1 | Mandrake Linux                                |     2 |
   | 402 |           7 | NULL | 8c05e3e9-1226-487f-9c0c-5bcfbaaa1dce | Solaris 
11 (64 bit)                           | 2023-08-21 07:54:59 | NULL    |         
      0 |       1 | Solaris 11 (64 bit)                           |     2 |
   | 403 |           7 | NULL | 445ed80a-2eb3-46ad-9fb2-474aa45495d5 | VMware 
Photon (64 bit)                        | 2023-08-21 07:54:59 | NULL    |        
       0 |       1 | VMware Photon (64 bit)                        |     2 |
   
+-----+-------------+------+--------------------------------------+-----------------------------------------------+---------------------+---------+-----------------+---------+-----------------------------------------------+-------+
   43 rows in set (0.00 sec)
   
   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 |
   
+-----+-------------+------+--------------------------------------+------------------------------+---------------------+---------+-----------------+---------+
   | 348 |           4 | NULL | 9458424f-0b9a-4abe-8119-b91b7c705fb1 | Red Hat 
Enterprise Linux 9.0 | 2023-08-18 07:59:44 | NULL    |               0 |       
0 |
   | 357 |           1 | NULL | 05a1e5a6-3ff8-11ee-af47-1e001e00011f | Red Hat 
Enterprise Linux 9   | 2023-08-21 07:54:57 | NULL    |               0 |       
0 |
   | 377 |           4 | NULL | c5c314e4-5da2-4b72-927f-21fb35c8276a | Red Hat 
Enterprise Linux 9.0 | 2023-08-21 07:54:59 | NULL    |               0 |       
1 |
   
+-----+-------------+------+--------------------------------------+------------------------------+---------------------+---------+-----------------+---------+
   3 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 |
   
+------+-----------------+----------------------------+-------------+--------------------+--------------------------------------+---------------------+---------+-----------------+
   | 8590 | KVM             | Red Hat Enterprise Linux 9 |         357 | 
default            | 05a1ee87-3ff8-11ee-af47-1e001e00011f | 2023-08-21 07:54:57 
| NULL    |               0 |
   | 8594 | VMware          | rhel9_64Guest              |         357 | 7.0    
            | 05a2529a-3ff8-11ee-af47-1e001e00011f | 2023-08-21 07:54:57 | NULL 
   |               0 |
   | 8598 | VMware          | rhel9_64Guest              |         357 | 
7.0.1.0            | 05a2f226-3ff8-11ee-af47-1e001e00011f | 2023-08-21 07:54:57 
| NULL    |               0 |
   | 8602 | VMware          | rhel9_64Guest              |         357 | 
7.0.2.0            | 05a372e3-3ff8-11ee-af47-1e001e00011f | 2023-08-21 07:54:57 
| NULL    |               0 |
   | 8606 | VMware          | rhel9_64Guest              |         357 | 
7.0.3.0            | 05a4299c-3ff8-11ee-af47-1e001e00011f | 2023-08-21 07:54:57 
| NULL    |               0 |
   | 8834 | VMware          | rhel9_64Guest              |         357 | 8.0    
            | 05a53053-3ff8-11ee-af47-1e001e00011f | 2023-08-21 07:54:57 | NULL 
   |               0 |
   | 9089 | VMware          | rhel9_64Guest              |         357 | 
8.0.0.1            | 05a64903-3ff8-11ee-af47-1e001e00011f | 2023-08-21 07:54:57 
| NULL    |               0 |
   | 9638 | VMware          | rhel9_64Guest              |         357 | 8.0.1  
            | 6db6c79e-43e5-4d82-b412-2b9ecd3fea2d | 2023-08-21 08:04:58 | 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 |
   
+------+-----------------+----------------------------+-------------+--------------------+--------------------------------------+---------------------+---------+-----------------+
   | 9776 | KVM             | Red Hat Enterprise Linux 9 |         348 | 
default            | b62fd70c-019c-445c-865b-40c17895501b | 2023-08-21 08:04:59 
| NULL    |               0 |
   | 9777 | VMware          | rhel9_64Guest              |         348 | 7.0    
            | 636e53e6-66a3-4568-ac95-1ae2ce364841 | 2023-08-21 08:04:59 | NULL 
   |               0 |
   | 9778 | VMware          | rhel9_64Guest              |         348 | 
7.0.1.0            | 9cf341ca-063e-40c3-ad47-92f044642c78 | 2023-08-21 08:04:59 
| NULL    |               0 |
   | 9779 | VMware          | rhel9_64Guest              |         348 | 
7.0.2.0            | 636ee96e-bda4-4dfe-9317-a308cf4b2131 | 2023-08-21 08:04:59 
| NULL    |               0 |
   | 9780 | VMware          | rhel9_64Guest              |         348 | 
7.0.3.0            | 48a54aa1-3662-4709-94da-350642c27d01 | 2023-08-21 08:04:59 
| NULL    |               0 |
   | 9781 | VMware          | rhel9_64Guest              |         348 | 8.0    
            | 731ad32f-df0c-43ba-8b7e-1b5d909219f8 | 2023-08-21 08:04:59 | NULL 
   |               0 |
   | 9782 | VMware          | rhel9_64Guest              |         348 | 
8.0.0.1            | ab30dfdd-908c-456b-bebc-0ab3a4364148 | 2023-08-21 08:04:59 
| NULL    |               0 |
   | 9783 | VMware          | rhel9_64Guest              |         348 | 8.0.1  
            | b4ddf210-11a9-49d1-afa1-4c2f3cb3987a | 2023-08-21 08:04:59 | NULL 
   |               0 |
   | 9144 | VMware          | rhel9_64Guest              |         377 | 
7.0.1.0            | a4b5f7f0-8a29-4cb7-9f98-457282d8d5da | 2023-08-21 07:54:59 
| NULL    |               0 |
   
+------+-----------------+----------------------------+-------------+--------------------+--------------------------------------+---------------------+---------+-----------------+
   9 rows in set (0.00 sec)
   
   MariaDB [cloud]> 
   MariaDB [cloud]> select * from guest_os_hypervisor where guest_os_id in 
(select id from guest_os where display_name like "Ubuntu 20.04 LTS" and 
display=1);
   
+------+-----------------+--------------------------+-------------+--------------------+--------------------------------------+---------------------+---------+-----------------+
   | id   | hypervisor_type | guest_os_name            | guest_os_id | 
hypervisor_version | uuid                                 | created             
| removed | is_user_defined |
   
+------+-----------------+--------------------------+-------------+--------------------+--------------------------------------+---------------------+---------+-----------------+
   | 9129 | Xenserver       | Ubuntu Focal Fossa 20.04 |         364 | 8.2.0    
          | a5e42d13-290e-47d3-8325-4cb8cf08d335 | 2023-08-21 07:54:59 | NULL   
 |               0 |
   | 9381 | VMware          | ubuntu64Guest            |         364 | 6.5      
          | 79944b11-0a6f-4f94-91d1-6fd5a476fd8a | 2023-08-21 08:04:57 | NULL   
 |               0 |
   | 9382 | VMware          | ubuntu64Guest            |         364 | 6.7      
          | 8a08b735-850d-4a03-b328-1cdbedca5579 | 2023-08-21 08:04:57 | NULL   
 |               0 |
   | 9383 | VMware          | ubuntu64Guest            |         364 | 6.7.1    
          | 021af9c9-3315-4ded-a480-3f868b7a30b3 | 2023-08-21 08:04:57 | NULL   
 |               0 |
   | 9384 | VMware          | ubuntu64Guest            |         364 | 6.7.2    
          | 389b791b-9203-4ae7-838a-664ebe96686f | 2023-08-21 08:04:57 | NULL   
 |               0 |
   | 9385 | VMware          | ubuntu64Guest            |         364 | 6.7.3    
          | cb5cf938-4db6-4ec6-9ca4-90ba551fce43 | 2023-08-21 08:04:57 | NULL   
 |               0 |
   | 9386 | VMware          | ubuntu64Guest            |         364 | 7.0      
          | 858d1865-012b-4c69-afad-dbce831a6b38 | 2023-08-21 08:04:57 | NULL   
 |               0 |
   | 9387 | VMware          | ubuntu64Guest            |         364 | 7.0.1.0  
          | 008f4bb7-eb8c-460e-a36d-f647b6ed7eb9 | 2023-08-21 08:04:57 | NULL   
 |               0 |
   | 9388 | VMware          | ubuntu64Guest            |         364 | 7.0.2.0  
          | 8865f272-19aa-4f15-b493-26a501e1d497 | 2023-08-21 08:04:57 | NULL   
 |               0 |
   | 9389 | VMware          | ubuntu64Guest            |         364 | 7.0.3.0  
          | 42b1b50a-1d28-4a10-b59d-34ac2decd4f4 | 2023-08-21 08:04:57 | NULL   
 |               0 |
   | 9390 | VMware          | ubuntu64Guest            |         364 | 8.0      
          | d6d3f917-793f-464d-8540-04737a2940fe | 2023-08-21 08:04:57 | NULL   
 |               0 |
   | 9641 | VMware          | ubuntu64Guest            |         364 | 8.0.1    
          | 26f3a929-00c0-42b7-8c7d-f8bd14ef14f7 | 2023-08-21 08:04:58 | NULL   
 |               0 |
   | 9742 | KVM             | Ubuntu 20.04 LTS         |         364 | default  
          | aa0aaf44-c676-4701-8d28-36c6ea187d3e | 2023-08-21 08:04:59 | NULL   
 |               0 |
   
+------+-----------------+--------------------------+-------------+--------------------+--------------------------------------+---------------------+---------+-----------------+
   13 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]

Reply via email to