CLOUDSTACK-3806: There was error in host_view sql, it was using host_details.id for join instead host_details.host_id

anshulgangwar · Sateesh Chodapuneedi · commit bdbdfd401b0f · 2013-08-27T06:17:47.000+05:30
Signed-off-by: Sateesh Chodapuneedi &lt;sateesh@apache.org&gt;
diff --git a/setup/db/db/schema-307to410.sql b/setup/db/db/schema-307to410.sql
@@ -977,7 +977,7 @@ CREATE VIEW `cloud`.`host_view` AS
             left join
         `cloud`.`host_pod_ref` ON host.pod_id = host_pod_ref.id
             left join
-        `cloud`.`host_details` ON host.id = host_details.id
+        `cloud`.`host_details` ON host.id = host_details.host_id
             and host_details.name = 'guest.os.category.id'
             left join
         `cloud`.`guest_os_category` ON guest_os_category.id = CONVERT( host_details.value , UNSIGNED)
diff --git a/setup/db/db/schema-40to410.sql b/setup/db/db/schema-40to410.sql
@@ -1073,7 +1073,7 @@ CREATE VIEW `cloud`.`host_view` AS
             left join
         `cloud`.`host_pod_ref` ON host.pod_id = host_pod_ref.id
             left join
-        `cloud`.`host_details` ON host.id = host_details.id
+        `cloud`.`host_details` ON host.id = host_details.host_id
             and host_details.name = 'guest.os.category.id'
             left join
         `cloud`.`guest_os_category` ON guest_os_category.id = CONVERT( host_details.value , UNSIGNED)
diff --git a/setup/db/db/schema-410to420.sql b/setup/db/db/schema-410to420.sql
@@ -976,7 +976,7 @@ CREATE VIEW `cloud`.`host_view` AS
             left join
         `cloud`.`host_pod_ref` ON host.pod_id = host_pod_ref.id
             left join
-        `cloud`.`host_details` ON host.id = host_details.id
+        `cloud`.`host_details` ON host.id = host_details.host_id
             and host_details.name = 'guest.os.category.id'
             left join
         `cloud`.`guest_os_category` ON guest_os_category.id = CONVERT( host_details.value , UNSIGNED)
