You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Shreyas Kaushik (JIRA)" <de...@db.apache.org> on 2005/01/03 05:52:29 UTC
[jira] Updated: (DERBY-13) Quoted names with embedded period mishandled in from list
[ http://issues.apache.org/jira/browse/DERBY-13?page=history ]
Shreyas Kaushik updated DERBY-13:
---------------------------------
Attachment: Derby-13.diff
Latest proposed patch for Derby-13
> 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
> 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.
--
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