Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <1625300024.1203975771189.JavaMail.jira@brutus>
Date: Mon, 25 Feb 2008 13:42:51 -0800 (PST)
From: "Steve Ebersole (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Created: (DERBY-3464) NPE is seemingly simple query
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

NPE is seemingly simple query
-----------------------------

                 Key: DERBY-3464
                 URL: https://issues.apache.org/jira/browse/DERBY-3464
             Project: Derby
          Issue Type: Bug
    Affects Versions: 10.3.1.4
            Reporter: Steve Ebersole


Not sure if this is specifically a regression caused by DERBY-1624, however I noticed this as a regression to our tests in an attempt to verify the fixes for DERBY-1624 with release 10.3.1.4.

The offending query seems very simple and innocuous:

select count(customer0_.ID) as col_0_0_ from CUSTOMER_TABLE customer0_ group by customer0_.code having customer0_.code in ('GBR' , 'CHA')

leading the the following NPE:

2008-02-25 14:55:56,062 DEBUG [org.hibernate.util.JDBCExceptionReporter:69] could not execute query [select count(customer0_.ID) as col_0_0_ from CUSTOMER_TABLE customer0_ group by customer0_.code having customer0_.code in ('GBR' , 'CHA')]
java.sql.SQLException: The exception 'java.lang.NullPointerException' was thrown while evaluating an expression.
       at org.apache.derby.client.am.SQLExceptionFactory.getSQLException(Unknown Source)
       at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
       at org.apache.derby.client.am.PreparedStatement.executeQuery(Unknown Source)
       at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:235)
       at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
       at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
       at org.hibernate.loader.Loader.doQuery(Loader.java:674)
       at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
       at org.hibernate.loader.Loader.doList(Loader.java:2220)
       at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
       at org.hibernate.loader.Loader.list(Loader.java:2099)
       at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
       at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
       at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
       at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
       at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
       at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:65)
       at com.sun.ts.tests.ejb30.persistence.query.language.Client.test_groupByHaving(Client.java:5197)
Caused by: org.apache.derby.client.am.SqlException: The exception 'java.lang.NullPointerException' was thrown while evaluating an expression.
       at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source)
       at org.apache.derby.client.net.NetStatementReply.parseOpenQueryError(Unknown Source)
       at org.apache.derby.client.net.NetStatementReply.parseOPNQRYreply(Unknown Source)
       at org.apache.derby.client.net.NetStatementReply.readOpenQuery(Unknown Source)
       at org.apache.derby.client.net.StatementReply.readOpenQuery(Unknown Source)
       at org.apache.derby.client.net.NetStatement.readOpenQuery_(Unknown Source)
       at org.apache.derby.client.am.Statement.readOpenQuery(Unknown Source)
       at org.apache.derby.client.am.PreparedStatement.flowExecute(Unknown Source)
       at org.apache.derby.client.am.PreparedStatement.executeQueryX(Unknown Source)

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.