[DERBY-13] Quoted names with embedded period mishandled in from list

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 10.0.2.0
• Fix Version/s: 10.1.1.0
• Component/s: SQL
• Assignee: Shreyas
• Reporter: Ramandeep Kaur
• Created: 29/Sep/04 18:51
• Updated: 08/Jul/06 10:06
• Resolved: 25/May/05 15:53

Description

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.