[Tickets #7084] SQL portability, column does not exist - with shares.

[bugs at horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/7084
------------------------------------------------------------------------------
  Ticket             | 7084
  Created By         | barryp at medicine.nodak.edu
  Summary            | SQL portability, column does not exist - with shares.
  Queue              | Horde Framework Packages
  Version            | FRAMEWORK_3
  Type               | Bug
  State              | Unconfirmed
  Priority           | 2. Medium
  Milestone          |
  Patch              | 1
  Owners             |
+New Attachment     | horde.patch
------------------------------------------------------------------------------


barryp at medicine.nodak.edu (2008-07-19 14:00) wrote:

I'm getting this error with PostgreSQL 8.3.3, after I've added myself  
to a group.  I believe it's the same deal as with bug [#7075].  I've  
attached a patch to show where the problem is, not quite sure what the  
cool way to do quoting would be in this case.

----------
ERROR:  column "3" does not exist at character 311

STATEMENT:  SELECT s.*  FROM nag_shares s  LEFT JOIN nag_shares_users  
AS u ON u.share_id = s.share_id LEFT JOIN
nag_shares_groups AS g ON g.share_id = s.share_id WHERE s.share_owner  
= 'barryp' OR (s.perm_creator & 4) <> 0 OR
(s.perm_default & 4) <> 0 OR ( u.user_uid = 'barryp' AND (u.perm & 4)  
<> 0) OR ( g.group_uid IN ("3") AND (g.perm & 4) <> 0)
ORDER BY s.attribute_name ASC
-------------