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