Message:
The following issue has been deleted from JIRA.
---------------------------------------------------------------------
Here is an overview of the issue:
---------------------------------------------------------------------
Key: DERBY-16
Summary: NPE with USING clause of INNER/OUTER Join in simple Derby "select"
statement.
Type: Bug
Status: Unassigned
Priority: Minor
Project: Derby
Assignee:
Reporter: Ramandeep Kaur
Created: Wed, 29 Sep 2004 11:59 AM
Updated: Wed, 29 Sep 2004 11:59 AM
Description:
Opening this bug on behalf of Satheesh Bandaram.
------------------------------------------------------------
If the USING clause of an inner/outer join in a select
statement refers to a column that is not in both of the
specified tables, a Null Pointer Exception will be thrown when
building the query tree:
create table t1 (col1 int, col2 int);
create table t2 (col1 int, col2 int, col3 int);
// Following is fine:
select * from t1 inner join t2 using (col1);
// But the following will fail with NPE's:
select * from t1 inner join t2 using (oops);
ERROR XJ001: Java exception: ':
java.lang.NullPointerException'.
select * from t1 left outer join t2 using (col3);
ERROR XJ001: Java exception: ':
java.lang.NullPointerException'.
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
