Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Development" <derby-dev@db.apache.org>
Message-ID: <630187231.1096483772196.JavaMail.apache@nagoya>
Date: Wed, 29 Sep 2004 11:49:32 -0700 (PDT)
From: derby-dev@db.apache.org
To: derby-dev@db.apache.org
Subject: [jira] Created: (DERBY-12) Quoted table names mishandled in select
 list expansion
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Message:

  A new issue has been created in JIRA.

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

Here is an overview of the issue:
---------------------------------------------------------------------
        Key: DERBY-12
    Summary: Quoted table names mishandled in select list expansion
       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:49 AM
    Updated: Wed, 29 Sep 2004 11:49 AM

Description:
Opening this bug on behalf of Satheesh Bandaram.

------------------------------------------------------
Select list expansion is incorrect when there is a quoted table 
name with an embedded period. Consider the following SQL:
  create table "S1.T1" (id int not null primary key, d1 int);
  create schema s1;
  create table s1.t1 (id int not null primary key, d2 int);
  select s1.t1.* from "S1.T1";
  select "S1.T1".* from s1.t1;
The select statements should both throw errors, because s1.t1 
and "S1.T1" are different tables. However Derby does not 
throw an error. However, the following SQL does throw an error, 
as it should.
  select "S1.T1".id from s1.t1;
  select s1.t1.id from "S1.T1"


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