summaryrefslogtreecommitdiffstats
path: root/lib/public/share.php
diff options
context:
space:
mode:
Diffstat (limited to 'lib/public/share.php')
-rw-r--r--lib/public/share.php10
1 files changed, 7 insertions, 3 deletions
diff --git a/lib/public/share.php b/lib/public/share.php
index 122ab3fa030..f40cd0d77fa 100644
--- a/lib/public/share.php
+++ b/lib/public/share.php
@@ -662,9 +662,13 @@ class Share {
// Remove the permissions for all reshares of this item
if (!empty($ids)) {
$ids = "'".implode("','", $ids)."'";
- $query = \OC_DB::prepare('UPDATE `*PREFIX*share` SET `permissions` = `permissions` & ?'
- .' WHERE `id` IN ('.$ids.')');
- $query->execute(array($permissions));
+ // the binary operator & works on sqlite, mysql, postgresql and mssql
+ $sql = 'UPDATE `*PREFIX*share` SET `permissions` = `permissions` & ? WHERE `id` IN ('.$ids.')';
+ if (\OC_Config::getValue('dbtype', 'sqlite') === 'oci') {
+ // guess which dbms does not handle & and uses a function for this
+ $sql = 'UPDATE `*PREFIX*share` SET `permissions` = BITAND(`permissions`,?) WHERE `id` IN ('.$ids.')';
+ }
+ \OC_DB::executeAudited($sql, array($permissions));
}
}
}