[Tickets #6751] Re: Issue with bitwise comparisons in native SQL share drivers (with postgres db-backend)

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/6751
-----------------------------------------------------------------------
 Ticket             | 6751
 Updated By         | josef at netzagentur.at
 Summary            | Issue with bitwise comparisons in native SQL share
drivers (with
                    | postgres db-backend)
 Queue              | Horde Framework Packages
 Version            | HEAD
 Type               | Bug
 State              | Feedback
 Priority           | 2. Medium
 Milestone          | Horde 3.2
 Patch              |
 Owners             | Michael Rubinsky
-----------------------------------------------------------------------


josef at netzagentur.at (2008-05-24 13:27) wrote:

For documentation:
the error was:

horde=> SELECT s.*  FROM ansel_shares s  LEFT JOIN ansel_shares_users AS u
ON u.share_id = s.share_id LEFT JOIN ansel_shares_groups AS g ON g.share_id
= s.share_id WHERE s.share_owner = 'josef at netzagentur' OR s.perm_creator &
8 OR s.perm_default & 8 OR ( u.user_uid = 'josef at netzagentur' AND u.perm &
8) OR ( g.group_uid IN
("cn=www-data at netzagentur.at,dc=netzagentur","cn=edvteam at netzagentur,dc=netzagentur")
AND g.perm & 8) ORDER BY s.share_name DESC;

FEHLER:  Argument von OR muss Typ boolean haben, nicht Typ integer
horde=>