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