db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "A B (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-3464) NPE is seemingly simple query
Date Mon, 25 Feb 2008 22:16:52 GMT

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

A B commented on DERBY-3464:
----------------------------

Hi Steve, thanks for the filing this issue.  The stack trace that you posted seems like it
may not be complete--esp. the underlying cause of the error does not appear in the trace (from
what I can tell).  Is there more to the trace that you have not posted?  Or if possible, do
you have a "derby.log" file which contains any errors in it?

Do you have a simple reproduction case for this issue?  I looked at the query above and was
able to generate an NPE against 10.3.1.4 with the following:

  connect 'testdb;create=true';
  create table t1 (i int, c char(3));
  insert into t1 values (1, 'ONE'), (2, 'TWO'), (3, 'CHA');
  select count(a.i) as col0_0_ from t1 a group by a.c having a.c in ('GBR', 'CHA');

If you run those simple statements do you see an NPE, and if so, does it look like the same
problem you are seeing?  Without having any further information, I'm wondering if you are
seeing DERBY-3253, which was also filed against 10.3.1.4 but has since been fixed in the 10.3
codeline.  At least, the above example query, which fails with 10.3.1.4, now runs without
error on the latest 10.3 branch.

Is it possible for you to build a set of jars from the 10.3 codeline and see if your query
still fails?

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


Mime
View raw message