db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Satheesh Bandaram <sathe...@Sourcery.Org>
Subject Re: [jira] Assigned: (DERBY-13) Quoted names with embedded period mishandled in from list
Date Fri, 29 Apr 2005 06:33:53 GMT
U are correct... I think both of them seem to have been fixed, based on
the test case in the defect. I will close both of them, if everyone agrees.

Satheesh

Shreyas Kaushik wrote:

> I thought this was patched ??
>
> ~ Shreyas
>
> Jack Klebanoff (JIRA) wrote:
>
>>     [ http://issues.apache.org/jira/browse/DERBY-13?page=all ]
>>
>> Jack Klebanoff reassigned DERBY-13:
>> -----------------------------------
>>
>>    Assign To: Jack Klebanoff
>>
>>  
>>
>>> Quoted names with embedded period mishandled in from list
>>> ---------------------------------------------------------
>>>
>>>         Key: DERBY-13
>>>         URL: http://issues.apache.org/jira/browse/DERBY-13
>>>     Project: Derby
>>>        Type: Bug
>>>  Components: SQL
>>>    Versions: 10.0.2.0
>>>    Reporter: Ramandeep Kaur
>>>    Assignee: Jack Klebanoff
>>>    Priority: Minor
>>> Attachments: Derby-13.diff, Derby-13.patch, derbylang_report.txt
>>>
>>> Opening this bug on behalf of Satheesh Bandaram
>>> ---------------------------------------------------------
>>> The compiler mishandles quoted names with embedded periods when
>>> checking uniqueness of table names in the from list of a SELECT.
>>> 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 * from s1.t1, "S1.T1" where s1.t1.id = "S1.T1".id;
>>> Derby throws an error on the final SELECT statement:
>>> "ERROR 42X09: The table or alias name 'S1.T1' is used more than once
>>> in the FROM list". However s1.t1 and "S1.T1" are different tables.
>>>   
>>
>>
>>  
>>
>
>
>


Mime
View raw message