Stack overflow when issuing SELECT statements with *lots* of 'OR' in the WHERE
clause
-------------------------------------------------------------------------------------
Key: DERBY-3876
URL: https://issues.apache.org/jira/browse/DERBY-3876
Project: Derby
Issue Type: Bug
Reporter: Øyvind Harboe
The problem is that e.g. Cayenne uses *long* SQL statements with *lots* of OR
statements to implement certain operations.
This causes a stack overflow as evaluation of 'OR' is implemented recursively.
Could an iterative implementation trivially replace the recursive
implementation?
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.BinaryLogicalOpera
See also
https://issues.apache.org/cayenne/browse/CAY-1079?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12974#action_12974
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
