db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mamta Satoor <msat...@gmail.com>
Subject Re: [jira] Commented: (DERBY-4402) Assert failure (sane) or Array out of bounds error (insane) when attempting to GROUP BY accumulator function
Date Mon, 10 May 2010 23:42:41 GMT
Dag, I just resolved this jira entry.

thanks,
Mamta

On Mon, May 10, 2010 at 4:29 PM, Dag H. Wanvik (JIRA) <jira@apache.org> wrote:
>
>    [ https://issues.apache.org/jira/browse/DERBY-4402?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12865976#action_12865976
]
>
> Dag H. Wanvik commented on DERBY-4402:
> --------------------------------------
>
> Can this be resolved?
>
>
>> Assert failure (sane) or Array out of bounds error (insane) when attempting to GROUP
BY accumulator function
>> ------------------------------------------------------------------------------------------------------------
>>
>>                 Key: DERBY-4402
>>                 URL: https://issues.apache.org/jira/browse/DERBY-4402
>>             Project: Derby
>>          Issue Type: Bug
>>          Components: SQL
>>    Affects Versions: 10.5.3.0, 10.6.1.0
>>            Reporter: Dag H. Wanvik
>>            Assignee: Mamta A. Satoor
>>            Priority: Minor
>>             Fix For: 10.5.3.1, 10.6.1.0
>>
>>
>> The error checking fails to catch this wrong usage (accumulator function inside a
group by column expression.
>> :
>> select sum(i) from t group by (4+sum(j))
>> :
>> java.sql.SQLException: Java exception: 'ASSERT FAILED Unexpected Aggregate vector
generated by Group By clause: org.apache.derby.shared.common.sanity.AssertFailure'.
>>       at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45)
>>       at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(SQLExceptionFactory40.java:119)
>>       at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:70)
>>       ... 16 more
>> Caused by: org.apache.derby.shared.common.sanity.AssertFailure: ASSERT FAILED Unexpected
Aggregate vector generated by Group By clause
>>       at org.apache.derby.shared.common.sanity.SanityManager.ASSERT(SanityManager.java:120)
>>       at org.apache.derby.impl.sql.compile.SelectNode.bindExpressions(SelectNode.java:648)
>>       at org.apache.derby.impl.sql.compile.DMLStatementNode.bindExpressions(DMLStatementNode.java:227)
>>       at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(DMLStatementNode.java:140)
>>       at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(CursorNode.java:249)
>>       at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java:319)
>>       at org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:88)
>>       at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConnectionContext.java:824)
>>       at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:606)
>>       ... 9 more
>> The parser has a check against the top node of a "groupingColumnReference" being
an aggregator, but fails to "see" inside an expression.
>> Maybe this check should be made by a visitor in the bind phase instead.
>
> --
> This message is automatically generated by JIRA.
> -
> You can reply to this email to add a comment to the issue online.
>
>

Mime
View raw message