db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dag H. Wanvik (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-4403) Assert failure (sane) or NullPointerException (insane) when attempting to GROUP BY expression containing scalar subquery
Date Fri, 09 Oct 2009 01:16:31 GMT
Assert failure (sane) or NullPointerException (insane) when attempting to GROUP BY expression
containing scalar subquery
------------------------------------------------------------------------------------------------------------------------

                 Key: DERBY-4403
                 URL: https://issues.apache.org/jira/browse/DERBY-4403
             Project: Derby
          Issue Type: Bug
          Components: SQL
            Reporter: Dag H. Wanvik


The following is not caught by the error checking:

select sum(i) from t group by j + (select j from t where i=1)

java.sql.SQLException: Java exception: 'ASSERT FAILED dummySubqueryList.size() is expected
to be 0: 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 dummySubqueryList.size()
is expected to be 0
	at org.apache.derby.shared.common.sanity.SanityManager.ASSERT(SanityManager.java:120)
	at org.apache.derby.impl.sql.compile.GroupByList.bindGroupByColumns(GroupByList.java:220)
	at org.apache.derby.impl.sql.compile.SelectNode.bindExpressions(SelectNode.java:629)
	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)

-- 
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