db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF subversion and git services (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-4403) Assert failure (sane) or NullPointerException (insane) when attempting to GROUP BY expression containing scalar subquery
Date Thu, 25 Sep 2014 20:17:34 GMT

    [ https://issues.apache.org/jira/browse/DERBY-4403?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14148239#comment-14148239
] 

ASF subversion and git services commented on DERBY-4403:
--------------------------------------------------------

Commit 1627645 from mikem@apache.org in branch 'code/branches/10.10'
[ https://svn.apache.org/r1627645 ]

DERBY-4403: Disallow subqueries in the GROUP BY list

backporting change #1575226 from trunk to 10.10 branch.  merged clean.

Queries that were grouped by subqueries used to fail with a
NullPointerException or an assert failure. Make them fail with a
proper syntax error instead.

> 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
>    Affects Versions: 10.2.1.6, 10.2.2.0, 10.3.1.4, 10.3.2.1, 10.3.3.0, 10.4.1.3, 10.4.2.0,
10.5.1.1, 10.5.2.0, 10.5.3.0, 10.6.1.0, 10.6.2.1, 10.7.1.1
>            Reporter: Dag H. Wanvik
>            Assignee: Mike Matrigali
>              Labels: derby_triage10_5_2
>             Fix For: 10.11.1.1
>
>         Attachments: d4403-1a.diff
>
>
> 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 was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message