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

* Your Email Address
* Spam protection	Enter the letters below: .___. ..__ \ /.__ [__ \|__\|\| \ >< [ __ \| \| \|\|__// \[_./
Comment	> Half success! > > First problem is solved, but there's another (same) one. > > This statement now works: > > SELECT c.datatree_id, c.datatree_name FROM horde_datatree c LEFT JOIN > horde_datatree_attributes a1 ON a1.datatree_id = c.datatree_id LEFT > JOIN horde_datatree_attributes a2 ON a2.datatree_id = c.datatree_id > WHERE c.group_uid = 'horde.shares.kronolith' AND (a1.attribute_name = > 'perm_groups' AND a1.attribute_key IN ('1', '2') AND > (a1.attribute_value & 2) = 2) AND a2.attribute_name = 'name' GROUP > BY c.datatree_id, c.datatree_name, c.datatree_order, > a2.attribute_value ORDER BY a2.attribute_value ASC > > > > ...after I changed the following values (Sybase Database Options): > > Blocking = Off > > Optimization_Goal = First-Row > > Optimization_Level = 0 > > Optimization_Logging = On > > Prefetch = Off > > > > Now the same problem on a even more complex statement. (It can be > found in the already attached file horde.log) Error code again -157. > Message 'conversion from "Kalender von root" to unsigned bigint not > possible'. > > > > SELECT c.datatree_id, c.datatree_name FROM horde_datatree c > > LEFT JOIN horde_datatree_attributes a1 ON a1.datatree_id = c.datatree_id > > LEFT JOIN horde_datatree_attributes a2 ON a2.datatree_id = c.datatree_id > > LEFT JOIN horde_datatree_attributes a3 ON a3.datatree_id = c.datatree_id > > WHERE c.group_uid = 'horde.shares.kronolith' AND > > ( > > ( > > > > (a1.attribute_name = 'owner' AND a1.attribute_value = 'root') OR > > > > (a1.attribute_name = 'perm_users' AND a1.attribute_key = 'root' > AND (a1.attribute_value & 2) = 2) OR > > (a1.attribute_name = 'perm_creator' AND (a1.attribute_value & 2) = 2) OR > > (a1.attribute_name = 'perm_default' AND (a1.attribute_value & 2) = 2) OR > > (a1.attribute_name = 'perm_groups' AND a1.attribute_key IN ('1', > '2') AND (a1.attribute_value & 2) = 2) > > ) AND a2.attribute_name = 'owner' AND a2.attribute_value = 'root') > > AND a1.datatree_id = a2.datatree_id AND a3.attribute_name = 'name' > > > > GROUP BY c.datatree_id, c.datatree_name, c.datatree_order, > a3.attribute_value ORDER BY a3.attribute_value ASC > > > > ------- > > But when I remove the line > > (a1.attribute_name = 'owner' AND a1.attribute_value = 'root') OR > > it runs perfectly!
Attachment
Watch this ticket

Saved Queries