db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From derby-...@db.apache.org
Subject [jira] Deleted: (DERBY-16) NPE with USING clause of INNER/OUTER Join in simple Derby "select" statement.
Date Fri, 01 Oct 2004 18:52:32 GMT
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


Mime
View raw message