Updated Branches: refs/heads/master fe6e0390f -> bdbdfd401
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 <[email protected]> Project: http://git-wip-us.apache.org/repos/asf/cloudstack/repo Commit: http://git-wip-us.apache.org/repos/asf/cloudstack/commit/bdbdfd40 Tree: http://git-wip-us.apache.org/repos/asf/cloudstack/tree/bdbdfd40 Diff: http://git-wip-us.apache.org/repos/asf/cloudstack/diff/bdbdfd40 Branch: refs/heads/master Commit: bdbdfd401b0fcd40244e6aedf2ae853853e75e1a Parents: fe6e039 Author: Anshul Gangwar <[email protected]> Authored: Mon Aug 26 13:27:56 2013 +0530 Committer: Sateesh Chodapuneedi <[email protected]> Committed: Tue Aug 27 06:17:47 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/bdbdfd40/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/bdbdfd40/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/bdbdfd40/setup/db/db/schema-410to420.sql ---------------------------------------------------------------------- diff --git a/setup/db/db/schema-410to420.sql b/setup/db/db/schema-410to420.sql index ec4d472..f51b53c 100644 --- 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)
