[Tickets #9151] Re: Kronolith, Nag, Mnemo, Turba don't work with Oracle DB

[bugs at horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/9151
------------------------------------------------------------------------------
  Ticket             | 9151
  Updated By         | robert at databee.org
  Summary            | Kronolith, Nag, Mnemo, Turba don't work with Oracle DB
  Queue              | Horde Framework Packages
  Version            | FRAMEWORK_3
  Type               | Bug
  State              | Feedback
  Priority           | 2. Medium
  Milestone          |
  Patch              |
  Owners             | Jan Schneider
------------------------------------------------------------------------------


robert at databee.org (2010-07-27 18:05) wrote:

tried - worked. Thanks a lot.
Connections to the database are made and its doing inserts and updates.

BUT: Now I got lots of errors like this:

  [pid 8797 on line 470 of  
"/home/horde/horde-webmail-1.2.6/lib/Horde/Share/sql.php"]
Jul 27 23:47:49 HORDE [error] [mnemo] MDB2 Error: unknown error:  
_doQuery: [Error message: Could not execute statement]
[Last executed query: SELECT DISTINCT s.*  FROM mnemo_shares s  LEFT  
JOIN mnemo_shares_users AS u ON u.share_id = s.share_id WHERE  
s.share_owner = 'rmarz' OR (bitand(s.per
m_creator, 4) = 4) OR (bitand(s.perm_default, 4) = 4) OR ( u.user_uid  
= 'rmarz' AND (bitand(u.perm, 4) = 4)) ORDER BY s.attribute_name ASC]
[Native code: 905]
[Native message: ORA-00905: missing keyword]

which is caused by the "AS" between table-name and alias in the  
outer-joined table.
In this rare case, Oracle follows hard the sql99-Standard, which says,  
that "as" is allowed for column aliases and does not mention it for  
table-aliases.