db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-4388) NullPointerException in RIGHT JOIN with NOT BETWEEN
Date Fri, 25 Sep 2009 13:14:16 GMT

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

Knut Anders Hatlen commented on DERBY-4388:
-------------------------------------------

The stack trace is similar to DERBY-4342, but I'm logging it as a separate issue since this
query doesn't use VALUE or COALESCE. Also, DERBY-4342 throws NPE during Statement.execute(),
whereas the NPE in this issue is thrown during ResultSet.next().

Here's the relevant part of the stack trace:

java.lang.NullPointerException
	at org.apache.derby.impl.sql.execute.BaseActivation.getColumnFromRow(BaseActivation.java:1451)
	at org.apache.derby.exe.ac0b5b0099x0123xf14ex9cd1x000003c495d81.e4(Unknown Source)
	at org.apache.derby.impl.services.reflect.DirectCall.invoke(ReflectGeneratedClass.java:147)
	at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(ProjectRestrictResultSet.java:268)
	at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.getNextRow(BasicNoPutResultSetImpl.java:471)
	at org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(EmbedResultSet.java:427)
	at org.apache.derby.impl.jdbc.EmbedResultSet.next(EmbedResultSet.java:371)

> NullPointerException in RIGHT JOIN with NOT BETWEEN
> ---------------------------------------------------
>
>                 Key: DERBY-4388
>                 URL: https://issues.apache.org/jira/browse/DERBY-4388
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.0.2.1, 10.1.3.1, 10.2.2.0, 10.3.3.0, 10.4.2.0, 10.5.3.0, 10.6.0.0
>            Reporter: Knut Anders Hatlen
>
> ij> create table t1(x int);
> 0 rows inserted/updated/deleted
> ij> create table t2(x int);
> 0 rows inserted/updated/deleted
> ij> insert into t2 values (1);
> 1 row inserted/updated/deleted
> ij> select * from t1 right join t2 on t1.x = t2.x where t1.x not between 0 and 4;
> X          |X          
> -----------------------
> ERROR 38000: The exception 'java.lang.NullPointerException' was thrown while evaluating
an expression.
> ERROR XJ001: Java exception: ': java.lang.NullPointerException'.

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