Eli Mesika has submitted this change and it was merged. Change subject: core: show data once on ISO shared from multi DCs ...................................................................... core: show data once on ISO shared from multi DCs When the same ISO is shared to multiple DCs, this SP will return duplicate rows (as the number of DCs having this ISO) This is fixed by adding a DISTINCT ON (id) * to the select statement in this SP, this will eliminate the results to the 1st matching record. Change-Id: I7c9a1381aae2eb623d1743314a1fb6ef7795dcb6 Bug-Url : https://bugzilla.redhat.com/show_bug.cgi?id=1295742 Signed-off-by: emesika <emesika@redhat.com> --- M packaging/dbscripts/storages_sp.sql 1 file changed, 1 insertion(+), 1 deletion(-) Approvals: Eli Mesika: Verified; Passed CI tests Allon Mureinik: Looks good to me, approved Oved Ourfali: Looks good to me, but someone else must approve -- To view, visit https://gerrit.ovirt.org/51438 To unsubscribe, visit https://gerrit.ovirt.org/settings Gerrit-MessageType: merged Gerrit-Change-Id: I7c9a1381aae2eb623d1743314a1fb6ef7795dcb6 Gerrit-PatchSet: 3 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Eli Mesika <emesika@redhat.com> Gerrit-Reviewer: Allon Mureinik <amureini@redhat.com> Gerrit-Reviewer: Eli Mesika <emesika@redhat.com> Gerrit-Reviewer: Jenkins CI Gerrit-Reviewer: Maor Lipchuk <mlipchuk@redhat.com> Gerrit-Reviewer: Martin Peřina <mperina@redhat.com> Gerrit-Reviewer: Moti Asayag <masayag@redhat.com> Gerrit-Reviewer: Oved Ourfali <oourfali@redhat.com> Gerrit-Reviewer: Tal Nisan <tnisan@redhat.com> Gerrit-Reviewer: gerrit-hooks <automation@ovirt.org>