Tickets :: Comment on [#7084] SQL portability, column does not exist

* Your Email Address
* Spam protection	Enter the letters below: . __.. ..__ \| (__ \| \|[__) \|___.__)\|___\__\|\| \
Comment	> 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 > > -------------
Attachment
Watch this ticket