[Tickets #8608] Re: Wrong datatype "?" to "unsigned bigint" in datatree. \lib\Horde\DataTree\sql.php

[bugs at horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/8608
------------------------------------------------------------------------------
  Ticket             | 8608
  Updated By         | Jan Schneider <jan at horde.org>
  Summary            | Wrong datatype "?" to "unsigned bigint" in datatree.
                     | \lib\Horde\DataTree\sql.php
  Queue              | Horde Framework Packages
  Version            | FRAMEWORK_3
  Type               | Bug
  State              | Feedback
  Priority           | 2. Medium
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


Jan Schneider <jan at horde.org> (2009-10-01 05:45) wrote:

It sounds to me as if Sybase is doing some bad query optimization.  
 From the error message it looks like it is doing the  
(a1.attribute_value & 2) = 2 comparison on rows where attribute_value  
contains 'Kalender von root'. This is an expected value for rows that  
have attribute_name = 'name'. But we explicitly ask for attribute_name  
= 'perm_groups' in the query *first*. No idea, why it gets the order  
correct without the group_uid part. And I don't know how to tell  
Sybase to get its optimization correctly done either.