[jira] Created: (DERBY-16) NPE with USING clause of INNER/OUTER Join in simple Derby "select" statement.

[de...@db.apache.org]

Message:

  A new issue has been created in JIRA.

---------------------------------------------------------------------
View the issue:
  http://issues.apache.org/jira/browse/DERBY-16

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
 Components: 
             SQL
   Versions:
             10.0.2.0

   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