[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         | c-master at freenet.de
  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             |
------------------------------------------------------------------------------


c-master at freenet.de (2009-09-30 14:11) wrote:

I guess Sybase has some kind of problem with this part of the sql-statement:
"... AND a1.attribute_key IN ('1', '2') AND (a1.attribute_value & 8) =  
8)  AND a2.attribute_name = 'name' ...".
Because attribute_value is varchar(255) and not an integer sybase  
seems not to refer to the actual VALUE of attribute_value but instead  
to the TYPE of attribute_value. Maybe it needs some explicit  
conversation at this time.
OR (my 2nd guess)
The mapping between attribute_name and attribute_value somehow fails  
and horde (or sybase?) just takes a wrong value from attribute_value.