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.
