[
https://issues.apache.org/jira/browse/DERBY-4403?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dag H. Wanvik updated DERBY-4403:
---------------------------------
Description:
The following is not caught by the error checking (or maybe it is supposed to
work?):
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)
was:
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)
> 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 (or maybe it is supposed to
> work?):
> 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.
