Shubhendu Tripathi has posted comments on this change. Change subject: gluster: Added app_mode field to roles table ......................................................................
Patch Set 6: (2 comments) .................................................... File packaging/dbscripts/multi_level_administration_sp.sql Line 250: AS $procedure$ Line 251: BEGIN Line 252: RETURN QUERY SELECT * Line 253: FROM roles Line 254: WHERE roles.app_mode & v_app_mode > 0; Replacing & with AND does not work as here I need a binary "and" for two integer fields and this is not the LOGICAL AND of two conditional expressions. Line 255: Line 256: END; $procedure$ Line 257: LANGUAGE plpgsql; Line 258: Line 293: BEGIN Line 294: RETURN QUERY SELECT roles.* Line 295: FROM roles INNER JOIN Line 296: permissions ON permissions.role_id = roles.id Line 297: WHERE roles.app_mode & v_app_mode > 0 Replacing & with AND does not work as here I need a binary "and" for two integer fields and this is not the LOGICAL AND of two conditional expressions. Line 298: AND (permissions.ad_element_id = v_user_id Line 299: or permissions.ad_element_id in(select id from getElementIdsByIdAndGroups(v_user_id, v_group_ids))); Line 300: Line 301: END; $procedure$ -- To view, visit http://gerrit.ovirt.org/18592 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: comment Gerrit-Change-Id: Id83b7a2c90100744487b276642158e7c3e93de85 Gerrit-PatchSet: 6 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Shubhendu Tripathi <shtri...@redhat.com> Gerrit-Reviewer: Eli Mesika <emes...@redhat.com> Gerrit-Reviewer: Kanagaraj M <kmayi...@redhat.com> Gerrit-Reviewer: Sahina Bose <sab...@redhat.com> Gerrit-Reviewer: Shubhendu Tripathi <shtri...@redhat.com> Gerrit-Reviewer: Yair Zaslavsky <yzasl...@redhat.com> Gerrit-Reviewer: oVirt Jenkins CI Server Gerrit-HasComments: Yes _______________________________________________ Engine-patches mailing list Engine-patches@ovirt.org http://lists.ovirt.org/mailman/listinfo/engine-patches
