[Tickets #7363] Re: Avoid bitwise operations in the SQL Share driver

[bugs at horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/7363
------------------------------------------------------------------------------
  Ticket             | 7363
  Updated By         | Michael Rubinsky <mrubinsk at horde.org>
  Summary            | Avoid bitwise operations in the SQL Share driver
  Queue              | Horde Framework Packages
  Version            | FRAMEWORK_3
  Type               | Enhancement
  State              | Accepted
  Priority           | 2. Medium
  Milestone          |
  Patch              |
  Owners             | Horde Developers, Chuck Hagenbuch
------------------------------------------------------------------------------


Michael Rubinsky <mrubinsk at horde.org> (2008-10-06 09:46) wrote:

The DISTINCT was/is necessary to avoid counting the same share more  
than once when the share has more than one entry in either the *_users  
or *_groups table. Otherwise, we get erroneous share counts.

Not ideal, but necessary with the current implementation. I agree  
things need to be reorganized after seeing the results of those  
EXPLAIN statements.