Re: [jira] Created: (CAY-1079) Derby adapter uses recursive implementation for orExp()

[Marcin Skladaniec]

I saw that before: this happens when yo have too long query, plausibly the one like:

SELECT whatever FROM someTable where id in (long list 100+ items)



Marcin



On 23/06/2008, at 9:27 PM, Øyvind Harboe (JIRA) wrote:

how to get to this query when paging ? maybe setPageSize(1000), but I'm not sure.

Derby adapter uses recursive implementation for orExp()
-------------------------------------------------------

                Key: CAY-1079
                URL: https://issues.apache.org/cayenne/browse/CAY-1079
            Project: Cayenne
         Issue Type: Bug
         Components: Cayenne Core Library
   Affects Versions: 3.0
           Reporter: Øyvind Harboe
           Assignee: Andrus Adamchik


I get this exception w/paged queries.

I need to make a note of this bug and get back to it.




--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

at org.apache.derby.impl.sql.compile.OrNode.bindExpression(Unknown Source) at org .apache .derby.impl.sql.compile.BinaryOperatorNode.bindExpression(Unknown Source) at org .apache .derby .impl.sql.compile.BinaryLogicalOperatorNode.bindExpression(Unknown Source) at org.apache.derby.impl.sql.compile.OrNode.bindExpression(Unknown Source) at org .apache .derby.impl.sql.compile.BinaryOperatorNode.bindExpression(Unknown Source) at org .apache .derby .impl.sql.compile.BinaryLogicalOperatorNode.bindExpression(Unknown Source) at org.apache.derby.impl.sql.compile.OrNode.bindExpression(Unknown Source) at org .apache .derby.impl.sql.compile.BinaryOperatorNode.bindExpression(Unknown Source) at org .apache .derby .impl.sql.compile.BinaryLogicalOperatorNode.bindExpression(Unknown Source) at org.apache.derby.impl.sql.compile.OrNode.bindExpression(Unknown Source) at org .apache .derby.impl.sql.compile.BinaryOperatorNode.bindExpression(Unknown Source) at org .apache .derby .impl.sql.compile.BinaryLogicalOperatorNode.bindExpression(Unknown Source) at org.apache.derby.impl.sql.compile.OrNode.bindExpression(Unknown Source) at org .apache .derby.impl.sql.compile.BinaryOperatorNode.bindExpression(Unknown Source) at org .apache .derby .impl.sql.compile.BinaryLogicalOperatorNode.bindExpression(Unknown Source) at org.apache.derby.impl.sql.compile.OrNode.bindExpression(Unknown Source) at org .apache .derby.impl.sql.compile.BinaryOperatorNode.bindExpression(Unknown Source) at org .apache .derby .impl.sql.compile.BinaryLogicalOperatorNode.bindExpression(Unknown Source)

smime.p7s
Description: S/MIME cryptographic signature