[Tickets #10346] Re: Syntax error in Horde_ActiveSync_State_History->listDevices()

[bugs at horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/10346
------------------------------------------------------------------------------
  Ticket             | 10346
  Updated By         | botner at univention.de
  Summary            | Syntax error in
                     | Horde_ActiveSync_State_History->listDevices()
  Queue              | Horde Framework Packages
  Version            | Git master
  Type               | Bug
  State              | Feedback
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             | Michael Rubinsky
------------------------------------------------------------------------------


botner at univention.de (2011-07-19 14:11) wrote:

> What RDBMS is this?  I'm guessing it doesn't like aliasing the  
> d.device_id column name with the same name as the column (device_id)?

The rdbms is PostgreSQL.

It seems there is a comma missing and the column reference "device_id"  
is ambiguous, something like this works:

- SELECT d.device_id device_id, device_type, device_agent,  
device_policykey,  ...
+ SELECT d.device_id, u.device_id, device_type, device_agent,  
device_policykey,  ...