cloudstack-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sate...@apache.org
Subject git commit: updated refs/heads/4.2-forward to c059dac
Date Tue, 27 Aug 2013 08:02:40 GMT
Updated Branches:
  refs/heads/4.2-forward d0ad80530 -> c059dacfc


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

Signed-off-by: Sateesh Chodapuneedi <sateesh@apache.org>


Project: http://git-wip-us.apache.org/repos/asf/cloudstack/repo
Commit: http://git-wip-us.apache.org/repos/asf/cloudstack/commit/c059dacf
Tree: http://git-wip-us.apache.org/repos/asf/cloudstack/tree/c059dacf
Diff: http://git-wip-us.apache.org/repos/asf/cloudstack/diff/c059dacf

Branch: refs/heads/4.2-forward
Commit: c059dacfc49b0757e4cd78498fef0d424a462c54
Parents: d0ad805
Author: Anshul Gangwar <anshul.gangwar@citrix.com>
Authored: Mon Aug 26 13:27:56 2013 +0530
Committer: Sateesh Chodapuneedi <sateesh@apache.org>
Committed: Tue Aug 27 08:01:44 2013 +0530

----------------------------------------------------------------------
 setup/db/db/schema-307to410.sql | 2 +-
 setup/db/db/schema-40to410.sql  | 2 +-
 setup/db/db/schema-410to420.sql | 2 +-
 3 files changed, 3 insertions(+), 3 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/cloudstack/blob/c059dacf/setup/db/db/schema-307to410.sql
----------------------------------------------------------------------
diff --git a/setup/db/db/schema-307to410.sql b/setup/db/db/schema-307to410.sql
index 70cddfd..7feb53e 100644
--- 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)

http://git-wip-us.apache.org/repos/asf/cloudstack/blob/c059dacf/setup/db/db/schema-40to410.sql
----------------------------------------------------------------------
diff --git a/setup/db/db/schema-40to410.sql b/setup/db/db/schema-40to410.sql
index f1482f8..24f6d4c 100644
--- 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)

http://git-wip-us.apache.org/repos/asf/cloudstack/blob/c059dacf/setup/db/db/schema-410to420.sql
----------------------------------------------------------------------
diff --git a/setup/db/db/schema-410to420.sql b/setup/db/db/schema-410to420.sql
index c29fd86..4d68838 100644
--- a/setup/db/db/schema-410to420.sql
+++ b/setup/db/db/schema-410to420.sql
@@ -992,7 +992,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)


Mime
View raw message