plysan has uploaded a new change for review.

Change subject: history: No history data for unbounded host interfaces
......................................................................

history: No history data for unbounded host interfaces

The dwh_host_interface_configuration_history_view missed to include
host interfaces in vds_interface whose is_bound field is false.

Change-Id: I44fe7c0edbf1429f0bf513459cf9dff10f6f9395
Bug-Url: https://bugzilla.redhat.com/1069605
Signed-off-by: plysan <ply...@gmail.com>
---
M packaging/dbscripts/create_dwh_views.sql
1 file changed, 1 insertion(+), 0 deletions(-)


  git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/17/25017/1

diff --git a/packaging/dbscripts/create_dwh_views.sql 
b/packaging/dbscripts/create_dwh_views.sql
index 46ffdb3..afb681d 100644
--- a/packaging/dbscripts/create_dwh_views.sql
+++ b/packaging/dbscripts/create_dwh_views.sql
@@ -204,6 +204,7 @@
                             FROM          dwh_history_timekeeping AS 
history_timekeeping_1
                             WHERE      (var_name = 'lastSync')))) AND
                   (a.is_bond is null OR
+            a.is_bond is false OR
                   (a.is_bond = true and a.name in (SELECT b.bond_name
                                                                                
        FROM vds_interface AS b
                                                                                
        where b.is_bond is null and b.vds_id = a.vds_id)));


-- 
To view, visit http://gerrit.ovirt.org/25017
To unsubscribe, visit http://gerrit.ovirt.org/settings

Gerrit-MessageType: newchange
Gerrit-Change-Id: I44fe7c0edbf1429f0bf513459cf9dff10f6f9395
Gerrit-PatchSet: 1
Gerrit-Project: ovirt-engine
Gerrit-Branch: master
Gerrit-Owner: plysan <ply...@gmail.com>
_______________________________________________
Engine-patches mailing list
Engine-patches@ovirt.org
http://lists.ovirt.org/mailman/listinfo/engine-patches

Reply via email to