| Summary | Issue with bitwise comparisons in native SQL share drivers (with postgres db-backend) |
| Queue | Horde Framework Packages |
| Queue Version | HEAD |
| Type | Bug |
| State | Resolved |
| Priority | 2. Medium |
| Owners | mrubinsk (at) horde (dot) org |
| Requester | josef (at) netzagentur (dot) at |
| Created | 05/24/2008 (6249 days ago) |
| Due | |
| Updated | 05/24/2008 (6249 days ago) |
| Assigned | 05/24/2008 (6249 days ago) |
| Resolved | 05/24/2008 (6249 days ago) |
| Github Issue Link | |
| Github Pull Request | |
| Milestone | Horde 3.2 |
| Patch | No |
State ⇒ Resolved
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@netzagentur' OR
s.perm_creator & 8 OR s.perm_default & 8 OR ( u.user_uid =
'josef@netzagentur' AND u.perm & 8) OR ( g.group_uid IN
("cn=www-data@netzagentur.at,dc=netzagentur","cn=edvteam@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=>
$where .= 'OR (s.perm_creator & ' . $perm . ') <> 0';
for all the boolean comparisons?
since this seems to be ANSI-SQL.
Summary ⇒ Issue with bitwise comparisons in native SQL share drivers (with postgres db-backend)
State ⇒ Feedback
$where .= 'OR (s.perm_creator & ' . $perm . ') <> 0';
for all the boolean comparisons?
Assigned to
Milestone ⇒ Horde 3.2
Summary ⇒ Issue with boolean comparisons in native SQL share drivers (with postgres db-backend)
should really be resolved before 3.2 release.
Version ⇒ HEAD
Queue ⇒ Horde Framework Packages
an issue specific to Ansel, but to the hierarchical (and possibly the
native sql driver as well).
State ⇒ Assigned
Priority ⇒ 2. Medium
Assigned to Michael Rubinsky
if any other devs can chime in here, I'd appreciate it.
Priority ⇒ 3. High
State ⇒ Unconfirmed
Patch ⇒ No
Milestone ⇒
Queue ⇒ Ansel
Summary ⇒ Gallery list doesn't work (with postgres db-backend)
Type ⇒ Bug
/usr/share/php/Horde/sql_hierarchical.php (framework)
in the function _getShareCriteria
when I put explicit CAST-Conversion in there,
the problem seems to be solved - for me, but maybe not for any other
DB-Backend:
$where .= ' OR s.perm_creator & ' . $perm;
$where .= ' OR (s.perm_creator & ' . $perm . ')::boolean';
there are some further boolean comparisons, which I modified - and so
ANSEL does it's job again.