Moti Asayag has uploaded a new change for review.
Change subject: engine: Prevent fetching null labels
......................................................................
engine: Prevent fetching null labels
It make sense to fetch only the defined labels
in the data center.
Change-Id: Ib068f8a87848dfc9845733a535e05a25934082f6
Signed-off-by: Moti Asayag <masa...@redhat.com>
---
M packaging/dbscripts/network_sp.sql
1 file changed, 2 insertions(+), 1 deletion(-)
git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/75/22875/1
diff --git a/packaging/dbscripts/network_sp.sql
b/packaging/dbscripts/network_sp.sql
index b0d3d66..20a7e58 100644
--- a/packaging/dbscripts/network_sp.sql
+++ b/packaging/dbscripts/network_sp.sql
@@ -266,7 +266,8 @@
RETURN QUERY
SELECT DISTINCT label
FROM network
- WHERE network.storage_pool_id = v_id;
+ WHERE network.storage_pool_id = v_id
+ AND label IS NOT NULL;
END; $procedure$
LANGUAGE plpgsql;
--
To view, visit http://gerrit.ovirt.org/22875
To unsubscribe, visit http://gerrit.ovirt.org/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: Ib068f8a87848dfc9845733a535e05a25934082f6
Gerrit-PatchSet: 1
Gerrit-Project: ovirt-engine
Gerrit-Branch: master
Gerrit-Owner: Moti Asayag <masa...@redhat.com>
_______________________________________________
Engine-patches mailing list
Engine-patches@ovirt.org
http://lists.ovirt.org/mailman/listinfo/engine-patches
