[Tickets #1439] DataTree sql is not Oracle compatible

[bugs at bugs.horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/?id=1439
-----------------------------------------------------------------------
 Ticket             | 1439
 Updated By         | selsky at columbia.edu
 Summary            | DataTree sql is not Oracle compatible
 Queue              | Horde Base
 Version            | 3.0.3
 State              | Feedback
 Priority           | 2. Medium
 Type               | Bug
 Owners             | Horde Developers
-----------------------------------------------------------------------


selsky at columbia.edu (2005-03-04 18:08) wrote:

I'm getting a little lost in the code trying to do this without messing up
other stuff.  For example, when buildClause() does something like this:

return sprintf('bitand(%s,%d) = %d', $lhs, (int)$rhs, (int)$rhs);

What is the right way to parameterize that?

return sprintf('bitand(%s,?) = ?', $lhs);

How will the caller know that it needs to pass that parameter twice? 

Would it be easier to just add to_clob() around the values (for oracle only)
to convert the strings to CLOBs?